OpenAirDocs.org
Westfield, MA

Registered aircraft · 37

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

N106PBBurrows Paul J BOWERS FLY BABY 1A · S/N 918Built 1996 · Pioneer Valley Military & Transportation MuseumN11970Cessna 150L · S/N 15075748Kiforishin SamuelN12291Cessna 172M · S/N 17261913Built 1973 · Cisek Jason MN1389TPiper PA-28-180 · S/N 28-7205292Built 1972 · R And S Flying LLCN15240Piper PA-32-300 · S/N 32-7340025Built 1972 · Mitchell Joseph BN16317Piper PA-28-140 · S/N 28-7325223Built 1973 · Wolf Aviation Network IncN171XXSchempp-Hirth K G MINI-NIMBUS C · S/N 103Built 1978 · Guay MarkN2574WGibbo Gear BB103 · S/N 2002-20Built 2002 · Westfield Technical AcademyN2669TPiper PA-28-140 · S/N 28-7225082City Of WestfieldN27ACCirrus Design SR20 · S/N 9807Built 2024 · N27ac LLCN34616Cessna 177B · S/N 17701904Built 1973 · Gois PaulN3573QCessna 172M · S/N 17261677Built 1973 · Fly Lugu LLCN39803Aer-Pegaso M-100S · S/N 059Built 1965 · Pioneer Valley Military & Transportation MuseumN401BDDavid Mccurdy/Brian Erickson 400 · S/N 1BDBuilt 2021 · Pioneer Valley Military And Transportation MuseumN413ACCirrus Design SR22T · S/N 9079Built 2023 · Jibber Aviation LLCN413MMHelio H-395 · S/N 1005Built 1960 · Doyle Brian GN44668Piper PA-28-151 · S/N 28-7415700Built 1974 · Wolf Aviation Network IncN4860Kornmeyer David L PIETENPOL-AIR CAMPER · S/N 001Built 2021 · Westfield Aviation MuseumN5069JBeech T42 · S/N 65-12714Westfield Public SchoolsN515ACPiper PA-28-181 · S/N 28020037N515ac LLCN51639Cessna UC-78 · S/N 5043Pioneer Valley Military And Transportation MuseumN523ACCirrus Design SR22T · S/N 11113Built 2026 · Jibber Aviation LLCN555AGGlasflugel MOSQUITO · S/N 76Built 1977 · Guay Mark WN56596Piper PA-28-180 · S/N 28-7405021Built 1973 · Gutowski Michael HN578ACCirrus Design SR20 · S/N 11308Built 2026 · N578ac LLCN59411Ryan Aeronautical ST3KR · S/N 1366Built 1941 · Avezzie HarlandN6109WPiper PA-28-140 · S/N 28-20123Built 1964 · City Of WestfieldN6132JPiper PA-28-151 · S/N 28-7615309Built 1976 · Wolf Aviation Network IncN616ACPiper PA-28-181 · S/N 28020038Built 2021 · N616ac LLCN6837NMooney M20C · S/N 680126Built 1968 · Bloom AlexsandrN711VVBeech B200 · S/N BB-1365Built 1990 · Maynard Aviation LLCN73HAFairchild M-62C(PT-23A) · S/N 331H0Built 1943 · Avezzie Harland CN824RApollo MONSOON · S/N 000012Built 2009 · Regan Kenneth MN904KWKudelka Keven W RV-6A · S/N 25904Kudelka Keven WN914XXStephen J Lantz JUST SUPERSTOL JA30 · S/N JA 288-02-13Fitzgerald Robert S IIIN9215LAmerican AA-1A · S/N AA1A-0115Built 1971 · Dipietro IanN9251SBeech B24R · S/N MC-387Built 1975 · Aayan Air LLC
Back to Westfield, MA