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.
N8159XClydesdale Aviation LLC · Goodwater, ALN815BStrong James R · Williamsville, NYN815VKKoenigsberg Douglas D · Baltimore, MDN81600Rybicki Joseph · Hayesville, NCN81607Price Donald N · Houston, TXN8160FRydell Leonard A · Newberg, ORN8160LGarcia Geoff M · Tecumseh, OKN8160TWhite Orion H · Moses Lake, WAN81617Ose Leroy B · Thief River Falls, MNN81618Mycroft Fred A · Sierra Madre, CAN8161ABuck Robert O · Waterbury Center, VTFirst renewal noticeN8161BFehrenbach Chris A · Evansville, INN8161LNexten Flight Academy · Riverside, CAN8161UKaiser James · Fond Du Lac, WIN8162BMountain Air LLC · Carabaset Vly, MEN8162FWeishuhn Charlie D · La Grange, TXN8162MMeggers Darin R · Baker, MTN8162ULunger Eric K · Mifflintown, PAN8163ABarker Donna J · Connersville, INN8163BAerosim Inc · Stockton, CAN8163UCave Mark A · Snyder, TXN81641Christensen Grey · Saint George, UTN8164ASpurlock Daniel C · Harrogate, TNN8164LBowtie Properties LLC · Dadeville, ALN8164TKent Larry A · Gaylord, MIN8165BEvans David M · Superior, WIN8165FMoat William A · Braselton, GAN8165SDickey Jenni M · Willow, AKN8165TEubanks James D · Horn Lake, MSN8165UFena Daniel J · Side Lake, MNN81667Ellingson Leslie B · Harwood, NDN8166FHassan Nabil Ibrahim · Victorville, CAN8166LBlackerby Dennis N · Wilsonville, ALN8166TPakan John S Trustee · Wasilla, AKN8166XWells Clinton M · Cincinnati, IAN81670Buckshot Aviation LLC · Greenville, MSN8167LVan Pelt Wilbur F · Seattle, WAN8167SReid Bryce · Oklahoma City, OKN8167TSouthern Sky LLC · Henderson, NVN8167XAbel Jacob · Bland, MON81686Frost David R · Utopia, TXN8168BJacobs Dennis A · Rochert, MNN8168USale Reported · Three Rivers, MISale reportedN8169AVetterli Gary R · Monroe, WIN8169FRegistration Pending · Parker, KSRegistration pendingN8169LApex Flight Training LLC · Houma, LAN8169TPerry Edward Glen Trustee · Ozark, ARN8169UThorn Mark · Vashon, WAN8169XHenderson George · Fresno, CAN8170BMelechin David H · Los Angeles, CA
Back to AD 94-05-05 R1