OpenAirDocs.org
Northampton, MA

Registered aircraft · 29

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 = 'MA' AND g.registrant_city = 'NORTHAMPTON'
  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.

N173TMSocata TBM 700 · S/N 533Built 2010 · Ellegeegee CorpN17968Schweizer SGS 2-33A · S/N 270Built 1973 · Northampton Aeronautics IncN17NAPiper PA-28-161 · S/N 28-8316067Built 1983 · Hampden Aviation Services IncN2157YPiper PA-28-181 · S/N 28-7990376Registration pendingBuilt 1979N23NAPiper PA-28-161 · S/N 28-7716036Built 1977 · Northampton Aeronautics IncN28820Christen Industries A-1 · S/N 1014Built 1987 · Elite Flying Group LLCN30130Waco UPF-7 · S/N 5527Built 1940 · Race Aviation IncN32NAPiper PA-28-161 · S/N 28-8316023Built 1982 · Hampden Aviation Services IncN440GWGrumman G-44A · S/N 1410Built 1945 · Race Aviation IncN4923NBoeing E75 · S/N 75-8216Built 1940 · N4923n LLCN56607Piper PA-28-180 · S/N 28-7405022Built 1973 · Arsenault Mark EN56NAPiper PA-28-161 · S/N 28-8016073Built 1979 · Hampden Aviation Services IncN5GJGrumman American Avn. GA-7 · S/N GA7-0006Built 1978 · Northampton Lsa LLCN601RKBeech 76 · S/N ME-71Built 1978 · Northampton Aeronautics IncN60NAPiper PA-28-161 · S/N 28-8116049Built 1980 · Hampden Aviation Services IncN614RCCirrus Design SR22 · S/N 0249Built 2002 · Macisaac RichardN64273American Champion 8KCAB · S/N 1131-2013Built 2013 · Bacon RobertN642SBBurwell Stephen R BURWELL RV6 · S/N 24862Built 2004 · Bloomberg David CN65296Harlow PJC-2 · S/N 7Built 1940 · Malkin Matthew CN703GBAero SP Z O O AT-4 LSA · S/N AT4-003Built 2007 · Northampton Lsa LLCN722JPFlight Design CTSW · S/N 06-01-12Built 2006 · Dobson Eric MN7968TCessna 175A · S/N 56668Built 1960 · Siegel Donald SN79NAPiper PA-28-161 · S/N 28-7816276Built 1977 · Northampton Aeronautics IncN85NAPiper PA-28-161 · S/N 287816296Hampden Aviation Services IncN9238NMaule MX-7-160 · S/N 19012CBuilt 1993 · Bloomberg David CN927QBeech 35-A33 · S/N CD-385Built 1962 · Cumulonimbus LLCN94513Cessna 152 · S/N 15285702Built 1983 · Hampden Aviation Services IncN94NAPiper PA-28R-201 · S/N 2844003Registration pendingN9616VMooney M20E · S/N 21-0022Built 1971 · Florio Michael J Jr Owner
Back to Northampton, MA