OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,578

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.

N1809ZCleared For Departure LLC · Kennewick, WABuilt 1962 · S/N 205-0009N180AHigginbottom Nathan · Cave City, ARBuilt 1954 · S/N 31090N180AAButler Tracey D · Buckley, WABuilt 1973 · S/N 18052399N180ABFoster Bradley J · Wichita, KSBuilt 1953 · S/N 30210N180AFRegistered aircraftBuilt 1957 · S/N 32809N180AGAg Leasing LLC · Wilmington, DES/N 18052187N180AHSwiss Arctic Flyers Inc · Lewes, DEBuilt 1981 · S/N 18053192N180AKBecker Kurt G · Dexter, NMBuilt 1955 · S/N 31349N180ANJones Marvin B · Farmerville, LABuilt 1957 · S/N 50008N180APAir Plains Services Corp · Wellington, KSBuilt 1965 · S/N 18051472N180AQTracy Michael R · Santee, CABuilt 1967 · S/N 18051848N180AXNoyes Abigail · North Pole, AKBuilt 1969 · S/N 18051910N180AYPerkins Paul Fortaine · Anchorage, AKS/N 50052N180AZMohr Elizabeth G · Brandon, MSBuilt 1974 · S/N 18052433N180BADavis Robert D · Camas, WAS/N 18052419N180BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18053103N180BDSanderson Bryan D · Emmett, IDBuilt 1954 · S/N 30848N180BFComunale Anthony S · Roxbury, CTBuilt 1973 · S/N 18052402N180BGCmw Aircraft LLC · Hailey, IDS/N 31372N180BHMorris Christopher H · Valparaiso, INS/N 18052132N180BKKrissman Ryan · Gallup, NMBuilt 1970 · S/N 18052120N180BRDainas Barry · Port Orange, FLBuilt 1955 · S/N 31386N180BSSerie Dennis P · Chugiak, AKBuilt 1959 · S/N 624N180BTAerobug LLC · League City, TXBuilt 1967 · S/N 18051815N180CBrown Hector M · Glenwood Springs, COBuilt 1956 · S/N 32312N180CBSmith Dennis A Trustee · Salem, ORBuilt 1955 · S/N 31489N180CDHicks P David · Heber City, UTS/N 18052310N180CETailwinds Ranch LLC · Orlando, FLBuilt 1976 · S/N 18052669N180CJWipaire Inc · South Saint Paul, MNBuilt 1975 · S/N 18052539N180CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12727N180CRSnow Robert J · La Mesa, CAS/N 30627N180CTPerformance Paradise LLC · Eagle Harbor, MIBuilt 1959 · S/N 50632N180CYYoung Ideas LLC · Post Falls, IDS/N 50460N180DProuty Edgar C Jr · Sebec, MES/N 31168N180DAAalgaard Raymond F · Hollister, CABuilt 1956 · S/N 32476N180DCWilson Lewis G Jr · Rock Hill, SCBuilt 1965 · S/N 18051605N180DFSale Reported · Anchorage, AKSale reportedS/N 31892N180DGHodnett Stephen T · Canadian, TXBuilt 1955 · S/N 31280N180DHMarden Aero Services LLC · Erwinna, PABuilt 1975 · S/N 18052615N180DJHuang Sophie M · Newcastle, WABuilt 1954 · S/N 31154N180DKGriffin Vaughn · Spirit Lake, IDBuilt 1974 · S/N 18052456N180DLHall John E · Duluth, MNBuilt 1976 · S/N 18052704N180DMMock David J · Mesa, AZS/N 32911N180DRJorgensen Bryan H · Wadsworth, OHS/N 18051762N180DSCrawford E Clarke · Flagstaff, AZBuilt 1954 · S/N 30804N180DTWalton Indy R · Soldotna, AKBuilt 1954 · S/N 31023N180DUSchlegel Mark O · Kingman, KSBuilt 1979 · S/N 18053012N180DZAndrews Ruben · San Diego, CABuilt 1979 · S/N 18053094N180ECDarb Inc · Lakeville, MNS/N 32268N180EFPoe Rick M · Mojave, CABuilt 1959 · S/N 17349
Back to AD 79-10-14 R1