Torrance, CA
Registered aircraft · 295
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 = 'TORRANCE' 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 = 'TORRANCE' 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.
N105KYRobinson Helicopter R66 · S/N 1557N109GSMcewen SPECIAL · S/N 1N10HJGerhardt Heinrich VANS RV6 · S/N 21622N11162Buhl LA-1 · S/N 103N11BMRobinson Helicopter R44 II · S/N 15043N1217Piper PA-23 · S/N 23-237N122YBRobinson Helicopter R22 BETA · S/N 3309N1232ASling SLING LSA · S/N 341N1248QCessna 150L · S/N 15072548N1264UCessna 172M · S/N 17266959N127JCSchleicher ASW-19 · S/N 19031N12LKRobinson Helicopter R66 · S/N 1558N13562Waco UIC · S/N 3816N135WTWayne Toddun SLING 4 TSI · S/N 131SN138KAero Commander 720 · S/N 720-621-2N13FRRobinson Helicopter R66 · S/N 0373N1404WBell 206B · S/N 298N141VSchempp-Hirth NIMBUS 3T · S/N 3N143JBCessna 337 · S/N 337-0102N145TRRobinson Helicopter R44 II · S/N 15020N1488MSling SLING LSA · S/N 339N157JWLemmond CASSUTT 111M · S/N CAL1N158RPThomas Mrcrea VORTEX · S/N P1987N160FSmith MINIPLANE · S/N HEF-1N166PACessna T182T · S/N T18209060N168TWAirplane Factory Ltd The SLING · S/N 155N1743JPiper PA-28-140 · S/N 28-24159N17DWRobinson Helicopter R66 · S/N 1564N181KMSean Mullett SLING TSI · S/N 682SQN1837WBeech C23 · S/N M-2340N18CFSchleicher ASW-15 · S/N 15187N1910BLuscombe 8A · S/N 6337N1941GBurris Troy A DRAGONFLY · S/N 457N1944WGrumman J4F-2 · S/N 1342N1963MCirrus Design SR22 · S/N 0355N204CESling SLING LSA · S/N 364N206AYCessna U206B · S/N U206-0820N210FBCessna 210L · S/N 21060441N2114UCessna 172S · S/N 172S9618N212HWJoseph Keenan SLING HW · S/N 131GQN2151BSling SLING LSA · S/N 327N217MECessna T303 · S/N T30300188N221YZYuriy Chanba SLING TSI · S/N 694SQN223PHEvektor-Aerotechnik SPORTSTAR SL · S/N 20081201N225WHRobinson Helicopter R44 II · S/N 15012N232RWAirplane Factory SLING 4 · S/N 121N2331GCessna 182B · S/N 51631N2360QPiper PA-25-235 · S/N 25-7956034N238FSling SLING LSA · S/N 358N241TDSling SLING LSA · S/N 360
Back to Torrance, CA