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.
N5433Travel Air 4000 · S/N 522N5551TCessna 172E · S/N 17251451N56350Piper PA-28-140 · S/N 28-7325613N5680LAmerican AA-1 · S/N AA1-0080N570HBCessna 140A · S/N 15384N570UACessna 150H · S/N 15067929N5876UPiper PA-28-140 · S/N 28-26709N58834Howard DGA-15P · S/N 561N58855Howard DGA-15P · S/N 995N5955VPiper PA-28-181 · S/N 28-7790516N615JKDJI AGRAS T40 · S/N 64TBL7K00200D6N619JCUltramagic N-300 · S/N 300/51N619TBThunder Balloons AX7-77 · S/N 619N6281TCessna 150E · S/N 15060981N65033Howard DGA-15P · S/N 831N6505KRepublic RC-3 · S/N 771N6508SCameron Balloons US A-250 · S/N 6598N6715HBeech C23 · S/N M-2255N6735ECessna 175 · S/N 56235N6805ECessna 175A · S/N 56305N6969FCessna 150F · S/N 15063569N6UMUltramagic N-180 · S/N 180/21N7016LAerostar International BAG · S/N BAG-3001N7508ALindstrand Balloons 120A · S/N 5258N752MBCirrus Design SR22T · S/N 1174N75644Xag P150 · S/N 1863FPEG8223442G9N03N76YAUltramagic N-300 · S/N 300/76N7727CNavion L-17A · S/N NAV4-1688N77501Aeronca 0-58B · S/N 058B-6192N77WKWendel James J RV-4 · S/N 1468N791YACameron Balloons US A-340 · S/N 6996N800EJEclipse EA500 · S/N 000134N8224KPiper PA-28-161 · S/N 28-8216171N825JWDassault-Breguet FALCON 50 · S/N 217N82NBBingham Neil D BINGHAM VANS RV-4 · S/N 001N8332UCessna 172F · S/N 17252232N8338TCessna 175C · S/N 17557038N8589PLuther David J MURPHY REBEL · S/N 503REBFirst renewal noticeN874NPPowell Neal J VANS RV-9A · S/N 90874N888NRCameron Balloons U S Z-315 · S/N 7016Sale reportedN9079UPowrachute AIRWOLF · S/N A080ULSN907NBAdams Balloons A-B · S/N 314N91014Lake LA-4-200 · S/N 455N9102UAerostar International RAVEN S49A · S/N S49A-3172N9122RMooney M20M · S/N 27-0075N91554North American NAVION A · S/N NAV-4-330N91604Cessna 182M · S/N 18259840N92726Cessna 182N · S/N 18260330N92750Cessna 182N · S/N 18260339N92VRReichel Richard D FOKKER DR-1 · S/N 82019
Back to Temecula, CA