OpenAirDocs.org
Simi Valley, CA

Cancelled registrations · 113

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 = 'SIMI VALLEY'
  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.

N3134HErcoupe 415-C · S/N 3759Cancelled Dec 19, 2023 · Revoked, canceled · Built 1946 · Welton Richard EN9340HCessna 172M · S/N 17266098Cancelled May 13, 2023 · Revoked, canceled · Built 1975 · Williamson John EN7917GCessna 172L · S/N 17259617Cancelled Apr 25, 2023 · Built 1970 · Delahunt Steven DN29PTLehmann Thomas R KINA BUG 1 · S/N 001Cancelled Jul 31, 2021 · Registration expired, pending cancellation · Built 2005 · Lehmann Thomas RN806AVAerovironment PUMA AE · S/N 502Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Aerovironment IncN808AVAerovironment PUMA AE · S/N 504Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Aerovironment IncN809AVAerovironment PUMA AE · S/N 506Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Aerovironment IncN811AVAerovironment PUMA AE · S/N 838Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Aerovironment IncN813AVAerovironment PUMA AE · S/N 840Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Aerovironment IncN814AVAerovironment PUMA AE · S/N 844Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Aerovironment IncN816AVAerovironment PUMA AE · S/N 847Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Aerovironment IncN817AVAerovironment PUMA AE · S/N 848Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Aerovironment IncN819AVAerovironment PUMA AE · S/N 849Cancelled Mar 6, 2021 · Registration expired, pending cancellation · Aerovironment IncN805CADJI PHANTOM 4 PRO · S/N 0AXCE4S0B30719Cancelled Jan 30, 2021 · Registration expired, pending cancellation · Olivares Diego SN51161Veronica James A SPITFIRE · S/N 001ACancelled Jan 6, 2021 · Registration expired, pending cancellation · Built 1980 · Veronica James LN195ECessna 195 · S/N 7392Cancelled Dec 5, 2020 · Registration expired, pending cancellation · Swanson Duane RN205AVAerovironment PUMA AE · S/N 835Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 2010 · Aerovironment IncN207AVAerovironment PUMA AE · S/N 836Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 2010 · Aerovironment IncN209AVAerovironment PUMA AE · S/N 837Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Built 2010 · Aerovironment IncN2918AUltralight America SPITFIRE II · S/N 19661978Cancelled Aug 2, 2020 · Registration expired, pending cancellation · Lawrence Steven RN26034Burton George M GMB 1 · S/N 001Cancelled Jul 10, 2020 · Registration expired, pending cancellation · Built 1998 · Lawrence Steven RN848JWMooney M20F · S/N 680121Cancelled Oct 5, 2019 · Registration expired, pending cancellation · Built 1967 · Turford David JamesN307DCRobinson Helicopter R44 II · S/N 11181Cancelled Jul 17, 2019 · Exported to Canada · Built 2006 · Rs Aviation ServicesN179AVAerovironment QUBE · S/N 30009Cancelled May 4, 2019 · Registration expired, pending cancellation · Aerovironment IncN156AVAerovironment SHRIKE · S/N 044Cancelled Apr 12, 2019 · Registration expired, pending cancellation · Aerovironment IncN7788CAeronca 7DC · S/N 7AC-5928Cancelled Feb 5, 2019 · Registration expired, pending cancellation · Built 1946 · Albee Robert EN157AVAerovironment SHRIKE · S/N 045Cancelled Jan 30, 2019 · Registration expired, pending cancellation · Aerovironment IncN150AVAerovironment SHRIKE · S/N 043Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Aerovironment IncN189AVAerovironment PUMA AE · S/N 719Cancelled Jan 14, 2019 · Registration expired, pending cancellation · Aerovironment IncN159AVAerovironment QUBE · S/N 30001Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Aerovironment IncN160AVAerovironment QUBE · S/N 30004Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Aerovironment IncN161AVAerovironment QUBE · S/N 30005Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Aerovironment IncN186AVAerovironment QUBE · S/N 30011Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Aerovironment IncN193AVAerovironment PUMA AE · S/N 720Cancelled Dec 15, 2018 · Registration expired, pending cancellation · Aerovironment IncN187AVAerovironment QUBE · S/N 30013Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Aerovironment IncN188AVAerovironment QUBE · S/N 30028Cancelled Oct 23, 2018 · Registration expired, pending cancellation · Aerovironment IncN109AVAerovironment SHRIKE · S/N 032Cancelled Oct 22, 2018 · Registration expired, pending cancellation · Aeroviroment IncN125AVAerovironment SHRIKE · S/N 012Cancelled Oct 22, 2018 · Registration expired, pending cancellation · Aerovironment IncN137AVAerovironment SHRIKE · S/N 035Cancelled Oct 22, 2018 · Registration expired, pending cancellation · Aerovironment IncN145AVAerovironment SHRIKE · S/N 037Cancelled Oct 22, 2018 · Registration expired, pending cancellation · Aerovironment IncN148AVAerovironment SHRIKE · S/N 041Cancelled Oct 22, 2018 · Registration expired, pending cancellation · Aerovironment IncN142AVAerovironment SHRIKE · S/N 036Cancelled Sep 13, 2018 · Registration expired, pending cancellation · Aerovironment IncN158AVAerovironment SHRIKE · S/N 046Cancelled Aug 6, 2018 · Registration expired, pending cancellation · Aerovironment IncN124AVAerovironment SHRIKE · S/N 030Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Aerovironment IncN135AVAerovironment SHRIKE · S/N 031Cancelled Jul 12, 2018 · Registration expired, pending cancellation · Aerovironment IncN205GFAerovironment QUBE · S/N 30003Cancelled Jun 8, 2018 · Registration expired, pending cancellation · Aerovironment IncN126AVAerovironment SHRIKE · S/N 015Cancelled May 3, 2018 · Registration expired, pending cancellation · Aerovironment IncN131AVAerovironment SHRIKE · S/N 022Cancelled May 3, 2018 · Registration expired, pending cancellation · Aerovironment IncN133AVAerovironment SHRIKE · S/N 023Cancelled May 3, 2018 · Registration expired, pending cancellation · Aerovironment IncN134AVAerovironment SHRIKE · S/N 025Cancelled May 3, 2018 · Registration expired, pending cancellation · Aerovironment Inc
Back to Simi Valley, CA