OpenAirDocs.org
Bedford, NH

Registered aircraft · 36

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

N100GDTextron T182T · S/N T18209152Built 2024 · Elp LLCN122WDPiper PA 46-350P · S/N 4636084Built 1997 · Sazerac Air LLCN15SNMaule M-7-235C · S/N 25074CBuilt 2001 · Robinson BrianN191GCAmerican General Acft AG5B · S/N 10020Built 1991 · Hughes Aviation LLCN194HPPiper PA-32R-301 · S/N 3213043Built 1993 · Highwood Consulting Group IncN220SRCirrus Design SR22 · S/N 0391Built 2002 · Briar Flyer LLCN235WTCirrus Design SR22T · S/N 9061Built 2023 · Nelson John RN26865Beech A36 · S/N E-2319Built 1986 · Coastline Bonanza LLCN27TSAnthony A Salerni LANCAIR IV-P · S/N LIV-244Built 2016 · Salerni Anthony AN300GDBell Textron Canada 505 · S/N 65427Built 2022 · Jem Spin LLCN3054RBeech A36 · S/N E-2879Built 1994 · Jamms Aviation LLCN3456LDehavilland BEAVER U-6A · S/N 52-6110Built 1952 · Self Defense Of New England LLC DBAN354DSDiamond Aircraft Ind DA 40 · S/N 40.1082Built 2010 · Randhawa Sandeep SN424CStinson 108-2 · S/N 108-3424Millard Richard JN428FPiper PA-28R-200 · S/N 28R-35201Built 1969 · Clark Robert DN4328BPiper PA-32R-301T · S/N 32R-8429003Built 1983 · Repeta Wayne RobertN48NCAlexander Schleicher ASH 31 MI · S/N 31101Built 2013 · Roelke Richard RN5543ACessna 180 · S/N 32660Built 1956 · Self Defense Of New England LLC DBAN555MGBeech A36 · S/N E-2391Built 1987 · Hampshire Blue Skies LLCN6AACessna LC41-550FG · S/N 411100Built 2008 · General Property Development LLCN700GDTextron 525C · S/N 525C0341Built 2020 · Jem Aviation LLCN717PLSchempp-Hirth Flugzeugbau DUO DISCUS T · S/N 64Duo Papa Lima LLCN7360CCessna U206G · S/N U20603898Kacoyanis John GeorgeN7585DPiper PA-18 · S/N 18-5881Built 1957 · Self Defense Of New England LLC DBAN789LRGulfstream Aerospace GV-SP (G500) · S/N 5100Built 2006 · Nordlys LLCN802RVDimeo Robert RV8 · S/N 80423Built 2006 · Dimeo RobertN82819Aeronca 7AC · S/N 7AC-3362Fitzgerald Cynthia JN8283JVarga 2150A · S/N VAC-129-79Built 1979 · Furey Gale JN8430BPiper PA-32R-301T · S/N 32R-8129097Built 1981 · Trident Aviation LLCN862PADiamond Aircraft Ind DA 62 · S/N 62.C085Built 2024 · Millvale Holdings LLCN8718NPiper PA-28-140 · S/N 28-25623Built 1969 · Kelly Bradford SN89TPMaule MXT-7-180 · S/N 14100CBuilt 2000 · Stratton Scott MN9007ACessna 170A · S/N 18762Built 1949 · Weiszmann ErikN913GKJonker Sailplanes JS3 · S/N 03-107Built 2021 · Kelley Glen AN9153SBeech B24R · S/N MC-400Built 1976 · B Squared IncN9647KStinson 108-2 · S/N 108-2647Built 1947 · Murray Mark A Trustee
Back to Bedford, NH