San Francisco, CA

Registered aircraft · 294

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 = 'SAN FRANCISCO'
  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.

N100PSBeech F33A · S/N CE1140Built 1987 · G & C Property Hc LLCN1094UCessna 172M · S/N 17266843Built 1976 · Brajnikoff Edward CN109PAPoseidon Tech EGRET · S/N E-001Poseidon Tech CorpN109SRSkyrunner MK 3.2 · S/N 0116C 912T MK 32 502 007Built 2016 · Birch MichaelN1101TMaule MXT-7-180 · S/N 14139CBuilt 2023 · Thompson Thomas BrianN1122EPiper PA-32R-301T · S/N 32-57176Built 2000 · Vasey IgorN114KMMccarty Kirk A MOOSE · S/N KM-3Built 2004 · Aeolus Labs IncN117MLBroceliande LANCAIR EVOLUTION · S/N EVO-0051Built 2014 · Broceliande LLCN1202CGulfstream Aerospace GVI (G650) · S/N 6214Built 2016 · Scarlet Capital LLCN120DLEurocopter EC120B · S/N 1634Built 2010 · Farview Holdings LLCN125CBZipline International P2 ZIP · S/N P2-ZIP-00133Zipline International IncN1350EAeronca 7AC · S/N 7AC-4911Built 1946 · Lam PhilipN143MPMooney M20L · S/N 26-0024Vpma1 IncN1463CCirrus Design SR20 · S/N 1356Built 2003 · Latta Lutz MN152HBBalloon Tech BALL-A · S/N 2Balloon Tech CoN152MCessna 170B · S/N 25006Built 1952 · Nauleau Paul ElieN1547TCostruzioni Aeronautiche Tecna ASTORE · S/N 047Built 2016 · Sienkiewicz MichaelN157DCirrus Design SR22T · S/N 10402Built 2025 · Fair Haven Aviation LLCN15AHAirbus Helicopters EC 130 T2 · S/N 9295Built 2022 · San Francisco Bay Heli LLCN15ZMFlight Design CTSW · S/N 04-12-01Built 2004 · Wide Open LLCN1600WPilatus PC-12/47E · S/N 1812Built 2018 · Flattop Aviation LLCN1602QBalloon Tech BALL-A · S/N 1Balloon Tech CoN1627FCessna 172H · S/N 17255022Jrm Equipment LLCN1783MCessna 182P · S/N 18264443Built 1975 · Ryan Jason PN1818GChampion 7ECA · S/N 561Built 1968 · Pine Wind Aviation LLCN182GNCessna T182T · S/N T18208112Built 2002 · Worthington GregN1835SBeech B36TC · S/N EA-419Built 1984 · Eagles Flying Club IncN1941AWilson Charlie H RV-3 · S/N 92-1148Built 1992 · Ackerman BenjaminN194FGlasflugel KESTREL · S/N 5Built 1969 · Seronello John FN1994FLamothe Maurice KITFOX IV · S/N ICU092Jacobs JustinN1ETCompagnie Daher TBM 700 · S/N 1516Built 2023 · California Aerospace LLCN20287Legrand Lewis W CH 701 · S/N 001Snyder Eric PN202LSDiamond Aircraft Ind DA 40 · S/N 40.459Built 2004 · Ksx Aviation Services LLCN202ZZDiamond Aircraft Ind DA 40 NG · S/N 40.NC245Built 2023 · Raccoon Air LLCN210CBCirrus Design SR22T · S/N 10411Built 2025 · Campbell Terry G TrusteeN2174JMooney M20S · S/N 30-0005Built 1999 · Safa MasoudN219SDSocata TB21 · S/N 2050Built 2001 · Freund GregorN222XTCirrus Design SF50 · S/N 0313Built 2021 · Junior Aviation LLCN22479Cessna 172M · S/N 17264066Built 1974 · Robinson Paul CN22585Cessna 150H · S/N 15068379Built 1968 · Obregon Aviation LLCN225ASEmbraer EMB-500 · S/N 50000239Built 2011 · Richelieu LLCN226TMCessna T182T · S/N T18208796Built 2007 · Wadeberg LLCN2275QBell 206B · S/N 3625Built 1982 · Sierra Bravo Aviation IncN233MTEclipse EA500 · S/N 000093Aml Global Payments LLCN234ATCirrus Design SF50 · S/N 0705Built 2025 · San Francisco Aviation LLCN246KTEaa Chapter 246 KOLB MARK III · S/N M3-275Melero Ivan VN247SSEclipse EA500 · S/N 000133Built 2008 · N76t LLCN25KQCirrus Design SF50 · S/N 0745Built 2026 · Levance Aviation LLCN2736ZSchweizer SGS 1-26B · S/N 254Built 1964 · Pearce Andrew MN285KYAviat A-1C-200 · S/N 3373Built 2021 · Charlie Lima Tango Enterprises LLC
Back to San Francisco, CA