Terre Haute, IN
Registered aircraft · 86
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 = 'TERRE HAUTE' 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 = 'TERRE HAUTE' 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.
N1036UMooney M20J · S/N 24-3386N138TTPilatus PC-12/47E · S/N 2192N152RACessna 152 · S/N 15279562N1543RGrumman American Avn. AA-5B · S/N AA5B-0043N1643RGrumman American Avn. AA-1B · S/N AA1B0643N1656RCessna R182 · S/N R18200498N169TTPilatus PC-24 · S/N 585N20060Cessna 172M · S/N 17260972N2040LLake LA-4 · S/N 373N2133JPiper PA-28-181 · S/N 28-7990217N214ESCessna 182E · S/N 18253673N2208APiper PA-32RT-300 · S/N 32R-7985005N252MEMooney M20K · S/N 25-1025N25948Cessna 152 · S/N 15280875N273DCDiamond Aircraft Ind DA20-C1 · S/N C0373N2972CPiper PA-28-161 · S/N 28-8016003N2QFCessna T337G · S/N P3370280N32460Comco Ikarus C 42 · S/N 0205-6487N3331RPiper PA-28-180 · S/N 28-5661N33WBPiper PA-32RT-300T · S/N 32R-7987056N34833Cessna 177B · S/N 17702032N350LBLindstrand Balloons 90A · S/N 5249N37JPVans RV-12 · S/N 120176N3833TMooney M20TN · S/N 31-0108N391DCDiamond Aircraft Ind DA20-C1 · S/N C0191N394MKCirrus Design SR22 · S/N 4299N403AMDiamond Aircraft Ind DA20-C1 · S/N C0329N413ZMMooney M20K · S/N 25-2013N414JPiper J4A · S/N 41299N419DBHonda HA-420 · S/N 42000040N447SLXag P100 PRO · S/N 1863FPEG82193482S6L5N447TLXag P100 PRO · S/N 1863FPEG82193515D34MN45CLLittleton David A TWINSTAR · S/N 004N461THDiamond Aircraft Ind DA 42 · S/N 42.AC044N462THDiamond Aircraft Ind DA 40 · S/N 40.1056N4635LCessna 152 · S/N 15284201N463THDiamond Aircraft Ind DA 40 · S/N 40.1058N464THDiamond Aircraft Ind DA 40 · S/N 40.1052N465THDiamond Aircraft Ind DA 40 · S/N 40.879N475DCDiamond Aircraft Ind DA20-C1 · S/N C0475N492SBXag P150 · S/N 186324P1822350815UA6N5116NBuckeye Powered Parachutes DREAM MACHINE · S/N 3365N5117HPegasus QUANTUM 15-912 · S/N 7830N5175VAir Tractor AT-602 · S/N 602-0509N544KCDiamond Aircraft Ind DA20-C1 · S/N C0544N5456ECessna 182R · S/N 18268323N55AFPiper PA-32-260 · S/N 32-864Registration pendingN61WRDiamond Aircraft Ind DA20-C1 · S/N C0382N6216DThrush S2R-H80 · S/N H80-181N6216KThrush S2R-H80 · S/N H80-182
Back to Terre Haute, IN