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.

N9326YHand Timothy P · Osage Beach, MOBuilt 1960 · S/N TD-443N9328JRegistered aircraftBuilt 1966 · S/N 28-3422N9329JBradford Earl · Fairview, MIFirst renewal noticeBuilt 1966 · S/N 28-3423N932AZN932az LLC · Miami, FLBuilt 1986 · S/N 17276586N932FSAviation Equipment Co LLC · Lincoln, NES/N 44-7995018N932PRoss Brian D · Northfield, ILBuilt 2002 · S/N 3806N932SHBuell Travis W · Harper, TXBuilt 2005 · S/N 3899N9330BCarpenter Michael R · Wasilla, AKBuilt 1959 · S/N 55130N9330JTinaga Resorts Corp · San Angelo, TXS/N 28-3424N9331JSkysight Consulting LLC · Memphis, TNBuilt 1966 · S/N 28-3428N9331VMartin Edward J · Poplar Grove, ILBuilt 1969 · S/N 700002N9332DMartin Clint R · Escondido, CABuilt 1958 · S/N 22-6352N9332JKnutson Wayne R · Thompson, NDBuilt 1966 · S/N 28-3429N9333JRau Alan · Java, SDBuilt 1966 · S/N 28-3430N9333MMalaka Air LLC · Bradenton, FLBuilt 1966 · S/N 1265N9334CBadzinski James P · Roseville, MNBuilt 1978 · S/N 28-7816461N9334HFree State Flying Club · College Park, MDBuilt 1975 · S/N 17266092N9335SKeep Climbing LLC · Las Vegas, NVS/N M-1642N9336DSitta Donald C · Farmington, NMS/N 22-6356N9337CLovett Zachary · Fort Worth, TXBuilt 1978 · S/N 28-7816462N9337DNantz William G Jr · Raleigh, NCBuilt 1958 · S/N 22-6357N9337EMarianas Air Transfer Inc · Saipan, MPBuilt 1979 · S/N 17272230N9337HLorraine'S Blue Sky Aviation LLC · Norman, OKBuilt 1975 · S/N 17266095N9337JHudson Kenneth J · Caswell Beach, NCBuilt 1966 · S/N 28-3434N9337KSkyrise Aviation Corp · Pompano Beach, FLBuilt 1976 · S/N 28-7625176N9337SDalton Stephen P · Lewistown, PABuilt 1975 · S/N M-1655N9338CSmart4 LLC · Kissimmee, FLBuilt 1978 · S/N 28-7816463N9338HSchab Davis Maragaret A · Spangle, WABuilt 1975 · S/N 17266096N9338JCarr Shelby · Stevenson, ALBuilt 1966 · S/N 28-3435N9338SGentilin Glen R · Camino, CABuilt 1975 · S/N M-1643N9339JTruesdell Michael L · Tonopah, NVS/N 28-3436N9339VTechnical Education Services Inc · Virginia Beach, VABuilt 1969 · S/N 700005N933BKKreul Robert W · Waconia, MNBuilt 1971 · S/N 28-7225113N933CC27 Latitude LLC DBA · West Palm Beach, FLBuilt 1979 · S/N 28-7990503N933GYDemaria Steven M · Dacula, GAS/N 839N933TEBcaz Holdings LLC · Wilmington, DEBuilt 2002 · S/N 10212N933XAndrews Richard S III · Guilford, CTBuilt 2005 · S/N 60515N9340JLovelace Mario · Coral Springs, FLBuilt 1966 · S/N 28-3438N9341CMerlin Aviation LLC · South Saint Paul, MNBuilt 1978 · S/N 28-7890399N9341HAndreas Neil A · Yakima, WABuilt 1975 · S/N 17266099N9341SSantos Eric G · West Oneonta, NYBuilt 1975 · S/N M-1644N9341VAvalle Oscar A · Chicago, ILBuilt 1969 · S/N 700006N9342HGutierrez Ricardo · Downey, CABuilt 1975 · S/N 17266100N9342JDeschepper Sandra K · Independence, MOBuilt 1966 · S/N 28-3440N9343DAva Aviation LLC · Tappan, NYBuilt 1982 · S/N 172RG1128N9343VFundora Joel A · Altamonte Springs, FLBuilt 1969 · S/N 700007N9344HBarnstormers Flying Club Inc · Pulaski, TNBuilt 1975 · S/N 17266102N9344JBiamonte Thomas John · Ventura, CABuilt 1966 · S/N 28-3442N9344LCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1986 · S/N 17276543N9344SScram Branden L · Fairbanks, AKBuilt 1975 · S/N MB-778
Back to AD 79-10-03 R2