OpenAirDocs.org
AD 79-10-14 R1

Registered aircraft · 56,580

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.

N3999JMurphy Arthur John III · Huntsville, ALBuilt 1966 · S/N 15065299N3999LMorris Jeffrey A · Lake Delton, WIS/N 17254168N399AAAoa Kissimmee Inc · Kissimmee, FLBuilt 2015 · S/N 172S11553N399CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18281999N399CVCivil Air Patrol · Maxwell Afb, ALBuilt 2016 · S/N 18282441N399EFisher James W · Humboldt, TNBuilt 1959 · S/N 17219N399ESBray Aviation LLC · Calera, OKBuilt 1997 · S/N 17280155N399FFieldgrove Matt L · Somerton, AZBuilt 1955 · S/N 31478N399HLon Air LLC · Miles City, MTBuilt 1978 · S/N 18266519N399JPL&M Aircraft Inc · Rome, GABuilt 1977 · S/N 177RG1111N399KOsborn Ferrell V · Avery Island, LABuilt 1977 · S/N 18265733N399KMCustodio Olga · San Antonio, TXBuilt 1973 · S/N 21059982N399MESound Sleep Clinic Pllc · Bainbridge Island, WABuilt 2000 · S/N 18280878N399NBicknell Brooks E · Andover, NHBuilt 1980 · S/N 18267690N399STLankford Austin S · Sturtevant, WIBuilt 1959 · S/N 17399N399TBg Flight Group LLC · Bowling Green, KYBuilt 2000 · S/N 18280817N399TXCherry Lane R · Vidor, TXS/N 15065205N39AKRenfro Michael W · Bethel, AKBuilt 1980 · S/N 20700597N39BEAberdeen Flying Service · Aberdeen, SDBuilt 1984 · S/N 21064889N39CCWard Bobby J · Dalhart, TXBuilt 1975 · S/N 18502858N39FCStout Keith · Salmon, IDBuilt 1979 · S/N 18503923N39JApex 1996 LLC · Kilgore, TXS/N 18052274N39JJStag Aviation LLC · Tomball, TXBuilt 1966 · S/N 17254265N39MPMission Aviation Training Academy · Arlington, WABuilt 1965 · S/N U206-0288N39PDBechard Barry C · Mount Joy, PABuilt 2000 · S/N 172S8424N39PSSmith Justin Dean · Dayton, TNS/N 18258921N39TDHawk Meadow Aviation LLC · Sutton, AKBuilt 1971 · S/N 15073099N3AQSinnott-Simonis Lyle · Girdwood, AKBuilt 1955 · S/N 31744N3BCBenedict Larry · Dexter, NMBuilt 1956 · S/N 33947N3BDCopley Johnnie H · Minooka, ILBuilt 1979 · S/N 18267206N3BYJamora Daniel L · Victorville, CABuilt 1969 · S/N 17257965N3CHElliott Frank F · Mojave, CABuilt 1970 · S/N 33701282N3CLWehner Kaitlyn M · Malone, WIBuilt 1968 · S/N 17257531N3CMOxbow Investments LLC · Sonora, CABuilt 1972 · S/N P337-0025N3CYSchultz Daniel A · Tipp City, OHBuilt 1972 · S/N P3370022N3DWWhite Robert D Trustee · Colorado Springs, COBuilt 1973 · S/N 18262003N3DZXtreme Flying Club LLC · Gansevoort, NYS/N 33534N3EHHoppe Nicholas J · Big Lake, AKBuilt 1961 · S/N 18051020N3FRValiair Limited Company Trustee · Casper, WYS/N R172-0237N3HLLamarr Ryan A · Greenview, CABuilt 1957 · S/N 29935N3HQChesapeake Searey LLC · Wilmington, DES/N 17269154N3JARegistered aircraftBuilt 1975 · S/N 17266528N3JNGas Aviation LLC · Decatur, TNBuilt 1966 · S/N 337-0558N3JPMcbride Scott · Lake Havasu City, AZBuilt 1978 · S/N 18266230N3JTMcdannel Albert M · Laporte, INS/N 15070621N3JXDunbar Marc L Trustee · Rocklin, CABuilt 1952 · S/N 25248N3KKKraussman Daniel J · San Antonio, TXBuilt 1978 · S/N 21062752N3KVAirmax Charters LLC · Lake Worth, FLBuilt 1981 · S/N 17274768N3LESubick Leonard W · Spring City, PAS/N 20700368N3LUKirby & Associates Texas Lp · West Hills, CAS/N 18264437
Back to AD 79-10-14 R1