AD 90-04-06 R1
Registered aircraft · 68,377
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N5918QNorheim Bjoern T · Phoenix, AZN5918VKnutson Sever B · Hutchinson, MNN5918WLathrop Patrick W · Kent, WAN5919HKidder Robin G · Burlington, KYN5919LMckee Marty R · Lenoir City, TNN5919QBig Sky Adventures LLC · Nicholasville, KYN5919UDewater Mark · Mulberry, ARN591JPReed Douglas W · Kingwood, TXN591PHKingdom Air Corps · Sutton, AKN591RVSims David L · Mc Alpin, FLN591TXSchechter Andrew M · Goshen, OHN5920DBates Matthew T · Springfield, VAN5920HZakrzewski Patrick J · Waterford, WIN5920LSharratt Mark M · Ogilvie, MNN5920QKellogg Annabelle S · Cumming, GAN5920WSynergy Aviation LLC · Greer, SCN5921HHoehne Michael G · Vienna, VAN5921PFiscus Ryan K · Burleson, TXN5921WStearns Edwin Ben Jr · Eloy, AZN5922EAerial Scouting Solutions LLC · Sioux Center, IAN5922FNeel Aviation LLC · Lakeland, FLN5922HGifford Gary W · Lighthouse Point, FLN5922LJokerst Kenneth · Saint Louis, MON5922PWiseman Transport LLC · Henderson, TXN5922UPagan Jose A · Kokomo, INN5922ZBellamy John Mark · Freeville, NYN59231Widewings LLC · Alexandria, VAN5923LKane Christopher M · Sacred Heart, MNN5923WPremier Pilots LLC · Herriman, UTN5924FN5924f LLC · Cocoa, FLN5924QWright Andrew · Sacramento, CAN5924UOrganization Of Black Aerospace Professionals Inc · Westchester, ILN5924WPribbenow Dennis A · Payson, AZN59262Tabbert William Stanley · Diamondhead, MSN5926BAddington Ralph P · Orlando, FLN5926DToste Greg · Newcastle, CAN5926FRegistered aircraftN5926UIron Flyer Of Cuzamil LLC · Lewes, DEN5926WLeonard Jeffrey A · Bakersfield, CAN5927HParley Michael D · Carmel, CAN5927LTri State Airmotive LLC · Berryville, ARN5927PSchlup John R · Booneville, ARN5927WKochling Christopher · Houston, TXN5928EGace Flying Club Inc · Ronkonkoma, NYN5928JParsons Royson A · Atascadero, CAN5928QSchmidt Tyren A · Albertville, MNN5928WRegistered aircraftN-number assigned, not yet registeredN5929WEdwards Allan · Leesburg, VAN5929ZBrown Dave M · Crescent City, CAN592CJAims Community College · Greeley, CO
Back to AD 90-04-06 R1