# Cancelled registrations: Virginia Gardens, FL

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

Cancelled aircraft registrations in Virginia Gardens, FL.

- [N306FA](https://openairdocs.org/deregistered/N306FA-2022-09-03.md): Mcdonnell Douglas DC-9-83(MD-83) · S/N 49344 · Cancelled Sep 3, 2022 · Registration expired, pending cancellation · Caribbean Sun Airlines Inc
- [N6184Y](https://openairdocs.org/deregistered/N6184Y-2020-09-04.md): Piper PA-23-250 · S/N 27-3410 · Cancelled Sep 4, 2020 · Registration expired, pending cancellation · Built 1966 · Sky Global Aviation School Inc
- [N99RJ](https://openairdocs.org/deregistered/N99RJ-2018-03-08.md): Beech 95-C55 · S/N TE-439 · Cancelled Mar 8, 2018 · Built 1967 · P&B Aviation Corp
- [N245AA](https://openairdocs.org/deregistered/N245AA-2018-02-12.md): Mcdonnell Douglas DC-9-82(MD-82) · S/N 49257 · Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Built 1984 · Air Capital Group LLC
- [N447AA](https://openairdocs.org/deregistered/N447AA-2018-01-04.md): Mcdonnell Douglas DC-9-82(MD-82) · S/N 49473 · Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1987 · Air Capital Group LLC
- [N448AA](https://openairdocs.org/deregistered/N448AA-2018-01-04.md): Mcdonnell Douglas DC-9-82(MD-82) · S/N 49474 · Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1987 · Air Capital Group LLC
- [N449AA](https://openairdocs.org/deregistered/N449AA-2018-01-04.md): Mcdonnell Douglas DC-9-82(MD-82) · S/N 49475 · Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1987 · Air Capital Group LLC
- [N243AU](https://openairdocs.org/deregistered/N243AU-2016-10-18.md): Boeing 737-530 · S/N 25243 · Cancelled Oct 18, 2016 · Exported to Peru · Xtreme Aviation LLC
- [N981AS](https://openairdocs.org/deregistered/N981AS-2013-11-22.md): Mcdonnell Douglas MD 83 · S/N 53472 · Cancelled Nov 22, 2013 · Exported to Venezuela · Built 1997 · Air Capital Group LLC
- [N5972L](https://openairdocs.org/deregistered/N5972L-2013-07-19.md): American AA-1 · S/N AA1-0272 · Cancelled Jul 19, 2013 · Registration expired, pending cancellation · Built 1969 · Aerad Co
- [N800E](https://openairdocs.org/deregistered/N800E-2012-12-27.md): Hawker Siddeley HS.125 SERIES 700A · S/N NA-0240 · Cancelled Dec 27, 2012 · Exported to Bahamas · Built 1978 · Safari Airways LLC
- [N985BB](https://openairdocs.org/deregistered/N985BB-2012-11-16.md): Gulfstream American G-1159 · S/N 250 · Cancelled Nov 16, 2012 · Built 1979 · Miami Purchasing Services Corp
- [N246AA](https://openairdocs.org/deregistered/N246AA-2011-07-25.md): Mcdonnell Douglas DC-9-82(MD-82) · S/N 49258 · Cancelled Jul 25, 2011 · Exported to Venezuela · Built 1984 · Air Capital Group LLC
- [N746AP](https://openairdocs.org/deregistered/N746AP-2005-11-10.md): Boeing 737-281 · S/N 21770 · Cancelled Nov 10, 2005 · Exported to Ecuador · Lqs Finance LLC
- [N5051Y](https://openairdocs.org/deregistered/N5051Y-2003-05-08.md): Piper PA-23-250 · S/N 27-2060 · Cancelled May 8, 2003 · Exported to Venezuela · Built 1962 · Rg International Aircraft Corp
- [N934FT](https://openairdocs.org/deregistered/N934FT-1991-10-24.md): Boeing 727-23 · S/N 19430 · Cancelled Oct 24, 1991 · Exported to Colombia · Scott Steven T Trustee

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

This list as a web page: https://openairdocs.org/faa-place/FL/Virginia%20Gardens/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
