# Cancelled registrations: Thermal, CA

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

Cancelled aircraft registrations in Thermal, CA.

- [N9623T](https://openairdocs.org/deregistered/N9623T-2022-01-11.md): Piper PA-38-112 · S/N 38-78A0146 · Cancelled Jan 11, 2022 · Registration pending, canceled
- [N77668](https://openairdocs.org/deregistered/N77668-2019-02-04.md): Fairchild 24R-46A · S/N R46368 · Cancelled Feb 4, 2019 · Registration expired, pending cancellation · Built 1947 · Goodrum Christopher D
- [N3037H](https://openairdocs.org/deregistered/N3037H-2018-04-18.md): Cessna 162 · S/N 16200115 · Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 2011 · Jacksonair Services LLC
- [N335AC](https://openairdocs.org/deregistered/N335AC-2018-02-13.md): American Champion 7GCBC · S/N 1241-98 · Cancelled Feb 13, 2018 · Registration expired, pending cancellation · Built 1998 · Okole Aviation LLC
- [N8856A](https://openairdocs.org/deregistered/N8856A-2017-11-21.md): Beech B35 · S/N D-2511 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1950 · Peterson Allan L
- [N3175Z](https://openairdocs.org/deregistered/N3175Z-2017-06-19.md): Balloon Works FIREFLY 9 · S/N F9-066 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 1996 · Desert Balloon Charters
- [N3200T](https://openairdocs.org/deregistered/N3200T-2017-05-31.md): Cessna 177 · S/N 17700500 · Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1967 · Specht Brian L
- [N1017D](https://openairdocs.org/deregistered/N1017D-2016-09-09.md): Cessna 195A · S/N 7625 · Cancelled Sep 9, 2016 · Revoked, canceled · Built 1950 · Valley Air Svc
- [N23EZ](https://openairdocs.org/deregistered/N23EZ-2013-07-30.md): Ryan Anthony W LONG EZ 61 · S/N 390 · Cancelled Jul 30, 2013 · Sale reported, canceled
- [N4048Y](https://openairdocs.org/deregistered/N4048Y-2012-11-07.md): Balloon Works FIREFLY 6B · S/N 6745 · Cancelled Nov 7, 2012 · Sale reported, canceled · Built 1979
- [N65323](https://openairdocs.org/deregistered/N65323-2012-10-12.md): Cessna 172S · S/N 172S9697 · Cancelled Oct 12, 2012 · Exported to Mexico · Built 2004 · Turbo Flight Professionals LLC
- [N34155](https://openairdocs.org/deregistered/N34155-2012-09-12.md): Cessna 177B · S/N 17701673 · Cancelled Sep 12, 2012 · Sale reported, canceled · Built 1971
- [N3677N](https://openairdocs.org/deregistered/N3677N-2012-08-23.md): Balloon Works FIREFLY 8-24 · S/N F8-014 · Cancelled Aug 23, 2012 · Sale reported, canceled
- [N37498](https://openairdocs.org/deregistered/N37498-2012-08-06.md): Balloon Works FIREFLY 6B · S/N F6B-006 · Cancelled Aug 6, 2012 · Registration pending, canceled
- [N28101](https://openairdocs.org/deregistered/N28101-2009-07-20.md): Piper J3C-65 · S/N 4579 · Cancelled Jul 20, 2009 · Registration revoked · Built 1940 · Chase Wilford
- [N512D](https://openairdocs.org/deregistered/N512D-2008-06-20.md): Cessna 182E · S/N 18254044 · Cancelled Jun 20, 2008 · Exported to Canada · Built 1962 · Wilson Mary Michelle Trustee
- [N8095V](https://openairdocs.org/deregistered/N8095V-1975-04-02.md): Cessna A188 · S/N 188-0345 · Cancelled Apr 2, 1975 · Noels Flying Service Inc
- [N2196E](https://openairdocs.org/deregistered/N2196E-1954-09-21.md): Aeronca 7DC-CONV · S/N 7AC-5770 · Cancelled Sep 21, 1954 · Wagner Eleanor

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

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