OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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-25-02-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-25-02-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.

N312TMoore Joseph A · Kingwood, WVBuilt 1953 · S/N 18-2426N3130MCarlblom Boyd W · Eveleth, MNBuilt 1947 · S/N 12-1818N3131CBell Anthony Scott · Garland, TXBuilt 2008 · S/N 6-5847N3135MWilson Brian W · Palmer, AKS/N 12-1829N3136MEms Ronald D · Portland, ORBuilt 1947 · S/N 12-1808N31381Strobridge Mark D · Bunnell, FLBuilt 1982 · S/N 15285644N3138MSpoden Thomas R · Maple Lake, MNBuilt 1947 · S/N 12-1821N313CEAvidash LLC · Cape Coral, FLBuilt 1972 · S/N 886-72N313KFGrahl Nickolas W · Appleton, WIBuilt 2012 · S/N S97060216N313TBlackerby Alexander · Eola, TXS/N 18-2427N3140BKaczmarek James J · Parksley, VABuilt 1982 · S/N LG-1N3148MThoft Matthew M · Wasilla, AKBuilt 1947 · S/N 12-1835N314LFEnalas Corp · Bayonne, NJBuilt 2004 · S/N 20-1027N31504Gendron Matthew · Port Orange, FLS/N 7749N3151MWrong Brothers Aviation LLC · Webster, MNBuilt 1947 · S/N 12-1837N31524Beazley Phillip B · Millbrook, ALBuilt 1994 · S/N 1N3152MAce Aeromotive Inc · Miami, FLBuilt 1947 · S/N 12-1839N3155MManrique Rick E · Palmer, AKFirst renewal noticeBuilt 1947 · S/N 12-1857N3157MRegistered aircraftS/N 12-1890N315ZWagner Daniel D · Unionville, MOBuilt 2024 · S/N 6-7048N3162MWilson John R · Fayetteville, NCBuilt 1947 · S/N 12-1842N3166MAdam Charles D · Hayden, IDBuilt 1947 · S/N 12-2001N3167MBunn Benjamin D · Winchester, VABuilt 1947 · S/N 12-1599N3168MHebrink Benjamin W · Fairbanks, AKBuilt 1947 · S/N 12-1847N316JTMccord Timothy C · Vero Beach, FLBuilt 1984 · S/N 1213N316TPanther Rock LLC · Fluvanna, TXBuilt 1953 · S/N 18-2430N3171MHubner Matthew B · Napa, CABuilt 1947 · S/N 12-1852N3174MSouthern Cross Aviation Inc · Wilmington, DES/N 12-1851N3175AEaglex Aviation LLC · Esko, MNBuilt 1995 · S/N 1002N3177MMayo William M · Wahpeton, NDBuilt 1947 · S/N 12-1894N317DFSchachle Robert G Jr · Wasilla, AKBuilt 1947 · S/N 12-1649N317WSWood Steven J · Rock Hill, MOBuilt 2019 · S/N 1871N317WTNix Gary E · Mountain View, WYBuilt 1995 · S/N PT-1099N3181MBiondich Dennis A · Rubicon, WIBuilt 1947 · S/N 12-2021N31823Rankin Bryan A · Cloverdale, CAS/N 1164N3185MEva Tn LLC · Wilmington, DEBuilt 1947 · S/N 12-1866N3187MZimmerman Kyle R · Gilbert, AZBuilt 1947 · S/N 12-2014N3188MBirch Jerome I Trustee · Anchorage, AKBuilt 1947 · S/N 12-1867N3190MHart David E · Jackson, GABuilt 1947 · S/N 12-2008N3199MDe Voe Don F · Anchorage, AKBuilt 1947 · S/N 12-1862N31CDLow Thomas P · Belmont, CAS/N 020-AN320EZNeshat Bijan · Eastpoint, FLBuilt 1984 · S/N 725N3210Perry Daryl C · Sanford, NCBuilt 1961 · S/N 22-8079N3210EGrove Douglas W · Flemington, PABuilt 1947 · S/N 12-1473N3213NRegistered aircraftBuilt 1946 · S/N 22403N3218MAthol Aggregate LLC · Athol, IDBuilt 1947 · S/N 12-1881N321DDoyle Charles J · Sequim, WABuilt 1974 · S/N AA1B0321N32207Petersen David A · Soldotna, AKBuilt 1947 · S/N 7856N32225Tranby Todd · Minot, NDS/N 7874N3222MRegistered aircraftBuilt 1947 · S/N 12-1887
Back to AD 80-25-02 R2