OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,394

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-03-R2')
    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-03-R2')
  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.

N95CHJones Cecil W · Fort Walton Beach, FLBuilt 2020 · S/N 80956N95CJSimmons Marshall · San Antonio, TXBuilt 1960 · S/N TD-334N95CPGates Thomas S · Moyock, NCBuilt 1976 · S/N 17265896N95DLOwen Jayson S · Tampa, FLBuilt 1960 · S/N TD-418N95EGNelson Gregory E · Austin, TXS/N 636-320-381FBN95GWSkypirate Aviation LLC · Staunton, VABuilt 1995 · S/N 21373N95HDGreffenius Brian J · Covington, LABuilt 1995 · S/N 1255N95JALane Christopher C · Dallas, TXBuilt 1979 · S/N 172RG0015N95JPKeller Justin Allen · Youngstown, FLBuilt 1973 · S/N 28-7305429N95MMManley Marvin W · Camp Verde, AZBuilt 1998 · S/N 60035N95QLoftis Philip D · Buckhannon, WVBuilt 1975 · S/N 28-7515408N95RSpence Justin A · Memphis, TNFirst renewal noticeBuilt 1967 · S/N OAS-1N95RWColberg Stefan D · North Bend, ORS/N I-AN95SHReady Aim Flyer LLC · New Castle, DEBuilt 1957 · S/N TD-21N95WPPercival Wilhelm F · Las Vegas, NVBuilt 1987 · S/N 1995LN95YWhite Tavis · Huntsville, ALBuilt 1964 · S/N TD-604N96009Loera Arnold · Dillingham, AKBuilt 1990 · S/N 1124N9600JCox Grant L · Moses Lake, WABuilt 1989 · S/N 1118N9600SHargrove Tom R · Coffeyville, KSBuilt 1966 · S/N 2N9600UUniversity Of Oklahoma · Norman, OKBuilt 1978 · S/N 28-7816505N9601DRiffle David T · Woodinville, WABuilt 1958 · S/N 22-6510N9601JGevers Robert L · Lafayette, INBuilt 1966 · S/N 28-3747N9601QSteel Aviation Inc · Walnut Cove, NCBuilt 1975 · S/N 17265686N9602BLaguna Verde Leasing Inc · Wilmington, DES/N 172RG0912N9602SKrepfl Martin J · Colorado Springs, COBuilt 1965 · S/N 50N96033Sullivan Leo W · O Fallon, ILBuilt 1990 · S/N 1127N9603DHeartland Aviation Inc · Alliance, NES/N 22-6512N9603FWylie Aviation LLC · Boise, IDBuilt 1989 · S/N 1121N9603QConnecticut Flyers Inc · Madison, CTBuilt 1975 · S/N 17265688N9603WMoore Alan Ray · Glenwood, ARBuilt 1967 · S/N 28-23055N96042Aeropaint LLC · Wylie, TXBuilt 1990 · S/N 1138N9604QStevens Joel N · Monticello, ARBuilt 1990 · S/N 1120N9604SFmco Promotions Inc · North Little Rock, ARS/N 25N96052Copp James E · Adin, CAS/N 1150N9605CA O G Aircraft Services LLC · Aberdeen, NJBuilt 1978 · S/N 28-7816502N9605DDirty Side Down LLC · Downers Grove, ILBuilt 1958 · S/N 22-6514N9605QBragan Ryan J · Dunedin, FLBuilt 1975 · S/N 17265690N9605RStieglitz Jeffrey B · Firth, IDBuilt 1990 · S/N 1143N9605VBrookhart Brent Robert · Anaconda, MTBuilt 1990 · S/N 1144N9605ZBorror Kevin Bruce · Grants Pass, ORBuilt 1990 · S/N 1147N9606DNiemi Danny L · Osage, MNS/N 22-6516N9606SMix Timothy R · Hubbard, ORS/N 43N9606WMandolesi Daniel Martin · Hulmeville, PABuilt 1967 · S/N 28-23059N9607CLmc Aviation LLC · Goleta, CABuilt 1978 · S/N 28-7890429N9607DRomo Mark A · Dillingham, AKBuilt 1958 · S/N 22-6517N9607HTwin Oaks Airpark Inc · Hillsboro, ORFirst renewal noticeBuilt 1975 · S/N 17266260N9607RJohnston Bradley G · Ossining, NYBuilt 1959 · S/N TD-290N9607TPeterson Bradley E · Williston, NDBuilt 1990 · S/N 1134N9607WK-9 Handler LLC · Henderson, NVBuilt 1967 · S/N 28-23060N96088Griffith Kruz S · Bakersfield, CABuilt 1990 · S/N 1151
Back to AD 79-10-03 R2