OpenAirDocs.org
Downey, CA

Cancelled registrations · 60

Query with SQL
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 = 'DOWNEY'
  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.

N122CAEmbraer ERJ 190-100 ECJ · S/N 19000695Cancelled Apr 9, 2025 · Exported to San Marino · 4144 Mdr LLCN27SLGrumman G-1159 · S/N 84Cancelled Apr 1, 2023 · Registration expired, pending cancellation · Built 1970 · Onpoint Avionics LLCN325CCPiper PA-31-325 · S/N 317612057Cancelled Mar 4, 2023 · Registration expired, pending cancellation · Built 1976 · Onpoint Avionics LLCN92VCRockwell International NA-265-65 · S/N 465-61Cancelled Apr 4, 2022 · Exported to Guatemala · Built 1981 · Pacific Rim Management LLCN42FLGulfstream Aerospace G-1159A · S/N 416Cancelled Dec 30, 2021 · Exported to Aruba · Built 1984 · Global Avionics LLCN213JAGrumman G-1159 · S/N 196Cancelled Oct 22, 2020 · Exported to Mexico · Global Avionics LLCN375TCRaytheon Corporate Jets BAE 125-800A · S/N 258252Cancelled Sep 25, 2020 · Exported to Mexico · Onpoint Avionics LLCN833MMBritish Aerospace BAE 125 SERIES 800A · S/N NA0420Cancelled Aug 31, 2020 · Exported to Mexico · Onpoint Avionics LLCN700NWBritish Aerospace HS 125-700A · S/N NA0246Cancelled Apr 23, 2020 · Exported to Mexico · Onpoint Avionics LLCN805Huntley JUNGSTER 2 · S/N 100JHCancelled Nov 6, 2018 · Revoked, canceled · Built 1979 · Huntley Jerry BN95092Taylorcraft BF · S/N 9492Cancelled Jul 19, 2018 · Revoked, canceled · Built 1946 · Gerdes Lyle AN11858Bellanca 7KCAB · S/N 296-72Cancelled Sep 20, 2017 · Registration expired, pending cancellation · Built 1972 · Landers William LN169CWRobinson Helicopter R22 BETA · S/N 3002Cancelled Aug 7, 2017 · Sale reported, pending cancellation · Built 1999N77TLockheed 18-56 · S/N 2480Cancelled Feb 4, 2017 · Revoked, canceled · Built 1943 · Gusman ThomasN1422PPiper PA-23 · S/N 23-477Cancelled May 6, 2015 · Registration expired, pending cancellation · Built 1956 · Schaus Lance RN924KKKhosroabadi Khosro TEMAN MONOFLY · S/N 9241952Cancelled Dec 18, 2014 · Registration expired, pending cancellation · Khosroabadi KhosroN759UPCessna 182Q · S/N 18266272Cancelled Jan 8, 2014 · First renewal notice · Built 1978 · Smoke Eagles IncN5813CBeech C35 · S/N D-2765Cancelled Jun 27, 2013 · Registration expired, pending cancellation · Built 1951 · Starlight Construction IncN4950PPiper PA-23-235 · S/N 27-546Cancelled May 9, 2013 · Sale reported, canceled · Built 1963N2570VPiper PA-38-112 · S/N 38-82A0075Cancelled Apr 15, 2013 · Registration expired, pending cancellation · Built 1982 · Keenan MichaelN5880PPiper PA-24-250 · S/N 24-965Cancelled Feb 21, 2013 · Revoked, canceled · Built 1959 · Cook A LymanN597ACPiper PA-31-310 · S/N 31-7612022Cancelled Dec 21, 2012 · Exported to El Salvador · Built 1975 · Jewels By Angelo IncN28504Fairchild 24W-41A · S/N W40-124Cancelled Jan 11, 2012 · Sale reported, pending cancellation · Built 1940N4753KCessna P210N · S/N P21000284Cancelled Nov 20, 2009 · Triennial form not returned · Built 1979 · Dickson Steven LN6741ZPiper PA-25-235 · S/N 25-2355Cancelled Nov 16, 2004 · Exported to Mexico · Built 1963N4646WRockwell International 112TCA · S/N 13176Cancelled Oct 5, 2001 · Exported to Mexico · Fisch GregoryN5482NCessna T182 · S/N 18267751Cancelled May 13, 1998 · Triennial form not returned · American Community Dev Financial IncN999LMMooney M20E · S/N 1148Cancelled Dec 11, 1991 · Triennial form not returned · Mitchell John EN570QBell 47G3B2A · S/N 6838Cancelled Aug 15, 1991 · Exported to Mexico · Adams Richard CN1399HBeech 1900C · S/N 28-7725143Cancelled Sep 16, 1985 · Administratively canceled · Monjar JaneN7187PPiper PA-24-250 · S/N 24-2357Cancelled Jun 21, 1984 · Bruce John AN60193Cessna 150J · S/N 15070138Cancelled May 11, 1982 · Exported to Mexico · Laughlin William LN99755Ercoupe 415-C · S/N 2378Cancelled Jan 21, 1982 · Administratively canceled · Baker Robert JN2119EAeronca 7AC · S/N 7AC-1507Cancelled Jan 19, 1978 · William C Deschamp & Donald R DeschampN3259WPiper PA-32-260 · S/N 32-82Cancelled Dec 1, 1975 · De Maria DorothyN6114ECN Bensen Hydrocopter B-8MW · S/N 1004Cancelled Jan 24, 1972 · Nielesky Edward CN9068TCessna 182C · S/N 52968Cancelled Nov 26, 1971 · Exported to Canada · Salvage Aradean D Or Virgil SalvageN42408Piper J3C-65 · S/N 14668Cancelled Nov 17, 1971 · Built 1945 · Sullivan Robert JrN3644GCutler GD-2 · S/N GD-1Cancelled Sep 27, 1971 · Cutler Helicopter CorpN5341BCessna 182 · S/N 33341Cancelled Mar 19, 1971 · Built 1956 · Thomas Charles AN76659Cessna 140 · S/N 11099Cancelled Jun 26, 1968 · Moore William LN32781Piper J4A · S/N 4-1311Cancelled May 22, 1965 · Clovis J Atkinson And Armetta E ArkinsonN6994CSikorsky S-52-2 · S/N 52009Cancelled Oct 12, 1959 · Exported to Canada · Glick Mario RN6995CSikorsky S-52-2 · S/N 52032Cancelled Feb 27, 1959 · Exported to Canada · Glick Mario RN5604HPiper PA-16 · S/N 16-211Cancelled Jun 10, 1957 · Elliott JeanN67194Cessna T-50 · S/N 4695Cancelled Mar 22, 1956 · Davis LeeN63432Fairchild AT-21 · S/N 2Cancelled Nov 14, 1955 · Reavis C GN68176Cessna T-50 · S/N 2430Cancelled Oct 25, 1955 · Maas Fred HN29214Aeronca 65-TC · S/N C2660TCancelled Aug 8, 1951 · Built 1940 · Rouse Jack & Bieker Donald LN33267Piper J5A · S/N 5-468Cancelled Nov 10, 1948 · Exported to Mexico · Maas Fred H
Back to Downey, CA