Sunnyvale, CA
Cancelled registrations · 97
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 = 'SUNNYVALE' 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 = 'SUNNYVALE' 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.
N9288XPiper PA-32R-301T · S/N 3257027N4390DPiper PA-28-161 · S/N 28-8516028N107BCPZL MI-2 · S/N 5310928069N581ARBereznak Bradley J LANCAIR 360 · S/N BJB-1N8481ECessna 172N · S/N 17272211N6183QCessna 320F · S/N 320F-0033N28299Grumman American Avn. AA-5B · S/N AA5B0537N4329KPeterson Charles Eugene REVLTN MINI-500 BRVO · S/N 0421N8343DBeech J35 · S/N D-5431N5082WPiper PA-28 · S/N 2891N69SWWorthington Sean T BD-5B · S/N 001N28117Raven S-60A · S/N S60A415N63CMCalifornia Microwave CM-44B · S/N 003N112CMCalifornia Microwave CM-44B · S/N 002N827MCBeech F33A · S/N CE1230N72AUHunter Neil LONG-EZ · S/N 317N3226VBeech 35 · S/N D-669N67145Piper PA-28-180 · S/N 28-3525N528QBeech E33A · S/N CE191N94322Cessna 182Q · S/N 18266408N757BDCessna 152 · S/N 15279602N5611GCessna 150J · S/N 15071111N5650O R Craig B-8M · S/N 1N733HGCessna 172N · S/N 172-68302N95887Taylorcraft BC12-D · S/N 8187N5394Sircco MJ55F2 · S/N 158N710BBeech A35 · S/N D-1715N5519RCessna 172F · S/N 17253095N4612RPiper PA-28-140 · S/N 28-21361N5250XChampion 7KCAB · S/N 224N6371FCessna 337A · S/N 337-0371N8680NPiper PA-32-300 · S/N 32-7240024N4717VBellanca 17-30 · S/N 30058N3879Bensen B-8-KC · S/N 10345N3427RPiper PA-28-180 · S/N 28-5677N10364Schweizer SGS 1-23H-15 · S/N 47N2875CCessna 170B · S/N 26418N2800GNorth American T-28A · S/N 49-1628N55FBeech 35 · S/N D-254N5937TCessna 150D · S/N 15060637N5385LPiper PA-28-180 · S/N 28-4692N1608LLockheed Aircraft Intl 402-2 · S/N 1025N4919Homebuilt MINIPLANE · S/N VTOL-1N68274Schweizer TG3A · S/N 103N37052Luscombe 8C · S/N 1713N97309Stinson 108 · S/N 108-309N6162LAmerican AA-1 · S/N AA1-0362
Back to Sunnyvale, CA