AD 94-05-05 R1
Registered aircraft · 26,231
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N2681NPayne Michael · Sequim, WAN2681UOsterhaus Jonathan · Petersburg, TNN26820J 3 Cub Corp · Miami, FLN2682JCooper David J · Gravette, ARN2682LCommonwealth Technical Services Inc · Powhatan, VAN2682UCseh Sandor · New Brunswick, NJN2682VVogen Jeffrey L · Newark, ILN26838Gross Scott A · Williamsburg, VAN2683DRasmussen Merlin P · Enumclaw, WAN2683NBennett William Nicholas · Donalds, SCN2684DSaltsgaver Robert E III · Maryville, TNN2684NAir & Sea Leasing Inc · Cahokia, ILN2684UAnderson Robert David · Brighton, MIN2685NEvans Sheila Margaret · Griffin, GAN2686JMiller Mackenzie · Johnsonburg, PAN2686USzalay Jamey R · Princeton, NJN2686VMoore Steven L · Glasgow, KYN2687JBridgwater David A · Mcallen, TXN2688EGawthrop Keirn R · Westfield, INN2688LParsons Joshua A · Hollis Center, MEN2688UGould Martin W · Alba, TXN2690DN6112t LLC · Caldwell, IDN2691UHess Garrett J · Fullerton, CAN2692DSutton Aircraft Salvage LLC · Palmer, AKN2692JDowning Eric D · Saint Charles, MON2692KBoland John M · Oceanport, NJN2692NSinnott-Simonis Lyle · Girdwood, AKN2693DBarron Dillon L · Perry, MON2693UBolden Myles · Plumas Lake, CAN2694DDagenhart Jason F · Anchor Point, AKN2694KWinkelman Walter T · Sullivan, WIN2694NTodd Gregg A · Moneta, VAN2695DRoss David · Chestertown, MDN2695LHindberg Jacob W · Fisher, MNN2696Schmidt Gip E · Leavenworth, KSN2696DWotring Samuel Daniel II · Mount Pleasant, TXN2696LPark Rapids Avionics Inc · Park Rapids, MNN2696VHall Cody G · Coeur D Alene, IDN2697DSalinas Julius T · Esko, MNN2697JSalem Aero Club Inc · Bridgeton, NJN2697NOrsak Chris L · Seymour, TXN2697UOharra Robert J · Buckley, WAN2698DGumley Andrew · Wasilla, AKN2698JKruglov Stephan · Mundelein, ILN26995Mckay Franklin D · Rockport, TXN2699HForsyth Technical Community College · Winston Salem, NCN2699L98x LLC · Caddo Mills, TXN2699UHogue Richard L · Dos Palos, CAN269BWRidge Roger G · Port Clinton, OHN269RDHumphries Aviation LLC · Maysville, KY
Back to AD 94-05-05 R1