# Cancelled registrations: Cloverdale, VA

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

Cancelled aircraft registrations in Cloverdale, VA.

- [N205CK](https://openairdocs.org/deregistered/N205CK-2019-09-06.md): Bell 205A-1 · S/N 30152 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Summit Sales & Leasing Inc
- [N205JL](https://openairdocs.org/deregistered/N205JL-2019-09-06.md): Bell 205A-1 · S/N 30162 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Submit Sales & Leasing Inc
- [N835M](https://openairdocs.org/deregistered/N835M-2018-07-24.md): Bell UH-1H · S/N 70-16436 · Cancelled Jul 24, 2018 · Exported to South Africa · Johar Helicopters
- [N107HA](https://openairdocs.org/deregistered/N107HA-2018-03-19.md): Hiller UH-12E · S/N HA3007 · Cancelled Mar 19, 2018 · Registration expired, pending cancellation · Built 1974 · Summit Helicopters Inc
- [N112EC](https://openairdocs.org/deregistered/N112EC-2018-01-09.md): Hiller UH-12E · S/N HA3012 · Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1974 · Summit Helicopters Inc
- [N417ED](https://openairdocs.org/deregistered/N417ED-2017-10-31.md): Bell 212 · S/N 32137 · Cancelled Oct 31, 2017 · Registration expired, pending cancellation · Summit Helicopters Inc
- [N67089](https://openairdocs.org/deregistered/N67089-2017-03-21.md): Hiller UH-12D · S/N 1322 · Cancelled Mar 21, 2017 · Registration expired, pending cancellation · Built 1963 · Summit Helicopters Inc
- [N14641](https://openairdocs.org/deregistered/N14641-2017-03-06.md): Hiller OH-23G · S/N 63-12847 · Cancelled Mar 6, 2017 · Registration expired, pending cancellation · Built 1963 · Summit Helicopters Inc
- [N14638](https://openairdocs.org/deregistered/N14638-2015-05-20.md): Hiller OH-23G · S/N 63-12861 · Cancelled May 20, 2015 · Registration expired, pending cancellation · Built 1963 · Summit Helicopters Inc
- [N4507](https://openairdocs.org/deregistered/N4507-2015-01-08.md): Hiller OH-23F · S/N 61-3229 · Cancelled Jan 8, 2015 · Third renewal notice · Built 1961 · Summit Helicopters Inc
- [N5744Y](https://openairdocs.org/deregistered/N5744Y-2014-08-06.md): Bell Helicopter Textron 206L-1 · S/N 45465 · Cancelled Aug 6, 2014 · Exported to New Zealand · Built 1980 · Summit Helicopters Inc
- [N992SH](https://openairdocs.org/deregistered/N992SH-2014-08-06.md): Bell 206L-3 · S/N 51278 · Cancelled Aug 6, 2014 · Exported to New Zealand · Summit Helicopters Inc
- [N4034Z](https://openairdocs.org/deregistered/N4034Z-2012-11-15.md): Hiller-Rogerson Helicopter UH12E · S/N 5196 · Cancelled Nov 15, 2012 · Registration expired, pending cancellation · Summit Helicopters Inc
- [N9275Z](https://openairdocs.org/deregistered/N9275Z-2012-08-10.md): Hiller UH-12D · S/N 998 · Cancelled Aug 10, 2012 · Registration expired, pending cancellation · Built 1958 · Summit Helicopters Inc
- [N94877](https://openairdocs.org/deregistered/N94877-2009-09-17.md): Bell 47G-4 · S/N 3148 · Cancelled Sep 17, 2009 · Registration revoked · Built 1975 · Eastern Helicopter Corp
- [N508SH](https://openairdocs.org/deregistered/N508SH-2008-04-15.md): Bell 407 · S/N 53252 · Cancelled Apr 15, 2008 · Exported to Canada · Built 1998 · Summit Helicopters Inc
- [N407BT](https://openairdocs.org/deregistered/N407BT-2007-12-13.md): Bell 407 · S/N 53001 · Cancelled Dec 13, 2007 · Exported to Mexico · Built 1996 · Summit Helicopters Inc
- [N41870](https://openairdocs.org/deregistered/N41870-2007-09-18.md): Bell UH-1B · S/N 65-12853 · Cancelled Sep 18, 2007 · Triennial form not returned · Built 1965 · Summit Sales And Leasing Inc
- [N888LN](https://openairdocs.org/deregistered/N888LN-2007-03-28.md): Bell 206-L4 · S/N 52301 · Cancelled Mar 28, 2007 · Exported to Canada · Built 2004 · Summit Helicopters Inc
- [N4389Y](https://openairdocs.org/deregistered/N4389Y-2000-01-20.md): Bell UH-1B · S/N 63-13087 · Cancelled Jan 20, 2000 · Exported to Australia · Summit Sales And Leasing Inc
- [N2580V](https://openairdocs.org/deregistered/N2580V-1999-12-10.md): Bell UH-1B · S/N 8518 · Cancelled Dec 10, 1999 · Exported to Australia · Summit Helicopters Inc
- [N781CC](https://openairdocs.org/deregistered/N781CC-1999-12-09.md): Bell UH-1B · S/N 64-13925 · Cancelled Dec 9, 1999 · Exported to Australia · Summit Helicopters Inc
- [N156HA](https://openairdocs.org/deregistered/N156HA-1996-12-20.md): Hiller UH-12E · S/N HA3056 · Cancelled Dec 20, 1996 · Triennial form not returned · Summit Helicopters 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 = 'VA' AND d.registrant_city = 'CLOVERDALE'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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