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.

N453AMN543am LLC · Englewood, COBuilt 1982 · S/N 453N454MFCpc Aviation LLC · Bellaire, TXBuilt 2002 · S/N 201N4554D&J Air LLC · Canyon, TXBuilt 2001 · S/N 143N455DGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N 129N455RCSolomon Mark Trustee · Wilmington, DEBuilt 1998 · S/N 096N457JAviation Leasing Group Inc · Wilmington, DEBuilt 1987 · S/N 258085N458RMPjs Holdings LLC · Prior Lake, MNBuilt 1995 · S/N 650-7049N459LCJumper Air LLC · Green Bay, WIBuilt 1999 · S/N 060N45EJCoral Aircraft LLC · North Platte, NEBuilt 2000 · S/N 080N45GDPacific Rim Management LLC · Middletown, DEBuilt 1989 · S/N 258142N45HFBoard Of Regents Of The Univ Of Nebraska · Lincoln, NES/N 121N45KGAircraft Holding Solutions LLC · Newark, DEBuilt 1980 · S/N 257189N45KNHawker800xp LLC · Dorado, PRBuilt 2003 · S/N 258635N45LJWorldwide Aircraft Services Inc · Tampa, FLBuilt 1998 · S/N 150N45LRN45lr LLC · Anchorage, AKBuilt 1998 · S/N 013N45NMTriple Crown Energy LLC · Tulsa, OKBuilt 2004 · S/N 253N45NPBgs Transport LLC · Wilmington, DEBuilt 2002 · S/N 204N45TUFlying Amici Aviation LLC · Owasso, OKBuilt 2000 · S/N 120N468ESAir Roc Group LLC · Canandaigua, NYBuilt 1990 · S/N 650-0185N46MKSplendid Jet Lease LLC · Cape Coral, FLS/N 206N474CFCarrousel Aviation LLC · Monroe, WIBuilt 2004 · S/N 258662N475HMFalcon Double D 163 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 258451N478PAMerlin One Aircraft LLC · San Antonio, TXBuilt 1996 · S/N 6507069N479JSWest Lake Holdings Inc · Fort Smith, ARBuilt 2004 · S/N 2012N47ANLagoinha Orlando Church Inc · Orlando, FLBuilt 1984 · S/N 650-0054N47HAHoosier Jets LLC · Sellersburg, INBuilt 1995 · S/N 258280N47RARoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 352N480MEMe LLC · Scottsdale, AZBuilt 1993 · S/N 085N481NSJp Flying LLC · Dover, DEBuilt 1982 · S/N 378N484BATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 156N489BMEd Santos & Associates LLC Trustee · Wilmington, DEBuilt 1994 · S/N 258271N4950BBeaubouef Aviation LLC · Shreveport, LABuilt 1984 · S/N 150N497SPClyde Air LLC · Boston, MABuilt 1993 · S/N 236N498CSMmu-Cit-Aviation LLC · West Orange, NJS/N 650-0180N499GSN499gs LLC · Nashville, TNBuilt 2004 · S/N 2014N49CTJog001inc · Lewes, DES/N 314N49GGGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1981 · S/N 132120N49HMFlying Bullet LLC · Grand Island, NEBuilt 2005 · S/N 2036N49MNAlliance Air Parts Acquisitions Corp · Oklahoma City, OKS/N 019N49WLRfs Air LLC · Tucson, AZBuilt 1981 · S/N 457N4BAMonte Carlo Associates LLC · Santa Ana, CABuilt 2003 · S/N 200N4EASaldana Air LLC · Huntley, ILBuilt 1981 · S/N 458N4QNLabutte LLC · Dearborn, MIBuilt 1993 · S/N 650-7031N500BJAir Metro Leasing Inc · Wilmington, DEBuilt 1978 · S/N 242N500BLBnb LLC · Wilmington, DEBuilt 1996 · S/N 08N500FRInterstellar Air LLC · Gainesville, FLBuilt 1992 · S/N 650-0208N500JSTmfb Transportation LLC · Orlando, FLBuilt 1994 · S/N 250N500LY1380 Jets LLC · Pittsfield, MABuilt 2002 · S/N 323N500MPN500mp LLC · Alma, MIBuilt 2000 · S/N 198N500PTKbc Aviation LLC · Kingwood, TXS/N 202
Back to AD 98-17-01 R1