# Cancelled registrations: Orinda, CA

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

Cancelled aircraft registrations in Orinda, CA.

- [N397K](https://openairdocs.org/deregistered/N397K-2023-02-04.md): Curtiss Wright ROBIN · S/N 489 · Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Baumbach David J
- [N2247Q](https://openairdocs.org/deregistered/N2247Q-2021-12-04.md): Piper PA-28R-201T · S/N 28R-7703057 · Cancelled Dec 4, 2021 · Registration expired, pending cancellation · Logan William A Jr
- [N2928](https://openairdocs.org/deregistered/N2928-2019-11-01.md): Travel Air 4000 · S/N 157 · Cancelled Nov 1, 2019 · Sale reported, canceled
- [N9080](https://openairdocs.org/deregistered/N9080-2019-11-01.md): Curtiss Wright TRAVEL AIR 4000 · S/N 862 · Cancelled Nov 1, 2019 · Sale reported, canceled · Built 1928
- [N37KF](https://openairdocs.org/deregistered/N37KF-2018-03-13.md): Aerovodochody L-29 DELFIN · S/N 993233 · Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1969 · Ward Raju Mann
- [N3407E](https://openairdocs.org/deregistered/N3407E-2015-06-29.md): Cessna 172N · S/N 17271534 · Cancelled Jun 29, 2015 · Exported to Canada · Built 1978 · Gallegos George S
- [N7794C](https://openairdocs.org/deregistered/N7794C-2014-12-22.md): Piper PA-28R-200 · S/N 28R-7635117 · Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Built 1975 · Lombardo Christopher
- [N4572K](https://openairdocs.org/deregistered/N4572K-2012-07-24.md): Ryan NAVION · S/N NAV41572 · Cancelled Jul 24, 2012 · Revoked, canceled · Built 1948 · Plumleigh Robert E
- [N827RJ](https://openairdocs.org/deregistered/N827RJ-2010-07-07.md): Cirrus Design SR20 · S/N 1804 · Cancelled Jul 7, 2010 · Exported to Brazil · Built 2007 · Thompson Cirrus LLC
- [N7395C](https://openairdocs.org/deregistered/N7395C-2009-09-15.md): Cessna TU206G · S/N U20603919 · Cancelled Sep 15, 2009 · Triennial form not returned · Built 1977 · Pease Norman C
- [N74Q](https://openairdocs.org/deregistered/N74Q-2008-11-19.md): Milan J B/Thies T N QUESTAIR VENTURE · S/N 65 · Cancelled Nov 19, 2008 · Triennial form not returned · Milan J Bruce
- [N98TH](https://openairdocs.org/deregistered/N98TH-2005-11-17.md): Schweizer 269C · S/N S1760 · Cancelled Nov 17, 2005 · Triennial form not returned · Built 1998 · Sharf Stu
- [N5585N](https://openairdocs.org/deregistered/N5585N-2001-01-23.md): Bowman Jan QUICKIE Q-2 · S/N Q2121 · Cancelled Jan 23, 2001 · Triennial form not returned · Bowman Jan
- [N1874J](https://openairdocs.org/deregistered/N1874J-1998-07-13.md): Rockwell International 112TC · S/N 13033 · Cancelled Jul 13, 1998 · Triennial form not returned · Pifer Charles L
- [N8816A](https://openairdocs.org/deregistered/N8816A-1979-05-24.md): Beech B35 · S/N D-2260 · Cancelled May 24, 1979 · Lawrence E Mcnutt
- [N43032](https://openairdocs.org/deregistered/N43032-1977-06-21.md): Piper PA-28-235 · S/N 28-7410076 · Cancelled Jun 21, 1977 · Williams George P
- [N2624](https://openairdocs.org/deregistered/N2624-1974-07-19.md): Pitcairn PCA2 · S/N 8 · Cancelled Jul 19, 1974 · Built 1931 · Breuner Garald L

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

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