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.

N989WDTextron Aviation Employees Flying Club Inc · Wichita, KSBuilt 2025 · S/N 172S13289N989WUEglin Aero Club · Eglin Afb, FLBuilt 1998 · S/N 17280571N98BVUSA Air LLC · Ruskin, FLBuilt 1974 · S/N 15075695N98DDReady Aim Flyer LLC · New Castle, DES/N 51709N98DXInternational Air Services Inc Trustee · Carson City, NVS/N 17272526N98EMGreen Tool & Die Co LLC · Honesdale, PABuilt 1968 · S/N 17256804N98FFPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2024 · S/N 172S13208N98GCGarcia Alexandra · Pompano Beach, FLBuilt 1968 · S/N 17257750N98JBFlight1 Hsw LLC · Norwood, COBuilt 1965 · S/N 652N98MLPlr Services LLC · Stuart, FLBuilt 2019 · S/N 18283066N98PBFerry Services Corp · Cresson, TXBuilt 1977 · S/N 18503489N98SSSoutheastern Oklahoma State University · Durant, OKBuilt 1977 · S/N 15079353N98SWGankas Christopher · Ventura, CABuilt 1976 · S/N 177RG1090N98TCPositiv8 LLC · Wilmington, DEBuilt 1974 · S/N 18263411N98TDLewis John Cory · Modesto, CABuilt 1998 · S/N 18280081N98VFFitzpatrick Patrick D · Titusville, FLBuilt 2025 · S/N 18283316N98WHN94ee LLC · West Palm Beach, FLBuilt 1998 · S/N 18280122N98WYCheyenne Flying Club LLC · Cheyenne, WYBuilt 1998 · S/N 18280339N98ZTSharp Paul A II · Apollo Beach, FLBuilt 1971 · S/N 17259956N9900BS & L Aviation LLC · Buhl, IDS/N 34300N9900GSkyline Agrinautics Inc · Osage, IABuilt 1970 · S/N 18800700N9900NRegistered aircraftBuilt 1975 · S/N 18052555N9900QBedsole Clinton Allen · Frisco, TXBuilt 1975 · S/N 17265844N9900THamlin Timothy B · Garden City, KSBuilt 1960 · S/N 53000N9901BNichols Patrick C · Fairview, NCBuilt 1957 · S/N 34301N9901EBas Part Sales LLC · Greeley, COBuilt 1975 · S/N 18263961N9901NTeets David J · Fairbanks, AKBuilt 1975 · S/N 18052556N9901VMinske Troy · Princeton, MNBuilt 1966 · S/N 18051753N9902EOtto Real Estate Investment Inc · Bakersfield, CABuilt 1975 · S/N 18263962N9902QBowers John E · Owasso, OKBuilt 1975 · S/N 17265846N9902VEuroaviation Inc Trustee · KematenBuilt 1966 · S/N 18051754N9903GCourtney Brooks Streetwise Inc · Avondale, AZFirst renewal noticeS/N A1500456N9903MRegistered aircraftBuilt 1976 · S/N 18264799N9903TRiddle John G · Townsend, MTBuilt 1960 · S/N 53003N9903VDwh Flight LLC · Spring, TXBuilt 1974 · S/N 17264552N99040Bradley Aircraft Company LLC · Columbus, INBuilt 1985 · S/N 17276395N99045Allen Michael R · Graham, NCBuilt 1985 · S/N 17276396N99048Bradley Aircraft Co · Columbus, INBuilt 1976 · S/N 17268367N9904HWingin It LLC · Marshall, MNBuilt 1981 · S/N 18268101N9904QStanford Jay J · Saint Marys, GABuilt 1975 · S/N 17265848N9904VStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17264553N9905AHottois Scott A · Whittemore, MIS/N 19265N9905ELf Flying LLC · Wellington, MOBuilt 1985 · S/N 18268469N9905FNew Horizon Aviation Inc · Warwick, RIBuilt 1997 · S/N 17280184N9905HWhitaker Billy Dean Jr · Houston, TXBuilt 1981 · S/N 18268102N9905QCentral Air Service · Lewistown, MTBuilt 1975 · S/N 17265849N9906GNielson Donald L · Independence, ORBuilt 1973 · S/N A1500457N9906LRiseaero LLC · Florence, SCBuilt 1986 · S/N 17276647N9906MWhorton Darren · Nashville, TNBuilt 1976 · S/N 18264802N9906VStruempler Jed E · Anchorage, AKBuilt 1966 · S/N 18051758
Back to AD 79-10-14 R1