# Cancelled registrations: Edgewater, MD

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

Cancelled aircraft registrations in Edgewater, MD.

- [N7625T](https://openairdocs.org/deregistered/N7625T-2017-01-24.md): Cessna 172A · S/N 47225 · Cancelled Jan 24, 2017 · Revoked, pending cancellation · Built 1960 · Lee Kenneth W
- [N331GK](https://openairdocs.org/deregistered/N331GK-2015-05-20.md): Beech D-45 · S/N BG-350 · Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1957 · Department Of The Navy
- [N4065J](https://openairdocs.org/deregistered/N4065J-2015-05-06.md): Demeter Edward R BENSON 1 · S/N 001 · Cancelled May 6, 2015 · Registration expired, pending cancellation · Demeter Edward R
- [N8314Y](https://openairdocs.org/deregistered/N8314Y-2013-08-29.md): Piper PA-30 · S/N 30-1454 · Cancelled Aug 29, 2013 · Sale reported, canceled · Built 1967
- [N6877P](https://openairdocs.org/deregistered/N6877P-2013-01-31.md): Piper PA-24-250 · S/N 24-2013 · Cancelled Jan 31, 2013 · Registration expired, pending cancellation · Built 1960 · Shaffer Kenneth E
- [N734AT](https://openairdocs.org/deregistered/N734AT-2009-12-29.md): Cessna 172N · S/N 17268708 · Cancelled Dec 29, 2009 · Triennial form not returned · Built 1977 · Navy Annapolis Flight Center Inc
- [N3224P](https://openairdocs.org/deregistered/N3224P-2007-07-20.md): Piper PA-23 · S/N 23-1168 · Cancelled Jul 20, 2007 · Triennial form not returned · Built 1957 · Tri Flying Tigers Inc
- [N53HS](https://openairdocs.org/deregistered/N53HS-2000-10-27.md): Cessna 337A · S/N 337-0411 · Cancelled Oct 27, 2000 · Triennial form not returned · Poetzman Robert L
- [N9587F](https://openairdocs.org/deregistered/N9587F-2000-10-27.md): Hughes 269C · S/N 950439 · Cancelled Oct 27, 2000 · Exported to Canada · Annapolis Flying Services Inc
- [N304FB](https://openairdocs.org/deregistered/N304FB-1999-05-22.md): Fantasy Sky Promotions FANTASY 6 · S/N 056 · Cancelled May 22, 1999 · Triennial form not returned · Basic Technology Inc
- [N5276Z](https://openairdocs.org/deregistered/N5276Z-1998-08-13.md): Piper PA-22-108 · S/N 228969 · Cancelled Aug 13, 1998 · Triennial form not returned · Annapolis Flying Service Inc
- [N3776R](https://openairdocs.org/deregistered/N3776R-1992-05-13.md): Piper PA-28-180 · S/N 285819 · Cancelled May 13, 1992 · Triennial form not returned · Annapolis Flying Service Inc
- [N55657](https://openairdocs.org/deregistered/N55657-1992-03-12.md): Piper PA-28-140 · S/N 287325454 · Cancelled Mar 12, 1992 · Triennial form not returned · Annapolis Flying Service Inc
- [N1548J](https://openairdocs.org/deregistered/N1548J-1983-08-02.md): Piper PA-28-140 · S/N 28-23952 · Cancelled Aug 2, 1983 · Administratively canceled · Annapolis Flying Service Inc
- [N24617](https://openairdocs.org/deregistered/N24617-1978-05-13.md): Beech C23 · S/N M-1423 · Cancelled May 13, 1978 · Revoked, pending cancellation · Built 1972 · Choha Deforest D
- [N5483Z](https://openairdocs.org/deregistered/N5483Z-1973-06-25.md): Piper PA-22-108 · S/N 22-9265 · Cancelled Jun 25, 1973 · Annapolis Flying Service Inc
- [N4979Z](https://openairdocs.org/deregistered/N4979Z-1971-03-12.md): Piper PA-22-108 · S/N 22-8585 · Cancelled Mar 12, 1971 · Annapolis Flying Service Inc
- [N8458W](https://openairdocs.org/deregistered/N8458W-1970-09-25.md): Piper PA-28-180 · S/N 28-2694 · Cancelled Sep 25, 1970 · Jensen Roy J & Jensen Myrtle S
- [N127P](https://openairdocs.org/deregistered/N127P-1970-06-26.md): Stits PLAYBOY SA-3A · S/N P-620 · Cancelled Jun 26, 1970 · Parlett Donald Carlton
- [N5206M](https://openairdocs.org/deregistered/N5206M-1965-05-25.md): Taylorcraft BC12-D · S/N 10506 · Cancelled May 25, 1965 · Annapolis Flying Service Inc
- [N78747](https://openairdocs.org/deregistered/N78747-1964-09-11.md): Piper PA-11 · S/N 111519 · Cancelled Sep 11, 1964 · Annapolis Flying Service 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 = 'MD' AND d.registrant_city = 'EDGEWATER'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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