How do I find out if a substantial completion has been filed on a job?
There's not usually a "public" substantial completion notice. That is especially true because some contracts have different definition of substantial completion. If it's a public project, you can maybe request any letters about it through the public records act.