# Registered aircraft: Union City, TN

A list on [Union City, TN](https://openairdocs.org/faa-place/TN/Union%20City.md).

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

- [N1020Q](https://openairdocs.org/aircraft/N1020Q.md): Hughes 269A · S/N 115-0426 · Mike Rinker Aircraft LLC
- [N10693](https://openairdocs.org/aircraft/N10693.md): Cessna 150L · S/N 15074978 · Built 1973 · Full Stop Aviation LLC
- [N14HB](https://openairdocs.org/aircraft/N14HB.md): Muhle Paul ACRO CUBBY · S/N 004PM · Built 2009 · Mike Rinker Aircraft LLC
- [N183BB](https://openairdocs.org/aircraft/N183BB.md): Cessna R182 · S/N R18200310 · Built 1978 · Russell Charles B DBA
- [N2230T](https://openairdocs.org/aircraft/N2230T.md): Piper PA-28-180 · S/N 28-7105189 · Built 1971 · White Pelican LLC
- [N28PZ](https://openairdocs.org/aircraft/N28PZ.md): New Piper PA-32R-301T · S/N 3257418 · Built 2006 · Asa Obion LLC
- [N35YY](https://openairdocs.org/aircraft/N35YY.md): American Eurocopter AS350B2 · S/N 4673 · Built 2009 · Mike Rinker Aircraft LLC
- [N381R](https://openairdocs.org/aircraft/N381R.md): Beech 200 · S/N BB-385 · Built 1978 · Uc Aviation Holdings LLC
- [N4294B](https://openairdocs.org/aircraft/N4294B.md): Beech F35 · S/N D-4356 · Built 1955 · Full Stop Aviation LLC
- [N4374Q](https://openairdocs.org/aircraft/N4374Q.md): Cessna 172L · S/N 17260274 · Built 1971 · Willaero LLC
- [N452RX](https://openairdocs.org/aircraft/N452RX.md): Xag P100 PRO · S/N 821942509W9X · Xceed Ag LLC
- [N452SX](https://openairdocs.org/aircraft/N452SX.md): Xag P100 PRO · S/N 8219425Q831F · Xceed Ag LLC
- [N466CD](https://openairdocs.org/aircraft/N466CD.md): Cirrus Design SR22 · S/N 1466 · Built 2005 · Asa Obion LLC
- [N5195F](https://openairdocs.org/aircraft/N5195F.md): Air Tractor AT-502B · S/N 502B-0552 · Russell Charles B
- [N5517S](https://openairdocs.org/aircraft/N5517S.md): Cessna 188 · S/N 188-0017 · Built 1966 · Russell Charles B
- [N595T](https://openairdocs.org/aircraft/N595T.md): Hall Thomas E RV-8 · S/N 82823 · Built 2020 · Hall Thomas E
- [N600ZE](https://openairdocs.org/aircraft/N600ZE.md): Grumman G-21A · S/N B-100 · Built 1943 · Mike Rinker Aircraft LLC
- [N6024W](https://openairdocs.org/aircraft/N6024W.md): Piper PA-28-140 · S/N 28-20024 · Built 1964 · White Pelican LLC
- [N613N](https://openairdocs.org/aircraft/N613N.md): Waco CTO · S/N 3047 · Built 1929 · Mike Rinker Aircraft LLC
- [N668KC](https://openairdocs.org/aircraft/N668KC.md): New Piper PA-46-500TP · S/N 4697268 · Built 2006 · John A Lester LLC
- [N70592](https://openairdocs.org/aircraft/N70592.md): I.C.A.-Brasov IS-28B2 · S/N 73 · Built 1977 · Russell Larry B
- [N7225Y](https://openairdocs.org/aircraft/N7225Y.md): Piper PA-30 · S/N 30-248 · Built 1964 · Twin Cam Holdings LLC
- [N726DW](https://openairdocs.org/aircraft/N726DW.md): Stutes Dennis W LANCAIR LEGACY · S/N L2K-261 · Built 2006 · Mike Rinker Aircraft LLC
- [N736FS](https://openairdocs.org/aircraft/N736FS.md): Cessna R172K · S/N R1722497 · Built 1977 · Russell Larry B DBA
- [N759JN](https://openairdocs.org/aircraft/N759JN.md): Cessna 182Q · S/N 18266032 · Built 1977 · Mike Rinker Aircraft LLC
- [N777NL](https://openairdocs.org/aircraft/N777NL.md): Cirrus Design SR22 · S/N 2885 · Built 2007 · Orthoair LLC
- [N7798S](https://openairdocs.org/aircraft/N7798S.md): Schweizer SGS 1-26D · S/N 458 · First renewal notice · Built 1969 · Russell Larry B
- [N8579N](https://openairdocs.org/aircraft/N8579N.md): Piper PA-28-180 · S/N 28-7105133 · Built 1971 · Willaero LLC
- [N87BA](https://openairdocs.org/aircraft/N87BA.md): Cessna S550 · S/N S550-0131 · Built 1987 · Uc Aviation Holdings LLC
- [N90TN](https://openairdocs.org/aircraft/N90TN.md): Niemyjski Trevor G CLIP T · S/N 001 · Built 2015 · Mike Rinker Aircraft 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 = 'TN' AND g.registrant_city = 'UNION CITY'
ORDER BY g.n_number
```

This list as a web page: https://openairdocs.org/faa-place/TN/Union%20City/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, except the copies of manufacturers’ service documents, which belong to their rights holders.