# Cancelled registrations: Mary Esther, FL

A list on [Mary Esther, FL](https://openairdocs.org/faa-place/FL/Mary%20Esther.md).

Cancelled aircraft registrations in Mary Esther, FL.

- [N439XA](https://openairdocs.org/deregistered/N439XA-2021-07-03.md): M-Squared BREESE 2 · S/N 03-2011-000789 · Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Lee Robert E
- [N591YA](https://openairdocs.org/deregistered/N591YA-2019-04-19.md): Horizon Hobby BLADE 350QX · S/N UCIB350QX0001 · Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N624UC](https://openairdocs.org/deregistered/N624UC-2019-02-04.md): Unconventional Concepts TUAV-MK1.4 · S/N TUAV-MK1.4-0001 · Cancelled Feb 4, 2019 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N626UC](https://openairdocs.org/deregistered/N626UC-2019-02-04.md): Unconventional Concepts TUAV-MK2.1 · S/N TUAV-MK2.1-0001 · Cancelled Feb 4, 2019 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N627UC](https://openairdocs.org/deregistered/N627UC-2019-01-28.md): DJI PHANTOM 1 · S/N PH63553301 · Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N628UC](https://openairdocs.org/deregistered/N628UC-2019-01-28.md): 3D Robotics IRIS · S/N UCI-IRIS-0001 · Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N629UC](https://openairdocs.org/deregistered/N629UC-2019-01-28.md): DJI PHANTOM 2 VISION · S/N PH6360437128 · Cancelled Jan 28, 2019 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N621UC](https://openairdocs.org/deregistered/N621UC-2018-12-13.md): Unconventional Concepts TUAV-MK1.1 · S/N TUAV-MK1.1-0001 · Cancelled Dec 13, 2018 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N622UC](https://openairdocs.org/deregistered/N622UC-2018-12-13.md): Unconventional Concepts TUAV-MK1.2 · S/N TUAV-MK1.2-0001 · Cancelled Dec 13, 2018 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N623UC](https://openairdocs.org/deregistered/N623UC-2018-12-13.md): Unconventional Concepts TUAV-MK1.3 · S/N TUAV-MK1.3-0001 · Cancelled Dec 13, 2018 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N625UC](https://openairdocs.org/deregistered/N625UC-2018-12-13.md): Unconventional Concepts TUAV-MK2.0 · S/N TUAV-MK2.0-0001 · Cancelled Dec 13, 2018 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N620UC](https://openairdocs.org/deregistered/N620UC-2018-12-12.md): Unconventional Concepts TUAV-MK1.0 · S/N TUAV-MK1.0-0001 · Cancelled Dec 12, 2018 · Registration expired, pending cancellation · Unconventional Concepts Inc
- [N6883E](https://openairdocs.org/deregistered/N6883E-2018-07-12.md): Cessna 175A · S/N 56383 · Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Davila Norbey C
- [N69KR](https://openairdocs.org/deregistered/N69KR-2017-03-24.md): Boyd James E KR-2S · S/N JB001 · Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Boyd James E
- [N401JH](https://openairdocs.org/deregistered/N401JH-2013-06-06.md): Hicks John L QUICKIE · S/N 401 · Cancelled Jun 6, 2013 · Registration expired, pending cancellation · Built 1983 · Hicks John L
- [N4987C](https://openairdocs.org/deregistered/N4987C-2012-12-18.md): Andrews-Richard WEEDHOPPER JC24 · S/N 0014 · Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1978 · Erschen Thomas G
- [N1410V](https://openairdocs.org/deregistered/N1410V-2012-06-27.md): Cessna 172M · S/N 17263555 · Cancelled Jun 27, 2012 · Registration expired, pending cancellation · Built 1974 · Brand Flying Service Inc
- [N7067F](https://openairdocs.org/deregistered/N7067F-1991-04-29.md): Cessna 150F · S/N 15063667 · Cancelled Apr 29, 1991 · Triennial form not returned · Parker Jerry F
- [N20PX](https://openairdocs.org/deregistered/N20PX-1982-10-14.md): Patton Gary D PATTON B8M · S/N 2 · Cancelled Oct 14, 1982 · Built 1981 · Patton Gary D
- [N6067T](https://openairdocs.org/deregistered/N6067T-1964-11-03.md): Cessna 150D · S/N 15060767 · Cancelled Nov 3, 1964 · Built 1964 · Braud 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 = 'FL' AND d.registrant_city = 'MARY ESTHER'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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