# Cancelled registrations: Massena, NY

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

Cancelled aircraft registrations in Massena, NY.

- [N9173N](https://openairdocs.org/deregistered/N9173N-2019-09-06.md): Mcdonald P J/Clark F A CHALLENGER 2 PL STD · S/N CH2-0295-1279 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 1995 · Clark Franklin A
- [N2082R](https://openairdocs.org/deregistered/N2082R-2018-01-16.md): Cessna 182G · S/N 18255282 · Cancelled Jan 16, 2018 · Registration expired, pending cancellation · Built 1964 · Page Jason T
- [N46142](https://openairdocs.org/deregistered/N46142-2013-06-18.md): Cessna 172I · S/N 17257069 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1968 · Sabers And Sabers Inc
- [N59TR](https://openairdocs.org/deregistered/N59TR-2013-05-30.md): Romeo Thomas A KITFOX 4-1200 · S/N JCU108 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Romeo Thomas A
- [N85EB](https://openairdocs.org/deregistered/N85EB-1999-12-08.md): O'Brien Erwin HELICOM H-1 · S/N EOB51037 · Cancelled Dec 8, 1999 · Exported to Canada · O'Brien Erwin R
- [N6445S](https://openairdocs.org/deregistered/N6445S-1997-04-29.md): Cessna 150H · S/N 15067245 · Cancelled Apr 29, 1997 · Triennial form not returned · Green Merrlyn E
- [N88902](https://openairdocs.org/deregistered/N88902-1974-09-09.md): Dehavilland DHC-1B-2 · S/N 172 · Cancelled Sep 9, 1974 · Hunsinger Dean
- [N4099V](https://openairdocs.org/deregistered/N4099V-1970-11-13.md): Cessna 170A · S/N 18431 · Cancelled Nov 13, 1970 · Massena Flying Club Inc
- [N8020K](https://openairdocs.org/deregistered/N8020K-1970-09-03.md): Stinson 108-2 · S/N 108-3020 · Cancelled Sep 3, 1970 · Britain Stanley And Stewart John
- [N5518T](https://openairdocs.org/deregistered/N5518T-1969-05-27.md): Cessna 172E · S/N 17251418 · Cancelled May 27, 1969 · Exported to Canada · Richey Floyd
- [N88040](https://openairdocs.org/deregistered/N88040-1965-07-27.md): Piper J-3 · S/N 15657 · Cancelled Jul 27, 1965 · Exported to Canada · Stanley E Britain
- [N92063](https://openairdocs.org/deregistered/N92063-1965-01-26.md): Piper J3C-65 · S/N 16496 · Cancelled Jan 26, 1965 · Exported to Canada · Stanley E Britain
- [N28568](https://openairdocs.org/deregistered/N28568-1963-05-27.md): Luscombe 8A · S/N 1397 · Cancelled May 27, 1963 · Exported to Canada · Pond Development Corp
- [N36752](https://openairdocs.org/deregistered/N36752-1958-11-12.md): Stinson 10A · S/N 8152 · Cancelled Nov 12, 1958 · Exported to Canada · Built 1941 · Meagher James M Jr
- [N44355](https://openairdocs.org/deregistered/N44355-1957-08-07.md): Taylorcraft BC12-D1 · S/N 10155 · Cancelled Aug 7, 1957 · Exported to Canada · Dessert Arnold F
- [N1074E](https://openairdocs.org/deregistered/N1074E-1955-11-18.md): Aeronca 7AC · S/N 7AC-4626 · Cancelled Nov 18, 1955 · Adams Merton Edward
- [N43557](https://openairdocs.org/deregistered/N43557-1955-06-20.md): Taylorcraft BC12-D · S/N 7216 · Cancelled Jun 20, 1955 · Exported to Canada · Prentice Richard
- [N44106](https://openairdocs.org/deregistered/N44106-1955-06-20.md): Taylorcraft BCS12-D · S/N 9906 · Cancelled Jun 20, 1955 · Exported to Canada · Boyce John R
- [N46468](https://openairdocs.org/deregistered/N46468-1955-03-31.md): Fairchild M-62A · S/N T40-125 · Cancelled Mar 31, 1955 · Built 1940 · Markham George H
- [N51992](https://openairdocs.org/deregistered/N51992-1955-03-31.md): Fairchild M-62A · S/N T41-1155 · Cancelled Mar 31, 1955 · Built 1941 · Markham George H
- [N51663](https://openairdocs.org/deregistered/N51663-1949-06-10.md): Fairchild M-62A · S/N T42-1977 · Cancelled Jun 10, 1949 · Built 1942 · Boyce John R / Page Walter A
- [N39180](https://openairdocs.org/deregistered/N39180-1948-09-16.md): Taylorcraft DF-65 · S/N 4186 · Cancelled Sep 16, 1948 · Built 1942 · Dufort Clarence
- [N17411](https://openairdocs.org/deregistered/N17411-1948-04-22.md): Aeronca C-3 · S/N A-722 · Cancelled Apr 22, 1948 · George Leslie Fetterly & Robert James Belyea
- [N34086](https://openairdocs.org/deregistered/N34086-1944-11-19.md): Taylorcraft BC12-65 · S/N 2951 · Cancelled Nov 19, 1944 · Clarence Dufort

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

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