PlanePlotter Querys - UPDATE 30/10/2014 ..

#1
For all PlanePlotter that you use, and set the Custom Symbols addon aircraft I leave a table query statements to update once symbols ..


For those who do not know as they get to look at this tutorial, the installation is very simple

This Video will show you how to install Plane Symbols to Enhance the Chart / Outline Display.

Once installed and running you will realize that many planes have yet to upgrade, as it is based on the table is the default, and the truth is that fatan a lot of planes, what makes you be updating hand constantly symbols.

TABLE BASE:
PlaneSymbol1 $1 Light C152 etc
PlaneSymbol2 $2 Light Twin prop
PlaneSymbol3 $3 2 Rear Engine Jet MD82 etc
PlaneSymbol4 $4 2 Engine Jet 737 etc
PlaneSymbol5 $5 4 Engine Jet 747 Etc
PlaneSymbol6 $6 Cazas
PlaneSymbol7 $7 Helo
PlaneSymbol8 $8 Biz jet
PlaneSymbol9 $9 RJ85 B146 etc

PlaneSymbolA $A VC10
PlaneSymbolB $B C17-C5
PlaneSymbolC $C C130
PlaneSymbolD $D DH8 SB20 etc
PlaneSymbolE $E Glider U2 etc
PlaneSymbolF $F AWACS
-Here we see that those two planes did not leave the symbols in its class.
EASY SOLUTION:
Well, to update a single run any program will use the symbols that exist in treatment internet database, in my case I use SQlite Expert, but there is a free version that does exactly the same, you can download from the following address .....


Once installed we tell where we have our Basestation.sql and being open like this ...


We click on the SQL tab and copy and paste the table and been created for different planes with their respective symbols in this table are the vast majority of aircraft naturalmemente missing many but every day the broad table, the I'll put here as to grow.


TABLES OF SYMBOLS:

Ver. 1.2.0 - 30/Octubre/2014

Code:
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A310";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A319";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A320";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A321";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A330";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A332";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A333";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A3OB";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A306";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A3ST";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "A340";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "A342";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "A343";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "A345";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "A346";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A358";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A359";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A400";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "A388";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "A380";

UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B701";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B703";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B720";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B721";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B722";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B731";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B732";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B733";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B734";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B735";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B736";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B737";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B738";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B739";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B741";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B742";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B743";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B744";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "BLCF";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "BSCA";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B74S";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B74R";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B752";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B753";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B762";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B763";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B764";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B772";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B77L";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B773";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B77W";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B77F";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B783";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B788";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B789";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B737";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "B752";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B742";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "B712";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "B748";

UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "C130";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C25A";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "CRJX";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "GLEX";

UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "AT72";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "GLF4";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "E50P";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "ASTR";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "SB20";
UPDATE Aircraft SET UserTag="$6" WHERE ICAOTypeCode LIKE "F100";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "E175";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "AT43";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "P68";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C181";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C182";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "EC35";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "AT76";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "AT75";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "RJ85";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PC12";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "G550";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "LJ45";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "GLF4";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "G650";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "TBM7";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA34";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "FA7X";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "E190";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PC7";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DA40";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P28A";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PC6P";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "M20T";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C172";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C650";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F900";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "E135";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "C425";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C680";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "C160";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "AS55";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F9EX";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "R44";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "EC20";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "APM3";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "TRIN";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "IL76";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "GL5T";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C25A";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C25B";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C25C";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "E195";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "RJ70";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "RJ80";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "RJ90";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "RJ95";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "RJ1H";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "B146";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "G126";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "TBM9";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "EC45";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C750";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "C295";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "G120";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "G150";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "MD82";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "AS65";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "LJ55";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "SR22";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "MD82";
UPDATE Aircraft SET UserTag="$B" WHERE ICAOTypeCode LIKE "C5";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "ATP";
UPDATE Aircraft SET UserTag="$B" WHERE ICAOTypeCode LIKE "B462";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C550";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "BE9L";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "F406";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "CRJ7";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "CRJ9";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "CRJ2";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "P180";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "SF34";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "E170";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "PAY1";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "SW3";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "AT43";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "CRUZ";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F2TH";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "M20P";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "A139";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "BE40";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "H900";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "AT45";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "D328";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DA42";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C150";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DIMO";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "GLF5";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "CRJ1";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "T34P";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "G450";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "FK50";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "H25B";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C525";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "AS50";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "LJ60";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P46T";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "AA5";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F70";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "c206";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P32R";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DV20";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "T214";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F2LX";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "DH8D";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "B463";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C510";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "DH8C";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "DH8A";
UPDATE Aircraft SET UserTag="$B" WHERE ICAOTypeCode LIKE "K35R";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "MD83";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "MD88";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "MD90";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "G200";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "CL64";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C560";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "GLF3";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "E145";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "FA50";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "B350";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "BE20";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "G280";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "B190";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "COL3";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "RV10";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "ELA7";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F2EX";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DR40";
UPDATE Aircraft SET UserTag="$5" WHERE ICAOTypeCode LIKE "MD11";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "EH10";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C152";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "LYNX";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA18";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "C310";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "JS41";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "BK17";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "A148";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "GL6T";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "EC55";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "BE36";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "FDCT";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "LA4";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C210";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "E55P";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P210";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "TOBA";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P28T";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "RV7";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "C212";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F100";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "GLID";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "ST75";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "sr20";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "sr22";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "CL61";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "be33";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "L410";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "b429";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "s22t";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "r22";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "hr10";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "g3";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "wt9";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "rall";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "TL20";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "CL30";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "S61";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "efox";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "husk";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "H53";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "g2ca";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "hr20";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "sira";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "AS3B";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "c72r";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "YK42";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "H60";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "b105";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "s6";

UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P750";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "V22";
UPDATE Aircraft SET UserTag="$B" WHERE ICAOTypeCode LIKE "C17";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "TBM8";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "LJ75";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "LJ40";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C208";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "a109";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "ZZZZ";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "DHC6";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "b06";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "i3";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PAY2";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "dr30";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "evss";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DHC2";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "b407";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "AN2";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "z42";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "aat3";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "SF25";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "TAMP";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "LNC2";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "DC10";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "S92";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "ZEPH";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "C30J";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "ALO3";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "A210";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "SC7";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "S10S";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "AC11";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "CL65";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "TUCA";
UPDATE Aircraft SET UserTag="$6" WHERE ICAOTypeCode LIKE "EUFI";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "B461";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "P06T";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "JAB2";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "G115";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "TRIS";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "BN2P";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA44";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA24";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "J1";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "Z602";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "C421";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "S330";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "AS32";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "T204";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "H25A";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "R300";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA32";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "SKRA";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA31";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "BE76";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "FK9";

UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA46";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "HA4T";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "BE95";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "EDGE";
UPDATE Aircraft SET UserTag="$6" WHERE ICAOTypeCode LIKE "L39";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "RV6";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "NIMB";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "CN35";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "E121";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "MCR1";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "C414";
UPDATE Aircraft SET UserTag="$B" WHERE ICAOTypeCode LIKE "a124";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "LGEZ";

UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P28R";
UPDATE Aircraft SET UserTag="$6" WHERE ICAOTypeCode LIKE "AJET";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "BE58";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C337";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "FA10";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "DC3";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "U2";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DHC7";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "BE99";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "AC90";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "B412";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "EN48";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P337";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "LJ35";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "E120";

UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C56X";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "GC1";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "MU2";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "DH8B";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "DH8D";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "BE9T";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "AEST";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C501";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "E300";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C82R";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DR22";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "F50";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "EC30";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "D228";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "C441";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "C402";

