OpenAirDocs.org
AD 88-24-16

Registered aircraft · 295

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:88-24-16')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:88-24-16')
  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-0184N116MBTvpx Ars Inc Trustee · North Salt Lake, UTS/N 650-7081N117BGJohnson Calvin · Fort Lauderdale, FLBuilt 1983 · S/N 650-0007N118MMBradley Flight LLC · Denver, COBuilt 1999 · S/N 650-7105N1210LElite Elevated Enterprises LLC · Las Vegas, NVBuilt 1997 · S/N 650-7078N123FFN123ff LLC · North Palm Beach, FLS/N S550-0005N123TLN919cs LLC · Colts Neck, NJBuilt 1987 · S/N S550-0124N124HBVanguard Aircraft Trust Company LLC Trustee · Fort Lauderdale, FLBuilt 1996 · S/N 650-7067N125TNTriad Aviation LLC · Tyler, TXBuilt 1993 · S/N 650-7025N129GBCapital Cost Corp · Wilmington, DEBuilt 1983 · S/N 650-0006N131PGAga 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-7004N161SDSierra Delta Aviation LLC · Boise, IDBuilt 1996 · S/N 650-7066N163JN163j LLC · Smithfield, NCBuilt 1987 · S/N S550-0122N163JMGainesville Aircraft Sales Inc · Gainesville, FLBuilt 1988 · S/N 650-0163N16RPRose Aviation LLC · Sarasota, FLBuilt 1985 · S/N S5500047N175JAir King Inc Trustee · Cheyenne, WYS/N 650-0168N178DAAr Leasing LLC · Portland, ORBuilt 1984 · S/N S550-0004N17LPN17lp LLC · Amarillo, TXBuilt 1985 · S/N S550-0111N17NNRusty Wallis Aviation LLC · Dallas, TXBuilt 1999 · S/N 6507099N181GMid South Agricultural Products Inc · Lafayette, LAS/N S550-0006N184GPGpj 184 LLC · Newport Beach, CABuilt 1994 · S/N 650-0236N18GBRm Equipment LLC · Seattle, WABuilt 1995 · S/N 650-7048N193JCWt 1 Interests LLC · Houston, TXBuilt 1991 · S/N 650-0199N19QCOn 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-7046N204BBCentex Aero LLC Trustee · San Antonio, TXBuilt 1990 · S/N 650-0189N220BPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N S550-0034N224KCBeasley Timber Co In · Hazlehurst, GABuilt 1985 · S/N S550-0104N232CEN232ce LLC · Newberry, FLBuilt 1984 · S/N 650-0067N232TAAviation Trading Partners LLC · Shawnee, KSS/N 650-0128N2411APuerto Rico Air Management Services Inc · Coral Gables, FLS/N 650-0103N241DSNcb Air Ventures LLC · Lighthouse Point, FLS/N S550-0042N24KT80000 LLC · Dallas, TXBuilt 1995 · S/N 650-7052N256CPSkymax Aero LLC · Chantilly, VAS/N S550-0033N25EGGarcia Airways LLC · Virginia Beach, VABuilt 1989 · S/N 650-0167N25GZTvpx Aircraft Soultions Trustee · North Salt Lake, UTS/N S550-0011N264GVCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2000 · S/N 650-0104N269TAMadison Ql Partners LLC · Dallas, TXBuilt 2000 · S/N 650-7112
Back to AD 88-24-16