OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,579

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.

N1196MAtlas Aviation LLC · Buckhannon, WVS/N 172S10424N1196USwaff Properties LLC · Humble, TXBuilt 1976 · S/N 17266897N1196YYork Aero Club Inc · York, SCBuilt 1962 · S/N 15059596N11970Kiforishin Samuel · Westfield, MAS/N 15075748N11971Registration Pending · Durham, NCRegistration pendingBuilt 1974 · S/N 15075749N11974Yilmaz Enes A · Austin, TXBuilt 1974 · S/N 15075752N1197FSchumacher Bradley M · Lewiston, IDBuilt 1975 · S/N 18502763N1197MSholer Jon R · Battle Ground, WABuilt 1975 · S/N 18264241N1197UP D H S Aerial Photography Inc · St Petersburg, FLBuilt 1976 · S/N 17266898N1197VVentry Solutions Inc · Hauser, IDBuilt 1976 · S/N R1722137N1198FStockle Barry W · Oakland, CABuilt 1966 · S/N 17254793N1198MGoeke Christine A Trustee · Hartland, WIBuilt 1969 · S/N 17258698N11995Russell Ricky · Montrose, ARS/N 18263974N1199DSpacely Space Sprockets LLC · Aurora, ORBuilt 2006 · S/N 172S10388N1199HWingsleasing LLC · Wichita, KSBuilt 2006 · S/N 172S10390N1199ULansford Inc · Clovis, NMBuilt 1982 · S/N 21064673N119DCDuque Helen · Orlando, FLS/N 17267722N119DHJohnson Peter L · Chico, CAS/N 36257N119DSDeltasierra LLC · Staunton, VABuilt 1979 · S/N 18503735N119FRJeffery & Weiss Holdings LLC · Long Beach, CAS/N 17276535N119JLMayo Clive S · Palmetto Bay, FLBuilt 1973 · S/N 18262575N119KSKent State University · Stow, OHBuilt 1999 · S/N 17280823N119LSMarsair LLC · Franklin, WIBuilt 2002 · S/N 18281119N119MSAeronorth LLC · Ann Arbor, MIBuilt 1969 · S/N 21059121N119P4dw Interests LLC · Longview, TXS/N 17263873N119PWMeyer Peter W · Stevensville, MDBuilt 1999 · S/N 172S8127N119RKHtv Music Co · Franklin, TNBuilt 1972 · S/N 18261574N119SJetkinect LLC · Henderson, NVBuilt 2000 · S/N 172S8402N119WCSmith Steven W · Kodiak, AKBuilt 1972 · S/N 18052235N11APAp Aero LLC · Oklahoma City, OKBuilt 1974 · S/N 21060168N11ATChan Roger J · Anchorage, AKBuilt 1974 · S/N 18502547N11BTBravo Tango LLC · Minden, LABuilt 1965 · S/N 18256146N11CSilicz Nicholas J · Shafter, CABuilt 1975 · S/N 18502713N11CEMelcher Pierre S · New Braunfels, TXBuilt 1974 · S/N 18502512N11DHRegistered aircraftBuilt 1978 · S/N 18052974N11DZLowe Jacob · Knoxville, TNBuilt 1965 · S/N 18256245N11FJPetit Chris J · Marrero, LABuilt 1961 · S/N 18253252N11FNScheck Christopher R · Troutdale, ORBuilt 1973 · S/N 15074423N11FRMosley John E · Jackson, MSBuilt 1971 · S/N 18260761N11GSHuddleston Edward · Oaktown, INBuilt 1976 · S/N 15078597N11HHRegistration Pending · Durango, CORegistration pendingBuilt 1965 · S/N 18051484N11JESky Vista LLC · Macon, GABuilt 1974 · S/N 18263240N11JTJjj Ventures LLC · Bronx, NYBuilt 1969 · S/N 15071181N11KRDawson Gray N · Roseburg, ORBuilt 1976 · S/N 21061249N11KTHilborn Rebecca M · Addison, NYBuilt 1956 · S/N 28593N11LATwo-Ten LLC · Ramona, CABuilt 1968 · S/N 21059058N11MBYoungstown Warren Development Partners · Youngstown, OHBuilt 1979 · S/N 17272769N11NNLamm Russell N · Wernersville, PABuilt 1974 · S/N 17263954N11TCShiver James B Jr · Stanley, NMBuilt 1977 · S/N 21062230N11VBuckner Eldon L · Baker City, ORBuilt 1959 · S/N 55819
Back to AD 79-10-14 R1