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.
...
If the aircraft is amateur built, ignore.
If its a Canadian Type Certficiate Holder (TCH airframe, its ) (aka Canadian built), acquiring the airframe info is more important.
Alternately, if the registry page shows an aircraft that left the US before the SDR occurence occurrence date, its a good idea to null out the tail mark
...