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.

N931CELinke John H · Norfolk, NES/N 1502524CEN931JBPyxis Volare LLC · Winter Garden, FLBuilt 1997 · S/N 20328N931MSColeman Aviation LLC · Livingston, TNBuilt 1968 · S/N 17257349N931PKBewley Corey T · Midlothian, TXBuilt 1995 · S/N 3484N931RGScates Gregory B · Melba, IDBuilt 1995 · S/N 21002N931SHDodson International Parts Inc · Rantoul, KSBuilt 2005 · S/N 3890N931ZMason Fred B · Waterford, OHBuilt 1968 · S/N SE-1N9320HPlane Tail LLC · Bethany, CTBuilt 1975 · S/N 17266085N9320MMoreau Donald G · Dayton, TXBuilt 1966 · S/N 1252N9321CBas Part Sales LLC · Greeley, COBuilt 1978 · S/N 28R-7837191N9321DNiec Casmier M · Clio, MIFirst renewal noticeBuilt 1958 · S/N 22-6334N9321JR Goldburg LLC · Gastonia, NCBuilt 1966 · S/N 28-3414N9322DHitchcock Mark J · Scottsdale, AZBuilt 1958 · S/N 22-6335N9322JZollitsch Allan P · Lancaster, NYBuilt 1966 · S/N 28-3415N9322RNickname LLC · Scappoose, ORBuilt 1993 · S/N 2311N9323ESchock Richard F II · Peoria, ILBuilt 1979 · S/N 17272226N9323JDaissaoui Anouar · Quincy, MABuilt 1966 · S/N 28-3416N9324DRegistered aircraftBuilt 1958 · S/N 22-6337N9324JAdbdelsalam Moustafa · Buena Park, CABuilt 1966 · S/N 28-3417N9324KBellew Philip H · Gadsden, ALBuilt 1976 · S/N 28-7690243N9325VJaa Holdings LLC · Springfield, ILS/N 690096N9326DAll Seasons Aviation LLC · Laredo, TXBuilt 1982 · S/N 172RG1122N9326EWest Bend Air Inc · West Bend, WIBuilt 1979 · S/N 17272228N9326YHand 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-7816463
Back to AD 80-04-03 R2