Index / Match with multiple possible results.

I have a database of part number, name, serial number and the same information for the part they are installed on.  I'm using an Index / Match setup to pull specifics out of the database but I have one part that exists four (4) times on an engine, all with the same name, same part number but different serial numbers.  If I try to do the Index / Match I end up with (as we all know) the first item it finds in the list four times... how do I get the information for items 2, 3 and 4 in the inquiry?

To pull the part number:

=INDEX(Data!A:A,MATCH(1,INDEX((Data!D:D=Query!$F$7)*(Data!B:B=Query!B8),,),0),0)

           part # list                       part it is installed on                name of the individual part

To pull the serial number:

=INDEX(Data!C:C,MATCH(1,INDEX((Data!D:D=Query!$F$7)*(Data!A:A=Query!E8),,),0),0)

             serial # list                    part it is installed on               part # of the individual part

What can I add to these to grab the other items part number and serial number

As requested here is an example and yes the only thing that is different in the four items is the serial number: