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.
N6005UHaney William R · Pontotoc, MSN6005ZMarstall Nancy T · Asheville, NCN6006DLedda Francesco · Canton, TXN6006WGreen William A · Memphis, TNN60079Bacich Peter C · Brick, NJN6007FMobley Barbara Alice · Kathleen, GAN6007QRegistration Pending · Tampa, FLRegistration pendingN6007TMinton Richard D · Longville, LAN6007USteele Tucker L · The Colony, TXFirst renewal noticeN6007WMoore Merritt · Mcarthur, CAN6007YAudubon Air Of Louisiana LLC · Bossier City, LAN60083Kocik William J Jr · Shepherdstown, WVN60086Echo Bravo LLC · Helena, MTN6008DChristopher D Bock · Fishers, INN6008HSwartz Selden H Jr · Jacksonville, ORN6008KShore Stephen · Longview, TXN6008LGawlik Leslie W · Reisterstown, MDN6008URasmussen John E · Seffner, FLN6008XMangum Gary W · Centreville, VAN60097Ratliff Frank O · Palestine, TXN6009ACampbell Bryan P · Naples, FLN6009DKirkendall James A · N Richland Hills, TXN6009QDelone Charles P · Sarasota, FLN6009WLowman Jeffrey L · Clarksburg, WVN600AMid Atlantic Air Museum · Reading, PAN600AABrauer Jason R · Winnebago, ILN600APToombs Todd J · Peyton, CON600AVMountain Top Aviation Inc · Ebensburg, PAN600BHBeaupre Harry R · Fallon, NVN600CWWinn Kathy J · Spring, TXN600EZMoore Glenn C · Elkhart Lake, WIN600FSHome Free Aviation LLC · New Port Richey, FLN600GGNlh Aviation LLC · College Station, TXN600HHFleming Mike R · Troy, MON600HJRavotti Air LLC · Leechburg, PAN600KKFeielin Kenneth M · Paris, OHN600PCRudd Wayne · Basalt, CON600PFEastern Aviation Corp · Whitestone, NYN600RBGates Steven · Midlothian, TXN600SEMcgavock Randall J · Camp Verde, AZN600TLLbaviation LLC · Wheatland, WYN600VVMindy Limited LLC · Muscatine, IAN600WPort Of Tillamook Bay · Tillamook, ORN600WTBaldauf Mark H · Nova, OHN6010James Douglas M Trustee · Scottsdale, AZN60104Theo-N60104 LLC · Wilmington, DEN60106Lutzko Timothy R · Ocean View, DEN6010CBig Bend Community College · Moses Lake, WAN6010DTrenkamp John F · Oskaloosa, IAN6010LBergstrom Robert L · Amelia, VA
Back to AD 90-04-06 R1