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.

N27300Rankin Kevin J · Maryville, MOBuilt 1998 · S/N 17280551N2730EOew Aviation LLC · Sumter, SCBuilt 1978 · S/N 17271309N2730QSkylane Corp · Pittston, PABuilt 1967 · S/N 18257930N2730XSmith Daniel E · Anchorage, AKBuilt 1965 · S/N 18051530N2731DVoegeli Nathan · Sacramento, CAS/N 25273N2731JPatry Aeronautical Institute · Kalispell, MTBuilt 1974 · S/N A1500574N2731KYoung Aviation LLC · Oshkosh, WIBuilt 1979 · S/N 18053045N2731Q31q LLC · Boise, IDBuilt 1967 · S/N 18257931N2731UKemp Gilbert A · Waterville, NYBuilt 1963 · S/N 17250331N2731YGeorgia Forestry Commission · Macon, GABuilt 2003 · S/N 18281202N2732DYounger Cody M · Shedd, ORBuilt 1952 · S/N 25274N2732GPrince Benjamin D · Lincoln, MTS/N 52032N2732KDixie Sand And Gravel LLC · Edisto Island, SCBuilt 1979 · S/N 18053046N2732LGlenndale LLC · Jackson, MOBuilt 1967 · S/N 17255932N2732UDavenport Jimmy J · Hayesville, NCS/N 17250332N27339Rice John G · Craig, AKBuilt 1970 · S/N 18052140N2733CYurechko Philip Jr · Jewett City, CTBuilt 1954 · S/N 26277N2733FMetzger William M · Boonville, INBuilt 1965 · S/N 18256833N2733GSkydive Ky LLC · Cecilia, KYS/N 52033N2733LHugelman Frank J III · Waynesville, MOBuilt 1967 · S/N 17255933N2733VOlson Kirk · Dickinson, NDBuilt 1975 · S/N 177RG0676N2734CRegistered aircraftS/N 26278N2734FWard Christopher C · Lufkin, TXBuilt 1965 · S/N 18256834N2734HGriebel Kyle L · Lafayette, COBuilt 1959 · S/N 52034N2734JHelbig Frederick E · Oakland, MDBuilt 1974 · S/N A1500576N2734Q1175 Bangtail Way LLC · Greycliff, MTBuilt 1967 · S/N 18257934N2734URegistered aircraftBuilt 1963 · S/N 17250334N2735CBeach Michael C · Lebanon, ORBuilt 1954 · S/N 26279N2735DMorpeth Thomas · Fortson, GABuilt 1952 · S/N 25277N2735GGaunt Galen B · Glennallen, AKBuilt 1959 · S/N 52035N2735KCook Kyle R · Green Valley, AZBuilt 1979 · S/N 18053049N2735QRegistration Pending · Hearne, TXRegistration pendingBuilt 1967 · S/N 18257935N2735UKnepper Gary E · Canby, ORBuilt 1963 · S/N 17250335N2736GFor Skies Flying Club Ltd · Martinsville, ILBuilt 1959 · S/N 52036N2736KP M Logistics LLC · Haskell, OKBuilt 1979 · S/N 18053050N2736LWilson Steven W · N Richlnd Hls, TXFirst renewal noticeBuilt 1967 · S/N 17255936N2736QBachich George A · Napa, CABuilt 1967 · S/N 18257936N2736XMehling Michael R · Fairview, MTBuilt 1965 · S/N 18051536N2737CBenard Matthew Scott · Lakeville, MABuilt 1954 · S/N 26281N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643N2737KFanazick Joseph P · Juneau, AKBuilt 1979 · S/N 18053051N2737LAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 17255937N2737SBlock Oliver L · Nashville, TNBuilt 1967 · S/N 15066637N2737XFly-By Aviation Services LLC · Colorado Springs, COBuilt 1965 · S/N 18051537N2738LDemkiewicz Daniel · Houston, TXBuilt 1967 · S/N 17255938N2738UVan Der Waal Allan L · Port Angeles, WABuilt 1963 · S/N 17250338N2739GSwanson Gordon · Prescott, AZS/N 52039N2739JCiulla Santo · Odessa, FLBuilt 1974 · S/N A1500578N2739LHall Barbara S · Burgettstown, PABuilt 1967 · S/N 17255939N2739UN2739u Holding LLC · New Orleans, LABuilt 1963 · S/N 17250339
Back to AD 79-10-14 R1