# Cancelled registrations: Colton, CA

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

Cancelled aircraft registrations in Colton, CA.

- [N58895](https://openairdocs.org/deregistered/N58895-2020-02-13.md): Fairchild M-62A · S/N FV407 · Cancelled Feb 13, 2020 · Revoked, canceled · Driskill Russell
- [N25068](https://openairdocs.org/deregistered/N25068-2017-09-25.md): Cessna 152 · S/N 15280527 · Cancelled Sep 25, 2017 · Exported to Mexico · Built 1977 · Barrera Mauricio A
- [N61183](https://openairdocs.org/deregistered/N61183-2017-02-08.md): Cessna 150J · S/N 15070868 · Cancelled Feb 8, 2017 · Built 1969 · Bates Steven B
- [N76389](https://openairdocs.org/deregistered/N76389-2017-02-04.md): Cessna 140 · S/N 10810 · Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Hartzler Roy
- [N50448](https://openairdocs.org/deregistered/N50448-2015-05-19.md): Taylorcraft DCO-65 · S/N 4724 · Cancelled May 19, 2015 · Registration expired, pending cancellation · Built 1942 · Freeman Christopher D
- [N79HW](https://openairdocs.org/deregistered/N79HW-2013-06-05.md): Piper PA 31P 350 · S/N 31P-8414021 · Cancelled Jun 5, 2013 · Registration expired, pending cancellation · Built 1983 · Charlie Gill Enterprises Inc
- [N8898T](https://openairdocs.org/deregistered/N8898T-2013-05-17.md): Cessna 182C · S/N 52798 · Cancelled May 17, 2013 · Registration expired, pending cancellation · Built 1960 · Chon Young K
- [N2608D](https://openairdocs.org/deregistered/N2608D-1999-11-02.md): Cessna 170B · S/N 20760 · Cancelled Nov 2, 1999 · Second triennial mailing, no response · Crane Michael A
- [N2506A](https://openairdocs.org/deregistered/N2506A-1992-02-24.md): Piper PA-38-112 · S/N 3878A0721 · Cancelled Feb 24, 1992 · Triennial form not returned · Polhill Larry R
- [N3361G](https://openairdocs.org/deregistered/N3361G-1983-08-31.md): Briegleb BG-12C · S/N C-1 · Cancelled Aug 31, 1983 · Sale reported · Built 1961
- [N1665B](https://openairdocs.org/deregistered/N1665B-1973-06-05.md): Luscombe 11A · S/N 11-171 · Cancelled Jun 5, 1973 · Built 1948 · Maintenance Coleman
- [N93585](https://openairdocs.org/deregistered/N93585-1971-01-04.md): Engineering & Research 415-C · S/N 908 · Cancelled Jan 4, 1971 · Robertson Richard V
- [N2970U](https://openairdocs.org/deregistered/N2970U-1970-06-25.md): Cessna 172D · S/N 17250570 · Cancelled Jun 25, 1970 · Hubbs Kenneth
- [N5149T](https://openairdocs.org/deregistered/N5149T-1967-11-09.md): Champion 7KCAB · S/N 2 · Cancelled Nov 9, 1967 · Scholl Arthur E
- [N80001](https://openairdocs.org/deregistered/N80001-1965-05-22.md): Beech D18S · S/N A-60 · Cancelled May 22, 1965 · Stater Brothers
- [N94947](https://openairdocs.org/deregistered/N94947-1951-01-30.md): Taylorcraft BC12-D · S/N 9347 · Cancelled Jan 30, 1951 · Exported to Mexico · King George
- [N77329](https://openairdocs.org/deregistered/N77329-1949-03-03.md): Cessna 120 · S/N 11771 · Cancelled Mar 3, 1949 · Built 1946 · Hubbs William O/Hubbs Paul J
- [N53432](https://openairdocs.org/deregistered/N53432-1949-01-24.md): Ryan Aeronautical PT-22 · S/N 2206 · Cancelled Jan 24, 1949 · Hein Joachim C
- [N192W](https://openairdocs.org/deregistered/N192W-1933-04-14.md): Noel Sharp SHARP SECOND GLIDER · S/N NAS-2 · Cancelled Apr 14, 1933 · Sharp Noel

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

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