OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,471

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:80-04-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:80-04-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.

N9573LCrosetto Pierre F · Downey, CABuilt 1974 · S/N AA5-0573N9573SOppegard Nicholas D · Eagle River, AKBuilt 1966 · S/N 66N9573VReynolds Darryl G · Wills Point, TXBuilt 1974 · S/N 17264375N9573WPyxl Sky LLC · Cogan Station, PABuilt 1967 · S/N 28-23013N9574BHinds Community College · Bolton, MSBuilt 1981 · S/N 172RG0891N9574HJb III LLC · Stuart, FLBuilt 1975 · S/N 17266238N9574LRiederich John B · Huntington Beach, CABuilt 1974 · S/N AA5-0574N9574SKrejchik Daniel J · Portage, WIBuilt 1965 · S/N 14N9575JJones Anthony J · North Royalton, OHBuilt 1966 · S/N 28-3712N9575UBarnett Gary L · Bertram, TXBuilt 1975 · S/N AA5A-0075N9575VFurnari Alfio · Hutchinson Island, FLBuilt 1974 · S/N 17264377N9575WMike Flying Service LLC · Terrell, TXBuilt 1967 · S/N 28-23015N9576CMercer Paul A · Salida, CABuilt 1978 · S/N 28-7816497N9576JWright Jason C · Thorntown, INBuilt 1966 · S/N 28-3713N9576KClearwater Valley Aero Club Inc · Kamiah, IDBuilt 1976 · S/N 28-7615215N9577BRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1981 · S/N 172RG0894N9577DBerry Matthew G · Creedmoor, NCBuilt 1958 · S/N 18-6760N9577JBrown Dennis N · Bakersfield, CAS/N 28-3715N9577LSquire Barry H · Sarasota, FLBuilt 1974 · S/N AA5-0577N9577USoluserv LLC · Caldwell, TXBuilt 1975 · S/N AA5A-0077N9577VMdr Flying Inc Trustee · Wilmington, DEBuilt 1974 · S/N 17264379N9578BHalseth Harald E · El Paso, TXBuilt 1981 · S/N 172RG0895N9578JDesbien Paul D · Texhoma, OKBuilt 1966 · S/N 28-3716N9578LRegistration Pending · Hoover, ALRegistration pendingBuilt 1974 · S/N AA5-0578N9578POldenburg Scott J · Kasilof, AKS/N 18-7609156N9578UScheutzow David P · Medina, OHS/N AA5A-0078N9579CVan Winkle Steven Russell · East Berlin, PABuilt 1978 · S/N 28-7890425N9579DLee Gerald R · Glennallen, AKBuilt 1958 · S/N 186764N9579JGarrity Richard R · Green Bay, WIBuilt 1966 · S/N 28-3717N9579LJackson Richard B · Cambria, CABuilt 1974 · S/N AA5-0579N9579UBoland Kelly A · Fort Worth, TXBuilt 1975 · S/N AA5A-0079N957RVWilson Tyler J · Lynnwood, WABuilt 2009 · S/N 72608N957TEConlon Kevin P · Lake Geneva, WIBuilt 2004 · S/N 10236N957UMBecker Brian S · Portage, WIBuilt 1990 · S/N AG5B-10002N9580JFrontier Adventure Flyers LLC · Colorado Springs, COBuilt 1966 · S/N 28-3718N9580LBlack Carrell C · Cochranville, PABuilt 1974 · S/N AA5-0580N9580URogers Ronald G · Forest, VABuilt 1975 · S/N AA5A-0080N9580WDestination Flyer LLC · Memphis, TNBuilt 1967 · S/N 28-23025N9581SKing John D · Midland, VABuilt 1966 · S/N 192N9582DMontminy John · Berlin, NHBuilt 1958 · S/N 22-6489N9582HMiller Timothy · Saratoga, CABuilt 1975 · S/N 17266244N9582VCady Craig D · New Braunfels, TXBuilt 1974 · S/N 17264384N9582WBlomquist Kevin C · Kanab, UTS/N 28-23027N9583BBurke Larry Ryan · Pembroke, GABuilt 1981 · S/N 172RG0898N9583JTevik Michael A · Provo, UTBuilt 1966 · S/N 28-3722N9584B360 Marine · Bristol, RIBuilt 1981 · S/N 172RG0899N9584JLow Wing LLC · Upland, CABuilt 1966 · S/N 28-3723N9584VStick & Rudder Club Inc · Waukegan, ILBuilt 1974 · S/N 17264386N9584WMitchell Gary N · Kansas City, KSS/N 28-23030N9585DArnt James Robert Jr · Worthington, MNBuilt 1958 · S/N 22-6492
Back to AD 80-04-03 R2