Camden, SC
Registered aircraft · 90
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 = 'CAMDEN' 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 = 'CAMDEN' 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.
N101JGNorth American SNJ-5C · S/N 90906N1242BCessna 172S · S/N 172S10307N1318QCessna 172S · S/N 172S10657N1323XCessna 172S · S/N 172S10367N1496MCessna 182P · S/N 18264352N169KSCessna 414A · S/N 414A0015N183ERCessna 150L · S/N 15073584N1859UCessna 172S · S/N 172S9927N187ERCessna 150M · S/N 15077004N189ERCessna 150M · S/N 15076412N20957Cessna 172S · S/N 172S9571N21019Cessna 172S · S/N 172S9595N210JMCessna T210N · S/N 21064159N2119QCessna 172S · S/N 172S9623N2157HCessna 172S · S/N 172S9536N22467Cessna 172S · S/N 172S10487N2302YCessna 172S · S/N 172S9973N231KYMooney M20K · S/N 25-0293N24108Cessna 172S · S/N 172S10504N24447Cessna 172S · S/N 172S10122N2466TCessna 172S · S/N 172S10062N2472UCessna 172S · S/N 172S10074N2651KLuscombe 8E · S/N 5378Registration pendingN269FGCessna 172S · S/N 172S10885N26AATextron 172S · S/N 172S11693N277GTCessna 172S · S/N 172S9286N278SPCessna 172S · S/N 172S9474N2836FCessna 182J · S/N 18256936N316EPTextron 172S · S/N 172S11682N3265ACessna 172S · S/N 172S9878N33483Piper PA-28-180 · S/N 28-7505151N3422BBeech D35 · S/N D-3660N3617PPiper PA-22-150 · S/N 22-3723N362CWDJI AGRAS T50 · S/N 1581F6BUB23AG001TP30N401LPCessna 172S · S/N 172S9401N458SCzech Sport Aircraft A S SPORTCRUISER · S/N 09SC280N45EFCessna 172S · S/N 172S8982N464ERCessna 172S · S/N 172S11598N467DMCessna 421B · S/N 421B0377N469FGCessna 172S · S/N 172S10884N509FGCessna 172S · S/N 172S10270N5114ZCessna 172S · S/N 172S10927N51390Cessna 172S · S/N 172S10892N5181ECessna 172S · S/N 172S9058N52217Cessna 172P · S/N 17274441N52232Cessna 172S · S/N 172S10870N5225DCessna 172N · S/N 17272457N5251ZCessna 172S · S/N 172S10902N52522Cessna 172S · S/N 172S10905N5253CCessna 172S · S/N 172S10906
Back to Camden, SC