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.

N61758Skywagon Aero LLC · Wilmington, DES/N 18052796N61759Watkins Joe C · Albany, GABuilt 1975 · S/N 17264780N6175ENeilson Craig H · Vista, CABuilt 1958 · S/N 46275N6175GKimber 123 Holdings LLC · Morgantown, WVBuilt 1979 · S/N 17273574N6175RElinoff Neal D · Telluride, COBuilt 1965 · S/N T210-0075N61760Little Duane V · Puyallup, WABuilt 1975 · S/N 17264781N61761Hawk Aviation Inc · Rush City, MNBuilt 1975 · S/N 17264782N61763Bortoto Da Silva Alexandre · Fort Lauderdale, FLBuilt 1975 · S/N 17264784N61765Dean Mark T · Van Alstyne, TXBuilt 1975 · S/N 17264785N61766Strange Keith · Lincoln, MES/N 18504253N61769Jackson Lynn B · Cocoa Beach, FLBuilt 1975 · S/N 17264787N6176BWitzel Colton J · Frenchglen, ORBuilt 1957 · S/N 34176N6176EBullit Enterprises Ltd · Wshngtn Ct Hs, OHS/N 46276N6176GGaruda Flight Training LLC · Miami, FLBuilt 1979 · S/N 17273575N6176KDeal Clarence · Jonesboro, GABuilt 1975 · S/N 15077571N6176RJulius Kaleb · Mesa, COBuilt 1965 · S/N T210-0076N6176TMatta Figueroa Eduardo · Chapman, KSBuilt 1964 · S/N 15060876N61770Mwbw LLC · Shawano, WIBuilt 1975 · S/N 17264788N61772Henry Donald R · Lake Stevens, WABuilt 1975 · S/N 17264789N61778Cambridge Valley Flying Club Inc · Shushan, NYBuilt 1975 · S/N 17264793N6177BThomas Harry F Jr · Panama City, FLBuilt 1957 · S/N 34177N6177EByrom Nathanto · Grass Valley, CAS/N 46277N6177KMoses Annie R · Uvalde, TXBuilt 1975 · S/N 15077572N61780Delaney Kevin P · Germantown, TNBuilt 1975 · S/N 17264794N61781Ryan Good Aviation LLC · Sioux Falls, SDBuilt 1977 · S/N 18052797N61782Schroeder Rodger · Chugwater, WYBuilt 1977 · S/N 18052798N61783Copper River Airmotive LLC · Copper Center, AKBuilt 1975 · S/N 17264797N61785Fort Sam Houston Flying Club · San Antonio, TXBuilt 1975 · S/N 17264799N61786Northwest Wings LLC · Hillsboro, ORBuilt 1975 · S/N 17264800N61789Padilla Frank J · Vacaville, CAS/N 17264802N6178BSeven Eight Bravo LLC · Billings, MTBuilt 1957 · S/N 34178N6178EWaak Harlan L · Lincoln, NEBuilt 1958 · S/N 46278N6178TRobinson Don · Peotone, ILS/N 15060878N61792Turnbull Jason D · Wasilla, AKS/N 18052800N61794Dm Asset Management LLC · Plain City, OHBuilt 1975 · S/N 17264807N61798Mayo Michael E · Boerne, TXBuilt 1978 · S/N 18053009N61799Flf Aviation LLC · West Columbia, SCBuilt 1975 · S/N 17264810N6179EHolland Frederic A · Advance, NCBuilt 1958 · S/N 46279N6179RMcclinton Charles R · Cape Coral, FLBuilt 1979 · S/N 172RG0104N6179TCullipher William L · Texarkana, TXBuilt 1964 · S/N 15060879N617EPEpic Aviation Inc DBA · New Smyrna Beach, FLBuilt 2017 · S/N 172S12042N617EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12717N617FGRidgeline Assets LLC · Wilmington, DEBuilt 2020 · S/N 172S12597N617MBKlinger Ronald S Trustee · Olympia, WABuilt 1977 · S/N 18503316N617RRed Baron LLC · Middletown, DES/N 180-52979N617SPPrecision Design Inc · Wilmington, DEBuilt 2000 · S/N 172S8606N617TWTango Whiskey Aviation LLC · Cody, WYBuilt 2002 · S/N 18281176N6180Plane Fun Inc Tr Trustee · Snellville, GAS/N 32966N61801Tampa Aviation Club Inc · Tampa, FLBuilt 1975 · S/N 17264811N61803N61803 LLC · Manassas, VABuilt 1975 · S/N 17264812
Back to AD 79-10-14 R1