OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,472

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.

N3387TWarner Stephen DBA · Pleasantville, PABuilt 1967 · S/N 17700687N3387ZBlake Clark D · Belle Fourche, SDBuilt 1960 · S/N 18-7271N3388PMorrison Maria · Port Townsend, WABuilt 1958 · S/N 23-1351N3388TKing Eric J · Zillah, WABuilt 1967 · S/N 17700688N3389EBarnfather James D · Sequim, WABuilt 1978 · S/N 17271528N3389PLapeyrouse Charles L · Raceland, LABuilt 1958 · S/N 23-1352N3389ZTorgerson'S LLC · Ethridge, MTBuilt 1960 · S/N 18-7274N338BSMcnabb William B · Kingsport, TNBuilt 2002 · S/N 80310N338CALincoln Skyways Inc · Lincoln, CABuilt 1978 · S/N 17269465N338PMMarso Peter G · Decorah, IABuilt 2019 · S/N KA15081311N338QJones Thomas P · Quartz Hill, CABuilt 1971 · S/N 70N338RVSalvini John M · San Luis Obispo, CABuilt 2004 · S/N 80696N338TRChan John · Newport Coast, CABuilt 2021 · S/N 90108N338VHDevries Larry E · Pella, IABuilt 1993 · S/N 2300N3390TTucker Lon R · East Peoria, ILBuilt 1967 · S/N 17700690N3390XPrince Aviation LLC · Las Vegas, NVS/N 3385N3391EOcala Aviation Services Inc · Ocala, FLBuilt 1978 · S/N 17271529N3391RValiair Lc Trustee · Casper, WYBuilt 1969 · S/N 28-5668N3391XDunham Seth Aaron · Acampo, CABuilt 1966 · S/N 3386N3391ZThompson Michael M · Soldotna, AKBuilt 1960 · S/N 18-7276N3392REllsworth Steven C · Muscatine, IABuilt 1969 · S/N 28-5669N3393RBay Richard G · Sparks, NVBuilt 1969 · S/N 28-5672N3393TWilcox Russell J · Salinas, CABuilt 1967 · S/N 17700693N3393ZWilliams Shane · Union, ORS/N 18-7279N3394TPekrul Eric C · Frankfort, MIBuilt 1968 · S/N 17700694N3394ZNord Margie N Trustee · Cantwell, AKBuilt 1960 · S/N 18-7281N3396QRomanair Wdr Inc · Winder, GABuilt 1977 · S/N 28-7790455N3396XS R Gilliam Construction Inc · Carthage, NCS/N 3388N3396ZPineland Holdings LLC · Gibsland, LABuilt 1960 · S/N 18-7285N3397TMckinney Adrian R · Mineral Wells, TXBuilt 1967 · S/N 17700697N3398R3y3 Piper Group LLC · Saint Charles, IABuilt 1969 · S/N 28-5671N339AMills Scott I · Littleton, COBuilt 2005 · S/N 90493N339DLFriedrich Robin K · Houston, TXS/N 90206N339EEvans James W Jr · Wake, VABuilt 1985 · S/N 759N339ECBlackmore Marc A · Hilltop Lakes, TXBuilt 1977 · S/N 20017N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119N339TLeroux Todd C · Palmer, AKBuilt 1953 · S/N 18-2453N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784N33AWWeigle Alan B · Seward, NEBuilt 2001 · S/N 489N33CBShepperson Frank Lester · Midwest, WYBuilt 1958 · S/N 18-6682N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989N33CMCharley Ernie · Gakona, AKBuilt 1976 · S/N 18-7609082N33CRConstitutional Defense Arizona LLC · Scottsdale, AZBuilt 1977 · S/N 28-7725287N33CTThree Wing Flight School LLC · Stratford, CTBuilt 1977 · S/N 28-7890136N33DHHarrington David · Lake Saint Louis, MOBuilt 1966 · S/N MB-4N33DSAvion Ahoy LLC · Jacksonville, FLS/N 680176N33DVKostreva Adam · Riverton, WYBuilt 1970 · S/N 234-70N33ECMccammon Aviation LLC · Sullivan, INS/N 28-7225182N33ELAdvancing Blade LLC · Glenwood, MNBuilt 1992 · S/N 20770N33ERCrump Edward J · Boonton, NJBuilt 1978 · S/N AA5B0884
Back to AD 80-04-03 R2