Show approach minimums

[andrewda]

It'd be nice to see the minimums for the approaches listed, and be able to filter based on ft above minimums (e.g. I only want to see approaches with at least 500 ft between ceiling and minimums). Need to figure out how we can find minimums in the CIFP data, and then correlate the minimums to the FAF based on approach ID.

[ammaraskar]

Heya, just stumbled upon this project. Just a heads up, the CIFP does not encode the minimums as per an aeronautical inquiry I sent to the FAA.

I'm actually working on a project here https://github.com/ammaraskar/faa-instrument-approach-db that will eventually output some json with the minimums and some other properties I'm interested in about approaches. (Approach angles, hold-in-lieus, procedure turns, DME arcs etc) for all the FAA approaches.

Eventually I plan on making a web viewer for it so you can view them all on a map and filter to ones nearby but it might also be handy for your project. I'll give you a heads up when the data is ready to consume.

[andrewda]

@ammaraskar thank you for sharing! I was actually looking into this the other day and came to the same conclusion, but hadn't considered parsing the chart files directly. Looking forward to hearing when you've got it working 😄

[ammaraskar]

Just made an initial release here: https://github.com/ammaraskar/faa-instrument-approach-db/releases/download/v0.0.1-beta/approaches.json

I'll set up a github workflow to release it with the dtpp and cifp cycles at some point. There's also some bugs that need fixing.

Some cool quick facts from the data:

• LDA RWY 26L at HNL (Daniel K. Inouye International Airport) has a 45 degree offset from the approach course to the runway!
• ILS Y or LOC Y RWY 20R at ENA (Kenai Mun, Alaska)'s missed approach requires a fairly high 800 per NM climb gradient (1200ft/min at 90kts).