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.
N8370JBrown David A · Lumberton, TXN8370MLandry Paul G · Fallon, NVN8370QState Of Alaska Dept Of Fish And Game · Palmer, AKN8370SBerti Robert Cord · Wilton, CAN8370TGreen Benjamin · Oro Valley, AZN8370USimonsen Joshua A · White Salmon, WAN8371MNosewheels Navy LLC · Rochester Hills, MIN8371SLamm Matthew S · Morristown, NJN8372AHegge Sharon D · Marysville, WAN8372JPaquette Michael J · Greene, NYN8372LRed Sky Aviation LLC · Livermore, CAN8372MCollins Delbert Ray · Talihina, OKN8372XN8372x LLC · Chelan, WAN8373AMcginn Robert W · Marion, NCN8373BSkyview Aviation LLC · Tracy, CAN8373GColumbia Asset Trust Corp Trustee · Wichita, KSN8373LFaulkner Jeannine P · Bethel, AKFirst renewal noticeN8373MBond Hiram E · Pls Vrds Est, CAN8373QBassham Clark · Anchorage, AKN8373SBart Bruno Paul · Monterey, CAN8373UKramer Mark S · Branchburg, NJN8373XPenrose Cory · Reno, NVN8374AChilds Donald R · Wasilla, AKN8374BGardner Gilbert W · Hartford, KSN8374LGeneral Aviation LLC · Henderson, NVN8374Q8374q LLC · Gig Harbor, WAN8375BRutan James · Palmer, AKN8375JAtlanta Aircraft Consultants LLC · Rex, GAN8375QSt George Edward · Henderson, NVN8375SAero Glide Corporation · Sedona, AZN8375TChristiansen Aviation LLC · Wilmington, DEN8375XDugan Ronald C · Rogers City, MIN8376BBilton Aircraft Management Inc · Umatilla, FLN8376GDakota Aircare Inc · Wagner, SDN8376MPhillips Lester L · Pahrump, NVN8376XDraeger Joshua D · De Leon, TXN8377BLittle Eagle Valley LLC · Dover, DEN8377HRhodes Kent A · Seattle, WAN8377MBoyd Edward Lee · Apison, TNN8377QAafedt Aaron B · Belgrade, MTN8378LLett Brian R · Eden Prairie, MNN8378MKuklo Robert M · Livermore, CAN8378QAeroworks Of Alaska LLC · Chugiak, AKN8378SGulley Ronald L · Boise, IDN8378UMartin Garland L · Zephyrhills, FLN8378ZKling Jeffrey V · Friendswood, TXN8379ADedominicis Anthony J · Oneonta, NYN8379JLin Air LLC · Oviedo, FLN8379LSan Fernando Aviation LLC · Van Nuys, CAN8379QLaumeyer Richard H · Wilson, WY
Back to AD 79-10-14 R1