Palm Springs, 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 = 'PALM SPRINGS' 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 = 'PALM SPRINGS' 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.
N1193NBoeing E75 · S/N 75-1218N121GRAerotek PITTS S-2A · S/N 2159N1420PCessna 182T · S/N 18281888N1515QCessna 150L · S/N 15072815N151BPNorth American/Aero Classics P-51D · S/N 44-74908N15270Piper PA-28R-200 · S/N 28R-7335012N163BPBell/Pond P-63C KING COBRA · S/N 091263RPN1737RCessna R182 · S/N R18200541N226EWaco UPF-7 · S/N 5309N26044Piper J3C-65 · S/N 3995N304DRRadford Darrel F CHRISTEN EAGLE II · S/N RADFORD-0001N371CDCirrus Design SR22 · S/N 1434N372CNorth American T-28B · S/N 138203N4086TNorth American AT-6D · S/N 42-86068N411MACirrus Design SR22 · S/N 3496N41507Piper PA-28-151 · S/N 28-7415241N415PJCirrus Design SR22 · S/N 0002N4292YPiper PA-28-181 · S/N 28-8390037N472SRCirrus Design SR22 · S/N 2272N476DTCessna 172G · S/N 17254299N47PSCessna 182P · S/N 18262767N5673QMooney M20C · S/N 3035N579DBeech 35 · S/N D-369N60154Douglas DC3C-R-1830-90C · S/N 32755N60PTDan Harrington SERIES 6 · S/N S60109-060N653KSCirrus Design SR22 · S/N 3233N6633DLockheed TV-2 · S/N 126591N6949RCessna T210H · S/N T210-0349N7273CLockheed PV-2 · S/N 37211N745RVJones John J RV-12 · S/N 120430N8218NPiper PA-28-140 · S/N 28-25548N8879NPiper PA-28-140 · S/N 28-25743
Back to Palm Springs, CA