# Cancelled registrations: Mansfield, MA

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

Cancelled aircraft registrations in Mansfield, MA.

- [N54819](https://openairdocs.org/deregistered/N54819-2015-05-19.md): Piper PA-23-250 · S/N 27-7554116 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1975 · V P Aviation Inc
- [N591M](https://openairdocs.org/deregistered/N591M-2013-12-30.md): Embraer EMB-120ER · S/N 120316 · Cancelled Dec 30, 2013 · Exported to Zambia · Built 1996 · Vcg Aviation Services LLC
- [N9637C](https://openairdocs.org/deregistered/N9637C-2013-05-23.md): Piper PA-32RT-300 · S/N 32R-7885063 · Cancelled May 23, 2013 · Registration expired, pending cancellation · Built 1978 · Wyman Robert C
- [N68180](https://openairdocs.org/deregistered/N68180-2008-09-08.md): Cessna 152 · S/N 15282167 · Cancelled Sep 8, 2008 · Exported to Philippines · Built 1978 · King Aviation Mansfield Inc
- [N81017](https://openairdocs.org/deregistered/N81017-2007-12-03.md): Piper PA-28-161 · S/N 28-8016096 · Cancelled Dec 3, 2007 · Exported to South Africa · Built 1979 · King Aviation-Mansfield Inc
- [N757HN](https://openairdocs.org/deregistered/N757HN-2007-10-17.md): Cessna 152 · S/N 15279754 · Cancelled Oct 17, 2007 · Exported to South Africa · Built 1977 · King Aviation Mansfield Inc
- [N48750](https://openairdocs.org/deregistered/N48750-2007-05-30.md): Cessna 152 · S/N 15283367 · Cancelled May 30, 2007 · Exported to South Africa · Built 1979 · King Aviation Mansfield Inc
- [N25589](https://openairdocs.org/deregistered/N25589-1998-07-28.md): Cessna 152 · S/N 15280750 · Cancelled Jul 28, 1998 · Triennial form not returned · King Aviation Of Mansfield Inc
- [N2500D](https://openairdocs.org/deregistered/N2500D-1984-01-10.md): Piper PA-38-112 · S/N 38-79A0340 · Cancelled Jan 10, 1984 · Administratively canceled · Cutillo Ralph
- [N5499Q](https://openairdocs.org/deregistered/N5499Q-1973-05-24.md): Cessna 150L · S/N 50-73399 · Cancelled May 24, 1973 · Carleton-Whitney Aero Service Inc
- [N5792G](https://openairdocs.org/deregistered/N5792G-1971-12-06.md): Cessna 150K · S/N 15071292 · Cancelled Dec 6, 1971 · Caretp-Whintney Aero Serv Inc
- [N4498P](https://openairdocs.org/deregistered/N4498P-1970-06-23.md): Piper PA-23-160 · S/N 23-2021 · Cancelled Jun 23, 1970 · Carleton-Whitney Aero Service Inc
- [N42591](https://openairdocs.org/deregistered/N42591-1956-03-05.md): Piper J3C-65 · S/N 14874 · Cancelled Mar 5, 1956 · Sharon Foxboro Airways Inc
- [N43647](https://openairdocs.org/deregistered/N43647-1956-03-01.md): Taylorcraft BC12-D · S/N 7306 · Cancelled Mar 1, 1956 · Sharon Foxboro Airways Inc
- [N27760](https://openairdocs.org/deregistered/N27760-1955-03-23.md): Stinson 10A · S/N 7762 · Cancelled Mar 23, 1955 · Sherman Philip E
- [N3844M](https://openairdocs.org/deregistered/N3844M-1950-02-09.md): Piper PA-12 · S/N 12-2755 · Cancelled Feb 9, 1950 · Sharon Foxboro Airways Inc
- [N8504](https://openairdocs.org/deregistered/N8504-1941-08-01.md): Waco GXE · S/N 1552 · Cancelled Aug 1, 1941 · Garofalo George M

## 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 = 'MANSFIELD'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

This list as a web page: https://openairdocs.org/faa-place/MA/Mansfield/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.
