San Jose, CA
Cancelled registrations · 699
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 = 'SAN JOSE' 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 = 'SAN JOSE' 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.
N45182Cessna 150M · S/N 15076773N359SZAllstar PZL Glider SZD 59 · S/N 590.A.09.011N336TCBeech A36TC · S/N EA136N221CJSikorsky S-76C · S/N 760659N222CJKeystone Helicopter S-76C · S/N 760779N31036Catto ICARUS II · S/N CA001N590ALCessna TU206G · S/N U20606049N2211HEngineering & Research ERCOUPE 415-C · S/N 2834N32PGPiper PA-32-300 · S/N 32-7340165N28TCCessna TU206G · S/N U20604780N857ALCessna U206G · S/N U20605444N887ALCessna TU206G · S/N U20605416N20HDBarnett Harvey D MA-5 CHARGER · S/N 0103N408PDAirbus Helicopters AS350B3 · S/N 8459N1201UCessna 172M · S/N 17266901N34974Cessna 177B · S/N 17702126N5566CIcam Copters GT80X · S/N 4N568LCIcam Copters GT80X · S/N 2N568NCIcam Copters GT80X · S/N 3N571GCIcam Copters GT80X · S/N 6N97252Stinson 108 · S/N 108-252N380SPCessna 172S · S/N 172S8774N562QCIcam Copters GT80X · S/N 1N567FCIcam Copters GT80X · S/N 5N78119Universal GLOBE GC-1B · S/N 2119N2791EAeronca 7AC · S/N 7AC-6374N43YRAirborne EDGE X CLASSIC · S/N 582-705N9166XCessna 182D · S/N 18253566N770WPiper PA-32R-301T · S/N 3257267N575ALHonda HA-420 · S/N 42000151N814SXHonda HA-420 · S/N 42000062N462ALNihon YS-11A · S/N 2084N714HFCessna 150M · S/N 15079183N923LAEvektor-Aerotechnik SPORTSTAR PLUS · S/N 20070923N719ZVucinic Dejan CH 601 HDS · S/N 4018N575DMHonda HA-420 · S/N 42000031N33EDRolladen-Schneider OHG LS3-A · S/N 3351N700HDSocata TBM 700 · S/N 313N666HPPiper PA-28RT-201T · S/N 28R-8031065N781TMSocata TBM 700 · S/N 5N1514RBalloon Works FIREFLY 8B-15 · S/N F8B-610N21THSchempp-Hirth DISCUS-2B · S/N 91N64DNBellanca 17-31ATC · S/N 73-31064N566KKBeech D95A · S/N TD-673N68258Piper J3C-65 · S/N 8213N44YSGulfstream Aerospace G1159B · S/N 098N66754Convair BT-13A · S/N 1969N824LBCessna 172S · S/N 172S9824N4560DBeech G35 · S/N D-4691N4593JPiper PA-28R-180 · S/N 28R-30469
Back to San Jose, CA