OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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.

N5839HKinney Philip D · Audubon, MNBuilt 1949 · S/N 16-456N5839ZPhillips Michael K · Issaquah, WABuilt 1963 · S/N 22-9692N5840HFarrell Tammy · Sterling, AKBuilt 1949 · S/N 16-458N5842HUnivair Aircraft Corp · Aurora, COBuilt 1949 · S/N 16-460N5843HPerkins Jeffrey · Georgetown, TXBuilt 1949 · S/N 16-461N5843ZIkenberg H L · Butler, PABuilt 1963 · S/N 22-9697N5844HMccoy David L · Bear Creek, WIS/N 16-463N5844ZJohnk Willi C II · Donalds, SCBuilt 1963 · S/N 22-9698N5846HTop Flight Detail LLC · Middlebury, INS/N 16-465N5848HWhite Terry W · Saint Joseph, MIBuilt 1949 · S/N 16-467N584UConverse Donald A · Los Alamitos, CABuilt 1986 · S/N 862N5850ZMiller Helen J · Springfield, OHBuilt 1963 · S/N 22-9705N5851ZBurklund Joel H · Minneapolis, MNBuilt 1963 · S/N 22-9706N5852HKelley Don Lee · Loon Lake, WABuilt 1949 · S/N 16-462N5852ZTuttle James R · Cherryvale, KSS/N 22-9708N5856HWaco West Inc · Dover, DEFirst renewal noticeBuilt 1949 · S/N 16-474N5856ZHankins Jon A · Fort Mohave, AZBuilt 1963 · S/N 22-9712N5858HKoch Michael R · Nemo, SDBuilt 1949 · S/N 16-478N5859ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1963 · S/N 22-9716N58629Thomas Cross Ad · Yacolt, WABuilt 1942 · S/N 8607N5862ZBitton Robert L · Corbett, ORBuilt 1963 · S/N 22-9719N5863ZGarner James H III · Sun Lakes, AZBuilt 1963 · S/N 22-9720N5864ZPeterson Josh · Paso Robles, CAS/N 22-9722N5866HOsmundson John C · Tenino, WAS/N 16-485N5867ZDraughon Charles V · Easley, SCBuilt 1963 · S/N 22-9730N5868HStein John R · Central Lake, MIBuilt 1949 · S/N 16-487N5871ZJohnson Nathan P · Rapid City, SDBuilt 1963 · S/N 22-9729N5872ZCollins James T · Blossvale, NYBuilt 1963 · S/N 22-9728N5873ZSchramm Thomas L · South Rockwood, MIBuilt 1963 · S/N 22-9731N5874ZGodbey Patrick · St Simons Island, GABuilt 1963 · S/N 22-9732N5875HPresten Eric A · Vineburg, CABuilt 1949 · S/N 16-493N5875ZReed John F · Bemus Point, NYBuilt 1963 · S/N 22-9733N5876ZDraper Scott · Rutland, VTBuilt 1963 · S/N 22-9736N5878ESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1978 · S/N 17271949N5878HDelaware Taildraggers LLC · Hancock, NYBuilt 1949 · S/N 16-495N5879HParlin Larrol L · Friday Harbor, WABuilt 1949 · S/N 16-497N587BHitterman James D · Metropolis, ILBuilt 1994 · S/N 3185N5881HGazda Jerry V · Granbury, TXBuilt 1949 · S/N 16-501N5883ZMckernan Thomas H · Gabriels, NYBuilt 1963 · S/N 22-9745N5885ZLewis Vincent E · Oregon, MOBuilt 1963 · S/N 22-9747N5886ZArgabright Jeremy E · Bloomfield, MTBuilt 1963 · S/N 22-9750N5888HGfeller Kent · Winona, KSBuilt 1949 · S/N 16-510N5888ZGoldberg David C · Garner, NCBuilt 1963 · S/N 22-9752N588DSCox Joshua · Ormond Beach, FLBuilt 1973 · S/N 961-73N5891HFelske Michael J · East Troy, WIBuilt 1949 · S/N 16-512N5892ZCarbiener Ross · Kewanee, ILBuilt 1963 · S/N 22-9756N5893HAmos Derek L · Helena, MTBuilt 1949 · S/N 16-513N5893ZKugmach LLC · Holdrege, NEBuilt 1963 · S/N 22-9758N5894ZRussell Webster K · Ridgeland, MSS/N 22-9759N5895HThompson Timothy G · Kenosha, WIBuilt 1949 · S/N 16-517
Back to AD 80-25-02 R2