OpenAirDocs.org
Frankfort, KY

Registered aircraft · 47

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 = 'FRANKFORT'
  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.

N10SPBell 206L-3 · S/N 51064Built 1983 · State Of KentuckyN11253Waco ASO · S/N 3212Built 1931 · Patterson John Miles IIN1334FCessna 172G · S/N 17254829Built 1966 · Hamilton Alathea LN148KYBell 206B · S/N 1795Built 1975 · Commonwealth Of KentuckyN15770Piper PA-28-140 · S/N 28-7325159Built 1972 · Collett PalmerN162KTPhillips Kevin R EXEC 162F · S/N 6999Built 2011 · Phillips Kevin RN220SPBell OH-58A · S/N 71-20452Kentucky State PoliceN2275DCessna 170B · S/N 20427Built 1952 · Jordan Ken WN235JRAlbastar AS-15 FES · S/N 003Built 2025 · Hayes StevenN25BNWsk-Pzl-Mielec TS-11 ISKRA · S/N 3H 1205Tufair LLCN282SPBell OH-58A · S/N 72-21157Kentucky State PoliceN283SPBell OH-58A · S/N 71-20352Kentucky State PoliceN284SPBell 407 · S/N 53655Built 2005 · Kentucky State PoliceN285SPBell Textron Canada 429 · S/N 57546Built 2025 · Kentucky State PoliceN2CFCessna 340A · S/N 340A0319Kentucky Aviation Solutions LLCN3012APiper PA-28-181 · S/N 28-7990112Built 1978 · Bottoms Engineering & Service IncN36038Taylorcraft BC12-65 · S/N 3003Roberts Billie JN36SPGates Learjet 35A · S/N 577Built 1985 · Kentucky State PoliceN3KYBell 206L-3 · S/N 51113First renewal noticeCommonwealth Of KentuckyN421SPMD Helicopters 369FF · S/N 0714FFBuilt 2008 · Kentucky State PoliceN428RCCarlson Robert L ZODIAC 601XL · S/N 6-5332Carlson Robert LN45SPBell UH-1H · S/N 70-16413Kentucky State PoliceN467GRRoach Gene T ACRO SPORT I · S/N 892Roach Gene TN46SPHughes OH-6A · S/N 1280950Built 1968 · Kentucky State PoliceN470LBArbc Inc DBA Lindstrand 90A · S/N 5326Built 2006 · Stevenson Frank WN4850EChampion 7GC · S/N 7GC-47Built 1959 · Gibson Timothy AN50124Head Balloons AX8-88 · S/N 470Built 2019 · Stevenson Frank WN512LMPegasus QUANTUM 15 · S/N 7585Marshall Adam JN51608Cessna R172E · S/N R1720255Built 1967 · Commonwealth Of KentuckyN525WFCessna 525 · S/N 525-0246Built 1998 · Kentucky Aviation Solutions LLCN53KGTextron B300 · S/N FL-1246Built 2021 · Kentucky State PoliceN5416QCessna 150L · S/N 15073316Sharp Jacob TN57KYTextron G36 · S/N E-4154Built 2023 · Patterson John MN629CACentrair 101A · S/N 101A0088Built 1983 · Hayes Steven RN632TKCessna 182T · S/N 18282188Built 2009 · Kentucky State PoliceN7061QCessna 172L · S/N 17260361Built 1972 · Mccutcheon Henry CN7163UMooney M20C · S/N 2745Built 1964 · Patterson John M IIN723KYPiper PA-31-350 · S/N 31-7852122Built 1978 · Commonwealth Of KentuckyN7260HCessna 182S · S/N 18280896Built 2000 · N2617f LLCN82KYCessna 182Q · S/N 18267092Kentucky Department Of AviationN84169Cessna 172K · S/N 17258363Roach Gene TN89581Cessna 140 · S/N 8624Built 1946 · Roberts Billie JN90632Aerostar International RAVEN S49A · S/N S49A-3155Built 1993 · Stevenson Frank WN984KTGlenn W Anderson FX-61 · S/N 001Kentucky Transportation CabinetN986KTGlenn W Anderson M680-4 · S/N 001Kentucky Transportation CabinetN987KTGlenn W Anderson M680-4 · S/N 002Kentucky Transportation CabinetN994DMMaxwell Douglas KITFOX IV · S/N 1403Built 1995 · Sudduth Norton
Back to Frankfort, KY