OpenAirDocs.org
Alameda, CA

Registered aircraft · 108

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 = 'ALAMEDA'
  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.

N103PYPyka PELICAN · S/N 16056PS0065Pyka IncN1085NMooney M20K · S/N 25-0583Built 1981 · Wong Sonja MN109LDPiper PA-28-181 · S/N 28-7990292Built 1979 · East Bay Flight LLCN109PYPyka PELICAN · S/N 16056PS0066Pyka IncN111PYPyka PELICAN · S/N 16056PS0067Pyka IncN121CCraig Valentine SLING 4 TSI · S/N 170SKBuilt 2020 · Valentine CraigN1348TPyka PELICAN · S/N 16056PS0036Built 2024 · Pyka IncN1349UPyka PELICAN CARGO · S/N 16056PC0010Pyka IncN1351NPyka PELICAN CARGO · S/N 16056PC0008Pyka IncN1352QPyka PELICAN · S/N 16056PS0039Built 2024 · Pyka IncN1353GPyka PELICAN CARGO · S/N 16056PC0006Built 2023 · Pyka IncN1357DPyka PELICAN · S/N 16056PS0038Built 2025 · Pyka IncN1367ZPyka PELICAN · S/N 16056PS0037Built 2025 · Pyka IncN136RPPyka PELICAN CARGO · S/N 16056PC0009Pyka IncN136XPPyka PELICAN · S/N 16056PS0035Built 2024 · Pyka IncN136ZPPyka PELICAN CARGO · S/N 16056PC0007Built 2024 · Pyka IncN1547YCessna 172C · S/N 17249247Built 1962 · Burgo Randy PN1660DCessna 170B · S/N 20302Built 1952 · Foster MikeN205MPMooney M20J · S/N 24-3032Built 1987 · Sadler Ryan TN20663Luscombe 8 · S/N 826Maggio Ronald CN210PYPyka PELICAN · S/N 16056PS0070Pyka IncN2123LBeech A36 · S/N E-886Built 1976 · Panther Air LLCN213CNew Piper PA-32R-301T · S/N 3257436Built 2006 · Levins KennethN221PYPyka PELICAN · S/N 16056PS0071Pyka IncN223PYPyka PELICAN · S/N 16056PS0072Pyka IncN22QTDiamond Aircraft Ind DA 40 · S/N 40.491Built 2005 · Alameda Aero ClubN25HKKilroy Andrew B RV-14A · S/N 140394Built 2022 · Kilroy Andrew BN265NAPyka PELICAN · S/N 16056PS0063Pyka IncN354WSPyka PA02 · S/N 1796F00164E833EA39E0Built 2020 · Pyka IncN40EHHibler Phillip E GLASAIR II S TD · S/N 2067Built 1995 · Hibler Phillip EN47CPCessna 180 · S/N 32304Built 1957 · Hibler Philip EarlN4826TPiper PA-28-180 · S/N 28-7205202Sundance Air Services IncN487RSPyka PA02 · S/N 6907Built 2022 · Pyka IncN4880PPyka PELICAN · S/N 16056PS0055Pyka IncN4881PPyka PELICAN · S/N 16056PS0060Pyka IncN4882PPyka PELICAN · S/N 16056PS0048Pyka IncN4884PPyka PELICAN · S/N 16056PS0061Pyka IncN4885PPyka PELICAN · S/N 16056PS0062Pyka IncN4886PPyka PELICAN · S/N 16056PS0049Pyka IncN4887PPyka PELICAN · S/N 16056PS0064Pyka IncN4888PPyka PELICAN · S/N 16056PS0045Pyka IncN4889PPyka PELICAN · S/N 16056PS0058Pyka IncN488MPPyka PELICAN · S/N 16056PS0056Pyka IncN488NPPyka PELICAN · S/N 16056PS0046Pyka IncN488VAPyka PELICAN · S/N 16056PS0057Pyka IncN488XPPyka PELICAN · S/N 16056PS0059Pyka IncN488YPPyka PELICAN · S/N 16056PS0047Pyka IncN489APPyka PELICAN · S/N 16056PS0050Pyka IncN489BPPyka PELICAN · S/N 16056PS0051Pyka IncN489CWPyka PELICAN · S/N 16056PS0053Pyka Inc
Back to Alameda, CA