Shelbyville, KY
Registered aircraft · 34
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 = 'SHELBYVILLE' 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 = 'SHELBYVILLE' 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.
N10610DJI MAVIC 3 · S/N 1581F5FJD239E00DGGE3N1148HAeronca 15AC · S/N 15AC-163N129NNRolladen Schneider LS-8A · S/N 8211N1873WBeech A60 · S/N P-231N248AVDJI INSPIRE 1 · S/N W13DCD10031589N2787UCessna 172D · S/N 17250387N2795QDJI AGRAS T40 · S/N 64TBL9D00200CSN299FRXag P100 PRO · S/N 821934510U8MN299HRXag P100 PRO · S/N 82193453T7R2N306MKGlasflugel H 301 LIBELLE · S/N 14N32179Waco UPF-7 · S/N 5811N35449Cessna 172I · S/N 17256774N3731BBeech 77 · S/N WA-143N3885SCessna 172E · S/N 17251085N393DSCirrus Design SR22 · S/N 9499N426DCConway Darryl M 3500 MOOSE · S/N SR169N4346NCessna 195 · S/N 7063N44467Taylorcraft BC12-D1 · S/N 10267N451RPPowrachute AIRWOLF 912ULS · S/N A161ULSN511RFPiper PA-28-180 · S/N 28-7105167N5567WPiper PA-28-180 · S/N 28-661N582EFMartin Edward H FIRE STAR II · S/N EHM-1N6429BCessna 172 · S/N 29629N680ATCessna 680 · S/N 680-0192N750TPThomas O Palmer II STOL CH 750 · S/N 75-7428N773WEllis Melvin RV9A · S/N 90664N7877LBeech 35-C33 · S/N CD-1058N80363Cessna 172M · S/N 17266551N82512Aeronca 7AC · S/N 7AC-1149N880MXChristen Darryl K GILES · S/N 002DCN890HNBell Textron Canada 505 · S/N 65721N92372Piper J3C-65 · S/N 16831N96662Taylorcraft BC12-D · S/N 8962N987EEslinger Carl RV-4 · S/N 01
Back to Shelbyville, KY