AD 94-05-05 R1
Registered aircraft · 26,232
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.
N5605GMartinez Ivan A · Oro Valley, AZN5605RCostello John M · Wichita, KSN5606CCollins Florence D Miki · Lake Minchumina, AKFirst renewal noticeN5606FCavu Aviation LLC · Cedar Park, TXN5606GPinho Michel A · Santa Barbara, CAN5607AGilbirds William M · Kansas City, MON5608CGustafson Kurt E · Winchester, VAN5608EMyers Alex B · Oshkosh, WIN5609FGregory Vernon L · Swansea, SCN5609TWestfall Gage T · Marietta, OKN560MAKrauss Solutions LLC · Debary, FLN560SFAllen Adam W · Sutter Creek, CAN5610ANielson Douglas W · East Troy, WIN5610EBenelli Matthew T · Sandwich, MAN5610GInternational Air Services Inc Trustee · Carson City, NVN5611ALewis Christopher Michael · Troy, OHN5611RNordell Louis W · Watervliet, MIN5611TAnderson King David · Lenexa, KSN5612FWilliams Eddie R · Golden Valley, AZN5612GNelson Daniel J · Ladd, ILN5612MNelson Harold G · Pendleton, ORN5612RLoerke James S · John Day, ORN5612TLord David A · Mackay, IDN5613CHolliday Mark E · Lake Elmo, MNN5613ESuter Laurance · Livermore, CAN5613MStuart John R · Taylorsville, KYN5613TJones Curtis DBA · Jacksonville, NCN5614FKatzakian Trevor T · Lodi, CAN5614MBachman Ernest J · New Brighton, PAN5614TBarnes Roger F · Oronoco, MNN5615EWeaver John M · Senoia, GAFirst renewal noticeN5615FBalderston Daniel · Garden Grove, CAN5615RWittrock Thomas L · Wiota, IAN5616ABingham Boyce James · Juneau, AKN5616FHoak Edward C · Duncannon, PAN5617FNiemi Fred H · Lake City, MIN5618FClanton Thomas I · Maryville, TNN5618MMolek Eugene · Warren, OHN5618RMiller Richard L · Tipp City, OHFirst renewal noticeN5618THildebrand Mark D · Manawa, WIN5619CDunaire LLC · Mechanicsburg, PAN5619MHardy Lee E · Dundee, NYN561GSSandberg David C · Auke Bay, AKN5620ASmith Steven R · Nome, AKN5620FLight Sport LLC · Payson, AZN5620RVandeven Avery D · Saint Joseph, LAN5621AMedic Choppers LLC · Springdale, ARN5621CDawkins Terry · Defuniak Springs, FLN5621FBullock Robert · Mount Airy, MDN5621RSale Reported · Genoa, WVSale reported, canceled
Back to AD 94-05-05 R1