# Cancelled registrations: Chowchilla, CA

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

Cancelled aircraft registrations in Chowchilla, CA.

- [N101RB](https://openairdocs.org/deregistered/N101RB-2023-12-14.md): Cessna 421 · S/N 421-0024 · Cancelled Dec 14, 2023 · Built 1967 · N101rb LLC
- [N8989S](https://openairdocs.org/deregistered/N8989S-2018-03-07.md): Cessna 150F · S/N 15062289 · Cancelled Mar 7, 2018 · Registration expired, pending cancellation · Built 1965 · Flanagan Tom
- [N36MV](https://openairdocs.org/deregistered/N36MV-2018-03-01.md): Hiller UH-12E · S/N 5060 · Cancelled Mar 1, 2018 · Registration expired, pending cancellation · Built 1978 · Jeff Streeter Motor Sports Inc DBA
- [N655Y](https://openairdocs.org/deregistered/N655Y-2018-02-15.md): Grumman G-164 · S/N 309 · Cancelled Feb 15, 2018 · Registration expired, pending cancellation · Thiel Air Care Inc
- [N1724S](https://openairdocs.org/deregistered/N1724S-2018-02-09.md): Aero Commander S2R · S/N 1425R · Cancelled Feb 9, 2018 · Registration expired, pending cancellation · Built 1968 · Jeff Streeter Motor Sports Inc DBA
- [N4556S](https://openairdocs.org/deregistered/N4556S-2018-01-04.md): Air Tractor AT-502 · S/N 502-0137 · Cancelled Jan 4, 2018 · Registration expired, pending cancellation · Built 1991 · Thiel Air Care Inc
- [N7QC](https://openairdocs.org/deregistered/N7QC-2015-05-19.md): Bell 47G-4A · S/N 7611 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Jeff Streeter Motor Sports Inc
- [N93944](https://openairdocs.org/deregistered/N93944-2014-11-24.md): Engineering & Research ERCOUPE 415-C · S/N 1267 · Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1946 · Mandala Michael L
- [N1474S](https://openairdocs.org/deregistered/N1474S-2014-09-05.md): Cessna 182P · S/N 18265021 · Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1976 · Fry John L
- [N71111](https://openairdocs.org/deregistered/N71111-2013-02-20.md): Luscombe 8A · S/N 2538 · Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1946
- [N5261C](https://openairdocs.org/deregistered/N5261C-2012-12-18.md): Beech B35 · S/N D-2653 · Cancelled Dec 18, 2012 · Sale reported, canceled · Built 1950
- [N2427X](https://openairdocs.org/deregistered/N2427X-2010-06-07.md): Piper PA-36-375 · S/N 36-8302005 · Cancelled Jun 7, 2010 · Exported to Philippines · James Jarrod A
- [N70164](https://openairdocs.org/deregistered/N70164-2009-03-23.md): Cessna A188B · S/N 18801855T · Cancelled Mar 23, 2009 · Exported to Philippines · Built 1974 · Gudgel Robert W
- [N9961G](https://openairdocs.org/deregistered/N9961G-2009-03-23.md): Cessna A188A · S/N 18800761 · Cancelled Mar 23, 2009 · Exported to Philippines · Built 1971
- [N502WQ](https://openairdocs.org/deregistered/N502WQ-2008-05-19.md): Air Tractor AT-502 · S/N 502-0085 · Cancelled May 19, 2008 · Triennial form not returned · Thiel Edward E
- [N4399S](https://openairdocs.org/deregistered/N4399S-2008-01-24.md): Air Tractor AT-301 · S/N 301-0059 · Cancelled Jan 24, 2008 · Triennial form not returned · Thiel Air Care Inc
- [N478Q](https://openairdocs.org/deregistered/N478Q-2006-02-23.md): Cessna A188B · S/N 18802315T · Cancelled Feb 23, 2006 · Triennial form not returned · Built 1975 · Thiel Aircare Inc
- [N906DS](https://openairdocs.org/deregistered/N906DS-2002-07-22.md): Piper PA-25-235 · S/N 25-4906 · Cancelled Jul 22, 2002 · Triennial form not returned · Built 1969 · Thiel Air Care Inc
- [N8689D](https://openairdocs.org/deregistered/N8689D-1976-02-04.md): Piper PA-22-160 · S/N 22-5807 · Cancelled Feb 4, 1976 · Kamburoff John A
- [N4806Y](https://openairdocs.org/deregistered/N4806Y-1971-12-07.md): Piper PA-25-260 · S/N 254589 · Cancelled Dec 7, 1971 · Robert W Gudgel
- [N4068F](https://openairdocs.org/deregistered/N4068F-1965-10-05.md): Cessna 172 · S/N 36968 · Cancelled Oct 5, 1965 · Anderson Pump Co
- [N5038V](https://openairdocs.org/deregistered/N5038V-1952-08-22.md): Curtiss Wright P-40N · S/N 22786 · Cancelled Aug 22, 1952 · Collier Carroll M

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

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