For reference, Air Canada would need to give ~91% raise to get pilot pay back in line with where Air Canada pilots were in 2001. Post 9/11 the pilots took a terrible ‘save the company from bankruptcy’ deal, then during negotiations in 2012 the government forced a return to work deal with another terrible pilot contract.
What you are looking for is a RAG and is one of the few legitimately useful implementations of LLMs outside the wall of hype.