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.

N911GUTeam Aero LLC · Olathe, KSBuilt 1981 · S/N 343N913CKKalitta Charters LLC · Ypsilanti, MIBuilt 1975 · S/N 013N913SCAircraft Holding Solutions LLC · Newark, DES/N NA0418N914ECPacific Rim Management LLC · Downey, CAS/N 258001N914TV1365 Swan Ridge Road LLC · New York, NYBuilt 1987 · S/N 14N915APAir Services Corp · Wilmington, DEBuilt 2002 · S/N 258574N917SMAircraft Fidelity Corporation Trustee · Dover, DEBuilt 1998 · S/N 099N918XZAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1990 · S/N 258177N919WTAir Waukegan LLC · Waukegan, ILBuilt 2001 · S/N 313N91DPN91dp LLC · Dublin, OHBuilt 1993 · S/N 079N91GJGlobal Jetcare Inc · Brooksville, FLBuilt 1975 · S/N 032N91MSLabbe LLC · Huntington Valley, PABuilt 1987 · S/N 10N920EJAlliance Aviation Group LLC · Wilmington, DEBuilt 2005 · S/N 258705N920RARoyal Air Freight Inc · Waterford, MIBuilt 1980 · S/N 430N920TCHendershot Aviation LLC · Houston, TXBuilt 1996 · S/N 258291N921EDWild Boar LLC · Klamath Falls, ORBuilt 1981 · S/N 31N922KMRosado Aviation Inc · Moosic, PABuilt 1998 · S/N 650-7087N922TG100 LLC · Rancho Santa Fe, CABuilt 1999 · S/N 109N924WJSky Air Center Unlimited LLC · Burleson, TXBuilt 1983 · S/N 141N925BPApexnetwork Air LLC · Highland, ILBuilt 1998 · S/N 098N926CBSgj Racing LLC · Miami, FLBuilt 2000 · S/N 650-7114N927BRFur Management & Consulting LLC · Junction, TXBuilt 2002 · S/N 196N927SKCrosley Aviation LLC · Warsaw, INBuilt 1999 · S/N 051N928ALHogsback Holdings LLC · Klamath Falls, ORBuilt 1982 · S/N 041N928JAWorld Champion Air LLC · Acworth, GABuilt 1995 · S/N 0075N929TCypress Investments LLC · Cheyenne, WYBuilt 1980 · S/N 24N92CJSkyview LLC · Wilmington, DEBuilt 1982 · S/N 092N92UPTexas Aircraft Parts Brokers LLC · Seguin, TXBuilt 1997 · S/N 258309N931CAWild Aviation LLC · Rockford, ILBuilt 2002 · S/N 258586N931EDRainier Jets LLC · Middletown, DEBuilt 1996 · S/N 124N931RSWard Ohara Companies LLC · Kansas City, MOBuilt 1999 · S/N 184N939MCForever Astra Inc · Wilmington, DES/N 012N939RTInvestjet LLC · Miami, FLBuilt 1984 · S/N 650-0061N940CCRegistered aircraftBuilt 1982 · S/N 88N942FKForty Er LLC · Bethany, OKBuilt 2001 · S/N 145N945SKJog001 Inc · Lewes, DEBuilt 1982 · S/N 650-0001N947DTTkr Aviation LLC · Ballwin, MOBuilt 1992 · S/N 117N949JABemo23 Assembly LLC · New York, NYBuilt 1998 · S/N 258362N949SAN501wj LLC · Ottawa Lake, MIBuilt 1985 · S/N 650-0074N94CHInvestjet LLC · Miami, FLBuilt 1998 · S/N 650-7088N94GPJr Aviation LLC · El Cajon, CABuilt 1981 · S/N 411N950FJPlane To Sea Aviation LLC · Boca Raton, FLBuilt 1981 · S/N 41N950JBKlc 158 LLC · Dallas, TXBuilt 2005 · S/N 602N950RARoyal Air Freight Inc · Waterford, MIS/N 170N950SFTsl 2 LLC · Jackson, WYBuilt 1988 · S/N 50N953JFRwb Holdings LLC · Cheyenne, WYBuilt 1984 · S/N 650-0043N954MEMiller Equipment Leasing LLC · Hewlett, NYBuilt 1994 · S/N 244N954SGTeam Aero LLC · Olathe, KSBuilt 1981 · S/N 54N955VGTvpx Aircraft Solutions Trustee · North Salt Lake, UTBuilt 2002 · S/N 328N957ECBank Of Utah Trustee · Salt Lake City, UTBuilt 1979 · S/N 146
Back to AD 98-17-01 R1