Skip to content

Cancelled registrations · 25

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

N14327Piper PA-18-150 · S/N 18-7409087Cancelled Jan 31, 2026 · Sale reported, canceled · Built 1974 N2488Bensen B-8M · S/N 01Cancelled Dec 30, 2023 · Revoked, canceled · Built 1971 · Harvey Clayton W N3647VCessna 150M · S/N 15076575Cancelled Oct 30, 2021 · Registration expired, pending cancellation · Thomason Mitchell N82570Aeronca 7AC · S/N 7AC1207Cancelled Apr 3, 2020 · Revoked, canceled · Built 1946 · Forrest James A N72LSRolladen-Schneider LS 4A · S/N 4581Cancelled Aug 12, 2019 · Exported to New Zealand · Thomson Brian C Trustee N1958TPiper PA-28-180 · S/N 28-7105193Cancelled Mar 23, 2018 · Revoked, canceled · Built 1971 · Capps John L Jr N7195TCessna 172A · S/N 46795Cancelled Jan 23, 2018 · Registration expired, pending cancellation · Built 1959 · Marteney Anne N96ECessna 170A · S/N 19985Cancelled Nov 21, 2017 · Revoked, canceled · Built 1951 · Austin Richard Cornelius N97434Stinson 108 · S/N 108434Cancelled Feb 13, 2017 · Revoked, canceled · Built 1946 · Cindyline N35DBCessna T210L · S/N T210-59775Cancelled Dec 17, 2012 · Exported to Mexico · Built 1972 · Byrne Paul B N458AECessna 150G · S/N 15066610Cancelled Sep 10, 2012 · Registration pending, canceled · Built 1967 N5131PPiper PA-24 · S/N 24-144Cancelled Aug 13, 2012 · Revoked, canceled · Built 1958 · Jones Royce A N502RGGrumman G-1159 · S/N 178Cancelled Jul 23, 2011 · Sale reported · Built 1976 N173ELGrumman G-1159 · S/N 173Cancelled Feb 23, 2006 · Built 1975 · Plane Parts Inc N2434TNavion NAVION G · S/N NAV-4-2434Cancelled May 5, 2001 · Triennial form not returned · Tenneson D C N6597PPiper PA-24-180 · S/N 24-1719Cancelled May 12, 2000 · Ferrell J L Jr N693QBeech 35-33 · S/N CD14Cancelled Jul 9, 1992 · Triennial form not returned · Nunnelee Burl H N3546Stewart FLY BABY · S/N 1Cancelled Dec 8, 1981 · Built 1971 · Besha Charles N N1269TPiper PA-28-140 · S/N 28-7225445Cancelled Aug 31, 1977 · Carter Donna J N6670TCessna 150A · S/N 15059070Cancelled Jul 14, 1977 · Boron Peter E N82109Aeronca 7AC · S/N 7AC-735Cancelled Nov 19, 1970 · James R Collins N4624VHutchinson VHS · S/N 101Cancelled Aug 9, 1968 · Built 1950 · Heronen John E N33223Piper J3C-65 · S/N 5899Cancelled Aug 17, 1960 · Ralph C Spurgeon N84849Aeronca 7AC · S/N 7AC-3568Cancelled Oct 12, 1955 · Schmidt Earl N3253Ryan M-2 · S/N 11Cancellation date not recorded · Built 1927 · Bruenger I J

Back to Saugus, CA