Walnut Creek, CA
Registered aircraft · 95
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 = 'WALNUT CREEK' 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 = 'WALNUT CREEK' 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.
N111XWExtra Flugzeugbau EA-300 · S/N 064N1407UCessna 172M · S/N 17267077N151BWNorth American/Aero Classics P-51D · S/N 44-74813N155DGCessna T210N · S/N 21064815N156PCPilatus PC-6/B2-H2 · S/N 777N159LGRob Holmes VANS RV-7 · S/N 75017N166BJSanches William A RV-10 · S/N 40608N171KKParker Judson B SERIES 5 · S/N S9506-0130First renewal noticeN20506Mooney M20M · S/N 27-0238N20BGGlodfelty W L CHRISTEN EAGLE II · S/N GLODFELTY 001N21348Cessna 182P · S/N 18261578N21SAMalecha A C VANS RV-7A · S/N 70739N23135Piper J-3 · S/N 2918N232DEApex CAP 232 · S/N 39N235TBPaul R Scott ZENITH CH 750 · S/N 75-10347N240HCBeech 58P · S/N TJ-221N2500KLuscombe 8E · S/N 5227N2501CCessna 170B · S/N 26145First renewal noticeN2581VCessna 177RG · S/N 177RG0625N2657YCessna 180E · S/N 18051157N2759KLuscombe 8E · S/N 5486N2938UPiper PA-28-181 · S/N 28-7990574N29488Cessna 177 · S/N 17700921N301DEExtra Flugzeugbau EA 300/L · S/N 041N3100DCessna 180 · S/N 31898N32386Piper PA-28-140 · S/N 28-7525058N331JTCessna A185E · S/N 18501899N3455WPiper PA-32-260 · S/N 32-324N36XCCessna 182Q · S/N 18267223N375BFAviat S-2C · S/N 6071N3779NMooney M20F · S/N 680116N3781VCessna 140A · S/N 15202N39007Grumman American Avn. AA-1C · S/N AA1C0181N398CCCubcrafters CC11-160 · S/N CC11-00398N3SZHearne Roy A GLASAIR III · S/N 1N4087RPiper PA-32-300 · S/N 32-40405N417CCessna 525C · S/N 525C0021N422ESSimmons Gary F STOL CH 701 · S/N 7200N427CTFlight Design CTSW · S/N 07-03-10N43070Piper PA-32-300 · S/N 32-7440115N4568NCessna 340A · S/N 340A0549N45EACirrus Design SR20 · S/N 11097N4651SBeech A36 · S/N E-766N48525Piper J3C-65 · S/N 9441N4881SPiper PA-32-260 · S/N 32-7100005N491ACCessna T210N · S/N 21063673N5009KNanchang China CJ-6A · S/N 4132021N51PTNorth American F-51D · S/N 44-72145N5223ACessna T210N · S/N 21063316N526STColumbia Aircraft Mfg LC41-550FG · S/N 41726
Back to Walnut Creek, CA