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.

N714ETGrenie Arles A · Richland Center, WIBuilt 1976 · S/N 15079126N714EWBashore Barry A · Pleasant Hill, OHBuilt 1976 · S/N 15079129N714EYStevens Matthew S · Penn Yan, NYBuilt 1953 · S/N 25668N714EZSherrod Robert W Jr · Burleson, TXBuilt 1976 · S/N 15079132N714FDSolida Christopher · Bunker Hill, INBuilt 1976 · S/N 15079135N714FFAirgo Inc · Centralia, ILBuilt 1976 · S/N 15079137N714FGTraining Services Inc T/A · Virginia Beach, VABuilt 1976 · S/N 15079138N714FHPoliti Terris P · Lake Placid, NYBuilt 1976 · S/N 15079139N714FKSmokejumper Aviation LLC · Winthrop, WABuilt 1976 · S/N 15079141N714FMNorth Florida Flight School LLC · Tallahassee, FLBuilt 1976 · S/N 15079142N714FWPilot Rise Aircraft Holdings LLC · Fort Worth, TXBuilt 1976 · S/N 15079151N714GBBuchanan Michael Shane · Manchester, TNBuilt 1976 · S/N 15079155N714GDRose Robert J · Grosse Ile, MIBuilt 1976 · S/N 15079157N714GHStrauss Austin · Avon, OHBuilt 1976 · S/N 15079161N714GJOlson John W · Jackson, MNBuilt 1976 · S/N 15079162N714GKCashman Timothy J · Mercer Island, WAS/N 15079163N714GLHall Johnie S · Kingsland, ARBuilt 1976 · S/N 15079164N714GRStrine Russell A · Reading, PABuilt 1976 · S/N 15079169N714GUIrwin Roberta L · San Diego, CABuilt 1977 · S/N 15079172N714GYWilson William R · Halfway, ORS/N 15079176N714GZOrmond Aircraft Leasing & Management Inc · Ormond Beach, FLBuilt 1977 · S/N 15079177N714HBJ11 Air LLC · Dallas, TXBuilt 1977 · S/N 15079179N714HHPhelps Clay DBA · Santa Paula, CABuilt 1977 · S/N 15079185N714HKDent Kelly J · Locust Grove, GABuilt 1977 · S/N 15079187N714HLSlate Mitchell P · Colorado Springs, COBuilt 1977 · S/N 15079188N714HPTic Aerospace Inc · Miami, FLBuilt 1982 · S/N 172RG1123N714HRHendry Joshua R · Carthage, TNS/N 15079193N714HUSingh Paviter · Beavercreek, OHBuilt 1977 · S/N 15079196N714HVStrahan Sam · San Angelo, TXBuilt 1964 · S/N 15060890N714HWNational Training 1 LLC · Wilmington, DEBuilt 2005 · S/N 172S9855N714HYLeft Final LLC · Gastonia, NCS/N 15079199N714JMartinez Ivan · Oro Valley, AZBuilt 1977 · S/N 15079382N714JCAries Flyers Inc · Santa Clara, CABuilt 1977 · S/N 15079203N714JDGuthrie Bobby D · El Dorado, ARS/N 15079204N714JEAllred Mark · Farmington, UTBuilt 1983 · S/N 18504398N714JFMetcalf Christopher A · Meadowview, VABuilt 1977 · S/N 15079206N714JKDrouin Arnold R · Berlin, NHBuilt 1977 · S/N 15079210N714JLWestra Todd A · Ireton, IABuilt 1977 · S/N 15079211N714JPCp Aviation Inc · Santa Paula, CABuilt 1966 · S/N 15065030N714JQDepartment Of Marine Resources · Augusta, MES/N 18504399N714JTThompson John · Stevens Point, WIBuilt 1977 · S/N 15079217N714JXPiteck Timothy S · Battle Ground, WAS/N 15079221N714KEGustin Ralph P · New Smyrna Beach, FLFirst renewal noticeBuilt 1977 · S/N 15079228N714KHFlying Moose Alaska LLC · Clear, AKBuilt 1983 · S/N 18504400N714KKMcnally Robert H · Tulsa, OKS/N 15079233N714KMDavis Steven M · Eastsound, WABuilt 1977 · S/N 15079234N714KQBowser Dwight H · Anchorage, AKBuilt 1977 · S/N 15079237N714KRB2 W Corporation · Winona, MNBuilt 1977 · S/N 15079238N714KTCox Garry G · Coleman, TXS/N 15079240N714KUInsalaco Stephen C · Benson, AZS/N 15079241
Back to AD 79-10-14 R1