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.

N5346NMustang Manufacturing Inc · Carson City, NVBuilt 1980 · S/N 18267658N5346QCape Fear Aviation Maintenance LLC · Fayetteville, NCBuilt 1972 · S/N 15073246N5346TTiffany Shawn M · Herington, KSBuilt 1964 · S/N 17251246N5346VRegistered aircraftBuilt 1980 · S/N 172RG0510N53474Executive Air Taxi Corp · Bismarck, NDBuilt 2003 · S/N 172S9376N53475Rw Aviation LLC · Fishers, INBuilt 1975 · S/N 33701649N5347HMonterey Bay Aviation Inc · Watsonville, CABuilt 1975 · S/N 17265410N5348DSwaz Aviation LLC · Mesa, AZBuilt 1979 · S/N 17272536N5348EDexter Brady R · Chambers, NEBuilt 2003 · S/N 18281212N5348UC3 Shadow LLC · Columbus, OHBuilt 1984 · S/N 21064874N5348VKavon Clinreg LLC · Palm Beach Gardens, FLBuilt 1980 · S/N 172RG0511N5348YWheeler Robert T · Silt, COBuilt 1980 · S/N 21064176N53491Crossbrook LLC · Willoughby, OHBuilt 1981 · S/N 17274764N53494Gandarillas Andrew J · Toledo, WABuilt 1981 · S/N 17274765N5349DFisher Randall A · Salem, OHBuilt 1979 · S/N 17272537N5349RTroya Aviation LLC · Utica, NYBuilt 1965 · S/N 17252878N534DDVan Gasse Randall M · Norway, MIBuilt 1998 · S/N 17280323N534DWValiair Ltd Co Trustee · Casper, WYBuilt 1976 · S/N 177RG1004N534EREmbry Riddle Aeronautical University Inc · Prescott, AZBuilt 2024 · S/N 172S13165N534FLeiser Harry W · Rome, PABuilt 1965 · S/N T210-0109N534HFSun Aircraft Management LLC · Ormond Beach, FLBuilt 2000 · S/N 17280832N534KSKent State University · Stow, OHBuilt 2012 · S/N 172S11241N534PCSutton Brad · Vallecito, CABuilt 1975 · S/N 18264394N534RHAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13473N53504Aviation Adventures LLC · Hansen, IDBuilt 1975 · S/N 33701664N53507Flight School Of Gwinnett · Lawrenceville, GABuilt 1981 · S/N 17274769N5350CJones Terry M · Bells, TNBuilt 1950 · S/N 15573N5350KCenterline Aviation LLC · Oklahoma City, OKBuilt 1980 · S/N 17274076N5350RNorth Fergus Flying Club · Winifred, MTBuilt 1965 · S/N 17252879N53510Joey Os LLC · Darlington, PABuilt 1975 · S/N 33701670N53519Gic Inc · Oneill, NEBuilt 1975 · S/N 33701677N5351CLc Aviation Consulting LLC · Montauk, NYBuilt 1950 · S/N 15482N5351DSplan David L · Mccall, IDS/N 50249N5351HHayes Jeffery M · Yatesville, GABuilt 1975 · S/N 17265411N5351QBarrett Dannie P · Halfway, ORS/N 17261778N5351VHarris Adam K · Shrewsbury, MABuilt 1977 · S/N R1722292N53520Harben Grover S III · Gainesville, GAS/N 33701678N53525Dewind Helicopter LLC · Zeeland, MIBuilt 1976 · S/N 33701682N5352CBohl Howard M · Temecula, CABuilt 1950 · S/N 15483N5352KPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1980 · S/N 17274077N5352NAhrens Douglas T · Los Altos, CABuilt 1980 · S/N 18267662N5352RProam Flyers Of Union County · Matthews, NCBuilt 1965 · S/N 17252882N5352SGustafson Steven R · Jamestown, NYBuilt 1966 · S/N 337-0452N5352TFord Howard J · Salt Lake City, UTBuilt 1964 · S/N 17251252N5352ULittle Dog Aviation LLC · Anchorage, AKBuilt 2003 · S/N 172S9385N53531Hayes Inc · Betsy Layne, KYBuilt 1976 · S/N 33701686N5353CStill Martin L · Upper Sandusky, OHBuilt 1950 · S/N 15484N5353DMcmahan Charles B · Gakona, AKS/N 50242N5353KCentury Air Inc · Fairfield, NJBuilt 1980 · S/N 17274078N5353QRegistered aircraftBuilt 1972 · S/N 15073253
Back to AD 79-10-14 R1