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.

N629EPRockland Aviation LLC · New City, NYBuilt 1982 · S/N 109N629MDAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1985 · S/N 650-0096N62DTN250ap LLC · Chicago, ILS/N 200N62LJN62lj LLC · Fort Lauderdale, FLBuilt 1982 · S/N 056N62RARoyal Air Freight Inc · Waterford, MIS/N 312N632JSRms Flight Services LLC · Wilmington, DEBuilt 1999 · S/N 061N633PJN633pj LLC · Oklahoma City, OKBuilt 2002 · S/N 241N635RJRoyal Air Freight Inc · Waterford, MIBuilt 1975 · S/N 35-017N63FXTrn Aviation LLC · Lewes, DEBuilt 1994 · S/N 6500234N63UCJamrock Leasing LLC · Schenectady, NYBuilt 2001 · S/N 136N63WJKaylan Paige Leasing LLC · Grand Junction, COBuilt 2005 · S/N 278N63YMSun Country Products LLC · Tampa, FLBuilt 2003 · S/N 258636N640RBTalfin Leasing II LLC · Heflin, ALBuilt 1998 · S/N 650-7092N644CKKalitta Charters LLC · Ypsilanti, MIBuilt 1988 · S/N 644N649TTTownes Aircraft Sales LLC · Paris, TXBuilt 2005 · S/N 342N64HAJoe Air LLC · Sellersburg, INBuilt 1999 · S/N 258448N64MJM J Electric LLC · Iron Mountain, MIBuilt 2001 · S/N 136N64NBRcc Management & Aviation LLC · Magnolia, TXS/N 065N650ABBank Of Utah Trustee · Salt Lake City, UTBuilt 1997 · S/N 650-7074N650ACTen X Express LLC · Fort Myers, FLBuilt 1996 · S/N 650-7065N650AHNice Trip LLC · San Juan, PRBuilt 1987 · S/N 650-0139N650CBSzucs Attila · Port Orange, FLBuilt 1985 · S/N 650-0084N650CGC G Bretting Manufacturing Co Inc · Ashland, WIBuilt 1984 · S/N 6500023N650CZTeam Aero LLC · Shawnee, KSBuilt 1995 · S/N 650-7050N650FCOrion Igv LLC · Opa-Locka, FLBuilt 1987 · S/N 650-0146N650GCBank Of Utah Trustee · Salt Lake City, UTBuilt 1992 · S/N 650-0215N650HGHamlin Aviation LLC · Ormond Beach, FLBuilt 1985 · S/N 6500083N650JAAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 650-0090N650JLEncore Jet Management LLC · San Antonio, TXBuilt 1999 · S/N 650-7101N650JSEwi Tn LLC · Gallatin, TNS/N 216N650KPJt95 Airways LLC · Concord, CABuilt 1985 · S/N 650-0095N650MGFalco Industries LLC · Belle Chasse, LABuilt 1978 · S/N 387N650PFAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1988 · S/N 650-0154N650PJSouthwest Aviation Inc · Marshall, MNBuilt 1995 · S/N 650-7059N650PTBurkim LLC · Hartland, WIBuilt 1989 · S/N 650-0169N650RARomeo Alpha LLC · Addison, TXBuilt 1995 · S/N 650-7047N650RCRosado William · Moosic, PABuilt 1993 · S/N 6507029N650RPRussell Air LLC · Madison, INBuilt 1988 · S/N 650-0157N650RTGlobal Aero Aviation Inc · Houston, TXBuilt 1985 · S/N 650-0089N650SFBas Part Sales LLC · Greeley, COBuilt 1984 · S/N 650-0034N650SGMerlin One Aircraft LLC · San Antonio, TXBuilt 1990 · S/N 6500191N650TASale Reported · Greeley, COSale reported, pending cancellationBuilt 1985 · S/N 650-0088N650TWKwafr LLC · Richland Hills, TXBuilt 1997 · S/N 650-7082N650WAWings Aloft Incorporated · Portland, ORS/N 650-0047N650WTRiver Bay Aviation N650wt LLC · Jacksonville, FLBuilt 1998 · S/N 650-7094N651CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 650-7119N651EJComprehensive Energy Aviation LLC · Longwood, FLBuilt 1995 · S/N 650-0241N651EMWv Jet Experience LLC · Charleston, WVBuilt 1984 · S/N 650-0030N651MKMaxfly Aviation Inc · Fort Lauderdale, FLBuilt 1981 · S/N 465-73N651SFN444cw Partners LLC · Spring, TXBuilt 1984 · S/N 650-0063
Back to AD 98-17-01 R1