Here is the database creation and filling to analyse the transponder packet.

some Views i use:

CREATE VIEW `V_MsgStatus` AS
SELECT `T_tData`.`msg_type` AS `msg_type`,
CONCAT(`T_tData`.`b_status1`,`T_tData`.`b_status2` ,`T_tData`.`b_status3`,`T_tData`.`b_status4`,`T_tD ata`.`b_status5`,`T_tData`.`b_status6`,`T_tData`.` b_status7`,`T_tData`.`b_status8`) AS `SatusBit`
FROM `T_tData`;

CREATE VIEW `V_TransMsgNible` AS
SELECT `T_tData`.`transponder` AS `transponder`,`
T_tData`.`msg_type` AS `msg_type`,`T_tData`.`b_nible1` AS `b_nible1`,`T_tData`.`b_nible2` AS `b_nible2`,`T_tData`.`b_nible3` AS `b_nible3`,
`T_tData`.`b_nible4` AS `b_nible4`,`T_tData`.`b_nible5` AS `b_nible5`,`T_tData`.`b_nible6` AS `b_nible6`,`T_tData`.`b_nible7` AS `b_nible7`,
`T_tData`.`b_nible8` AS `b_nible8` FROM `T_tData`;


Thor