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.
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
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.
N101GRCessna 140 · S/N 9749N106SKClaude J Pignol SLING 4 TSI · S/N 106SKN133TXRans Employee Flying Club S-21 OUTBOUND · S/N 05180003N1421RGrumman American Avn. AA-1B · S/N AA1B-0521N143SECosmos PHASE II · S/N B21445N14611Waco UKC-S · S/N 3978N194SPCessna 172S · S/N 172S9459N2050ZBeech V35B · S/N D-10193N210PZCessna 210L · S/N 21061268N22KWCessna 208B · S/N 208B5210N25PSKillough PITTS S-1S · S/N 7-0002N2779TLajoie Gerald L VANS RV7A · S/N 72270N280TTIai GULFSTREAM G280 · S/N 2049N298RAAmmenti David A SPORTSMAN · S/N 7154N3038BPiper PA-28-236 · S/N 28-7911018N3261CRaytheon 58 · S/N TH1785N342AGrumman American Avn. AA-1B · S/N AA1B0342N35FSCessna 421B · S/N 421B0831N38495Piper PA-28R-201T · S/N 28R-7703229N413AKCirrus Design SR22 · S/N 4429N4159NCessna 140 · S/N 13630First renewal noticeN42SHCirrus Design SR22T · S/N 10066N444EDDutreaux Edward Allan VANS RV-4 · S/N 2457N4452TPiper PA-28R-200 · S/N 28R-7235053N4674ECessna 182R · S/N 18268258N525ECessna 525 · S/N 525-0853N5463AAlef Aeronautics MODEL ZERO 24 · S/N 1N550DAGulfstream Aerospace GV-SP (G550) · S/N 5556N559ATVans RV-12IS · S/N 121625N5690DEnstrom Helicopter 280C · S/N 1154N600DWEADS PZL Warszawa-Okecie PZL-104MA WILGA 2000 · S/N 00060022N6440DCessna 172N · S/N 17272801N6529HPiper J3C-85 · S/N 19718N6610BCessna 310B · S/N 35710N7021ECessna 175A · S/N 56521N718BPCirrus Design SR22T · S/N 0609N734CDCirrus Design SR22 · S/N 1686N7360TCessna 172A · S/N 46960N7449ECessna 210 · S/N 57149N758VWCessna R172K · S/N R1723404N7756NPiper PA-28-180 · S/N 28-5200N79187Cessna 172K · S/N 17257943Registration pendingN7BVCessna R182 · S/N R18200432N807THBeech 58 · S/N TH-807N833BCAlef Aeronautics MODEL ZERO MILPITAS · S/N 2N8357DBeech J35 · S/N D-5470N83SBScott E Bohannon CCX-2300 · S/N CCX-2300-0109N84099Cessna 182P · S/N 18261853N84777Cessna 210L · S/N 21059624N8744NPiper PA-28-140 · S/N 28-25558First renewal notice
Back to San Mateo, CA