Santa Clarita, CA
Registered aircraft · 40
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 CLARITA' 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 CLARITA' 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.
N105SXLuke Raymond F SONEX · S/N 1105N1195LAmerican General Acft AG5B · S/N 10095N1445SCessna 182P · S/N 18264993N202XSCzech Aircraft Group Sro SPORTCRUISER · S/N C0687N22395Cessna 172M · S/N 17264063N2244ROverland Freedom CCX-2300 · S/N CCX-2300-0054Registration pendingN22GBCessna T310R · S/N 310R1237N3668UBeech A36 · S/N E-1701N3941YBeck/Statler/Statler R.A.C.E. SPECIAL · S/N 001N407AFPiper PA-30 · S/N 30-1285N489PFFleming Peter A RV 4 · S/N 2813N5013TPiper PA-28R-200 · S/N 28R-7235173N5045KRosenhan SKYHOPPER · S/N 1N5537RCessna 172RG · S/N 172RG0073N5562FPiper PA-28-140 · S/N 28-24902N56748Piper PA-28-140 · S/N 28-7425029N6108SBeech A36 · S/N E-1946N646UPiper PA-46-701TP · S/N 46020061N646VACirrus Design SR20 · S/N 11361N661GKAirbus Helicopters AS350B3 · S/N 9654N66948Cessna 152 · S/N 15281683N6951ZCameron Balloons US Z-77 · S/N 6770N700LDPiper AEROSTAR 602P · S/N 62P-928-8165051N704UHCessna 150M · S/N 15078881N7142PPiper PA-24-250 · S/N 24-2307N7373QCessna 182P · S/N 18261013N74785Mooney M20B · S/N 1785N7769QCessna 310Q · S/N 310Q0269N779SLAirplane Factory SLING LSA · S/N 246N8056LCessna 172H · S/N 17256256N81765Piper PA-28RT-201T · S/N 28R-8231039N831CRChristopher G Chaney RV-7 · S/N 74160N874WVPiper PA-28-235 · S/N 28-7610137N8RBBeech D95A · S/N TD-662N9003FPiper PA-28-181 · S/N 28-7790273N9099BChampion 7EC · S/N 7EC-648N9278MMooney M20E · S/N 1215N9295SBeech C23 · S/N M-1630N9641QCessna 172M · S/N 17265725N9876RBeech M35 · S/N D-6431
Back to Santa Clarita, CA