Huntington, IN
Registered aircraft · 48
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 = 'HUNTINGTON' 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 = 'HUNTINGTON' 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.
N1047CNorth American SNJ-5 · S/N 85063N121GHPiper PA-32R-300 · S/N 32R-7780262N122FSS C Aerostar S A YAK-52TW · S/N 0312408N137DCessna 310R · S/N 310R2136N1411UCessna 172M · S/N 17267080N141ZABeech E18S · S/N BA-178N1812LBeech V35B · S/N D-9875N20WPBeech C90 · S/N LJ-738N22310Cessna 150H · S/N 15068210N305ABCessna 305A · S/N 21290N3121BPiper J5A · S/N 5-314N314MRBeech E-90 · S/N LW-184N3287DJI T50 · S/N 63YBM4L002007UN33644Douglas DC3 · S/N 4123N3931RNorth American AT-6 · S/N 84-923N41600Air Tractor AT-602 · S/N 602-1187N4171AGrumman TBM-3E · S/N 91521N4481FDJI AGRAS T50 · S/N 1581F6BUB246Q0015H00N4482FDJI AGRAS T50 · S/N 1581F6BUB248U0018625N4487FDJI AGRAS T50 · S/N 1581F6BUB248U001W4J8N448SMAeroprakt Mfg SP Z O O A32 · S/N 306N46026Aeronca 0-58B · S/N 058B13394N47237Aeronca 0-58B · S/N 0-58B-9783N49555Taylorcraft L-2M · S/N L5667N5050CDehavilland TIGER MOTH DH 82A · S/N NL875N515SANorth American AT-6D · S/N 8814953N529UFDJI AGRAS T100 · S/N 1581F8ZLC257B0023P11N5336CCessna 310R · S/N 310R1542N583GFDJI AGRAS T100 · S/N 1581F8ZLC257B002C1N2N58894Fairchild M-62A-3 · S/N FT-737N6209XCessna 310R · S/N 310R1339N62466Douglas EA-1E · S/N 135178N642KAAir Tractor AT-602 · S/N 602-1212N6536DJI AGRAS T30 · S/N 3U4DKDU0011QDEN653YAEa Vision J-150 · S/N JMZKJ150UAV602595399N6833FPiper PA-28-181 · S/N 28-7790166N701KKeith R Paterson/Claudia Pater STOL CH 701 · S/N 7-4579N712AWNorth American SNJ-4 · S/N 27222N715AWNorth American SNJ-5 · S/N 84868N740PNCurtiss Wright P40N-1CU · S/N 42-104827N76BWBraungart-Whitehead-Mcgrew BREEZY PUSHER · S/N 1976-1N7757Canadian Car & Foundry HARVARD MK IV · S/N CCF4-171N9119New Standard D-25 · S/N 143N914CMMyers Dallas S6S · S/N 079913275N94313Engineering & Research ERCOUPE 415-C · S/N 1536N97257Cessna 182Q · S/N 18267037N98057Piper J3C-65 · S/N 18206N99734Engineering & Research ERCOUPE 415-C · S/N 2357
Back to Huntington, IN