# Cancelled registrations: East Boston, MA

A list on [East Boston, MA](https://openairdocs.org/faa-place/MA/East%20Boston.md).

Cancelled aircraft registrations in East Boston, MA.

- [N19RL](https://openairdocs.org/deregistered/N19RL-2020-03-11.md): Leftwich William S LM-1X · S/N LM-1X-1001 · Cancelled Mar 11, 2020 · Lockyer Robert
- [N4530P](https://openairdocs.org/deregistered/N4530P-2014-10-09.md): Piper PA-23-250 · S/N 27-34 · Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1960 · Sabia Joseph E
- [N186CM](https://openairdocs.org/deregistered/N186CM-2014-09-10.md): Piper J3C-65 · S/N 20340 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 1946 · Cravotta Phillip S
- [N204E](https://openairdocs.org/deregistered/N204E-1971-11-08.md): Dehavilland DHC-6 TWIN OTTER · S/N 108 · Cancelled Nov 8, 1971 · Exported to Canada · Executive Airlines Inc
- [N90670](https://openairdocs.org/deregistered/N90670-1970-06-30.md): Convair 240-2 · S/N 90 · Cancelled Jun 30, 1970 · Northeast Airlines Inc
- [N90659](https://openairdocs.org/deregistered/N90659-1959-02-10.md): Convair 240 · S/N 34 · Cancelled Feb 10, 1959 · Exported to Brazil · Northeast Airlines Inc
- [N53R](https://openairdocs.org/deregistered/N53R-1958-06-23.md): Cessna 172 · S/N 29044 · Cancelled Jun 23, 1958 · Exported to Canada · Atlantic Aviation Corp
- [N33889](https://openairdocs.org/deregistered/N33889-1948-08-13.md): Aeronca 65-TL · S/N L9831T · Cancelled Aug 13, 1948 · Inter City Aviation Inc
- [N17166](https://openairdocs.org/deregistered/N17166-1948-04-29.md): Stinson SR-9B · S/N 5151 · Cancelled Apr 29, 1948 · Northeast Airlines Inc
- [N12121](https://openairdocs.org/deregistered/N12121-1938-09-03.md): Stinson U · S/N 9009 · Cancelled Sep 3, 1938 · Mayflower Airlines Inc
- [N15849](https://openairdocs.org/deregistered/N15849-1936-11-15.md): Beech C17B · S/N C17B-92 · Cancelled Nov 15, 1936 · Built 1936 · Shobe Aairlines Inc
- [N4964](https://openairdocs.org/deregistered/N4964-1936-02-19.md): American Eagle A-1 · S/N 135 · Cancelled Feb 19, 1936 · Bay State Flying Service
- [N965M](https://openairdocs.org/deregistered/N965M-1931-11-09.md): Curtiss Wright Flying Service FLEDGLING · S/N B-102 · Cancelled Nov 9, 1931 · Built 1931 · Curtiss Wright Flying Service
- [N87K](https://openairdocs.org/deregistered/N87K-1931-03-10.md): Ireland N 2 B · S/N 42 · Cancelled Mar 10, 1931 · Built 1929 · Curtiss Wright Flying Service Inc
- [N56M](https://openairdocs.org/deregistered/N56M-1931-01-23.md): Moth 60-GM · S/N 72 · Cancelled Jan 23, 1931 · Built 1929 · Curtiss Wright Flying Service Inc A Me Corp
- [N660K](https://openairdocs.org/deregistered/N660K-1931-01-05.md): Stearman C3-R · S/N 5008 · Cancelled Jan 5, 1931 · East Coast Aircraft Corp
- [N5458](https://openairdocs.org/deregistered/N5458-1930-11-24.md): Fairchild Airplane Mfg FC-2 · S/N 91 · Cancelled Nov 24, 1930 · Built 1928 · Curtiss Flying Service Of New England Inc
- [N266H](https://openairdocs.org/deregistered/N266H-1930-09-10.md): Curtiss Wright FLEDGLING · S/N B-43 · Cancelled Sep 10, 1930 · Built 1929 · Curtiss Flying Service Of New England Inc
- [N831E](https://openairdocs.org/deregistered/N831E-1930-07-15.md): Moth 60-GM · S/N 1-F · Cancelled Jul 15, 1930 · Built 1929 · Skyways Inc
- [N4791](https://openairdocs.org/deregistered/N4791-1930-07-09.md): Avro TRAINING · S/N 1 · Cancelled Jul 9, 1930 · Croce Thomas Jr
- [N2779](https://openairdocs.org/deregistered/N2779-1930-07-01.md): Stinson SB-1 · S/N 108 · Cancelled Jul 1, 1930 · Curitss Flying Service Of New England Inc
- [N374H](https://openairdocs.org/deregistered/N374H-1930-04-18.md): Moth 60G · S/N 1-M · Cancelled Apr 18, 1930 · Built 1929 · Skyways Inc
- [N223](https://openairdocs.org/deregistered/N223-1930-01-10.md): Curtiss Wright TRAVEL AIR 2000 · S/N 139 · Cancelled Jan 10, 1930 · Built 1926 · Curtiss Flying Service
- [N6604](https://openairdocs.org/deregistered/N6604-1929-10-17.md): Curtiss JN4D · S/N 5219 · Cancelled Oct 17, 1929 · Built 1918 · Curtiss Flying Service Of New England Inc

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

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