# Cancelled registrations: Calistoga, CA

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

Cancelled aircraft registrations in Calistoga, CA.

- [N4932T](https://openairdocs.org/deregistered/N4932T-2024-09-30.md): Cessna TR182 · S/N R18201791 · Cancelled Sep 30, 2024 · Exported to Canada · Built 1981 · Swaffar Gregory R
- [N1647C](https://openairdocs.org/deregistered/N1647C-2018-01-11.md): Firefly Balloons GALAXY 9 · S/N GLX-1079 · Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 2007 · Calistoga Balloons Inc
- [N15001](https://openairdocs.org/deregistered/N15001-2017-06-07.md): Firefly Balloons FIREFLY 11 · S/N F11-2001 · Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 2001 · Calistoga Balloons LLC
- [N1519G](https://openairdocs.org/deregistered/N1519G-2017-06-07.md): Firefly Balloons GALAXY 9 · S/N GLX-1059 · Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Calistoga Balloons
- [N63164](https://openairdocs.org/deregistered/N63164-2015-05-04.md): Aerostar International S-66A · S/N S66A-3043 · Cancelled May 4, 2015 · Registration expired, pending cancellation · Carnevale Michael V
- [N931BC](https://openairdocs.org/deregistered/N931BC-2015-05-04.md): Thunder & Colt Balloons 160A · S/N 1403 · Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1989 · Carnevale Michael V
- [N74149](https://openairdocs.org/deregistered/N74149-2013-09-13.md): Balloon Works FIREFLY 8-24 · S/N F8-084 · Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Once In A Lifetime Inc
- [N2599L](https://openairdocs.org/deregistered/N2599L-2013-07-29.md): Balloon Works FIRE FLY 10 · S/N F10-012 · Cancelled Jul 29, 2013 · Sale reported, canceled · Built 1993
- [N981TC](https://openairdocs.org/deregistered/N981TC-2013-07-11.md): Colt Balloons 160A · S/N 1519US · Cancelled Jul 11, 2013 · Sale reported, canceled · Built 1989
- [N71059](https://openairdocs.org/deregistered/N71059-2013-05-30.md): Balloon Works FIREFLY 8-24 · S/N F8-104 · Cancelled May 30, 2013 · Registration expired, pending cancellation · Once In A Lifetime Balloon Co Inc
- [N1926R](https://openairdocs.org/deregistered/N1926R-2013-05-06.md): Balloon Works FIREFLY 8 · S/N 11127 · Cancelled May 6, 2013 · Registration expired, pending cancellation · Built 1982 · Kimball Jay V
- [N37022](https://openairdocs.org/deregistered/N37022-2012-12-18.md): Balloon Works FIREFLY 8-24 · S/N F8-063 · Cancelled Dec 18, 2012 · Registration expired, pending cancellation · Built 1985 · Once In A Lifetime Inc
- [N4405Y](https://openairdocs.org/deregistered/N4405Y-2012-11-29.md): Piper PA-25-235 · S/N 25-4013 · Cancelled Nov 29, 2012 · Registration expired, pending cancellation · Built 1966 · Indrebo E J
- [N25533](https://openairdocs.org/deregistered/N25533-2012-08-14.md): Balloon Works FIREFLY 9 · S/N F9-055 · Cancelled Aug 14, 2012 · Registration pending, canceled · Built 1992
- [N2RE](https://openairdocs.org/deregistered/N2RE-1994-02-10.md): Cessna 150F · S/N 15063988 · Cancelled Feb 10, 1994 · Triennial form not returned · Eberhart Ronald F
- [N2450W](https://openairdocs.org/deregistered/N2450W-1984-07-11.md): Schweizer SGS 2-32 · S/N 50 · Cancelled Jul 11, 1984 · Administratively canceled · Indrebo E J DBA
- [N7787S](https://openairdocs.org/deregistered/N7787S-1975-12-15.md): Schweizer SGS 2-33A · S/N 157 · Cancelled Dec 15, 1975 · Indrebo E J
- [N5726S](https://openairdocs.org/deregistered/N5726S-1975-05-08.md): Schweizer SGS 2-33 · S/N 70 · Cancelled May 8, 1975 · Calistoga Soaring Center
- [N5754S](https://openairdocs.org/deregistered/N5754S-1973-06-25.md): Schweizer SGS 2-33A · S/N 89 · Cancelled Jun 25, 1973 · Calistoga Soaring Center

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

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