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.
N1637DThigpen Don L II · Daniel Island, SCN1637YSmartt Kevin M · Springfield, TNN1638FKeith Frye · El Dorado, KSN1638QBeck Michael C · Farmington, CTN1639DVoigt Don M · Palmer, AKN1639KGordon Earl S · Custer, SDN1639NFrisby Craig · Rexburg, IDN163AAspegren Robert N · Vacaville, CAN163LASimeon Sound LLC · Aguilares, TXN163MCCriddle Michael J · Baker, FLN163MSTurberville Gregory R · Enterprise, ALN163WDavis Paul J Jr · Springdale, ARN1640DRoessler Larry J · Groveland, CAN1640NBurger Terry L Trustee · Salina, KSN1640YHall Justin J · Bellevue, NEN1641YBlake Justin · Watson, OKN1642FRomeo Kilo Golf LLC · Asheville, NCN1642NJstream Lc · Sheridan, WYN1643DMaselko Jacek · Juneau, AKN1643NAusk Steven G · Alice, NDN1643YLehman Patrick A · Phillips, WIN1644NNafziger Brian L Trustee · Cincinnati, OHN1644QBell Norman O · Hurlock, MDN1644YPopple Timothy J · Osseo, WIN1645VBode Theodore Wayne · Potosi, WIN1646DDraggin Tail Pilots · Prospect, PAN1646FBowman Nathaniel Ryan · Wildwood, MON1646QOwens Wilbur · Rancho Palos Verde, CAN1646VTodd Doug A · De Witt, IAN1646YMinion Air · John Day, ORN1647DExpress Aviation Management LLC · Dover, DEN1647FBlue Sky Rentals LLC · Hermiston, ORN1647NBeach Andrew N · Hawthorne, NVN1647YRudolphi William A · Doylestown, PAN1648FBahizi Pierre Ntwali · Sterling, VAN1648NPrice John DBA · Bennington, KSN1648QPlane Connection LLC · New Bern, NCN1648YSutton Aircraft Salvage LLC · Palmer, AKN1649FWalton Amber · Upper Sandusky, OHN1649VLaforce Larry B · Big Sandy, TXN164PCSkye Equipment LLC · Asheboro, NCN164TCChurchill Robert D Jr · Wasilla, AKN1650F4 Aces Air LLC · Brandon, MSN1650NSale Reported · La Plata, NMSale reportedN1650PChilcote Gary D · Britt, MNN1650YAirria Holdings LLC · BerlinN1651DWeber Donald B · Chugiak, AKN1651FMurphey Julian R · Knoxville, TNN1651VKistler Harvey S · Colby, KSN1652DFischer Andrew G · Hopkins, MN
Back to AD 94-05-05 R1