Simi Valley, CA
Cancelled registrations · 114
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.
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
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.
N134AVAerovironment SHRIKE · S/N 025N532JSSiemer James H EARTHSTAR ODYSSEY · S/N 010107N5541HPiper PA-11 · S/N 11-1045N5604YFrancis Michael TIERRA · S/N 11031955N3012FArbc Inc DBA Lindstrand 105A · S/N 5441N61602Cessna 172M · S/N 17264669N38DCessna 310B · S/N 35695N140AVAerovironment PUMA · S/N 0007N143AVAerovironment PUMA · S/N 0009N147AVAerovironment PUMA · S/N 0011N162AVAerovironment RAVEN · S/N 5379N163AVAerovironment RAVEN · S/N 5380N165AVAerovironment RAVEN · S/N 5381N166AVAerovironment WASP · S/N 1047N169AVAerovironment WASP · S/N 1048N173AVAerovironment WASP · S/N 1049N9862LGrumman American Avn. AA-1B · S/N AA1B-0462N16889Bell 206B · S/N 2286N61191Cessna 150J · S/N 15070876N9836RBeech M35 · S/N D-6377N63429Cessna 150M · S/N 15077307N691SWAmerican AA-1 · S/N AA1-0131N27RGGanzer Raymond & David RUTAN VARIEZE · S/N 27N71JSSorrell JT1-M · S/N 1271N426NHWest Geoffrey R FISHER HORIZON #1 · S/N 080N597LSStimac Les M LONG EZE · S/N 51N5618DMendes Cary D SORRELL SNS-8 · S/N 32N84817Robinson Helicopter R22 ALPHA · S/N 0396N26451Schleicher ASW-20 · S/N 20486N9200ZWinslow-Stits PLAYBOY SA3A-1 · S/N WS1N5019NBoron AIR COMMAND · S/N 1N48654Aeronca 0-58B · S/N C3482TAN30HHHoops Howard M HOOPS KR2 · S/N 001N87MLMandell Lee S FALCON XP · S/N 600201N4467JPiper PA-28-140 · S/N 28-22883N19149Cessna 177B · S/N 17702560N43809Taylorcraft BC12-D · S/N 7468N6647MStinson 108-3 · S/N 108-4647N1872FCessna 210F · S/N 21058772N72086Cessna 337G · S/N 33701518N111ACNorth American NA-265-40 · S/N 282-79N52731Cessna 177RG · S/N 177RG1261N78CSSwearingen SA-226T · S/N T229N19939Cessna 177B · S/N 17702614N100PNPiper PA-31P · S/N 31P-7530023N704CFairchild SA227-AC · S/N AC-704N3585VCessna 140 · S/N 14750N418MBBurson William M MINI 500 · S/N 0279N411DPPieske JODEL F-12A · S/N 8037N477RMRichards L Roger LANCAIR IV P · S/N LIV-060
Back to Simi Valley, CA