# Registered aircraft: North Augusta, SC

A list on [North Augusta, SC](https://openairdocs.org/faa-place/SC/North%20Augusta.md).

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

- [N16HP](https://openairdocs.org/aircraft/N16HP.md): Air Creation GTE 582S · S/N 91440 · Built 1996 · Prescott Paul H
- [N2170R](https://openairdocs.org/aircraft/N2170R.md): Piper PA-28-180 · S/N 28-5753 · Built 1970 · Kotz Dennis M
- [N227HP](https://openairdocs.org/aircraft/N227HP.md): Harden Gary RV9A · S/N 90760 · Built 2008 · Britt Joseph A
- [N2573D](https://openairdocs.org/aircraft/N2573D.md): Blaser Robert H RANS S-12XL · S/N 03000911 · Coenen Lance G
- [N41HB](https://openairdocs.org/aircraft/N41HB.md): American AA-1 · S/N AA1-0277 · Built 1969 · Walsh Bowen S
- [N5259C](https://openairdocs.org/aircraft/N5259C.md): Mooney M20J · S/N 24-3094 · Mcsorley John A
- [N5530J](https://openairdocs.org/aircraft/N5530J.md): Piper PA-32-260 · S/N 32-992 · Built 1967 · Sellers Justin Kennedy
- [N6435R](https://openairdocs.org/aircraft/N6435R.md): Piper PA-28-140 · S/N 28-21616 · Built 1966 · Spears Travis L
- [N7186X](https://openairdocs.org/aircraft/N7186X.md): Cessna 150A · S/N 15059286 · Smith Calvin E
- [N7215S](https://openairdocs.org/aircraft/N7215S.md): Cessna 150H · S/N 15067915 · Built 1967 · Hitt Bruce A
- [N7351H](https://openairdocs.org/aircraft/N7351H.md): Piper J3C-65 · S/N 20610 · Built 1946 · Walsh Bowen S
- [N742CA](https://openairdocs.org/aircraft/N742CA.md): Columbia Aircraft Mfg LC42-550FG · S/N 42544 · Built 2007 · Eagle Talon Inc
- [N79191](https://openairdocs.org/aircraft/N79191.md): Cessna 172K · S/N 17257947 · Built 1969 · Kirkland Patrick C Sr
- [N821T](https://openairdocs.org/aircraft/N821T.md): Diamond Aircraft Ind DA 40 · S/N 40.1154 · Built 2012 · Colquhoun Steven
- [N87034](https://openairdocs.org/aircraft/N87034.md): Ercoupe 415-C · S/N 207 · Built 1945 · Prescott Paul H
- [N973L](https://openairdocs.org/aircraft/N973L.md): Costruzioni Aeronautiche Tecna P2004 BRAVO · S/N 118 · Built 2007 · Prescott Paul H
- [N98377](https://openairdocs.org/aircraft/N98377.md): Piper PA-28-140 · S/N 28-26198 · Built 1969 · Sloan Allen Lee

## 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 = 'NORTH AUGUSTA'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/SC/North%20Augusta/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.