# Cancelled registrations: Ellicott City, MD

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

Cancelled aircraft registrations in Ellicott City, MD.

- [N3KJ](https://openairdocs.org/deregistered/N3KJ-2022-07-30.md): American Champion 8KCAB · S/N 765-96 · Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Gruver John G
- [N578YS](https://openairdocs.org/deregistered/N578YS-2021-10-30.md): DJI PHANTOM 2 · S/N PT645194009 V1.0 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Serino Robert M
- [N578ZS](https://openairdocs.org/deregistered/N578ZS-2021-10-30.md): DJI PHANTOM 2 · S/N PT645332823 V1.0 · Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Serino Robert M
- [N386CG](https://openairdocs.org/deregistered/N386CG-2019-10-04.md): Roboflight Systems RF-70 · S/N RF70-017 · Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Cabezon Group
- [N388CG](https://openairdocs.org/deregistered/N388CG-2019-10-04.md): DJI PHANTOM 3 PROFESSION · S/N P77DCK12010140 · Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Cabezon Group
- [N389CG](https://openairdocs.org/deregistered/N389CG-2019-10-04.md): Swift Radioplanes LYNX · S/N LYNX-036 · Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Cabezon Group
- [N390CG](https://openairdocs.org/deregistered/N390CG-2019-10-04.md): Applied Aeronautics ALBATROSS · S/N A00023 · Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Cabezon Group
- [N392CG](https://openairdocs.org/deregistered/N392CG-2019-10-04.md): Yuneec TYPHOON Q500 4K · S/N YU15330615B04C01 · Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Cabezon Group
- [N709JH](https://openairdocs.org/deregistered/N709JH-2019-05-04.md): DJI INSPIRE 1 · S/N W13DCA29020297 · Cancelled May 4, 2019 · Registration expired, pending cancellation · Elevated Media Concepts Inc
- [N61523](https://openairdocs.org/deregistered/N61523-2017-09-29.md): Piper PA-31-350 · S/N 31-7552025 · Cancelled Sep 29, 2017 · Exported to Bahamas · Built 1974 · Aerial Imaging East LLC
- [N5260S](https://openairdocs.org/deregistered/N5260S-2017-07-14.md): Cessna TR182 · S/N R18201527 · Cancelled Jul 14, 2017 · Registration expired, pending cancellation · Built 1980 · Kunkel Stephen T
- [N40587](https://openairdocs.org/deregistered/N40587-2015-05-13.md): Balloon Works FIREFLY 7 · S/N 7966 · Cancelled May 13, 2015 · Registration expired, pending cancellation · Built 1979 · Shupe Rob
- [N646AG](https://openairdocs.org/deregistered/N646AG-2014-11-20.md): Robinson Helicopter R66 · S/N 0409 · Cancelled Nov 20, 2014 · Sale reported, pending cancellation · Built 2013
- [N21363](https://openairdocs.org/deregistered/N21363-2014-09-16.md): Cessna 172M · S/N 17263936 · Cancelled Sep 16, 2014 · Registration expired, pending cancellation · Built 1974 · Johnson Jack A
- [N644DC](https://openairdocs.org/deregistered/N644DC-2014-09-10.md): Diamond Aircraft Ind DA20-C1 · S/N C0144 · Cancelled Sep 10, 2014 · Registration expired, pending cancellation · Built 2001 · Alejandra Aircraft Holdings LLC
- [N5356S](https://openairdocs.org/deregistered/N5356S-2013-04-09.md): Piper PA-28-140 · S/N 28-26776 · Cancelled Apr 9, 2013 · Registration expired, pending cancellation · Built 1970 · Reiger James G
- [N8921](https://openairdocs.org/deregistered/N8921-2013-03-11.md): Bradley B8-M GYROCOPTER · S/N B-21146433 · Cancelled Mar 11, 2013 · Sale reported, canceled
- [N5138G](https://openairdocs.org/deregistered/N5138G-2006-07-10.md): Cessna 172K · S/N 17259068 · Cancelled Jul 10, 2006 · Triennial form not returned · Built 1970 · Schaefer Charles M
- [N3613Z](https://openairdocs.org/deregistered/N3613Z-2000-11-29.md): Schweizer SGS 2-33A · S/N 562 · Cancelled Nov 29, 2000 · Triennial form not returned · Walker Simon B
- [N38463](https://openairdocs.org/deregistered/N38463-1981-12-23.md): Piper PA-28-181 · S/N 287790554 · Cancelled Dec 23, 1981 · Built 1977 · Krause Vernon A Jr
- [N17077](https://openairdocs.org/deregistered/N17077-1970-04-09.md): Pilatus PC-6/350-H1 · S/N 540 · Cancelled Apr 9, 1970 · Exported to Canada · Shank Walter A
- [N540W](https://openairdocs.org/deregistered/N540W-1963-02-08.md): Piper PA-28 · S/N 28-304 · Cancelled Feb 8, 1963 · 40 West Flying Club Inc
- [N72702](https://openairdocs.org/deregistered/N72702-1949-02-24.md): Cessna 140 · S/N 9881 · Cancelled Feb 24, 1949 · Brown James D 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 = 'ELLICOTT CITY'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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