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.

N5290ZColeman Kyle M · Sisters, ORBuilt 1961 · S/N 22-8986N5291ZBay Area Recreational Flyers LLC · Midland, MIBuilt 1961 · S/N 22-8989N52920Ward David K · Enumclaw, WAS/N 5-1427N5292HHartmann Lucas A · Barrington, ILBuilt 1949 · S/N 16-96N5292ZHayes David A · Steward, ILBuilt 1961 · S/N 22-8992N5293HPierce Stephan · Graham, TXBuilt 1949 · S/N 16-97N5294HWingo John W Jr · Washington, DCBuilt 1949 · S/N 16-98N5294ZMorpeth Dorinda · Fortson, GABuilt 1961 · S/N 22-8994N5295ZFawcett Debra K · Baraboo, WIBuilt 1961 · S/N 22-8995N5297MAllard John R · Circleville, OHS/N 15284518N5299ZWilliams Robert M · Red Hook, NYBuilt 1961 · S/N 22-8786N529JHCoconut Racing Group LLC · North Miami, FLBuilt 1976 · S/N AA1B0669N529LSMcnatt Shaun M · Snohomish, WABuilt 1969 · S/N 727-70N52GDVilimek Mark William · Milpitas, CABuilt 2007 · S/N 001N52JXPinhoc Inc · Winter Garden, FLS/N 15281088N52KPKrog Steven L · Hartford, WIBuilt 1995 · S/N 1994N52MSTaylor Jerry D · Blair, NEBuilt 2011 · S/N 050900074N52RTParks Andy J · Fort Lupton, COBuilt 1981 · S/N 078252N52TN52t LLC · Pleasant Prairie, WIBuilt 1971 · S/N AA1A-0212N5300HStanton David R · Washougal, WABuilt 1949 · S/N 16-111N5300ZThissell David W · Plymouth, MABuilt 1961 · S/N 22-9002N5301HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15284083N5302ZLee Ronald Earl Jr · Stokesdale, NCBuilt 1961 · S/N 22-9005N5304HMyakka Head Aviation LLC DBA · Bradenton, FLBuilt 1949 · S/N 16-108N5305HMarlatt Daniel L · Susanville, CAFirst renewal noticeS/N 16-109N5306HWroe Daniel C · Denton, MDBuilt 1949 · S/N 16-110N5309HZeis Patrick J · Albany, MNBuilt 1949 · S/N 16-114N5309ZNorth Central Aircraft Sales · Tioga, NDS/N 22-9012N530CACavalair LLC · San Francisco, CABuilt 1977 · S/N 152-79757N530EZBaxter Matthew C · Renton, WAS/N 1103N5310H426th Aero Squadron LLC · Cropwell, ALBuilt 1979 · S/N 15284084N5310ZStoller Russell L · Algoma, WIBuilt 1961 · S/N 22-9013N5311ZWhitley Wes A · Dumas, TXBuilt 1961 · S/N 22-9014N5312MMoore Aviation Inc · Beaver Falls, PABuilt 1980 · S/N 15284526N5312QHoogendorn Homer E · Wasilla, AKBuilt 1981 · S/N 15285098N5313HRizzo Joseph A · Akron, NYBuilt 1949 · S/N 16-118N5313ZMartinez Milton E · Fort Lauderdale, FLS/N 22-9017N5314MAlpha Golf Aviation LLC · Naples, FLBuilt 1980 · S/N 15284528N5315ZGates Steven F · Rockford, ILS/N 22-9019N5316HGade Dale A · Antioch, ILBuilt 1949 · S/N 16-121N5316ZMarshall Jesse A · Moab, UTBuilt 1961 · S/N 229020N5317ZBauman Michael P · Toronto, OHS/N 22-9021N5318HZefting Brett M · Bellingham, WABuilt 1949 · S/N 16-123N5318MHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1980 · S/N 15284529N5319PRockwell Collins Flight Services Inc · Cedar Rapids, IAS/N 15284912N531TGBurns Peter J · North River, NYBuilt 1974 · S/N 1082-75N5320GStroup David J · Alliance, OHBuilt 1953 · S/N 18-2326N5320HMiller Lorin D · Colo, IAS/N 16-125N5320ZLand Cecil J · Goshen, KYBuilt 1961 · S/N 22-9024N5321HNurge Richard J · Gilroy, CAS/N 16-126
Back to AD 80-25-02 R2