Sept 2021 : NOTE - all required code for this process is found at :
simply copy and place into your preferred SQL tool
...
OPTIONAL - if we do NOT have an AIRCRAFT MANUFACTURER/MODEL, but we DO have a tail mark, go to the FAA registry website and acquire the airframe info.
...