# Cancelled registrations: Westfield, MA

A list on [Westfield, MA](https://openairdocs.org/faa-place/MA/Westfield.md).

Cancelled aircraft registrations in Westfield, MA.

- [N434AC](https://openairdocs.org/deregistered/N434AC-2024-04-22.md): Cirrus Design SR20 · S/N 8731 · Cancelled Apr 22, 2024 · Exported to Canada · Built 2022 · N434ac LLC
- [N3136K](https://openairdocs.org/deregistered/N3136K-2015-05-05.md): French Charles W SCORPION · S/N CWF-1 · Cancelled May 5, 2015 · Registration expired, pending cancellation · French Charles W
- [N6791A](https://openairdocs.org/deregistered/N6791A-2013-05-02.md): Cessna 172 · S/N 28891 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1956 · Zepko George C
- [N1113D](https://openairdocs.org/deregistered/N1113D-2012-06-04.md): Flying Dutchman D-1 · S/N LFD-13 · Cancelled Jun 4, 2012 · Registration expired, pending cancellation · Built 1967 · Sinclair Donald C DBA
- [N704WX](https://openairdocs.org/deregistered/N704WX-2011-07-22.md): Cessna 150M · S/N 15078942 · Cancelled Jul 22, 2011 · Expired dealer · Built 1976 · Charis Air Corp
- [N2980X](https://openairdocs.org/deregistered/N2980X-2009-09-29.md): Cessna 177 · S/N 17700380 · Cancelled Sep 29, 2009 · Built 1967 · Dion Paul E
- [N16040](https://openairdocs.org/deregistered/N16040-2002-05-30.md): Cessna 150L · S/N 15073433 · Cancelled May 30, 2002 · Triennial form not returned · Built 1972 · Air Fleet Management Inc
- [N704ZY](https://openairdocs.org/deregistered/N704ZY-1999-04-28.md): Cessna 150M · S/N 15079014 · Cancelled Apr 28, 1999 · Triennial form not returned · Built 1976 · Air Fleet Management Inc
- [N71WH](https://openairdocs.org/deregistered/N71WH-1993-11-16.md): Hampton William JR AIR COMMAND 582 · S/N 699 · Cancelled Nov 16, 1993 · Associated Air Services Inc
- [N5220X](https://openairdocs.org/deregistered/N5220X-1992-11-12.md): Champion 7KCAB · S/N 199 · Cancelled Nov 12, 1992 · Triennial form not returned · Nesin Asher
- [N794Y](https://openairdocs.org/deregistered/N794Y-1983-10-26.md): Beech 76 · S/N ME-180 · Cancelled Oct 26, 1983 · Mills Frank G
- [N53078](https://openairdocs.org/deregistered/N53078-1980-09-25.md): Cessna 177RG · S/N 177RG01339 · Cancelled Sep 25, 1980 · Exported to Germany · Built 1978 · Standard Air Service Inc
- [N68712](https://openairdocs.org/deregistered/N68712-1980-09-02.md): Cessna 152 · S/N 15282328 · Cancelled Sep 2, 1980 · Exported to Iceland · Standard Air Service Inc
- [N737QA](https://openairdocs.org/deregistered/N737QA-1980-07-07.md): Cessna 172N · S/N 17269581 · Cancelled Jul 7, 1980 · Exported to Iceland · Standard Air Services Inc
- [N1735J](https://openairdocs.org/deregistered/N1735J-1979-06-30.md): Piper PA-28-140 · S/N 28-24149 · Cancelled Jun 30, 1979 · Built 1968 · Omni Aviation
- [N273RC](https://openairdocs.org/deregistered/N273RC-1978-01-13.md): Cessna 500 · S/N 5000273 · Cancelled Jan 13, 1978 · Exported to Mexico · Standard Air Services Inc
- [N71550](https://openairdocs.org/deregistered/N71550-1975-06-30.md): Cessna 182 · S/N 182-59661 · Cancelled Jun 30, 1975 · Barnes Aviation Inc
- [N800V](https://openairdocs.org/deregistered/N800V-1955-02-23.md): Waco RNF · S/N 3273 · Cancelled Feb 23, 1955 · Zehr Willard A
- [N4506M](https://openairdocs.org/deregistered/N4506M-1952-08-25.md): Piper PA-11 · S/N 11-10 · Cancelled Aug 25, 1952 · E W Wiggins Airways Inc
- [N34654](https://openairdocs.org/deregistered/N34654-1951-07-02.md): Stinson 10A · S/N 8054 · Cancelled Jul 2, 1951 · Kellogg Brush Mfg Co
- [N7029](https://openairdocs.org/deregistered/N7029-1948-03-31.md): Atlantic FOKKER UNIVERSAL · S/N 434 · Cancelled Mar 31, 1948 · Built 1928 · Howe Samuel T
- [N786H](https://openairdocs.org/deregistered/N786H-1943-09-24.md): Stearman 6L · S/N 6001 · Cancelled Sep 24, 1943 · Built 1930 · Charles P O'Connor

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT d.n_number, d.cancel_date, d.status, d.export_country, d.serial_number, d.year_manufactured, m.manufacturer, m.model, d.registrant_name, d.registrant_city, d.registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_deregistration.parquet' d LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = d.aircraft_model_code
WHERE d.registrant_state = 'MA' AND d.registrant_city = 'WESTFIELD'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/MA/Westfield/earlier

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.