Riverside, CA
Registered aircraft · 211
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.
N10251Flagg Larry D LARRYS MIXTURE · S/N 1N103NADouglas C-47B · S/N 33569N112MSheehan Michael F SPECIAL · S/N 5N112WKKontara TBV-1 · S/N 001N113MVSocata TB21 · S/N 2193N11430Cessna 150L · S/N 15075414N1151VMooney M20J · S/N 24-1231N11GMBeech V35B · S/N D-10298N12239Cessna 172M · S/N 17261900N123CTBeech V35 · S/N D-8590N1354TPiper PA-28R-200 · S/N 28R-7235268N13BTConsolidated Vultee BT-15 · S/N 11453N1408CCessna 177B · S/N 17702723N1414FCessna 172H · S/N 17254909N144PDRobinson Helicopter R44 II · S/N 10033N146SDDelatorre Samuel VANS RV-7A · S/N 70745N15022Piper PA-28R-200 · S/N 28R-7335001Registration pendingN151TAWilliams John T-51 MUSTANG · S/N M04SV6SOHK0027Sale reportedN1535WBeech F33A · S/N CE-374N15BMCirrus Design SR22 · S/N 3300N188RJBeech P35 · S/N D-7205N19312Cessna 150L · S/N 15074329N1985Sheehan Michael F SPECIAL · S/N 2N19KDAero Commander 520 · S/N 520-29N19SCCessna T182T · S/N T18208101N207CBPiper PA-28-181 · S/N 2881001N20GKSocata TB-20 TRINIDAD · S/N 646N20WECessna 441 · S/N 441-0160N213MBCessna 177B · S/N 17702282N2183PCessna T182T · S/N T18208470N22151Cessna 150H · S/N 15068099N225CBPiper PA-28-181 · S/N 2881634N22SRPiper PA-28RT-201T · S/N 28R-7931106N2328CPiper PA-38-112 · S/N 38-79A0154N2446YCessna 172D · S/N 17249746N246CBPiper PA-28-181 · S/N 2881002N2472YBeech A36 · S/N E-254N2489LCessna 172H · S/N 17255689N248CBPiper PA-28-181 · S/N 2881003N249CBPiper PA-28-181 · S/N 2881636N2545YCessna 172F · S/N 17252552N254TDDJI AGRAS T30 · S/N 527BK4N001002JN256JSMiller Gregory J RV-7A · S/N 70274N259CBPiper PA-28-181 · S/N 2881004N262CBPiper PA-28-181 · S/N 2881005N2641LCessna 172H · S/N 17255841N26EAThweatt Andrew C MURPHY ELITE · S/N 716EN272CBPiper PA-28-181 · S/N 2881006N2736WMooney M20E · S/N 1036N275CBPiper PA-28-181 · S/N 2881916
Back to Riverside, CA