Cancelled registrations · 18

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

N6637KGrumman Acft ENG Cor-Schweizer G-164B · S/N 402BCancelled Jan 22, 2026 · Exported to Uruguay · Built 1978 · Jones Aviation Inc N716YGrumman G-164 · S/N 278Cancelled Apr 25, 2023 · Registration expired, pending cancellation · Built 1964 · Jones Aviation Inc N10277Grumman G-164 · S/N 77Cancelled May 11, 2012 · Registration expired, pending cancellation · Built 1961 · Williams Clarence E N703YGrumman G-164 · S/N 269Cancelled Mar 16, 2011 · First renewal notice · Built 1963 · Chuck Jones Flying Service Inc N3631BSchweizer G-164B · S/N 762BCancelled Sep 27, 2004 · Sale reported · Built 1984 N10222Grumman G-164 · S/N 22Cancelled Apr 2, 2004 · Triennial form not returned · Built 1959 · Chuck Jones Flying Service Inc N10219Grumman G-164 · S/N 19Cancelled Mar 31, 2004 · Triennial form not returned · Built 1959 · Chuck Jones Flying Service N982XGrumman G-164A · S/N 496Cancelled Dec 11, 2003 · Triennial form not returned · Built 1968 · Jones Dale A N9640KStinson 108-2 · S/N 108-2640Cancelled Apr 29, 2003 · Triennial form not returned · Built 1947 · Bacon Gerald A N9830Grumman Acft ENG Cor-Schweizer G-164A · S/N 1257Cancelled Feb 11, 2000 · Triennial form not returned · Chuck Jones Flying Service Inc N6030TCessna 150D · S/N 15060730Cancelled Feb 16, 1994 · Triennial form not returned · Satur Paul N363YGrumman G-164 · S/N 209Cancelled Dec 24, 1992 N6708KGrumman Acft ENG Cor-Schweizer G-164B · S/N 374BCancelled Oct 29, 1991 · Triennial form not returned · Chuck Jones Flying Service Inc N10225Grumman G-164 · S/N 25Cancelled Jun 25, 1983 · Administratively canceled · Chuck Jones Flying Service N53306Cessna A188B · S/N 18801747TCancelled Jun 24, 1983 · Exported to Australia · Ag Viation Inc N9449RSnow S2A · S/N 1079ACancelled May 20, 1965 · Butte County Mosquito Abatement Dist N9435RSnow S2A · S/N 1065ACancelled Jul 5, 1962 · Butte County Mosquito Abatement District N9750HBoeing B75N1 · S/N 75-7443Cancelled Jun 19, 1959 · Stanley John L

Back to Biggs, CA