San Mateo, CA

Registered aircraft · 61

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 MATEO'
  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.

N101GRCessna 140 · S/N 9749Built 1946 · Alshamari Ahmad MN106SKClaude J Pignol SLING 4 TSI · S/N 106SKBuilt 2024 · Pignol Claude JacquesN133TXRans Employee Flying Club S-21 OUTBOUND · S/N 05180003Built 2018 · Fardy Melissa AN1421RGrumman American Avn. AA-1B · S/N AA1B-0521Built 1975 · Greenawald Richard JN143SECosmos PHASE II · S/N B21445Built 2000 · Harter Chris DN14611Waco UKC-S · S/N 3978Built 1935 · Allen Dennis RN194SPCessna 172S · S/N 172S9459Built 2003 · Fly4sp LLCN2050ZBeech V35B · S/N D-10193Built 1978 · Pong William RobertN210PZCessna 210L · S/N 21061268Built 1976 · Kmz Centurion LLCN22KWCessna 208B · S/N 208B5210Built 2015 · Finn Capital LLCN25PSKillough PITTS S-1S · S/N 7-0002Built 1974 · Bennett Robert CN2779TLajoie Gerald L VANS RV7A · S/N 72270Built 2011 · Lajoie Gerald LN280TTIai GULFSTREAM G280 · S/N 2049Built 2014 · N280tt Partners LLCN298RAAmmenti David A SPORTSMAN · S/N 7154Built 2010 · Ammenti David AN3038BPiper PA-28-236 · S/N 28-7911018Built 1978 · Jpsm Aircraft LLCN3261CRaytheon 58 · S/N TH1785Built 1996 · Heyman StevenN342AGrumman American Avn. AA-1B · S/N AA1B0342Slater Trevor MN35FSCessna 421B · S/N 421B0831Built 1974 · Selistli LLCN38495Piper PA-28R-201T · S/N 28R-7703229Built 1977 · St Peter Christopher EN413AKCirrus Design SR22 · S/N 4429Built 2016 · Alhambra Aviation LLCN4159NCessna 140 · S/N 13630First renewal noticeBuilt 1947 · Bergwall Douglas HN42SHCirrus Design SR22T · S/N 10066Built 2024 · Lejoran LLCN444EDDutreaux Edward Allan VANS RV-4 · S/N 2457Dutreaux Edward AN4452TPiper PA-28R-200 · S/N 28R-7235053Built 1972 · Utehin Nick AN4674ECessna 182R · S/N 18268258Built 1982 · Milliken Bradley BN525ECessna 525 · S/N 525-0853Built 2014 · Bellevue Advisors LLCN5463AAlef Aeronautics MODEL ZERO 24 · S/N 1Alef Aeronautics IncN550DAGulfstream Aerospace GV-SP (G550) · S/N 5556Built 2017 · Draper Management Co LLCN559ATVans RV-12IS · S/N 121625Tennis Caleb JN5690DEnstrom Helicopter 280C · S/N 1154Built 1978 · Rolfe Cameron RN600DWEADS PZL Warszawa-Okecie PZL-104MA WILGA 2000 · S/N 00060022Digital Production And Design LLCN6440DCessna 172N · S/N 17272801Built 1979 · Burns John Michael IIIN6529HPiper J3C-85 · S/N 19718Built 1946 · Bennett Robert CN6610BCessna 310B · S/N 35710Built 1958 · P R Air CorpN7021ECessna 175A · S/N 56521Dheedene Nicholas LN718BPCirrus Design SR22T · S/N 0609Built 2013 · Baywater Publishing LLCN734CDCirrus Design SR22 · S/N 1686Built 2005 · Jds Aviation LLCN7360TCessna 172A · S/N 46960Soper Phyllis DN7449ECessna 210 · S/N 57149Built 1960 · Dabir-Ebrahimi Mike MN758VWCessna R172K · S/N R1723404Built 1980 · Simon Ilene FN7756NPiper PA-28-180 · S/N 28-5200Built 1968 · Siegler Dylan BenjaminN79187Cessna 172K · S/N 17257943Registration pendingBuilt 1969N7BVCessna R182 · S/N R18200432Hartman Gregory SN807THBeech 58 · S/N TH-807Built 1977 · San Mateo Real Estate IncN833BCAlef Aeronautics MODEL ZERO MILPITAS · S/N 2Alef Aeronautics IncN8357DBeech J35 · S/N D-5470Built 1958 · Quinn Robert FN83SBScott E Bohannon CCX-2300 · S/N CCX-2300-0109Built 2024 · Bohannon Scott EN84099Cessna 182P · S/N 18261853Built 1973 · 650 Aviation LLCN84777Cessna 210L · S/N 21059624Built 1972 · Flight Path Partners LLCN8744NPiper PA-28-140 · S/N 28-25558First renewal noticeBuilt 1969 · Tsuei Mark
Back to San Mateo, CA