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.
N18534Rupert Dinah J · New Plymouth, OHFirst renewal noticeN18537Kirsch Richard D · Lisbon, NDN1853DBent James L Jr DBA · Palatine Bridge, NYN1853NProst Gary E · Stockton, CAN1853VMid Michigan Aviation LLC · Owosso, MIN1853YHurd Roger Mark · Bow, WAN18540Fisher Tracey R · Glenwood, IAN18546O'Sita Tade · Burnsville, MNFirst renewal noticeN1854CBurns Linda J · Vernon, MIN1854YMikowski Charles A · Sparta, MIN18552Malecha James L Trustee · Wilmot, NHN18554Lavelle Jonathan A · Berrien Springs, MIN18558Gunderson Robert B · League City, TXN1855CRowe James D · Nome, AKN1856Eakle Randy C · Mapleton, ILN18565Hughes Danny R · Hickory, NCN18567Barros Da Silva Norton · Tyler, TXN18568Green Tom H · Vega, TXN18569Doyle Harley M · O Brien, FLN1856CJones Mark S · Tampa, FLN18572Stofka Joseph M · Erie, MIN18574Reed Philip D · Millsboro, DEN18578Nauerth John III · Lakefield, MNN18579Beck Roger M Trustee · Goode, VAN1857CSchlender Michael E · Clintonville, WIN1857YKnudson Wayne L · Larimore, NDN18580Kirk Bryan · Las Vegas, NVN18582Voigts Bruce M · Clarion, IAN18583Niles Donald W · Wadena, MNN18584Murphey Julian Ryan · Knoxville, TNN18586Flyit LLC · Camas, WAN18587Payne Frederick B · Fayetteville, GAN1858KGunder Craig R · Red Lion, PAN1858NWeeks Addison W · Covina, CAN1858YBlaich George F IV · Poplar Bluff, MON18590Williams Michael · Williston, FLN18594Robinson Ronald W · Saint Joseph, MIN18596Baxter Wiley · Glennville, GAN18597Kiser Joshua Alan · Dry Ridge, KYN18598Gudgel Aviation · Lemoore, CAN1859BKruse Adam L · Weiser, IDN1859VKorson James J · Yorkville, ILN185WTPenley Robert G · Corinth, TXN18609Underwood Gary · Lewisville, TXN1860KDarby Jake B · Manila, ARN1860VNuckles Charles A Jr · Suffolk, VAN1860YPeterson Jerad · Oshkosh, NEN18612Missoula Fliers LLC · Milltown, MTN18618Hammons Bryan S · Stephenville, TXN1861CSierra Flying Club LLC · Woodinville, WA
Back to AD 94-05-05 R1