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.

N840SWN840sw LLC · Vero Beach, FLBuilt 1994 · S/N 084N841MSSafari Intl LLC · Lewes, DEBuilt 1984 · S/N 650-0056N841TFRoyal Air Freight Inc · Waterford, MIBuilt 1981 · S/N 416N845BBN845bb Partners LLC · Richmond, VABuilt 2000 · S/N 650-7115N845TXButler Brian S · Oklahoma City, OKBuilt 1981 · S/N 342N848NAsf Aviation LLC · Cortlandt Manor, NYBuilt 1998 · S/N 258371N84JHFlycarolina LLC · Concord, NCBuilt 1984 · S/N 650-0062N84TJUsaircraft Inc · Newark, DES/N 188N84UPN84up LLC · Wilmington, DEBuilt 2000 · S/N 258484N850BWJetcorp LLC · Fontana, CABuilt 1982 · S/N 75N850CCSunshine Aero Industries Inc · Crestview, FLBuilt 1980 · S/N 465-38N850ENBcbg Capital LLC · Clearwater, FLBuilt 2002 · S/N 326N850FJPachy Music Corp · Bellflower, CABuilt 1991 · S/N 215N850RARoyal Air Freight Inc · Waterford, MIBuilt 1988 · S/N 189N850SXN850sx LLC · Lewes, DEBuilt 1994 · S/N 258270N850XMHawker Jet Holdings Xp1 LLC · Opa Locka, FLS/N 258426N851CGBank Of Utah Trustee · Salt Lake City, UTS/N 59N851LDodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 114N855MWMunguia Mario · Downey, CABuilt 1993 · S/N 258241N855RJJw-N855rj LLC · Mcallen, TXBuilt 1981 · S/N 009N858SPBrown Lawson M II · San Diego, CABuilt 1974 · S/N 11N858WWMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1993 · S/N 064N85MSAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1985 · S/N 650-0075N85PTWestwind Air LLC · Oklahoma City, OKBuilt 1980 · S/N 285N85SVTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1980 · S/N 347N85WTExcalibur International Aviation Inc · Spring, TXBuilt 1988 · S/N 650-0162N860JAAirborne Aviation LLC · Miami, FLBuilt 1998 · S/N 650-7086N864BFPsx LLC · Sheridan, WYBuilt 2002 · S/N 258584N865CSReef Aviation LLC · Knoxville, TNBuilt 2004 · S/N 136N865PCPapa Charlie LLC · Houma, LABuilt 1998 · S/N 271N867TXAirplane 1 LLC · Richmond, TXBuilt 2002 · S/N 258576N86BRBest Aircraft Deals LLC · Salt Lake City, UTS/N 90N86TNBravo Aviation LLC · Santa Rosa Beach, FLBuilt 1995 · S/N 241N870CKKalitta Charters LLC · Ypsilanti, MIBuilt 1978 · S/N 170N870ZPotomac Corp · Wheeling, ILBuilt 2001 · S/N 193N876MRBudget Jet LLC · Greenville, DEBuilt 1994 · S/N 125N8778Ligon Air LLC · Birmingham, ALBuilt 2001 · S/N 258560N877SARegistered aircraftBuilt 1997 · S/N 260N878MBMb Air LLC · New York, NYBuilt 2002 · S/N 258603N87KBKkb Holdings LLC · Wilmington, DEBuilt 2003 · S/N 331N87RTPremier Lj40 Inc · Wilmington, DEBuilt 1977 · S/N 106N87SNB & M Aviation LLC · Theodore, ALBuilt 1998 · S/N 650-7089N880CHEcho Acquisitions LLC · Dover, DES/N 168N880PLExecutive Air Taxi Corp · Bismarck, NDBuilt 1998 · S/N 258380N881AFPetrotransit LLC · Cypress, TXBuilt 1996 · S/N 258289N882SCAti Jet Inc · El Paso, TXBuilt 1984 · S/N 590N884ABJetsteam Aviation Inc · Cheyenne, WYS/N 258097N884BBHf III LLC · Saint Paul, MNBuilt 1987 · S/N 17N886DCLcjna Management LLC · Leesburg, VABuilt 1998 · S/N 177N887SGN45ax LLC · Tulsa, OKBuilt 2001 · S/N 174
Back to AD 98-17-01 R1