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.

N238AXFabio Lopez · Denver, NCS/N 030N238DBLewis University · Romeoville, ILBuilt 1977 · S/N 215N238LMBcp Fa Ap LLC · Providence, RIBuilt 1999 · S/N 039N239AXAviation8 LLC · Carle Place, NYBuilt 1987 · S/N 39N239CASantiago Communities Inc · Orange, CABuilt 1996 · S/N 126N239JCIbikunle Christopher · Dover, DEBuilt 2002 · S/N 239N240BThunderun Aviation Corp · Glenwood, NYBuilt 1999 · S/N 175N240CKKalitta Charters LLC · Ypsilanti, MIBuilt 1966 · S/N 24N240VN240v LLC · Wilmington, DEBuilt 1999 · S/N 258417N2411APuerto Rico Air Management Services Inc · Coral Gables, FLS/N 650-0103N241CTAvalair Aircraft Management LLC · Brookshire, TXBuilt 1981 · S/N 355N241LJDouble Whiskey Aviation LLC · Midland, TXS/N 241N243JRDodson International Parts Inc · Rantoul, KSS/N 565N244CKKalitta Air LLC · Ypsilanti, MIBuilt 1977 · S/N 369N244FLAviation Leasing Group Inc · Wilmington, DES/N 258066N244LJN244lj Aviation Inc · Middletown, DEBuilt 1979 · S/N 244N244RG369ba LLC · West Columbia, SCBuilt 1977 · S/N 154N245TXLearjet N245tx LLC · Uvalde, TXBuilt 1999 · S/N 023N248BPNorth Valley Air Ltd · St Thomas, VIBuilt 1998 · S/N 283N248ECEc Aviation LLC · Lake Oswego, ORBuilt 1998 · S/N 258368N24KT80000 LLC · Dallas, TXBuilt 1995 · S/N 650-7052N24NNWorld Jet Of Delaware Inc · Fort Lauderdale, FLS/N 35-037N24SMExecutive Air Solutions Corp · Fort Lauderdale, FLBuilt 2002 · S/N 258567N24ZDNext Wave Aviation LLC · Henderson, NVBuilt 1994 · S/N 073N250APLone Star Avalanche LLC · Marble Falls, TXBuilt 1982 · S/N 125N250EXAb Aspen LLC · Opa Locka, FLBuilt 2001 · S/N 139N250MBNo Layover LLC · Hays, KSBuilt 1993 · S/N 258237N253SCPowderhorn Aviation LLC · Bethany, OKBuilt 2004 · S/N 252N254ALCorsair Two LLC · Hillsboro, ORBuilt 2005 · S/N 283N254FSS&S Aviation Management LLC · Waco, TXBuilt 1999 · S/N 058N254SBHawker 800xp LLC · Fort Lauderdale, FLBuilt 2003 · S/N 258616N255RVSolomon Mark Trustee · Wilmington, DEBuilt 1983 · S/N 095N255TKTurbine Aircraft Services LLC · Bethany, OKBuilt 2000 · S/N 193N256AUnlimited Boat Sales Inc · Page, AZS/N 172N256VGitsis Nick Trustee · MakatiBuilt 1979 · S/N 151N257SJN257sj Aviation Corp · Middletown, DEBuilt 1985 · S/N 55-118N258MRE D Santos & Associates LLC Trustee · Wilmington, DEBuilt 1994 · S/N 258258N258UTBurnt Orange Five LLC · Seabrook, TXBuilt 1992 · S/N 114N259RHAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258529N25EGGarcia Airways LLC · Virginia Beach, VABuilt 1989 · S/N 650-0167N25STLewis Garry L · Livingston, LABuilt 1982 · S/N 198N25XPRd Airways LLC · Channelview, TXS/N 258572N260LFEthos Aviation LLC · Cleveland, OHBuilt 2001 · S/N 231N260RCValiair Limited Company Trustee · Casper, WYBuilt 1993 · S/N 080N260RFHampton Holdings LLC · Atlanta, GABuilt 1996 · S/N 160N263SNBlue Skies Hawker LLC · Whitefish, MTBuilt 2002 · S/N 258580N264GVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 650-0104N264RVHfa Specialty Acquisitions LLC · Boca Raton, FLBuilt 2002 · S/N 327N265FTSunshine Aero Industries Inc · Crestview, FLBuilt 1980 · S/N 465-46N265GCnl Group Services III LLC · Orlando, FLS/N 214
Back to AD 98-17-01 R1