Indianapolis, IN
Registered aircraft · 450
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 = 'INDIANAPOLIS' 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 = 'INDIANAPOLIS' 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.
N1007BBrock L Aldrich SUBSONEX · S/N JSX0024N101WHHeiden William F CHRISTEN EAGLE II · S/N HEIDEN-CHRISTENN102TDGulfstream Aerospace GV-SP (G550) · S/N 5515N102VPCessna 560 · S/N 560-0629N1031VCessna TU206F · S/N U20602409N107TDGulfstream Aerospace G-IV · S/N 1355N10DTThompson SKYBOLT · S/N TSB-1N111FBPiper PA-28R-200 · S/N 28R-7335310N111JCPhantom Aeronautics X-1 · S/N 94-0143N11245Waco RNF · S/N 3405N1139LPiper PA-32R-301T · S/N 32R8029091N113DNDJI INSPIRE 1 · S/N W130CA13020063N113JAJames P Aikman G2SA-2 · S/N AA0043N115TWPiper PA-28-181 · S/N 28020133N115WDBeech E-55 · S/N TE-863N116VBBalony Kubicek Spol Sro BB30Z · S/N 1670N1174VBeech D17S · S/N 6892N118APPilatus PC-12/45 · S/N 175N11MNCessna 500 · S/N 500-0266N11SBPiper PA-31-325 · S/N 31-7612062N1267ZBeech N35 · S/N D-6707N127LAerofab LAKE SEAWOLF · S/N 127N12KSBeech E-55 · S/N TE-1005N13327Cessna 172M · S/N 17262672N133LCAmerican Legend AL3 · S/N AL-1078N144WARobinson Helicopter R44 II · S/N 14216N145EXCameron Balloons ZL-77 · S/N 6680N145SCBeech SNB-1 · S/N 3906N1490GBeech 35-B33 · S/N CD-476N149ZBBowman Brice R RV-9A · S/N 90620N1510BKubicek Factory S R O BB37Z · S/N 2585N151VUCessna 172RG · S/N 172RG0667N1522MBoeing E75 · S/N 75-8343N1522XPiper PA-28R-200 · S/N 28R-7535308N152KVCessna 525 · S/N 525-0152N154CAPiper PA-31T · S/N 31T-8020085N157WMPiper PA-44-180 · S/N 4496157N158WUPiper PA-44-180 · S/N 4496158N16015Cessna 150L · S/N 15073413N16104Stinson SR-7C · S/N 9663N172RSCessna 172C · S/N 17248893N17489Dehavilland DH82A · S/N A17-489N175HGLearjet 45 · S/N 541N17679Beech D17S · S/N 6911N17985Beech D17S · S/N 4807N17CSorrell Nieuport 17C · S/N 1N1859WBeech V35B · S/N D-9503N187THCzech Aircraft Works Spol Sro SPORTCRUISER · S/N 07SC036N188LWaco Classic YMF-F5C · S/N F5C-8-136N191LLEurocopter Deutschland MBB-BK 117 C-2 · S/N 9319
Back to Indianapolis, IN