Skip to content

United Technologies Corp

Earlier aircraft under this name · 59

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

Query with SQL

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 CORP' OR list_contains(d.other_registrant_names, 'UNITED TECHNOLOGIES CORP') ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

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

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 CORP' OR list_contains(d.other_registrant_names, 'UNITED TECHNOLOGIES CORP')
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N494TWLockheed 749A-79 · S/N 2601Cancelled Apr 25, 2005 · Exported to South Korea · Built 1948 · East Hartford, CT N3123DSikorsky S-76B · S/N 760262Cancelled Jul 6, 1999 · Triennial form not returned · Stratford, CT N50056Sikorsky S-70A-28 · S/N 701882Cancelled Jul 18, 1994 · Exported to Turkey · Stratford, CT N5009SSikorsky S-76B · S/N 760404Cancelled Oct 5, 1993 · Exported to South Korea · Stratford, CT N5001XSikorsky S-70A-18 · S/N 701619Cancelled Jul 6, 1993 · Exported to South Korea · Stratford, CT N50013Sikorsky S-70C(M)-1 · S/N 701580Cancelled May 24, 1993 · Exported to Taiwan · Stratford, CT N5002GSikorsky S-70A-18 · S/N 701620Cancelled May 24, 1993 · Exported to South Korea · Stratford, CT N5002WSikorsky S-70C(M)-1 · S/N 701568Cancelled May 24, 1993 · Exported to Taiwan · Stratford, CT N5003CSikorsky S-70A-18 · S/N 701713Cancelled May 24, 1993 · Exported to South Korea · Stratford, CT N5005USikorsky S-70C(M)-1 · S/N 701586Cancelled May 24, 1993 · Exported to Taiwan · Stratford, CT N7268ASikorsky S-70A-22 · S/N 701483Cancelled May 24, 1993 · Exported to South Korea · Stratford, CT N761LSikorsky S-76A · S/N 760068Cancelled Dec 19, 1990 · Exported to Australia · Stratford, CT N3122XSikorsky S-70A-5 · S/N 70587Cancelled Apr 12, 1984 · Exported to Philippines · Stratford, CT N5422ASikorsky S-76A · S/N 760210Cancelled Apr 19, 1983 · Exported to Japan · Stratford, CT N3120YSikorsky S-76 · S/N 760194Cancelled Nov 5, 1982 · Exported to Indonesia · Stratford, CT N3121ASikorsky S-76 · S/N 760195Cancelled Nov 5, 1982 · Exported to Indonesia · Stratford, CT N5446USikorsky S-76 · S/N 760179Cancelled Nov 5, 1982 · Exported to Indonesia · Stratford, CT N82801Sikorsky H-34 · S/N 58-532Cancelled Oct 15, 1981 · Stratford, CT N82803Sikorsky H-34 · S/N 58-833Cancelled Oct 15, 1981 · Stratford, CT N37701Sikorsky H-34 · S/N 58-1813Cancelled May 5, 1981 · Stratford, CT N37702Sikorsky H-34 · S/N 58-1504Cancelled May 5, 1981 · Stratford, CT N37704Sikorsky H-34 · S/N 58-1512Cancelled May 5, 1981 · Stratford, CT N37705Sikorsky H-34 · S/N 58-1578Cancelled May 5, 1981 · Stratford, CT N37706Sikorsky H-34 · S/N 58-1566Cancelled May 5, 1981 · Stratford, CT N1547USikorsky S-76A · S/N 760089Cancelled Nov 25, 1980 · Exported to Jordan · Built 1980 · Stratford, CT N1548KSikorsky S-76A · S/N 760090Cancelled Oct 24, 1980 · Exported to Jordan · Built 1980 · Stratford, CT N5514XSikorsky S-76A · S/N 760044Cancelled Mar 4, 1980 · Exported to Canada · Stratford, CT N49293Sikorsky S-76A · S/N 760033Cancelled Jan 15, 1980 · Exported to Brazil · Stratford, CT N4245SSikorsky S-76A · S/N 760020Cancelled Jan 14, 1980 · Exported to Brazil · Built 1979 · Stratford, CT N4248SSikorsky S-76A · S/N 760023Cancelled Dec 26, 1979 · Exported to Brazil · Stratford, CT N4247SSikorsky S-76A · S/N 760022Cancelled Nov 8, 1979 · Exported to United Kingdom · Built 1979 · Stratford, CT N4246SSikorsky S-76 · S/N 760021Cancelled Nov 5, 1979 · Exported to United Kingdom · Built 1979 · Stratford, CT N4244SSikorsky S-76A · S/N 760018Cancelled Nov 1, 1979 · Exported to United Kingdom · Built 1979 · Stratford, CT N4243SSikorsky S-76A · S/N 760017Cancelled Oct 2, 1979 · Exported to Canada · Stratford, CT N4232SSikorsky S-76 · S/N 76007Cancelled Sep 17, 1979 · Exported to Brazil · Built 1979 · Stratford, CT N4233SSikorsky S-76A · S/N 760008Cancelled Sep 17, 1979 · Exported to Brazil · Stratford, CT N4235SSikorsky S-76A · S/N 760010Cancelled Aug 10, 1979 · Exported to Bahrain · Built 1979 · Stratford, CT N4230SSikorsky S-76 · S/N 760005Cancelled Apr 17, 1979 · Exported to Australia · Built 1979 · Stratford, CT N4229SSikorsky S-76 · S/N 76004Cancelled Apr 13, 1979 · Exported to Canada · Built 1979 · Stratford, CT N37707Sikorsky H-34 · S/N 58-1526Cancelled Jun 15, 1977 · Exported to Thailand · Stratford, CT N4227SSikorsky S-61A-4 · S/N 61785Cancelled May 11, 1977 · Exported to Malaysia · Built 1977 · Stratford, CT N4226SSikorsky S-61A · S/N 61784Cancelled Mar 2, 1977 · Exported to Malaysia · Stratford, CT N4225SSikorsky S-61A · S/N 61783Cancelled Feb 24, 1977 · Exported to Malaysia · Built 1976 · Stratford, CT N4221SSikorsky S-61A · S/N 61780Cancelled Jan 18, 1977 · Exported to Malaysia · Built 1976 · Stratford, CT N4224SSikorsky S-61A · S/N 61782Cancelled Jan 17, 1977 · Exported to Malaysia · Built 1976 · Stratford, CT N37715Sikorsky H-34 · S/N 58-1091Cancelled Jan 6, 1976 · Exported to Venezuela · Built 1974 · Stratford, CT N37700Sikorsky H-34 · S/N 58-1632Cancelled Dec 15, 1975 · Exported to Brazil · Built 1974 · Stratford, CT N4220SSikorsky S-65C · S/N 65409Cancelled Oct 17, 1975 · Exported to Israel · Stratford, CT N4044SSikorsky S-65C · S/N 65402Cancelled Oct 10, 1975 · Exported to Israel · Stratford, CT N4045SSikorsky S-65C3 · S/N 65403Cancelled Oct 10, 1975 · Exported to Israel · Built 1975 · Stratford, CT

Back to United Technologies Corp