# Cancelled registrations: Columbia, CA

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

Cancelled aircraft registrations in Columbia, CA.

- [N3852S](https://openairdocs.org/deregistered/N3852S-2022-02-05.md): Cessna 172E · S/N 17251052 · Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1963 · Springfield Flying Service LLC
- [N417DF](https://openairdocs.org/deregistered/N417DF-2021-09-04.md): Grumman S2F-1 (TS-2A) · S/N 061 · Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Columbia Airport
- [N122EC](https://openairdocs.org/deregistered/N122EC-2018-03-08.md): Piper PA-23-250 · S/N 27-3212 · Cancelled Mar 8, 2018 · Registration expired, pending cancellation · Built 1966 · Aztec Aviation LLC
- [N9428Z](https://openairdocs.org/deregistered/N9428Z-2017-11-21.md): Grumman TBM-3E · S/N 86026 · Cancelled Nov 21, 2017 · Revoked, canceled · Built 1944 · Sonora Flying Svc Inc
- [N7181G](https://openairdocs.org/deregistered/N7181G-2015-04-30.md): Cessna 172K · S/N 17258881 · Cancelled Apr 30, 2015 · Registration expired, pending cancellation · Built 1969 · Brown Michael B
- [N320SA](https://openairdocs.org/deregistered/N320SA-2013-10-31.md): Kelly Kevin L SIGNATURE 2 · S/N 001 · Cancelled Oct 31, 2013 · Registration expired, pending cancellation · Built 1992 · Kelly Kevin L
- [N86159](https://openairdocs.org/deregistered/N86159-2013-05-15.md): Cessna 337D · S/N 337-1098 · Cancelled May 15, 2013 · Registration expired, pending cancellation · Built 1969 · Yosemite Airlines Inc
- [N6867Q](https://openairdocs.org/deregistered/N6867Q-2013-05-02.md): Beech 65-A80 · S/N LD-223 · Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1965 · Jensen Soren Edward Jr
- [N65931](https://openairdocs.org/deregistered/N65931-2013-04-30.md): Schweizer SGS 1-26E · S/N 571 · Cancelled Apr 30, 2013 · Registration expired, pending cancellation · Built 1973 · Thompson Jeannie
- [N71706](https://openairdocs.org/deregistered/N71706-2013-02-20.md): Luscombe 8A · S/N 3133 · Cancelled Feb 20, 2013 · Sale reported, canceled · Built 1946
- [N7458X](https://openairdocs.org/deregistered/N7458X-2013-01-14.md): Cessna 172B · S/N 17247958 · Cancelled Jan 14, 2013 · Registration expired · Built 1960 · Springfield Flying Service LLC
- [N22264](https://openairdocs.org/deregistered/N22264-2012-08-30.md): Cessna 150H · S/N 15068177 · Cancelled Aug 30, 2012 · Registration expired, pending cancellation · Built 1968 · Matthews Edwin J
- [N42VK](https://openairdocs.org/deregistered/N42VK-2012-08-30.md): Harding Elwood W KR-2 · S/N 6485 · Cancelled Aug 30, 2012 · Registration pending, canceled · Built 1984
- [N2819Y](https://openairdocs.org/deregistered/N2819Y-2005-02-16.md): Cessna 182E · S/N 18253819 · Cancelled Feb 16, 2005 · Triennial form not returned · Built 1962 · Pinley Steven D
- [N2522S](https://openairdocs.org/deregistered/N2522S-2000-11-17.md): Cessna T337C · S/N 337-0822 · Cancelled Nov 17, 2000 · Triennial form not returned · Skystar Inc
- [N9512T](https://openairdocs.org/deregistered/N9512T-2000-05-11.md): Cessna 210 · S/N 57312 · Cancelled May 11, 2000 · Hoffman Robert L
- [N7875T](https://openairdocs.org/deregistered/N7875T-1997-02-03.md): Cessna 172A · S/N 47475 · Cancelled Feb 3, 1997 · Second triennial mailing, no response · Fairchild Stephen R DBA
- [N5104Q](https://openairdocs.org/deregistered/N5104Q-1996-12-13.md): Cessna 172M · S/N 17261748 · Cancelled Dec 13, 1996 · Exported to Philippines · Built 1973 · Wilcox Brent
- [N4687X](https://openairdocs.org/deregistered/N4687X-1994-06-27.md): Cessna 150G · S/N 15064737 · Cancelled Jun 27, 1994 · Triennial form not returned · Rau Tommy J
- [N93367](https://openairdocs.org/deregistered/N93367-1981-10-14.md): Ercoupe 415-C · S/N 690 · Cancelled Oct 14, 1981 · Roundtree Thomas D
- [N9230L](https://openairdocs.org/deregistered/N9230L-1976-03-04.md): American AA-1A · S/N AA1A-0130 · Cancelled Mar 4, 1976 · Murphy William L
- [N6598R](https://openairdocs.org/deregistered/N6598R-1975-11-18.md): Beech C23 · S/N M-1604 · Cancelled Nov 18, 1975 · Tuolumne Air Service
- [N29B](https://openairdocs.org/deregistered/N29B-1971-08-25.md): Grumman FM-2 · S/N 4955 · Cancelled Aug 25, 1971 · Coeur Mel DBA
- [N6821C](https://openairdocs.org/deregistered/N6821C-1962-04-04.md): Grumman TBM-3E · S/N 6342 · Cancelled Apr 4, 1962 · Sonora Flying Service Inc

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

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