OpenAirDocs.org
AD 97-25-04

Registered aircraft · 1,350

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

N100CCSeneca Tank · Des Moines, IABuilt 1982 · S/N 425-0170N101CANorton Energy Drilling LLC · Lubbock, TXS/N 425-0142N101CGGrant Aviation Inc · Anchorage, AKBuilt 2015 · S/N 208B5191N101HLPapoose Air II LLC · Wilmington, DEBuilt 1981 · S/N 425-0056N101PSJtech Solutions Inc · San Ramon, CABuilt 1982 · S/N 4250108N101RSWillfish LLC · Vero Beach, FLBuilt 2016 · S/N 208B5289N101TNHillsborough County Sheriffs Office · Tampa, FLS/N 20800587N101XWJoby Aero Inc · Santa Cruz, CABuilt 1993 · S/N 208B0382N1026VPa1 208b-0319 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 208B0319N1029YPa1 208b-0325 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 208B0325N102ADEpic Crew LLC · Fort Worth, TXBuilt 1983 · S/N 4410311N1031PMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0404N1037NMartinaire Aviation LLC · Addison, TXBuilt 1993 · S/N 208B0334N103ANCessna 208b0928 Inc Trustee · Wilmington, DEBuilt 2001 · S/N 208B0928N1040DMjr Aviation Consultants LLC · Clearwater, FLBuilt 2021 · S/N 208B5628N1041LMartinaire Aviation LLC · Addison, TXBuilt 1993 · S/N 208B0337N104WYWyoming Department Of Transportation · Cheyenne, WYBuilt 2004 · S/N 20800377N1058NAvion Capital Corp · Anchorage, AKBuilt 1993 · S/N 208B0347N105FC4j Air LLC · Newark, DEBuilt 1981 · S/N 425-0094N105JFIsr Aviation LLC · Wilmington, DEBuilt 1997 · S/N 20800272N105RFRandigo LLC · Wilmington, DEBuilt 1993 · S/N 208B0353N105VEPlane Fun Inc Tr Trustee · Snellville, GABuilt 1998 · S/N 208B0680N106ANTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 208B0917N106RFRandigo LLC · Wilmington, DEBuilt 1995 · S/N 208B0481N106VERedding Aero Enterprises Inc · Redding, CABuilt 1999 · S/N 208B0769N107KAN107ka Inc · Addison, TXBuilt 2005 · S/N 208B1107N1086FAvion Capital Corp · Anchorage, AKBuilt 1995 · S/N 208B0436N108ANFlorida Air Cargo Inc · Davie, FLS/N 208B0975N108RFRandigo LLC · Wilmington, DEBuilt 1996 · S/N 208B0528N109CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0060N109HPFlorida Highway Patrol · Tampa, FLBuilt 2015 · S/N 208B5239N10BBFayard Enterprises LLC · Wake Forest, NCBuilt 1989 · S/N 20800152N10FZAirflair Inc · Maurice, IABuilt 1981 · S/N 425-0117N10JAAircraft Structures International Corp · Enid, OKBuilt 2002 · S/N 208B0961N10YPBmf Jax LLC · Jacksonville, FLBuilt 2020 · S/N 20800666N110PEMission Aviation Fellowship · Nampa, IDBuilt 2000 · S/N 208B0858N1114AEvans David J · Parker, COS/N 208B0309N1115MPa1 208b-0356 LLC · Fort Lauderdale, FLBuilt 1993 · S/N 208B0356N1116GAircraft Structures International Corp · Enid, OKBuilt 1994 · S/N 208B0402N1116WAvion Capital Corp · Anchorage, AKBuilt 1994 · S/N 208B0411N1117GBrylee Investment Corp · Wilmington, DEBuilt 1993 · S/N 208B0370N1119VMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0383N111JJTextron Aviation Inc · Wichita, KSS/N 208B5988N111KULot-A-Go Six LLC · Polson, MTBuilt 1985 · S/N 425-0226N112Central Copters Inc · Belgrade, MTBuilt 2026 · S/N 208B5960N1120WMartinaire Aviation LLC · Addison, TXBuilt 1994 · S/N 208B0388N1128LArne Aviation LLC · Suffolk, VABuilt 1996 · S/N 208B0536N1129GTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2001 · S/N 208B0924N112CZDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 1981 · S/N 441-0233N112LTNorthrop Grumman Systems Corp · El Segundo, CABuilt 2003 · S/N 208B1037
Back to AD 97-25-04