Sept 2021 : NOTE - all required code for this process is found at :
simply copy and place into your preferred SQL tool
...
OPTIONAL - if we have a tail mark, and airframe data, BUT no aircraft serial number retrieve it from the FAA register, or null out that tail mark. Serial numbers are important to help us associate the reports to previously Canadian-registered aircraft by establishing a possible Aircraft_id. (unique numeric identifier for a specific aircraft, provided by CCARCS)
...