Helicopters Inc
Registered aircraft · 57
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 = 'HELICOPTERS INC' OR list_contains(g.other_registrant_names, 'HELICOPTERS INC') 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 = 'HELICOPTERS INC' OR list_contains(g.other_registrant_names, 'HELICOPTERS INC') 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.
N10TVBell 206L-3 · S/N 51399N10XVBell 206-L4 · S/N 52293N11TVBell 206-L4 · S/N 52289N12BQBell 206-L4 · S/N 52012N12YABell Helicopter Textron Canada 505 · S/N 65103N13HDBell 206-L4 · S/N 52152N13NNBell Helicopter Textron Canada 206L-4 · S/N 52380N20TVBell 206-L4 · S/N 52084N21CLBell 407 · S/N 53536N27MBell 206-L4 · S/N 52045N28LLBell Helicopter Textron Canada 407 · S/N 53581N29SBell 206B · S/N 4378N38BLBell 407 · S/N 53368N38BZBell 206-L4 · S/N 52128N39CLBell 407 · S/N 53612N3QYBell 206-L4 · S/N 52224N3YJBell 206B · S/N 4322N42SLBell Helicopter Textron Canada 206L-4 · S/N 52377N43EEBell 206-L4 · S/N 52219N46CLBell 206B-III · S/N 4518N4CQBell 206-L4 · S/N 52088N50GVBell Helicopter Textron Canada 407 · S/N 54864N50QBell 407 · S/N 53565First renewal noticeN553HDBell 407 · S/N 53304N55SLBell Helicopter Textron Canada 206L-4 · S/N 52347N569TBell 206-L4 · S/N 52290N56BLBell 206B · S/N 3502N5NYBell 407 · S/N 53474N5QPBell 206B · S/N 3457N5QVBell 206B · S/N 3098N5TVBell 206B · S/N 4036N61CLBell 206B · S/N 4190N62FBell 206B · S/N 4341N62TVBell Helicopter Textron Canada 206L-4 · S/N 52369N67CLBell 206B · S/N 4530N69FBell 407 · S/N 53025N6QPBell 206-L4 · S/N 52191N6ULBell 206-L4 · S/N 52015N6UXEurocopter AS 350 B3 · S/N 3749N6YJBell 407 · S/N 53066N77NYBell Helicopter Textron Canada 407 · S/N 54148N7QDBell 206-L4 · S/N 52108N7QNBell 206-L4 · S/N 52199N7YJBell 206-L4 · S/N 52026N82FBell 206B-III · S/N 4240N83UBell 206-L4 · S/N 52124N84BLBell 407 · S/N 53291N8QDBell 206B · S/N 4189N8YJBell 206B · S/N 4485N90CLBell 206B · S/N 4066
Back to Helicopters Inc