Helicopter Express LLC
Registered aircraft · 42
Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.
Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'HELICOPTER EXPRESS LLC' OR list_contains(g.other_registrant_names, 'HELICOPTER EXPRESS LLC') ORDER BY g.n_number"
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 g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code WHERE g.registrant_name = 'HELICOPTER EXPRESS LLC' OR list_contains(g.other_registrant_names, 'HELICOPTER EXPRESS LLC') ORDER BY g.n_number
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.
N101HXBell Textron Canada 412EP · S/N 39123N103HXBell Textron Canada 412EP · S/N 39125N12HXBell 407 · S/N 53415N14HXBell 407 · S/N 53184N154ACSikorsky S-64E · S/N 64037N159ACSikorsky S-64F · S/N 64084N15HXBell 205A-1 · S/N 30117N16HXBell 205A-1 · S/N 30293N172ACSikorsky S-64E · S/N 64061N173ACSikorsky S-64E · S/N 64015N176ACSikorsky S-64E · S/N 64003N178ACSikorsky S-64F · S/N 64097N179ACSikorsky S-64F · S/N 64091N17HXBell 205A-1 · S/N 30217N189ACErickson S64E · S/N 641001N194ACSikorsky S-64E · S/N 64017N217ACErickson S64E · S/N 64064N218ACErickson S64E · S/N 64033N243ACErickson Air Crane S-64E · S/N 64022N27HXBell 407 · S/N 53012N28HXBell 205A-1 · S/N 30034N29HXBell 206B · S/N 3061N35HXAirbus Helicopters AS 350B3 · S/N 7980N37HXBell 205A-1 · S/N 30038N38HXAirbus Helicopters AS 350B3 · S/N 8006N39HXKaman Aerospace K-1200 · S/N A94-0042N40HXKaman Aerospace K-1200 · S/N A94-0051N41HXBell Helicopter Textron Canada 407 · S/N 53866N43HXKaman Aerospace K-1200 · S/N A94-0029N44HXBell 407 · S/N 53125N46HXBell Helicopter Textron Canada 407 · S/N 53641N52HXBell Helicopter Textron Canada 429 · S/N 57026N600HXSikorsky S-64F · S/N 64081N610HXErickson S-64F · S/N 64F5001N615HXSikorsky S-64E · S/N 64065N625HXSikorsky S-64E · S/N 64034DN630HXSikorsky S-64F · S/N 64093N655HXErickson S64E · S/N 64052N6962RSikorsky S-64E · S/N 64058N6HEBell 407 · S/N 53235N88HXKaman Aerospace K-1200 · S/N A94-0054N90HXBell Helicopter Textron Canada 412EP · S/N 39101
Back to Helicopter Express LLC