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.

N9741AHelzer Michelle A · Canby, ORBuilt 1950 · S/N 19406N9741FAa-Aero Inc · Fairfield, NJBuilt 1997 · S/N 17280036N9741XHalbert Larry E · Jacksonville, FLBuilt 1961 · S/N 21058041N97428Right Wing Aviation LLC · Fort Wayne, INBuilt 1984 · S/N 17276188N9742BHarp Aviation LLC · Flemington, NJBuilt 1981 · S/N 172RG1005N9742HSingularity - Intelligence Amplified LLC · Conesus, NYBuilt 1981 · S/N 18267989N9742VN9742v LLC · Ord, NEBuilt 1966 · S/N 188-0192N97433Menyhay William Csaba · Clovis, CABuilt 1979 · S/N 18267090N97435Wipaire Inc · South Saint Paul, MNBuilt 1979 · S/N 18267091N97437Carr Jeffrey A · Worthington, KYS/N 18267093N9743AYokom James C · Wichita, KSBuilt 1950 · S/N 19204N9743BVinson Paul E DBA · Gainesville, GABuilt 1981 · S/N 172RG1006N97443Miller Charles L Jr · Eunice, LABuilt 1979 · S/N 18267095N97446Mpm Wizard Enterprise LLC · Hawthorne, CAFirst renewal noticeBuilt 1979 · S/N 18267096N9744AKahrs Andrew J · Bainbridge Island, WAS/N 19205N9744DTom Wood Aviation Inc · Fishers, INBuilt 1997 · S/N 17280260N97452Taylor Michael Riding · Friday Harbor, WAFirst renewal noticeBuilt 1979 · S/N 18267099N97453Stofer William B · Warsaw, INBuilt 1979 · S/N 18267100N97456Harrington Co · Butte, MTBuilt 1979 · S/N 18267101N97459Christiansen Aviation LLC · Wilmington, DEBuilt 1984 · S/N 17276190N9745TOwens Edward W · Raymore, MOBuilt 1960 · S/N 47545N97465Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276194N97467Kg Rentals LLC · Edmond, OKBuilt 1979 · S/N 18267104N97469Wooten James E · Avinger, TXBuilt 1979 · S/N 18267105N9746APetey LLC · Bozeman, MTBuilt 1950 · S/N 19207N9746BRegistration Pending · Middletown, DERegistration pendingBuilt 1981 · S/N 172RG1009N9746XAgent West Insurance Inc · Hurricane, UTBuilt 1962 · S/N 21058046N9746YAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1981 · S/N 21064585N9747GPavlu Aerial Spraying LLC · Ness City, KSS/N 18801587TN9747TMapes James R · Ellensburg, WABuilt 1960 · S/N 47547N97485Strong Neil E · Pittsburg, TXBuilt 1979 · S/N 18267109N97487Bruns Gregg R · West Chester, OHBuilt 1979 · S/N 18267110N97489Neron II LLC · Lewes, DES/N 17276197N9748AJuhl Amanda · Centennial, COBuilt 1950 · S/N 19209N9748GKlamar Spraying Inc · Gatzke, MNBuilt 1972 · S/N 18052248N9748ZKerr Kenneth E · Bakersfield, CAS/N 21060943N9749BLee Norman S · Green Valley, AZBuilt 1957 · S/N 50047N9749G3 B Farms Inc · Pinetown, NCFirst renewal noticeBuilt 1974 · S/N 18801588N9749XNeal Daniel A · Winchester, TNBuilt 1962 · S/N 21058049N974BCL & W Aircraft Investment LLC · Homestead, FLBuilt 1997 · S/N 17280044N974CAFranks Gary W · Bolivar, MOS/N 17264459N974DBPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10661N974PCMontana Bizjets LLC · Missoula, MTBuilt 1997 · S/N 18280076N974RCRafael Cisneros LLC · Wilmington, DEBuilt 1981 · S/N 21064459N974SFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1960 · S/N 17248209N974SGWalters Patrick W · Tallapoosa, GABuilt 1997 · S/N 18280083N974SPTexas State Technical College · Waco, TXBuilt 1999 · S/N 172S8178N974TASky Peak Aviation LLC · Los Angeles, CABuilt 2002 · S/N 172S9074N974THRidgeline Assets LLC · Wilmington, DEBuilt 2023 · S/N 172S12974N97503Mercury International LLC · Cheyenne, WYBuilt 1979 · S/N 18267114
Back to AD 79-10-14 R1