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.

N7741GCaviness Dewayne · Chico, CABuilt 1970 · S/N 17259441N7741NBrindle Richard L · Pleasant Hall, PABuilt 1969 · S/N 28-5186N7742MGribble Ted · Paris, TXBuilt 1974 · S/N 20-0011N7742NDistler Robert · Northborough, MAS/N 28-5188N7742WDupont Micheal Rene · East Taunton, MABuilt 1964 · S/N 28-1751N7743DHann James M · Ballwin, MOBuilt 1957 · S/N 22-5422N7743NRegistered aircraftBuilt 1968 · S/N 28-5144N7743WAtigun Aviation LLC · Sheridan, WYBuilt 1964 · S/N 28-1752N7744TDickert Investments Holdings LLC · Cave Creek, AZBuilt 1968 · S/N 28-24073N7744WShotwell Michael · Dallas, GABuilt 1964 · S/N 28-1754N7745DSale Reported · Joseph, ORSale reportedBuilt 1957 · S/N 22-5425N7745GSuperhawk N7745g Owners' Group LLC · Bend, ORBuilt 1970 · S/N 17259445N7745NAppealing Adventures Inc · Canadensis, PABuilt 1968 · S/N 28-5189N7745WSchaff Investments LLC · Stone Mountain, GABuilt 1964 · S/N 28-1755N7746DDobson Garland J · Willow, AKBuilt 1985 · S/N 1N7746FWilliams Dwight J · Wichita, KSBuilt 1976 · S/N 28-7725105N7747GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259447N7747NShumock Jerry Ray · Moss Point, MSBuilt 1968 · S/N 28-5191N7747PBartley John H · Vassalboro, MEBuilt 1961 · S/N 24-2962N7747WFlying Family LLC · Orlando, FLBuilt 1964 · S/N 28-1757N7748DJagust William M · Troy, MOBuilt 1957 · S/N 22-5428N7748MLarson David · Klamath Falls, ORS/N 20-0012N7749DOakley Lance E · Conway, ARS/N 22-5429N7749FLohr Martin J · Petersburg, AKBuilt 1976 · S/N 28-7725106N7749NTeijeiro Edgar E Trustee · El Paso, TXBuilt 1968 · S/N 28-5194N774ACDarr Henry H · Drummond, MTBuilt 1997 · S/N 388-97N774GHarmon Larry · Springfield, OHS/N 001N774GAAircraft Resource Center Inc · Lakeville, MNBuilt 1978 · S/N GA7-0061N774HAExtreme Helicopter Service LLC · Alice, TXBuilt 1989 · S/N 1084N774JBJb Air LLC · Oakwood, GABuilt 2004 · S/N 1365-2004N774MGPs Aviation Inc · Jackson, MNS/N 17269250N774PCHarrell Brian · Auburn, ALBuilt 1973 · S/N 28-7405018N774PDTump Christopher · Hartland, WIBuilt 1968 · S/N 17701281N774RPDanny Buys LLC · San Antonio, TXBuilt 2000 · S/N 25205N774RVSlutz Gary J DBA · Beach City, OHS/N 2047N7750DCarruthers Matthew L · Charlotte Hall, MDBuilt 1957 · S/N 22-5430N7750GVitt Edward J · Sewell, NJBuilt 1970 · S/N 17259450N7751MM&M Aircraft LLC · Arnold, MOS/N 20-0013N7751WSmith Derek D · Portland, ORS/N 28-1719N7752NCote Daniel A · Montpelier, VTS/N 28-5197N7752WCavender John S · Centerville, MDBuilt 1964 · S/N 28-1728N7753GCw Enterprise LLC · Jewell Ridge, VABuilt 1970 · S/N 17259453N7753NSonner Michael J · Golden, COBuilt 1968 · S/N 28-5198N7753WNortheastern Oregon Flying Club Inc · La Grande, ORBuilt 1964 · S/N 28-1758N7754GRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1970 · S/N 17259454N7754NSan Juan Flyers Inc · Pagosa Springs, COBuilt 1968 · S/N 28-5201N7754WMartin Travis James · Gladewater, TXBuilt 1964 · S/N 28-1772N7755DWellborn Ralph Lee · Kenai, AKBuilt 1957 · S/N 22-5436N7755GSagori Aviation LLC · Orlando, FLBuilt 1970 · S/N 17259455N7755PBubak Land And Cattle LLC · Imperial, NEBuilt 1961 · S/N 24-2971
Back to AD 80-04-03 R2