OpenAirDocs.org
Lihue, HI

Registered aircraft · 30

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

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_state = 'HI' AND g.registrant_city = 'LIHUE'
  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.

N144KWRobinson Helicopter R44 · S/N 12805Built 2009 · Aloha Helicopter Tours LLCN151CDRobinson Helicopter R44 · S/N 1705Built 2007 · Aloha Helicopter Tours LLCN241AKSims Scott DVM DYNAMIC WT-9 · S/N DY-K12/2006Built 2007 · Smith Norton RN251HEurocopter AS 350 B2 · S/N 3975Built 2005 · Island Helicopters Kauai IncN274CDRobinson Helicopter R44 II · S/N 10649Built 2005 · Aloha Helicopter Tours LLCN346WWaco Classic YMF-F5C · S/N F5C-8-146Built 2016 · Air Ventures Hawaii LLCN369JHHughes Helicopters 369E · S/N 0145EBuilt 1985 · Jack Harter Helicopters IncN451HEurocopter AS 350 B2 · S/N 3231Built 1999 · Island Helicopters Kauai IncN454JHMcdonnell Douglas Helicopter 369E · S/N 0454EBuilt 1991 · Jack Harter Helicopters IncN457CDRobinson Helicopter R44 II · S/N 13302Built 2012 · Aloha Helicopter Tours LLCN506CDRobinson Helicopter R44 · S/N 1976Built 2008 · Aloha Helicopter Tours LLCN588AVGippsland Aeronautics PTY GA 8 · S/N GA8-05-076Built 2005 · Air Ventures Hawaii LLCN6162VCessna 182T · S/N 18281373Built 2004 · Air Ventures Hawaii LLCN633JHMcdonnell Douglas Helicopter 369E · S/N 0230EBuilt 1987 · Jack Harter Helicopters IncN67923Cessna 152 · S/N 15282101Kaluahine Fredstan KN699AVGippsland GA-8 · S/N GA8-06-106Built 2006 · Air Ventures Hawaii LLCN702SAEurocopter AS 350 B2 · S/N 3551Built 2002 · Saf LtdN711JHEurocopter AS 350 B2 · S/N 3397Built 2001 · Jack Harter Helicopters IncN716KVMcdonnell Douglas Helicopter 369E · S/N 0407EBuilt 1990 · Aa Leasing LpN721AVGippsland GA-8 · S/N GA8-07-121Built 2007 · Air Ventures Hawaii LLCN801HEurocopter AS 350 B2 · S/N 7788Built 2013 · Island Helicopters Kauai IncN808SAEurocopter AS 350 B2 · S/N 3347Built 2000 · Saf LtdN812BZRobinson Helicopter R44 II · S/N 12021Aloha Helicopter Tours LLCN822AVGippsland Aeronautics PTY GA 8 · S/N GA8-05-082Air Ventures Hawaii LLCN842JHHughes Helicopters 369E · S/N 0020EBuilt 1983 · Jack Harter Helicopters IncN909SCessna 152 · S/N 15280969Kaluahine FredstanN911HKMD Helicopters 369FF · S/N 0173FFBuilt 2009 · County Of Kauai-Fire DepartmentN963SAAerospatiale AS350 B2 ECUREUIL · S/N 2855Built 1995 · Saf LtdN964SAEurocopter AS 350 B2 · S/N 2931Built 1996 · Saf LtdN995ADDoughty Andrew AIRCAM · S/N AC154Built 2011 · Smith Norton R
Back to Lihue, HI