OpenAirDocs.org
AD 86-14-01

Registered aircraft · 408

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:86-14-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-14-01')
  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.

N105RHJem Aviation Solutions LLC · South River, NJBuilt 1984 · S/N 650-0055N106PGGreco Equipment Leasing LLC · Bartlett, ILBuilt 1993 · S/N 650-7012N111FFabair LLC · Milwaukee, WIBuilt 1991 · S/N 650-0197N111YWN111yw LLC · Houston, TXBuilt 1993 · S/N 650-0223N11288Fly The Coop Aviation LLC · Willow Park, TXBuilt 1990 · S/N 650-0184N112EDE D Santos & Associates LLC Trustee · Wilmington, DES/N 258048N116MBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 650-7081N117BGJohnson Calvin · Fort Lauderdale, FLBuilt 1983 · S/N 650-0007N117HHZephyr Air LLC · Houston, TXBuilt 1993 · S/N 258249N117JTColcot Aviation LLC · New York, NYBuilt 1992 · S/N 258205N118MMBradley Flight LLC · Denver, COBuilt 1999 · S/N 650-7105N1210LElite Elevated Enterprises LLC · Las Vegas, NVBuilt 1997 · S/N 650-7078N122LJBas Part Sales LLC · Greeley, COBuilt 1993 · S/N 258239N123HKTavaero Jet Charter Corp · Houston, TXBuilt 1992 · S/N 258208N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLBuilt 1996 · S/N 650-7067N125SBBay Venture Management LLC · Atlanta, GABuilt 1985 · S/N 258046N125TNTriad Aviation LLC · Tyler, TXBuilt 1993 · S/N 650-7025N129GBCapital Cost Corp · Wilmington, DEBuilt 1983 · S/N 650-0006N12SYMcwalsh LLC · Dover, DEBuilt 1987 · S/N 258103N131PGAga Aviation LLC · Lewes, DEBuilt 1986 · S/N 650-0126N132CESouthern Energy Transport LLC · Shelbyville, TNBuilt 1995 · S/N 650-7061N1400MGainesville Aircraft Sales Inc · Gainesville, FLS/N 650-0140N140TSInch & Co Aviation LLC · York, PAS/N 650-0141N140WHVarney Aviation LLC · Bangor, MEBuilt 1991 · S/N 650-0195N144CAKingdom Heir Aviation LLC · Frisco, TXBuilt 1992 · S/N 650-7004N150SBRegistration Pending · Anchorage, AKRegistration pendingBuilt 1991 · S/N 258197N161SDSierra Delta Aviation LLC · Boise, IDBuilt 1996 · S/N 650-7066N163JMGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1988 · S/N 650-0163N171MDN171md LLC · Amarillo, TXBuilt 1993 · S/N 258251N175JAir King Inc Trustee · Cheyenne, WYS/N 650-0168N176TLBank Of Utah Trustee · Salt Lake City, UTBuilt 1990 · S/N 258176N17NNRusty Wallis Aviation LLC · Dallas, TXBuilt 1999 · S/N 6507099N180NEJunction Medical Office P C · Jackson Heights, NYS/N NA0401N180VLBank Of Utah Trustee · Salt Lake City, UTS/N 4480N184GPGpj 184 LLC · Newport Beach, CABuilt 1994 · S/N 650-0236N18GBRm Equipment LLC · Seattle, WABuilt 1995 · S/N 650-7048N191PJAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1990 · S/N 258203N193JCWt 1 Interests LLC · Houston, TXBuilt 1991 · S/N 650-0199N193SJFrontera Flight Holdings Inc · Dover, DES/N 193N199WQBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 4199N19QCOn Three Angels Wings LLC · Melbourne, FLBuilt 1994 · S/N 650-0238N200LHEagle Nation Aviation LLC · Macon, GABuilt 1992 · S/N 650-7005N202AVAvista Corp · Spokane, WABuilt 1999 · S/N 650-7108N202JKRosado Aviation Inc · Moosic, PABuilt 1985 · S/N 650-0100N202JPAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 1994 · S/N 650-7046N2033Aircraft Holding Solutions LLC Trustee · Newark, DES/N 258093N204BBCentex Aero LLC Trustee · San Antonio, TXBuilt 1990 · S/N 650-0189N213RGGlobal Avionics LLC · Downey, CABuilt 1986 · S/N 258073N218PJSoany Steam Inc · Cheyenne, WYBuilt 1988 · S/N NA0426N228DGKonair US LLC · Miami, FLS/N 128
Back to AD 86-14-01