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.
N731MRMerced County Mosquito Abatement District · Merced, CAN731PHTorkelson Charles A · San Antonio, TXN731PMAir Ag Inc · Tarboro, NCN731QCTim Whitfield Aviation · Fairfield, NCN731RLTrevor Liou · Brush Prairie, WAN731TBoard Of Trustees Of Southern Illinois University · Murphysboro, ILN731TBEastern Flying Service Inc · Middletown, DEN731TQSnider Scott E DBA · Turner, MTN731TSSantana Hector Rafael · Crystal River, FLN731TXRegistration Pending · Harrah, OKRegistration pendingN731UFPeniston Bob · Chillicothe, MON731VXGoff Bayou LLC · Shelby, MSN731VYCarr Scott A · Allen, NEN731WVKutschera Theodore C DBA · Callicoon, NYN731XGPeniston Charles R · Chillicothe, MON731XNPeniston Bob · Chillicothe, MON731YRAbernathy Larry D · Tipton, OKN73200Burns Kurtis L · Clyde Park, MTN73209Goldberg Peter S · Eagle River, AKN7320FRick Aviation Inc · Newport News, VAN7320GDelaware Aircraft Trust LLC Trustee · New Castle, DEN7320HAlaska Trophy Safaris Inc · Chugiak, AKN7320JNextgen Flight Academy Inc · Riverside, CAN7320TRegistration Pending · Shepherdsville, KYRegistration pendingN7320UYr-Aircraft Leasing LLC · Bethel, AKN73211Tc International Inc · Whittier, CAN73213Haig Gene · Palatine, ILN73217Ryan Air Inc · Anchorage, AKN7321GTriad Aviation Academy LLC · Greensboro, NCN7321MWood Robert B · Woods Cross, UTN7321NMalad Aviation LLC · Bliss, IDN7321SRauber James S · Lincoln, MTN7321TDelaney Glen W · Canyon, TXN7322ABaas Keith L · Alto, MIN7322GHolt Thomas H · Griffin, GAN7322MDeasy Brendan W · Berlin, NHN7322SSueson Flying Inc · Wilmington, DEN7322TSchaub John P · Darlington, INN7322XHogan Robert Leroy · Depew, OKN7323GSpiker Jeffrey A · Granville, OHN7323QYelderman Neil O · Guy, TXN7323XBrandt Goetz K · San Jose, CAN7324MBehrends Brandon R · Duluth, MNN7324NLeonhardt Bonnie · Riverton, WYN73250Skaya Aircraft LLC · Buford, GAN73254Swensen Jason D · Norfolk, NEN7325AJaeger Howard E · Claremore, OKN7325CPollard Seka A · Huntington, WVN7325TCierra Rose Morgan Shawe · Seattle, WAN73262Air Spacers Inc · Santa Monica, CA
Back to AD 79-10-14 R1