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.

N269TCleveland Frank W · Quinhagak, AKBuilt 1953 · S/N 18-2383N269ZZKaplan Richard P · Cape Coral, FLS/N 866N26AFTuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1983 · S/N 6N26CARogers Patricia A · Albany, ORBuilt 1979 · S/N 15283794N26EFMischel Herbert · Las Vegas, NVS/N 15282800N26PKLauda Thomas J · Des Moines, IABuilt 1974 · S/N 1041-74N26SBBeert Stephen R · Mckinney, TXBuilt 2002 · S/N 1055N27016Porter Michael P · East Liverpool, OHBuilt 1940 · S/N 4301N2701MBaltrum Daniel R · Ester, AKBuilt 1946 · S/N 12-1205N2707MKarpik Joseph Paul · Floodwood, MNBuilt 1946 · S/N 12-1210N2708MKiceniuk Taras · Santa Paula, CAS/N 12-1211N270SVJones Joseph D · Broken Arrow, OKBuilt 1978 · S/N 15282329N2712ESeuferer Kevin J · Osceola, IABuilt 1946 · S/N 7AC-6292N2718MLibby Justin C · Anchorage, AKBuilt 1946 · S/N 12-1215N271TSmith James L · Asheville, NCS/N 18-2385N2720MCalderwood Kenneth E · Kenai, AKBuilt 1946 · S/N 12-1220N2722MInfinity Aviation LLC · Piedmont, SDBuilt 1946 · S/N 12-1133N2725ZGeorge Ladelle L · Ashley, NDS/N 1231-78N2726FMid America Sprayers Inc · Ulysses, KSBuilt 1979 · S/N 15282841N2732MEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1946 · S/N 12-1225N2734MGraves Dorel E · Danville, INBuilt 1946 · S/N 12-1226N2735ZSoucy Gary J · Brewer, MEBuilt 1978 · S/N 1232-78N2736MBrummer Christopher P · Wasilla, AKBuilt 1946 · S/N 12-1137N2737MGautreau Peter F · Chickaloon, AKBuilt 1946 · S/N 12-1141N2737ZBrown Joseph Earl · Lawrenceburg, INBuilt 1978 · S/N 1233-78N273EZMoore Monty R · Chancellor, ALBuilt 1981 · S/N 1994N273RLRegistered aircraftS/N AA1B-0273N273TKing Kalin J · Valdez, AKBuilt 1953 · S/N 18-2387N2743MKemp Dale W · Lampasas, TXBuilt 1946 · S/N 12-1229N2746MStonecipher Wayne H · Yamhill, ORBuilt 1947 · S/N 12-1233N2747MGuy Vaughn Zindel III · Eden, UTBuilt 1946 · S/N 12-1234N2748MLathrop Patrick W · Kent, WABuilt 1946 · S/N 12-1235N274AARegistered aircraftS/N AA1-0230N2755MKerwin Peter M · Naperville, ILBuilt 1946 · S/N 12-1240N2758MHaring Clay · Lincoln, KSBuilt 1946 · S/N 12-1154N275ACTsutsumi Erika E · Boston, MABuilt 1998 · S/N 1372-98N275CWLunde Craig W · Fort Shaw, MTBuilt 1946 · S/N 1744N2763GWilko Air LLC · Van Wert, OHBuilt 1967 · S/N 459N2770MThissell David W · Plymouth, MABuilt 1946 · S/N 12-1149N2772GSchultz Jason G · Crowley, LABuilt 1967 · S/N 460N2772MDexter Fred H · Live Oak, FLBuilt 1946 · S/N 12-1245N2773MWinby Elize Aj · Palo Alto, CABuilt 1946 · S/N 12-1247N27776Bauer Mark A · Palmer, AKS/N 7720N2778MMiller Benny · Canutillo, TXBuilt 1946 · S/N 12-1159N277FCRegistered aircraftAssigned (import), pending cancellationS/N WA-308N277LTBeechnutz Aviation LLC · Atlanta, GABuilt 1981 · S/N WA277N2780MHerrington James W · Locust Grove, GAFirst renewal noticeBuilt 1946 · S/N 12-1168N2784MWarwick Steven D · Middletown, DEBuilt 1946 · S/N 12-1165N2789MDagostino Scott J · Bozeman, MTBuilt 1946 · S/N 12-1184N278ACLetourneau University · Longview, TXBuilt 2001 · S/N 1385-2001
Back to AD 80-25-02 R2