Richmond, KY
Registered aircraft · 62
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 = 'RICHMOND' 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 = 'RICHMOND' 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.
N101KUMooney M20J · S/N 24-0778N1025TRoger Thorstad/Brad Thorstad KOLB TWINSTAR MARK 3 · S/N M3X20-4-00116N112PFCessna 172R · S/N 17280400N126SMCessna 150J · S/N 15070492N1475LBeech A23 · S/N M-871N159FSCessna 172R · S/N 17280816N1QPCessna 182P · S/N 18261605N2357HEngineering & Research 415-D · S/N 2982N24WFGrumman American Avn. AA-5 · S/N AA5-0684N258BWCessna 172P · S/N 17274811N280MECessna 172S · S/N 172S8536N302CFCessna 172R · S/N 17281137N3125GPiper PA-44-180 · S/N 4496214N322WYAviat A-1C-180 · S/N 3222N333ALSteiner KOLB MARK III · S/N M3-150N338JRRowe Jason Lee RV-7A · S/N 71749N3547FCessna 172S · S/N 172S8887N364MMDJI AGRAS T30 · S/N 527BK4Q001002LN381CSSpoke Craig A MARK 3 XTRA · S/N M3X6-2-00080N3901RCessna 172H · S/N 17255401N392RMMarques FLY BABY 1-A · S/N 717N40489Robinson Helicopter R44 · S/N 30113N41912Cessna 172R · S/N 17280628N431MJMooney M20R · S/N 29-0491N435BEBuckeye BREEZE · S/N 16373N504MACessna 172P · S/N 17275917N511SPBeech A36 · S/N E-910N5173VCessna 172S · S/N 172S9046N52208Cessna 172S · S/N 172S9208N5439KCessna 172P · S/N 17274110N565RBPiper PA-44-180 · S/N 4496307N6111TCessna 150E · S/N 15060811N61565Cessna 172M · S/N 17264643N61622Cessna 172M · S/N 17264681N6298UBeech F33A · S/N CE-995N63569Cessna 172P · S/N 17275452N667SRCirrus Design SR22 · S/N 2838N67STBeech 35-C33 · S/N CD-1069N6833LCessna 310R · S/N 310R2125N70095Cessna 172M · S/N 17267192N713BJCessna 172 · S/N 46696N722MCRobinson Helicopter R22 BETA · S/N 2374N727DTRobinson Helicopter R44 · S/N 30019N741WBCessna 172S · S/N 172S11571N746DWCessna 172S · S/N 172S11569N7720YPiper PA-44-180 · S/N 4496132N7727Carden Gene H TITAN TORNADO 912 · S/N D95912SOHK0186N8043URobinson Helicopter R22 BETA · S/N 1062N8629YPiper PA-30 · S/N 30-1770N870SPCessna 172S · S/N 172S8130
Back to Richmond, KY