#!/usr/bin/env python

import gadfly

faa_db = gadfly.gadfly("FAA", "Gadfly_databases/FAA")
faa_cursor = faa_db.cursor()

faa_cursor.execute("""
	select
		location_identifier,
		associated_city_name,
		associated_state_post_office_code,
		reference_point_longitude,
		reference_point_latitude
	from 
		airports
	where
		associated_state_post_office_code = 'IN'
""")

for record in faa_cursor.fetchall():
	print record

faa_cursor.execute("""
	select
		*
	from approaches 
""")

#for record in faa_cursor.fetchall():
#	print record