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.

N912PABird Acquisition LLC · Phoenix, AZBuilt 1999 · S/N 2843302N912TCWiltrout Boyce W · Colorado Springs, COBuilt 1997 · S/N 23301N912VWThomas David A · Halifax, MABuilt 1968 · S/N 17700859N912YAChewelah Flyers · Chewelah, WAS/N 17264195N9131DDupuis Alex R · Wasilla, AKBuilt 1958 · S/N 18-6512N9131HStroemsuik Kristian · Strasburg, VAS/N 17265962N9131KThompson Flying Club Inc · New Cumberland, PABuilt 1976 · S/N 28-7690220N9132JPortneuf Holdings LLC · Chubbuck, IDBuilt 1966 · S/N 28-3182N9132KMcwhorter Mark Edward · Flower Mound, TXBuilt 1976 · S/N 28-7690221N91338Kejair LLC · San Francisco, CABuilt 1985 · S/N 28-8616008N9134HRegistration Pending · Kalispell, MTRegistration pendingS/N 17265964N9134JRolsing Steve Patrick · Saint Peters, MOBuilt 1966 · S/N 28-3185N9134LSipes Greg A · North Pole, AKS/N 310-71N9134YParis Air Inc · Vero Beach, FLBuilt 1985 · S/N 28-8616010N9135JSwaz Aviation LLC · Mesa, AZS/N 28-3186N9136DRegistered aircraftBuilt 1958 · S/N 18-6522N9136RHalderman Floyd Jr · Eldon, MOBuilt 2000 · S/N 23389N9136VDaniels Jeff W · Athens, GAFirst renewal noticeBuilt 1969 · S/N 690022N9137HPilots Flying School LLC · Englishtown, NJBuilt 1975 · S/N 17265966N9137JYuma Piper Fliers · Yuma, AZBuilt 1966 · S/N 28-3190N9138HMojo Flight Group LLC · Gainesville, GABuilt 1975 · S/N 17265967N9139TBoss Peter J · Bruce, WIBuilt 1968 · S/N M-1155N913CSSeaman Bruce M · Mohave Valley, AZBuilt 2021 · S/N 71112N913CVMansfield Douglas M · East Gull Lake, MNBuilt 2002 · S/N CV-3N913FBrooks Benjamin · Little Rock, ARBuilt 1991 · S/N 1801N913LKKeller Logan · Vale, ORBuilt 2021 · S/N 70MN913MSCukovic Naim · Portsmouth, NHBuilt 1976 · S/N 28-7715094N913TGThomas Home Center Inc · Sheridan, ORBuilt 1985 · S/N 28-8616011N914Daiber Marcus · Jefferson, GABuilt 1972 · S/N 388HN9140DLee Gerald R · Glennallen, AKBuilt 1958 · S/N 18-6529N9140JKeller Michael A · South Lake Tahoe, CABuilt 1966 · S/N 28-3194N9140TKay Aviation LLC · Merritt Island, FLBuilt 1968 · S/N M-1156N9141JArvizu Alberto P · Lake Havasu, AZS/N 28-3195N9141RInternational Air Services Inc Trustee · Carson City, NVBuilt 1988 · S/N 1323N9141VFlitton Mark S · Enterprise, ALS/N 690010N9142JKormash John A · Edgewater, FLBuilt 1966 · S/N 28-3196N9142KSwales Michael K · Harrisville, MIBuilt 1976 · S/N 28-7615177N9143DHellberg Farms LLC · Lowden, WAS/N 18-6533N9143JN9143j LLC · Fort Wayne, INBuilt 1966 · S/N 28-3197N9143VCrazy Mountain Cub LLC · Helena, MTBuilt 1988 · S/N 1809002N9144TShiflett Philip B · Marietta, OHBuilt 1985 · S/N 28-8690029N9145JBonertz Brian J · Muscatine, IAS/N 28-3200N9145VRoe Cameron · Salt Lake City, UTBuilt 1969 · S/N 690011N9146DSmith Paul G · Wasilla, AKBuilt 1958 · S/N 18-6536N9146JSwarey Steven · Whiteville, TNBuilt 1966 · S/N 28-3201N9146KBartlett Jesse Charles · Henderson, NVBuilt 1976 · S/N 28-7615178N9146LMalone Aaron E · Wasilla, AKS/N 812-71N9146VWood David Allen · Conyers, GABuilt 1969 · S/N 690025N9148JNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1966 · S/N 28-3203N9148SBlue Skies Aviation LLC · Holland, MIS/N MB-787
Back to AD 80-04-03 R2