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.

N714QXLewis Justin S P · Choctaw, OKBuilt 1977 · S/N 15079361N714QZ20925 Harper Rd LLC · Bend, ORBuilt 1983 · S/N 18504412N714RBStewart Family Ranch Inc · Chadron, NES/N 15079365N714RCWebster Richard Eric · West Valley City, UTS/N 15079366N714RFB2 Aviation LLC · Hopkinsville, KYBuilt 1977 · S/N 15079369N714RGLumgair David R · Painter, VAS/N 15079370N714RNHubler Alvin J Jr · Elizabethtown, PABuilt 1977 · S/N 15079376N714RPSapp Michael B · Burlington, NCBuilt 1977 · S/N 15079377N714RRMcburney Gary N · Apple Valley, CABuilt 1977 · S/N 15079379N714RSBeefair LLC · Kalispell, MTBuilt 1977 · S/N 15079380N714RVPataky Edward F Jr · Nashville, TNBuilt 1977 · S/N 15079383N714SBNorth Delta Crop Consulting LLC · Dyersburg, TNBuilt 1973 · S/N 18261869N714SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12559N714SGAce Aviators LLC · Mcdonough, GABuilt 1977 · S/N 15079393N714SKAlaska Sky School LLC · Anchorage, AKBuilt 1977 · S/N 15079396N714SLSopko Mark W · Flagtown, NJBuilt 1977 · S/N 15079397N714SPBoyer Steven L · Wooster, OHBuilt 1977 · S/N 15079400N714SSPierce Jeanne E · Wellington, NVBuilt 1977 · S/N 15079403N714SVStookey Aaron M · Mesa, AZBuilt 1977 · S/N 15079405N714TLHarshman Jeff C DBA · Cedar Point, KSS/N 18504419N714TPRutherford Troy L · Clanton, ALBuilt 1965 · S/N 18256503N714ZKWhite Blaine Scott · Castlewood, VABuilt 1985 · S/N 18504440N71501Boone William G · Orland, CABuilt 1976 · S/N 17267228N7150FTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1966 · S/N 15063750N7150TKittelman Real Estate Inc · Enumclaw, WABuilt 1959 · S/N 46750N7150XBrown Mitchell J · Herndon, PABuilt 1961 · S/N 15059250N71511Jochl Kimberley · Sugar Mountain, NCFirst renewal noticeBuilt 1969 · S/N 18259647N71514Slater Richard · Graham, WABuilt 1969 · S/N 18259648N71518Northern Arizona 182 Flying Guys LLC · Flagstaff, AZBuilt 1969 · S/N 18259650N7151GRoadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258851N7151JLenticularis LLC · Madison, WIBuilt 1980 · S/N 17273903N7151KKyllo Jeff K · Larimore, NDBuilt 1976 · S/N R1722048N7151SCoby Jacob E · Fairview, NCBuilt 1976 · S/N 18265072N7151XWhite James D · Bozeman, MTS/N 15059251N7152ERobinson Andrew K · Pahrump, NVBuilt 1959 · S/N 52152N7152GJ&B Aircraft Leasing LLC · Lufkin, TXBuilt 1969 · S/N 17258852N7152QSkyrealms LLC · Austin, TXBuilt 1972 · S/N 17260452N7152TKaras Alyssa Jane · Henderson, NVBuilt 1959 · S/N 46752N7152XGivens Eric J · Frankfort, OHBuilt 1961 · S/N 15059252N71538Grier Curtis · Lake Havasu City, AZBuilt 1969 · S/N 18259656N7153EStec Inc · Seminole, TXNon-citizen corporation, flight hours not reportedBuilt 1959 · S/N 52153N7153GEricson Eric · St Charles, ILBuilt 1973 · S/N 15074618N7153MKeel Jeffrey A · Fort Myers, FLBuilt 1958 · S/N 55453N7153TBarlow Ephraim · Hyde Park, UTS/N 46753N7154AKim Sungtae · Los Angeles, CABuilt 1956 · S/N 29254N7154DChick Theodore D · Beulah, NDBuilt 1972 · S/N 21059520N7154FFenton Richard Trustee · Mckinleyville, CABuilt 1966 · S/N 15063754N7154GJuranich William M · Kent, WAS/N 17258854N7154MTandberg Eric · Kent, WABuilt 1958 · S/N 55454N7154SAlexander Aviation LLC · Ellisville, MSBuilt 1967 · S/N 15067854
Back to AD 79-10-14 R1