Visalia, CA
Cancelled registrations · 116
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 = 'VISALIA' 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 = 'VISALIA' 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.
N146UPiper PA-24-250 · S/N 24-2648N1843EAeronca 7AC · S/N 7AC-5410N9976Semco Balloon T · S/N SEM87N2852DBoeing A75N1(PT17) · S/N 75-004N51XBBower Rod XB51 · S/N 80769N1777SAero Commander 600 S-2D · S/N 600-1377DN7063MMcentire James R RANS S-9 · S/N 0888058N7291YPiper PA-30 · S/N 30-329N249RSBurns Gary A RV-8 · S/N 80926N10531Cessna 150L · S/N 15074904N8472FPiper PA-28-181 · S/N 28-7790246N43132Taylorcraft BC12-D · S/N 6791N729BBStamm William J RUTAN VARIEZE · S/N 164N225Harwell Roy M III V-20 · S/N 20N9683GCessna TU206F · S/N U20601883N8276MCessna 210K · S/N 21059276N600EMMcnamee W A / Mcnamee E G SPEEDWING · S/N 600N30438Cessna 177A · S/N 17701254N595BBeech A35 · S/N D1616N8874QAero Commander S2R · S/N 1474RN3087DAyres S-2R · S/N R1820027DCN9520LGrumman American Avn. AA-5 · S/N AA50520N8924Edmiston SCORPION ONE · S/N PL02N3416GBensen B-8M · S/N PL01N3214VCessna 150M · S/N 15076423N2440FRussell Morris H KR-1 · S/N MR3479N5022CBeech B35 · S/N D2284N3225ZNoell-Oros ROTEC RALLY 3 · S/N 64646N52338Cessna 182P · S/N 18262539N6143XAero Commander 500-A · S/N 500A-931-26N23501Cessna 150H · S/N 15068993N4815RCessna A188B · S/N 18802335TN7705TCessna 172A · S/N 47305N202QAero Commander 500 · S/N 793N54865Consolidated Vultee BT-13A · S/N 1414N4712JBeech A23-19 · S/N MB-170N56419Boeing A75 · S/N 35-215N7945FCessna 150F · S/N 15064045N2818MBeech 95-B55 (T42A) · S/N TC-867N56488Consolidated Vultee BT-13A · S/N 5325N9395MMooney M20F · S/N 670019N6986PPiper PA-24-250 · S/N 24-2129N7766ACessna 180A · S/N 32663N5062NCessna T-50 · S/N 4124N6963PPiper PA-24-250 · S/N 24-2103N3001HErcoupe 415-C · S/N 3626N9720RBeech M35 · S/N D-6383N3437VCessna 190 · S/N 7142N68449Consolidated Vultee BT-13A · S/N 6597N1364NNorth American AT-6C · S/N 26977
Back to Visalia, CA