Los Gatos, CA
Registered aircraft · 67
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 = 'LOS GATOS' 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 = 'LOS GATOS' 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.
N10048Mooney M20R · S/N 29-0282N112WRED Bullock JR AVENTURA HP · S/N AAHP0019N117MNNashner Michael S RV-14 · S/N 140579N128MRRaf Holdings RV-8 · S/N 001N12GJBeech E-90 · S/N LW-12N1414ALamar Philip D VANS RV-14A · S/N 140387N1758TPiper PA-28-140 · S/N 28-7125076N20ACBeech V35B · S/N D9371N221VJFrank Ducker VJ-22 · S/N 0341N22MJPiper PA-28-236 · S/N 28-7911334N2324NCessna 120 · S/N 12564N2874ECessna T210M · S/N 21062773N291DRRigotti David A RANS S-6S · S/N 08121962N293DBDaniel R Benua VANS RV-3B · S/N 11426N2994ACessna 180 · S/N 30194N3018ZPiper PA-28-161 · S/N 28-7916398N3035UCessna 172E · S/N 17250635N311JSCirrus Design SR20 · S/N 9339N314EVM&D Flugzeugbau JS-MD 3 RES · S/N 3.MD206N320TSCirrus Design SR22 · S/N 0771N322LLEmbraer S A EMB-505 · S/N 50500117N324EBeech E35 · S/N D-3908N3293FMooney M-20G · S/N 680001N32BJSexton Robert B KITFOX · S/N 3N349DNNorman Dave SPORT 1000 · S/N 001N349WCubcrafters CC11-160 · S/N CC11-00328N356AWJohn Topliff PA18-200EXP · S/N PA-18-200-1-JTN3799QBeech V35 · S/N D-8433N3954ABeech F33A · S/N CE-308N414KFCessna 180K · S/N 180-53147N422WACirrus Design SR22T · S/N 1929N42EWPhoenix Air Sro U-15 PHOENIX · S/N 05/U15N4789HMooney M20J · S/N 24-0879N49917Cessna 337C · S/N 337-0784N529SDCessna T206H · S/N T20608710N5600LVarga 2180 · S/N VAC17882N560BBBeech B36TC · S/N EA-562N560SMCessna 560 · S/N 560-0017N578WZCessna 525B · S/N 525B0403N580PGPowrachute PEGASUS · S/N A058 PEGN5ZZCessna 182Q · S/N 18265840N6161NCessna T210M · S/N 21062932N624SACirrus Design SR22T · S/N 1950N638DECR Dreams Charters CCK-1865 · S/N CCK-1865-1037N650TTTreat Tim 601XLB · S/N 6-7052N68DJJekyll Thomas JEKYLL-GLASAIR · S/N 628N68TBCessna T210N · S/N 21064492N70HCRaytheon A36 · S/N E-3172N7230DBeech A36 · S/N E-2281N7272HPiper J3C-65 · S/N 20522
Back to Los Gatos, CA