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.

N2676DLamott Brenda I · Boise, IDBuilt 1952 · S/N 20828N2676GHolland Ross D · Guymon, OKBuilt 1959 · S/N 51976N2676KFurey Michael J · Hazlehurst, MSS/N 18053033N2676LCupp Stanley J · Quilcene, WABuilt 1967 · S/N 17255876N2676URobinson Dalton M · Londonberry, OHS/N 17250276N2677FNeu Aviation LLC · Benton, LABuilt 1965 · S/N 18256777N2677GPeterson Barbara A · Cheney, KSBuilt 1959 · S/N 51977N2677KAeropod Inc · Aurora, COS/N 18053034N2677XHawk Jeff · Flowermound, TXBuilt 1965 · S/N P206-0177N2677YHracha Deanna L · Palmer, AKBuilt 1963 · S/N 18051177N2678SHardy Mikel Gareth · Thatcher, AZBuilt 1973 · S/N 18502265N2678XStewart Jeffrey D · Snyder, TXBuilt 1965 · S/N P206-0178N2679DHoppe Air LLC · Beaman, IABuilt 1952 · S/N 20831N2679FR & K Explorations Inc · Bonners Ferry, IDBuilt 1966 · S/N 18256779N2679JJupiter Flight Service And Investing LLC · Lithonia, GABuilt 1966 · S/N 15065679N2679LBartley James K · Kent, WABuilt 1967 · S/N 17255879N2679RSchultz Charles D · Webster, WIBuilt 1967 · S/N 18258379N2679SJordan Richard L · Memphis, TNBuilt 1968 · S/N 337-0979N2679ZRonalter John M · Norristown, PABuilt 1963 · S/N 185-0679N267EEvenson Charles R · Saint Charles, MOBuilt 1972 · S/N 15074092N267FGRidgeline Assets LLC · Wilmington, DES/N 172S12725N267HPFlorida Highway Patrol · Tampa, FLBuilt 2002 · S/N 172S9267N267MCKitchen Blaine III · Rochester, MABuilt 2006 · S/N 20608267N267MECape Aero LLC · Cape Girardeau, MOBuilt 2000 · S/N 18280774N267RAReynolds Darryl G · Wills Point, TXS/N 17261919N267RHPxw Services · Bristow, VABuilt 2010 · S/N 18282208N2680FWatkins Jeffrey M · Auburn, CABuilt 1965 · S/N 18256780N2680GTodd Larry D · Wasilla, AKBuilt 1959 · S/N 51980N2680XN2680x LLC · Mountain Home, ARBuilt 1998 · S/N 18280307N2680YReid Brian M · Boise, IDBuilt 1962 · S/N 18051180N2681GRhea Higher Education And Aviation LLC · Prescott, AZBuilt 1959 · S/N 51981N2681SBromley Keith W · Titusville, PAFirst renewal noticeS/N 337-0981N2681UOsterhaus Jonathan · Petersburg, TNBuilt 1963 · S/N 17250281N2681XZimmer Roy E Jr · Winter Park, FLBuilt 1965 · S/N P206-0181N2682CInternational Air Services Inc Trustee · Carson City, NVS/N 18281648N2682GFlying L Aircraft Inc · Fort Denaud, FLBuilt 1959 · S/N 51982N2682JCooper David J · Gravette, ARBuilt 1966 · S/N 15065682N2682LCommonwealth Technical Services Inc · Powhatan, VABuilt 1967 · S/N 17255882N2682RRadeka Michael · East Machias, MES/N 18258382N2682UCseh Sandor · New Brunswick, NJBuilt 1963 · S/N 17250282N2682VVogen Jeffrey L · Newark, ILBuilt 1948 · S/N 18193N2683DRasmussen Merlin P · Enumclaw, WABuilt 1952 · S/N 20835N2683GEtc Aircraft LLC · Anchorage, AKFirst renewal noticeS/N 51983N2683RNance James H II · Grants Pass, ORBuilt 1967 · S/N 18258383N2683VPeters Robert M · Fremont, INBuilt 1975 · S/N 177RG0655N2684DSaltsgaver Robert E III · Maryville, TNS/N 20836N2684FFelts Anthony E · Groveland, CAS/N 18256784N2684QJastram Benjamin C · Lafayette, LABuilt 1966 · S/N 18257884N2684UAnderson Robert David · Brighton, MIBuilt 1963 · S/N 17250284N2684VReims Rocket LLC · Tempe, AZBuilt 1976 · S/N R1722227
Back to AD 79-10-14 R1