# Cancelled registrations: Cicero, NY

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

Cancelled aircraft registrations in Cicero, NY.

- [N154SR](https://openairdocs.org/deregistered/N154SR-2020-06-02.md): Dunn James MURPHY SUPER REBEL · S/N 184SR · Cancelled Jun 2, 2020 · Registration expired, pending cancellation · Built 2013 · Dunn James W
- [N8822U](https://openairdocs.org/deregistered/N8822U-2017-02-16.md): Cessna 172F · S/N 17252730 · Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1965 · Michael Michael D DBA
- [N2846Z](https://openairdocs.org/deregistered/N2846Z-2015-05-19.md): Piper PA-22-150 · S/N 22-6842 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1959 · J & J Air Inc
- [N5146K](https://openairdocs.org/deregistered/N5146K-2014-10-27.md): Ryan NAVION · S/N NAV-4-2046 · Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Built 1950 · Deuel John C
- [N1113P](https://openairdocs.org/deregistered/N1113P-2013-11-12.md): Piper PA-23 · S/N 23-123 · Cancelled Nov 12, 2013 · Registration expired, pending cancellation · Built 1955 · Michael Michael D DBA
- [N8638B](https://openairdocs.org/deregistered/N8638B-2013-05-15.md): Cessna 172 · S/N 36338 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1957 · Michael Michael D DBA
- [N7037J](https://openairdocs.org/deregistered/N7037J-1997-01-22.md): Mankovich Stanley J JR REVENGE · S/N 547 · Cancelled Jan 22, 1997 · Michael Michael D DBA
- [N51996](https://openairdocs.org/deregistered/N51996-1965-05-20.md): Fairchild M-62A · S/N T43-5652 · Cancelled May 20, 1965 · Onondaga Aviation
- [N27066](https://openairdocs.org/deregistered/N27066-1960-07-03.md): Piper J3F-65 · S/N 4334 · Cancelled Jul 3, 1960 · Built 1940 · Michael William E
- [N671Y](https://openairdocs.org/deregistered/N671Y-1960-06-13.md): Waco RNF · S/N 3358 · Cancelled Jun 13, 1960 · Built 1930 · Michael William E
- [N35243](https://openairdocs.org/deregistered/N35243-1960-06-03.md): Piper J3L-65 · S/N 6237 · Cancelled Jun 3, 1960 · Michael Wm E
- [N70984](https://openairdocs.org/deregistered/N70984-1960-05-23.md): Piper J3C-65 · S/N 18011 · Cancelled May 23, 1960 · Onodaga Air Service
- [N9131H](https://openairdocs.org/deregistered/N9131H-1960-05-21.md): Fairchild M-62A-3 · S/N FT692 · Cancelled May 21, 1960 · Michael William E
- [N87869](https://openairdocs.org/deregistered/N87869-1959-03-12.md): Piper J3C-65 · S/N 15487 · Cancelled Mar 12, 1959 · Built 1946 · Michael Wm E
- [N28086](https://openairdocs.org/deregistered/N28086-1959-03-11.md): Piper J3F-65 · S/N 4566 · Cancelled Mar 11, 1959 · Michael William E
- [N33568](https://openairdocs.org/deregistered/N33568-1959-03-11.md): Piper J3C-65 · S/N 14045 · Cancelled Mar 11, 1959 · Onondaga Aviation
- [N3879E](https://openairdocs.org/deregistered/N3879E-1959-03-11.md): Aeronca 11AC · S/N 11AC-S-75 · Cancelled Mar 11, 1959 · Michael William E
- [N6354H](https://openairdocs.org/deregistered/N6354H-1959-03-04.md): Piper J3C-65 · S/N 19534 · Cancelled Mar 4, 1959 · Built 1946 · Michael William E
- [N6617N](https://openairdocs.org/deregistered/N6617N-1959-03-04.md): Taylorcraft BC12D-4-85 · S/N 4-13017 · Cancelled Mar 4, 1959 · Onondaga Aviation

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

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