Los Altos, CA
Registered aircraft · 49
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 ALTOS' 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 ALTOS' 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.
N107RRRiter Russell W R.E.C. · S/N 107N114RJCirrus Design SR22T · S/N 10773N1218MCirrus Design SR22T · S/N 10774N122BMCirrus Design SR22 · S/N 4459N123GSBeech A36 · S/N E-1464N1253CCompagnie Daher TBM 700 · S/N 1444N180ZRCessna 180 · S/N 31662N1888Cessna 510 · S/N 510-0107N20GFSocata TB21 · S/N 645N210VVCessna T210N · S/N 21063214N224PCCirrus Design SR22 · S/N 4655N23674Beech V35B · S/N D-10146N239SFAmerican Champion 7GCAA · S/N 436-2000N284SGM&D Flugzeugbau JS-MD 3 RES · S/N 3.MD207N285CSTextron 182T · S/N 18283095N285SGCirrus Design SF50 · S/N 0365N313MLCirrus Design SR22T · S/N 1613N325HLCirrus Design SR22T · S/N 1327N32665Piper PA-28R-200 · S/N 28R-7535076N332CBRaytheon A36 · S/N E-3306N353CCAero Commander 500-B · S/N 500B-1230-105N3707XBeech B-60 · S/N P-557N38078Piper J3C-65 · S/N 6774N39203Taylorcraft BC12-D · S/N 6457N4122PCirrus Design SR22 · S/N 9394N420WATextron 182T · S/N 18283027N5015HCessna T182T · S/N T18208096N516KLKerr John A RV9 · S/N 90616N532SLFan Zhang SLING TSI · S/N 532SKN5352NCessna 182Q · S/N 18267662N55011Gulfstream Aerospace GV-SP (G550) · S/N 5476N5XXSchleicher ASW-27 · S/N 27109N611SESiebold John K RV-7 · S/N 72962N6193DCessna 182T · S/N 18281394N621SLLancair LC41-550FG · S/N 41510N6DYEmbraer Executive EMB-505 · S/N 50500791N700ANSocata TBM 700 · S/N 132N700JJSocata TBM 700 · S/N 242N721TRBeech B-60 · S/N P-571N735ZACessna 182Q · S/N 18265804N739DSDiamond Aircraft Ind DA 40 · S/N 40.739N7753MMooney M20F · S/N 22-0017First renewal noticeN81166Grumman American Avn. AA-5B · S/N AA5B0445N81531Piper PA-28-236 · S/N 28-8011088N82CEOsterhuber Richard P CHRISTEN EAGLE II · S/N OSTERHUBER 0001N82KDAmerican Champion 8KCAB · S/N 1182-2019N8780Bellanca 7KCAB · S/N 362-73N8912TSocata TBM 700 · S/N 1166N997TCCirrus Design SR22T · S/N 8548
Back to Los Altos, CA