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.

N8182ERed Arrow Aviation LLC · Santa Teresa, NMBuilt 1978 · S/N 17272148N8182UMorristown Flying Service Inc · Talbott, TNBuilt 1964 · S/N 17252082N8182ZWolf Richard Cory · Syracuse, UTBuilt 1963 · S/N 2050182N8183ARegistered aircraftBuilt 1952 · S/N 25035N8183FArvizu Jason Arthur Scott · Bakersfield, CABuilt 1966 · S/N 15064283N8183MHaman Peter A · Douglas, WYBuilt 1977 · S/N 21062033N8183THysell Donovan · Atwater, OHBuilt 1960 · S/N 17556883N8183UMacauley Richard D · Shingle Springs, CABuilt 1964 · S/N 17252083N8184BPalouse Aviation Holdings LLC · Moscow, IDBuilt 1957 · S/N 29984N8184GAspire Aviation LLC · Farmingdale, NYBuilt 1979 · S/N 17273615N8184LVanderlaan Dirk C · Reno, NVBuilt 1967 · S/N 17256384N8184TGraham Steven K · Mc Grath, AKBuilt 1960 · S/N 17556884N8185GJohnston John Lane · Houston, TXBuilt 1974 · S/N 18263337N8185SJanssen Christopher M · Manchester, IABuilt 1965 · S/N 15061785N8185VCryan Mark · Port Orange, FLBuilt 1974 · S/N A1500557N8185ZViele Mark C · Buckley, WABuilt 1963 · S/N 205-0185N8186BMid-Atlantic Aircraft Leasing LLC · Wilmington, DEBuilt 1957 · S/N 29986N8186LBolsover Douglas J Sr · Cameron Park, CAS/N 17256386N8186TBouton Vern H · Fairbanks, AKBuilt 1961 · S/N 17556886N8186ULake Area Technical College · Watertown, SDBuilt 1964 · S/N 17252086N8186ZBernard David John · Damascus, MDBuilt 1963 · S/N 205-0186N8187BWithers Hurchel W · Stone Mountain, GABuilt 1957 · S/N 29987N8187FCoady Michael J · Taylorville, ILBuilt 1966 · S/N 15064287N8187MMoose Eddy · Tyler, TXBuilt 1976 · S/N 18264556N8187SCounter Kevin · Windsor, CAS/N 15061787N8187TLawdawg Property Rentals LLC · Williston, NDBuilt 1961 · S/N 17556887N8187VNelson Brett R · Shoreview, MNBuilt 1974 · S/N A1500559N8188ZHzl Hanger LLC · Drums, PABuilt 1963 · S/N 205-0188N8189AEight Niner Alpha LLC · Eagle, IDBuilt 1952 · S/N 25041N8189FArchuleta Michelle L · Las Cruces, NMBuilt 1973 · S/N A1500455N8189GBeebe Brad A · Clinton, MOBuilt 1974 · S/N 18263341N8189XQuire Gregory L Sr · Shepherdsville, KYBuilt 1961 · S/N 17248689N8189ZMirage Mfg Co Inc · Gainesville, FLBuilt 1962 · S/N 205-0189N818ARLandsworth Corp · Monterey, CABuilt 2004 · S/N 18281430N818CPCivil Air Patrol · Maxwell Afb, ALBuilt 2003 · S/N 18281258N818EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2018 · S/N 172S12165N818EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2022 · S/N 172S12792N818HFlorez Oscar · Independence, KSBuilt 1958 · S/N 51548N818MLTurning Point Northwest LLC · Stanwood, WABuilt 1966 · S/N 15064017N818SPN818xp LLC · Charleston, SCBuilt 2001 · S/N 172S8734N8190LOlsen Curtis O · Lindon, UTS/N 17256390N8191FMoore Clayton P · Cayce, SCBuilt 1966 · S/N 15064291N8191GGroce James D · Portland, ORS/N 18263343N8191SStang Daniel Jr · Lindale, TXBuilt 1965 · S/N 15061791N8191TDavis Jonathan L · Pleasanton, CAFirst renewal noticeBuilt 1960 · S/N 17556891N8191UAnderson Amy J · Manistique, MIBuilt 1964 · S/N 17252091N8192BAll Sports Aviation LLC · Sandpoint, IDBuilt 1957 · S/N 29992N8192ESalerno Michael P · Pueblo, COBuilt 1974 · S/N 18502388N8192LSteinmetz William · Lakeville, INBuilt 1967 · S/N 17256392N8192TFranke Darren W · Yorktown, TXBuilt 1960 · S/N 17556892
Back to AD 79-10-14 R1