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.

N84125Koenig Aircraft Restoration Inc · Loranger, LABuilt 1969 · S/N 17258343N84129Petschow Kenneth W · Upland, CABuilt 1969 · S/N 17258344N8412CEiler Marc · Seattle, WAS/N 28-7690137N8412LAddison Flying LLC · Addison, NYBuilt 1968 · S/N 17256612N8412RChamberlain Richard T · Collinsville, ILBuilt 1966 · S/N 28-22289N8412WSutton Timothy A · Glencoe, ALS/N 28-2636N84130Gutierrez Sergio E · Pharr, TXBuilt 1969 · S/N 17258345N84133Registration Pending · Bowman, NDRegistration pendingS/N 17258347N8413LRussell Adam G · Easton, MES/N 17256613N8413RZuniga Hector Javier · Mission, TXBuilt 1966 · S/N 28-22290N8413WHollier Gregory J · Arnaudville, LABuilt 1965 · S/N 28-2637N8413YReinbold Frederick K · Anchorage, AKBuilt 1969 · S/N 18-8858N84140Kaiser Joe E · Anchorage, AKBuilt 1969 · S/N 17258351N84141Registration Pending · Mansfield, OHRegistration pendingBuilt 1969 · S/N 17258352N84143Jones Donald T · Barrigada, GUS/N 17258353N84146Stone Air LLC · Carrollton, GABuilt 1969 · S/N 17258354N84147Cox James O II · Shady Shores, TXBuilt 1969 · S/N 17258355N8414FPenley Robert G · Corinth, TXBuilt 1976 · S/N 28-7725111N8414LMorris Christopher J · Manor, TXBuilt 1968 · S/N 17256614N8414M8414m LLC · Nunica, MIBuilt 1981 · S/N 28-8190276N8414NAirlake Aero Inc · Lakeville, MNBuilt 1981 · S/N 28-8190278N8414RVick Justin M · Morton Grove, ILBuilt 1966 · S/N 28-22291N8414WOhmacht Carlton J · Glenwood, MNBuilt 1965 · S/N 28-2638N8414YLone Oak Aviation LLC · Greenville, NCBuilt 1981 · S/N 28-8190279N84151Sanders George W · Cloverdale, INBuilt 1969 · S/N 17258358N84153Spirit Air Inc · Salmon, IDBuilt 1969 · S/N 17258360N8415RMahanna John A · Radcliff, KYBuilt 1966 · S/N 28-22348N8415YSchwend Brian · Forsyth, MTBuilt 1969 · S/N 18-8859N84162Crosswind Aviation Of Oklahoma LLC · Stillwater, OKBuilt 1969 · S/N 17258362N84169Roach Gene T · Frankfort, KYS/N 17258363N8416JEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1983 · S/N 0359N8416RExpert Staffing West Inc · Ramona, CABuilt 1966 · S/N 28-22293N8416WCass Aviation LLC · North Las Vegas, NVBuilt 1965 · S/N 28-2642N84170Follmer Todd F · Dunwoody, GABuilt 1969 · S/N 17258364N84176Brandywine Flight School · West Chester, PABuilt 1981 · S/N 28-8116275N8417CDolan Joseph B · Baltimore, MDBuilt 1976 · S/N 28-7625114N8417JAtkinson Joseph M · Phoenix, AZBuilt 1980 · S/N VAC-159-80N8417YHighhouse Alan J · Honesdale, PABuilt 1970 · S/N 18-8861N84183Chickadee Aviation LLC · Burr Ridge, ILBuilt 1969 · S/N 17258368N84185Harrison Gene R · Pendleton, ORS/N 17258348N84186Gould George Jr · Bryantville, MABuilt 1969 · S/N 17258369N8418CWingman Aircraft Repair Inc · Lawrenceville, GABuilt 1976 · S/N 28-7615106N8418JBrown Jerry D · Rio Rancho, NMS/N VAC-164-80N8418RCarlsson Carl J · Mason City, IABuilt 1966 · S/N 28-22295N8418WMadison Mike · Pittsburg, TXBuilt 1965 · S/N 28-2644N84190Frs & Craig Llp · Byron, GABuilt 1969 · S/N 17258371N84193Smirnov Alexei · Fair Lawn, NJBuilt 1969 · S/N 17258372N84194Ultra Aviation LLC · Cedar Bluff, VABuilt 1969 · S/N 17258373N84195Norcal Flight Center LLC · Lincoln, CABuilt 1969 · S/N 17258374N8419CMarsh Geoffrey E · Old Lyme, CTBuilt 1976 · S/N 28-7615107
Back to AD 80-04-03 R2