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.
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
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.
N100PSBeech F33A · S/N CE1140N1094UCessna 172M · S/N 17266843N109PAPoseidon Tech EGRET · S/N E-001N109SRSkyrunner MK 3.2 · S/N 0116C 912T MK 32 502 007N1101TMaule MXT-7-180 · S/N 14139CN1122EPiper PA-32R-301T · S/N 32-57176N114KMMccarty Kirk A MOOSE · S/N KM-3N117MLBroceliande LANCAIR EVOLUTION · S/N EVO-0051N1202CGulfstream Aerospace GVI (G650) · S/N 6214N120DLEurocopter EC120B · S/N 1634N125CBZipline International P2 ZIP · S/N P2-ZIP-00133N1350EAeronca 7AC · S/N 7AC-4911N143MPMooney M20L · S/N 26-0024N1463CCirrus Design SR20 · S/N 1356N152HBBalloon Tech BALL-A · S/N 2N152MCessna 170B · S/N 25006N1547TCostruzioni Aeronautiche Tecna ASTORE · S/N 047N157DCirrus Design SR22T · S/N 10402N15AHAirbus Helicopters EC 130 T2 · S/N 9295N15ZMFlight Design CTSW · S/N 04-12-01N1600WPilatus PC-12/47E · S/N 1812N1602QBalloon Tech BALL-A · S/N 1N1627FCessna 172H · S/N 17255022N1783MCessna 182P · S/N 18264443N1818GChampion 7ECA · S/N 561N182GNCessna T182T · S/N T18208112N1835SBeech B36TC · S/N EA-419N1941AWilson Charlie H RV-3 · S/N 92-1148N194FGlasflugel KESTREL · S/N 5N1994FLamothe Maurice KITFOX IV · S/N ICU092N1ETCompagnie Daher TBM 700 · S/N 1516N20287Legrand Lewis W CH 701 · S/N 001N202LSDiamond Aircraft Ind DA 40 · S/N 40.459N202ZZDiamond Aircraft Ind DA 40 NG · S/N 40.NC245N210CBCirrus Design SR22T · S/N 10411N2174JMooney M20S · S/N 30-0005N219SDSocata TB21 · S/N 2050N222XTCirrus Design SF50 · S/N 0313N22479Cessna 172M · S/N 17264066N22585Cessna 150H · S/N 15068379N225ASEmbraer EMB-500 · S/N 50000239N226TMCessna T182T · S/N T18208796N2275QBell 206B · S/N 3625N233MTEclipse EA500 · S/N 000093N234ATCirrus Design SF50 · S/N 0705N246KTEaa Chapter 246 KOLB MARK III · S/N M3-275N247SSEclipse EA500 · S/N 000133N25KQCirrus Design SF50 · S/N 0745N2736ZSchweizer SGS 1-26B · S/N 254N285KYAviat A-1C-200 · S/N 3373
Back to San Francisco, CA