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.

N6142TMiller Timothy A · Opheim, MTBuilt 1964 · S/N 15060842N6142XHurt Ronald L · Smithville, TNBuilt 1977 · S/N 17269169N61438Peot James J · Woodinville, WABuilt 1980 · S/N 18504189N6143BRushing Harley J III · Cheraw, SCBuilt 1957 · S/N 34143N6143GSale Reported · Brodhead, WISale reportedBuilt 1969 · S/N 15071643N61441Cook Sterling S · Wasilla, AKBuilt 1980 · S/N 18504191N6144BRieser Robert · Aurora, ILBuilt 1957 · S/N 34144N6144EBlack Kenneth Cory · Chillicothe, OHBuilt 1958 · S/N 46244N6144GHoke Christopher R · Kernersville, NCS/N 15071644N61455Hutcheson David Carl · Santa Rosa Beach, FLBuilt 2004 · S/N 18281363N6145ESaylor Willa G · Newburg, PAS/N 46245N6145FAlpha Bravo Aviation LLC · Trophy Club, TXBuilt 1973 · S/N A1500426N6145TJones Blake · Selma, ALBuilt 1964 · S/N 15060845N6146BMiles From Ordinary LLC · Auburn, WAS/N 34146N6146EDahlberg James C · Ogilvie, MNBuilt 1958 · S/N 46246N6146FHeppner Sebastian · Fishers, INS/N A1500427N6146TDanyal David · Lake Stevens, WABuilt 1964 · S/N 15060846N61471N484rf LLC · Jackman, MES/N 18504202N61473U S Department Of Interior · Boise, IDBuilt 1981 · S/N 18504204N61474Harper Analeasa Leighan · Clarksville, TNBuilt 2004 · S/N 18281370N6147BMock David J · Mesa, AZS/N 34147N6147FHenry Charles C · Portland, TNBuilt 1968 · S/N 21059047N6147RBloom James F · Clay City, KYS/N 172RG0094N6147TBooks Clifton B · Harrah, OKBuilt 1964 · S/N 15060847N6148EPlant Robert L · Churubusco, INBuilt 1958 · S/N 46248N6148FWorsham Eric S · La Porte, TXS/N 21059048N6149EOliphant John R · Houston, TXBuilt 1983 · S/N 18268349N6149KTurbine Financial Group LLC · Ogden, UTBuilt 1976 · S/N R1722029N6149VFoode Frank J · Cordova, AKBuilt 1980 · S/N 172RG0587N614AZWienholt Robert Jr · Perry Hall, MDBuilt 1985 · S/N 17276475N614EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2021 · S/N 172S12712N614FAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2004 · S/N 172S9614N614LFLunken Flight Training Center LLC · Cincinnati, OHBuilt 2019 · S/N 172S12257N614VZVision Aircraft LLC · Scottsdale, AZBuilt 1981 · S/N 17275258N6150ENeedham George T · Seattle, WABuilt 1958 · S/N 46250N6150FFranklin Aviation LLC · Paradise, CABuilt 1979 · S/N 17273156N6150GStockton Raymond L · Pearl City, HIBuilt 1969 · S/N 15071650N6150KAult Greg · Princeton, INBuilt 1976 · S/N R1722030N6150RChristy David L DBA · Meriden, KSBuilt 1979 · S/N 172RG0095N6150THaug Michael A · Spring Lake, MIBuilt 1964 · S/N 15060850N61516Zaikof Bay LLC · Jackson, WYBuilt 1981 · S/N 18504223N6151BCasey Ross H · Boise, IDBuilt 1957 · S/N 34151N6151KRomano Aviation LLC · Barrington, RIBuilt 1975 · S/N 15077555N6151RPath Barney H DBA · Claremont, CABuilt 1965 · S/N T210-0051N6151UMccall John A · Grapeland, TXBuilt 1985 · S/N 21064914N6151YBulloch Troy P · Cedar City, UTS/N 21064269N61522Zipay Michael A · Willow, AKS/N 18504226N6152BMohave County Board Of Supervisors · Kingman, AZBuilt 1978 · S/N 21062724N6152ESkyranch Knoxville Youth Inc · Knoxville, TNS/N 46252N6152FFisher Wayne G Trustee · Gainesville, FLBuilt 1968 · S/N 21059052
Back to AD 79-10-14 R1