Rancho Santa Fe, CA
Registered aircraft · 32
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 = 'RANCHO SANTA FE' 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 = 'RANCHO SANTA FE' 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.
N10YVPiper PA-18-150 · S/N 18-8185N133DXMichael J Weaver BUCKER 133 · S/N MJW001N20BALaister Sailplane LP-15 · S/N N9N21088Cessna 182P · S/N 18261405N233MWRaytheon 400A · S/N RK-233N2456LCessna T206H · S/N T20608272N24BVCirrus Design SR22T · S/N 10053N268RBeech A36 · S/N E1092N30002Piper PA-18-150 · S/N 187998N35HGBeechcraft B300 · S/N FL-856N360LBCerr AIRCAM · S/N AC-207N4063HMooney M20K · S/N 24-0402N440AFEmbraer EMB-550 · S/N 55000084N449BKMitsubishi MU-2B-40 · S/N 449 S.A.N45315Gulfstream American AA-5B · S/N AA5B1167N491TSDiamond Aircraft Ind DA 42 · S/N 42.AC091N4FLGulfstream Aerospace GVI · S/N 6032N534JWCubcrafters CC11-160 · S/N CC11-00381N5FLPilatus PC-24 · S/N 518N751EATextron 750 · S/N 750-0529N788KMCirrus Design SR22 · S/N 4745N8200GCessna 177RG · S/N 177RG0100N83PKTextron T182T · S/N T18209101N850EESocata TBM 700 · S/N 548N8620MBeech P35 · S/N D-7289N882JPBeech B200 · S/N BB-882N900MYDassault FALCON 900 · S/N 165N902MSHawker Beechcraft HAWKER 900XP · S/N HA-0196N912AVCessna LC41-550FG · S/N 411006N922TIsrael Aircraft Industries ASTRA SPX · S/N 109N9470GCessna U206E · S/N U20601670N991SBCirrus Design SR22T · S/N 0059
Back to Rancho Santa Fe, CA