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.

N4127MRand Richard E · Spearfish, SDBuilt 1947 · S/N 12-3024N4135MHardy Val D · Lewistown, MTBuilt 1947 · S/N 12-3034N4136Johnston Joel D · Mead, WABuilt 1969 · S/N EA-1N41360Cross Thomas Ad · Yacolt, WABuilt 1945 · S/N 5-1395N4136MArmstrong Charles · Shelbyville, MIBuilt 1947 · S/N 12-3035N4139YPremier Management Co Inc · Mobridge, SDBuilt 1978 · S/N 1248-78N413RBLarson Cody Q · Dillingham, AKBuilt 2003 · S/N 413RN4140YBuckman Dean D · Monroe City, MOBuilt 1976 · S/N 1178-76N4141YWells Kevin R · Elko, NVBuilt 1976 · S/N 1179-76N4142MMiddleton William A Jr · Crestwood, KYBuilt 1947 · S/N 12-3041N4146MKincaid Adam D · Anchorage, AKBuilt 1947 · S/N 12-3045N4150MDozier Roger S · Fairfield, ILBuilt 1947 · S/N 12-3049N4151MWillard John E · Rockwood, MEBuilt 1947 · S/N 12-3050N4151YWarner Kenneth G · Granbury, TXBuilt 1976 · S/N 1181-77N4154MChapman Cody C · Fairbanks, AKBuilt 1947 · S/N 12-3053N4155MFirey Charles R · Anchorage, AKBuilt 1947 · S/N 12-3054N4157MBibber Eugene A · Anchorage, AKBuilt 1947 · S/N 12-3056N4159MShapnek Lawrence R · Cedar Crest, NMBuilt 1947 · S/N 12-3058N4165MJones Donald T · Barrigada, GUS/N 12-3066N41683Ferraro Jeffrey T · Mckinney, TXS/N 976-73N41688Breunig Gerald S · Newark, ILBuilt 1973 · S/N 977-73N4168YThree Point LLC · Lacon, ILBuilt 1976 · S/N 1185-77N41693Glasford John T · Rapid City, SDBuilt 1973 · S/N 979-73N41698Collier James R · Castle Rock, COBuilt 1973 · S/N 980-73N4169MHaroldson Tyler J · Wasilla, AKBuilt 1947 · S/N 12-3063N4172MWeber Keith T · Rubicon, WIBuilt 1947 · S/N 12-3073N4172YColonels Flying Club · Princeton, MNBuilt 1976 · S/N 1186-77N4173MReints Rydell J · Wasilla, AKBuilt 1947 · S/N 12-3072N417CBWings Over L A Aviation LLC · West Hills, CAS/N 15281010N417EMManceaux Mike T · Mc Donald, TNBuilt 1991 · S/N 72819N41800Mccully Heather L · Payson, AZBuilt 1973 · S/N 981-73N4180MFast Mover Aviation LLC · Fort Smith, ARBuilt 1947 · S/N 12-3084N41820Wagner Patricia · West Milton, OHBuilt 1973 · S/N 985-74N41821Gilroy Joseph T · Escalon, CAS/N 1021-74N4182MGreer Guy A · Wasilla, AKBuilt 1947 · S/N 12-3089N4188MLindholm Michael D · Anchorage, AKBuilt 1947 · S/N 12-3078N4189MSchettler Patrick J · Garnett, KSBuilt 1947 · S/N 12-3090N4189YBaldacci Eric · Katy, TXBuilt 1977 · S/N 1191-77N418KN418k LLC · Jupiter, FLBuilt 2016 · S/N 005N4197YAgnew Michael D · Pardeeville, WIS/N 1193-77N419ALTomahawk Aero Services LLC · Bellingham, WABuilt 1978 · S/N 38-78A0401N419GCRiley Bradlee A · Archdale, NCBuilt 2016 · S/N AAZA0167N419YBBlum Bradley R · Waukesha, WIBuilt 2011 · S/N 4566N41HBWalsh Bowen S · North Augusta, SCBuilt 1969 · S/N AA1-0277N41RCCurtis Craig C · Dacula, GAS/N AA1A-0143N4200MGrald Jonathan A · New Hampton, NYBuilt 1947 · S/N 12-3103N4203MLangenberg Stewart M · Santa Barbara, CABuilt 1947 · S/N 12-3097N4205NRutherford Thom J · Burchwood, WIS/N 13676N4205YDrobshoff Alex · Livermore, CABuilt 1977 · S/N 1195-77N4207EDohnke Frederick William · Tehachapi, CABuilt 1978 · S/N 38-78A0489
Back to AD 80-25-02 R2