Temecula, CA
Registered aircraft · 160
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 = 'TEMECULA' 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 = 'TEMECULA' 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.
N2581SBalloon Works FIREFLY 7-15 · S/N F7-795N26MBCessna 150D · S/N 15060713N2717CCessna 170B · S/N 26261N2928LMooney M20F · S/N 670322N293JDCzech Sport Aircraft A S SPORTCRUISER · S/N C0561N30027Ultramagic S A N-250 · S/N 250/15N3009HUltramagic H-77 · S/N 77/192N300EABalony Kubicek Spol Sro BB85Z · S/N 1912N300GEBalony Kubicek Spol Sro BB85Z · S/N 1329N300KUBalony Kubicek Spol Sro BB60Z · S/N 1874N30137Firefly Balloons 2010 FIREFLY 8 · S/N F8-2035N3025BCameron Balloons CHAMPAGNE-90 · S/N 6041N304XSGlasflugel 304CZ-17 · S/N 60-17N3055ACessna 170B · S/N 25699N3074BCessna 195A · S/N 7958N308MCUltramagic S A S-105 · S/N 105/232N310ATCessna 310J · S/N 310J0097N322LKCessna T210L · S/N 21060344N323UBUltramagic N-300 · S/N 300/56N3291ABalloon Works FIREFLY 7B-15 · S/N F7B-369N34FUBeech D-45 · S/N BG-180N350BYBalony Kubicek Spol Sro BB100Z · S/N 1496N350WTPiper PA 46-350P · S/N 4636767N353GRXag P150 · S/N 186324P18223443NJ448N3620RPiper PA-28-180 · S/N 28-5716N3795WPiper PA-32-260 · S/N 32-722N38204Piper PA-28-235 · S/N 28-7710046N3889KTemco GC-1B · S/N 3589N40058Piper PA-28-161 · S/N 28-7816007N431TCThunder & Colt Airborne Amer AX10-180S1 · S/N 2244USAN433CACirrus Design SR22T · S/N 9503N433KBBalony Kubicek Spol Sro BB60Z · S/N 874N4362RCessna 172M · S/N 17263113N440BKBalony Kubicek Spol Sro BB26D · S/N 1640N4432UCessna 150D · S/N 15060432N4571CMooney M20K · S/N 25-0495N457GGCessna 150D · S/N 15060269N4665FPiper PA-28R-200 · S/N 28R-7635407N4739Travel Air 9000 · S/N 409N47503Aeronca 0-58B · S/N 058B-8212N4774Ultramagic T-150 · S/N 150/04N485TWBalony Kubicek Spol Sro BB60Z · S/N 1198N49CDLindstrand Balloons 180A · S/N 025N5086ACessna T210N · S/N 21063263N509KFBalony Kubicek Spol Sro BB51Z · S/N 1801N50CDUltramagic M-145 · S/N 145/09N520TWBalony Kubicek Spol Sro BB45Z · S/N 1779N522KGCirrus Design SR22 · S/N 1170N5340PPiper PA-24-250 · S/N 24-385N5352CCessna 140A · S/N 15483
Back to Temecula, CA