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.

N3VRMckinnon David C · Cornelia, GABuilt 1980 · S/N EE2N3VTFleming Stephen · Los Lunas, NMBuilt 1995 · S/N 21017N3WPHagar Kevin J · Skiatook, OKBuilt 1961 · S/N 1820N3XMSmith Michael K · Grass Valley, CABuilt 1996 · S/N B93F96N3YHarding Mike R · Ventura, CABuilt 1961 · S/N 1N3YRStone Charles Douglas · Cedarville, OHBuilt 1975 · S/N 18-7509113N3YSAdams Harry J · New Waverly, TXS/N 916N3ZRRegistered aircraftBuilt 1973 · S/N 1048N40005Williams Brian · Rhinebeck, NYBuilt 1977 · S/N 28-7716312N40006Kotwal Pramod · Bedford, MABuilt 1977 · S/N 28-7716314N40008Birkland Mitchell L · Lake Jackson, TXBuilt 1977 · S/N 28-7716317N4000MDonair LLC · Enid, OKBuilt 1962 · S/N M-90N4000ZAmstrup Jeremy T · Fairbanks, AKBuilt 1963 · S/N 18-7951N40015Wings Flying Club Inc · Sheperdsville, KYBuilt 1977 · S/N 28-7716319N40016Miller Aircraft Services Inc · Crookston, MNBuilt 1977 · S/N 28-7716320N40017Biro Of Chicago Inc · Chicago, ILBuilt 1977 · S/N 28-7716321N40019Registered aircraftBuilt 1977 · S/N 28-7716322N4001LRobinson Helicopter Co · Torrance, CABuilt 1990 · S/N 1331N4001ZPayne Ronald J II · Wasilla, AKBuilt 1963 · S/N 18-7952N40021Zieber Josh · Leesville, LAS/N 28-7716323N40023Stice Garrett · Summit, ARBuilt 1977 · S/N 28-7816002N4002KSummerskyz Inc · Urbana, ILBuilt 1990 · S/N 1390N4002ZTappen Farm Supply Inc · Tappen, NDBuilt 1963 · S/N 18-7953N40037Pars Avn Corp · Wilmington, DES/N 28-7816003N4003GButler Donald D · Petersburg, PABuilt 1990 · S/N 1459N4003TCorey Jason R · Meridian, IDBuilt 1968 · S/N M-1109N40042Volar Corp · El Cajon, CABuilt 1977 · S/N 28-7816004N40045Lawson William · Somerset, WIBuilt 1977 · S/N 28-7816006N4004NBrunkenhoefer Travis L · Lewisville, TXBuilt 1968 · S/N 680018N4004TBennett John G · Melbourne, FLBuilt 1968 · S/N M-1110N4004ZTiffany David J · Lyme, CTBuilt 1963 · S/N 18-7955N40057Hovnanyan Ari · Van Nuys, CABuilt 1977 · S/N 28-7716313N40058Johnson Cassandra · Temecula, CABuilt 1977 · S/N 28-7816007N4005ERmo Property Management LLC · Elkin, NCBuilt 1977 · S/N 18-7809016N4005ZMills Air Service Inc · Marstons Mills, MABuilt 1963 · S/N 18-7956N40060Marshall Loraine · Independence, KYBuilt 1977 · S/N 28-7816009N40062Kiwi Air Inc · Sausalito, CAS/N 28-7890003N40069Brown Willard Jr · Far Hills, NJS/N 28-7890170N4006MRegistration Pending · Wasilla, AKRegistration pendingBuilt 1947 · S/N 12-2883N4006ZGuisto Anthony Jl · Hood River, ORBuilt 1963 · S/N 18-7957N40070Penski Christopher E · Ocala, FLBuilt 1977 · S/N 28-7816012N4007ESimonson Gale J · Loring, MTBuilt 1977 · S/N 18-7809017N4007TThurmond Paul J · Huntley, MTBuilt 1968 · S/N M-1114N4007ZMcgeehan William F Jr Trustee · Marshfield, MOBuilt 1963 · S/N 18-7958N4008PViento LLC · Nashville, TNS/N 23-1483N4009PApplegate Ronald E · Rosamond, CABuilt 1958 · S/N 23-1484N4009TLake Gary M · Edmond, OKBuilt 1968 · S/N M-1116N4009ZJackson R Sherer · Hayes, SDBuilt 1963 · S/N 18-7960N400BGMakarounis John C · Albuquerque, NMBuilt 1990 · S/N 01-BGN400BMDufour William Anthony Jr · Bixby, OKBuilt 1991 · S/N 10038
Back to AD 80-04-03 R2