Johns Island, SC
Registered aircraft · 33
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 = 'JOHNS ISLAND' 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 = 'JOHNS ISLAND' 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.
N107THHukill Christopher J HUKILL ONE DESIGN · S/N 0001N11MUCirrus Design SR22T · S/N 1831N11VZBeech A36 · S/N E-397N12187Cessna 172M · S/N 17261870N12BUBeech D55 · S/N TE-595N1302LCessna 182P · S/N 18263615N20423Cessna 172M · S/N 17261278N2047ECessna 172N · S/N 17271131N242PZLancair LC-40-550FG · S/N 40037N299SRCirrus Design SR20 · S/N 1886N319JFCessna 210N · S/N 21063507Registration pendingN32094Waco UPF-7 · S/N 5730N399BWCirrus Design SR22T · S/N 11156N450UACostruzioni Aeronautiche Tecna P2006T · S/N 420/USN51DYThomson Malcolm THUNDER MUSTANG · S/N DITM019N52250Cessna 172P · S/N 17274460N5256LPiper PA-28-180 · S/N 28-4553N64155Cessna 172M · S/N 17265050N67000Beech 76 · S/N ME-283Registration pendingN699YZCirrus Design SR20 · S/N 2448N707DLCondor Air CCX-2000 · S/N CCX-2000-0031N72256Cessna 120 · S/N 9430N7230HBeech C90 · S/N LJ-1113N798PABritish Aerospace BAE 125 SERIES 800A · S/N 258070N812DBCirrus Design SR22 · S/N 2399N829PACessna T206H · S/N T20608950N842RBCessna 172K · S/N 17258377N8791WPiper PA-28-235 · S/N 28-10339Registration pendingN887ACBeech 58 · S/N TH-603N90496Piper PA-32R-300 · S/N 32R-7780353N92307Cessna 172M · S/N 17261558N9552YBeech P35 · S/N D-7053N96SEHeinlein Stephen RV-6A · S/N 001
Back to Johns Island, SC