which adapter to use to transfer photos from iPad Air 4th to MacBook Air 2017

One option: https://www.apple.com/shop/product/HN892ZM/A/mophie-usb-a-cable-with-usb-c-connector-1-m

You don't need to buy anything, just use AirDrop:

Use AirDrop on iPad to send items to nearby devices - Apple Support

I do it with my iPhone 11 Pro all the time.

i use a macally $7 usb c- to a adaptor often

just plug the chord that came with your iPad into the Macbook

'we can also use air drop, iCloud photos and a lightning use thumb drive as well

The cord that comes with an iPad Air 4 is a USB-C to USB-C cord and will not fit into a 2017 MacBook Air.