# Cancelled registrations: Yountville, CA

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

Cancelled aircraft registrations in Yountville, CA.

- [N947CA](https://openairdocs.org/deregistered/N947CA-2018-12-21.md): Ultramagic N-300 · S/N 300/27 · Cancelled Dec 21, 2018 · Exported to Mexico · Built 2007
- [N2VF](https://openairdocs.org/deregistered/N2VF-2018-12-15.md): Beech B95A · S/N TD-472 · Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Built 1961 · Plescia Brian
- [N7418M](https://openairdocs.org/deregistered/N7418M-2018-01-08.md): Balloon Works FIREFLY 8-24 · S/N F8-081 · Cancelled Jan 8, 2018 · Registration expired, pending cancellation · Napa Valley Aloft Inc
- [N22030](https://openairdocs.org/deregistered/N22030-2018-01-05.md): Firefly Balloons FIREFLY 10 · S/N F10-2005 · Cancelled Jan 5, 2018 · Registration expired, pending cancellation · Built 2004 · Napa Valley Aloft Inc
- [N2145P](https://openairdocs.org/deregistered/N2145P-2017-06-21.md): Firefly Balloons FIREFLY 11 · S/N F11-2006 · Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 2006 · Napa Valley Balloons Inc
- [N2196G](https://openairdocs.org/deregistered/N2196G-2017-06-19.md): Firefly Balloons GALAXY 11 · S/N GLX-11211 · Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2005 · Napa Valley Balloons Inc
- [N5709B](https://openairdocs.org/deregistered/N5709B-2013-07-22.md): Raven Industries RALLY RX7 · S/N RX7-216 · Cancelled Jul 22, 2013 · Registration expired, pending cancellation · Built 1980 · Above The West Hot Air Ballooning
- [N6307C](https://openairdocs.org/deregistered/N6307C-2013-06-24.md): Aerostar International S-66A · S/N S66A-3041 · Cancelled Jun 24, 2013 · Second renewal notice · Built 1990 · Balloon Aviation
- [N2799S](https://openairdocs.org/deregistered/N2799S-2013-06-18.md): Raven Industries S-66A · S/N S66A-158 · Cancelled Jun 18, 2013 · Registration expired, pending cancellation · Built 1985 · Adventures Aloft Napa Valley Inc
- [N6516B](https://openairdocs.org/deregistered/N6516B-2013-05-10.md): Aerostar International S-77A · S/N S77A-3005 · Cancelled May 10, 2013 · Sale reported, canceled · Built 1987
- [N986AA](https://openairdocs.org/deregistered/N986AA-2012-11-28.md): Colt Balloons 160A · S/N 1054 · Cancelled Nov 28, 2012 · Sale reported, canceled
- [N2208N](https://openairdocs.org/deregistered/N2208N-2012-10-03.md): Firefly Balloons FIREFLY 10 · S/N F10-2003 · Cancelled Oct 3, 2012 · Sale reported · Built 2004
- [N2018V](https://openairdocs.org/deregistered/N2018V-2012-10-02.md): Firefly Balloons FIREFLY 9B-15 · S/N F9B-2018 · Cancelled Oct 2, 2012 · Sale reported · Built 2006
- [N2576N](https://openairdocs.org/deregistered/N2576N-2012-10-02.md): Balloon Works FIREFLY 9B-15 · S/N F9B-006 · Cancelled Oct 2, 2012 · Third renewal notice · Napa Valley Aloft Inc
- [N2579V](https://openairdocs.org/deregistered/N2579V-2012-10-02.md): Balloon Works FIRE FLY 10 · S/N F10-015 · Cancelled Oct 2, 2012 · Sale reported · Built 1994
- [N3218R](https://openairdocs.org/deregistered/N3218R-2012-10-02.md): Balloon Works FIRE FLY 10 · S/N F10-026 · Cancelled Oct 2, 2012 · Sale reported · Built 1997
- [N3291N](https://openairdocs.org/deregistered/N3291N-2012-10-02.md): Balloon Works FIRE FLY 10 · S/N F10-022 · Cancelled Oct 2, 2012 · Sale reported · Built 1996
- [N7032N](https://openairdocs.org/deregistered/N7032N-2012-10-02.md): Balloon Works FIREFLY 9B-15 · S/N F9B-019 · Cancelled Oct 2, 2012 · Sale reported · Built 1999
- [N74214](https://openairdocs.org/deregistered/N74214-2012-10-02.md): Balloon Works FIREFLY 8B · S/N F8B-055 · Cancelled Oct 2, 2012 · Sale reported · Built 1986
- [N7423Q](https://openairdocs.org/deregistered/N7423Q-2012-10-02.md): Balloon Works FIREFLY 8-24 · S/N F8-089 · Cancelled Oct 2, 2012 · Sale reported · Built 1986
- [N4503N](https://openairdocs.org/deregistered/N4503N-2010-01-22.md): Cameron Balloons US A-210 · S/N 6354 · Cancelled Jan 22, 2010 · Triennial form not returned · Built 2003 · Napa Valley Balloons Inc
- [N3202V](https://openairdocs.org/deregistered/N3202V-2008-05-16.md): Balloon Works FIRE FLY 10 · S/N F10-019 · Cancelled May 16, 2008 · Triennial form not returned · Built 1995 · Napa Valley Balloons Inc
- [N21963](https://openairdocs.org/deregistered/N21963-2008-02-13.md): Firefly Balloons FIREFLY 10 · S/N F10-2006 · Cancelled Feb 13, 2008 · Triennial form not returned · Built 2004 · Napa Valley Balloons Inc
- [N5306N](https://openairdocs.org/deregistered/N5306N-2007-10-26.md): Cameron Balloons US A-210 · S/N 6165 · Cancelled Oct 26, 2007 · Triennial form not returned · Built 1998 · Napa Valley Balloons Inc
- [N36914](https://openairdocs.org/deregistered/N36914-2007-10-01.md): Balloon Works FIREFLY 8-24 · S/N F8-048 · Cancelled Oct 1, 2007 · Napa Valley Balloons Inc
- [N3288N](https://openairdocs.org/deregistered/N3288N-2007-01-23.md): Balloon Works FIRE FLY 10 · S/N F10-025 · Cancelled Jan 23, 2007 · Triennial form not returned · Built 1997 · Napa Valley Balloons Inc
- [N210NV](https://openairdocs.org/deregistered/N210NV-2006-08-30.md): Thunder & Colt America AX10-210S2 · S/N 4795 · Cancelled Aug 30, 2006 · Triennial form not returned · Built 2000 · Napa Valley Balloons Inc
- [N31415](https://openairdocs.org/deregistered/N31415-2005-11-17.md): Balloon Works FIRE FLY 10 · S/N F10-023 · Cancelled Nov 17, 2005 · Triennial form not returned · Built 1996 · Napa Valley Balloons Inc
- [N15078](https://openairdocs.org/deregistered/N15078-2005-07-20.md): Firefly Balloons FIREFLY 11B · S/N F11B-2002 · Cancelled Jul 20, 2005 · Triennial form not returned · Built 2001 · Napa Valley Balloons Inc
- [N2552N](https://openairdocs.org/deregistered/N2552N-2004-09-28.md): Balloon Works FIREFLY 9B-15 · S/N F9B-003 · Cancelled Sep 28, 2004 · Triennial form not returned · Built 1992 · Napa Valley Balloons Inc
- [N2599N](https://openairdocs.org/deregistered/N2599N-2002-01-08.md): Balloon Works FIRE FLY 10 · S/N F10-004 · Cancelled Jan 8, 2002 · Triennial form not returned · Built 1992 · Napa Valley Balloons Inc
- [N9087N](https://openairdocs.org/deregistered/N9087N-2001-02-21.md): Balloon Works FIREFLY 9 · S/N F9-050 · Cancelled Feb 21, 2001 · Triennial form not returned · Napa Valley Balloons Inc
- [N9091N](https://openairdocs.org/deregistered/N9091N-1998-05-12.md): Balloon Works FIREFLY 8-24 · S/N F8141 · Cancelled May 12, 1998 · Triennial form not returned · Napa Valley Balloons Inc
- [N7405C](https://openairdocs.org/deregistered/N7405C-1998-01-26.md): Balloon Works FIREFLY 8-24 · S/N F8062 · Cancelled Jan 26, 1998 · Triennial form not returned · Napa Valley Balloons Inc
- [N90850](https://openairdocs.org/deregistered/N90850-1998-01-21.md): Balloon Works FIREFLY 9 · S/N F9036 · Cancelled Jan 21, 1998 · Triennial form not returned · Napa Valley Balloons Inc
- [N4063K](https://openairdocs.org/deregistered/N4063K-1997-10-10.md): Balloon Works FIREFLY 7 · S/N 7995 · Cancelled Oct 10, 1997 · Triennial form not returned · Napa Valley Balloons Inc
- [N7418Z](https://openairdocs.org/deregistered/N7418Z-1997-10-08.md): Balloon Works FIREFLY 8-24 · S/N F8090 · Cancelled Oct 8, 1997 · Triennial form not returned · Napa Valley Balloons Unlimited Inc
- [N3721N](https://openairdocs.org/deregistered/N3721N-1997-02-18.md): Balloon Works FIREFLY 8-24 · S/N F8066 · Cancelled Feb 18, 1997 · Triennial form not returned · Napa Valley Balloons Inc
- [N9023Z](https://openairdocs.org/deregistered/N9023Z-1997-02-11.md): Balloon Works FIREFLY 8 · S/N F8350 · Cancelled Feb 11, 1997 · Triennial form not returned · Napa Valley Balloons Inc
- [N25069](https://openairdocs.org/deregistered/N25069-1995-10-19.md): Balloon Works FIREFLY 8 · S/N F8381 · Cancelled Oct 19, 1995 · Triennial form not returned · Above The West Hot Air Ballooning
- [N27046](https://openairdocs.org/deregistered/N27046-1995-07-17.md): Balloon Works FIREFLY 8-24 · S/N 804 · Cancelled Jul 17, 1995 · Triennial form not returned · Napa Valley Balloons Inc
- [N40514](https://openairdocs.org/deregistered/N40514-1994-06-27.md): Balloon Works FIREFLY 7 · S/N 7953 · Cancelled Jun 27, 1994 · Triennial form not returned · Napa Valley Balloons Inc
- [N2197H](https://openairdocs.org/deregistered/N2197H-1992-04-23.md): Balloon Works FIREFLY 7 · S/N 7793 · Cancelled Apr 23, 1992 · Triennial form not returned · Napa Valley Balloons Inc
- [N1824G](https://openairdocs.org/deregistered/N1824G-1976-03-30.md): Champion 7GCBC · S/N 107 · Cancelled Mar 30, 1976 · Steltzner Richard M

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

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