Brentwood, CA
Registered aircraft · 36
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 = 'BRENTWOOD' 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 = 'BRENTWOOD' 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.
N123MEMatthew Ellison SPORTSMAN GS-2 · S/N 7495N1831RCessna A185F · S/N 18502546N2068ABell 206B · S/N 3400N206PLBell 206B · S/N 3902N2605TMoyes Bailey DRAGONFLY · S/N 2006-096N2970CCessna 180 · S/N 30870N32151Piper PA-28-180 · S/N 28-7505030N3633TSchweizer G-164B · S/N 779BN38793Piper PA-28R-201T · S/N 28R-7703278N4161NCessna 120 · S/N 13632N4579JJohnson John C GLASTAR · S/N 5819N46FCCopeland Forrest H RV6 · S/N 60075N4798CCessna 414 · S/N 414-0012N48492Grumman Acft ENG Cor-Schweizer G-164B · S/N 47BN5334BCessna 182 · S/N 33334N56431Boeing D75N1 · S/N 75-3838N614AAtack David F SPORTSMAN KIT · S/N 7076N6278ACessna T182T · S/N T18208864N6613KGrumman Acft ENG Cor-Schweizer G-164B · S/N 390BN6745KGrumman Acft ENG Cor-Schweizer G-164B · S/N 446BN6864MCessna 182P · S/N 18263868N7208NNunn BTR EPIC LT · S/N 202N74AJBell 206B · S/N 2751N8087PPiper PA-24-180 · S/N 24-3335N810VPDJI INSPIRE 1 · S/N W13DCC30030268N811CXCessna 150J · S/N 15070360Registration pending, pending cancellationN8157WPiper PA-28-180 · S/N 28-2273N8231KGulfstream-Schweizer A/C GULFSTREAM AM G-164B · S/N 623-BN825JHCirrus Design SR22T · S/N 2341N825MSMehrdad Mehranpour RV-14A · S/N 140423N841SJJay Silva BIRDMAN 1 · S/N 13018N8681ABeech A35 · S/N D-2091N8945RChampion AERONCA 7GC · S/N 162N9111QBeech F33A · S/N CE-330N9657YBeech P35 · S/N D-7072N98TMKeithley Richard S RV-8 · S/N 80894
Back to Brentwood, CA