Charleston, SC
Registered aircraft · 95
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 = 'CHARLESTON' 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 = 'CHARLESTON' 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.
N103TXCessna 182T · S/N 18280984N107EDiamond Aircraft Ind DA 62 · S/N 62.106N121VUAmerican General Acft AG5B · S/N 10057N1465ECessna 172N · S/N 17271012N1506JRockwell International 112TC · S/N 13003N150BPCessna 150L · S/N 15073931N1624ZEipper Formance MXII · S/N 1764N16MTCirrus Design SR22T · S/N 2058N177ACessna 177B · S/N 17702284N182ALCessna 182N · S/N 18260549N183CRCessna 182P · S/N 18264029N2023XCessna 182H · S/N 18256123N2113TPiper PA-28R-200 · S/N 28R-7135058N222LDCirrus Design SR22 · S/N 1838N23500Cessna 150H · S/N 15068992N2362CCessna 182S · S/N 18280474N252JKCessna 525 · S/N 525-0166N2553RCessna 182K · S/N 18258253N25TLTL Ultralight Sro TL-3000 SIRIUS · S/N 23 SI 209N2628KLuscombe 8E · S/N 5355N26YBHenry E Avent JR SPITFIRE MK 26B · S/N 0102N295DAPiper PA-28-140 · S/N 28-24582N295JMRaytheon HAWKER 850XP · S/N 258754N29SLCirrus Design SR22T · S/N 8780N3061CBeech K35 · S/N D-5757N3185CRaytheon A36 · S/N E-3324N328CWCirrus Design SR22T · S/N 11087N328VJCirrus Design SF50 · S/N 0607N329WMCirrus Design SR22 · S/N 3868N333QKCirrus Design SR22 · S/N 11014N33PFCirrus Design SR22 · S/N 2572N345ALCessna T207 · S/N 20700262N34904Cessna 177B · S/N 17702078N363VPCessna 525A · S/N 525A-0363N391HCBeech 300 · S/N FA165N39843Bellanca 17-30A · S/N 73-30493N4188SBeech 58 · S/N TH-620N4287TPiper PA-28-235 · S/N 28-7110026N4340WBeech V35B · S/N D-9577N43838Piper PA-23-250 · S/N 27-4334N444PGRaytheon A36 · S/N E3218N48PGPilatus PC-12/45 · S/N 191N492JBBorke Michael F RV-9A · S/N 90852N50681Rans S-17 STINGER · S/N 0300010N513JNCessna 421C · S/N 421C0293N522MMPiper PA-32R-301 · S/N 32R-8013001N522SKCessna 172P · S/N 17274456Registration pendingN53077Cessna 172P · S/N 17274679N54046Ryan Aeronautical ST3KR · S/N 2083N5486KTalos Drones T60X · S/N 78KWN9D00A5C2H
Back to Charleston, SC