Watsonville, CA
Registered aircraft · 71
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 = 'WATSONVILLE' 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 = 'WATSONVILLE' 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.
N101RWPdps Pzl-Bielsko SZD-55-1 · S/N 551191028N10557Cessna 150L · S/N 15074909N108NBBrooks Neil T KITFOX SPEEDSTER · S/N CCS108N111VFCessna T210N · S/N 21064005N1458RGrumman American Avn. AA-1B · S/N AA1B-0558N174SMMary Mercedes Eulitt MERCEDES FLYER · S/N 001N1922GDassault FALCON 2000EX · S/N 174N20888Cessna 182P · S/N 18261287N2370BPiper PA-38-112 · S/N 38-79A0028N269SDFarrell Sean Patrick VANS AIRCRAFT RV-7A · S/N 73373N282JSCessna T182T · S/N T18208682N28329Interstate S-1A · S/N 17N290SHRobinson Helicopter R22 BETA · S/N 4186N300BKGrumman American Avn. AA-5B · S/N AA5B0335N30475Cessna 172M · S/N 17262791N307SHRobinson Helicopter R44 · S/N 30097N31461Aerotek PITTS S2S · S/N 1006N3282SCessna 182G · S/N 18255782N32874Piper PA-28-140 · S/N 28-7525125N3417BBeech D35 · S/N D-3655N37172Raytheon B300 · S/N FL-472N377CPMay Charles R SR RV7A · S/N 70377N37NADiamond Aircraft Ind DA 40 · S/N 40.568N3811EAeronca 11AC · S/N 11AC-S30Sale reported, canceledN396TACessna 172S · S/N 172S9396N39932Taylorcraft BC12-D · S/N 6585N4040Robinson Helicopter R44 · S/N 30048N4044DRobinson Helicopter R22 BETA · S/N 1619N4130NPiper PA-28-181 · S/N 2843171N4218KRobinson Helicopter R44 II · S/N 12645N422SDBell 206B · S/N 1093N442BNRobinson Helicopter R44 II · S/N 10642N4454EAntares MA-32 · S/N 4927N468EMEesley James M VANS RV-8A · S/N 81856N479SHRobinson Helicopter R22 BETA · S/N 4058N489CBCessna 525 · S/N 525-0489N49342Christen Industries PITTS S-1T · S/N 1049N49931Cessna 152 · S/N 15281402N52987Cessna 177RG · S/N 177RG1323N52TJDiamond Aircraft Ind DA 40 · S/N 40.1063N5347HCessna 172M · S/N 17265410N534VAJacob Boracca RV-12IS · S/N 121534N5473NCessna 182R · S/N 18267743N5853LAmerican AA-5 · S/N AA5-0053N595GTBorrmann Gary R SKYSTAR KITFOX 5 · S/N S94060030N6212FCessna 172N · S/N 17273167N622SARobinson Helicopter R22 BETA · S/N 3912N626BPiper PA-28-180 · S/N 28-2094N6512RLancair LC42-550FG · S/N 42014N666VMDubois Dennis E VIEWMASTER · S/N 01
Back to Watsonville, CA