# Registered aircraft: Kingstree, SC

A list on [Kingstree, SC](https://openairdocs.org/faa-place/SC/Kingstree.md).

Aircraft may not be kept in the town where they are registered. This site does not publish owners’ street addresses.

- [N2047V](https://openairdocs.org/aircraft/N2047V.md): Air Tractor AT-402B · S/N 402B-1253 · Built 2012 · Williamsburg Air Service Inc
- [N2070U](https://openairdocs.org/aircraft/N2070U.md): Bell Helicopter Textron 206L-1 · S/N 45706 · Aero-Tech Helicopters LLC
- [N2330J](https://openairdocs.org/aircraft/N2330J.md): Cessna T188C · S/N T18803455T · Built 1979 · Williamsburg Air Service Inc
- [N239BH](https://openairdocs.org/aircraft/N239BH.md): DJI AGRAS T40 · S/N 64TBL5F002008R · Highwater Drone Services LLC
- [N247LF](https://openairdocs.org/aircraft/N247LF.md): Air Tractor AT-502A · S/N 502A-3395 · Built 2022 · Williamsburg Air Service Inc
- [N3070G](https://openairdocs.org/aircraft/N3070G.md): Air Tractor AT-402B · S/N 402B-1303 · Built 2013 · Williamsburg Air Service Inc
- [N3089H](https://openairdocs.org/aircraft/N3089H.md): Beech F33A · S/N CE-1219 · Built 1988 · Williamsburg Air Service Inc
- [N348CP](https://openairdocs.org/aircraft/N348CP.md): Cessna 172R · S/N 17280348 · Built 1998 · Haddock Tracey P
- [N3599D](https://openairdocs.org/aircraft/N3599D.md): Aerospatiale SA315B · S/N 2579 · Built 1979 · Aero Tech Helicopters LLC
- [N451MC](https://openairdocs.org/aircraft/N451MC.md): Hughes 269C · S/N 340287 · Aero-Tech Helicopters LLC
- [N457MC](https://openairdocs.org/aircraft/N457MC.md): Bellanca 7KCAB · S/N 466-74 · Built 1974 · Boguy Air LLC
- [N4691P](https://openairdocs.org/aircraft/N4691P.md): Piper PA-23-250 · S/N 27-220 · Built 1960 · Williamsburg Air Service
- [N61NR](https://openairdocs.org/aircraft/N61NR.md): Bell 206B · S/N 689 · Built 1971 · Aero Tech Helicopters LLC
- [N62787](https://openairdocs.org/aircraft/N62787.md): Piper PA-23-250 · S/N 27-7754024 · Built 1977 · Williamsburg Air Service Inc
- [N8015G](https://openairdocs.org/aircraft/N8015G.md): Air Tractor AT-502A · S/N 502A-3301 · Built 2021 · Williamsburg Air Service Inc
- [N80CB](https://openairdocs.org/aircraft/N80CB.md): Hiller UH-12E · S/N 5048 · Aero-Tech Helicopters LLC
- [N91013](https://openairdocs.org/aircraft/N91013.md): Stinson L-5 · S/N 76-555 · Built 1943 · Buckner Bobby N
- [N9306J](https://openairdocs.org/aircraft/N9306J.md): Piper PA-28-180 · S/N 28-3398 · Built 1966 · Hanna Jr Charles W
- [N961QA](https://openairdocs.org/aircraft/N961QA.md): DJI AGRAS T40 · S/N 64TBK5J001002F · Aero Tech Helicopters LLC
- [N9903U](https://openairdocs.org/aircraft/N9903U.md): Beijing TT Avn Tech G200 · S/N G20267 · U & B Aquatics LLC

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 = 'KINGSTREE'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/SC/Kingstree/aircraft

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.