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.

N35143Premier Jets Inc · Hillsboro, ORS/N 17702229N3514KHollan Charles J · Columbia Station, OHBuilt 1967 · S/N 28-23601N3514QReed Daniel E · Wentzville, MOBuilt 1973 · S/N 17261659N35151Aac Leasing LLC · North Ferrisburgh, VTBuilt 1975 · S/N 17702235N35158Pearce Henry J · New Baltimore, MIBuilt 1975 · S/N 17702238N35163Eagle Sky Patrol Inc · Deadwood, SDBuilt 1975 · S/N 17702239N35165N35165 LLC · Starkville, MSBuilt 1975 · S/N 17702241N3516KSteitz John III · Antioch, ILS/N 28-23602N3517PSmith Mark A · Bowling Green, KYBuilt 1946 · S/N 12-374N3517ZMeyers Carl A · Salem, CTBuilt 1960 · S/N 22-7414N35185Stephens Brian A · Bruceville, INBuilt 1975 · S/N 17702252N35186Mucci Eileen F · Wolcott, CTBuilt 1975 · S/N 17702253N35191West Monte D · Coldspring, TXBuilt 1975 · S/N 17702255N35192Huffman Robert V · Washington, DCBuilt 1975 · S/N 17702256N35193Mccormack Duncan M · Sunfield, MIS/N 17702257N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261N3519ZSprott Robert L · Perkins, OKBuilt 1960 · S/N 22-7418N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918N351GSKukowski Matthew P · Wheatland, WYBuilt 2000 · S/N 80713N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263N3520PWidner Jack A · Stanley, NCBuilt 1955 · S/N 22-3274N3520ZWaldo Charles N · West Ossipee, NHBuilt 1960 · S/N 22-7420N35211Ballester Alexis R · Mayaguez, PRBuilt 1975 · S/N 17702267N35213Aviation Adventure LLC · Munster, INBuilt 1975 · S/N 17702268N35218Chessare Gary M · Caledonia, ILBuilt 1975 · S/N 17702270N35219Nelson Laurel L · Renton, WABuilt 1975 · S/N 17702271N3521MNationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816350N3521PJet Jam LLC · Layton, UTBuilt 1955 · S/N 22-3275N35220Spoor John B Jr · Sandwich, ILBuilt 1975 · S/N 17702272N35225Nguyen Ricky L · Honolulu, HIS/N 17702275N3522EKilgore William B · Eureka, CAS/N 17271572N3522KAsap Realty LLC · Stroud, OKS/N 28-23608N3522PBurling Daniel J DBA · Warsaw, NYBuilt 1955 · S/N 22-3276N3522QRamirez Jose Marcos · Casa Grande, AZBuilt 1973 · S/N 17261661N35238Williams E E · Atlanta, GABuilt 1975 · S/N 17702283N3523MMichigan Seaplane LLC · White Lake, MIBuilt 1947 · S/N 12-2369N3523PAdair Lawrence L Jr · Fountain Run, KYBuilt 1955 · S/N 22-3277N3523QRed Crest Aviation LLC · Columbus, OHBuilt 1975 · S/N 17702278N35242Dlss Inc · Caro, MIBuilt 1975 · S/N 17702286N35244Richardson Barry T · Butler, TNBuilt 1975 · S/N 17702288N35247Dwyer John R · Orange Park, FLBuilt 1975 · S/N 17702289N3524PRichard Waldren LLC · Newberg, ORBuilt 1955 · S/N 22-3279N3524QRegistered aircraftBuilt 1977 · S/N 28-7790462N3524ZRehmel Robert S · Liberty, INBuilt 1960 · S/N 22-7427N35259Gately Brian P · Brooklyn, NYBuilt 1975 · S/N 17702293N3525ZCollier Ronald O Trustee · Seymour, TNBuilt 1960 · S/N 22-7428N35262Aerial Photos Of New Jersey LLC · Clinton, NJBuilt 1975 · S/N 17702296N35264B&L Aviation LLC · Villa Rica, GABuilt 1975 · S/N 17702297N3526KCooke Canyon C · Marana, AZBuilt 1967 · S/N 28-23606
Back to AD 80-04-03 R2