Skip to content

Earlier aircraft under this name · 25

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

N4033ARobinson Helicopter R44 II · S/N 14128Cancelled Oct 12, 2017 · Exported to China · Costa Mesa, CA N4030FRobinson Helicopter R44 II · S/N 14111Cancelled Sep 22, 2017 · Exported to China · Costa Mesa, CA N4030TRobinson Helicopter R44 II · S/N 14115Cancelled Sep 22, 2017 · Exported to China · Costa Mesa, CA N4029RRobinson Helicopter R44 II · S/N 14110Cancelled Sep 14, 2017 · Exported to China · Costa Mesa, CA N4026PRobinson Helicopter R44 II · S/N 14100Cancelled Sep 1, 2017 · Exported to China · Costa Mesa, CA N7000VRobinson Helicopter R66 · S/N 0321Cancelled Jun 3, 2013 · Exported to Chile · Costa Mesa, CA N4181KRobinson Helicopter R44 II · S/N 12531Cancelled Nov 4, 2008 · Exported to Italy · Costa Mesa, CA N41852Robinson Helicopter R44 II · S/N 12485Cancelled Oct 8, 2008 · Exported to Italy · Costa Mesa, CA N41302Robinson Helicopter R44 II · S/N 12361Cancelled Jul 16, 2008 · Exported to Canada · Costa Mesa, CA N41491Robinson Helicopter R22 BETA · S/N 4314Cancelled May 15, 2008 · Exported to Canada · Costa Mesa, CA N4161MRobinson Helicopter R44 · S/N 1864Cancelled Apr 22, 2008 · Exported to Canada · Costa Mesa, CA N3256SRobinson Helicopter R44 II · S/N 11713Cancelled Apr 27, 2007 · Exported to Canada · Costa Mesa, CA N3129FRobinson Helicopter R44 · S/N 1642Cancelled Sep 11, 2006 · Exported to Canada · Costa Mesa, CA N30968Robinson Helicopter R44 II · S/N 11229Cancelled May 17, 2006 · Exported to Canada · Costa Mesa, CA N74538Robinson Helicopter R44 · S/N 1577Cancelled Mar 17, 2006 · Exported to Canada · Costa Mesa, CA N74506Robinson Helicopter R44 · S/N 1576Cancelled Feb 27, 2006 · Exported to Canada · Costa Mesa, CA N74696Robinson Helicopter R22 BETA · S/N 3935Cancelled Sep 20, 2005 · Exported to Italy · Costa Mesa, CA N85594Robinson Helicopter R22 · S/N 0473Cancelled Jul 22, 2003 · Second triennial mailing, no response · Built 1985 · Santa Ana, CA N7508PRobinson Helicopter R44 · S/N 1271Cancelled Dec 11, 2002 · Exported to Italy · Costa Mesa, CA N7190NRobinson Helicopter R44 · S/N 0924Cancelled Nov 17, 2000 · Exported to Canada · Costa Mesa, CA N8141LRobinson Helicopter R22 BETA · S/N 2413Cancelled Jul 11, 1997 · Exported to Brazil · Costa Mesa, CA N8343GRobinson Helicopter R44 · S/N 0314Cancelled Jul 10, 1997 · Exported to Brazil · Costa Mesa, CA N9070NRobinson Helicopter R22 BETA · S/N 1513Cancelled Feb 5, 1997 · Triennial form not returned · Costa Mesa, CA N8330GRobinson Helicopter R22 BETA · S/N 2566Cancelled Apr 17, 1996 · Exported to Brazil · Costa Mesa, CA N2322BRobinson Helicopter R22 BETA · S/N 2040Cancelled Mar 12, 1992 · Exported to Germany · Costa Mesa, CA

Back to Helistream Inc