Granite Bay, CA
Registered aircraft · 33
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 = 'GRANITE BAY' 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 = 'GRANITE BAY' 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.
N1083VCessna TU206F · S/N U20602453N13180Cessna 177B · S/N 17702402N135DSShaw Donald W MURPHY SUPER REBEL · S/N 30N150FFCessna 150M · S/N 15076716N17204Cessna 177B · S/N 17702518N201KZMooney M20J · S/N 24-0470N210TBCessna 210N · S/N 21063561N221RPCirrus Design SR22 · S/N 0878N262SLSling SLING LSA · S/N 349N2RGGrosch STARDUSTER TOO SA-30 · S/N 563First renewal noticeN3117QPiper PA-32R-301T · S/N 3257403N3385XMooney M20C · S/N 3383N3445LCessna U206B · S/N U206-0745N383SRCirrus Design SR22 · S/N 2164N388KMCirrus Design SR22T · S/N 1854N389LCAviation Wisdom AL18 · S/N AL-389N464WHCirrus Design SR22T · S/N 1928N47697Piper PA-32-300 · S/N 327840012N47VBouley Henry 21 · S/N 12N499SCessna 182N · S/N 18260228N5092XChampion 7ECA · S/N 657N52694Cessna 182T · S/N 18281161N5531BCessna 182 · S/N 33531N6523GCessna 150L · S/N 15072023N736VFCessna TR182 · S/N R18200776N77DEPiper PA-46-310P · S/N 4608054N79LCAmerican Legend AL3 · S/N AL-1143N8447ZCessna 210-5(205) · S/N 205-0447N8835PPiper PA-24-260 · S/N 24-4291N886JSJerry Scott ROCKET · S/N 4230N8964JBoobar D/ Morton C LANCAIR 320 · S/N 028N91325Piper PA-38-112 · S/N 38-81A0163N998TGRans Designs S-7LS · S/N 0212574
Back to Granite Bay, CA