# Cancelled registrations: South Miami, FL

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

Cancelled aircraft registrations in South Miami, FL.

- [N172GN](https://openairdocs.org/deregistered/N172GN-2022-07-30.md): Cessna 172M · S/N 17262464 · Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1973 · Wilson Timothy
- [N204AK](https://openairdocs.org/deregistered/N204AK-2019-09-06.md): Cirrus Design SR20 · S/N 1120 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Built 2001 · Copy Right Express LLC
- [N77WC](https://openairdocs.org/deregistered/N77WC-2015-05-05.md): Aero Commander 680-F · S/N 680F-1206-108 · Cancelled May 5, 2015 · Registration expired, pending cancellation · Built 1962 · Hollingsworth James P
- [N83783](https://openairdocs.org/deregistered/N83783-2014-11-19.md): Convair 240 · S/N 49-1933 · Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Dixie Aircharter Inc
- [N5942Y](https://openairdocs.org/deregistered/N5942Y-2014-10-29.md): Piper PA-23-250 · S/N 27-3108 · Cancelled Oct 29, 2014 · Registration expired, pending cancellation · Built 1959 · Carlat Jack
- [N4590Q](https://openairdocs.org/deregistered/N4590Q-2014-10-09.md): Cessna 402A · S/N 402A0090 · Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1969 · Atlantic Airways Inc
- [N50TR](https://openairdocs.org/deregistered/N50TR-2013-09-10.md): Smith AEROSTAR 601P · S/N 61P-0381-125 · Cancelled Sep 10, 2013 · Registration expired, pending cancellation · Built 1976 · Trans-Continental Agencies Inc
- [N9902S](https://openairdocs.org/deregistered/N9902S-2013-05-30.md): Gulfstream AM Corp Comm Div 695A · S/N 96002 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Built 1981 · Hodge Electronics Inc.
- [N6924C](https://openairdocs.org/deregistered/N6924C-2012-09-06.md): Lockheed 1049H-82 · S/N 4852 · Cancelled Sep 6, 2012 · Revoked, canceled · Built 1958 · Skyways International Inc
- [N6896Q](https://openairdocs.org/deregistered/N6896Q-2012-08-09.md): Beech 65 · S/N LC-193 · Cancelled Aug 9, 2012 · Registration pending, canceled · Built 1965
- [N46582](https://openairdocs.org/deregistered/N46582-1980-09-12.md): Cessna 172K · S/N 17257367 · Cancelled Sep 12, 1980 · Atlantic Airways Inc
- [N4838W](https://openairdocs.org/deregistered/N4838W-1977-11-10.md): Rockwell International 114 · S/N 14168 · Cancelled Nov 10, 1977 · Exported to Chile · Randys Handbags Accessories
- [N3145T](https://openairdocs.org/deregistered/N3145T-1974-07-30.md): Cessna 177 · S/N 17700445 · Cancelled Jul 30, 1974 · Thomas J Kelly
- [N296](https://openairdocs.org/deregistered/N296-1973-11-16.md): Douglas DC-7C · S/N 45466 · Cancelled Nov 16, 1973 · Skyways International Inc
- [N49918](https://openairdocs.org/deregistered/N49918-1965-06-09.md): Laister-Kauffman LK-10A · S/N 100 · Cancelled Jun 9, 1965 · Compton Francis B
- [N35232](https://openairdocs.org/deregistered/N35232-1963-11-06.md): Piper J3C-65 · S/N 6540 · Cancelled Nov 6, 1963 · Buckhalt James T William C Reifenberg
- [N9839Z](https://openairdocs.org/deregistered/N9839Z-1961-10-09.md): Beech C-45H · S/N 52-10828A · Cancelled Oct 9, 1961 · Exported to Nigeria · Silverthorne J M
- [N10430](https://openairdocs.org/deregistered/N10430-1958-02-05.md): Consolidated Vultee L-13A · S/N 47-338N · Cancelled Feb 5, 1958 · Duffy John Owens
- [N4959V](https://openairdocs.org/deregistered/N4959V-1957-10-03.md): Consolidated Vultee L-13B · S/N 47-404 · Cancelled Oct 3, 1957 · Duffy John Owens
- [N72323](https://openairdocs.org/deregistered/N72323-1955-04-18.md): Cessna 140 · S/N 9503 · Cancelled Apr 18, 1955 · Nielander J R Jr
- [N8837](https://openairdocs.org/deregistered/N8837-1955-03-04.md): Stearman C3-B · S/N 247 · Cancelled Mar 4, 1955 · Built 1929 · Brown Winford Willis
- [N66097](https://openairdocs.org/deregistered/N66097-1955-01-14.md): Consolidated Vultee BT-13 · S/N 2325 · Cancelled Jan 14, 1955 · Wehler Valery D
- [N14542](https://openairdocs.org/deregistered/N14542-1948-07-27.md): Aeronca C-3 · S/N A-319 · Cancelled Jul 27, 1948 · Cothron James M
- [N6257](https://openairdocs.org/deregistered/N6257-1948-03-31.md): Stearman C3-B · S/N 152 · Cancelled Mar 31, 1948 · Brown Winford W
- [N781H](https://openairdocs.org/deregistered/N781H-1947-12-18.md): Stearman C3-R · S/N 5031 · Cancelled Dec 18, 1947 · Brown Winford Willis

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

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