Registered aircraft · 17

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

Query with 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 = 'KY' AND g.registrant_city = 'VERSAILLES' ORDER BY g.n_number

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

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 = 'VERSAILLES'
ORDER BY g.n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N143LMMurphy Linda KITFOX III · S/N 1579Built 1992 · Basham John R N1695Brons Lawrence C RV-9A · S/N 91026Built 2007 · Mcvey Steven A N251PKBRM Aero S R O BRISTELL LSA · S/N 908/2026N251pk LLC N26471Grumman American Avn. AA-5A · S/N AA5A0615Built 1978 · N26471 LLC N2805MReed Jerry B 66 · S/N 001Murner Edward D N3102WBeech V35B · S/N D-9558Built 1973 · Bonanza Leasing LLC N3PUBoggess Donald BOGGESS N3-PUP · S/N 001Built 1994 · Boggess Roger M N40369Nanchang China CJ-6 · S/N 3732008Built 1982 · Kilroy Aviation LLC N4820JCessna T206H · S/N T20608052Built 1999 · Draper Aviation LLC N499JSMac Donald Brent L CHRISTEN EAGLE II · S/N MAC DONALD 0001Built 1985 · Shaw Raymond M N603EVEvektor-Aerotechnik SPORTSTAR · S/N 20060610Built 2006 · Mcmahon Arlynn N7461ACessna 172 · S/N 29561Built 1956 · Johnson Jeffrey M N852JNClose Jay G SONEX · S/N 0843Built 2017 · Close Jay G N9191PNanchang China CJ-6A · S/N 2751235Built 1970 · Kilroy Aviation LLC N9270MMooney M20E · S/N 1211Built 1966 · Mcmanus Nicholas A N9592UGrumman American Avn. AA-5A · S/N AA5A-0092Built 1976 · N9592u LLC N994QFDJI AGRAS T40 · S/N 64TBKAF00200LJDrone Agri Of Kentucky LLC

Back to Versailles, KY