# Cancelled registrations: Ocean City, NJ

A list on [Ocean City, NJ](https://openairdocs.org/faa-place/NJ/Ocean%20City.md).

Cancelled aircraft registrations in Ocean City, NJ.

- [N6783W](https://openairdocs.org/deregistered/N6783W-2023-03-04.md): Piper PA-28-140 · S/N 28-20912 · Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1965 · Mcentee Stephen T
- [N795CH](https://openairdocs.org/deregistered/N795CH-2019-11-04.md): Haury Charles J NIEUPORT II · S/N 795 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 2006 · Haury Jeanne M
- [N675A](https://openairdocs.org/deregistered/N675A-2018-05-31.md): Piper PA-22 · S/N 22-77 · Cancelled May 31, 2018 · Sale reported, canceled · Built 1951
- [N7474K](https://openairdocs.org/deregistered/N7474K-2017-02-04.md): Piper PA-20 · S/N 20-388 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1950 · Delozier John J
- [N6389E](https://openairdocs.org/deregistered/N6389E-2016-05-26.md): Cessna A185F · S/N 18504037 · Cancelled May 26, 2016 · Exported to Canada · Built 1980 · Plumbo Victor Gaston
- [N9295M](https://openairdocs.org/deregistered/N9295M-2013-09-11.md): Mooney M20E · S/N 1228 · Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1966 · King Richard B
- [N91682](https://openairdocs.org/deregistered/N91682-2013-05-22.md): Cessna 182M · S/N 18259870 · Cancelled May 22, 2013 · Registration expired, pending cancellation · Built 1969 · Farm Of The Child Inc
- [N2363W](https://openairdocs.org/deregistered/N2363W-2012-09-04.md): Beech A23-24 · S/N MA-5 · Cancelled Sep 4, 2012 · Registration expired, pending cancellation · Built 1966 · Zehner Roy H
- [N66LG](https://openairdocs.org/deregistered/N66LG-2010-09-15.md): Beech 58 · S/N TH-798 · Cancelled Sep 15, 2010 · Exported to South Africa · Built 1977 · Berger Realty Inc
- [N652Y](https://openairdocs.org/deregistered/N652Y-1982-05-14.md): Grumman G-164 · S/N 231 · Cancelled May 14, 1982 · Delozier Glenda
- [N6065Z](https://openairdocs.org/deregistered/N6065Z-1981-10-14.md): Piper PA-25 · S/N 25-75 · Cancelled Oct 14, 1981 · Delozier John
- [N84248](https://openairdocs.org/deregistered/N84248-1981-10-14.md): Champion 7AC · S/N 7AC-2940 · Cancelled Oct 14, 1981 · Delozier John J
- [N152Y](https://openairdocs.org/deregistered/N152Y-1980-10-09.md): Beech K35 · S/N D-6116 · Cancelled Oct 9, 1980 · Built 1959 · Ely Richard A Etal
- [N82746](https://openairdocs.org/deregistered/N82746-1970-12-31.md): American Champion 7AC · S/N 7AC-1393 · Cancelled Dec 31, 1970 · J Robert Cone
- [N10178](https://openairdocs.org/deregistered/N10178-1965-05-18.md): Fay Ronald W RENAIRAH XR-1 · S/N 51387762 · Cancelled May 18, 1965 · Fay Ronald Walter
- [N72268](https://openairdocs.org/deregistered/N72268-1955-12-12.md): Cessna 120 · S/N 9442 · Cancelled Dec 12, 1955 · Haines W P Jr
- [N4143](https://openairdocs.org/deregistered/N4143-1930-07-31.md): Kreider-Reisner C-2 · S/N 133 · Cancelled Jul 31, 1930 · Built 1928 · Abel Charles Colvert
- [N3573](https://openairdocs.org/deregistered/N3573-1929-08-01.md): Waco GXE · S/N 1112 · Cancelled Aug 1, 1929 · Brohan Fredrick H

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

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