Florence, SC
Registered aircraft · 46
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 = 'FLORENCE' 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 = 'FLORENCE' 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.
N1114FCessna 172G · S/N 17254709Registration pendingN1148UMooney M20J · S/N 24-1210N1331YCessna 172C · S/N 17249031N1466JRockwell International 112A · S/N 466N155MAPiper PA 46-350P · S/N 4636743N15930Piper PA-28-180 · S/N 28-7305189N175DADiamond Aircraft Ind DA 40 · S/N 40.1101N2244FCessna 310L · S/N 310L-0044N2500RCessna 182K · S/N 18258200N2579FChampion 7ECA · S/N 210N27527Piper PA-31-350 · S/N 31-7852044N282PCPiper PA-31T2 · S/N 31T-8166006N2960RPiper PA-28-236 · S/N 28-7911275N297TPCirrus Design SR20 · S/N 1134N29AHPiper PA-23-250 · S/N 27-398N31BKPiper PA-32R-300 · S/N 32R-7780545N3220LBeech C90A · S/N LJ-1420N329SKPilatus PC-12/45 · S/N 441N33357Callair A · S/N 113N3374WPiper PA-32-260 · S/N 32-220N345CRBeech A36 · S/N E-2873N3682LCessna 172G · S/N 17253851N384SCCzech Sport Aircraft A S SPORTCRUISER · S/N C0522N405WCCharles W Rogers A600 · S/N 6183N451WLPalmetto SW-51 · S/N SW-51-046N4993LPiper PA-28-180 · S/N 28-4366N549XLLiberty Aerospace LIBERTY XL-2 · S/N 0038N560FFCessna 560 · S/N 560-0477N563DSDiamond Aircraft Ind DA 40 · S/N 40.863N584DTBeech 58 · S/N TH-1745N60402Beech A36 · S/N E-1498N6320QMooney M20C · S/N 670139N6494JPiper PA-28-180 · S/N 28-4925N6553JPiper PA-28-180 · S/N 28-4998N7059HRobinson Helicopter R22 BETA · S/N 3695N717MECessna 172N · S/N 17273458N7775RBeech E33 · S/N CD-1202N7970WPiper PA-28-180 · S/N 28-2020N8314CPiper PA-32-260 · S/N 32-7600007N833GSPiper PA-32-260 · S/N 32-7200010N8913VCessna 172M · S/N 17264270N9190LBellanca 7ACA · S/N 44-72N926CSCessna 182A · S/N 34471N93DNAmerican Champion 8KCAB · S/N 712-93N941SHawker Beechcraft HAWKER 900XP · S/N HA0105N9906LCessna 172P · S/N 17276647
Back to Florence, SC