Skip to content

Cancelled registrations · 127

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

N35EGGates Learjet 35A · S/N 469Cancelled Mar 15, 2025 · Sale reported, canceled · Built 1982 N9728LBeech B19 · S/N MB-518Cancelled Feb 27, 2024 · Built 1971 · Henry George A N87RSchweizer SGS 2-32 · S/N 41Cancelled Feb 4, 2023 · Registration expired, pending cancellation · Built 1966 · Hollister Soaring Center LLC N7522CForney F-1 · S/N 5637Cancelled Jul 30, 2022 · Registration expired, pending cancellation · Built 1958 · Robinson Joseph B N337REBritish Aerospace BAE 125 SERIES 800A · S/N 258024Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Dk Turbines LLC N269DAirborne EDGE X CLASSIC · S/N 582612Cancelled Apr 3, 2021 · Registration expired, pending cancellation · Built 2002 · Enos Mark D N86760Bellanca 14-13 · S/N 1121Cancelled Sep 6, 2019 · Revoked, canceled · Built 1946 · Hollister Flying Club N105KBeech 65-90 · S/N LJ-113Cancelled Mar 13, 2018 · Registration expired, pending cancellation · Built 1966 · California Skydive Center N40PKGates Learjet 35A · S/N 260Cancelled Feb 28, 2018 · Registration expired, pending cancellation · Built 1979 · D K Turbines LLC N1432PPrice Roy A D-8A · S/N RAP-2Cancelled Jan 2, 2018 · Registration expired, pending cancellation · Pierce John C N480BCSwearingen SA-26AT · S/N T26-108Cancelled May 23, 2017 · Registration expired, pending cancellation · Built 1968 · Air Sales Inc N9187KUniversal Stinson 108-1 · S/N 108-2187Cancelled Feb 13, 2017 · Revoked, canceled · Built 1947 · Von Niederhausern Robert D N7745HPiper PA-12 · S/N 12-641Cancelled Feb 4, 2017 · Revoked, canceled · Built 1946 · Leisman Joseph Co Ow N62871Hiller OH-23G · S/N 63-12775Cancelled Sep 9, 2016 · Registration expired, pending cancellation · Built 1963 · Palm Steve N66NJGates Learjet 35A · S/N 296Cancelled Aug 25, 2015 · Sale reported · Built 1980 N124SLLiebenberg Paul Leon WOODSTOCK TWO · S/N 124Cancelled Sep 19, 2013 · Registration expired, pending cancellation · Built 1988 · Liebenberg Paul L N686CHAero Commander S2R · S/N 1866RCancelled Aug 23, 2013 · Sale reported, canceled · Built 1973 N204DRBell UH-1B · S/N 62-1881Cancelled Aug 21, 2013 · Sale reported, canceled N102HTHiller UH-12E · S/N 5218Cancelled Aug 14, 2013 · Registration expired, pending cancellation · Built 1983 · Palm Kevin N3503MPiper PA-12 · S/N 12-2352Cancelled Jul 25, 2013 · Sale reported, pending cancellation · Built 1947 N510MSLearjet 24B · S/N 204Cancelled Jul 1, 2013 · Second renewal notice · Built 1969 · Dk Turbines LLC N7504YPiper PA-30 · S/N 30-566Cancelled Jun 19, 2013 · Sale reported, pending cancellation · Built 1964 N84JJJones Jim L RS-550TWO · S/N SB-2144Cancelled Jun 14, 2013 · Registration expired, pending cancellation · Eastman William N686WBoeing A75N1(PT17) · S/N 75-3772Cancelled May 2, 2013 · Registration expired, pending cancellation · Built 1942 · Cruz Lenard F DBA N1121EAero Commander 1121 · S/N 20Cancelled Apr 11, 2013 · Sale reported, pending cancellation N6027XMooney M20A · S/N 1617Cancelled Apr 11, 2013 · Sale reported, pending cancellation · Built 1960 N7611RBeech 19A · S/N MB-422Cancelled Apr 11, 2013 · Sale reported, pending cancellation · Built 1969 N5176WPiper PA-28-160 · S/N 28-211Cancelled Apr 1, 2013 · Registration expired, pending cancellation · Built 1961 · Gavilan College N8717WPiper PA-28-235 · S/N 28-10252Cancelled Mar 5, 2013 · Triennial form not returned · Built 1964 · Richlife Quest A N116KXAero Commander 1121 · S/N 87Cancelled Feb 7, 2013 · Sale reported, pending cancellation · Built 1966 N9317BCessna 175 · S/N 55117Cancelled Nov 19, 2012 · Sale reported, pending cancellation · Built 1958 N54800Cessna T-50 · S/N 6007Cancelled Sep 18, 2012 · Revoked, canceled · Built 1944 · Gambetta Leo V N1783SAero Commander 600 S-2D RESTRICTED · S/N 600-1408DCancelled Aug 13, 2012 · Registration expired, pending cancellation · Built 1967 · Ag-Rotors Inc N23SADouglas DC-3A-S1C3G · S/N 4903Cancelled Aug 13, 2012 · Sale reported, canceled · Built 1942 N69MTLockheed 1329 · S/N 5107Cancelled Aug 7, 2012 · Registration pending, canceled · Built 1967 N1785SAero Commander 600 S-2D · S/N 600-1406DCancelled Jul 30, 2012 · Sale reported, canceled · Built 1967 N3612KPiper J3C-65 · S/N 22303Cancelled May 11, 2012 · Sale reported, pending cancellation · Built 1946 N1121NAero Commander 1121B · S/N 110Cancelled Jun 27, 2011 · Sale reported, pending cancellation · Built 1966 N235EDOwens Howard E VANS RV-8A · S/N 81732Cancelled Jan 25, 2010 · Exported to Australia · Owens Howard E N1736APiper PA-18-125 · S/N 18-1308Cancelled Aug 3, 2009 · Registration revoked · Built 1952 · Swanson Francis N269SDFarrell Sean Patrick VANS AIRCRAFT RV-7A · S/N 72505Cancelled Dec 8, 2008 · Built 2007 · Farrell Sean P N5515BCessna 152 · S/N 15283891Cancelled Oct 24, 2008 · Exported to Philippines · Built 1979 · Gavilan Aviation Inc N3369CBeech F35 · S/N D-4036Cancelled Aug 13, 2007 · Built 1955 · Gavilan Aviation N116QTBeech H35 · S/N D-4870Cancelled May 1, 2007 · Sale reported · Built 1956 N34SWAero Commander 1121 · S/N 97Cancelled Apr 28, 2006 · Built 1966 · O K Turbines Inc N540CLLearjet 23 · S/N 23-026Cancelled Apr 28, 2006 · Triennial form not returned · Built 1965 · Ok Turbines Inc N96TSIsrael Aircraft Industries 1123 · S/N 159Cancelled Mar 25, 2005 · Triennial form not returned · Built 1972 · Ok Turbines Inc N104JMMcanally Justin SHA-GLASAIR JM-1 · S/N 001-SH778Cancelled Aug 13, 2003 · Built 1988 · Brin William J Trustee N80TNNorth American NA-265-80 · S/N 380-19Cancelled Jun 6, 2002 · Sale reported N1132APiper PA-18-125 · S/N 18-726Cancelled Apr 18, 2000 · Baum Troy A

Back to Hollister, CA