AD 94-05-05 R1
Registered aircraft · 26,230
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.
N92186Museum Of Mountain Flying Inc · Missoula, MTN9218BWilliams Leslie D · Oneida, TNN9218UHolzgrove Thomas H · Pipestone, MNN92195Lindsey Gavin K · Burlington Flats, NYN9219AWatkins Donley E · Cheyenne, WYN9219UCarlson Farms Inc · Plentywood, MTN9219XRud Jay C · Newark, ILN921MAMoxie Vincent B · Sarver, PAN921VCole William H · Garner, NCN9220ABrown Douglas C · Daytona Beach, FLN92224Wallis Aircraft Inc · Clifford Township, PAN92226Rankin Kevin · Maryville, MON92229Cate Lyndle K Trustee · Medford, ORN9222AMccully Kevin W · Payson, AZN9222BGilreath Steven M · Anderson, SCN9222UJdl Services LLC · Centreville, MDN92230Warehime Wayne C Trustee · Senecaville, OHN9223ABrossard Adam · Olalla, WAN9224AGauman Dylon M · Wasilla, AKN9225APeterson Scott W · Garfield, KSN9225B25/25 LLC · Pinedale, WYN9225UPrecise Flight LLC · Waukesha, WIN9226ASchmidt James W · Dousman, WIN9226UMcnamara Gavin E W · Rancho Cucamonga, CAN92273Gates Steven S · Midlothian, TXN92289Felts Jeffrey R · Tillar, ARN9229APotter Gary W · Abilene, TXN922CMPapenthien Michael R · Waterloo, IAN922SWGhulam A Jafferi · South Miami, FLN92317Mizer James D · Hailey, IDFirst renewal noticeN9231UCreek William M · Emeryville, CAN92320Yarbrough Donald D · Aguila, AZN9232UWalnut Grove Properties LLC · Eureka, ILN9233BHiggins Kenneth James II · Dawsonville, GAN9233UThorstad Vaughn A · Fargo, NDN9235BOn A Lark LLC · Post Falls, IDN9237BMenard Keith L · Bellevue, TXN9238ABryan Kirk J · Big Timber, MTN92394Young Jeremy J · Hood River, ORN923BRWings Of Grace Ministries Inc · Melbourne, FLN923ZCyr Gregory A · Augusta, MEN92400Gonzales Kerry M · Enterprise, ALN92418Baier Dale · Colleyville, TXN92420Simmons Ralph R · Sadler, TXN9242ARobinson William A · Franklin, TNN9242ULiggett Garrett C · Eminence, MON92430Lange James · Brookfield, WIN9243ACollins Carvel Key · Uvalde, TXFirst renewal noticeN92442K&M Flyers LLC · Lewes, DEN9244AKauffman Forrest J · Coolidge, AZ
Back to AD 94-05-05 R1