Utility Helicopters Inc

Earlier aircraft under this name · 29

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 = 'UTILITY HELICOPTERS INC' OR list_contains(d.other_registrant_names, 'UTILITY HELICOPTERS INC')
  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.

N61735Hughes Helicopters HUGHES 369D · S/N 690534DCancelled Jan 6, 2014 · Registration expired · El Cajon, CAN73246Bell 47G-3B · S/N 2778Cancelled May 7, 1974 · Long Beach, CAN90888Sikorsky S-58E · S/N 58-374Cancelled Feb 5, 1974 · Exported to Indonesia · Long Beach, CAN7922SBell 47G-3B-1 · S/N 6593Cancelled Jan 7, 1974 · Exported to New Zealand · Long Beach, CAN7876SBell 206A · S/N 64Cancelled Dec 18, 1973 · Exported to Indonesia · Long Beach, CAN4767RBell 205A-1 · S/N 30027Cancelled Jun 5, 1973 · Exported to Indonesia · Long Beach, CAN1353XBell 47G-4A · S/N 7536Cancelled Apr 9, 1973 · Exported to New Zealand · Long Beach, CAN83047Bell 205A-1 · S/N 30116Cancelled Nov 15, 1972 · Exported to Indonesia · Torrance, CAN83006Bell 205A-1 · S/N 30114Cancelled Oct 16, 1972 · Exported to Indonesia · Long Beach, CAN7033JBell 205A-1 · S/N 30098Cancelled Jul 18, 1972 · Exported to Indonesia · Long Beach, CAN343VBeech C-45G · S/N AF-213Cancelled Apr 17, 1972 · Exported to Indonesia · Long Beach, CAN8542FBell 47G-3B-1 · S/N 3392Cancelled Feb 18, 1971 · Exported to New Zealand · Long Beach, CAN6245NBell 47G-3B-1 · S/N 6660Cancelled Oct 9, 1970 · Exported to Argentina · Long Beach, CAN7821SBell 47G-4A · S/N 7564Cancelled Jul 27, 1970 · Exported to IndonesiaN7917SBell 47G-4A · S/N 7552Cancelled Jul 8, 1970 · Exported to Indonesia · Long Beach, CAN944NABell 47J-2 · S/N 1856Cancelled Jun 25, 1970 · Long Beach, CAN1163WBell 47J-2A · S/N 3131Cancelled Jan 3, 1969 · Exported to New Zealand · Long Beach, CAN6272NBell 47G-5 · S/N 7885Cancelled May 6, 1968 · Exported to Hong Kong · Long Beach, CAN6246NBell 206A · S/N 109Cancelled Jan 26, 1968 · Exported to New Zealand · Built 1967 · Long Beach, CAN8477EBell 47G-2A · S/N 2673Cancelled Nov 14, 1967 · Exported to New Zealand · Long Beach, CAN2468BBell 47G-2 · S/N 1473Cancelled Jul 20, 1967 · Exported to India · Long Beach, CAN6706DBell 47G-2 · S/N 2194Cancelled Jul 20, 1967 · Exported to India · Los Angeles, CAN966BBell 47G-2 · S/N 1347Cancelled Jul 20, 1967 · Exported to India · Long Beach, CAN9737ZBell 47G-2 · S/N 31Cancelled Jul 20, 1967 · Exported to IndiaN3076GBell 47G-4 · S/N 3146Cancelled Mar 31, 1967 · Exported to New Zealand · Long Beach, CAN5150BBell 47J · S/N 1721Cancelled Mar 1, 1967 · Exported to Australia · Long Beach, CAN8534FBell 47G-4 · S/N 3375Cancelled Aug 25, 1965 · Exported to United Kingdom · Long Beach, CAN6713DBell 47G-2 · S/N 2205Cancelled Jun 23, 1965 · Exported to New Zealand · Long Beech, CAN1374NBell 47G-2 · S/N 668Cancelled Jan 9, 1964 · Exported to Australia · Bakersfield, CA
Back to Utility Helicopters Inc