OpenAirDocs.org
Waialua, HI

Registered aircraft · 32

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 = 'WAIALUA'
  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.

N1052YI.C.A.-Brasov IS-28B2 · S/N 213Built 1979 · North Shore Aircraft Leasing Co LLCN109FHBurkhart Grob G-109B · S/N 6367Albatross Aviation Hawaii LLCN1146SSchweizer SGS 2-32 · S/N 76Built 1971 · Honolulu Soaring Club IncN1189SSchweizer SGS 2-32 · S/N 62Built 1972 · Skysurfing Hawaii LLCN1699Glasflugel STANDARD LIBELLE · S/N 33Built 1969 · Lowry Steven DN17948Schweizer SGS 2-32 · S/N 78Built 1973 · Pfisters Flying Wahine LLCN1850Beech C-45H · S/N AF744North Shore Aviation Services CorpN19114Cessna 150L · S/N 15074179Built 1972 · Blackley ScottN232GFSchweizer SGS 2-32 · S/N 43Northshore Aircraft Leasing Co LLCN292XASlingsby T31B · S/N XA-292Soar Hawaii FoundationN301MGSchweizer 269C-1 · S/N 0157Wild BlakeN4232JPiper PA-28-140 · S/N 28-22581N4232j LLCN473GFCessna 305A · S/N 2018Built 1967 · Honolulu Soaring Club IncN56GWMarganski Edward MDM-1 FOX · S/N 201Built 1995 · Gromacki Ana ZN5703SSchweizer SGS 2-33 · S/N 51Built 1967 · Honolulu Soaring Club IncN5723SSchweizer SGS 2-32 · S/N 55Built 1967 · Honolulu Soaring Club IncN5729SSchweizer SGS 2-32 · S/N 56Built 1968 · Honolulu Soaring Club IncN5761SSchweizer SGS 2-32 · S/N 59Built 1968 · Skysurfing Hawaii LLCN6123NBeech 19A · S/N MB-409Built 1969 · Pfisters Flying WahineN674CMCostruzioni Aeronautiche Tecna ASTORE · S/N 066Built 2018 · Blackley ScottN704QHCessna 150M · S/N 15078786Built 1976 · Pfisters Flying Wahaine LLCN7143ECessna 182B · S/N 52143Built 1959 · Pfisters Flying Wahine LLCN787SFBurkhart Grob G103C TWIN III ACRO · S/N 34118Soar Hawaii FoundationN794KSSchleicher ASK-21 · S/N 21220Built 1984 · Albatross Aviation Hawaii LLCN80049Aerotek PITTS S-2A · S/N 2099Hawaii Biplane Adventures LLCN808FUJason Eisenberg MTOCLASSIC · S/N M01960ABuilt 2022 · Gyrocopters Hawaii LLCN808XSGyrocopters Hawaii MTOCLASSIC · S/N M01960Gyrocopters Hawaii LLCN8555LPiper PA-25-260 · S/N 25-4976Built 1969 · North Shore Aircraft Leasing Co LLCN904BGBurkhart Grob Flugzeugbau G109 · S/N 6104Built 1982 · Omphroy Carlos AN912TJames Alaggio MTOSPORT · S/N M01971Built 2022 · Hawaii Rotor Adventures LLCN91540North American NAVION A · S/N NAV-4-322Built 1946 · North Shore Aviation Services CorpN917BAStemme STEMME S 10-VT · S/N 11-109Built 2007 · Hawaii Rotor Adventures LLC
Back to Waialua, HI