Skip to content

Cancelled registrations · 145

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

N222RNRain Industries RAIN MK2B · S/N RN1006E19BCancelled Jun 20, 2024 · Non-citizen corporation, flight hours not reported · Rain Industries Inc N3036SCessna 150G · S/N 15066936Cancelled Jan 27, 2024 · Sale reported, canceled · Built 1967 N75DCessna 150M · S/N 15078673Cancelled Jan 11, 2021 · Registration expired, pending cancellation · Built 1976 · Therrien Edward N67EMScott Terry COMP AIR 7 SL · S/N 017268SLCancelled Aug 2, 2020 · Sale reported, canceled · Built 2002 N23774Stinson HW75 · S/N 7242Cancelled Jun 26, 2020 · Revoked, canceled · Built 1939 · Baker Boyd N48074Aeronca 0-58B · S/N 11003Cancelled Nov 19, 2019 · Revoked, pending cancellation · Built 1943 · Jones David M N47952Piper PA-28-161 · S/N 28-7816168Cancelled Jul 8, 2019 · Sale reported, canceled · Built 1977 N2293KLuscombe 8A · S/N 5020Cancelled Jan 29, 2019 · Revoked, canceled · Built 1947 · Therien Edward J N95038Cessna 152 · S/N 15285843Cancelled Nov 6, 2018 · Sale reported, canceled · Built 1984 N3080DCessna 310 · S/N 35280Cancelled May 30, 2018 · Sale reported, canceled · Built 1956 N7939DBeech H35 · S/N D-5245Cancelled Feb 16, 2018 · Registration expired, pending cancellation · Built 1957 · Hibler Phillip E N22887Cessna 150H · S/N 15068590Cancelled Jan 12, 2018 · Registration expired, pending cancellation · Built 1968 · Burejsza Daniel J N5797ECessna 150 · S/N 17297Cancelled Nov 21, 2017 · Revoked, canceled · Built 1959 · Shandrew Steven L N7869CBensen B-8MEJ · S/N VLD-3Cancelled Jun 21, 2017 · Registration expired, pending cancellation · Built 1962 · Witt Howard D N21912Cessna 172M · S/N 17264041Cancelled May 31, 2017 · Registration expired, pending cancellation · Built 1974 · Hobson Charles A N25243Moore Dan J MOORE-2 · S/N DM-Z-01Cancelled Mar 24, 2017 · Registration expired, pending cancellation · Moore Dan J N8920MBeech S35 · S/N D-7323Cancelled Feb 22, 2017 · Registration expired, pending cancellation · Built 1964 · Haskin Elmer G Jr N9933QCessna 172M · S/N 17265877Cancelled Dec 14, 2016 · Exported to Argentina · Built 1975 · Ware Damien T N7193ACessna 172 · S/N 29293Cancelled May 4, 2015 · Registration expired, pending cancellation · Built 1956 · Jennings David M N9988GCessna A188A · S/N 18800788Cancelled Dec 1, 2014 · Registration expired, pending cancellation · Built 1971 · Jennings David M N8334JVarga 2150A · S/N VAC-146-79Cancelled Nov 19, 2014 · Registration expired, pending cancellation · Built 1979 · Stinard Roger D N71417Luscombe 8A · S/N 2844Cancelled Nov 13, 2014 · Registration expired, pending cancellation · Built 1946 · Burson Jesse Roger N7081XCessna 150A · S/N 15059181Cancelled Aug 21, 2013 · Sale reported, canceled · Built 1961 N2ZBWsk-Pzl-Mielec TS-11 ISKRA · S/N 1H0518Cancelled May 9, 2013 · Sale reported, canceled · Built 1970 N20747Cessna 182P · S/N 18261175Cancelled May 1, 2013 · Exported to Canada · Built 1972 · Coussan Robert N3PHBeech K35 · S/N D-5740Cancelled Feb 25, 2013 · Registration expired, pending cancellation · Built 1958 · Haskin Elmer G Jr N2526Piasecki HUP-2 · S/N 130052Cancelled Aug 21, 2012 · Sale reported, canceled N15639Piper PA-28-140 · S/N 28-7325124Cancelled Jul 9, 2012 · Sale reported, canceled · Built 1972 N49925Cessna 152 · S/N 15281398Cancelled Jun 12, 2012 · Registration pending, canceled · Built 1978 N4007CDouglas DC-3A-S1C3G · S/N 11719Cancelled Feb 14, 2011 · Exported to Mexico · Built 1943 · Hunt Theodore W N18075Hyde John B NIDNOY D VII · S/N 1916Cancelled Jan 15, 2009 · Triennial form not returned · Built 2004 · Hyde John B N3931VCessna 150M · S/N 15076656Cancelled Mar 3, 2008 · Exported to Mexico · Built 1976 · Penney David S N4349QCessna 172L · S/N 17260249Cancelled Nov 30, 2007 · Triennial form not returned · Built 1971 · Spencer Randal N91594Cessna T207A · S/N 20700706Cancelled Jan 24, 2007 · Exported to Namibia · Built 1981 · International Aircraft Services LLC N91ELLutes E I/Lutes C L KITFOX MODEL II · S/N 390Cancelled Jul 12, 2000 · Triennial form not returned · Hyde John B N5607CMooney M20J · S/N 241359Cancelled Aug 20, 1997 · Triennial form not returned · Howard Howard K N63394Cessna 150M · S/N 15077281Cancelled Aug 14, 1995 · Triennial form not returned · Alameda Aero Club N44JRPegasus Group GLASAIR SH-2 · S/N 671RCancelled Apr 3, 1995 · Second triennial mailing, no response · Pegasus Group Ltd N3KNMooney M20J · S/N 241545Cancelled Mar 11, 1994 · Exported to Greece · Tzimas George N464EDShuey Edward G GLASAIR SH-2 · S/N SN464Cancelled Feb 11, 1992 · Triennial form not returned · Farney Kent J N14MADouglas DC3C · S/N 25347Cancelled Mar 29, 1991 · Exported to France · Mod Films N54604Douglas DC3C · S/N 25571Cancelled Mar 29, 1991 · Exported to France · Mod Films N5341JCessna 340A · S/N 340A0414Cancelled Oct 23, 1984 · Exported to New Zealand · Brents International Inc N5377GCessna 207 · S/N 20700009Cancelled Jul 31, 1984 · Exported to New Zealand · Brents Intl Inc N47289Cessna 152 · S/N 152-83209Cancelled Jul 3, 1984 · Exported to New Zealand · Built 1979 · Brent'S International Inc N4977BCessna 152 · S/N 152-83735Cancelled Jul 3, 1984 · Exported to New Zealand · Brent'S International Inc N6562LCessna 152 · S/N 152-84438Cancelled Jun 22, 1984 · Exported to New Zealand · Brents International Inc N758PJCessna R172K · S/N R1723249Cancelled Jun 12, 1984 · Exported to New Zealand · Brents International Inc N7438ZPiper PA-25-235 · S/N 25-3424Cancelled May 22, 1984 · Exported to Australia · Brents International Inc N757SZCessna TR182 · S/N R18201263Cancelled Feb 27, 1984 · Exported to New Zealand · Brents Intl Inc

Back to Alameda, CA