# Cancelled registrations: Lynn, MA

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

Cancelled aircraft registrations in Lynn, MA.

- [N58042](https://openairdocs.org/deregistered/N58042-2019-12-20.md): Taylorcraft DC-65 · S/N 5656 · Cancelled Dec 20, 2019 · Revoked, canceled · Built 1943 · Tansey Ruth C
- [N3062K](https://openairdocs.org/deregistered/N3062K-2019-12-09.md): Culver V · S/N V281 · Cancelled Dec 9, 2019 · Revoked, canceled · Built 1946 · Bates Wallace T
- [N158GB](https://openairdocs.org/deregistered/N158GB-2019-11-01.md): DJI PHANTOM 3 PROFESSION · S/N P76DCI15A21480 · Cancelled Nov 1, 2019 · Registration expired, pending cancellation · Alcantara Leandro
- [N6472V](https://openairdocs.org/deregistered/N6472V-2017-05-23.md): Aerostar International RAVEN S-55A · S/N S55A-3026 · Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1987 · Easton Thomas P
- [N808HB](https://openairdocs.org/deregistered/N808HB-2011-02-15.md): Hanold A D/Rascal Indstry EXEC 162-F · S/N 6800 · Cancelled Feb 15, 2011 · Exported to Canada · Built 2004 · Heliboss LLC
- [N9389H](https://openairdocs.org/deregistered/N9389H-2009-09-18.md): Ballard BALLARD · S/N 1 · Cancelled Sep 18, 2009 · Registration revoked · Built 1950 · Ballard Aircraft Co
- [N5610R](https://openairdocs.org/deregistered/N5610R-1997-05-06.md): Cessna 172F · S/N 17253221 · Cancelled May 6, 1997 · Triennial form not returned · Bedford Kenneth L
- [N1836](https://openairdocs.org/deregistered/N1836-1975-05-07.md): Cessna Ector 305A · S/N 2008 · Cancelled May 7, 1975 · Northeastern Light Aircraft Inc
- [N93708](https://openairdocs.org/deregistered/N93708-1974-05-17.md): Engineering & Research ERCOUPE 415-C · S/N 1031 · Cancelled May 17, 1974 · Marvin Peter
- [N844A](https://openairdocs.org/deregistered/N844A-1973-06-25.md): Piper PA-22 · S/N 22-143 · Cancelled Jun 25, 1973 · Built 1955 · West David M
- [N3299G](https://openairdocs.org/deregistered/N3299G-1971-07-19.md): North American T-28A · S/N 50-262A · Cancelled Jul 19, 1971 · Built 1950 · Alfred Hunter Jr
- [N69153](https://openairdocs.org/deregistered/N69153-1970-06-24.md): Timm N2T-1 · S/N 219 · Cancelled Jun 24, 1970 · Spanks Arthur G
- [N20667](https://openairdocs.org/deregistered/N20667-1959-06-17.md): Luscombe 8A · S/N 830 · Cancelled Jun 17, 1959 · Exported to Canada · Hudson Herman L
- [N19801](https://openairdocs.org/deregistered/N19801-1948-05-21.md): Taylorcraft A · S/N 308 · Cancelled May 21, 1948 · Built 1937 · Miga Michael E
- [N21050](https://openairdocs.org/deregistered/N21050-1947-09-29.md): Aeronca KM · S/N KM-7 · Cancelled Sep 29, 1947 · Dudley William G & Arthur W Nichols
- [N3765](https://openairdocs.org/deregistered/N3765-1940-07-11.md): Waco GXE/ASO · S/N 774 · Cancelled Jul 11, 1940 · Built 1927 · Ryan Charles Etal
- [N376V](https://openairdocs.org/deregistered/N376V-1935-10-29.md): Keystone K84 COMMUTER · S/N 315 · Cancelled Oct 29, 1935 · Built 1929 · Pine Tree Airways Inc
- [N6508](https://openairdocs.org/deregistered/N6508-1932-10-13.md): Waco GXE · S/N 1650 · Cancelled Oct 13, 1932 · Walter H Southwick

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

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