# Cancelled registrations: Newton, MA

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

Cancelled aircraft registrations in Newton, MA.

- [N554RD](https://openairdocs.org/deregistered/N554RD-2018-10-23.md): DJI PHANTOM 2 · S/N PH645308642 · Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Drozd Patryk K
- [N30J](https://openairdocs.org/deregistered/N30J-2018-01-17.md): Jorgenson STITS SA11-A · S/N 113 · Cancelled Jan 17, 2018 · Registration expired, pending cancellation · Built 1974 · Fruehauf Julian
- [N17UQ](https://openairdocs.org/deregistered/N17UQ-2018-01-03.md): Howell Norman E QUICKIE · S/N 486 · Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Ham Nelson D
- [N736FW](https://openairdocs.org/deregistered/N736FW-2017-02-04.md): Cessna R172K · S/N R1722501 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1977 · Stetson Joe R
- [N3068D](https://openairdocs.org/deregistered/N3068D-2014-09-29.md): Cessna 310 · S/N 35268 · Cancelled Sep 29, 2014 · Registration expired, pending cancellation · Built 1956 · Goodman Herbert D
- [N92391](https://openairdocs.org/deregistered/N92391-2013-05-22.md): Cessna 182N · S/N 18260184 · Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1969 · 37 Sierra Partnership
- [N46388](https://openairdocs.org/deregistered/N46388-2012-07-31.md): Fairchild M-62A · S/N T435307 · Cancelled Jul 31, 2012 · Revoked, canceled · Built 1943 · Gaetz Lloyd A
- [N731CM](https://openairdocs.org/deregistered/N731CM-2011-08-24.md): Cessna 172N · S/N 17268685 · Cancelled Aug 24, 2011 · Exported to Canada · Built 1977 · Ricotta Paul J
- [N9618Q](https://openairdocs.org/deregistered/N9618Q-2009-09-15.md): Cessna 172M · S/N 17265703 · Cancelled Sep 15, 2009 · Registration revoked · Built 1975 · Fine Lawrence
- [N6598C](https://openairdocs.org/deregistered/N6598C-2006-07-31.md): Beech C24R · S/N MC-790 · Cancelled Jul 31, 2006 · Triennial form not returned · Built 1983 · Alexander Mark S
- [N9017M](https://openairdocs.org/deregistered/N9017M-2002-05-01.md): Sikorsky S-76C · S/N 760521 · Cancelled May 1, 2002 · Exported to Hong Kong · Built 2001 · Helicopter Hong Kong Ltd
- [N188DM](https://openairdocs.org/deregistered/N188DM-1998-11-18.md): Piper PA-23-250 · S/N 277754020 · Cancelled Nov 18, 1998 · Murphy Charles F
- [N9147J](https://openairdocs.org/deregistered/N9147J-1993-11-29.md): Piper PA-32R-301 · S/N 3213018 · Cancelled Nov 29, 1993 · Triennial form not returned · Kaplan Ronald F
- [N106JM](https://openairdocs.org/deregistered/N106JM-1991-02-06.md): Mcpherson EVANS VP-1 · S/N 1849 · Cancelled Feb 6, 1991 · Triennial form not returned · Mcpherson John R
- [N8859P](https://openairdocs.org/deregistered/N8859P-1976-05-28.md): Piper PA-24-260 · S/N 24-4316 · Cancelled May 28, 1976 · Holbrook Russell N
- [N9712](https://openairdocs.org/deregistered/N9712-1932-07-01.md): Ireland N-2 · S/N 19 · Cancelled Jul 1, 1932 · Larkin Henry J
- [N58009](https://openairdocs.org/deregistered/N58009-undated.md): Cessna T-50 · S/N 5879 · Cancellation date not recorded · Built 1944 · Raytheon Manufacturing Co

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

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