OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,370

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

N57667Flatley Joshua Martin · Alexandria, VABuilt 1973 · S/N 286-74N57669Orwick Louren Chris · Michigan, NDFirst renewal noticeBuilt 1974 · S/N 2-74N5766JVan Hoogmoed Andrew P · Turlock, CABuilt 1980 · S/N 17273834N5766QSalmon Jerome L · Albany, NYS/N 3085N5766XEagles Flyers Inc · Eldridge, IABuilt 1984 · S/N 24-1487N5766YEbbers Stephen L · Bluffton, SCBuilt 1984 · S/N 24-1488N57671Bell Nicolette · Wasilla, AKBuilt 1973 · S/N 416-74N57673Beal Alan D · Prosper, TXBuilt 1974 · S/N 129-74N57674Benton Timothy C · Lepanto, ARBuilt 1973 · S/N 998-74N57676Arthur Flying Club Inc · Page, NDS/N 630-74N57677Dixie Dusters Inc · Itta Bena, MSBuilt 1974 · S/N 662-74N57678Flight School Inc · Spring, TXBuilt 1974 · S/N 417-74N57679Sw Aviation Services Inc · Queen Creek, AZBuilt 1974 · S/N 999-74N5767KSoham Oaks LLC · Kalispell, MTBuilt 1984 · S/N 24-1491N5767ZEtter Robert · Burlington, VTBuilt 1984 · S/N 24-1492N57682Cartillar James R IV · Wynne, ARBuilt 1973 · S/N 631-74N57683Legros Donald P · Jennings, LABuilt 1973 · S/N 632-74N5768BStratford Advancement LLC · Brooklyn Park, MNBuilt 1984 · S/N 24-1494N57690Stockton Robert E · North Pole, AKBuilt 1974 · S/N 3-74N57691Heitz Joel L · Cozad, NEBuilt 1973 · S/N 418-74N57694Bishop David DBA · Butlerville, INBuilt 1973 · S/N 1000-74N5770QJohnson Darryl · Fowler, COBuilt 1965 · S/N 3087N5771FSchutz Garrett · Alamogordo, NMBuilt 1984 · S/N 24-1497N5771QLuchterhand Charles · Salem, ORS/N 744N5772MRutigliano Pasquale T · Aquebogue, NYBuilt 1984 · S/N 24-1501N5772QTweten Gary L · Glasgow, MTS/N 3088N5772RFlying Particles Inc · Livermore, CABuilt 1984 · S/N 24-1502N57737North Creek Aviation LLC · Kilgore, TXBuilt 1984 · S/N 24-1503N5773QGunnerson Spencer · Murfreesboro, TNBuilt 1965 · S/N 745N5775MAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1984 · S/N 24-1505N5775QSinger David · Vandalia, OHBuilt 1965 · S/N 746N57766Smith Danny E III · Covington, INS/N 24-1506N5777HNeff Thomas J · Novato, CABuilt 1984 · S/N 24-1507N5778CTieman Matthew · Chapel Hill, NCS/N 24-1613N5778QPars Avn Corp · Wilmington, DEBuilt 1965 · S/N 3091N5779YMetz Timothy G · Chattanooga, TNBuilt 1984 · S/N 24-1510N5780QMuegge Erik L · Keller, TXBuilt 1965 · S/N 3092N5780YShields Thomas J · Port Orange, FLBuilt 1984 · S/N 24-1511N5781QFranklin Mountain Group Corp · Nashville, TNBuilt 1965 · S/N 749N5782JN5782j LLC · Myrtle Beach, SCBuilt 1979 · S/N 17273835N5782QSkylions LLC · Wichita, KSBuilt 1965 · S/N 3093N5784QArias Raymond G · Wesley Chapel, FLS/N 3094N5785MCanon James P · Calumet, OKBuilt 1984 · S/N 24-1520N5785QSw Industry Inc · Wilmington, DEBuilt 1965 · S/N 751N5785TLos Alamos Aero Services LLC · Los Alamos, NMBuilt 1984 · S/N 24-1521N5786QMartinez Todd P · Vacaville, CABuilt 1965 · S/N 3095N5786ZCampagnone Robert P · Columbia, CTFirst renewal noticeBuilt 1984 · S/N 24-1523N5788QMccabe David P · Tower, MNBuilt 1965 · S/N 3096N5788YWright Brent Alan · Colleyville, TXBuilt 1984 · S/N 24-1524N5789QWayden John R · El Paso, TXBuilt 1965 · S/N 873
Back to AD 80-25-07 R1