OpenAirDocs.org
Gilford, NH

Registered aircraft · 26

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 = 'NH' AND g.registrant_city = 'GILFORD'
  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.

N10YSJohn M NYS RV10 · S/N 41023Built 2012 · Lupo MichaelN1GTCirrus Design SF50 · S/N 0746Built 2026 · Srj LLCN2020QTextron 208B · S/N 208B5610Built 2020 · Karavan LLCN221EZCharles E Lewis SEAREY · S/N 0002Built 2019 · Lewis Charles EN2507KAero Commander 100 · S/N 217Built 1968 · Labonte Stephen MN30DFPiper PA-31-310 · S/N 31-7401263Built 1974 · Dae Aviation Enterprises CorpN3113YCessna 182E · S/N 18254113Built 1962 · Yorkwind LLCN35841Piper PA-31-325 · S/N 31-8012054Built 1980 · Flyingvine LLCN3684QBeech A23A · S/N M-1056Built 1967 · Desmarais Arthur GN38549Piper PA-28-161 · S/N 28-7716268Cohesive Aviation LLCN405SBPiper PA-28-161 · S/N 28-7916139Built 1978 · Sky Bright IncN40812Piper PA-28-180 · S/N 28-7405068Built 1973 · Dae Aviation Enterprises CorpN4178SBeech 58 · S/N TH-652Built 1975 · Glad Aviation LLCN4341XSalyer Gary J AVID MARK IV · S/N 1019Built 2004 · Mekler AlanN473CSTextron 172S · S/N 172S11673Built 2016 · Dae Aviation Enterprises CorpN521CMCirrus Design SR20 · S/N 1558Built 2005 · Shafique TajammulN603NHVans RV-12 · S/N 120250Built 2021 · Mekler AlanN626NJPiper PA-28-151 · S/N 28-7415292Built 1974 · Cohesive Aviation LLCN7140JCessna 172N · S/N 17273901Built 1980 · Cohesive Aviation LLCN77ZAPilatus PC-12/45 · S/N 300Built 1999 · Angel Lou Aviation LLCN8366NPiper PA-28-181 · S/N 28-8190205Built 1981 · Lakes Region Flying Club IncN858CPCessna 172R · S/N 17280539Built 1998 · Dae Aviation Enterprises CorpN878GRCirrus Design SR20 · S/N 2467Built 2018 · Didonna Mildred TrusteeN8881VCessna 172M · S/N 17264240Lien Ronald NN9127MMooney M20M · S/N 27-0299Built 2000 · Ap Aviation LLCN913CLCessna 560XL · S/N 560-5718Built 2007 · Dp Leasing LLC
Back to Gilford, NH