OpenAirDocs.org
Somerset, KY

Registered aircraft · 29

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 = 'KY' AND g.registrant_city = 'SOMERSET'
  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.

N17DFBell Textron Canada 407 · S/N 54922Df Aviation LLCN198BSPowrachute AIRWOLF 912ULS · S/N A138ULSBuilt 2010 · Smith Shannon MN221BGGarner Billy GARNER SNOBIRD · S/N G-1-001Built 2000 · Garner BillyN2415WDJI AGRAS T40 · S/N S8BBL6300166Warner FertilizerN3402RCessna 182L · S/N 18258702Built 1968 · Burton DarrellN35617Cessna 172I · S/N 17256865Britt David JN40858Piper PA-28-151 · S/N 28-7415102Built 1973 · Dicey Aviation LLCN414ATCessna 414A · S/N 414A0209Built 1978 · Creekmore ArnoldN419CTEmbraer Executive EMB-505 · S/N 50500889Built 2025 · Df Aviation LLCN4342KRyan NAVION · S/N NAV-4-1342Watson William JN521PFCessna 525 · S/N 525-0005Built 1993 · Alton Blakley Aviation IncN54396Piper PA-28-151 · S/N 28-7415055Built 1973 · Dicey Aviation LLCN580DMFX3 CCX-2000 · S/N CCX-2000-0052Built 2019 · Fx3 LLCN73387Cessna 172M · S/N 17267419Built 1976 · Bartley Darrell JrN735JGCessna 182Q · S/N 18265456Britt David JN7779CPiper PA-28-151 · S/N 28-7615063Built 1975 · Dicey Aviation LLCN778WFDJI T-30 · S/N 3V4DKDT0011QADWarner Fertilizer IncN782DPAirborne Windsports PTY EDGE XT-582-L · S/N XT-582-0023Built 2007 · Daulton StevenN79418Cessna 172K · S/N 17258069Built 1969 · Lee Steven WN8161DPiper PA-28-161 · S/N 28-8016220Built 1980 · Dicey Aviation LLCN830VPBell OH-58 · S/N 72-21268Pulaski County Sheriffs OfficeN830WKBell OH-58 · S/N 73-21900Pulaski County Sheriffs OfficeN8877YPiper PA-39 · S/N 39-34Built 1970 · Vanhook Orville RichardN9017HCessna 172M · S/N 17265901Built 1975 · Meece Harvey TN9180LBellanca 7ACA · S/N 38-72Poynter Everett BN927DBCirrus Design SR22 · S/N 4351Built 2016 · Brummett Enterprises Of Somerset LLCN9429BBarney Barnes PANTHER LS · S/N 064Built 2018 · Barnes Barney LN979CMMagni Partners GT-VX2 · S/N VX2-005Built 2024 · Fx3 LLCN993GMEmbraer Executive EMB-505 · S/N 50500695Built 2022 · Next Level Aviation LLC
Back to Somerset, KY