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.

N2531RMaierhoffer Henry F Jr · Sylvania, GAS/N 28-5642N2531YPremier Aviation LLC · Sioux Falls, SDBuilt 1985 · S/N 28-8590083N2532PRiley Mitchell C · Seattle, WABuilt 1955 · S/N 22-2895N2534PPearson Vincent N · Broken Bow, NES/N 22-2897N2535FBryan Michael R · Brownfield, TXBuilt 1965 · S/N 7GCAA-33N2536EEarle James K · Argonia, KSBuilt 1959 · S/N 22-6816N25386Fairview Farms Inc · Poteau, OKBuilt 1985 · S/N 28-8590088N2539GTpt Aviation LLC · Caseville, MIBuilt 1979 · S/N 38-79A0550N253AMiller Christopher T · Newnan, GABuilt 1956 · S/N 23-806N253BLewis Donald L · Brant Lake, NYBuilt 1957 · S/N 13N253RAReynolds Darryl G · Wills Point, TXBuilt 1981 · S/N 17274790N253SWBatts David · Lyons, COBuilt 1965 · S/N 28-2328N253TPLeblanc John David · Deland, FLFirst renewal noticeBuilt 1987 · S/N 253N253WMLambert Timothy Allen Jr · Burleson, TXBuilt 1964 · S/N 28-2026N254Russell Dale Christopher · Sierra Vista, AZBuilt 1978 · S/N AA5B0970N2540FMcguires Flying Service LLC · Obion, TNBuilt 1965 · S/N 96N2540PReed Michael D · Parsons, KSBuilt 1955 · S/N 22-2903N2540QAmt Aero Inc · Massapequa, NYBuilt 1977 · S/N 28-7790404N2541SLanning Danny E · Alzada, MTBuilt 1979 · S/N 18-7909156N2543URegistered aircraftBuilt 1979 · S/N 28-8090055N2544PCoonfield Russell Adam · Fayetteville, ARBuilt 1955 · S/N 22-2907N2544SSunrise Adventures LLC · Stillwater, MNBuilt 1979 · S/N 18-7909155N2545PMatter Steven S · Joliet, ILFirst renewal noticeBuilt 1955 · S/N 22-2908N2545UMcmahon Patrick S · San Antonio, TXBuilt 1979 · S/N 28-8016032N2546CRaby Byrd J · Normandy, TNBuilt 1954 · S/N 26190N2546PDadez Jaime G · Browntown, WIS/N 22-2910N2546UL00 Fliers LLC · Lewes, DEBuilt 1979 · S/N 28-8016033N2546ZClark Brent R · Layton, UTBuilt 1977 · S/N 998-77N25471Cottingham Lon W · Kingwood, TXBuilt 1940 · S/N 1N2547HThree S Ranch · Blanca, COBuilt 1979 · S/N 18-7909198N2547QLawrence Thomas C · Memphis, TNBuilt 1977 · S/N 28-7725200N2547ZLecompte Francesca · Lancaster, MABuilt 1978 · S/N 261-78N2548QChristian Keith · Lighthouse Point, FLS/N 28-7716110N2549PLyons Andrew J · Mansfield, MABuilt 1955 · S/N 22-2913N2549QFly Legacy Planes LLC · Philadelphia, PABuilt 1977 · S/N 28-7716111N254AZShook Scott R · Gilbert, AZBuilt 2013 · S/N 72102N254BAas LLC · Ovid, MIBuilt 1957 · S/N 14N254KMFowler Michael J · Golden Valley, MNBuilt 1968 · S/N 17701076N254PDN22154 Inc · Wilmington, DEBuilt 2004 · S/N 3271N254RAReynolds Darryl G · Wills Point, TXBuilt 1975 · S/N 17265910N254RVDecamp Larry R · Clinton, INBuilt 2024 · S/N 4163N254SHTexxon Resources Inc · Winter Park, FLBuilt 1997 · S/N 24259N2550BSouthern Utah University · Cedar City, UTS/N 0611N2550MEarthcom Inc · Williamston, MIBuilt 1977 · S/N 28-7816292N2550YPramik Thomas J · Akron, OHBuilt 1985 · S/N 28-8516077N25511Gleason Randy H · Redding, CABuilt 1969 · S/N 28-25718N2551PLimoge Jerome P III · Colorado Springs, COBuilt 1955 · S/N 22-2915N2551UPizzuto Samuel J · Chamblee, GABuilt 1979 · S/N 28-8016034N2551ZHobson Simon · Eagle River, AKBuilt 1977 · S/N 999-77N2553WBrown Jeffrey B · Punta Gorda, FLBuilt 1965 · S/N 3265
Back to AD 80-04-03 R2