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.
N1499YHockenberry Randall L · Cape Coral, FLN149ACOsceola Aerosport LLC · Osceola, WIN149JASummers Dennis L · Perry, OKN149MRRaper Miles M · Doral, FLN149NGerner Carl T · Cadyville, NYN14AUBazzo Richard J · Broadview Heights, OHN14CHClark Spencer L · Newton, KSN14CPWheels Floats Skids And Skis LLC · Brooklyn, MIN14CWThornwall Gregory C · Boonsboro, MDN14GLMc Flying Club Inc · Lewistown, PAN14HBMike Rinker Aircraft LLC · Union City, TNN14HKTrolinger John D · Kerrville, TXN14JEaa Aviation Foundation Inc · Oshkosh, WIN14JFMarzich Frank M · Rockford, ILN14KMRiver City Aero Club Inc · Columbus, GAN14KVKaitis Keye V · Joliet, ILN14KXHickman Tony · Eastman, GAN14LBPierce Nancy E · Whitesboro, TXN14LSJung Jason H · Randolph, WIN14MESantacroce Anthony M · Cedar Rapids, IAN14SWTriple R Ministries Inc · Crestview, FLN14TXMcbride Robert W Jr · Mineola, TXN14WAWright Brandon C · Cave City, KYN14XPVogler Dennis L · Lander, WYN150Beam David · Sabina, OHN1500QShoaff Mark · Lehigh, FLN1500TAguilar Honorio · Anna, TXN1501NWatson David P · Denison, TXN1501YStreeter Christopher D · Vinita, OKN1503EVan Tine Brad R · Billings, MTN1505BKulle William T · Springfield, MAN1505QN1505q LLC · Brunswick, GAN1506Westrum Durl Troy · Norwalk, IAN15060Palm View Aircraft Corp · Santa Rosa Beach, FLN1506QDonald A D · Plano, TXN1506YVaughn Jeffery Page · Shenandoah, VAN1507QSafety In Motion Flight Center Inc · Puyallup, WAN1508HClipp John W · Fayetteville, GAN1508UKnefley J Michael · Ulysses, PAN1509QBeavers David · Strasburg, CON150ARBerry Norman R · Knoxville, TNN150AWJohnson Seth · Gulfport, MSN150BNHernandez Ralph · San Antonio, TXN150BPRiffle Christopher Thomas · Charleston, SCN150BRList Bradley C J · Eastover, NCFirst renewal noticeN150BSSpry Brad T · Walker, MNN150BWRollinson Mark H · South CanterburyN150CPrincess North Inc · Lindstrom, MNN150CEBrazier Glen A · Greenbush, MNN150CGRomano Brian P · Terryville, CT
Back to AD 94-05-05 R1