Skip to content

Cancelled registrations · 141

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

N223TUCostruzioni Aeronautiche Tecna P2006T · S/N 223/USCancelled Jan 25, 2025 · Sale reported, canceled · Built 2017 N9003MCessna 182P · S/N 18264638Cancelled Oct 25, 2024 · Exported to Guatemala · Built 1976 · Dean Bruce L N24NMSchleicher ASW-24 · S/N 24222Cancelled May 18, 2024 · Sale reported, canceled · Built 1993 N8832DPiper PA-22-160 · S/N 22-6002Cancelled Nov 18, 2023 · Revoked, canceled · Built 1958 · Pearl Richard M N5849CCessna 402C · S/N 402C0052Cancelled Sep 20, 2023 · Built 1979 · Redding Aero Enterprises Inc N94VBeech C35 · S/N D-3313Cancelled Sep 16, 2023 · Sale reported, canceled · Built 1952 N1963BLuscombe 8F · S/N 6390Cancelled Jan 14, 2023 · Sale reported, canceled · Built 1948 N1809WUptmore Tim G QUICKSILVER SPRINTII · S/N SPRINT II 262Cancelled Dec 31, 2022 · Registration expired, pending cancellation · Allen Mark C N906CWRans S-12XL · S/N 04000916Cancelled Apr 2, 2022 · Registration expired, pending cancellation · Built 2000 · Kelly Charles A N4410HMooney M20J · S/N 24-0726Cancelled Feb 15, 2022 · Registration expired, pending cancellation · Built 1978 · Hecht Stephen T N91449Piper PA-14 · S/N 14-499Cancelled Sep 4, 2021 · Registration expired, pending cancellation · Fore Kevin W N3462JCessna 150G · S/N 15066162Cancelled May 15, 2021 · Sale reported, canceled · Built 1967 N3009CBeech J35 · S/N D-5672Cancelled May 8, 2021 · Registration expired, pending cancellation · Built 1958 · Garrett Dennis M N9495TCessna 210 · S/N 57295Cancelled Apr 5, 2021 · Registration expired, pending cancellation · Built 1960 · Hudson Craig A N3506VCessna 140 · S/N 14775Cancelled Mar 20, 2021 · Registration pending, canceled · Built 1948 N24MGCessna 208B · S/N 208B0850Cancelled Jan 16, 2021 · Registration expired, pending cancellation · Built 2000 · Redding Aero Enterprises Inc N248MCBeech C90 · S/N LJ-872Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1979 · Iasco Flight Training Inc N359ESCessna 172R · S/N 17280009Cancelled Oct 3, 2020 · Registration expired, pending cancellation · Built 1997 · Iasco Flight Training Inc N4914CChocolas John CORBY STARLET · S/N 902Cancelled Apr 14, 2020 · Built 2013 · Chocolas John N488HCessna 310I · S/N 310I0117Cancelled Feb 3, 2020 · Registration expired, pending cancellation · Laskowsky Randy K N58512Fairchild M-62A · S/N FT560Cancelled Jan 24, 2020 · Revoked, canceled · Built 1943 · Boegeman John H N8496GCessna 150F · S/N 15062596Cancelled Dec 16, 2019 · Sale reported, canceled · Built 1966 N14002Piper PA-23-250 · S/N 27-4621Cancelled Dec 2, 2019 · Built 1971 · Gardinier Robert J N9541PCessna 172R · S/N 17280425Cancelled Nov 4, 2019 · Registration expired, pending cancellation · Built 1998 · Iasco Flight Training Inc N731EDDJI PHANTOM 2 VISION + · S/N PH645494785Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Downey Brian E N731GBDJI INSPIRE 1 · S/N W13DCB17020127Cancelled Sep 6, 2019 · Registration expired, pending cancellation · Downey Brian E N4117TCessna 320D · S/N 320D0017Cancelled May 6, 2019 · Registration expired, pending cancellation · Built 1965 · Laskowsky Randell K N579HVSensefly EBEE · S/N EB-03-09867Cancelled Apr 19, 2019 · Registration expired, pending cancellation · Vertical Sciences Inc N229CAGovernment Aircraft Factories CANBERRA B. MK. 20 · S/N A84-229Cancelled Jan 31, 2019 · Registration expired, pending cancellation · Built 1955 · Northern California Veterans Museum & Heritage Ctr N425QRAircover Integrated Solutions 425 QUADROTOR · S/N 425-100-1206C-100-1Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Aircover Integrated Solutions Corp N601TLBell UH-1H · S/N 68-16128Cancelled May 30, 2018 · Sale reported, canceled N36KCBellanca 14-19-3 · S/N 4304Cancelled Apr 19, 2018 · Registration expired, pending cancellation · Built 1966 · Humbert Jeff M N7610SCessna 182Q · S/N 18265258Cancelled Apr 18, 2018 · Registration expired, pending cancellation · Built 1976 · Rnc Inc N355JEurocopter/France AS355N TWINSTAR · S/N 5360Cancelled Feb 14, 2018 · Exported to United Kingdom · Built 1986 · Sierra Pacific Industries N2200CMark Allen SUPER CADET · S/N 001Cancelled Feb 12, 2018 · Registration expired, pending cancellation · Allen Mark N8397KStinson 108-1 · S/N 108-1397Cancelled Jan 26, 2018 · Registration expired, pending cancellation · Built 1946 · Premiere Aviation Inc N6126Beech 3N · S/N CA-73Cancelled Jan 25, 2018 · Registration expired, pending cancellation · Built 1952 · Kingsway Sales And Marketing LLC N95MECessna 180K · S/N 18052783Cancelled Jan 24, 2018 · Registration expired, pending cancellation · Tres Amigos Flying Club LLC N5158ZPiper PA-22-108 · S/N 22-8812Cancelled Jan 9, 2018 · Registration expired, pending cancellation · Built 1961 · Buller Wil D N2713NCessna 120 · S/N 12971Cancelled Oct 28, 2017 · Revoked, pending cancellation · Built 1947 · Hoover William N33MMMckelvey Monty STEEN SKYBOLT · S/N 500Cancelled Jul 29, 2016 · Third renewal notice · Built 1998 · Mckelvey Monty K N2542DRussell Chris QUICKSILVER MXLII SP · S/N 912Cancelled Sep 14, 2015 · Built 2007 · Burch David R N7079NRobinson Helicopter R66 · S/N 0569Cancelled Apr 24, 2015 · Exported to Nigeria · Built 2015 · Air Shasta Rotor & Wing Inc N38EZPugh Robert C LONG-EZ · S/N 927Cancelled Dec 2, 2014 · Registration expired, pending cancellation · Built 1983 · Moore Robert L N7128Jodel D-9 · S/N F-3109Cancelled Dec 2, 2014 · Revoked, canceled · Built 1967 · Harrison Bruce Charles N757TECessna 152 · S/N 15279985Cancelled Nov 18, 2014 · Registration expired, pending cancellation · Built 1977 · Enterprise Flying Club Inc N25409Cessna 152 · S/N 15280638Cancelled Sep 22, 2014 · Registration expired, pending cancellation · Built 1977 · North Star Aviation N7075VRobinson Helicopter R66 · S/N 0232Cancelled Apr 24, 2014 · Exported to Russia · Built 2012 · Air Shasta Rotor & Wing Inc N6722TCessna 310C · S/N 39022Cancelled Sep 26, 2013 · Revoked, canceled · Built 1959 · Sanders Donald D N275GWilliams Gary B · S/N 275Cancelled Sep 24, 2013 · Registration expired, pending cancellation · Williams Gary D

Back to Redding, CA