OpenAirDocs.org
Union City, TN

Registered aircraft · 30

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 = 'TN' AND g.registrant_city = 'UNION CITY'
  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.

N1020QHughes 269A · S/N 115-0426Mike Rinker Aircraft LLCN10693Cessna 150L · S/N 15074978Built 1973 · Full Stop Aviation LLCN14HBMuhle Paul ACRO CUBBY · S/N 004PMBuilt 2009 · Mike Rinker Aircraft LLCN183BBCessna R182 · S/N R18200310Built 1978 · Russell Charles B DBAN2230TPiper PA-28-180 · S/N 28-7105189Built 1971 · White Pelican LLCN28PZNew Piper PA-32R-301T · S/N 3257418Built 2006 · Asa Obion LLCN35YYAmerican Eurocopter AS350B2 · S/N 4673Built 2009 · Mike Rinker Aircraft LLCN381RBeech 200 · S/N BB-385Built 1978 · Uc Aviation Holdings LLCN4294BBeech F35 · S/N D-4356Built 1955 · Full Stop Aviation LLCN4374QCessna 172L · S/N 17260274Built 1971 · Willaero LLCN452RXXag P100 PRO · S/N 821942509W9XXceed Ag LLCN452SXXag P100 PRO · S/N 8219425Q831FXceed Ag LLCN466CDCirrus Design SR22 · S/N 1466Built 2005 · Asa Obion LLCN5195FAir Tractor AT-502B · S/N 502B-0552Russell Charles BN5517SCessna 188 · S/N 188-0017Built 1966 · Russell Charles BN595THall Thomas E RV-8 · S/N 82823Built 2020 · Hall Thomas EN600ZEGrumman G-21A · S/N B-100Built 1943 · Mike Rinker Aircraft LLCN6024WPiper PA-28-140 · S/N 28-20024Built 1964 · White Pelican LLCN613NWaco CTO · S/N 3047Built 1929 · Mike Rinker Aircraft LLCN668KCNew Piper PA-46-500TP · S/N 4697268Built 2006 · John A Lester LLCN70592I.C.A.-Brasov IS-28B2 · S/N 73Built 1977 · Russell Larry BN7225YPiper PA-30 · S/N 30-248Built 1964 · Twin Cam Holdings LLCN726DWStutes Dennis W LANCAIR LEGACY · S/N L2K-261Built 2006 · Mike Rinker Aircraft LLCN736FSCessna R172K · S/N R1722497Built 1977 · Russell Larry B DBAN759JNCessna 182Q · S/N 18266032Built 1977 · Mike Rinker Aircraft LLCN777NLCirrus Design SR22 · S/N 2885Built 2007 · Orthoair LLCN7798SSchweizer SGS 1-26D · S/N 458First renewal noticeBuilt 1969 · Russell Larry BN8579NPiper PA-28-180 · S/N 28-7105133Built 1971 · Willaero LLCN87BACessna S550 · S/N S550-0131Built 1987 · Uc Aviation Holdings LLCN90TNNiemyjski Trevor G CLIP T · S/N 001Built 2015 · Mike Rinker Aircraft LLC
Back to Union City, TN