# Registered aircraft: Tea, SD

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

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

- [N169DR](https://openairdocs.org/aircraft/N169DR.md): Beech C90A · S/N LJ-1205 · Built 1989 · Legacy Aviation LLC
- [N16MR](https://openairdocs.org/aircraft/N16MR.md): Randall Marvin L VANS RV-3A · S/N 811-3 · Built 1988 · Vanguard Squadron Inc
- [N19EH](https://openairdocs.org/aircraft/N19EH.md): Ellingson Robert P JR VANS RV-3A · S/N 811-2 · Built 1985 · Vanguard Squadron Inc
- [N25RV](https://openairdocs.org/aircraft/N25RV.md): Ludtke E L/Skoglund C RV-3A · S/N 11086 · Built 1990 · Vanguard Squadron Inc
- [N28VF](https://openairdocs.org/aircraft/N28VF.md): Van Heuveln Le Mar RV-8 · S/N 80861 · Vanguard Squadron Inc
- [N34WC](https://openairdocs.org/aircraft/N34WC.md): Walling R A VANS RV-3A · S/N 811-4 · Built 1991 · Vanguard Squadron Inc
- [N35144](https://openairdocs.org/aircraft/N35144.md): Cessna 177B · S/N 17702230 · Hofer Chris A
- [N366GW](https://openairdocs.org/aircraft/N366GW.md): Beech E-90 · S/N LW-320 · Built 1979 · K&K Leasing Inc
- [N40557](https://openairdocs.org/aircraft/N40557.md): Piper PA-23-250 · S/N 27-7405297 · Built 1973 · Legacy Aviation LLC
- [N40J](https://openairdocs.org/aircraft/N40J.md): Integrated Systms Aero ENG OMEGA II · S/N 001 · Tav8rs LLC
- [N4460J](https://openairdocs.org/aircraft/N4460J.md): Cameron Balloons Z-90 · S/N 6214 · Built 1999 · Houser Taylor D
- [N5337Y](https://openairdocs.org/aircraft/N5337Y.md): Cessna T210N · S/N 21064171 · Built 1980 · Clement Aviation Inc
- [N5437F](https://openairdocs.org/aircraft/N5437F.md): Piper PA-28-151 · S/N 28-7715137 · Built 1976 · Legacy Aviation LLC
- [N548LC](https://openairdocs.org/aircraft/N548LC.md): Cessna 303 · S/N 303-00037 · K And L Management Inc
- [N55870](https://openairdocs.org/aircraft/N55870.md): Piper PA-28-180 · S/N 28-7305487 · Legacy Aviation LLC
- [N55JZ](https://openairdocs.org/aircraft/N55JZ.md): Steve Carlstrom MERLIN PSA · S/N HV-35 · Built 2018 · Tav8rs LLC
- [N611BD](https://openairdocs.org/aircraft/N611BD.md): Cessna 172M · S/N 17266692 · Clement Aviation Inc
- [N63242](https://openairdocs.org/aircraft/N63242.md): Cessna 180K · S/N 18052839 · Douglas Dustin D
- [N6944C](https://openairdocs.org/aircraft/N6944C.md): Piper PA-28-161 · S/N 28-7816442 · Built 1978 · Updraft Leasing LLC
- [N6GT](https://openairdocs.org/aircraft/N6GT.md): Wilts Gayle T RV-3A · S/N 811-1 · Built 1983 · Vanguard Squadron Inc
- [N79359](https://openairdocs.org/aircraft/N79359.md): Mooney M20E · S/N 569 · Built 1965 · Schultz Steven R
- [N802WC](https://openairdocs.org/aircraft/N802WC.md): William Cowden RV-8 · S/N 82408 · Built 2018 · Hrabe Daren L
- [N8621E](https://openairdocs.org/aircraft/N8621E.md): Piper PA-28-151 · S/N 28-7615143 · Built 1976 · Updraft Leasing LLC
- [N863SP](https://openairdocs.org/aircraft/N863SP.md): Cessna 172S · S/N 172S8122 · Built 1999 · Legacy Aviation 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 = 'SD' AND g.registrant_city = 'TEA'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/SD/Tea/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.