OpenAirDocs.org
Special Air Service Corp

Earlier aircraft under this name · 32

Cancelled registrations that named this owner when they ended, newest first.

Query with SQL
duckdb -csv -c "SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
  WHERE d.registrant_name = 'SPECIAL AIR SERVICE CORP' OR list_contains(d.other_registrant_names, 'SPECIAL AIR SERVICE CORP')
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

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.

N988SACessna T206H · S/N T20608325Cancelled Jul 23, 2008 · Exported to Spain · Built 2001 · Miami, FLN2049YCessna U206G · S/N U20603556Cancelled May 18, 2007 · Exported to Spain · Miami, FLN1518VAir Tractor AT-401 · S/N 401-0836Cancelled Apr 30, 2004 · Exported to Spain · Built 1991 · Miami, FLN89KCAir Tractor AT-401 · S/N 401-0739Cancelled Apr 30, 2004 · Exported to Spain · Built 1989 · Miami, FLN7015HWsk-Pzl-Mielec PZL-M-18 · S/N 1Z018-18Cancelled Mar 25, 2004 · Exported to Spain · Miami, FLN2456Piper PA-31-325 · S/N 318112019Cancelled Apr 1, 2003 · Exported to Panama · Miami, FLN56542Piper PA-36-285 · S/N 36-7360055Cancelled Feb 8, 2001 · Exported to Spain · Miami, FLN9984PPiper PA-36-285 · S/N 36-7560099Cancelled Aug 30, 1999 · Exported to Spain · Miami, FLN5622KBeech S35 · S/N D7383Cancelled Jul 9, 1998 · Exported to Chile · Miami, FLN4359EPiper PA-38-112 · S/N 3878A0574Cancelled May 28, 1998 · Exported to Chile · Miami, FLN5497PCessna 152 · S/N 15284960Cancelled Mar 10, 1998 · Exported to Chile · Miami, FLN132JCCessna T303 · S/N T30300181Cancelled Jan 20, 1998 · Exported to Chile · Miami, FLN681ACPiper PA-32RT-300T · S/N 32R7887232Cancelled Dec 8, 1997 · Exported to Chile · Miami, FLN6889JPiper PA-34-200T · S/N 347670298Cancelled Nov 19, 1997 · Exported to Chile · Miami, FLN69PLPiper PA-32RT-300 · S/N 32R7885220Cancelled Jun 5, 1997 · Exported to Chile · Miami, FLN532BCCessna T303 · S/N T30300113Cancelled May 21, 1997 · Exported to Chile · Miami, FLN4274EPiper PA-38-112 · S/N 3878A0519Cancelled Oct 23, 1996 · Exported to Chile · Miami, FLN700MAPiper PA-31-325 · S/N 318112048Cancelled Aug 6, 1996 · Exported to Chile · Miami, FLN4938QCessna A188B · S/N 18802673TCancelled Jul 14, 1995 · Exported to Chile · Miami, FLN53138Cessna A188B · S/N 18801641TCancelled Jul 14, 1995 · Exported to Chile · Miami, FLN21723Piper PA-31-350 · S/N 318152028Cancelled Dec 2, 1994 · Exported to Chile · Miami, FLN76MSCessna 340A · S/N 340A0100Cancelled Nov 30, 1994 · Exported to Chile · Miami, FLN41WRPiper PA-31-325 · S/N 318212014Cancelled May 10, 1994 · Exported to Chile · Miami, FLN732MHCessna T210M · S/N 21061616Cancelled May 2, 1994 · Exported to Chile · Miami, FLN222RRCessna 414 · S/N 4140473Cancelled Feb 24, 1993 · Exported to Spain · Medley, FLN414TJCessna 414 · S/N 4140647Cancelled Feb 23, 1993 · Exported to Spain · Medley, FLN408MSPiper PA-31-350 · S/N 318152091Cancelled Sep 24, 1992 · Exported to Panama · Medley, FLN758KXCessna R172K · S/N R1723167Cancelled Apr 1, 1992 · Exported to Spain · Medley, FLN3LSCessna 414 · S/N 4140174Cancelled Aug 26, 1991 · Exported to Spain · Medley, FLN5341DCessna 172N · S/N 17272530Cancelled Jul 25, 1991 · Exported to Chile · Medley, FLN102RSPiper PA-36-375 · S/N 36-7802007Cancelled Dec 28, 1990 · Exported to Spain · Built 1978 · Medley, FLN8994EPiper PA-34-200T · S/N 347670187Cancelled Oct 6, 1981 · Exported to Chile · Medley, FL
Back to Special Air Service Corp