Anderson, IN
Registered aircraft · 44
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 = 'ANDERSON' 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 = 'ANDERSON' 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.
N110VCPete Bitar ELEC JETBIKE VERTICY · S/N VC00001N1124UMooney M20J · S/N 24-1339N128SSBurkhart Grob Flugzeugbau G102 ASTIR CS · S/N 1211N1576DCessna 195A · S/N 7798N15APCessna 182P · S/N 18264944N161SSBurkhart Grob Flugzeugbau SPEED ASTIR II · S/N 4009N200SFPiper PA-32RT-300 · S/N 32R-7985034N24157Funk B85C · S/N 183N2811NCessna 140 · S/N 13072N2848NCessna 140 · S/N 13108N30680Cessna 177B · S/N 17701401N330VCPete Bitar ELEC JETBIKE VERTICY · S/N VCMK30001N3543CCessna 170B · S/N 26586N3865SCessna 172E · S/N 17251065N386SAVashon RANGER R7 · S/N 10204N38VLDallas Jimmie JR VELOCITY · S/N 11N423RVWoodrum Charles Dana RV-4 · S/N 1023N44381Taylorcraft BC12-D · S/N 10181N4487EAeronca 7DC · S/N 7DC-72N5227LPiper PA-28-180 · S/N 28-4521N5499FPiper PA-28-181 · S/N 28-7790127N5522DBeech H35 · S/N D-5057N6177FBuckeye BREEZE · S/N 16253N68974Boeing PT-13D · S/N 75-5076N69DLMooney M20J · S/N 24-0363N69NBJantzi Terrance RV-6 · S/N 21084N7000WPiper PA-28-180 · S/N 28-671N7003ECessna 175A · S/N 56503N7045NBeech V35A · S/N D-8633N709LMCowger Michael J SONEX · S/N 1216N72692Cessna 206H · S/N 20608139N73PRIndy Air Sales CCK-1865 · S/N CCK-1865-1105N7609NBeech D55 · S/N TE-747N76ZNavion NAVION A · S/N NAV-4-685N7732CCarnes Donald W PIPISTRELSINUS912KIT · S/N 276 S KIT 49 USAN7911BCessna 172 · S/N 29711N8029GCessna 177RG · S/N 177RG0029N8229XCessna 172B · S/N 17248729N8247DBeech J35 · S/N D-5347N8381PPiper PA-24-250 · S/N 24-3640N8393NBeech V35A · S/N D-8776N847RSRichard R Saliers VANS ACFT RV-9A · S/N 92212N932WTWilliam L Mount RV9A · S/N 90747N9YTBeech A36 · S/N E-3125
Back to Anderson, IN