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.

N44PForester Dwain E · Tonopah, NVBuilt 1961 · S/N 17248620N44PYSegler Angela U · Marco Island, FLBuilt 2000 · S/N 172S8543N44RBAmj Air LLC · Holland, MIBuilt 1973 · S/N 18261829N44RCPeterson Matthew W · Ethel, LABuilt 1957 · S/N 29593N44RPCook Aviation Services LLC · Fargo, NDS/N 17250833N44STTakvorian Sevag · West New York, NJBuilt 1979 · S/N 17271609N44TBPacific Horizon LLC · Eagle, IDS/N 18267207N44TUOglesby John B · Graford, TXBuilt 1978 · S/N 18503616N44UDB & K Aviation LLC · Danville, CABuilt 2017 · S/N 172S12072N44WHKelly Sean R · Bozeman, MTS/N 21061316N44XPFurnace Joel Ray · Golden, COBuilt 1977 · S/N R1722584N44XWMinnehan Land & Cattle · Joplin, MTS/N 18266990N4500BStartin Brandon Lee · Spokane, WABuilt 1955 · S/N 31399N4500CLynch Dana L · Fairbanks, AKBuilt 1953 · S/N 25443N4500UButler Dale K · Hillsborough, NCBuilt 1964 · S/N 15060500N4501EOptima Aviation LLC DBA · Lewisville, TXS/N 17271614N4501UPruzek Russell T · New Auburn, WIBuilt 1964 · S/N 15060501N45023New Joel · Waco, TXBuilt 1975 · S/N 15076705N45028Witke Ray · Menomonie, WIBuilt 1975 · S/N 15076706N4502BAshcraft Dustin William · Anchorage, AKBuilt 1955 · S/N 31401N4502CMcfarland Keith A · Oklahoma City, OKBuilt 1952 · S/N 25445N4502NSchoonover Traci L · Weyerhaeuser, WIS/N 26500N4502UWise Joseph D · Kilgore, TXBuilt 1964 · S/N 15060502N45031Stahla Russell · Girdwood, AKBuilt 1975 · S/N 15076709N45034Coffelt Roy · Nampa, IDBuilt 1975 · S/N 15076710N45045Lingle Gordon D · Gun Barrel City, TXBuilt 1975 · S/N 15076711N4504CHickle William H · Inyokern, CABuilt 1952 · S/N 25448N4504NHayton James B · Sedro Woolley, WAS/N 18502550N45058Red Cardinal Aviation LLC · Chantilly, VAS/N 15076715N4505UYates Kenneth E · Meridian, MSBuilt 1964 · S/N 15060505N45060Stone Eric · Cedarpines Park, CABuilt 1976 · S/N 177RG1091N4506CIliamna Copper River Fly Fishing Lodge LLC · Livingston, MTBuilt 1974 · S/N 18502576N4506UBryson James D · Casstown, OHBuilt 1964 · S/N 15060506N45073Trailing Edge LLC · Elmira, NYBuilt 1975 · S/N 15076724N4507FRodriguez Kenneth C · East Wenatchee, WABuilt 1966 · S/N 185-0989N45080Todd Doug A · Dewitt, IABuilt 1975 · S/N 15076726N45082Long Robert D · Kinston, NCBuilt 1975 · S/N 15076727N45086Dahl Ken L · Granite Falls, MNBuilt 1976 · S/N 177RG1092N4508FStotz Jon · Rockford, MIBuilt 1966 · S/N 185-0990N4509BTrompeter Mark S · Intl Falls, MNBuilt 1955 · S/N 31408N4509CReams Thomas M · Panacea, FLBuilt 1952 · S/N 25453N450DHHewitt Rod · Federal Way, WAS/N 21057998N450EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12955N450JTN450jt LLC · Colleyville, TXBuilt 1981 · S/N 18268032N4510CAyres Vance · Harrison, ARBuilt 1952 · S/N 25454N4510UOrsak Chris L · Seymour, TXBuilt 1964 · S/N 15060510N45112Iaba LLC · Norfolk, VABuilt 1975 · S/N 15076739N45115Jiang Jun · Fremont, CAS/N 15076740N4511EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271619N45128Bowker James K · Ponca City, OKBuilt 1976 · S/N 177RG1093
Back to AD 79-10-14 R1