OpenAirDocs.org
Oakland, CA

Registered aircraft · 88

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

N1054WBeech 58 · S/N TH-312Built 1973 · Heavers George SN1198FCessna 172G · S/N 17254793Built 1966 · Stockle Barry WN150TGCessna 680 · S/N 680-0127Built 2007 · Home Run LLCN155BCAmerican Champion 8GCBC · S/N 599-2019Built 2019 · Callander John KN1716XCessna 210L · S/N 21060738Built 1975 · Bell BrianN1719WVans RV-12IS · S/N 121060Built 2021 · Schoening Robert WilliamN173JEAmerican Legend AL3C-100 · S/N AL-1025Turney Gerald EN175KTMooney M20C · S/N 2382Built 1962 · Turney Gerald EN182AKCessna 182Q · S/N 18267486Built 1979 · Bluebird Pacific Aviation LLCN21866Piper PA-28-181 · S/N 28-7990063Built 1978 · Donthineni RakeshN220PDMcdonnell Douglas Helicopter 369E · S/N 0509EBuilt 1993 · City Of OaklandN224RAAmerican Champion 7GCAA · S/N 4832004Sierra Whiskey Aircraft LLCN23DNNeal Daniel K STEEN SKYBOLT · S/N 2301Built 1999 · Flagella MichaelN2473BBell 47G · S/N 1450Built 1955 · Kerr Douglas EN2507SColumbia Aircraft Mfg LC41-550FG · S/N 41567Friedman Jeffrey C TrusteeN270MGPhoenix Air Sro PHOENIX U15 · S/N 26/U15Built 2014 · Sargent Brook MN2853QCessna 172L · S/N 17259853Built 1971 · Shelton Stefon EN29DYWesterhout D/Gagnier A ESCAPADE · S/N JAESC 012Marlin Steve NN3051TCessna 320C · S/N 320C0051Pacific Arts Collection LLCN3053YCessna 182E · S/N 18254053Built 1962 · Mudd Joseph AN3119RCessna 182L · S/N 18258519Built 1967 · Chern JeffreyN3158LMooney M20M · S/N 27-0189Built 1994 · Scott Terrence LeeN330PDSchweizer 269C-1 · S/N 0201Built 2005 · City Of OaklandN365CJBombardier BD-700-1A10 · S/N 9077Built 2000 · Tashi CorpN415PCCessna 525B · S/N 525B0280Built 2008 · Blue Jay Air LLCN430WGDehavilland DHC-1 CHIPMUNK · S/N C1-0504Built 1951 · Randall Steven JN4497SBeech F33A · S/N CE-592Built 1975 · Frazier Ford PN450KMPiper PA46-500TP · S/N 4697361Built 2008 · Pa46 Capital LLCN4785MBlinkov Mikhail CH701 · S/N 7-8574Built 2015 · Blinkov Mikhail IN49004Cessna 152 · S/N 15281094Oakland Flyers LLCN510PDMcdonnell Douglas Helicopter 369E · S/N 0400EBuilt 1990 · City Of OaklandN521AATextron 525 · S/N 525-0920Built 2016 · One Alpha Alpha LLCN5323FPiper PA-28-181 · S/N 28-7790087Built 1976 · Silmi AmjadN53914Bellanca 7KCAB · S/N 561-76Built 1976 · Kauzlarich Steve FN5429AHoffman Wilson H RV 9A · S/N 91212Built 2008 · Hoffman Wilson HN5525UCessna U206G · S/N U20605311Built 1979 · Sheriffs DepartmentN553TPPiper PA-28-181 · S/N 28-7690105Built 1975 · Oakland Flyers LLCN5690UPiper PA-28-140 · S/N 28-26488Built 1970 · Pena Flight Partners LLCN5784NDavid Weinberg SONEX B · S/N 0026Built 2022 · Weinberg DavidN578CJCessna 525B · S/N 525B0282Built 2008 · N920 LLCN605PKPyka PELICAN · S/N 16056PS0025Pyka IncN6088RCessna 172G · S/N 17253757Built 1965 · Pruette JasonN612SCHenry Steven J ESCAPADE · S/N JAESC0054Marlin Steve NN620EEEmil Kroening SEAREY LSX · S/N 1LK634CKroening Emil JN626MMQuest KODIAK 100 · S/N 100-0176Built 2016 · Flying Tricycle LLCN6499NCessna T210N · S/N 21063073Built 1978 · Helgren Quentin CN653BSPyka P-400B · S/N 6902Pyka IncN656SMCessna 525B · S/N 525B-0117Built 2006 · Cj3 Systems LLCN656TEOstroth Thane L COZY MK IV · S/N 001Built 2007 · Winged Wallabies IncN666RJCessna 177RG · S/N 177RG0902Built 1976 · Newitt David C
Back to Oakland, CA