# Cancelled registrations: Claremont, CA

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

Cancelled aircraft registrations in Claremont, CA.

- [N3877D](https://openairdocs.org/deregistered/N3877D-2020-01-24.md): Cessna 182A · S/N 34577 · Cancelled Jan 24, 2020 · Revoked, canceled · Built 1957 · Johnson Adolph C
- [N4082K](https://openairdocs.org/deregistered/N4082K-2019-11-04.md): Navion L-17A · S/N NAV-4-1082 · Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1947 · Keith Kevin N
- [N48699](https://openairdocs.org/deregistered/N48699-2019-09-20.md): Taylorcraft DC-65 · S/N L5837 · Cancelled Sep 20, 2019 · Revoked, canceled · Built 1944 · Vega Flying Club Inc
- [N71568](https://openairdocs.org/deregistered/N71568-2018-05-31.md): Reno Gordon E TIERRA II · S/N 253 · Cancelled May 31, 2018 · Sale reported, canceled
- [N988RH](https://openairdocs.org/deregistered/N988RH-2018-04-06.md): Beech F35 · S/N D-4131 · Cancelled Apr 6, 2018 · Registration expired, pending cancellation · Built 1955 · Davis Keith C
- [N94185](https://openairdocs.org/deregistered/N94185-2018-02-15.md): Cessna 152 · S/N 15285615 · Cancelled Feb 15, 2018 · Sale reported, canceled · Built 1982
- [N5462K](https://openairdocs.org/deregistered/N5462K-2015-05-15.md): Cessna 172P · S/N 17274128 · Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1980 · Cable Marilyn R Co Trustee
- [N9957C](https://openairdocs.org/deregistered/N9957C-2013-05-31.md): Callair A-5 · S/N 212 · Cancelled May 31, 2013 · Registration expired, pending cancellation · Built 1958 · Odell Dale L
- [N6029C](https://openairdocs.org/deregistered/N6029C-2013-04-25.md): Callair A-5 · S/N 142-5A · Cancelled Apr 25, 2013 · Registration expired, pending cancellation · Built 1954 · Odell Dale L
- [N3261Q](https://openairdocs.org/deregistered/N3261Q-2013-01-30.md): Bell 47G · S/N 1062 · Cancelled Jan 30, 2013 · Sale reported, canceled
- [N6149C](https://openairdocs.org/deregistered/N6149C-2012-11-13.md): Callair A-4 · S/N 162 · Cancelled Nov 13, 2012 · Registration expired, pending cancellation · Built 1956 · Odell Dale L
- [N732TK](https://openairdocs.org/deregistered/N732TK-2011-06-07.md): Cessna T210M · S/N 21061760 · Cancelled Jun 7, 2011 · Exported to Mexico · Built 1977 · Brage Donald L
- [N9748B](https://openairdocs.org/deregistered/N9748B-2009-07-09.md): Cessna 180A · S/N 50046 · Cancelled Jul 9, 2009 · Registration revoked · Built 1957 · Askelson Eldon
- [N2006V](https://openairdocs.org/deregistered/N2006V-2009-02-09.md): Cessna 140 · S/N 14217 · Cancelled Feb 9, 2009 · Triennial form not returned · Built 1947 · Holmes Stephen L
- [N8622Z](https://openairdocs.org/deregistered/N8622Z-2006-05-25.md): Cessna TP206C · S/N P206-0422 · Cancelled May 25, 2006 · Exported to Mexico · Built 1967 · Riffenburgh Ralph S
- [N737TT](https://openairdocs.org/deregistered/N737TT-2006-02-23.md): Cessna 172N · S/N 17269669 · Cancelled Feb 23, 2006 · Exported to Canada · Built 1977 · Cable Marilyn R Trustee
- [N69088](https://openairdocs.org/deregistered/N69088-2006-01-13.md): Cessna 152 · S/N 15282479 · Cancelled Jan 13, 2006 · Exported to Peru · Built 1978 · Cable Marilyn R Co-Trustee
- [N6449B](https://openairdocs.org/deregistered/N6449B-2006-01-11.md): Cessna T210M · S/N 21062767 · Cancelled Jan 11, 2006 · Exported to Mexico · Built 1978 · Olivera Paul
- [N2733Y](https://openairdocs.org/deregistered/N2733Y-2004-09-08.md): Beech 95 · S/N TD-72 · Cancelled Sep 8, 2004 · Triennial form not returned · Built 1958 · Cable Marilyn R Co Trustee
- [N99142](https://openairdocs.org/deregistered/N99142-2004-08-28.md): Ercoupe 415-C · S/N 1765 · Cancelled Aug 28, 2004 · Triennial form not returned · Built 1946 · Payne Charles
- [N25440](https://openairdocs.org/deregistered/N25440-2003-10-24.md): Cessna 152 · S/N 15280660 · Cancelled Oct 24, 2003 · Exported to Panama · Built 1977 · Cable Marilyn R Co-Trustee
- [N817RH](https://openairdocs.org/deregistered/N817RH-1995-11-03.md): Harrison Robin T PITTS S1S · S/N 02RH · Cancelled Nov 3, 1995 · Triennial form not returned · Harrison Robin T
- [N5258D](https://openairdocs.org/deregistered/N5258D-1993-04-01.md): Cessna 172N · S/N 17272476 · Cancelled Apr 1, 1993 · Triennial form not returned · Cable Walter D Co Trustee
- [N149KS](https://openairdocs.org/deregistered/N149KS-1990-12-06.md): Schooley Kenneth L AVID FLYER · S/N 149 · Cancelled Dec 6, 1990 · Exported to Italy · Ring Robert III
- [N2Q](https://openairdocs.org/deregistered/N2Q-1988-04-29.md): Smith Miniplane DSA-1 · S/N MH-101 · Cancelled Apr 29, 1988 · Second triennial mailing, no response · Built 1968 · Batterton George B
- [N6339F](https://openairdocs.org/deregistered/N6339F-1986-01-17.md): Cessna 172N · S/N 17273196 · Cancelled Jan 17, 1986 · Garlett Jerry W
- [N1857Q](https://openairdocs.org/deregistered/N1857Q-1981-03-12.md): Cessna 177RG · S/N 177RG0257 · Cancelled Mar 12, 1981 · Built 1972 · Labarbera Vincent J
- [N51139](https://openairdocs.org/deregistered/N51139-1977-07-07.md): Cessna 150 · S/N 15069789 · Cancelled Jul 7, 1977 · Shupe Donald
- [N2208F](https://openairdocs.org/deregistered/N2208F-1977-02-07.md): Cessna 310L · S/N 310L-0008 · Cancelled Feb 7, 1977 · Foster Paul Wesley
- [N2210V](https://openairdocs.org/deregistered/N2210V-1976-05-26.md): Cessna 206 · S/N 206-0107 · Cancelled May 26, 1976 · Built 1964 · Borland Robert C
- [N2970Y](https://openairdocs.org/deregistered/N2970Y-1976-05-18.md): Cessna 182E · S/N 18253970 · Cancelled May 18, 1976 · Binnall Duane R
- [N9435](https://openairdocs.org/deregistered/N9435-1975-02-07.md): Pazmany PL1 · S/N 358 · Cancelled Feb 7, 1975 · Built 1972 · Sinclair R S
- [N3667A](https://openairdocs.org/deregistered/N3667A-1975-01-27.md): Stolp STARDUSTER 2 · S/N 125 · Cancelled Jan 27, 1975 · Meyer Robert E
- [N4736E](https://openairdocs.org/deregistered/N4736E-1973-07-16.md): Aeronca 7EC · S/N 7EC-79 · Cancelled Jul 16, 1973 · Exported to Canada · Porter George Or Mable Porter
- [N4756Z](https://openairdocs.org/deregistered/N4756Z-1965-06-12.md): Piper PA-22-108 · S/N 228312 · Cancelled Jun 12, 1965 · Howard E D
- [N77099](https://openairdocs.org/deregistered/N77099-1965-06-05.md): Cessna 140 · S/N 11557 · Cancelled Jun 5, 1965 · Built 1946 · Pierson Lenn M
- [N2865E](https://openairdocs.org/deregistered/N2865E-1965-05-25.md): Aeronca 7AC · S/N 7AC-6448 · Cancelled May 25, 1965 · Lenn M Pierson
- [N1498E](https://openairdocs.org/deregistered/N1498E-1965-05-22.md): Aeronca 7AC · S/N 7AC-5061 · Cancelled May 22, 1965 · Lenn M Pierson
- [N21721](https://openairdocs.org/deregistered/N21721-1941-11-17.md): Bowlus BABY ALBATROSS · S/N 102 · Cancelled Nov 17, 1941 · Shatzel Albert V
- [N212K](https://openairdocs.org/deregistered/N212K-1939-01-10.md): Great Lakes 2T-1A · S/N 38 · Cancelled Jan 10, 1939 · Long James N
- [N914Y](https://openairdocs.org/deregistered/N914Y-1933-06-17.md): Wolfe Claude PRIMARY GLIDER · S/N 1 · Cancelled Jun 17, 1933 · Built 1930 · Wolfe Claude

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

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