# Cancelled registrations: Brockton, MA

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

Cancelled aircraft registrations in Brockton, MA.

- [N46121](https://openairdocs.org/deregistered/N46121-2018-04-05.md): Aeronca 0-58B · S/N 058B4012 · Cancelled Apr 5, 2018 · Revoked, canceled · Built 1942 · Howard Arthur D Co-Ow
- [N83863](https://openairdocs.org/deregistered/N83863-2018-03-08.md): Aeronca 7AC · S/N 7AC-2544 · Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1946 · Schmouth John D
- [N27777](https://openairdocs.org/deregistered/N27777-2017-11-22.md): Stinson 10A · S/N 7721 · Cancelled Nov 22, 2017 · Revoked, canceled · Built 1940 · Johnson George H
- [N5872A](https://openairdocs.org/deregistered/N5872A-2014-10-29.md): Cessna 172 · S/N 28472 · Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1956 · Meehan John F
- [N38135](https://openairdocs.org/deregistered/N38135-2013-08-07.md): Piper J5A · S/N 5-884 · Cancelled Aug 7, 2013 · Sale reported, canceled · Built 1941
- [N62141](https://openairdocs.org/deregistered/N62141-2012-10-04.md): Jean SCORPION ONE PLACE · S/N 101B · Cancelled Oct 4, 2012 · Sale reported, pending cancellation · Built 1975
- [N8116E](https://openairdocs.org/deregistered/N8116E-2005-04-14.md): Mooney M20A · S/N 1387 · Cancelled Apr 14, 2005 · Triennial form undeliverable · Built 1959 · Sullivan James P
- [N5119D](https://openairdocs.org/deregistered/N5119D-1992-08-20.md): Cessna 182A · S/N 51219 · Cancelled Aug 20, 1992 · Triennial form not returned · Parsons William T
- [N9071K](https://openairdocs.org/deregistered/N9071K-1974-09-26.md): Stinson 108-1 · S/N 108-2071 · Cancelled Sep 26, 1974 · Brockton Flying Club Inc
- [N9553S](https://openairdocs.org/deregistered/N9553S-1974-05-06.md): Champion 7ECA · S/N 285 · Cancelled May 6, 1974 · Exported to Canada · Charles F Fenton Jr
- [N8320A](https://openairdocs.org/deregistered/N8320A-1971-02-16.md): Cessna 170B · S/N 25172 · Cancelled Feb 16, 1971 · Brockton Flying Club Inc
- [N88606](https://openairdocs.org/deregistered/N88606-1956-02-24.md): Piper J-3C · S/N 16234 · Cancelled Feb 24, 1956 · New England Air Spray And Dusting Co
- [N9159K](https://openairdocs.org/deregistered/N9159K-1956-02-14.md): Stinson 108-1 · S/N 108-2159 · Cancelled Feb 14, 1956 · Brockton Airways Inc
- [N46326](https://openairdocs.org/deregistered/N46326-1956-02-01.md): Piper J3C-65 · S/N G-199 · Cancelled Feb 1, 1956 · New England Air Spray And Dusting Co Inc
- [N2585M](https://openairdocs.org/deregistered/N2585M-1949-06-07.md): Piper PA-12 · S/N 12-1039 · Cancelled Jun 7, 1949 · Stryer William
- [N13043](https://openairdocs.org/deregistered/N13043-1948-07-19.md): Waco UEC · S/N 3658 · Cancelled Jul 19, 1948 · Whitman William P
- [N1243E](https://openairdocs.org/deregistered/N1243E-1948-05-14.md): Aeronca 7AC · S/N 7AC-4801 · Cancelled May 14, 1948 · Brockton Airways Inc
- [N728N](https://openairdocs.org/deregistered/N728N-1933-01-12.md): Malouin George J JR MALOUIN GLIDER · S/N 1 · Cancelled Jan 12, 1933 · George J Malouin Jr

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

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