Fort Mill, SC
Registered aircraft · 67
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 = 'FORT MILL' 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 = 'FORT MILL' 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.
N113SQGoad Nigel R / Parpia Ijaz H RV-9A · S/N 91065N115BYAmerican Champion 7GCAA · S/N 488-2004N115XMay Richard A COMET 3 · S/N 754N116JRRigoulot James P HELICYCLE · S/N 422-E2422N122PLRobinson Helicopter R22 BETA · S/N 3265N130BWPiper PA-32-300 · S/N 32-40963N1321RGrumman American Avn. AA-5 · S/N AA5-0721N13366Cessna 172M · S/N 17262704N148BWWindom David B VANS RV-8 · S/N 001N15153Piper PA-28-235 · S/N 28-7310016N1866DBeech C35 · S/N D-3136N20074Cessna 172M · S/N 17260986N2177FPiper PA-28-236 · S/N 28-7911097N2253YCessna 177 · S/N 17700053N229MPiper PA-23-250 · S/N 27-4252N2496MPiper PA-28R-201 · S/N 28R-7837091N252LMooney M20K · S/N 25-1019N26CRCessna 210L · S/N 21060084N298RWWhittridge Richard D TWINSTARR · S/N TS97015N3244LCessna 172H · S/N 17256144N3312MPiper PA-12 · S/N 12-2167N35542Cessna 172I · S/N 17256823N379TWCessna 414A · S/N 414A-0616N37LMManary SIROCCO · S/N 170N41090Ownbey James R CAPELLA FW2TD · S/N FW2C80TD024941N48KLCirrus Design SR22 · S/N 0372N5518Piwniczka Leo A MIDGET MUSTANG · S/N 1376N5600YVarga 2180 · S/N VAC188-82N560BLCessna 560 · S/N 560-0633N5755UPiper PA-28-140 · S/N 28-26579N58WPSchroeder J G/Szot R J LANCAIR ES · S/N ES-160N5BPBeech 58P · S/N TJ-315N6090HPiper J3C-65 · S/N 19250N61998Mullis SEAREY · S/N 1MK335CN6400TCessna 150 · S/N 17800N642SASymphony Aircraft Ind SA 160 · S/N S-0005N644LBCirrus Design SR22T · S/N 9644N6462QMooney M20F · S/N 680004N6538ZGoodfellow Kurtis L VANS RV9 · S/N 90233N6548PPiper PA-24-250 · S/N 24-1670N7001PPiper PA-24-250 · S/N 24-2146N701FACessna 182T · S/N 18281107N7102LGrumman American Avn. AA-5 · S/N AA5-0402N71308Luscombe 8A · S/N 2735N715MACessna 182Q · S/N 18267469N7191PPiper PA-24 · S/N 24-2361N74692Grumman American Avn. AA-5B · S/N AA5B0351N75305Piper PA-28-181 · S/N 28-7690326N767HGVans RV-12 · S/N 12038N777NTCessna 210L · S/N 21060972
Back to Fort Mill, SC