OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N4097UJ & K Flying LLC · Marengo, OHBuilt 1965 · S/N 15061497N4098DAspegren Robert N · Vacaville, CABuilt 1958 · S/N 34798N4098JFrench Darrell L · Easton, MDS/N 15065398N4098VQualitair LLC Trustee · MichelstadtBuilt 1948 · S/N 18430N409CQPaper Airplane Co LLC · Broomfield, COBuilt 2018 · S/N 18283041N409CRChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11440N409CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282443N409ESN409es LLC · Stuart, FLBuilt 1997 · S/N 17280231N409LPSolberg Aviation Co Inc · Whitehouse Station, NJS/N 172S9409N409PKSky Cowboy Supply Co LLC · Cape Elizabeth, MEBuilt 1978 · S/N 18503721N409SPTzerefos Lambros P · Mathews, VAS/N 177RG0493N409THQualitair LLC Trustee · MichelstadtS/N 337M0375N40AESchwartz Michael · Missoula, MTBuilt 1964 · S/N 18255664N40ASSchaad Rene · Arroyo Grande, CABuilt 1998 · S/N 18280422N40BBPawlak Jakub Piotr · Lafayette, INBuilt 1977 · S/N 18265944N40BLK & B Real Estate Holdings LLC · Huntley, MTS/N 18264088N40CKDcy Aviation Group LLC · Linton, INBuilt 1977 · S/N 17269264N40DVNordstrom Eric Trustee · Anchorage, AKBuilt 1982 · S/N U20606493N40ECHill Richard C · Buckeye, AZS/N 18256692N40ERFlying Aces Aero Fleet Inc · Guyton, GABuilt 1977 · S/N 17269569N40GVHauser Paul J · Longmont, COBuilt 1976 · S/N U20603438N40HFVogel Essex Nathaniel B · Berkeley, CAS/N 15072309N40LSFenhaus Jason · Billings, MTBuilt 1973 · S/N 18262242N40LTNilsson Winston · Merrill, ORBuilt 1953 · S/N 30527N40LYAsh Gary W · Houston, TXBuilt 1978 · S/N 17270900N40MTLudden Bradford R · Whitefish, MTS/N 32681N40MUOracle Aviation LLC · Omaha, NEBuilt 1974 · S/N 17264170N40RBKmg Aviation Holdings LLC · Hartville, OHBuilt 1976 · S/N 177RG1071N40RFGamma Flight LLC · Reno, NVBuilt 2007 · S/N 172S10473N40RGDovy Aviation LLC · Houston, TXBuilt 1974 · S/N 17263241N40SPSmith Terry G · Liberty Twp, OHBuilt 1980 · S/N 17274099N40TPDraco Flight School DBA · Chino, CABuilt 1981 · S/N 17274723N40WABergstedt Yvonne · Anchorage, AKBuilt 1956 · S/N 32588N40WLBentley Thomas F · Lockport, ILBuilt 1976 · S/N 15078056N40WNRider Rebecca L · Hyde Park, NYBuilt 1968 · S/N 17700829N40WTPritchett Thomas A · Covington, GABuilt 1953 · S/N 30324N4100VSanders Keith · Palm Bay, FLS/N 15076701N4101FHanson Kathleen A · Wasilla, AKS/N 46001N4102FAdams Samuel M · Anna, TXBuilt 1958 · S/N 46002N4102LWiplinger Robert D · Inver Grove Height, MNBuilt 1973 · S/N U20602093N4102UHartpence Damian K · Newcastle, OKS/N 15060102N4103A501st Flight Solutions LLC · Kaysville, UTBuilt 1966 · S/N 15063859N4103VMoore Israel · Pasco, WABuilt 1975 · S/N 15076702N4104FMcmahon William F · Westville, INS/N 46004N4104UJennett Christopher S · New Port Richey, FLBuilt 1963 · S/N 15060104N4104VDavis Lawrence R · Kent, OHBuilt 1948 · S/N 18436N4105YChock Steven Y H · Lopez Island, WABuilt 1962 · S/N 1850305N4106LHackens Bryan Jay · New Underwood, SDBuilt 1966 · S/N 17254175N4107BMullins Esten R · El Paso, TXBuilt 1976 · S/N 18264862N4107LRobitaille Charles · Stephenville, TXS/N 17254176
Back to AD 79-10-14 R1