Lexington, KY
Registered aircraft · 195
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 = 'LEXINGTON' 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 = 'LEXINGTON' 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.
N103AAAviat A-1B · S/N 2411N107GGBell 206B · S/N 2917N1089ERaytheon A36 · S/N E-3030N11456Waco RNF · S/N 3471N1240VCessna R172K · S/N R1722150N13100Cessna 172M · S/N 17262494N134CBBeech 56TC · S/N TG-40N136BDHenry Hollis B RV-8 · S/N 80264N13821Cessna 172M · S/N 17263015N146WWolfe Randy L SWICK T · S/N 001N150CCBofus CCX-1865 · S/N CCX-1865-0037N157BABeech A36 · S/N E-2339N161TFPiper PA-28-181 · S/N 2881549N1720BBoeing B75N1 · S/N 75-6017N173SKCessna 172N · S/N 17272108N18333Beech E-55 · S/N TE-1093N19380Cessna 150L · S/N 15074378N193AFRobinson Helicopter R66 · S/N 0264N1959NEmbraer Executive EMB-505 · S/N 50500466N197PWPzl-Swidnik PW-5 · S/N 1709004N1990KCameron Balloons US V-77 · S/N 5267N2018XCessna 182H · S/N 18256118N2027KDJI AGRAS T40 · S/N 64TBL2100201QTN2044SHead Balloons AX7-77 · S/N 403N204GRaytheon 58 · S/N TH-2042N20LCirrus Design SR22 · S/N 3195N213DSDiamond Aircraft Ind DA 40 · S/N 40.360N214RVAmateur Built Rv140359 VANS RV-14 · S/N 140359N2162DBeech D35 · S/N D-3509N216AMPiper PA-28-181 · S/N 2881092N221KPPatsey Kevin D RV-7 · S/N 70174N22792Cessna 150H · S/N 15068518N227JHCirrus Design SR22 · S/N 4237N232TFPiper PA-28-181 · S/N 2881550N235LERobinson Helicopter R44 II · S/N 14908N2453WSchweizer SGS 1-26B · S/N 368N252MBMooney M20K · S/N 25-1022N2638YCessna 310R · S/N 310R1667N273TYCessna 150E · S/N 15061468N274PGCirrus Design SR20 · S/N 1716N277CPPiper PA-28 · S/N 28-12N278SStringfellow James Mark RV-10 · S/N 40480N27MWMichael J Wright SA300 · S/N M001WN2804URaven S55A · S/N S55A-1089N3001WPiper PA-28-181 · S/N 28-7990356N30356Cameron Balloons US C-80 · S/N 6064N3049FCessna 182J · S/N 18257149N3092WBeech V35B · S/N D-9556N311MPDJI AGRAS T50 · S/N 1581F6BUB236S00100BWN312FCombs James Lee RV-10 · S/N 40192
Back to Lexington, KY