Northwest Helicopters LLC
Registered aircraft · 48
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 = 'NORTHWEST HELICOPTERS LLC' OR list_contains(g.other_registrant_names, 'NORTHWEST HELICOPTERS 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 = 'NORTHWEST HELICOPTERS LLC' OR list_contains(g.other_registrant_names, 'NORTHWEST HELICOPTERS 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.
N1304XBell 204-B · S/N 3169N2048PBell UH-1H · S/N 65-9602N204NWBell 204-B · S/N 2050N260NWSikorsky EH-60A · S/N 84-24025N302WHBell UH-1H · S/N 7422302N347AMBell UH-1H · S/N 74-22331N360NHSikorsky UH-60A · S/N 82-23725N362JNSikorsky UH-60L · S/N 89-26161N3814BBell UH-1H · S/N 66-00930N3819NBell UH-1H · S/N 69-15350N381TBBell UH-1H · S/N 70-15738N382ABBell UH-1H · S/N 69-15026N382DBBell UH-1H · S/N 66-17120N411KSBell 206B · S/N 1128N432KNBell UH-1H · S/N 13901N433ZNBell UH-1H · S/N 71-20170N4432WBell UH-1H · S/N 68-15784N443YBBell UH-1H · S/N 68-16261N460NWSikorsky UH-60A · S/N 87-24588N464NWSikorsky UH-60A · S/N 79-23338N50513Bell UH-1H · S/N 65-09805N536ZNSikorsky UH-60A · S/N 79-23292N5381VHiller UH-12E · S/N 2080N560NHSikorsky UH-60L · S/N 90-26254N64NHBell UH-1H · S/N 6413672N660NWSikorsky UH-60A · S/N 86-24494N668NWSikorsky UH-60A · S/N 82-23730N67SHBell TAH-1P · S/N 7622707N6828Bell UH-1H · S/N 66-00828N69NWMcdonnell Douglas Helicopter 369E · S/N 0435EN7091EBell UH-1H · S/N 67-17350N7095YBell UH-1H · S/N 63-08748N7106SBell UH-1H · S/N 64-13650N71083Bell UH-1H · S/N 65-09852N7123XBell UH-1H · S/N 70-16313N71290Bell UH-1H · S/N 70-16517N71NHBell UH-1H · S/N 6915394N722LMBell 206-L4 · S/N 52111N760NHSikorsky UH-60A · S/N 84-24016N860NHSikorsky UH-60A · S/N 8423991N876EMBell UH-1H · S/N 66-16048N876GMBell UH-1H · S/N 66-16006N9007NAerospatiale SA315B · S/N 2542N915BLFairchild Hiller FH-1100 · S/N 158N938AASikorsky UH-60A · S/N 81-23609N9446HSikorsky UH-60A · S/N 83-23876N963NWNorthwest Rotorcraft UH-60A · S/N 80-23421N97NWBell UH-1H · S/N 65-09823
Back to Northwest Helicopters LLC