# Cancelled registrations: Calipatria, CA

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

Cancelled aircraft registrations in Calipatria, CA.

- [N5566X](https://openairdocs.org/deregistered/N5566X-2015-05-04.md): Aero Commander S2R · S/N 1766R · Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1973 · Benco Custom Aerial Applicators
- [N907SD](https://openairdocs.org/deregistered/N907SD-2013-08-13.md): Bell 206 · S/N 40221 · Cancelled Aug 13, 2013 · Sale reported, canceled
- [N62456](https://openairdocs.org/deregistered/N62456-2013-08-07.md): Hiller UH-12D · S/N 1234 · Cancelled Aug 7, 2013 · Revoked, canceled · Built 1959 · Desert Helicopters
- [N5709D](https://openairdocs.org/deregistered/N5709D-2013-04-23.md): Piper PA-22-150 · S/N 22-4405 · Cancelled Apr 23, 2013 · Registration expired, pending cancellation · Built 1956 · Hanley Olan B
- [N53171](https://openairdocs.org/deregistered/N53171-2013-04-08.md): Cessna A188B · S/N 18801661T · Cancelled Apr 8, 2013 · Registration expired, pending cancellation · Built 1974 · Ben-Co Custom Aerial Applicators Inc
- [N66855](https://openairdocs.org/deregistered/N66855-2012-09-05.md): Cessna T-50 · S/N 2777 · Cancelled Sep 5, 2012 · Revoked, canceled · Built 1942 · Phillips William H
- [N2770N](https://openairdocs.org/deregistered/N2770N-2009-07-01.md): Bell 204 · S/N 63-8509 · Cancelled Jul 1, 2009 · Triennial form not returned · Built 1979 · Farm Air Service Inc
- [N9749V](https://openairdocs.org/deregistered/N9749V-1977-07-25.md): Cessna A188 · S/N 188-0199 · Cancelled Jul 25, 1977 · Pankratz Wallace
- [N1789S](https://openairdocs.org/deregistered/N1789S-1977-07-21.md): Aero Commander 600 S-2D · S/N 600-1400D · Cancelled Jul 21, 1977 · Pankratz Wallace B
- [N62380](https://openairdocs.org/deregistered/N62380-1976-05-26.md): Hiller UH-12D · S/N 1228 · Cancelled May 26, 1976 · Desert Helicopters
- [N1688S](https://openairdocs.org/deregistered/N1688S-1975-05-08.md): Snow S2C · S/N 6001269C · Cancelled May 8, 1975 · Pankratz Wallace B
- [N45044](https://openairdocs.org/deregistered/N45044-1973-06-21.md): Naval Aircraft Factory N3N-3 · S/N 2729 · Cancelled Jun 21, 1973 · Pankratz Wallace B
- [N45052](https://openairdocs.org/deregistered/N45052-1973-06-21.md): Naval Aircraft Factory N3N-3 · S/N 2844 · Cancelled Jun 21, 1973 · Pankratz Wallace B
- [N45088](https://openairdocs.org/deregistered/N45088-1973-06-21.md): Naval Aircraft Factory N3N-3 · S/N 2648 · Cancelled Jun 21, 1973 · Pankratz Wallace B
- [N45118](https://openairdocs.org/deregistered/N45118-1973-06-21.md): Naval Aircraft Factory N3N-3 · S/N 2758 · Cancelled Jun 21, 1973 · Pankratz Wallace B
- [N8079V](https://openairdocs.org/deregistered/N8079V-1972-05-10.md): Cessna A188 · S/N 188-0329 · Cancelled May 10, 1972 · Pankratz Wallace B
- [N9417R](https://openairdocs.org/deregistered/N9417R-1971-06-17.md): Snow S2B · S/N 1047 · Cancelled Jun 17, 1971 · Exported to United Kingdom · Pankratz Wallace B
- [N44809](https://openairdocs.org/deregistered/N44809-1971-05-24.md): Naval Aircraft Factory N3N-3 · S/N 3008 · Cancelled May 24, 1971 · Wallace B Pankratz
- [N8083V](https://openairdocs.org/deregistered/N8083V-1970-07-07.md): Cessna A188 · S/N 188-0333 · Cancelled Jul 7, 1970 · Pankratz Wallace B
- [N1786S](https://openairdocs.org/deregistered/N1786S-1970-07-06.md): Aero Commander 600 S-2D · S/N 600-1404D · Cancelled Jul 6, 1970 · Pandratz Wallace B
- [N66845](https://openairdocs.org/deregistered/N66845-1955-08-03.md): Consolidated Vultee BT-13A · S/N 1865 · Cancelled Aug 3, 1955 · Corn Wiley E And Lyerly Richard A
- [N63462](https://openairdocs.org/deregistered/N63462-1955-01-06.md): Consolidated Vultee BT-13A · S/N 5440 · Cancelled Jan 6, 1955 · Powell C F
- [N17052](https://openairdocs.org/deregistered/N17052-1940-12-22.md): Cessna C-34 · S/N 335 · Cancelled Dec 22, 1940 · Sinclair L E 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 = 'CALIPATRIA'
ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id
```

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