OpenAirDocs.org
United Technologies Corporation

Earlier aircraft under this name · 22

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 = 'UNITED TECHNOLOGIES CORPORATION' OR list_contains(d.other_registrant_names, 'UNITED TECHNOLOGIES CORPORATION')
  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.

N763SASikorsky S-76A · S/N 76003Cancelled Dec 10, 2001 · Triennial form not returned · Built 1976 · Stratford, CTN761SASikorsky S-76A · S/N 76001Cancelled Jan 19, 1999 · Triennial form not returned · Stratford, CTN762SASikorsky S-76 · S/N 76002Cancelled Feb 21, 1996 · Triennial form not returned · Stratford, CTN3123USikorsky S-76B · S/N 760269Cancelled Oct 25, 1994 · Exported to France · Built 1984 · Stratford, CTN72673Sikorsky S-70C(M)-1 · S/N 701558Cancelled Dec 15, 1993 · Exported to China · Stratford, CTN5007GSikorsky S-70A-28E · S/N 7010926Cancelled Jun 22, 1993 · Exported to Turkey · Stratford, CTN5007HSikorsky S-70A-28E · S/N 7010902Cancelled Jun 22, 1993 · Exported to Turkey · Stratford, CTN72662Sikorsky S-70B-2 · S/N 70486Cancelled Jun 22, 1993 · Exported to Australia · Stratford, CTN72664Sikorsky S-70B-2 · S/N 70489Cancelled Jun 22, 1993 · Exported to Australia · Stratford, CTN50006Sikorsky S-70C(M)-1 · S/N 701574Cancelled May 24, 1993 · Exported to Taiwan · Stratford, CTN5003ESikorsky S-70A-18 · S/N 701714Cancelled May 24, 1993 · Exported to South Korea · Stratford, CTN5004BSikorsky S-70C(M)-1 · S/N 701582Cancelled May 24, 1993 · Exported to Taiwan · Stratford, CTN5010ESikorsky S-70C(M)-1 · S/N 701671Cancelled May 24, 1993 · Exported to Taiwan · Stratford, CTN7265YSikorsky S-70B · S/N 70464Cancelled May 24, 1993 · Exported to Australia · Stratford, CTN72667Sikorsky S-70B-2 · S/N 70490Cancelled May 24, 1993 · Exported to Australia · Stratford, CTN72669Sikorsky S-70B-2 · S/N 70475Cancelled May 24, 1993 · Exported to Australia · Stratford, CTN72683Sikorsky S-70A-18 · S/N 701604Cancelled May 24, 1993 · Exported to South Korea · Stratford, CTN7268KSikorsky S-70A-22 · S/N 701490Cancelled May 24, 1993 · Exported to South Korea · Stratford, CTN7268MSikorsky S-70A-22 · S/N 701495Cancelled May 24, 1993 · Exported to South Korea · Stratford, CTN7268ZSikorsky S-70A-18 · S/N 701602Cancelled May 24, 1993 · Exported to South Korea · Stratford, CTN7265HSikorsky S-70B · S/N 70461Cancelled Mar 5, 1991 · Exported to Australia · Statford, CTN4931YSikorsky S-76A · S/N 760036Cancelled Jan 31, 1980 · Exported to United Kingdom · Stratford, CT
Back to United Technologies Corporation