Seneca, SC
Registered aircraft · 50
Aircraft may not be kept in the town where they are registered. This site does not publish street address information.
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 = 'SC' AND g.registrant_city = 'SENECA' 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 = 'SC' AND g.registrant_city = 'SENECA' 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.
N102JBS C Aerostar S A AEROSTAR 1 · S/N 04N122ZBBRM Aero Sro BRISTELL S-LSA · S/N 122/2015N14071Waco YKC · S/N 3992N14684Waco YOC · S/N 4283Registration pendingN1597SBeech 35-B33 · S/N CD-540N1704TPiper PA-28-140 · S/N 28-7125020N17559Cessna 175 · S/N 55863N2101UBrantly B-2B · S/N 147N2290UBrantly B-2B · S/N 461N22991Cessna 150H · S/N 15068666N23999Aeronca 65-C · S/N C6719Registration pendingN279YGilmore Mark S MARQUART CHARGER MA5 · S/N 027Registration pendingN334RPPiper PA-31-350 · S/N 31-8052071Registration pendingN33EBBeech F35 · S/N D-4046N3611ABeech A36 · S/N E-1472N3629HMooney M20C · S/N 20-1254N3674MPiper PA-12 · S/N 12-2624N3756JCessna 150G · S/N 15065056N3867DCessna 182A · S/N 34567N41YBYoungblood Charles D PIETENPOL AIR CAMPER · S/N 001N427ABurden Cecil R RV-7A · S/N 72115N448PTTerry L Latino RV-9A · S/N 92211N4618WRockwell International 112TC · S/N 13108N46534Cessna 172K · S/N 17257334N49320Waco EGC-8 · S/N 5074N504DHSikorsky S58E · S/N 58814N511DMAmerican General Acft AG5B · S/N 10102N514RJCirrus Design SR22T · S/N 10901N519SRCirrus Design SR22 · S/N 2072Sale reportedN5499Smith Dane E ZENITH CH 701 · S/N 7-6094N561SDBellanca 8KCAB · S/N 564-79N5778ZPiper PA-22-108 · S/N 22-9623N61857Boeing A75N1(PT17) · S/N 75-4733N6300MPiper PA-32-300 · S/N 32-7440141N65407Cessna 152 · S/N 15281533N67PVBRM Aero BRISTELL S-LSA · S/N 159/2015N733VSCessna 172N · S/N 17268588N73STPiper PA-28-180 · S/N 28-937N7402XCessna 172B · S/N 17247902N81258Fairchild 24W-46 · S/N W-46158N81288Fairchild 24W-46 · S/N W46215Registration pendingN81306Fairchild 24R-46 · S/N R46206Sale reportedN81318Fairchild 24W-46 · S/N W46218N8315APiper PA-34-200T · S/N 34-8170072N8464SCessna 182H · S/N 18256564N8481TCessna 182C · S/N 52381N8883PPiper PA-24-260 · S/N 24-4342N8991CPiper PA-22-135 · S/N 22-1564N9749QBeech C23 · S/N M-1363N97692Stinson 108 · S/N 108692
Back to Seneca, SC