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.

N61336Evans David C · Thousand Oaks, CABuilt 1969 · S/N 15070973N61338Flyit LLC · Camas, WABuilt 1969 · S/N 15070975N6133DThomas Aviation · Granada Hills, CABuilt 1979 · S/N 17272611N6133GRosebud Aviation · Gregory, SDBuilt 1973 · S/N 18801176N6133KSturguess James K · Boonville, MOS/N 15077542N61345Carlson Brent A · Shelley, IDS/N 15070980N6134GMagruder David · Independence, LABuilt 1979 · S/N 17273571N6134KMackenzie Stuart · Pearland, TXS/N 15077543N61354New Vision Aviation · Fresno, CABuilt 1969 · S/N 15070985N6135EAce Aviation LLC · Mankato, MNBuilt 1980 · S/N 18504003N6135FJr Imaging Logistics Inc · Pasco, WABuilt 1973 · S/N A1500423N6135RStafford Michael J · Clovis, CABuilt 1979 · S/N 172RG0089N61363Hulbert Stephen R · Fort Ransom, NDBuilt 1969 · S/N 15070989N61365Plane Progress LLC · Waterloo, IABuilt 1969 · S/N 15070990N61368Department Of Inland Fisheries And Wildlife · Augusta, MEBuilt 1980 · S/N 18504159N6136ERotormate LLC · Royse City, TXS/N 46236N6137EPennington Mitchell T · Medley, WVBuilt 1978 · S/N 17271994N6137FWingland Inc · Los Angeles, CABuilt 1968 · S/N 21059037N6137GPiersol Benjamin T · Honey Brook, PABuilt 1969 · S/N 15071637N6137QJeffery & Weiss Holdings LLC · Long Beach, CABuilt 2008 · S/N 172S10682N61387Stash Ventures LLC · Virginia Beach, VABuilt 1980 · S/N 18504168N61388Seidler Matthew J · Anchorage, AKBuilt 1980 · S/N 18504169N6138FSchlegelmilch Scott A · Elkhorn, NEBuilt 1968 · S/N 21059038N6138GStrange Keith · Lincoln, MEBuilt 1969 · S/N 15071638N61398Ali Rizwan Rajab · Richmond, TXBuilt 2008 · S/N 18282066N6139BFelker Gary L · Odessa, TXBuilt 1973 · S/N 210-59909N6139EWarner Aviation LLC · Belding, MIBuilt 1958 · S/N 46239N6139KKuykendall Justin R · Petaluma, CAFirst renewal noticeBuilt 1975 · S/N 15077547N6139TGrad Jonathan P · Warroad, MNS/N 15060839N613ADhs Operations LLC · Wilmington, DEBuilt 1997 · S/N 17280248N613AKNorman Scott E · Anchorage, AKBuilt 1976 · S/N 18265221N613ERTextron Aviation Inc · Wichita, KSS/N 172S13655N613LGRidgeline Assets LLC · Wilmington, DEBuilt 2002 · S/N 172S9252N613PFGeorgia Forestry Commission · Macon, GAS/N 18281139N613SPAirmart Inc · Lexington, KYBuilt 2000 · S/N 172S8597N613TLSams Aircraft LLC · Fredonia, KYBuilt 1980 · S/N 18267613N613WCAmpaire Inc · Hawthorne, CABuilt 1966 · S/N 337-0372N613WDCruse Josiah L · Rainier, ORBuilt 1969 · S/N 18259805N613YHKuspuk School District · Aniak, AKBuilt 1980 · S/N 20700633N61405Rovey George A · Cove, ORBuilt 1980 · S/N 18504174N6140EIorio Jeffrey M · Tucson, AZBuilt 1958 · S/N 46240N6140FFluno John I · San Rafael, CAS/N A1500425N6140GSmoketown Flight Center LLC · Smoketown, PABuilt 1969 · S/N 15071640N6140KHepner Glenn L · New Port Richey, FLBuilt 1980 · S/N 17274169N6141BPayne Jacqueline · Minden, NVBuilt 1957 · S/N 34141N6141EAbpz LLC · Mc Veytown, PABuilt 1958 · S/N 46241N61422Atp Aircraft 1 LLC · Wilmington, DEBuilt 2023 · S/N 172S13087N61423State Of Utah · Salt Lake City, UTBuilt 1980 · S/N 18504180N6142EHabecker David A · Tecumseh, MIBuilt 1958 · S/N 46242N6142KCreamer Ryan Patrick · Tower Hill, ILBuilt 1975 · S/N 15077550
Back to AD 79-10-14 R1