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.
N4301ZRubbert Logan · Reynolds, NDN43020Blue Skies Flying Services Inc · Lake In The Hills, ILN43023Drs Sandra M Krokos And Thomas P Kislan Pc · Hazle Township, PAN4302MNiver Mark A · Wasilla, AKN4302TRiley Thomas J · West Grove, PAN4302XJin Jin Aviation LLC · Anchorage, AKN4302YLundstedt Gregory · Duncan, SCN4302ZSportsmans Air Service Inc · Anchorage, AKN43034A S Flight Academy LLC · Lantana, FLN43037Miloud Chadd K · Fort Worth, TXN4303ANelund Craig David · Edwardsburg, MIN4303JGroff Paul F · San Leandro, CAN4303MLight John W · Anchorage, AKN4303QHobart Aviation Inc · Akron, OHN4303TReem Steven J · Cogan Station, PAN43044Will Eric S · Waseca, MNN4304AGuslick Michael M · Milwaukee, WIN4304GStamper Peter G · Valparaiso, INN4304HZimmerman Bradley S · Greentop, MON4304JStetser Nicholas R · Redding, CAN4304QProfessional Aviation Inc · Dalton, GAN4304TButler Jeffrey C · Abilene, TXN43050Essex Air LLC · Franklin Lakes, NJN43051Luitjens Jacob J · Cascade Locks, ORN43055Plain Plane Partners LLC · Wilmington, DEN43056Lucier Laura M · Houston, TXN43057Bogaard Family Partnership · Park Rapids, MNN4305JThompson Judith P · Loleta, CAN4305MBierlein Bruce M · Reese, MIN4305XKrzykwa Thomas F · Newark, DEN4305ZMahoney Edmund Mont · Anchorage, AKN43060Jefferson City Aviation Inc · Jefferson City, MON43062Burgraff William B · Palatine, ILN43065Hancock Glenn H · Jackson, GAN4306BPv Rec Flight LLC · West Chester, PAN4306DNightingale Matthew M · Rancho Cucamonga, CAN4306TKaszynski John · Porter Ranch, CAN4306YRegistration Pending · Phoenix, AZRegistration pendingN4307AKennedy Gary R · Sanger, TXN4307MCannon Mark C · Shelbyville, TNN4307PGibson Kim · Ocean Springs, MSN4307RMcmath Don · Collinsville, OKN4307XHorizon Aviation LLC · Brooks, GAN4307ZDenons Flying Service Inc · Rolling Fork, MSN43080Red Baron Rentals LLC · Jacksonville, FLN43084Bushby Harvey M · Minooka, ILN43088Registration Pending · Babson Park, FLRegistration pendingN4308JBuresh George W · Milwaukee, WIN4308KPetsche Renee A · Round Rock, TXN4308PPilots Flying School LLC · Englishtown, NJ
Back to AD 90-04-06 R1