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.
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
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.
N61735Hughes Helicopters HUGHES 369D · S/N 690534DN73246Bell 47G-3B · S/N 2778N90888Sikorsky S-58E · S/N 58-374N7922SBell 47G-3B-1 · S/N 6593N7876SBell 206A · S/N 64N4767RBell 205A-1 · S/N 30027N1353XBell 47G-4A · S/N 7536N83047Bell 205A-1 · S/N 30116N83006Bell 205A-1 · S/N 30114N7033JBell 205A-1 · S/N 30098N343VBeech C-45G · S/N AF-213N8542FBell 47G-3B-1 · S/N 3392N6245NBell 47G-3B-1 · S/N 6660N7821SBell 47G-4A · S/N 7564N7917SBell 47G-4A · S/N 7552N944NABell 47J-2 · S/N 1856N1163WBell 47J-2A · S/N 3131N6272NBell 47G-5 · S/N 7885N6246NBell 206A · S/N 109N8477EBell 47G-2A · S/N 2673N2468BBell 47G-2 · S/N 1473N6706DBell 47G-2 · S/N 2194N966BBell 47G-2 · S/N 1347N9737ZBell 47G-2 · S/N 31N3076GBell 47G-4 · S/N 3146N5150BBell 47J · S/N 1721N8534FBell 47G-4 · S/N 3375N6713DBell 47G-2 · S/N 2205N1374NBell 47G-2 · S/N 668
Back to Utility Helicopters Inc