# Cancelled registrations: Ojai, CA

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

Cancelled aircraft registrations in Ojai, CA.

- [N628VF](https://openairdocs.org/deregistered/N628VF-2019-09-06.md): DJI PHANTOM 3 PROFESSION · S/N CG061456159924 · Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Focal Flight LLC
- [N8538T](https://openairdocs.org/deregistered/N8538T-2018-05-21.md): Cessna 182C · S/N 52438 · Cancelled May 21, 2018 · Revoked, canceled · Built 1959 · Estill Jack D
- [N715GG](https://openairdocs.org/deregistered/N715GG-2018-03-08.md): Cessna 150M · S/N 15079160 · Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Fitzgerald Rolland L
- [N85TJ](https://openairdocs.org/deregistered/N85TJ-2018-03-08.md): Jones Thomas R KR-II · S/N 4988 · Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Fitzgerald Bryan L
- [N9138A](https://openairdocs.org/deregistered/N9138A-2013-09-19.md): Cessna 170A · S/N 18899 · Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1949 · Clarke Geoffrey F
- [N543AA](https://openairdocs.org/deregistered/N543AA-2013-06-18.md): Debusschere Donald B FALCON-XP · S/N 600164 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · De Busschere Donald B
- [N4065C](https://openairdocs.org/deregistered/N4065C-2013-06-12.md): Balloon Works FIREFLY 7 · S/N 10007 · Cancelled Jun 12, 2013 · Sale reported, canceled · Built 1979
- [N51663](https://openairdocs.org/deregistered/N51663-2013-04-01.md): Enstrom F-28C · S/N 397 · Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Brunette Louis L
- [N5178P](https://openairdocs.org/deregistered/N5178P-2013-04-01.md): Cessna 152 · S/N 15284889 · Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1981 · Lehr Harry P
- [N7858H](https://openairdocs.org/deregistered/N7858H-2013-02-27.md): Piper PA-12 · S/N 12-759 · Cancelled Feb 27, 2013 · Sale reported, canceled · Built 1946
- [N4686T](https://openairdocs.org/deregistered/N4686T-2012-11-27.md): Gere SPORT BIPLANE · S/N FRYE-1 · Cancelled Nov 27, 2012 · Sale reported, canceled · Built 1966
- [N28474](https://openairdocs.org/deregistered/N28474-2012-10-18.md): Luscombe 8A · S/N 1341 · Cancelled Oct 18, 2012 · Registration expired, pending cancellation · Built 1940 · Thomas Vincent G
- [N26199](https://openairdocs.org/deregistered/N26199-2011-12-19.md): Schiele JODEL D-11 · S/N F5124 · Cancelled Dec 19, 2011 · Sale reported, pending cancellation · Built 1980
- [N9679D](https://openairdocs.org/deregistered/N9679D-2009-09-17.md): Piper PA-22-150 · S/N 22-6596 · Cancelled Sep 17, 2009 · Registration revoked · Built 1959 · Landis Lee R
- [N32464](https://openairdocs.org/deregistered/N32464-2009-07-27.md): Superior CULVER LCA · S/N 196 · Cancelled Jul 27, 2009 · Registration revoked · Built 1941 · Morris Michael D
- [N13GT](https://openairdocs.org/deregistered/N13GT-2002-09-05.md): Grumman American Avn. AA-5B · S/N AA5B0457 · Cancelled Sep 5, 2002 · Triennial form not returned · Built 1977 · Curtis Charles F
- [N9300A](https://openairdocs.org/deregistered/N9300A-1998-04-04.md): Cessna 195A · S/N 7514 · Cancelled Apr 4, 1998 · Triennial form not returned · Lires John F
- [N39036](https://openairdocs.org/deregistered/N39036-1997-01-15.md): Grumman American Avn. AA-1C · S/N AA1C0196 · Cancelled Jan 15, 1997 · Triennial form not returned · True Glenn C Jr
- [N9546R](https://openairdocs.org/deregistered/N9546R-1996-08-14.md): Beech K35 · S/N D6142 · Cancelled Aug 14, 1996 · Triennial form not returned · Pacific Aviation Fuels Inc
- [N273Y](https://openairdocs.org/deregistered/N273Y-1978-01-24.md): Reichardt HOWARD DGA-6 · S/N 02 · Cancelled Jan 24, 1978 · Built 1934 · Reichardt Robert W
- [N20860](https://openairdocs.org/deregistered/N20860-1974-06-14.md): Cessna 182P · S/N 18261265 · Cancelled Jun 14, 1974 · Lawrence Michael A
- [N7027F](https://openairdocs.org/deregistered/N7027F-1974-05-17.md): Cessna 150F · S/N 15063627 · Cancelled May 17, 1974 · Wagner Ralph L
- [N1183B](https://openairdocs.org/deregistered/N1183B-1973-12-05.md): Luscombe 8A · S/N 5810 · Cancelled Dec 5, 1973 · Harris Bryan Riley
- [N9361](https://openairdocs.org/deregistered/N9361-1973-10-04.md): Ingels AIR KART AI-1 · S/N 001 · Cancelled Oct 4, 1973 · Ingels Arthur J
- [N5968E](https://openairdocs.org/deregistered/N5968E-1971-01-27.md): Cessna 150 · S/N 17468 · Cancelled Jan 27, 1971 · Fox Russell E
- [N7504D](https://openairdocs.org/deregistered/N7504D-1970-09-24.md): Piper PA-22-150 · S/N 22-5231 · Cancelled Sep 24, 1970 · James W Bryner
- [N45684](https://openairdocs.org/deregistered/N45684-1970-06-26.md): Luscombe 8A · S/N 2211 · Cancelled Jun 26, 1970 · Ronaldc Chrzanowski
- [N48925](https://openairdocs.org/deregistered/N48925-1955-10-11.md): Taylorcraft DCO-65 · S/N 5432 · Cancelled Oct 11, 1955 · Alfred E Houk Jr

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

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