Oroville, CA
Registered aircraft · 40
Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.
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_state = 'CA' AND g.registrant_city = 'OROVILLE' 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_state = 'CA' AND g.registrant_city = 'OROVILLE' 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.
N11RVBuboltz David C VANS RV-7A · S/N 72267N12590Beech B17L · S/N 8N15RDBeech A36 · S/N E-1407N164KDFitts Robert D SUPER 540 · S/N 001N1797NCessna 120 · S/N 12041N180JDCessna 180 · S/N 32144N1825ZCessna 210-5 · S/N 205-0025N187BCCessna 182Q · S/N 18265794N227ACBellanca 8KCAB · S/N 335-77N2841APowrachute PEGASUS 912 · S/N AZ003ULSN28482Piper PA-34-200T · S/N 34-7970211N2865FCessna 182J · S/N 18256965N3686SCessna 172E · S/N 17250886N416JSBeech 58 · S/N TH-416N4382BCessna 170B · S/N 26726N487HBAirbus Helicopters AS 350B3 · S/N 8886N488BCBell 206B · S/N 5103N505HBBell Helicopter Textron Canada 505 · S/N 65209N5139TChampion 7ECA · S/N 437N52983Cessna 182P · S/N 18262986N533MCThrush S2R-510 · S/N 510-529DCN5794TCessna 172E · S/N 17251694N606YGrumman G-164A · S/N 229N614BJGamble James H SPORTSMAN GS-2 · S/N 7147N63621Cessna 150M · S/N 15077436N6376RPiper PA-28-140 · S/N 28-21550N6578RBeech B19 · S/N MB-729N6641WBeech B36TC · S/N EA-274N7140ECessna 182B · S/N 52140N714YGrumman G-164 · S/N 276N72863Cessna 120 · S/N 10054N7641RBeech 19A · S/N MB-432N7675GCessna 150L · S/N 15074713N8133KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 579BN8214ZAllen Matthew C RV-14A · S/N 141039N88LTCessna 310Q · S/N 310Q0835N89GTBeech F33A · S/N CE-1383N9603VMooney M20C · S/N 20-0008N96041Taylorcraft BC12-D · S/N 8341N9974YChampion 7FC · S/N 7FC-461
Back to Oroville, CA