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.

N761YEUnique Educational Experiences Inc · Signal Hill, CABuilt 1981 · S/N A1520997N7620HMckinney Leonard F · Anchorage, AKBuilt 1946 · S/N 12-496N7622HEngler Eric M · Cass City, MIBuilt 1946 · S/N 12-516N7625HCook Susan R · Carl Junction, MOBuilt 1946 · S/N 12-500N7627SJohnson Richard M · Osceola, WIBuilt 1976 · S/N 1163-76N762AFLake Area Technical Institute · Watertown, SDBuilt 1988 · S/N 10N762JSSayers James B · Edison, OHBuilt 1981 · S/N A1520970N7631HSeibold Bryan S · Big Lake, AKBuilt 1946 · S/N 12-506N7632HAndersen Dana K · Scappoose, ORBuilt 1946 · S/N 12-507N7633SSageeyah Citabria LLC · Claremore, OKBuilt 1976 · S/N 1164-76N7634HHudgin James P · Murfreesboro, TNBuilt 1946 · S/N 12-509N7635HObrien Kenneth J · Lafayette, COBuilt 1946 · S/N 12-510N7636SPrt Aviation LLC · Port Orange, FLBuilt 1976 · S/N 1165-76N763AFTuskegee Airmen National Historical Museum Inc · Detroit, MIBuilt 1988 · S/N 11N763SASunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15283073N76405Koch Carson B · Vancouver, WABuilt 1946 · S/N 10831N76428Spivey Kenneth R Jr · Vestavia, ALS/N 10854N7643HHartley George V · Anchorage, AKBuilt 1946 · S/N 12-518N7644HBunn Jesse R · Wasilla, AKS/N 12-522N7645HJohnson Michaela Renee · Anchorage, AKBuilt 1946 · S/N 12-523N7646HHudson James W · Wasilla, AKS/N 12-524N7648HBranam James G · Middletown, OHS/N 12-527N7649HRinebold Jason R · Lewiston, IDBuilt 1946 · S/N 12-528N764AFVandenberg Garry F · Grand Haven, MIS/N 12N764APSale Reported · Kaplan, LASale reportedBuilt 1978 · S/N 38-78A0706N764HLKirby Dennis T · Sandia Park, NMBuilt 1999 · S/N 182N7654HAnderson Ayden M · Twin Bridges, MTBuilt 1946 · S/N 12-532N7655HKemper Joseph · Coxs Mills, WVS/N 12-533N7656HStephani Timothy M · White Lake, WIBuilt 1946 · S/N 12-534N765AFTuskegee Airmen National Historical Museum · Detroit, MIBuilt 1984 · S/N 5N7661HVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1946 · S/N 12-541N7663HZweifel Douglas L · Anchorage, AKFirst renewal noticeBuilt 1946 · S/N 12-543N76695Keyte Clinton W · Colfax, CABuilt 1946 · S/N 11127N7670HRobinson Eric C · Palmer, AKBuilt 1946 · S/N 12-549N7671DMartin James P · Sioux City, IABuilt 1957 · S/N 18-5889N7671HAir Dakota Flite Inc · Hettinger, NDBuilt 1946 · S/N 12-551N7675SKemp Gilbert A · Waterville, NYBuilt 1976 · S/N 1170-76N76786Engeman Nathon G · Bend, ORBuilt 1946 · S/N 11218N7678HGoth Tedd Lloyd · Hereford, AZBuilt 1946 · S/N 12-567N7682HHumphrey Ronald D · Pace, FLBuilt 1946 · S/N 12-571N7684HWellborn Ralph L · Kenai, AKBuilt 1946 · S/N 12-573N76901Dawsonfens 140 LLC · Pearland, TXBuilt 1946 · S/N 11343N7690HSandstrom Brandon M · Palmer, AKBuilt 1946 · S/N 12-580N7691HSanders Wes E · Palos Park, ILBuilt 1946 · S/N 12-581N76924Donald Ben B · Carthage, TXBuilt 1946 · S/N 11366N7697HMashburn Daniel T Jr · Bolton, MSS/N 12-588N769NERegistration Pending · Pottstown, PARegistration pendingBuilt 1977 · S/N 15280893N76CMRegistration Pending · New Braunfels, TXRegistration pendingBuilt 1978 · S/N 38-78A0422N76HBSinger Michael · Mission Viejo, CAS/N AA1-0140N76LNHillsboro Aero Academy LLC · Hillsboro, ORS/N 957
Back to AD 80-25-02 R2