OpenAirDocs.org
Berkeley, CA

Registered aircraft · 39

Aircraft may not be kept in the town where they are registered. This site does not publish street address information.

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

N101MLPiper PA-34-220T · S/N 34-8233066Built 1981 · Wesolowski TrevorN1561RGrumman American Avn. AA-5B · S/N AA5B-0061Built 1975 · Kimmerer William JN161AJPilatus PC-12/45 · S/N 161Built 1997 · Gruener GarrettN170TMCessna 525A · S/N 525A0100Built 2002 · Jba LLCN177SDCessna 177RG · S/N 177RG0997Millner Paul AN2086QCessna 177RG · S/N 177RG0486Built 1974 · Millner PaulN2243PPiper PA-28-181 · S/N 28-7990295Built 1979 · Easterling Richard V DBAN2337UPiper PA-28-236 · S/N 28-7911300Built 1979 · One Niner Right LLCN2859WBeech A36 · S/N E-446Built 1973 · Koonce J MichaelN28697Grumman American Avn. AA-5B · S/N AA5B0762Built 1978 · Saddler HarryN306RWViatcheslav Krassovsky ROTORWAY TALON A600 · S/N 8158Built 2023 · Krassovsky ViatcheslavN30AKSwanson R/Swanson S RV-6 · S/N 21153Built 1996 · Romanski JackN3311CBeech E35 · S/N D3977Built 1954 · Krassovsky ViatcheslavN3391Pitts Special SRIC · S/N 2500Sale reportedN35939Cessna 177RG · S/N 177RG1082Built 1976 · Aarons Daniel AN368BWBeech B-60 · S/N P-290Built 1974 · Yarak Six LLCN38841Piper PA-28-181 · S/N 28-7790596Built 1977 · Savate Lloyd SN40HFCessna 150L · S/N 15072309Vogel Essex Nathaniel BN4154SBeech V35B · S/N D-9751Built 1975 · Wilanco IncN452RACessna R182 · S/N R18200634Built 1979 · Melvin MarkN4708JBeech A23A · S/N M-1014Cardenas Jonathan MN47319Interstate L-6 · S/N 86Built 1943 · Detsch Andrew JN4853ZPiper PA-22-108 · S/N 22-8428Built 1961 · Pileggi James BN51VVMong Sport MS-2 · S/N PB1Christian Timothy EN582TJQuicksilver Mfg SPRINT II · S/N 436Madore Lionel JN619MCCirrus Design SR22T · S/N 1066Built 2015 · N619mc LLCN6421ACessna 182 · S/N 33221Built 1956 · Allen Khaled CharlesN6879VMooney M20F · S/N 22-1272Built 1975 · Burke JonathanN7217GCessna 172K · S/N 17258917Built 1969 · One Niner Right LLCN735ECCessna 182Q · S/N 18265357Built 1977 · Trillia Roy Alan John TrusteeN750MVMarv Vanderpool ZENITH STOL CH 750 · S/N 75-8225Gularte Gavin GN7568XCessna 172B · S/N 17248068Built 1960 · Krassovsky ViatcheslavN775TPPileggi Thomas W SPARROW · S/N PT-3Pileggi James BN8306NPiper PA-34-200T · S/N 34-8170052Gularte GavinN85JBBurke Jonathan Christopher S1-S · S/N B-1-9414Built 1997 · Burke JonathanN876RVSmith Jeff W VANS RV-7A · S/N 72006Burbridge Benjamin Lawrence JrN8894PPiper PA-24-260 · S/N 24-4347Built 1965 · Garms Walter I III TrusteeN930DUniversal Stinson 108-2 · S/N 108-2930Built 1947 · Hrabetin James FN984SBCessna 510 · S/N 510-0283Built 2010 · Air America LLC
Back to Berkeley, CA