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.

N517TGMcdonald Richard Reid · Rock Island, WAS/N 18517N517WPenell Mark A · Palmetto, FLBuilt 1949 · S/N 15255N5180Allen Michael G H · Casper, WYBuilt 1961 · S/N 18051077N51800Southeastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281101N51804Summit Aviation Inc · Belgrade, MTBuilt 2009 · S/N 172S10898N5180AWarmack Holdings LLC · Englewood, FLBuilt 1956 · S/N 28180N5180EMission Aviation Training Academy · Arlington, WABuilt 1959 · S/N 50480N5180FUnited States Air Force Owner · Hanscom Afb, MABuilt 1965 · S/N 17253108N5180RMacdonald Kaitlyn · Dillon, MTS/N 17263397N5180UAssociation Of Baptists For World Evangelism Inc · Harrisburg, PABuilt 1964 · S/N 206-0180N51816Barr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281120N5181ASoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281102N5181BSoutheastern Oklahoma State University · Durant, OKBuilt 2002 · S/N 17281103N5181DSchrick Robert B · Firth, NEBuilt 1958 · S/N 51281N5181EMustang Sally Aviation LLC · Camden, SCBuilt 2002 · S/N 172S9058N5181HRegistered aircraftBuilt 1975 · S/N 17265363N5181NValiair Lc Trustee · Casper, WYBuilt 1980 · S/N 18267562N5181REdelen Daniel R · Clayton, NCBuilt 1974 · S/N 17263398N5181VWarden Stephen M · Sugar Land, TXBuilt 2002 · S/N 18281102N51827B D Aviation LLC · Sauget, ILBuilt 2002 · S/N 17281108N5182AIasco Flight Training Inc · Redding, CABuilt 2002 · S/N 17281106N5182DJensen Rodney H · South Jordan, UTS/N 51282N5182ERegistered aircraftBuilt 1978 · S/N 17271756N5182FAmerican Flight Museum Inc · Topeka, KSBuilt 1965 · S/N 17253116N5182HVanderpool Robert W · Red Devil, AKS/N 18503326N5182RHalf Wagon Innovations LLC · Cresson, TXBuilt 2000 · S/N 18280707N51832Southern Aircraft Consultancy Inc Trustee · Casper, WYS/N 17274357N5183ENashville Flight School LLC · Nashville, TNS/N 17271757N5183RThompson Aerial Service Inc · Wyndmere, NDBuilt 1974 · S/N 17263400N51840Sky Bubble LLC · Santa Ana, CABuilt 1980 · S/N 17274359N5184EStringfellow Timothy C · Maryville, TNBuilt 1978 · S/N 17271758N5184FScott Alan M · Othello, WABuilt 1965 · S/N 17253124N5184GSicking Ryan · Gainesville, TXBuilt 2002 · S/N 18281104N5184JRiverside Flight Academy LLC · Riverside, CAS/N 17273721N5184PBarr Air Patrol LLC · Mesquite, TXBuilt 2002 · S/N 18281105N5185ACardan Aircraft Services Inc · Red Bluff, CAS/N 28185N5185DMartinez Richard Christian · Stockbridge, MIS/N 17272441N5185UMoyer Aviation Inc · Tobyhanna, PABuilt 2002 · S/N 172S9059N5185YPiedmont Flight Inc · Winston Salem, NCBuilt 2002 · S/N 172S9060N51864Zita Air LLC · Lewisburg, PABuilt 1980 · S/N 17274361N51865Savage Michael B · Lincoln, CABuilt 1981 · S/N 17274362N5186ATengwall Kevin A · Watford City, NDS/N 28186N5186HPope Brian B · Coalgate, OKBuilt 1975 · S/N 17265365N5186UHumphrey Jeffrey · Corvallis, MTBuilt 1964 · S/N 206-0186N51871Az2026 LLC · Miami, FLBuilt 1980 · S/N 17274366N51875Wings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 17274369N5187AHada Benjamin · Andrews, TXBuilt 2002 · S/N 18281111N5187DHonnold Thomas M Jr · Cascade, IDS/N 51287N5187ENowak Michael J · Waxahachie, TXBuilt 1978 · S/N 17271760N5187GThompson Edward A · Sunset Beach, NCBuilt 1979 · S/N 17273555
Back to AD 79-10-14 R1