Skip to content

Cancelled registrations · 236

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 = 'STOCKTON' 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 = 'STOCKTON'
  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 = 'STOCKTON'
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.

N7104XBalloon Works FIREFLY 8B · S/N F8B-094Cancelled Aug 1, 2026 · Sale reported, canceled N519XLLiberty Aerospace LIBERTY XL-2 · S/N 0014Cancelled Mar 16, 2024 · Sale reported, canceled · Built 2006 N18LKBeech E18S · S/N BA230Cancelled Oct 7, 2023 · Sale reported, canceled N563JJohannes James D LIGHTNING · S/N 87Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Built 2009 · Belshe Robert A Trustee N663HRDJI PHANTOM 3 PROFESSION · S/N P76DC107010305Cancelled Sep 24, 2022 · Registration expired, pending cancellation · Renewable Technologies Inc N67430Beech D17S · S/N 4822Cancelled Jul 27, 2021 · Revoked, canceled · Built 1943 · Vick Sylvan V N67723Fairchild M-62A · S/N FW908Cancelled Jul 19, 2021 · Revoked, canceled · Cramer Errol J N732EBBeech G18S · S/N BA-506Cancelled May 29, 2021 · Sale reported, canceled N66903Consolidated Vultee BT-13A · S/N 6128Cancelled Mar 20, 2020 · Revoked, canceled · Built 1942 · Weber Charles M N66904Consolidated Vultee BT-13A · S/N 7705Cancelled Mar 20, 2020 · Revoked, canceled · Weber Charles M N66963Consolidated Vultee BT-13A · S/N 3451Cancelled Mar 20, 2020 · Revoked, canceled · Weber Charles M N66965Consolidated Vultee BT-13A · S/N 2614Cancelled Feb 12, 2020 · Revoked, pending cancellation · Weber Charles M N327NEAuclair Michael D RENEGADE SPIRIT · S/N 315Cancelled Oct 4, 2019 · Registration expired, pending cancellation · Built 1992 · Earhart Nancy A N81402Aeronca 7AC · S/N 7AC-20Cancelled Mar 4, 2019 · Sale reported, canceled N3366MPiper PA-12 · S/N 12-2241Cancelled Mar 2, 2019 · Revoked, pending cancellation · Built 1947 · Blazer Eugene T N20PVLockheed PV-2 · S/N 15-1490Cancelled Jan 25, 2019 · Sale reported, canceled · Built 1944 N351DPPalmer Douglas Ian SPENCER AIRCAR S12E · S/N 351Cancelled Dec 1, 2018 · Registration expired, pending cancellation · Built 2007 · Plane Exchange Inc N6333JPiper PA-28-180 · S/N 28-4741Cancelled Mar 28, 2018 · Registration expired, pending cancellation · Built 1968 · Freytag Ronald D N30105Cessna 177 · S/N 17701064Cancelled Mar 21, 2018 · Registration expired, pending cancellation · Built 1968 · Plane Exchange Inc N99375Ercoupe 415-C · S/N 1998Cancelled Mar 16, 2018 · Registration expired, pending cancellation · Built 1946 · Montgomery Robert A N116KRRore James VANS RV-10 · S/N 003Cancelled Mar 12, 2018 · Registration expired, pending cancellation · Built 2014 · Rore James L N2314ZRobinson Helicopter R22 BETA · S/N 1995Cancelled Jan 11, 2018 · Registration expired, pending cancellation · Built 1991 · Heath David L DBA Sunrise Helicopter N28645Fairchild 24W-40 · S/N W40-165Cancelled Jan 3, 2018 · Registration expired, pending cancellation · Built 1940 · Mckenzie Aviation Services N76971Cessna 140 · S/N 11417Cancelled Nov 21, 2017 · Revoked, canceled · Built 1946 · Francois Nadaline N9040TCessna 182C · S/N 52940Cancelled Sep 26, 2017 · Registration expired, pending cancellation · Built 1960 · Buckman Kevin N240ABNorth Wing APACHE · S/N 0832Cancelled Jul 18, 2017 · Registration expired, pending cancellation · Built 2002 · Mc Grattan Colin J N55998Berry E F WINDY TWO · S/N ONECancelled Jun 30, 2017 · Registration expired, pending cancellation · Ketler Ronald W N641JPSabre SABRE 503 · S/N 26Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Built 1996 · Patterson Jean D N9331AHorvath John L III RECON · S/N 0005Cancelled Jun 7, 2017 · Registration expired, pending cancellation · Horvath John L III N4573KRyan NAVION · S/N NAV-4-1573Cancelled Apr 7, 2017 · Registration expired, pending cancellation · Built 1948 · Bellatos And Bellatos N6054KCessna R172K · S/N R1722022Cancelled Feb 16, 2017 · Registration expired, pending cancellation · Built 1976 · Davis Gent L N7910LBeech A23-19 · S/N MB-121Cancelled Feb 4, 2017 · Revoked, canceled · Built 1966 · Werner George R DBA N68403Cessna 152 · S/N 15282285Cancelled Feb 23, 2016 · Exported to Thailand · Built 1978 · Plane Exchange Inc N35664Cessna 172I · S/N 17256892Cancelled Feb 4, 2016 · Built 1968 · Plane Exchange Inc N61838Cessna 172M · S/N 17264832Cancelled Jan 7, 2016 · Exported to United Arab Emirates · Built 1975 · Plane Exchange Inc N64374Cessna 172M · S/N 17265202Cancelled Jan 29, 2015 · Exported to Thailand · Built 1975 · Plane Exchange Inc N711EHHutchinson HOMEBUILT EH-1 · S/N 1Cancelled Dec 2, 2014 · Revoked, canceled · Built 1975 · Hutchinson Elvin L N930TPProtheroe DUSTER BJ-1B · S/N 86Cancelled Nov 24, 2014 · Registration expired, pending cancellation · Built 1973 · Smith Dalton M N619MEBell UH-1B · S/N 61-701Cancelled Oct 14, 2014 · Registration expired, pending cancellation · Eccles Gary M N2149RRamer Vincent A TITAN TORNADO II · S/N D97912COHK0280Cancelled Oct 2, 2014 · Registration expired, pending cancellation · Built 2000 · Green Darren T N7090GCessna 172K · S/N 17258790Cancelled Jan 31, 2014 · Exported to Kenya · Built 1969 · Plane Exchange Inc N7801GCessna 172L · S/N 17259501Cancelled Jan 31, 2014 · Exported to Kenya · Built 1970 · Plane Exchange Inc N4127EPiper PA-34-220T · S/N 3449053Cancelled Oct 28, 2013 · Exported to Brazil · Built 1998 · Wolfe Peter V DBA N66770Cessna 150M · S/N 15076264Cancelled Oct 28, 2013 · Exported to Pakistan · Built 1974 N95770Taylorcraft BC12-D · S/N 8070Cancelled Sep 27, 2013 · Registration pending, canceled · Built 1946 N9806JCessna A150M · S/N A1500615Cancelled Sep 27, 2013 · Exported to Uruguay · Built 1975 · Pilot Communications N4530WKerlin Gilbert D QUICKIE · S/N 1Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Kerlin Gilbert D N588MKZenith CH701 · S/N 74588Cancelled Sep 13, 2013 · Exported to Mexico · Kelso Max Byron N6701DBell 47G-2 · S/N 2188Cancelled Sep 13, 2013 · Registration expired, pending cancellation · Built 1958 · Eccles Richard D N8879ABeech B35 · S/N D-2534Cancelled Sep 11, 2013 · Registration expired, pending cancellation · Built 1956 · Fransen Dana A

Back to Stockton, CA