Saratoga, CA
Registered aircraft · 44
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 = 'SARATOGA' 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 = 'SARATOGA' 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.
N105CKCirrus Design SR22 · S/N 4399N110ULFeemster John R QUICKSILVER MXLII SP · S/N 310N123BBeech F35 · S/N D-4098N1242NCessna 172S · S/N 172S10309N125MXEvektor - Aerotechnik A S SPORTSTAR MAX · S/N 2009 1205N1535KLuscombe 8A · S/N 4262N1BFBeech E-55 · S/N TE-961N233AMDiamond Aircraft Ind DA 40 · S/N 40.733N2461GCessna 182B · S/N 51761N25LGCessna 177RG · S/N 177RG0624N25LPCessna 310Q · S/N 310Q0748N2882WBeech A36 · S/N E-452N335MDPiper PA-32-301 · S/N 32-8206036N336NABeech A36 · S/N E-480N340JQCessna 340A · S/N 340A0279N353CHHautamaki Charles GLASAIR III SH-3R · S/N 3302N3576JPiper PA-28-181 · S/N 28-8090206N3746Cessna TU206F · S/N U20602818N4140PMaule MXT-7-180A · S/N 21064CN485EMCirrus Design SR22T · S/N 2277N5105JCessna 310R · S/N 310R0225N525LKCessna 525 · S/N 525-0200N54KSCirrus Design SR22T · S/N 10403N57MHBombardier CL-600-2B16 · S/N 5842N60ETBeech 58TC · S/N TK-57N624RGreat Lakes 2T-1 · S/N 85N630KBPiper PA 46-350P · S/N 4636625N65504Cessna 182T · S/N 18281452N6768PPiper PA-24 · S/N 24-1899N6824RCessna T210G · S/N T210-0224N72VGranville Brothers E · S/N 8N748SPCessna 172S · S/N 172S8682N7570PPiper PA-24-250 · S/N 24-2781N772MDBeech B36TC · S/N EA-605N7RRCessna T210N · S/N 21063468N818DCCarr Donald A VANS RV-6 · S/N 60455N868SCIsrael Aerospace Ind GULFSTREAM 200 · S/N 232N8766PPiper PA-24-260 · S/N 24-4216N888ESGulfstream Aerospace G-IV · S/N 1120N95252Taylorcraft BC12-D · S/N 9652N9582HCessna 172M · S/N 17266244N97BCAmerican Champion 8GCBC · S/N 510-2008N98640Piper J3C-65 · S/N 18866N9922TCirrus Design SR22T · S/N 11386
Back to Saratoga, CA