OpenAirDocs.org
AD 80-26-04 R1

Registered aircraft · 1,267

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-26-04-R1')
    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-26-04-R1')
  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.

N4085PTango Bravo Aviation LLC · Taylorsville, MSBuilt 1959 · S/N 23-1563N4087PPankratz Laura M · Stroudsburg, PABuilt 1959 · S/N 23-1565N4088PBas Part Sales LLC · Greeley, COS/N 23-1561N4091PPaulay Sandor F · Kenmore, WABuilt 1959 · S/N 23-1570N4093PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1572N4094PShelley Isaac R · Scottsville, VABuilt 1959 · S/N 23-1573N4095PTorell Pamela O · Port Saint Lucie, FLBuilt 1959 · S/N 23-1574N40LWMorgan Aviation LLC · Oak Harbor, WABuilt 1975 · S/N 27-7554146N4100PValley Flying LLC · Stuarts Draft, VABuilt 1959 · S/N 23-1580N4102PDoran Jeffrey T · Westerville, OHBuilt 1959 · S/N 23-1582N4103PLumley John J · Delray Beach, FLBuilt 1959 · S/N 23-1583N4104PSpooter Air II LLC · Willis, TXBuilt 1959 · S/N 23-1584N4107PTm Aero Marine Inc · North Miami, FLBuilt 1959 · S/N 23-1562N4109AMarc Inc · Bolton, MSBuilt 1970 · S/N 27-4459N410RABradley Aviation Group LLC · Van Nuys, CABuilt 1979 · S/N 27-7954097N4121PRiggin Flight Service Inc · Madison, SDBuilt 1959 · S/N 23-1601N412LClark Terry E · Dixon, MOBuilt 1954 · S/N 23-18N4130PKoch William L · Barre, VTBuilt 1959 · S/N 23-1610N4133PCoulson Michael D · Zanesville, OHBuilt 1959 · S/N 23-1613N4136PN4136p LLC · Titusville, FLS/N 23-1617N4138PFreyburger Gregory P · Strykersville, NYBuilt 1959 · S/N 23-1619N4143PSparrowhawk Aviation · Manvel, TXBuilt 1959 · S/N 23-1624N4145PBlackhawk Holding Corp · Wilmington, DEBuilt 1959 · S/N 23-1626N4153PHilty Robert · Wheatland, WYS/N 23-1637N4159PSparks Brian E · Monmouth, ORBuilt 1959 · S/N 23-1644N415CCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 27-3908N415MDHammychan Industries LLC · Glendale, AZBuilt 1967 · S/N 27-3492N4160POgle Richard W Jr · Joplin, MOS/N 23-1645N4164PSeaplanes R Fun Inc · Wilmington, DEBuilt 1959 · S/N 23-1649N416GSB & K Travel LLC · Wilmington, DEBuilt 1975 · S/N 27-7554094N4170PIfa Aviation Inc · Wilmington, DEBuilt 1959 · S/N 23-1657N417GTLs Aerospace Inc · Big Spring, TXBuilt 1974 · S/N 27-7405467N4188PAero Club Valkaria LLC · Malabar, FLS/N 23-1676N4189PAdams Carlos · Hawi, HIS/N 23-1677N4191PBerry Michael C · Stanfield, AZBuilt 1959 · S/N 23-1679N4196PHarmon Aviation LLC · Exeter, NHBuilt 1959 · S/N 23-1684N4198BAero Flight Flying Club · Minneapolis, MNBuilt 1959 · S/N 23-1687N41DMMission Air LLC · Oklahoma City, OKBuilt 1959 · S/N 23-1566N4202PWells John · Eugene, ORBuilt 1959 · S/N 23-1691N42050Baum Thomas J · Kaufman, TXBuilt 1969 · S/N 27-4081N4209PN4209p LLC · Eagle River, WIS/N 23-1702N4217PInternational Air Services Inc Trustee · Carson City, NVS/N 23-1710N4218PPn4 Aviation Holdings LLC · Bishop, CAS/N 23-1711N4239POneal Hollis R · Deridder, LABuilt 1959 · S/N 23-1737N4243PLandry Lonny R · Fort Worth, TXS/N 23-1742N4248PDavila Rudolfo G · Runge, TXFirst renewal noticeBuilt 1959 · S/N 23-1747N4252UDoitch Dan · Parowan, UTS/N 27-465N4253PBowles Alan B DBA · Georgetown, TXBuilt 1959 · S/N 23-1752N4254PPetersen Clayton L · Albert Lea, MNBuilt 1959 · S/N 23-1753N4259PSkypark Inc · Wadsworth, OHBuilt 1959 · S/N 23-1758
Back to AD 80-26-04 R1