Skip to content

Cancelled registrations · 146

Query with 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 = 'NAPA' ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id

duckdb -csv -c "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 = 'NAPA'
  ORDER BY d.cancel_date DESC NULLS LAST, d.deregistration_id"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N24412Semco Balloon T · S/N SEM92Cancelled Jul 27, 2024 · Revoked, canceled · Hacker Dan N6953UCameron Balloons US A-250 · S/N 6856Cancelled Feb 23, 2024 · Exported to Kenya · Built 2018 · Napa Valley Balloons Inc N808DRFischer Bob FISCHER MONARCH · S/N FB211Cancelled Jun 5, 2023 · Exported to Australia · Built 2010 · Obrien Barton P N967PVans RV-12IS · S/N 121048Cancelled Aug 11, 2022 · Exported to United Kingdom · Built 2021 · Steers Roger T N4513APiper PA-22-150 · S/N 22-3818Cancelled May 9, 2022 · Registration expired, pending cancellation · Lucas Lester L N4133NCessna 140 · S/N 13596Cancelled Feb 5, 2022 · Registration expired, pending cancellation · Built 1947 · Marek Arthur J N801PFParadise Flyers RIB 1 · S/N 001Cancelled Dec 8, 2021 · Sale reported, canceled · Built 2002 N1079CUltramagic S A N-250 · S/N 250/24Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Balloons Above The Valley Ltd N2424NHead Balloons AX8-105 · S/N 336Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Built 2004 · Hough Williamson T N1186MPingrey Richard H AEROCHAIR AX3-21 · S/N 002Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1982 · Kimball Jerrold V N7213BBalloon Works FIREFLY 9B-15 · S/N F9B-026Cancelled May 20, 2020 · First renewal notice · Built 2000 · Bulman Terry B DBA N25018Semco Balloon T · S/N SEM69Cancelled Dec 27, 2019 · Revoked, canceled · Built 1972 · Beidleman Rodney N328SKKemnitzer Stephen R ZENITH STOL CH750 · S/N 75-8975Cancelled Dec 23, 2019 · Built 2014 · Kemnitzer Stephen R N64277Aerostar International RX-7 · S/N RX7-3053Cancelled Nov 29, 2019 · Registration expired, pending cancellation · Built 1986 · Custis Kenneth R N6703LBeech 76 · S/N ME-288Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1979 · Skyking Aviation Services LLC N896MHAdam Aircraft Industries A500 · S/N 0008Cancelled Mar 14, 2019 · Registration expired, pending cancellation · Built 2006 · Monticello Air LLC N90308Balloon Works FIREFLY 8-24 · S/N F8-301Cancelled Feb 26, 2019 · Registration expired, pending cancellation · Built 1989 · Bonaventura Balloon Co Inc N25634Balloon Works FIREFLY 9B-15 · S/N F9B-002Cancelled Jan 29, 2019 · Registration expired, pending cancellation · Built 1992 · Bonaventura Balloon Co Inc N80732Globe GC-1A · S/N 135Cancelled Oct 12, 2018 · Revoked, canceled · Built 1946 · Sanchez Salvador N553FSDJI PHANTOM 2 VISION + · S/N PH645487694 V3.0Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Smith Kendrick F N6406NAerostar International RX-7 · S/N RX7-3057Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Built 1986 · Johnson Diana K N3955NBeech 35 · S/N D-1215Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1947 · Henry Brian James DBA N90884Balloon Works FIREFLY 8 · S/N F8-354Cancelled Feb 23, 2018 · Registration expired, pending cancellation · Built 1990 · Streich Karl F N4058MCameron Balloons US A-250 · S/N 6504Cancelled Feb 14, 2018 · Registration expired, pending cancellation · Built 2007 · Napa Valley Balloons Inc N2011FBalloon Works FIREFLY 7 · S/N F7-221Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Thorne Gayne R N1203RThunder Balloons AX8-90 · S/N 736Cancelled Dec 21, 2017 · First renewal notice · Built 1985 · Jones Christopher A N1259YCameron Balloons A-315 · S/N 6435Cancelled Jun 19, 2017 · Registration expired, pending cancellation · Built 2006 · Balloons Above The Valley Ltd N3595MAerostar International RAVEN S-66A · S/N S66A-3032Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1989 · Philbert John N N63468Aerostar International S-77A · S/N S77A-3017Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1991 · Balloons Above The Valley N66SAAleshire T Stewart MONI · S/N 00361Cancelled Feb 28, 2017 · Registration expired, pending cancellation · Munson Harry L N2010DBailey FLAGLOR SCOOTER 007 · S/N 178Cancelled Feb 4, 2017 · Revoked, canceled · Bailey Mark T N7674WPiper PA-28-180 · S/N 28-1655Cancelled Feb 4, 2017 · Revoked, canceled · Built 1964 · Huntley Ben N1089VCameron Balloons US A-250 · S/N 6400Cancelled Sep 1, 2016 · Third renewal notice · Built 2005 · Balloons Above The Valley Ltd N4459WCameron Balloons US A-250 · S/N 6230Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1999 · Dream Flights LLC N8079XCessna 172B · S/N 17248579Cancelled May 15, 2015 · Registration expired, pending cancellation · Built 1961 · Kane Benjamin J N16131Avian Balloon MAGNUM IX · S/N 164Cancelled May 5, 2015 · Registration expired, pending cancellation · American Hot Airlines Inc N1613ZAvian Balloon MAGNUM IX · S/N 163Cancelled Dec 22, 2014 · Registration expired, pending cancellation · Balloon Safaris Inc N2806XRaven Industries S-66A · S/N S66A-159Cancelled Dec 17, 2014 · Registration expired, pending cancellation · Balloon Aviation Of Napa Valley N8479PThunder Balloons AX8-90 · S/N 259Cancelled Nov 26, 2014 · Registration expired, pending cancellation · Built 1980 · Strain Gary C N7759CSkyhopper 10 · S/N 10Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1961 · Kunkel Mark W N471RSSantos Rob J BENSEN B-80 · S/N RS-1Cancelled Oct 27, 2014 · Registration expired, pending cancellation · Santos Rob J N43540Piper PA-34-200 · S/N 34-7450193Cancelled Oct 9, 2014 · Registration expired, pending cancellation · Built 1974 · Pitner Robert E N1516SBalloon Works FIREFLY 7 · S/N 11086Cancelled Sep 5, 2014 · Registration expired, pending cancellation · Built 1981 · Williams Hiram T N27862Raven Industries S-66A · S/N S66A-154Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1985 · Napa'S Great Balloon Escape Inc N9365PPiper PA-24-260 · S/N 24-4865Cancelled Nov 8, 2013 · Registration expired, pending cancellation · Built 1969 · Langhofer Gene Trustee N9661RBeech D50C · S/N DH-244Cancelled Oct 28, 2013 · Registration expired, pending cancellation · Built 1960 · Napa Valley Dodge DBA N7107RBalloon Works FIREFLY 8-24 · S/N F8-108Cancelled Oct 23, 2013 · Registration expired, pending cancellation · Built 1987 · Balloons Above The Valley N25767Balloon Works FIRE FLY 10 · S/N F10-001Cancelled Oct 21, 2013 · First renewal notice · Marshall Jim G N90240Balloon Works FIREFLY 9 · S/N F9-012Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Built 1989 · Balloons Above The Valley Ltd N61109Cameron Balloons US N-180 · S/N 5538Cancelled Sep 20, 2013 · Registration expired, pending cancellation · Built 1989 · Postelnek Alan N

Back to Napa, CA