Can anyone help with the attached OBD codes?

[Fruitwolf]

Can anyone help with the attached OBD codes? Curious if there’s known issues in 2016-2023 CX-9s. 114k miles

The check engine light will stay on a couple/three days then, stay off a few days. This has been going on for a couple months. The car idles/accelerates and drives perfectly. Thanks

 

[22GrayGhost]

Found the following on internet.

What are the possible causes of OBDII code P0507 in a Mazda?
- Common causes include a malfunctioning idle air control valve, vacuum leaks, throttle body issues, dirty or faulty Mass Air Flow (MAF) sensor, or a faulty Engine Control Module (ECM).

P0171 codes are possible
Intake air leaks
Faulty front heated oxygen sensor
Ignition misfiring
Faulty fuel injectors
Exhaust gas leaks
Incorrect fuel pressure
Lack of fuel
Faulty Mass Air Flow (MAF) sensor
Incorrect Positive Crankcase Ventilation (PCV) hose connection