# Cancelled registrations: Hermitage, TN

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

Cancelled aircraft registrations in Hermitage, TN.

- [N2363Q](https://openairdocs.org/deregistered/N2363Q-2018-02-27.md): Beech 23 · S/N M-436 · Cancelled Feb 27, 2018 · Revoked, pending cancellation · Built 1963 · Vines Jack
- [N547AS](https://openairdocs.org/deregistered/N547AS-2015-03-20.md): Brakes Inc DBA Aero SVC CHALLENGER II · S/N CH204870247 · Cancelled Mar 20, 2015 · Registration pending, canceled
- [N13165](https://openairdocs.org/deregistered/N13165-2014-09-03.md): Cessna 172M · S/N 17262543 · Cancelled Sep 3, 2014 · Registration expired, pending cancellation · Built 1973 · Thomas Billy R
- [N89987](https://openairdocs.org/deregistered/N89987-2013-09-11.md): Cessna 140 · S/N 9039 · Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1946 · Roberts William G Jr
- [N7030G](https://openairdocs.org/deregistered/N7030G-2013-07-10.md): Smith Jearld T KITFOX # 1 · S/N 117 · Cancelled Jul 10, 2013 · Sale reported, canceled · Built 1988
- [N3530N](https://openairdocs.org/deregistered/N3530N-2013-04-16.md): Piper PA-31-310 · S/N 31-7912078 · Cancelled Apr 16, 2013 · Registration expired, pending cancellation · Built 1979 · Beeler George Sr
- [N276AB](https://openairdocs.org/deregistered/N276AB-2013-03-26.md): Bailey William R TEAM TANDEM AIRBIKE · S/N AB276AMT · Cancelled Mar 26, 2013 · Sale reported, canceled
- [N210HM](https://openairdocs.org/deregistered/N210HM-2010-01-12.md): Cartwright H Jr/Cottrell M RV-10 · S/N 40238 · Cancelled Jan 12, 2010 · Triennial form not returned · Built 2006 · Rvn210hm-10 Inc
- [N4784R](https://openairdocs.org/deregistered/N4784R-2006-02-13.md): Cessna A188B · S/N 18802320T · Cancelled Feb 13, 2006 · Exported to Dominican Republic · Built 1975 · Roberts William G
- [N37TL](https://openairdocs.org/deregistered/N37TL-2005-07-08.md): Lawicki Todd KITFOX IV · S/N 1614 · Cancelled Jul 8, 2005 · Exported to Switzerland · Built 1993 · Lawicki Todd A
- [N82ST](https://openairdocs.org/deregistered/N82ST-2001-03-09.md): Cox William C III PITTS S1C · S/N 0082 · Cancelled Mar 9, 2001 · Main Michael Alan
- [N23ZH](https://openairdocs.org/deregistered/N23ZH-2000-03-09.md): North American SNJ-5 · S/N 84968 · Cancelled Mar 9, 2000 · Loudermilk Rick
- [N329L](https://openairdocs.org/deregistered/N329L-1999-06-18.md): Lindsey Turnage R LONG-EZ · S/N 422 · Cancelled Jun 18, 1999 · Cottrell Michael S
- [N53314](https://openairdocs.org/deregistered/N53314-1997-02-27.md): Cessna A188B · S/N 18801755T · Cancelled Feb 27, 1997 · Exported to Turkey · Roberts William G
- [N731MN](https://openairdocs.org/deregistered/N731MN-1985-04-29.md): Cessna A188B · S/N 18803002T · Cancelled Apr 29, 1985 · Exported to Mexico · Roberts William G
- [N1053L](https://openairdocs.org/deregistered/N1053L-1984-08-31.md): Kelley John R BREEZY FLU-1 · S/N 1 · Cancelled Aug 31, 1984 · Administratively canceled · Kelly John R
- [N4XX](https://openairdocs.org/deregistered/N4XX-1975-05-09.md): Trimble Charles E 1325 · S/N 40647739 · Cancelled May 9, 1975 · Built 1973 · Trimble Charles

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

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