OpenAirDocs.org
AD 98-17-01 R1

Registered aircraft · 1,201

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:98-17-01-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:98-17-01-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.

N729HBBravo Alpha Aerospace LLC · Camden, DEBuilt 1983 · S/N 332441N729WLBearcat Air LLC · Solon, OHBuilt 2000 · S/N 218N72AYCababie Sara · Laredo, TXBuilt 1981 · S/N 419N72FCAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258519N730DFDunn Diehl Farms LLC · Wimauma, FLBuilt 1993 · S/N 067N731PCW O Powers Management Inc · Atlanta, GAS/N 262N731RARoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 328N732AADjcj LLC · Nashville, TNBuilt 1993 · S/N 258243N732SCSantiago Communities Inc · Orange, CAS/N 187N733GBuzick Air LLC · Bardstown, KYBuilt 2004 · S/N 340N737MMMadrock LLC · Dallas, TXBuilt 2000 · S/N 650-7113N73GHSemcoa LLC · Huntingdon, PABuilt 1997 · S/N 261N73GPTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 1986 · S/N 55-127N73LRFalcon N73lr LLC · Belton, TXBuilt 1974 · S/N 35N740TFTop Gun Air LLC · Pompano Beach, FLBuilt 2000 · S/N 074N744ARTop Air Texas LLC · Glendale, CABuilt 2001 · S/N 316N745MCMiradair LLC · Lake George, NYBuilt 2002 · S/N 258593N745TTFlaghill LLC · Key West, FLBuilt 2000 · S/N 099N746ARJdm Aircraft LLC · Arlington, TXS/N 63N747BWOxford LLC · Fort Lauderdale, FLBuilt 1984 · S/N 594N747CPRoyal Air Charter LLC · El Cajon, CABuilt 1983 · S/N 502N7490ATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N NA 0320N750CKMn Aircraft LLC · San Juan, PRBuilt 1992 · S/N 650-7015N751JCCbr Aviation LLC · Delaware, OHBuilt 2001 · S/N 134N752JCTeam Aero LLC · Shawnee, KSBuilt 1980 · S/N 28N757TRRegistered aircraftS/N 560-0598N75ABRivers Equipment III LLC · Nashville, TNBuilt 2001 · S/N 94N75JMJast Air LLC · Wilsonville, ORBuilt 2001 · S/N 123N75MVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 274N75VCSunshine Aero Industries Inc · Crestview, FLBuilt 1981 · S/N 465-71N75XPRedd Air LLC · Vancouver, WABuilt 2000 · S/N 118N760RARoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 432N762MG1mg LLC · Fort Wayne, INBuilt 1982 · S/N 035N766HKDac Acquisition Co LLC · Easton, MDBuilt 1985 · S/N 161N766RARoyal Air Freight Inc · Waterford, MIBuilt 1977 · S/N 360N76CDBankair Inc · West Columbia, SCS/N 093N76CKKalitta Charters LLC · Ypsilanti, MIBuilt 1976 · S/N 076N770CCTaughannock Aviation Corp · Ithaca, NYBuilt 2002 · S/N 258587N770FGHangar LLC · Las Vegas, NVBuilt 1967 · S/N 116N777BLBlackstone Mm Assets LLC · Beverly Hills, CABuilt 1990 · S/N 048N777CJHarvest International Ministries Inc · Texarkana, ARBuilt 1986 · S/N 650-0122N777FCAlghazzawi Hani · Holland, OHBuilt 1986 · S/N 508N777MXAirplane III LLC · Fulshear, TXBuilt 1984 · S/N 650-0051N777QLMed Air LLC · Lawrenceville, GABuilt 2002 · S/N 216N777XYCair Leasing LLC · Wilmington, DEBuilt 1987 · S/N 27N77HFCb Aircraft Inc · Fort Lauderdale, FLBuilt 1994 · S/N 650-7036N77LXWatford Horizons LLC · College Station, TXBuilt 1995 · S/N 650-7051N77METrilogy Investments Ag LLC · Las Vegas, NVBuilt 1982 · S/N 96N77SFSeneca Foods Corp · Penn Yan, NYBuilt 1996 · S/N 650-7072N780DWBemo23 Assembly LLC · New York, NYBuilt 1998 · S/N 258378
Back to AD 98-17-01 R1