Helicopter Services Inc
Earlier aircraft under this name · 28
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 = 'HELICOPTER SERVICES INC' OR list_contains(d.other_registrant_names, 'HELICOPTER SERVICES 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 = 'HELICOPTER SERVICES INC' OR list_contains(d.other_registrant_names, 'HELICOPTER SERVICES 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.
N906BAS N I A S AS-350B ECUREUIL · S/N 1479N2109UBrantly B-2 · S/N 136N278RGS N I A S AS350BA · S/N 1355N512PHAmerican Eurocopter AS350B3 · S/N 4607N849KSSchweizer 269C-1 · S/N 0310N582HSSikorsky S-58 · S/N S58-061N585HSSikorsky S-58 · S/N 581745N586HSSikorsky S-58 · S/N 58128N587HSSikorsky S-58 · S/N 58-451DN583HSSikorsky S-58 · S/N S58-226N584HSSikorsky S-58 · S/N S58-841N4214LSikorsky S-58 · S/N 58008N9435FHughes 269B · S/N 0190N36GHBell 206B · S/N 233N234LARobinson Helicopter R22 BETA · S/N 3534N281RGRobinson Helicopter R22 BETA · S/N 4250N3083KRobinson Helicopter R22 BETA · S/N 4049N15VHAerospatiale AS350B · S/N 1554N7534SRobinson Helicopter R22 BETA · S/N 3657N747LFRobinson Helicopter R22 BETA · S/N 2961N6145HSchweizer 269C · S/N S1645N7198HRobinson Helicopter R22 BETA · S/N 3165N8332FRobinson Helicopter R22 BETA · S/N 2594N126TVEurocopter AS 350 B2 ECUREUIL · S/N 2944N8316WRobinson Helicopter R22 BETA · S/N 2482N8731FHughes 269A · S/N 12-0036N8853FHughes 269A · S/N 53-0212N5774MCessna 310P · S/N 310P0074
Back to Helicopter Services Inc