UPDATE Aircraft SET UserTag="$F" WHERE ICAOTypeCode LIKE "C135";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "C500";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F5EX";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "FA20";
UPDATE Aircraft SET UserTag="$F" WHERE ICAOTypeCode LIKE "UAV";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "EPIC";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "S76";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "BE55";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "STAR";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "TEX2";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "GALX";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "KODI";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "HDJT";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PC9";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "L200";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "GAZL";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "SJ32";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "S05R";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "D250";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "S05R";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "DUOD";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA25";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "J3";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "EUPA";
UPDATE Aircraft SET UserTag="$6" WHERE ICAOTypeCode LIKE "F16";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "RV4";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P28B";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "H269";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "VL3";
UPDATE Aircraft SET UserTag="$6" WHERE ICAOTypeCode LIKE "HAWK";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "ULAC";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C42";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "RV9";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "CH60";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C42";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "G109";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "AP22";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "G109";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "EUPA";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PUP";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "RF4";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "JS32";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "C404";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "EC25";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "ULAC";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "BREZ";

UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "SU95";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "R66";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "VENT";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "G102";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "P3";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "C77R";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "H500";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "RELI";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "G300";
UPDATE Aircraft SET UserTag="$F" WHERE ICAOTypeCode LIKE "E3CF";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "CH7A";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "GLAS";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "DG80";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "MI2";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "H64";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "CP10";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "UH1";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "PK20";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "AV68";
UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "C340";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "BE23";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P208";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "CP10";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DR10";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "RV8";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "MCR4";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "CE43";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "D11";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F9LX";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "AN74";

UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "BALL";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "T18";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "R90R";
UPDATE Aircraft SET UserTag="$9" WHERE ICAOTypeCode LIKE "SW4";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "M7";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PIVI";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "ECHO";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA22";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "VJ22";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA11";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "AT8T";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "EA50";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "CJM2";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "BE10";
UPDATE Aircraft SET UserTag="$3" WHERE ICAOTypeCode LIKE "DC91";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "P32T";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "GX";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "COL4";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "LJ36";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "BE35";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "XA42";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "CH70";

UPDATE Aircraft SET UserTag="$2" WHERE ICAOTypeCode LIKE "BE50";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "EAGL";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "J328";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "PA16";
UPDATE Aircraft SET UserTag="$B" WHERE ICAOTypeCode LIKE "CVLT";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "F27";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "RF6";
UPDATE Aircraft SET UserTag="$6" WHERE ICAOTypeCode LIKE "TOR";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "MD3R";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "D253";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "APM2";
UPDATE Aircraft SET UserTag="$D" WHERE ICAOTypeCode LIKE "AN26";
UPDATE Aircraft SET UserTag="$4" WHERE ICAOTypeCode LIKE "KC10";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "ARCP";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "PRM1";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "DO27";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "GY80";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "DG11";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "CL4T";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "F2TS";

UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "CONI";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "YK40";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "YK52";
UPDATE Aircraft SET UserTag="$E" WHERE ICAOTypeCode LIKE "as31";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "fox";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "veze";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "sc01";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "f260";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "c177";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "pa27";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "cozy";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "sv4";
UPDATE Aircraft SET UserTag="$7" WHERE ICAOTypeCode LIKE "mt";

UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "G500";
UPDATE Aircraft SET UserTag="$B" WHERE ICAOTypeCode LIKE "A124";
UPDATE Aircraft SET UserTag="$8" WHERE ICAOTypeCode LIKE "CL35";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "AN12";
UPDATE Aircraft SET UserTag="$C" WHERE ICAOTypeCode LIKE "C27J";
UPDATE Aircraft SET UserTag="$F" WHERE ICAOTypeCode LIKE "K35T";
UPDATE Aircraft SET UserTag="$1" WHERE ICAOTypeCode LIKE "jab4";


Staying this way .......


Now we can only run the SQL button and we already have changed once.



OTHER INTERESTING STATEMENTS

Code:
select * from Aircraft
We list all the aircraft in the database.

Code:
select * from Aircraft where ICAOTypeCode like "C56X"
We list all aircraft that are of the specified type (in the example "C56X").

Code:
select * from Aircraft where modescountry like "Spain" and ICAOTypeCode Like "A3%"
We list all the aircraft that are in the country specified with the type of aircraft selected.

Code:
UPDATE Aircraft SET Interested='0' WHERE ICAOTypeCode LIKE 'DH8%';
We modify the state of "interesting or not interesting" of a particular type of plane.


P.D: As good Spanish my English is a disaster, some forum moderator if you want to edit the post and translate a little better would be sensational.

 
Last edited: