Santa Cruz, CA
Registered aircraft · 116
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 = 'SANTA CRUZ' 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 = 'SANTA CRUZ' 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.
N101XWCessna 208B · S/N 208B0382N11229Waco RNF · S/N 3456N1134UCessna 172M · S/N 17266863N113DBeech 35-C33A · S/N CE-2N114CDPiper PA-30 · S/N 30-37N118MAMooney M20R · S/N 29-0260N122NMDG Flugzeugbau LS 10-ST · S/N L10-021N12301Vans RV-12IS · S/N 121198N126SDStephen Denmark RV-9A · S/N 91709N141TJJames Timothy H GLASTAR · S/N 5190N146WBBrecheisen Adell Warren II RV-6 · S/N 23005N14FTTerrell Franklin Pierce RV-4 · S/N 1394N1572Travel Air Mfg 2000 · S/N 225N162SACessna 208B · S/N 208B0548N1913YMooney M20D · S/N 208N2078BPiper PA-32RT-300T · S/N 32R-7987022N22488Cessna 150H · S/N 15068313N228GMGordon A Comfort VANS RV-8 · S/N 80010N22JKRyan Aeronautical ST3KR · S/N 1697N2335RRaytheon 58 · S/N TH-1835N2429KPiper PA-38-112 · S/N 38-79A0627N243TACostruzioni Aeronautiche Tecna P92 TAIL DRAGGER · S/N 1443N25797Piper J3C-65 · S/N 3751N26HSMooney M20F · S/N 670343N2758SCessna 150G · S/N 15066658N2895XCessna 177 · S/N 17700295N308CLCessna T182T · S/N T18208825N30FRJoby Aero JAI30 · S/N 001N317XMaule M-5-235C · S/N 6127CN325DHHinman David GS2 SPORTSMAN · S/N 7267N32693Piper PA-28R-200 · S/N 28R-7535078N34FXLawrence S/Farley R VANS ACFT RV-4 · S/N 1692N350TWWalker Tommy E VANS RV-6A · S/N 24822N35547Piper J3C-65 · S/N 6452N3615CCessna 180 · S/N 31113N3647NPiper J3C-65 · S/N 22906N3663KBeech A36TC · S/N EA-84N38ZCReeder Zachary C RV-8 · S/N 82432N4089FFliehr David L RV-8 · S/N 81452N428KWHenley John F RV-6 · S/N 24486N42980Cessna 182L · S/N 18259274N434GXRemos REMOS GX · S/N 434N44RDJones-Davis QUICKIE · S/N 413N45188Cessna 177RG · S/N 177RG1095N454TACostruzioni Aeronautiche Tecna P2002 SIERRA · S/N 451N4597RCessna 150J · S/N 15070525N4693QCessna 172M · S/N 17261746N48DMSchempp-Hirth VENTUS B/16.6 · S/N 201N4960DCessna 182A · S/N 51060N517ATAustin Andrew J RV-10 · S/N 41237
Back to Santa Cruz, CA