OpenAirDocs.org
AD 2004-25-16 R1

Registered aircraft · 10,537

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:2004-25-16-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2004-25-16-R1')
  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.

N9529CSilver Lining Carpet Care & Restoration LLC · Tallahassee, FLS/N T30300185N952ANAztec 66 LLC · Indianapolis, INBuilt 1965 · S/N 27-2862N9536PPa1 208-00090 LLC · Fort Lauderdale, FLBuilt 1986 · S/N 20800090N9539FPa1 208-00092 LLC · Fort Lauderdale, FLS/N 20800092N953DMMainline Services Co · Wilmington, DEBuilt 1976 · S/N 340A0205N953DSShows Douglas · Seabrook, TXBuilt 1983 · S/N TJ-443N954JCSkyline Aviation Services LLC · Miramar, FLBuilt 1983 · S/N T30300209N954JWHawaii Pacific Aviation Inc · Kailua Kona, HIBuilt 1979 · S/N 34-7970429N954MCBank Of Utah Trustee · Salt Lake City, UTBuilt 1975 · S/N 421B0891N9555BStern Aviation Inc · N Fort Myers, FLBuilt 1981 · S/N TC-2405N9555YRegistered aircraftBuilt 1973 · S/N TC-1577N955BESouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N TC-1272N955BRBuffalo River Aviation LLC · Bentonville, ARBuilt 1972 · S/N TH-230N955CAJa Flight Services LLC · Sugar Grove, ILBuilt 1979 · S/N TC-2264N955DBWeyant Steven R · Bonney Lake, WABuilt 1978 · S/N TC-2195N955RHFrenzel Aviation Investments LLC · Brentwood, TNBuilt 1977 · S/N TC-2095N955RPBideler Nicholas · Saint Louis, MOBuilt 1979 · S/N TC-2243N956EALopez Fabio · Denver, NCBuilt 1976 · S/N 340A-0085N956TXTexas Department Of Public Safety · Austin, TXBuilt 2014 · S/N 20800563N9573CBarber Scott H · Redwood Falls, MNBuilt 1978 · S/N 34-7870198N957MM957mm Inc · Wilmington, DEBuilt 1964 · S/N TC-669N957PCPilot Realty Inc · Sackets Harbor, NYS/N TH-2023N957SSkymark Airlines · Sacramento, CARegistration revokedBuilt 1962 · S/N 27-2136N958BPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496653N958CCSolomon Mark Trustee · Wilmington, DEBuilt 1989 · S/N TH-1565N958HCHydroair LLC · Auburn, ALBuilt 1999 · S/N TH-1891N958JLEuroaviation Inc Trustee · KematenBuilt 2024 · S/N 20800712N958MDGko Aviation LLC · Wilmington, DES/N 340A0734N958PDrew Jensen Inc · Lincoln, NEBuilt 1978 · S/N TJ-139N958PBMo Elite Air LLC · Rolla, MOBuilt 1981 · S/N TJ-392N958WDBrush Art Corp · Downs, KSBuilt 1999 · S/N TH-1928N959CVaero Inc · Vinton, VABuilt 1981 · S/N 27-8154029N959DCKpp Air LLC · Navasota, TXBuilt 1980 · S/N 340A0942N959PEParis Air Inc · Vero Beach, FLBuilt 1974 · S/N 34-7450084N959RHRd Holdings LLC · Las Vegas, NVBuilt 1978 · S/N 414A0217N959TXAhern John · Prosper, TXBuilt 1977 · S/N 414A0011N959WATailwind Flyers LLC · Guilderland, NYBuilt 1982 · S/N 34-8233080N95BHSale Reported · Lacombe, LASale reported, canceledBuilt 1975 · S/N TJ-29N95DSale Reported · GuernseySale reportedBuilt 1998 · S/N 3449060N95FBSouthern Wings LLC · Shreveport, LABuilt 1964 · S/N TC-640N95FLWolfenden Enterprises Inc · Vero Beach, FLBuilt 1973 · S/N TC-1625N95FSN95fs Ltd · Chicago, ILBuilt 1969 · S/N 30-1786N95GMMeinig High Club LLC · Klamath Falls, ORBuilt 1980 · S/N 421C0821N95KAAirborne Resources Inc · Midlothian, TXBuilt 1981 · S/N 318152146N95KMAerial Logistics LLC Trustee · Lakeland, FLBuilt 1981 · S/N TH-1315N95PJMoghimi Gholamali · Monroe, LABuilt 1980 · S/N TH-1162N95PNM&B Aviation Services LLC · Wilmington, DEBuilt 1972 · S/N TH-282N95PTFinkelstein Robert S · Palm Beach Gardens, FLBuilt 1980 · S/N TC-2346N95RDSwair LLC · Denver, COBuilt 1965 · S/N TC-827N95TCMmec Air LLC · Oxford, MSBuilt 1983 · S/N 31-8352037
Back to AD 2004-25-16 R1