Rock Hill, SC
Registered aircraft · 80
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 = 'SC' AND g.registrant_city = 'ROCK HILL' 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 = 'ROCK HILL' 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.
N104TBPiper PA-28-151 · S/N 28-7415010N1111MPiper PA-32R-301T · S/N 32R-8329010N112WWCessna T310R · S/N 310R1215First renewal noticeN1161LPipistrel D O O ALPHA TRAINER · S/N 1161 AT 912 LSAN11XMRaytheon A36 · S/N E-3225N1449ECessna 172N · S/N 17271005N1579EAeronca 7BCM/CONV · S/N 7AC-5145N1588ZBeech 35-B33 · S/N CD-436N17375Cessna 150L · S/N 15073718N1782GBeech 35-B33 · S/N CD-510N180DCCessna 180H · S/N 18051605N1891YCessna 172C · S/N 17249491N2017QCessna 177RG · S/N 177RG0417N211QABeech D35 · S/N D-3564N2215ZPiper PA-28-181 · S/N 28-7990406N222PNLawrence W Thomas CHRISTAVIA MK1 · S/N 614N226SBeech D95A · S/N TD-627N2305XCessna 182H · S/N 18256205Sale reportedN2331PPiper PA-38-112 · S/N 38-79A0948N2762LCessna 172H · S/N 17255962N2898NCessna 120 · S/N 13159N3008FPiper PA-28-161 · S/N 28-7916210N3088DBeech A36 · S/N E-2398N31057Piper J5A · S/N 5-306N330RSGreg Panzl/Rachel Panzl PANZL S-330D · S/N 01N343MCChilds Jeffrey A VANS RV-14A · S/N 140688N3537XMooney M20F · S/N 670074N35577Cessna 172I · S/N 17256846N3631NPiper J3C-65 · S/N 22885N4012FPiper PA-28-140 · S/N 28-7725001N40627Piper J3C-65 · S/N 7386N40HPPiper PA 46-350P · S/N 4636264N41388Piper J5A · S/N 5-1345N43511Piper PA-28-180 · S/N 28-7405201N44DBBeech K35 · S/N D-6074N4508RPiper PA-32-300 · S/N 32-7940245N45645Dressler David Scott SPARROWHAWK · S/N SH20030006KN4569KRugg Erwin W J-4 · S/N 5N4587CCessna 170B · S/N 25531N469PBeech F33A · S/N CE-1784N489ACAmerican Champion 7GCAA · S/N 413-98N5102SPiper PA-28-180 · S/N 28-7105125N554EECirrus Design SF50 · S/N 0460N556RMMorrison Robert J RV-9 · S/N 91398N5833WPiper PA-28-160 · S/N 28-2159N5888LBeech 60 · S/N P-89N6411HPiper J3C-65 · S/N 19591N6543WPiper PA-28-140 · S/N 28-20622N658RMRichard L Maury IV RV-7 · S/N 73161N66054Cessna 150M · S/N 15075802
Back to Rock Hill, SC