OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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.

N4321JN51343 LLC · Newnan, GABuilt 1967 · S/N 28-22695N4321QW H Flying Club Inc · Kingston, MIS/N 17260221N43221Bednarz Joseph P · Hendersonville, TNBuilt 1974 · S/N 28-7405181N43224Piper Aviation LLC · Tierra Verde, FLBuilt 1974 · S/N 28-7425346N4322GMid Atlantic Air Museum · Reading, PABuilt 1971 · S/N 032N4322JDougherty Joseph P · Hughesville, PABuilt 1967 · S/N 28-22696N4322XManitowoc Flyers Corp · Manitowoc, WIBuilt 1975 · S/N 28-7690015N4322ZLee Gerald R · Glennallen, AKBuilt 1968 · S/N 18-8636N43232N43232 LLC · Orange, TXBuilt 1974 · S/N 28-7415450N43234Level Up Aviation LLC · Newton, ALBuilt 1974 · S/N 28-7415451N4323QWausau Flying Service Inc · Wausau, WIBuilt 1971 · S/N 17260223N4323RMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263076N4323XRegistered aircraftBuilt 1975 · S/N 28-7690016N4323ZDubious Adventures LLC · Big Lake, AKS/N 18-8638N43240O'Quinn Kayla M · Jesup, GABuilt 1974 · S/N 28-7405182N43241Atmospheric Vehicle & Spacecraft Flight Exploratio · Rch Palos Vrd, CAS/N 28-7425349N43243Gomez Herbert · Holdenville, OKBuilt 1974 · S/N 28-7415453N43247Aircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 28-7415456N4324HTrott James E · Cathlamet, WAS/N 185569N4324JStaple K Aviation LLC · Queen Creek, AZBuilt 1967 · S/N 28-22699N4324RShadle James A Jr · Gig Harbor, WABuilt 1974 · S/N 17263077N4324ZBretts Spray Service Inc · Onida, SDFirst renewal noticeBuilt 1968 · S/N 18-8639N43257P23 LLC · Edmond, OKBuilt 1974 · S/N 28-7405183N4325FIreland David · Eatonville, WABuilt 1976 · S/N 28-7715017N4325JJpsc LLC · College Station, TXBuilt 1967 · S/N 28-22700N4325QBeier Mark E · Sylvania, GABuilt 1971 · S/N 17260225N4325RGaruda Aviation Inc · Miami, FLBuilt 1974 · S/N 17263078N4325TBledsoe Randell W · Springtown, TXBuilt 1971 · S/N 28-7205141N4325UMetro Aircraft Co · Bloomington, MNBuilt 1983 · S/N 28-8416016N4325VArcher Assoc LLC · Ashburn, VABuilt 1983 · S/N 28-8416017N43263Healey Terrance P · Redding, CABuilt 2005 · S/N 5014N43268Inter Global Aviation LLC · New Fairfield, CTBuilt 1974 · S/N 28-7415461N4326JHayes Barrett W · Siler City, NCBuilt 1967 · S/N 28-22701N4326LN4326l LLC · Senoia, GABuilt 1983 · S/N 28-8490015N4326NLikakis John M · Bennington, VTBuilt 1983 · S/N 28-8490017N4326QStar Fleet Aviation LLC · Bisbee, AZBuilt 1971 · S/N 17260226N4326ZSuchland Simon K · North Pole, AKBuilt 1968 · S/N 18-8643N4327ACasten Scot R · Vernonia, ORBuilt 1956 · S/N 22-3682N4327QFackler Aviation Services LLC · Clearwater, FLBuilt 1971 · S/N 17260227N43287Carlucci Peter M · Pittstown, NJBuilt 1974 · S/N 28-7415420N43289Prickett Terry L · Albertville, ALS/N 28-7415421N4328AHubert Matthew J · Fremont Center, NYBuilt 1956 · S/N 22-3683N4328JWeldon Thomas · Marysville, OHBuilt 1967 · S/N 28-22703N4328NTalker Albert · Stroudsburg, PABuilt 1983 · S/N 28-8416020N4328QBetzner John C · Medway, MABuilt 1971 · S/N 17260228N4328TWhite Mickey S · Hyrum, UTBuilt 1970 · S/N 28-26927N4328XWhitehair Donald N · Stevensville, MTBuilt 1946 · S/N 12144N4328ZWilmarth Rebecca C · Red Devil, AKBuilt 1968 · S/N 18-8646N43291Etheredge Mark · Pell City, ALBuilt 1974 · S/N 28-7415448N4329MByrne Matthew A · West Allis, WIBuilt 1983 · S/N 28-8490021
Back to AD 80-04-03 R2