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.

N5162REllis Harvey Airport Inc · Guthrie, OKBuilt 1974 · S/N 17263379N51637South Dakota State University · Brookings, SDS/N 172S9033N5163APassero Robert S · Madison, ALBuilt 1955 · S/N 28163N5163DHaddix Stanley D · Hagerhill, KYBuilt 1979 · S/N 17272438N5163HLsn Air LLC · Morrison, COBuilt 2001 · S/N 172S8933N5163UValor View Aviation LLC · Midland, TXS/N 172RG0267N5163VKopacz Thomas · Glen Flora, WIBuilt 1980 · S/N 172RG0457N5163ZGevojanyan Gary · Burbank, CAS/N 172S9032N5164EWilliams Kevin J · Giltner, NEBuilt 1978 · S/N 17271746N5164FBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281082N5164NCaribbean Way Of Life Inc Trustee · Wilmington, DEBuilt 1980 · S/N 18267554N5165AKulp Robert E Jr · Cartersville, GABuilt 1955 · S/N 28165N5165DHull Terri L · Weirsdale, FLBuilt 1958 · S/N 51265N5165MAl & Zal Corp · Gaylord, MIBuilt 2002 · S/N 17281092N5165RAvocado Air LLC · Perkasie, PABuilt 1974 · S/N 17263382N5166ADavis Barry E · Carrollton, GABuilt 1955 · S/N 28166N5166EHanson Michael M · Kent, WABuilt 1959 · S/N 50466N5166FColeman Timothy J · Cornwall On Hudson, NYBuilt 1965 · S/N 17253052N5166RCrown Flying Club · Overland Park, KSBuilt 1974 · S/N 17263383N5166YSchmenk Brent · Frisco, TXBuilt 2002 · S/N 18281089N51670Colorado Northwestern Community College · Rangely, COBuilt 1980 · S/N 17274336N5167EJkg LLC · Murfreesboro, TNBuilt 1978 · S/N 17271747N5167HBest Joseph J · Coldwater, MIBuilt 1975 · S/N 17265357N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294N5168NRidgley Kirk L · Shingle Springs, CABuilt 1980 · S/N 18267555N5168VSky-Vu Flyers Inc · Fishers, INS/N 172S9037N5169DHomesick Angel LLC · Black Hawk, COBuilt 1958 · S/N 51269N5169EVenbro Holdings LLC · Brooklyn, NYBuilt 2002 · S/N 172S9038N5169VMalcolm Douglas · Shell Beach, CABuilt 1980 · S/N 172RG0458N516APStewart Stewart D · South Egremont, MABuilt 1977 · S/N 177-RG-1259N516AVN388v LLC · Manassas, VABuilt 1981 · S/N 17275205N516CACharlie Alpha Flying Club · Sunnyvale, CABuilt 1978 · S/N 18266702N516CSMccullough Construction Inc · South Jordan, UTBuilt 1998 · S/N 17280428N516DMSmall Howard · West Hartford, CTS/N 18280028N516EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2022 · S/N 172S12867N516JWAerostar LLC · Newport Beach, CABuilt 1975 · S/N 17265201N516LPSun City Aviation LLC · Davie, FLBuilt 1998 · S/N 18280179N516NDSunrise Aviation Inc · Ormond Beach, FLBuilt 2008 · S/N 172S10786N516SPOrlando Aeroclub Inc · Orlando, FLBuilt 2000 · S/N 172S8375N516TGNatchez Flight Training LLC · Natchez, MSBuilt 1977 · S/N 17268889N51700Brown County Flying Club · Aberdeen, SDBuilt 1980 · S/N 17274338N5170DSandford Graves M · Moberly, MOBuilt 1958 · S/N 51270N5170NVx LLC · Melbourne, FLBuilt 1980 · S/N 18267557N5171AInfinity Metalworks Inc · Newton, KSBuilt 1955 · S/N 28171N5171DFaber Elgin · Havre, MTBuilt 1958 · S/N 51271N5171EL & D Air · Foley, ALBuilt 1982 · S/N 18268295N5171HPan Air Flying Club · Miami, FLBuilt 1975 · S/N 17265358N5171KBrewer Curtis E · Millington, TNBuilt 1980 · S/N 17273998N5171RSamuels Jay M · East Tawas, MIBuilt 1974 · S/N 17263388N5171USummers Jeffrey L · Pekin, INBuilt 1980 · S/N 172RG0272
Back to AD 79-10-14 R1