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.

N579DNPdii LLC · Concord, NCBuilt 1978 · S/N 388N579RAWorld Is Not Enough LLC · Turner, ORS/N 21N57FSFobl Inc · Juana Diaz, PRBuilt 1991 · S/N 6500204N57KTKlein Tools Inc · Lincolnshire, ILBuilt 2002 · S/N 110N57MKIce Age Aviation LLC · Greensboro, NCS/N 197N57TSAircraft Trustee Services Inc Trustee · Dover, DES/N 236N583SDMiller Waste Mills Inc · Winona, MNBuilt 1993 · S/N 650-7034N585VCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 258585N58CWOn Eagles Wings I LLC · Pearland, TXBuilt 1977 · S/N 116N58DHAviation Trust Co LLC Owner Trustee · Oklahoma City, OKBuilt 2002 · S/N 258599N58HTAmerican Air Charter Inc · Chesterfield, MOBuilt 1981 · S/N 465-70N590TCLear Holding Corp · Wilmington, DEBuilt 1983 · S/N 082N595DCChoice Aviation LLC · San Antonio, TXBuilt 1990 · S/N 650-0179N595PLFly High Inc · Wichita, KSBuilt 1994 · S/N 97N597AFMoondream 5 LLC · Cypress, TXBuilt 1995 · S/N 650-7057N59CJOptical Air Data Systems LLC · Manassas, VABuilt 1986 · S/N 159N59FTSt Andrews Aircraft LLC · West Palm Beach, FLBuilt 1986 · S/N 650-0123N5CAMach 87 LLC · Sulphur Springs, TXBuilt 1981 · S/N 187N5VGLear Holding Corp · Wilmington, DES/N 014N5XRAviacion Del Oeste Inc · Mayaguez, PRBuilt 1982 · S/N 063N600KEJuliet Zulu Aviation LLC · Loganville, GABuilt 1985 · S/N 416N600RARoyal Air Freight Inc · Waterford, MIBuilt 1984 · S/N 296N603AWNational Test Pilot School · Mojave, CABuilt 1981 · S/N 46572N604GSSix Hundred Four Corp · Paramus, NJS/N 604N604PTR3hd Air LLC · Marietta, GABuilt 1969 · S/N 202N605BXXcel Jet Management Inc · Newark, DEBuilt 2003 · S/N 2004N606WJHawker 800xp LLC · Fort Lauderdale, FLBuilt 2002 · S/N 258606N607RJFlamingo Aircraft Holdings LLC · Orlando, FLBuilt 1990 · S/N 206N609RBAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationBuilt 1984 · S/N 258019N60BTReklaw Management Co · Houston, TXBuilt 1987 · S/N 432N60HXFlying Piggs LLC · Klamath Falls, ORBuilt 1981 · S/N 47N610RLFalconrl LLC · Missoula, MTBuilt 1988 · S/N 68N6110Solidwood Aviation Express LLC · Waller, TXBuilt 1993 · S/N 650-7023N611ATN611at LLC · Punta Gorda, FLBuilt 1987 · S/N 650-0143N611TGRegistered aircraftBuilt 1981 · S/N 55N615FJMegatel Group Services LLC · Dallas, TXS/N 102N616LKMeisner Aircraft Inc · Janesville, WIBuilt 2002 · S/N 240N616WGForza Wings LLC · Laredo, TXBuilt 1985 · S/N 258030N618JGChris Jenschke LLC · Poteet, TXBuilt 1995 · S/N 650-7055N61RARoyal Air Freight Inc · Waterford, MIBuilt 1987 · S/N 630N61SJByrum Lyle Trustee · Roswell, NMBuilt 1983 · S/N 081N61VWSolomon Mark Trustee · Wilmington, DEBuilt 1991 · S/N 049N620KEAir Coryell Flight LLC · Springfield, MOBuilt 2001 · S/N 137N623PMLal Holdings LLC · Gallatin, TNBuilt 1992 · S/N 650-7018N625CYCite Aviation LLC · Wilmington, DES/N 625N626BMRegistered aircraftBuilt 1989 · S/N 634N626HJAv 900 LLC · Deerfield Beach, FLBuilt 1988 · S/N 180N626JCSeascape Air LLC · Irvine, CABuilt 2001 · S/N 140N628EKKauffman Land & Development LLC · Fort Lupton, COBuilt 1982 · S/N 071N629BKKeselowski Transportation LLC · Statesville, NCBuilt 2002 · S/N 198
Back to AD 98-17-01 R1