# Cancelled registrations: Elkton, MD

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

Cancelled aircraft registrations in Elkton, MD.

- [N202BA](https://openairdocs.org/deregistered/N202BA-2023-05-08.md): Ryskamp Bruce A SONEX · S/N 060653 · Cancelled May 8, 2023 · Sale reported, canceled · Built 2000
- [N145HB](https://openairdocs.org/deregistered/N145HB-2022-10-01.md): DJI PHANTOM 2 VISION + · S/N BE292316106991 · Cancelled Oct 1, 2022 · Registration expired, pending cancellation · Benson Hudson M
- [N61316](https://openairdocs.org/deregistered/N61316-2021-05-08.md): Solo Wings WINDLASS TRIKE · S/N WL-20 · Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1987 · Cooke Warren P
- [N9462U](https://openairdocs.org/deregistered/N9462U-2018-03-23.md): Cessna 150M · S/N 15078410 · Cancelled Mar 23, 2018 · Revoked, canceled · Built 1976 · Tramar Aviation Inc
- [N25874](https://openairdocs.org/deregistered/N25874-2017-10-19.md): Balloon Works FIREFLY 8B-15 · S/N F8B-466 · Cancelled Oct 19, 2017 · Registration expired, pending cancellation · Built 1994 · Choice Ballooning Inc
- [N1CJ](https://openairdocs.org/deregistered/N1CJ-2013-10-31.md): Cox WM C / Johnson Paul R JR S-9 CHAOS · S/N 1287034 · Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1992 · Groft David W
- [N4255F](https://openairdocs.org/deregistered/N4255F-2013-07-30.md): Cessna 172 · S/N 46155 · Cancelled Jul 30, 2013 · Registration expired, pending cancellation · Built 1958 · Rowe Incorporated
- [N4425W](https://openairdocs.org/deregistered/N4425W-2004-11-05.md): Warrington John Anthony SURREL GUPPY · S/N 53 · Cancelled Nov 5, 2004 · Triennial form not returned · Built 1999 · Warrington John Anthony
- [N2535Z](https://openairdocs.org/deregistered/N2535Z-1997-03-24.md): Bellanca 8KCAB · S/N 34177 · Cancelled Mar 24, 1997 · Triennial form not returned · Sherrard Frank C
- [N7107C](https://openairdocs.org/deregistered/N7107C-1995-10-03.md): Balloon Works FIREFLY 8B · S/N F8B106 · Cancelled Oct 3, 1995 · Triennial form not returned · Choice Ballooning Inc
- [N199PJ](https://openairdocs.org/deregistered/N199PJ-1992-07-20.md): Reed Paul R QUICKSILVER GT500 · S/N 00022 · Cancelled Jul 20, 1992 · Reed Paul R
- [N7454J](https://openairdocs.org/deregistered/N7454J-1991-08-01.md): Piper PA-28R-180 · S/N 28R30804 · Cancelled Aug 1, 1991 · Triennial form not returned · Wieser Carol A
- [N8828J](https://openairdocs.org/deregistered/N8828J-1982-03-31.md): Piper PA-28-180 · S/N 28-2783 · Cancelled Mar 31, 1982 · Dilks Kenneth M
- [N3611A](https://openairdocs.org/deregistered/N3611A-1970-09-23.md): Piper PA-22 · S/N 22-1871 · Cancelled Sep 23, 1970 · Rasnake Curtis S
- [N6319K](https://openairdocs.org/deregistered/N6319K-1965-05-20.md): Republic RC-3-1 · S/N 543 · Cancelled May 20, 1965 · Prial John J
- [N48169](https://openairdocs.org/deregistered/N48169-1952-01-25.md): Fairchild M-62A · S/N 5553AE · Cancelled Jan 25, 1952 · Buchanan Jack & B G Nelson
- [N4347H](https://openairdocs.org/deregistered/N4347H-1950-09-14.md): Piper PA-15 · S/N 15-133 · Cancelled Sep 14, 1950 · Williams Franklin T Jr

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

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