Walterboro, SC
Registered aircraft · 18
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 = 'WALTERBORO' 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 = 'WALTERBORO' 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.
N1078Iniziative Industraili Italia SKY ARROW 650TCNS · S/N CNS 026N12390Cessna 172M · S/N 17261963N147CMCarson Roy R RV-7 · S/N 71424N157JDiamond Aircraft Ind DA 62 · S/N 62.C090N277JJBeech B200 · S/N BB-1043N279RWCessna 182B · S/N 52347N2922UPiper PA-34-200T · S/N 34-7970377N332MSBeech C90 · S/N LJ1023N400SCBeech B200 · S/N BB-1040N600ACBeech E-90 · S/N LW-185N63605Cessna 150M · S/N 15077423N825STBeech B200 · S/N BB-1320N8338PPiper PA-24-250 · S/N 24-3593N843MPIniziative Industraili Italia SKY ARROW 650TCNS · S/N CNS018N854JACessna 550 · S/N 550-0920N941KDCessna 525C · S/N 525C0005N9494SBeech 95-B55 (T42A) · S/N TC-985N997LMBeech 200 · S/N BB217
Back to Walterboro, SC