OpenAirDocs.org
California Highway Patrol

Registered aircraft · 24

Registered to this exact name, as owner or co-owner. Owners who share a name are listed together; other spellings aren’t included.

Query with SQL
duckdb -csv -c "SELECT g.n_number, g.serial_number, g.year_manufactured, m.manufacturer, m.model, g.status, g.registrant_name, g.registrant_city, g.registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' g LEFT JOIN 'https://openairdocs.org/data/latest/faa_aircraft_model.parquet' m ON m.code = g.aircraft_model_code
  WHERE g.registrant_name = 'CALIFORNIA HIGHWAY PATROL' OR list_contains(g.other_registrant_names, 'CALIFORNIA HIGHWAY PATROL')
  ORDER BY g.n_number"

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.

N137HPGippsaero PTY GA8 TC-320 · S/N GA8-TC 320-15-218Built 2015 · Sacramento, CAN139HPGippsaero PTY GA8 TC-320 · S/N GA8-TC-320-15-224Built 2015 · Sacramento, CAN140HPGippsaero PTY GA8 TC-320 · S/N GA8-TC-320-13-198Built 2013 · Sacramento, CAN153HPGippsaero PTY GA8 TC-320 · S/N GA8-TC-320-16-232Built 2016 · Sacramento, CAN156HPGippsaero PTY GA8 TC-320 · S/N GA8-TC-320-16-234Built 2016 · Sacramento, CAN159HPGippsaero PTY GA8 TC-320 · S/N GA8-TC-320-18-246Built 2018 · Sacramento, CAN202HPTextron 208B · S/N 208B5682Built 2022 · Sacramento, CAN247HPTextron 208 · S/N 20800720Built 2025 · Sacramento, CAN263HPTextron 208 · S/N 20800719Built 2025 · Mcclellan, CAN273HPTextron 208 · S/N 20800721Built 2025 · Sacramento, CAN553HPCessna T206H · S/N T20608633Built 2006 · Sacramento, CAN911CARaytheon B300 · S/N FL-462Built 2005 · Sacramento, CAN918CABeech A200 · S/N BC-57Built 1978 · Sacramento, CAN974HPAirbus Helicopters AS350B3 · S/N 7871Built 2014 · Sacramento, CAN975HPAirbus Helicopters AS350B3 · S/N 7873Built 2014 · Sacramento, CAN976HPAirbus Helicopters AS350B3 · S/N 7881Built 2014 · Sacramento, CAN978HPAirbus Helicopters AS350B3 · S/N 7915Built 2014 · Sacramento, CAN981HPAirbus Helicopters AS350B3 · S/N 8169Built 2016 · Sacramento, CAN982HPAirbus Helicopters AS350B3 · S/N 8187Built 2016 · Sacramento, CAN983HPAirbus Helicopters AS350B3 · S/N 8190Built 2016 · Sacramento, CAN984HPAirbus Helicopters AS 350B3 · S/N 8653Built 2019 · Sacramento, CAN985HPAirbus Helicopters AS 350B3 · S/N 8666Built 2019 · Sacramento, CAN986HPAirbus Helicopters AS350B3 · S/N 9394Built 2023 · Sacramento, CAN988HPAirbus Helicopters AS350B3 · S/N 8927Built 2021 · Sacramento, CA
Back to California Highway Patrol