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.

N5639RKeith L S · Forestburg, TXBuilt 1965 · S/N 17253262N563EREmbry-Riddle Aeronautical Univerity Inc · Prescott, AZBuilt 2023 · S/N 172S13088N563FAWang Yuemin · Wauconda, ILBuilt 2003 · S/N 172S9563N563FSPatterson Marshall S · Tuscumbia, ALBuilt 1967 · S/N 15066188N563GMarsh Matthew · Cleveland, ALBuilt 1968 · S/N 15068275N563GSGilderhus Edwin T · Oberon, NDS/N 15071468N563NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10788N563RSRaven Bryan F · Lakeland, FLS/N 17255866N563SPSloan Joseph · Lancaster, CAS/N 172S8416N5640ASanders David L · Powell, WYBuilt 1956 · S/N 28240N5640BN5640b LLC · Ashburn, VABuilt 1956 · S/N 33640N5640EHunt Jacky R · Bowling Green, KYBuilt 1978 · S/N 17271909N5640RUnruh Jerel W · Versailles, MOBuilt 1965 · S/N 17253264N5641BGoebel William R · Rhome, TXBuilt 1956 · S/N 33641N5641REaton Samuel D · Clinton, PABuilt 1965 · S/N 17253265N5641TMarcy Dara Owen · Tacoma, WABuilt 1964 · S/N 17251541N5642AMoore Alton O III · Lago Vista, TXS/N 28242N5642JGreater Houston Soaring Association · Needville, TXBuilt 1969 · S/N 18800592N5642RMatheny Roger P · Humble, TXBuilt 1965 · S/N 17253266N5643ARosansky Jeff S · Weldon Spring, MOBuilt 1956 · S/N 28243N5644BSchmidt Ross A · D-63329 EgelsbachNon-citizen corporation, flight hours not reportedBuilt 1956 · S/N 33644N5644CRegistered aircraftBuilt 1950 · S/N 15598N5644RShaffer Mark J · Porterfield, WIBuilt 1965 · S/N 17253269N5644TScootair LLC · Alburgh, VTBuilt 1964 · S/N 17251544N5645AAll Seasons Catering Inc · Shelter Isl, NYBuilt 1956 · S/N 28245N5645BHenderson William R · Ohatchee, ALBuilt 1956 · S/N 33645N5645EHagen Edward E · New Auburn, WIBuilt 1959 · S/N 17145N5645RGecha Brian S · Brandon, VTBuilt 1965 · S/N 17253270N5645TJ & J Aviation Inc · Martinsville, VABuilt 1964 · S/N 17251545N5646AHeffron Jacob L · Little Falls, MNS/N 28246N5646BSkydive Ky LLC · Cecilia, KYS/N 33646N5646CBivens Jason D · Duncan, OKBuilt 1950 · S/N 15600N5646RAumack Bryant D · Melbourne, FLBuilt 1965 · S/N 17253272N5647GDarter Lloyd R · Mountain Grove, MOBuilt 1973 · S/N 18801129N5647TJohnson Jeffri K · Brighton, COBuilt 1964 · S/N 17251547N5648AMartin Rand E · Lake Stevens, WAS/N 28248N5648BBailey Carl · Huntington, WVBuilt 1956 · S/N 33648N5648EHanna Charles M · Luthersville, GABuilt 1959 · S/N 17148N5648JSswb Enterprises LLC · Lufkin, TXBuilt 1974 · S/N 18263479N5648RKurtz Richard G · Ithaca, NYS/N 17253275N5648TYankton Area Aviators Inc · Crofton, NEBuilt 1964 · S/N 17251548N5649AMinor Charles G · Medford, ORS/N 28249N5649CRon Alexander Youth Aviation Program · Williamson, GABuilt 1950 · S/N 15603N5649GMaran Properties LLC · Lowell, ARBuilt 1979 · S/N 17273564N564ATMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10020N564CMurray Robert G · Eudora, KSBuilt 1964 · S/N 185-0656N564DSLopez John · Prole, IAS/N 15066564N564EDTilse William A · Kirkland, WABuilt 1956 · S/N 28362N564GHughes Ramzi S · Alamo, NVBuilt 1968 · S/N 15068276N564LMSky Horse LLC · Santa Cruz, CABuilt 2012 · S/N 20608340
Back to AD 79-10-14 R1