OpenAirDocs.org
Maysville, KY

Registered aircraft · 19

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

N130MMPiper PA-30 · S/N 30-550Built 1964 · Mighty Mike LLCN1310FCessna 172G · S/N 17254805Built 1966 · Humphries Aviation LLCN13662Cessna 172M · S/N 17262922Built 1974 · Grutza Robert JN251CXGignac Raymond E THATCHER CX4 · S/N 012160Built 2013 · C&L Aviation LtdN269RDCessna 172F · S/N 17252737Humphries Aviation LLCN3754WPiper PA-32-260 · S/N 32-669Built 1966 · Ham Aviation LLCN469KEAndrew B Maitland ELIZABETH ANN BIPLAN · S/N 001Built 2014 · C&L Aviation LtdN486Reynolds Robert H STLP STDSTR II SA300 · S/N 1678Hagg Jeffrey DN611RTCirrus Design SR22 · S/N 2523Built 2007 · Grutza Robert JN6430LAmerican AA-1A · S/N AA1A-0430Sale reportedN67JSSelcher SPORT BIPLANE · S/N JS1C&L Aviation LtdN6833JPiper PA-28-140 · S/N 28-7625244Built 1976 · Humphries Aviation LLCN6904JPiper PA-28-181 · S/N 28-7690426Built 1976 · Glass Michael CN75WTTomak WICHAWK · S/N 82C&L Aviation LtdN7789MMooney M20C · S/N 20-0023Built 1974 · Ripato Peter AN9269EMaule M-5-235C · S/N 7263CHagg Jeffrey DN9343LAmerican AA-1A · S/N AA1A-0043C&L Aviation LtdN9572RBeech M35 · S/N D-6164Built 1959 · Thompson Charles RN991CCCook Rola A II SONEX · S/N 0991C&L Aviation Ltd
Back to Maysville, KY