OpenAirDocs.org
Hawaii Pacific Aviation Inc

Registered aircraft · 29

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 = 'HAWAII PACIFIC AVIATION INC' OR list_contains(g.other_registrant_names, 'HAWAII PACIFIC AVIATION 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.

N120ABRobinson Helicopter R44 II · S/N 10868Built 2005 · Kailua Kona, HIN170PDRobinson Helicopter R66 · S/N 0526Built 2014 · Kailua Kona, HIN217DKRobinson Helicopter R44 · S/N 2556Built 2018 · Kailua Kona, HIN307RBRobinson Helicopter R22 BETA · S/N 3007Built 1999 · Kailua Kona, HIN3126WNew Piper PA-28-181 · S/N 2843621Built 2006 · Kailua Kona, HIN31551Robinson Helicopter R44 II · S/N 11451Built 2006 · Kailua Kona, HIN322ALRobinson Helicopter R44 II · S/N 10559Built 2004 · Kailua Kona, HIN333PJRobinson Helicopter R22 BETA · S/N 3804Built 2005 · Kailua Kona, HIN405CMRobinson Helicopter R22 BETA · S/N 3096Built 2000 · Kailua Kona, HIN4078PRobinson Helicopter R22 BETA · S/N 1806Built 1991 · Kailua Kona, HIN445KPRobinson Helicopter R44 II · S/N 11693Built 2007 · Kailua Kona, HIN461HRobinson Helicopter R22 BETA · S/N 1460Built 1990 · Kailua Kona, HIN4830GCessna 172N · S/N 17273378Built 1979 · Kailua Kona, HIN525MDRobinson Helicopter R44 II · S/N 11510Built 2006 · Kailua Kona, HIN665CTRobinson Helicopter R66 · S/N 0401Built 2013 · Kailua Kona, HIN6KTRobinson Helicopter R22 BETA · S/N 3016Built 2000 · Kailua Kona, HIN7090MRobinson Helicopter R22 BETA · S/N 4714Built 2016 · Kailua Kona, HIN7158SRobinson Helicopter R22 BETA · S/N 3689Built 2004 · Kailua Kona, HIN721HHRobinson Helicopter R22 BETA · S/N 1484Built 1990 · Kailua Kona, HIN739HPCessna 172N · S/N 17270558Built 1978 · Kailua Kona, HIN747KKCessna 172N · S/N 17267651Built 1976 · Kailua Kona, HIN787AJRobinson Helicopter R44 II · S/N 14096Built 2017 · Kailua Kona, HIN788AJRobinson Helicopter R44 II · S/N 10193Kailua Kona, HIN817ABRobinson Helicopter R22 BETA · S/N 1258Kailua Kona, HIN822FRobinson Helicopter R44 II · S/N 10860Built 2005 · Kailua Kona, HIN827CCRobinson Helicopter R66 · S/N 0112Built 2012 · Kailua Kona, HIN8379ZRobinson Helicopter R22 ALPHA · S/N 0491Built 1985 · Kailua Kona, HIN903KCRobinson Helicopter R22 BETA · S/N 1640Built 1991 · Kailua Kona, HIN954JWPiper PA-34-200T · S/N 34-7970429Built 1979 · Kailua Kona, HI
Back to Hawaii Pacific Aviation Inc