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.

N8713TMoreau Darlene A · Penrose, COS/N 52613N8713XLentz Walter E · Duncan, OKBuilt 1961 · S/N 18253113N8714TPittman Stuart P · Palisade, COBuilt 1960 · S/N 52614N8714XFrancis Rocky D · Greeley, COBuilt 1960 · S/N 18253114N8715BSchultz John J · Kenai, AKS/N 36415N8715SAllen Thomas Page · Comer, GABuilt 1965 · S/N 15062015N8715ZMarconi Joseph · Hamilton, OHBuilt 1968 · S/N P206-0515N8716SBores Scott J · Huron, OHS/N 15062016N8716TManchester International LLC · Liberty Lake, WABuilt 1960 · S/N 52616N8716UWings Of Hope · Chesterfield, MOBuilt 1965 · S/N 17252620N8716XKempf Jerry J · Whitefish, MTS/N 18253116N8717BNorsic Michael · Parma, OHBuilt 1957 · S/N 36417N8717QState Of Alaska · Nome, AKBuilt 1979 · S/N 18503757N8717XStevens Matthew S · Penn Yan, NYBuilt 1960 · S/N 18253117N8717ZBoucher Kenneth G · Scotland, CTBuilt 1975 · S/N 18502901N8718UPuckett Matthew Scott · Argyle, TXBuilt 1965 · S/N 17252622N8719BSale Reported · Westerville, NESale reported, canceledS/N 36419N8719GRosso Anthony J · Wallace, NCS/N 15062819N8719ZFedane Rohit · Green Bay, WIBuilt 1968 · S/N P206-0519N871CPRedstone Arsenal Flying Activity · Redstone, ALBuilt 1999 · S/N 17280687N871EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13517N871FBFreebird Leasing Group LLC · Sarasota, FLBuilt 2024 · S/N 18283266N871PDJohnson Aircraft Leasing LLC · Springfield, ILBuilt 2000 · S/N 18280871N871TSSlad George W · Albuquerque, NMS/N 337-1172N8720THarris Todd D · Malta, IDBuilt 1960 · S/N 52620N8720XSparks Brian Elslie · Monmouth, ORS/N 18253120N8721SPruden Larry J · Louise, MSBuilt 1965 · S/N 15062021N8722BBuell Jack A · St Maries, IDBuilt 1957 · S/N 36422N8722QPrice Scott · Eagle Point, ORBuilt 1979 · S/N 18503758N8722TBarker Bruce L · Liberal, MOBuilt 1960 · S/N 52622N8722UBrown Stephen L · Charlotte, MIBuilt 1965 · S/N 172-52626N8723GEastham Gregory L · Columbia, KYBuilt 1966 · S/N 15062823N8723SCondor Aviation LLC · South Saint Paul, MNBuilt 1965 · S/N 15062023N8723UTraining Services Inc T/A · Virginia Beach, VABuilt 1965 · S/N 17252627N8724BMcmahon William · Westville, INS/N 36424N8724TStephens Nicholas C · Overgaard, AZS/N 52624N8724URonald O Holcomb LLC · Lapeer, MIBuilt 1976 · S/N 15077974N8725QN8725q LLC · Grand Junction, COBuilt 1976 · S/N U20603478N8725SKolis Joseph E II · Springfield, ILBuilt 1965 · S/N 15062025N8725UArklamiss Aviation LLC · Ruston, LABuilt 1965 · S/N 17252629N8725ZRomine George · Tucson, AZBuilt 1968 · S/N P206-0525N8726BEckles Phillip · Holdenville, OKBuilt 1957 · S/N 36426N8726GJacks Benjamin Scott · Chanute, KSBuilt 1966 · S/N 15062826N8726UHowell Harley L · Colville, WAS/N 17252630N8727GJstream Lc · Sheridan, WYBuilt 1966 · S/N 15062827N8727SMejia Jose Patricio · Meridian, IDBuilt 1965 · S/N 15062027N8727XWallis Aircraft Inc · Clifford Township, PABuilt 1960 · S/N 18253127N8727ZRobertson Reuben · Johnson City, TNBuilt 1968 · S/N P206-0527N8728XQualls Randy J · Claremore, OKBuilt 1960 · S/N 18253128N8729BChristian Melvin Lee Jr · Apison, TNBuilt 1957 · S/N 36429
Back to AD 79-10-14 R1