# Cancelled registrations: Crestview, FL

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

Cancelled aircraft registrations in Crestview, FL.

- [N565V](https://openairdocs.org/deregistered/N565V-2025-01-16.md): Cessna 501 · S/N 501-0267 · Cancelled Jan 16, 2025 · Exported to Brazil · Cosco & Associates Inc
- [N570R](https://openairdocs.org/deregistered/N570R-2022-03-22.md): Rockwell International NA-265-65 · S/N 465-75 · Cancelled Mar 22, 2022 · Sunshine Aero Industries Inc
- [N86225](https://openairdocs.org/deregistered/N86225-2021-07-03.md): Aeronca 11AC · S/N 11AC29 · Cancelled Jul 3, 2021 · Registration expired, pending cancellation · Built 1946 · Hall Aaron C
- [N7317Q](https://openairdocs.org/deregistered/N7317Q-2021-06-05.md): Cessna 182P · S/N 18260957 · Cancelled Jun 5, 2021 · Registration expired, pending cancellation · Big Sky Flight LLC
- [N7853U](https://openairdocs.org/deregistered/N7853U-2021-04-03.md): Cessna 172F · S/N 17251853 · Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 1964 · Roberts Max R
- [N217VS](https://openairdocs.org/deregistered/N217VS-2020-04-03.md): Beech 95-A55 · S/N TC-455 · Cancelled Apr 3, 2020 · Registration expired, pending cancellation · White Billy C
- [N188MW](https://openairdocs.org/deregistered/N188MW-2019-05-06.md): DJI Innovations PHANTOM 3 PROFESSION · S/N P76DCF17013755 · Cancelled May 6, 2019 · Registration expired, pending cancellation · Werth Mario S
- [N124SD](https://openairdocs.org/deregistered/N124SD-2017-12-13.md): Rockwell International NA-265-65 · S/N 465-2 · Cancelled Dec 13, 2017 · Sunshine Aero Industries Inc
- [N56DB](https://openairdocs.org/deregistered/N56DB-2017-05-23.md): Banks SONERAI II · S/N 1 · Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1977 · Hall Steven J
- [N91089](https://openairdocs.org/deregistered/N91089-2014-11-24.md): Waldron FLYBABY · S/N 75-5 · Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1978 · Littlefield Lawrence Lee
- [N6248P](https://openairdocs.org/deregistered/N6248P-2013-10-31.md): Piper PA-24-250 · S/N 24-1355 · Cancelled Oct 31, 2013 · First renewal notice · Built 1959 · Keller Robert L
- [N333PT](https://openairdocs.org/deregistered/N333PT-2013-08-06.md): Seales Frankie Paul PT 2 B · S/N PT1003 · Cancelled Aug 6, 2013 · Sale reported, canceled · Built 1991
- [N5102C](https://openairdocs.org/deregistered/N5102C-2011-09-10.md): Beech B35 · S/N D-2383 · Cancelled Sep 10, 2011 · First renewal notice · Built 1950 · Cosgrove D DBA
- [N9319P](https://openairdocs.org/deregistered/N9319P-2008-03-04.md): Piper PA-24-260 · S/N 24-4816 · Cancelled Mar 4, 2008 · Exported to Australia · Built 1969 · Hi Plex Aviation Inc
- [N551S](https://openairdocs.org/deregistered/N551S-1992-01-08.md): Smith AEROSTAR 600 · S/N 600021 · Cancelled Jan 8, 1992 · Triennial form not returned · Littlefield Lawrence L
- [N44666](https://openairdocs.org/deregistered/N44666-1974-11-13.md): Culver V · S/N V-27 · Cancelled Nov 13, 1974 · Built 1946 · Kennedy John R
- [N86129](https://openairdocs.org/deregistered/N86129-1949-03-24.md): Aeronca 11AC · S/N 11AC-558 · Cancelled Mar 24, 1949 · Dobbins Don R DBA Northwest Florida Flying Service

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

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