Sellersburg, IN
Registered aircraft · 40
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 = 'IN' AND g.registrant_city = 'SELLERSBURG' 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 = 'IN' AND g.registrant_city = 'SELLERSBURG' 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.
N142HACessna 172M · S/N 17266306N148KAeropro CZ S R O A240 · S/N 51117N188HARaytheon 400A · S/N RK-164N198SBCessna 680 · S/N 680-0020N22316Mooney M20M · S/N 27-0276N2274BCessna 172R · S/N 17280689N255MECessna 182S · S/N 18280765N27HACessna T303 · S/N T30300064N28HACessna 172N · S/N 17271942N3676FNorth American SNJ-5 · S/N 51882N425NPCessna 425 · S/N 4250224N42ELRaytheon 390 · S/N RB-145N45JGLearjet 45 · S/N 272N47HARaytheon Corporate Jets HAWKER 800XP · S/N 258280N4856WRockwell International 114 · S/N 14186N497PFCessna 550 · S/N 550-0964N5072ZPiper PA-22-108 · S/N 22-8701N53HACessna 650 · S/N 650-7076First renewal noticeN55HACessna 172N · S/N 17269194N575HACessna 650 · S/N 650-7009N57HAGame Composites GB1 GAMEBIRD · S/N 0068N610CGBombardier BD-100-1A10 · S/N 20241N63HAAmerican Champion 8KCAB · S/N 1198-2022N64HARaytheon HAWKER 800XP · S/N 258448N6502CCameron Balloons US Z-77 · S/N 6576N679SSCameron Balloons US Z-105 · S/N 6462N686CCKentucky Pilots Assoc Edu Fndn CCK-1865 · S/N CCK-1865-1067N700JSCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC039N718KJCameron Balloons US Z-77 · S/N 6965N730HACessna 172M · S/N 17267246N73118Cessna 182P · S/N 18264122N781RSRobert Earl Semones JR VANS RV-8 · S/N 83046N789HARaytheon HAWKER 800XP · S/N 258354N83175Aeronca 7AC · S/N 7AC-1834N83HACessna 560 · S/N 5600487N83MLAgustawestland Philadelphia AW139 · S/N 41356N84PJDassault FALCON 2000EX · S/N 303N886YSCessna 550 · S/N 550-1013N928EFBeech 76 · S/N ME-136N949LTLincoln Taylor ZENITH STOL CH 750 · S/N 75-7984
Back to Sellersburg, IN