Registered aircraft · 17

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

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 = 'ORANGE COUNTY SHERIFFS OFFICE' OR list_contains(g.other_registrant_names, 'ORANGE COUNTY SHERIFFS OFFICE') ORDER BY g.n_number

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 = 'ORANGE COUNTY SHERIFFS OFFICE' OR list_contains(g.other_registrant_names, 'ORANGE COUNTY SHERIFFS OFFICE')
  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.

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 = 'ORANGE COUNTY SHERIFFS OFFICE' OR list_contains(g.other_registrant_names, 'ORANGE COUNTY SHERIFFS OFFICE')
ORDER BY g.n_number

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.

N407KBBell 407 · S/N 53146Built 1997 · Orlando, FL N407LMBell Helicopter Textron Canada 407 · S/N 53767Built 2007 · Orlando, FL N866DMCessna T206H · S/N T20608666Built 2006 · Orlando, FL N914EMDJI INSPIRE 1 · S/N W13DEG21060983Orlando, FL N915EMDJI INSPIRE 1 · S/N W13DEG21060984Orlando, FL N918EMDJI MAVIC PRO · S/N 08QCE6F01206Z4Orlando, FL N923EMDJI MAVIC PRO · S/N 08QUE5A00102UYOrlando, FL N924EMDJI MATRICE 210 V1 · S/N 0G0DF4S0230045Orlando, FL N927EMDJI MAVIC 2 ENTERPRISE · S/N 298DFCS001P71FOrlando, FL N928EMLockheed Martin INDAGO · S/N 64Orlando, FL N930EMDJI MAVIC MINI · S/N 1SZCH4N4125RTJOrlando, FL N937EMDJI MAVIC 2 ENTERP DUAL · S/N 298CH1KR0A00SLOrlando, FL N938EMDJI MAVIC 2 ENTERPRISE · S/N 298CJ1QR0A10NEOrlando, FL N943EMDJI MAVIC MINI 2 · S/N 3Q4SJ170034RWTOrlando, FL N945EMDJI MAVIC MINI 2 · S/N 3Q4SJ1E00357LXOrlando, FL N946EMDJI MAVIC MINI 2 · S/N 3Q4SJ1F00359JQOrlando, FL N947EMDJI MAVIC MINI 2 · S/N 3Q4SJ1F00359ZBOrlando, FL

Back to Orange County Sheriffs Office