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.

N6684TButzen Steve B · Sheboygan, WIBuilt 1960 · S/N 15059084N6685XTaliaferro John P · Birmingham, ALBuilt 1961 · S/N 21057685N6686NClarity Aviation LLC · Anchorage, AKBuilt 1978 · S/N 21063146N6687EDriggers David J · Anchor Point, AKBuilt 1959 · S/N 56187N6687FBlakesley Eric R · Canandaigua, NYS/N 15063287N6687SSale Reported · Houston, AKSale reportedBuilt 1967 · S/N 15067487N6687XReed Ted R · San Angelo, TXBuilt 1961 · S/N 21057687N66888Registered aircraftAssigned (import), pending cancellationS/N 17281380N6688APouncey Robert · Proctor, ARS/N 28788N6688HSamaritans Purse · Boone, NCS/N 18503335N6688NLedson Steven Noble · Sonoma, CAS/N 21063148N6688TSelfridge Dennis A · Dighton, KSBuilt 1960 · S/N 15059088N6689AMaley Christopher L · Otsego, MIBuilt 1956 · S/N 28789N6689EHeizler Mark W · Oswego, ILBuilt 1959 · S/N 56189N6689FMills Nicolas A · Greenwood, NYBuilt 1966 · S/N 15063289N6689SSimpson Dwight D · Phillips, WIBuilt 1967 · S/N 15067489N6689TFlying Restorations LLC · Holts Summit, MOBuilt 1960 · S/N 15059089N6689XBravo Echo Echo LLC · Millersview, TXS/N 21057689N668CSTom Wood Aviation · Fishers, INBuilt 2016 · S/N 172S11667N668DB686 Aviation LLC · Lakewood, COBuilt 1975 · S/N 21061003N668EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12558N6690MWatson Joseph F · Colorado Springs, COBuilt 1975 · S/N 18263800N6690SSeniram Air Inc · Wilmington, DEBuilt 1967 · S/N 15067490N6690TAviation Connection LLC · Lake Worth, FLBuilt 1960 · S/N 15059090N6690XWinston Marine LLC · Bellingham, WABuilt 1961 · S/N 21057690N6692EMarshall Jerry J Sr · Parker, AZBuilt 1959 · S/N 56192N6692GHopkins Marissa A · Cameron, MTBuilt 1970 · S/N 15072192N6692MEagle Forestry Services Inc · Monticello, ARBuilt 1975 · S/N 18263802N6692SNoltensmeyer Kurt Jon · Greenbank, WABuilt 1967 · S/N 15067492N6693HSwithenbank Leonard Co-Trustee · Fort Bragg, CABuilt 1975 · S/N 17265539N6694ADenslow Carl W · Barto, PABuilt 1956 · S/N 28794N6694EThunderbird Aviation LLC · Littleton, COBuilt 1978 · S/N 17272050N6694FWanagel Walter · Lisbon, CTBuilt 1966 · S/N 15063294N6694GChatas John W · Ann Arbor, MIS/N 15072194N6694NGear Down LLC · Dalhart, TXBuilt 1978 · S/N 21063150N6695AStewart Guy C · Stevens Point, WIFirst renewal noticeBuilt 1956 · S/N 28795N6695MRegistration Pending · Sheridan, WYRegistration pendingBuilt 1976 · S/N 17266695N6695SOlsen Raymond E · Washington, UTBuilt 1967 · S/N 15067495N6695TSischka Nicholas A · Haddon Heights, NJBuilt 1960 · S/N 15059095N66964Tyler Daniel Jr · Durango, COS/N 17275994N6696FYoung Deborah C · Lopez Island, WABuilt 1966 · S/N 15063296N6696SJohnson Jay E · Murray, IABuilt 1967 · S/N 15067496N6696XTesch Timm A · Spring, TXBuilt 1961 · S/N 21057696N66978Tupper Daniel A · Groveland, CABuilt 1983 · S/N 17275995N6697AHart David L · Oxnard, CABuilt 1956 · S/N 28797N6697EMartin Jonathan · Trumann, ARBuilt 1959 · S/N 56197N6697FLogan Thomas H · Canfield, OHS/N 15063297N6697GPaul William A · Windfall, INS/N 15072197N66987De Brouwer Isabelle Mc · Alpine, TXS/N 56198N6698TJeplawy Elizabeth A · Glenwood Springs, COBuilt 1960 · S/N 15059098
Back to AD 79-10-14 R1