SELECT
Aircraft.ModeS as MS,
Aircraft.Registration as AR,
Aircraft.ICAOTypeCode as AT,
Aircraft.Type as AN,
Aircraft.RegisteredOwners as AC,
Aircraft.SerialNo as CN
FROM
Aircraft
Airnav, is it worth considering importing this into your central database of aircraft?