Hopkinsville, KY
Registered aircraft · 38
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 = 'HOPKINSVILLE' 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 = 'HOPKINSVILLE' 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.
N153LGPilatus PC-12/47E · S/N 1420N1969GTucker Paul K XAIRS · S/N 679N21352Piper PA-32RT-300 · S/N 32R-7885252N2648WMooney M20E · S/N 981N306TVDJI AGRAS T50 · S/N 1581F6BUB235C00100CCN306UVDJI AGRAS T50 · S/N 1581F6BUB234700102AGN306VVDJI AGRAS T50 · S/N 1581F6BUB235400101LMN31388Piper PA-32-300 · S/N 32-7840128N3256KGlobe GC-1B · S/N 1249First renewal noticeN325FJPiper PA-31-325 · S/N 31-7812007Sale reportedN332PVDJI AGRAS T40 · S/N 1581F574B226H00103MTN332QVDJI AGRAS T40 · S/N 1581F574B225M00100ASN332WVDJI FLYCART 30 · S/N 1581F7C6B243E001319GN332ZVDJI FLYCART 30 · S/N 1581F7C6B243E001V2QJN3873MPiper PA-28R-201T · S/N 28R-7803198N4779MEdwin Miller CALIDUS · S/N C00525N490MJDJI T50 · S/N 1581F680523C70C1T025N4ZFMagni Gyro M16 · S/N 16-07-4493N54474Piper PA-28-235 · S/N 28-7410046N55327Piper PA-28-180 · S/N 28-7305362N5846FPiper PA-28-181 · S/N 28-7790138N5874BCessna 182A · S/N 33874N616JEEstes Austin L S-7S · S/N 0903349-SN618XRRaj Hamsa Ultralights X-AIR STANDARD · S/N 835N6322LAmerican AA-1A · S/N AA1A-0342N696WHRaytheon A36 · S/N E-3048N697WHPiper PA-31-350 · S/N 31-8352008N7004LAir Creation BUGGY · S/N T01030N708CGSocata TBM 700 · S/N 220N7117WPiper PA-28-180 · S/N 28-908N714AZCessna 150M · S/N 15079039N714RFCessna 150M · S/N 15079369N7150PPiper PA-24-250 · S/N 24-2315N7167ACessna 172 · S/N 29267N857BHHester Bobby R JR RV-7A · S/N 70172N8928SCessna 150F · S/N 15062228N984SMPaul Laurin SINUS 912 · S/N 611 SFN 912N999YSDJI AGRAS T40 · S/N 64TBK8F001001G
Back to Hopkinsville, KY