Swansea, SC
Registered aircraft · 91
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 = 'SWANSEA' 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 = 'SWANSEA' 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.
N1915VCessna 172M · S/N 17263793N2021HErco 415-C · S/N 2644N2120HErcoupe 415-D · S/N 2787N2244HEngineering & Research ERCOUPE 415-C · S/N 2867N2349QBeech 23 · S/N M-417N2402HErcoupe 415-C · S/N 3027N2446HErcoupe 415-C · S/N 3071N2536HErcoupe 415-C · S/N 3161N2608HErcoupe 415-C · S/N 3233N2663HErcoupe 415-C · S/N 3288N2715HErcoupe 415-D · S/N 3340N2730HErcoupe 415-C · S/N 3355N2747HErcoupe 415-C · S/N 3372N2779JEngineering & Research 415-C · S/N 976N28939Ercoupe 415-C · S/N 34N28960Ercoupe 415-C · S/N 56N2915HErcoupe 415-C · S/N 3540N2962HErcoupe 415-C · S/N 3587N3007GForney F-1 · S/N 5699N3009GForney F-1 · S/N 5701N3027GForney F-1A · S/N 5722N3041HErcoupe 415-CD · S/N 3666N3043HEngineering & Research 415-C · S/N 3668N3067HErcoupe 415-CD · S/N 3692N3100HErcoupe 415-C · S/N 3725N3130HEngineering & Research 415-C · S/N 3755N3149HErcoupe 415-D · S/N 3774N37107Engineering & Research ERCOUPE 415-C · S/N 74N3785HEngineering & Research ERCOUPE 415-C · S/N 4410N3798HErcoupe 415-C · S/N 4423N3804HEngineering & Research ERCOUPE 415-CD · S/N 4505N3868HErcoupe 415-CD · S/N 4569N3878HErcoupe 415-D · S/N 4579N3926DErcoupe 415-CD · S/N 4627N3943HErcoupe 415-CD · S/N 4644N415RGForney 415-C · S/N 864N5609FAlon A2 · S/N A-209N5674FAlon A2 · S/N A-174N5678FAlon A2 · S/N A-178N5918FAlon A2 · S/N A-213N601JDDavis John G ZODIAC 601XL · S/N 6-6875N6363VAlon A2 · S/N A-39N6364VAlon A2 · S/N A-40N6534QAlon A2 · S/N A-134N7081ACessna 172 · S/N 29181N719BByrd Melvin G SINGLE-SEAT CLIPWING · S/N 0199-CW-0719N72DSErcoupe 415-D · S/N 1012N747ECForney 415-C · S/N 747N7531CForney F-1 · S/N 5646N86991Engineering & Research ERCOUPE 415-C · S/N 164
Back to Swansea, SC