AD 79-10-14 R1
Registered aircraft · 56,582
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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.
N91HAHoneybee Air LLC · Newark, NJN91LPDreisewerd William · Winfield, MON91LVWoodfield Terry J · Pearland, TXN91MWSub C Air LLC · Spring, TXN91PAHigh Wing Air LLC · Arnold, MON91PCChay Dan B · Kenai, AKN91PFSkyline Solutions Inc · Deland, FLN91PHJulien John · Houghton, MIN91PMRunrich LLC · Newport News, VAN91QSFly Diablo Inc · North Wales, PAN91RBlack Pilots Of America Detroit Chapter · Detroit, MIN91WAStevens James L · Carrollton, GAN92000Clift Robert E · Anchorage, AKN92004Oklahoma State University · Stillwater, OKN92006Troughton Jill A · Spring Hill, FLN92009Will Dennis L · Clyde, MIN9200BChristiansen Aviation LLC · Wilmington, DEN9200GNoya Charles J · Albuquerque, NMN9200UCherry Hill Aviation Inc · Freetown, INN9200XCochreham Bryce O · Seibert, CON92013Burns Dale E · Kamiah, IDN92014Shotwell Land Management Co LLC · Jackson, MSN92016Campbell Kevin T · Gretna, NEFirst renewal noticeN92018Mercenary Medical LLC · St George, UTN9201HSparkwizard LLC · Greenville, RIN92020Domaille Dennis C · Mammoth Lakes, CAN92021Pisiak Sonny S · Queen Creek, AZN92026Haltom Frances F · Alva, OKN9202AWilson Alan Trustee · Waukesha, WIN9202TLander David W · Gilroy, CAN9202UOklahoma State University · Stillwater, OKN9202XNohrenberg Larry R · Jamestown, NDN92035Ford Daniel T · Warsaw, INN92039Newwing LLC · Freeland, WAN9203CSamuel James F · Port Byron, NYN9203GStohr Jeffry M · Aberdeen, SDN9203TMartinson Douglas E · Nome, AKN9203UAlaskan Mariners Inc · Homer, AKN9203XPeru Projects Inc · Lincoln, NEN92049Put Ronald · Alameda, CAN9204AConrad William A · Kaukauna, WIN9204BMcelwain Floyd · Saint Joseph, MON9204GSchwend Brian · Forsyth, MTN9204HTongass Air LLC · Ketchikan, AKN9204TDoner Daniel D · Highlands Ranch, CON92050Tysky Air LLC · Arvada, CON92051Yardy Paul J · Caledon OntarioN92054Waterheat Inc · Anchorage, AKN92059Scott Donald · Bend, ORN9205RRegistration Pending · Manito, ILRegistration pending
Back to AD 79-10-14 R1