Riverside, CA
Registered aircraft · 213
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 = 'RIVERSIDE' 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 = 'RIVERSIDE' 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.
N2804SCessna 150G · S/N 15066704N2876GChampion 7ECA · S/N 522-68N2884TPiper PA-28-140 · S/N 28-7225266N288CBPiper PA-28-181 · S/N 2881635N290VGPiper PA-23 · S/N 23-5N29151Cessna TU206C · S/N U206-1121N291CBPiper PA-28-181 · S/N 2881007N296CBPiper PA-28-181 · S/N 2881008N297CBPiper PA-28-181 · S/N 2881917N3045YRaytheon B36TC · S/N EA-623N3068GBell 47J-2 · S/N 2856N310FPCessna 310K · S/N 310K0027N3147VBeech 35 · S/N D-577N3195RCessna 182L · S/N 18258595N321DGCessna 210K · S/N 21059201N3269KGlobe GC-1B · S/N 1262N3308VBeech 35 · S/N D-767N3423SCessna 182G · S/N 18255823N34643Stinson 10A · S/N 7964N3515SCessna 172E · S/N 17250715N3589WPiper PA-32-260 · S/N 32-484N3611MPiper PA-12 · S/N 12-2543N373CBPiper PA-28R-201 · S/N 2844174N374CBPiper PA-28R-201 · S/N 2844175N3795LCessna 172G · S/N 17253964N3811TPiper PA-28R-180 · S/N 28R-30126N3848TPiper PA-28R-180 · S/N 28R-30169N3881SCessna 172E · S/N 17251081N3903Sheehan Michael F SPECIAL · S/N 3N398JFMooney M20K · S/N 25 0398N3QABeech B36TC · S/N EA-427N4055Mooney M-18LA · S/N 113N408ABCessna LC41-550FG · S/N 411090N4105EAeronca 11CC · S/N 11CC14N415MSPiper PA-28-161 · S/N 28-7816430N418BBeech 35R · S/N D-1424R8N42477Piper PA-28-151 · S/N 28-7415392N42852Cessna 182L · S/N 18259215N438CBPiper PA-44-180 · S/N 4496404N440HPJeffrey E Mcnamara MAMMOTH · S/N 0001N4415RCessna 172M · S/N 17263163N44346Taylorcraft BC12-D · S/N 10146N44848Naval Aircraft Factory N3N-3 · S/N 4477N4543CCessna 170B · S/N 25487N46130Cessna 172I · S/N 17257061N46307Cessna 172K · S/N 17257174N46CBPiper PA-32R-300 · S/N 32R-7780481N47930Cessna 152 · S/N 15283263N486CBPiper PA-44-180 · S/N 4496417N4962FCessna U206B · S/N U206-0662
Back to Riverside, CA