mirror of
				https://github.com/MariaDB/server.git
				synced 2025-10-31 10:56:12 +01:00 
			
		
		
		
	 ee1c5226b9
			
		
	
	
	ee1c5226b9
	
	
	
		
			
			Fixed memory leak in _db_set() (Bug#24497 Valgrind warning: get_one_option) Don't call net_clear() on COM_QUIT. This avoids a warning from net_clear() after shutdown: "skipped ## bytes from file" BUG#21428: skipped 9 bytes from file: socket (3)" on "mysqladmin shutdown" sql-bench/test-wisconsin.sh: Rename: BitKeeper/deleted/.del-test-wisconsin.sh~c0b86821b5f95f26 -> sql-bench/test-wisconsin.sh sql-bench/test-transactions.sh: Rename: BitKeeper/deleted/.del-test-transactions.sh~c1c892f10c40caf -> sql-bench/test-transactions.sh sql-bench/test-insert.sh: Rename: BitKeeper/deleted/.del-test-insert.sh~893bfac9dedb79a7 -> sql-bench/test-insert.sh sql-bench/test-select.sh: Rename: BitKeeper/deleted/.del-test-select.sh~6d5cc770acf11be6 -> sql-bench/test-select.sh sql-bench/test-create.sh: Rename: BitKeeper/deleted/.del-test-create.sh~f9a1ea38c191b17a -> sql-bench/test-create.sh sql-bench/test-big-tables.sh: Rename: BitKeeper/deleted/.del-test-big-tables.sh~5b1b0c5fb623565a -> sql-bench/test-big-tables.sh sql-bench/test-connect.sh: Rename: BitKeeper/deleted/.del-test-connect.sh~382a728c949ee075 -> sql-bench/test-connect.sh sql-bench/test-ATIS.sh: Rename: BitKeeper/deleted/.del-test-ATIS.sh~e8ebff7086c95773 -> sql-bench/test-ATIS.sh sql-bench/test-alter-table.sh: Rename: BitKeeper/deleted/.del-test-alter-table.sh~eba6cfa9972fcced -> sql-bench/test-alter-table.sh sql-bench/innotest2b.sh: Rename: BitKeeper/deleted/.del-innotest2b.sh~7b99ece835e8dff3 -> sql-bench/innotest2b.sh sql-bench/run-all-tests.sh: Rename: BitKeeper/deleted/.del-run-all-tests.sh~41d6da1cf211ee95 -> sql-bench/run-all-tests.sh sql-bench/innotest2.sh: Rename: BitKeeper/deleted/.del-innotest2.sh~9c14df528285603 -> sql-bench/innotest2.sh sql-bench/innotest2a.sh: Rename: BitKeeper/deleted/.del-innotest2a.sh~e01d016a7cafdc0b -> sql-bench/innotest2a.sh sql-bench/innotest1a.sh: Rename: BitKeeper/deleted/.del-innotest1a.sh~c64f4610ae1e26fe -> sql-bench/innotest1a.sh sql-bench/innotest1b.sh: Rename: BitKeeper/deleted/.del-innotest1b.sh~aafd0819ae84da7b -> sql-bench/innotest1b.sh sql-bench/innotest1.sh: Rename: BitKeeper/deleted/.del-innotest1.sh~aa36bce09ca783c7 -> sql-bench/innotest1.sh sql-bench/crash-me.sh: Rename: BitKeeper/deleted/.del-crash-me.sh~2fa881d0b40339c8 -> sql-bench/crash-me.sh sql-bench/graph-compare-results.sh: Rename: BitKeeper/deleted/.del-graph-compare-results.sh~7e4e28b3591b4542 -> sql-bench/graph-compare-results.sh sql-bench/copy-db.sh: Rename: BitKeeper/deleted/.del-copy-db.sh~e8116afb93144ccd -> sql-bench/copy-db.sh sql-bench/compare-results.sh: Rename: BitKeeper/deleted/.del-compare-results.sh~a9e26e2644c694b3 -> sql-bench/compare-results.sh sql-bench/bench-count-distinct.sh: Rename: BitKeeper/deleted/.del-bench-count-distinct.sh~a92f174271a831d7 -> sql-bench/bench-count-distinct.sh sql-bench/as3ap.sh: Rename: BitKeeper/deleted/.del-as3ap.sh~f54eebbd8d34c9b6 -> sql-bench/as3ap.sh sql-bench/Comments/Informix.crash-me: Rename: BitKeeper/deleted/.del-Informix.crash-me~51ab5b717cefe74 -> sql-bench/Comments/Informix.crash-me sql-bench/Comments/postgres.crash-me: Rename: BitKeeper/deleted/.del-postgres.crash-me~eacac145c3e30f17 -> sql-bench/Comments/postgres.crash-me sql-bench/Comments/Empress.crash-me: Rename: BitKeeper/deleted/.del-Empress.crash-me~bdaff0c68ce10f02 -> sql-bench/Comments/Empress.crash-me sql-bench/Comments/Adabas.crash-me: Rename: BitKeeper/deleted/.del-Adabas.crash-me~ce88ba1a540971ac -> sql-bench/Comments/Adabas.crash-me sql-bench/Comments/Access.crash-me: Rename: BitKeeper/deleted/.del-Access.crash-me~bb457ec282d939b6 -> sql-bench/Comments/Access.crash-me sql-bench/Comments/postgres.benchmark: Rename: BitKeeper/deleted/.del-postgres.benchmark~4d30890732b784a -> sql-bench/Comments/postgres.benchmark sql-bench/Comments/mysql.benchmark: Rename: BitKeeper/deleted/.del-mysql.benchmark~4d8729c0937456fc -> sql-bench/Comments/mysql.benchmark sql-bench/Comments/FrontBase.benchmark: Rename: BitKeeper/deleted/.del-FrontBase.benchmark~217041ef18274c2e -> sql-bench/Comments/FrontBase.benchmark sql-bench/Comments/interbase: Rename: BitKeeper/deleted/.del-interbase~cdad59622b4d6f3 -> sql-bench/Comments/interbase sql-bench/uname.bat: Rename: BitKeeper/deleted/.del-uname.bat~a6d933d2ee9314c -> sql-bench/uname.bat sql-bench/pwd.bat: Rename: BitKeeper/deleted/.del-pwd.bat~9b64050849abf51 -> sql-bench/pwd.bat sql-bench/example.bat: Rename: BitKeeper/deleted/.del-example.bat~22d0170bccf0f030 -> sql-bench/example.bat sql-bench/Makefile.am: Rename: BitKeeper/deleted/.del-Makefile.am~7b07da85b2e9375 -> sql-bench/Makefile.am sql-bench/Data/ATIS/transport.txt: Rename: BitKeeper/deleted/.del-transport.txt~fa4ca40735f8354c -> sql-bench/Data/ATIS/transport.txt sql-bench/Data/ATIS/time_zone.txt: Rename: BitKeeper/deleted/.del-time_zone.txt~4171f9ca732f65c0 -> sql-bench/Data/ATIS/time_zone.txt sql-bench/Data/Wisconsin/tenk.data: Rename: BitKeeper/deleted/.del-tenk.data~6aeaebdd534e458e -> sql-bench/Data/Wisconsin/tenk.data sql-bench/Data/Wisconsin/onek.data: Rename: BitKeeper/deleted/.del-onek.data~6cd1edaf596a7f7 -> sql-bench/Data/Wisconsin/onek.data sql-bench/Data/ATIS/stop1.txt: Rename: BitKeeper/deleted/.del-stop1.txt~f09ba164ad44a288 -> sql-bench/Data/ATIS/stop1.txt sql-bench/Data/ATIS/time_interval.txt: Rename: BitKeeper/deleted/.del-time_interval.txt~a1def62e267a59b2 -> sql-bench/Data/ATIS/time_interval.txt sql-bench/Data/ATIS/stop.txt: Rename: BitKeeper/deleted/.del-stop.txt~31fb564e1f415e34 -> sql-bench/Data/ATIS/stop.txt sql-bench/Data/ATIS/restriction.txt: Rename: BitKeeper/deleted/.del-restriction.txt~6ae208924617784a -> sql-bench/Data/ATIS/restriction.txt sql-bench/Data/ATIS/state.txt: Rename: BitKeeper/deleted/.del-state.txt~9dd470ce14075b90 -> sql-bench/Data/ATIS/state.txt sql-bench/Data/ATIS/restrict_class.txt: Rename: BitKeeper/deleted/.del-restrict_class.txt~2f741bf0ea498f84 -> sql-bench/Data/ATIS/restrict_class.txt sql-bench/Data/ATIS/month_name.txt: Rename: BitKeeper/deleted/.del-month_name.txt~4c44f7a323d57d92 -> sql-bench/Data/ATIS/month_name.txt sql-bench/Data/ATIS/restrict_carrier.txt: Rename: BitKeeper/deleted/.del-restrict_carrier.txt~925b5492f3f9cba3 -> sql-bench/Data/ATIS/restrict_carrier.txt sql-bench/Data/ATIS/ground_service.txt: Rename: BitKeeper/deleted/.del-ground_service.txt~1087e477e86e84c -> sql-bench/Data/ATIS/ground_service.txt sql-bench/Data/ATIS/food_service.txt: Rename: BitKeeper/deleted/.del-food_service.txt~66d95a150c28458 -> sql-bench/Data/ATIS/food_service.txt sql-bench/Data/ATIS/flight_day.txt: Rename: BitKeeper/deleted/.del-flight_day.txt~76868d6d265d441e -> sql-bench/Data/ATIS/flight_day.txt sql-bench/Data/ATIS/flight_fare.txt: Rename: BitKeeper/deleted/.del-flight_fare.txt~d7322593c8530487 -> sql-bench/Data/ATIS/flight_fare.txt sql-bench/Data/ATIS/flight_class.txt: Rename: BitKeeper/deleted/.del-flight_class.txt~1801101474c29098 -> sql-bench/Data/ATIS/flight_class.txt sql-bench/Data/ATIS/fconnection.txt: Rename: BitKeeper/deleted/.del-fconnection.txt~e0ef6a8b5560a713 -> sql-bench/Data/ATIS/fconnection.txt sql-bench/Data/ATIS/flight.txt: Rename: BitKeeper/deleted/.del-flight.txt~e5065423760e99eb -> sql-bench/Data/ATIS/flight.txt sql-bench/Data/ATIS/fare.txt: Rename: BitKeeper/deleted/.del-fare.txt~ea0652f490bc24a6 -> sql-bench/Data/ATIS/fare.txt sql-bench/Data/ATIS/day_name.txt: Rename: BitKeeper/deleted/.del-day_name.txt~f813b215955d894c -> sql-bench/Data/ATIS/day_name.txt sql-bench/Data/ATIS/dual_carrier.txt: Rename: BitKeeper/deleted/.del-dual_carrier.txt~a7dd776224fbd92b -> sql-bench/Data/ATIS/dual_carrier.txt sql-bench/Data/ATIS/date_day.txt: Rename: BitKeeper/deleted/.del-date_day.txt~4e9a282fcf54cfd8 -> sql-bench/Data/ATIS/date_day.txt sql-bench/Data/ATIS/compound_class.txt: Rename: BitKeeper/deleted/.del-compound_class.txt~d4a2f1b7f96340b9 -> sql-bench/Data/ATIS/compound_class.txt sql-bench/Data/ATIS/connect_leg.txt: Rename: BitKeeper/deleted/.del-connect_leg.txt~f97b6e94e108bb36 -> sql-bench/Data/ATIS/connect_leg.txt sql-bench/Data/ATIS/code_description.txt: Rename: BitKeeper/deleted/.del-code_description.txt~f9117373e438b0e2 -> sql-bench/Data/ATIS/code_description.txt sql-bench/Data/ATIS/city.txt: Rename: BitKeeper/deleted/.del-city.txt~d96dd6d073344d2e -> sql-bench/Data/ATIS/city.txt sql-bench/Data/ATIS/class_of_service.txt: Rename: BitKeeper/deleted/.del-class_of_service.txt~21f6b9848b8c76d -> sql-bench/Data/ATIS/class_of_service.txt sql-bench/Data/ATIS/airport_service.txt: Rename: BitKeeper/deleted/.del-airport_service.txt~6ee6d5b852b3e38 -> sql-bench/Data/ATIS/airport_service.txt sql-bench/Data/ATIS/airline.txt: Rename: BitKeeper/deleted/.del-airline.txt~a79f8eadf853f2c8 -> sql-bench/Data/ATIS/airline.txt sql-bench/Data/ATIS/airport.txt: Rename: BitKeeper/deleted/.del-airport.txt~59c78514130e1f45 -> sql-bench/Data/ATIS/airport.txt sql-bench/Data/ATIS/aircraft.txt: Rename: BitKeeper/deleted/.del-aircraft.txt~15e4de7ab37c92d3 -> sql-bench/Data/ATIS/aircraft.txt sql-bench/TODO: Rename: BitKeeper/deleted/.del-TODO~cac6d7a63c426ae5 -> sql-bench/TODO sql-bench/limits/sybase.cfg: Rename: BitKeeper/deleted/.del-sybase.cfg~c4636b12767b3f14 -> sql-bench/limits/sybase.cfg sql-bench/limits/solid-nt4.cfg: Rename: BitKeeper/deleted/.del-solid-nt4.cfg~cca779f0c9e29d31 -> sql-bench/limits/solid-nt4.cfg sql-bench/limits/solid.cfg: Rename: BitKeeper/deleted/.del-solid.cfg~5ae0e4342eadb0fb -> sql-bench/limits/solid.cfg sql-bench/limits/pg.cfg: Rename: BitKeeper/deleted/.del-pg.cfg~db59cf39a5d417be -> sql-bench/limits/pg.cfg sql-bench/limits/mysql.cfg: Rename: BitKeeper/deleted/.del-mysql.cfg~9cab20a8771b93cf -> sql-bench/limits/mysql.cfg sql-bench/limits/oracle.cfg: Rename: BitKeeper/deleted/.del-oracle.cfg~affab21af8f438fd -> sql-bench/limits/oracle.cfg sql-bench/limits/mysql-4.1.cfg: Rename: BitKeeper/deleted/.del-mysql-4.1.cfg~b6c5e74aefc99e3c -> sql-bench/limits/mysql-4.1.cfg sql-bench/limits/mysql-3.23.cfg: Rename: BitKeeper/deleted/.del-mysql-3.23.cfg~3cf9d6be54b77a3c -> sql-bench/limits/mysql-3.23.cfg sql-bench/limits/mysql-4.0.cfg: Rename: BitKeeper/deleted/.del-mysql-4.0.cfg~6c9d63c85b5ef574 -> sql-bench/limits/mysql-4.0.cfg sql-bench/limits/mysql-3.22.cfg: Rename: BitKeeper/deleted/.del-mysql-3.22.cfg~e706f26a161175cd -> sql-bench/limits/mysql-3.22.cfg sql-bench/limits/msql.cfg: Rename: BitKeeper/deleted/.del-msql.cfg~52710b12932cceb9 -> sql-bench/limits/msql.cfg sql-bench/limits/ms-sql65.cfg: Rename: BitKeeper/deleted/.del-ms-sql65.cfg~6b9bc3c460dbee05 -> sql-bench/limits/ms-sql65.cfg sql-bench/limits/mimer.cfg: Rename: BitKeeper/deleted/.del-mimer.cfg~234e6c1c3c47b612 -> sql-bench/limits/mimer.cfg sql-bench/limits/ms-sql.cfg: Rename: BitKeeper/deleted/.del-ms-sql.cfg~1907964264d2786a -> sql-bench/limits/ms-sql.cfg sql-bench/limits/interbase.cfg: Rename: BitKeeper/deleted/.del-interbase.cfg~c6951a0376cc6ff3 -> sql-bench/limits/interbase.cfg sql-bench/limits/interbase-dialect3.cfg: Rename: BitKeeper/deleted/.del-interbase-dialect3.cfg~46277bdfc74c667a -> sql-bench/limits/interbase-dialect3.cfg sql-bench/limits/interbase-superserver.cfg: Rename: BitKeeper/deleted/.del-interbase-superserver.cfg~22501198689243b0 -> sql-bench/limits/interbase-superserver.cfg sql-bench/limits/interbase-dialect1.cfg: Rename: BitKeeper/deleted/.del-interbase-dialect1.cfg~659206b5b9a11036 -> sql-bench/limits/interbase-dialect1.cfg sql-bench/limits/empress.cfg: Rename: BitKeeper/deleted/.del-empress.cfg~1f97f34d6560a499 -> sql-bench/limits/empress.cfg sql-bench/limits/frontbase.cfg: Rename: BitKeeper/deleted/.del-frontbase.cfg~71369e9c002696e -> sql-bench/limits/frontbase.cfg sql-bench/limits/db2.cfg: Rename: BitKeeper/deleted/.del-db2.cfg~711099b4d7906959 -> sql-bench/limits/db2.cfg sql-bench/limits/access.cfg: Rename: BitKeeper/deleted/.del-access.cfg~5239ea3655b7bba0 -> sql-bench/limits/access.cfg sql-bench/limits/access_odbc.cfg: Rename: BitKeeper/deleted/.del-access_odbc.cfg~34b4cf0eda56c4b1 -> sql-bench/limits/access_odbc.cfg sql-bench/limits/Informix.cfg: Rename: BitKeeper/deleted/.del-Informix.cfg~b94188e1ececb51b -> sql-bench/limits/Informix.cfg sql-bench/limits/Adabas.cfg: Rename: BitKeeper/deleted/.del-Adabas.cfg~343ed4e7f8b02111 -> sql-bench/limits/Adabas.cfg sql-bench/README: Rename: BitKeeper/deleted/.del-README~b1aa0c1bf9f5eb5e -> sql-bench/README BitKeeper/deleted/.del-create-pg_fast-Linux_2.2.14_my_SMP_i686-crashed: Delete: sql-bench/Results/create-pg_fast-Linux_2.2.14_my_SMP_i686-crashed Makefile.am: Added back sql-bench configure.in: Added back sql-bench dbug/dbug.c: Fixed memory leak in _db_set() This is not a complete fix as we can still get memory leaks if we do any of the following: mysqld --debug --debug CAll DBUG_SET or DBUG_SET_INITIAL more than once in a program Use SET @@global.debug=xxxx At some point we should fix the above, but this is not critical for normal operation (only for debugging) Bug #24497 Valgrind warning: get_one_option Note that all changes to _db_set_ is only a variable access change, and can be ignored while reviewing the bug fix. mysql-test/t/flush_read_lock_kill-master.opt: Added '+' to option, to be able to use this together with --debug mysql-test/valgrind.supp: Removed warning that is now fixed mysys/ptr_cmp.c: Fixed wrong pointer read (probably never used) scripts/make_binary_distribution.sh: Added back sql_bench sql/field.h: Removed class function that was identical in parent class sql/mysqld.cc: Removed some calls to my_thread_init() / my_thread_end() that was not needed. Only call DBUG_SET_INITAL, not DBUG_SET (Fixes memory leak in dbug) Mark some code as deadcode sql/net_serv.cc: Add information about from where error comes sql-bench/bench-init.pl.sh: Cleaned up help text sql-bench/server-cfg.sh: Don't write '/' after server name of no ssl version sql-common/client.c: Don't call net_clear() on COM_QUIT. This avoids a warning from net_clear() after shutdown: "skipped ## bytes from file" BUG#21428: skipped 9 bytes from file: socket (3)" on "mysqladmin shutdown" sql/sql_parse.cc: Added comment sql/table.h: Removed compiler warning
		
			
				
	
	
		
			314 lines
		
	
	
	
		
			10 KiB
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			314 lines
		
	
	
	
		
			10 KiB
		
	
	
	
		
			Text
		
	
	
	
	
	
| 'AA','AMERICAN AIRLINES',''
 | |
| 'AC','AIR CANADA',''
 | |
| 'AD','EXEC EXPRESS II,INC.',''
 | |
| 'AF','AIR FRANCE',''
 | |
| 'AG','ATLANTIC AIRWAYS LIMITED',''
 | |
| 'AM','AEROMEXICO - AEROVIAS DE MEXICO S.A. DE C.V.',''
 | |
| 'AP','ASPEN AIRWAYS,INC.',''
 | |
| 'AQ','ALOHA AIRLINES INC.',''
 | |
| 'AR','AEROLINEAS ARGENTINAS',''
 | |
| 'AS','ALASKA AIRLINES',''
 | |
| 'AT','ROYAL AIR MAROC',''
 | |
| 'AV','AVIANCA',''
 | |
| 'AY','FINNAIR',''
 | |
| 'AZ','ALITALIA',''
 | |
| 'BA','BRITISH AIRWAYS',''
 | |
| 'BE','ENTERPRISE AIRLINES,INC.',''
 | |
| 'BF','MARKAIR,INC.',''
 | |
| 'BK','CHALKS/PARADISE ISLAND AIRLINES',''
 | |
| 'BL','AIR BVI,LTD.',''
 | |
| 'BW','BWIA INTERNATIONAL',''
 | |
| 'CA','CAAC',''
 | |
| 'CD','TRANS-PROVINCIAL AIRLINES LTD.',''
 | |
| 'CH','BEMIDJI AIRLINES',''
 | |
| 'CI','CHINA AIRLINES LTD.',''
 | |
| 'CO','CONTINENTAL AIRLINES',''
 | |
| 'CP','CANADIAN AIRLINES INTERNATIONAL LTD.',''
 | |
| 'CS','AIR TORONTO',''
 | |
| 'CT','MIDCONTINENT AIRLINES INC.',''
 | |
| 'CU','CUBANA AIRLINES',''
 | |
| 'CX','CATHAY PACIFIC AIRWAYS LTD.',''
 | |
| 'DD','COMMAND AIRWAYS,INC.',''
 | |
| 'DE','PRIME AIR,INC.',''
 | |
| 'DF','AERO COACH AVIATION INTERNATIONAL,INC.',''
 | |
| 'DL','DELTA AIR LINES,INC.',''
 | |
| 'DO','DOMINICANA DE AVIACION',''
 | |
| 'DQ','COASTAL AIR TRANSPORT',''
 | |
| 'DV','NANTUCKET AIRLINES',''
 | |
| 'EA','EASTERN AIR LINES,INC.',''
 | |
| 'ED','CCAIR INC.',''
 | |
| 'EI','AER LINGUS P.L.C.',''
 | |
| 'EJ','NEW ENGLAND AIRLINES,INC.',''
 | |
| 'EM','EMPIRE AIRWAYS',''
 | |
| 'EU','EMPRESA ECUATORIANA DE AVIACION',''
 | |
| 'EV','ATLANTIC SOUTHEAST AIRLINES,INC.',''
 | |
| 'FC','CHAPARRAL AIRLINES,INC.',''
 | |
| 'FH','MALL AIRWAYS INC.',''
 | |
| 'FI','ICELANDAIR',''
 | |
| 'FK','FLAMENCO AIRWAYS,INC.',''
 | |
| 'FN','SFO HEICOPTER AIRLINES,INC.',''
 | |
| 'FQ','AIR ARUBA',''
 | |
| 'FX','EXPRESS AIR,INC.',''
 | |
| 'FY','METROFLIGHT AIRLINES',''
 | |
| 'GA','GARUDA INDONESIAN AIRWAYS',''
 | |
| 'GM','AIR AMERICA',''
 | |
| 'GQ','BIG SKY AIRLINES',''
 | |
| 'GS','BAS AIRLINES',''
 | |
| 'GU','AVIATECA S.A.',''
 | |
| 'HA','HAWAIIAN AIR LINES',''
 | |
| 'HD','NEW YORK HELICOPTER CORPORATION',''
 | |
| 'HE','KEYSTONE AIR SERVICE LTD.',''
 | |
| 'HG','HARBOR AIRLINES,INC',''
 | |
| 'HI','GRAND CANYON HELICOPTERS',''
 | |
| 'HP','AMERICA WEST AIRLINES,INC.',''
 | |
| 'HQ','BUSINESS EXPRESS',''
 | |
| 'HY','METRO AIRLINES',''
 | |
| 'IB','IBERIA',''
 | |
| 'IF','INTERFUG',''
 | |
| 'IH','CHANNEL FLYING,INC.','SERVICE TEMPORARILY SUSPENDED'
 | |
| 'IN','EAST HAMPTON AIRE',''
 | |
| 'IU','HELITRANS AIR SERVICE,INC.',''
 | |
| 'JB','HELIJET AIRWAYS',''
 | |
| 'JC','ROCKY MOUNTAIN AIRWAYS',''
 | |
| 'JF','L.A.B. FYING SERVICE,INC.','CARRIER PERFORMS SEASONAL SERVICE ONLY'
 | |
| 'JI','JET EXPRESS',''
 | |
| 'JL','JAPAN AIRLINES',''
 | |
| 'JM','AIR JAMAICA LIMITED',''
 | |
| 'JO','HOLIDAY AIRLINES,INC.',''
 | |
| 'JQ','TRANS-JAMAICAN AIRLINES LTD.',''
 | |
| 'JR','AERO CALIFORNIA',''
 | |
| 'JT','IOWA AIRWAYS,INC.',''
 | |
| 'JU','YUGOSLAV AIRLINES (JAT)',''
 | |
| 'JV','BEARSKIN LAKE AIR SERVICE LIMITED',''
 | |
| 'KE','KOREAN AIR',''
 | |
| 'KI','TIME AIR LTD.',''
 | |
| 'KL','KLM-ROYAL DUTCH AIRLINES',''
 | |
| 'KS','PENINSULA AIRWAYS,INC.',''
 | |
| 'KW','CARNIVAL AIR LINES',''
 | |
| 'KX','CAYMAN AIRWAYS,LTD.',''
 | |
| 'LA','LAN CHILE S.A.',''
 | |
| 'LH','LUFTHANSA GERMAN AIRLINES',''
 | |
| 'LI','LIAT (1974) LTD.',''
 | |
| 'LM','ALM-ANTILLEAN AIRLINES',''
 | |
| 'LR','LACSA',''
 | |
| 'LS','ILIAMNA AIR TAXI,INC.',''
 | |
| 'LV','LAV-LINEA AEROPOSTAL VENEZOLANA',''
 | |
| 'LW','AIR NEVADA',''
 | |
| 'LY','EL AL ISRAEL AIRLINES',''
 | |
| 'MG','MGM GRAND AIR,INC.',''
 | |
| 'MH','MALAYSIAN AIRLINE SYSTEM',''
 | |
| 'ML','MIDWAY AIRLINES,INC.',''
 | |
| 'MO','CALM AIR INTERNATIONAL LTD.',''
 | |
| 'MQ','SIMMONS AIRLINES',''
 | |
| 'MX','MEXICANA DE AVIACION',''
 | |
| 'NA','EXECUTIVE AIR CHARTER',''
 | |
| 'ND','INTAIR',''
 | |
| 'NN','C.A.A.A.-AIR MARTINIQUE',''
 | |
| 'NQ','CUMBERLAND AIRLINES',''
 | |
| 'NR','NORONTAIR',''
 | |
| 'NV','NORTHWEST TERRITORIAL AIRWAYS,LTD.',''
 | |
| 'NW','NORTHWEST AIRLINES,INC.',''
 | |
| 'OA','OLYMPIC AIRWAYS',''
 | |
| 'OB','TEMPUS AIR LTD.','CARRIER PERFORMS SEASONAL SERVICE ONLY'
 | |
| 'OE','WESTAIR AIRLINES',''
 | |
| 'OG','AIR GUADELOUPE',''
 | |
| 'OH','COMAIR,INC.','NATL AIR TRANSPORTATION ASSOC,INC.'
 | |
| 'OJ','AIR ST.-BARTHELEMY',''
 | |
| 'OK','CZECHOSLOVAK AIRLINES',''
 | |
| 'OO','SKY WEST AIRLINES',''
 | |
| 'OQ','AEROLIBERTAD S.A. DE C.V.',''
 | |
| 'OT','EVERGREEN ALASKA',''
 | |
| 'OU','CITY EXPRESS',''
 | |
| 'OY','SUNAIRE',''
 | |
| 'PA','PAN AMERICAN WORLD AIRWAYS,INC.',''
 | |
| 'PD','PEM AIR LIMITED',''
 | |
| 'PK','PAKISTAN INTERNATIONAL AIRLINES',''
 | |
| 'PN','COASTAL AIRWAYS',''
 | |
| 'PQ','HOLIDAY AIRWAYS','SERVICE TEMPORARILY SUSPENDED'
 | |
| 'PR','PHILIPPINE AIRLINES,INC.',''
 | |
| 'PS','CENTRAL STATES AIRLINES,INC.',''
 | |
| 'PT','PBA-PROVINCETOWN-BOSTON AIRLINE,INC.',''
 | |
| 'PV','PANORAMA AIR',''
 | |
| 'PY','SURINAM AIRWAYS LTD.',''
 | |
| 'QA','AERO CARIBE',''
 | |
| 'QB','INTER-QUEBEC',''
 | |
| 'QD','GRAND AIRWAYS,INC.',''
 | |
| 'QF','QANTAS AIRWAYS LTD.',''
 | |
| 'QO','BAR HARBOR AIRLINES',''
 | |
| 'QQ','DRUMMOND ISLAND AIR','CARRIER PERFORMS SEASONAL SERVICE ONLY'
 | |
| 'QR','AIR SATELLITE,INC.',''
 | |
| 'QS','PROPHETER AVIATION',''
 | |
| 'QW','TURKS AND CAICOS NATIONAL AIRLINE',''
 | |
| 'QX','HORIZON AIR',''
 | |
| 'QY','AERO VIRGIN ISLANDS CORP',''
 | |
| 'RG','VARIG,S.A.',''
 | |
| 'RH','REGAL BAHAMAS INTERNATIONAL AIRLINES',''
 | |
| 'RJ','ROYAL JORDANIAN',''
 | |
| 'RM','WINGS WEST AIRLINE,INC.',''
 | |
| 'RP','PRECISION AIRLINES',''
 | |
| 'RV','REEVE ALEUTIAN AIRWAYS,INC.',''
 | |
| 'SE','WINGS OF ALASKA',''
 | |
| 'SK','SCANDINAVIAN AIRLINES SYSTEM',''
 | |
| 'SN','SABENA BELGIAN WORLD AIRLINES',''
 | |
| 'SQ','SINGAPORE AIRLINES',''
 | |
| 'SR','SWISSAIR',''
 | |
| 'SS','METRO AIRLINES NORTHEAST INC.',''
 | |
| 'SU','AEROFLOT-SOVIET AIRLINES',''
 | |
| 'SV','SAUDI ARABIAN AIRLINES',''
 | |
| 'SX','CHRISTMAN AIR SYSTEM',''
 | |
| 'TB','TRUMP SHUTTLE,INC.',''
 | |
| 'TE','AIR NEW ZEALAND-INTERNATIONAL',''
 | |
| 'TG','THAI AIRWAYS INTERNATIONAL,LTD.',''
 | |
| 'TO','ALKAN AIR LTD.',''
 | |
| 'TP','TAP AIR PORTUGAL',''
 | |
| 'TV','HAITI TRANS AIR S.A.',''
 | |
| 'TW','TRANS WORLD AIRLINES,INC.',''
 | |
| 'TZ','AMERICAN TRANS AIR',''
 | |
| 'UA','UNITED AIRLINES',''
 | |
| 'UC','LADECO-LINEA AEREA DEL COBRE',''
 | |
| 'UE','AIR LA',''
 | |
| 'UJ','AIR SEDONA',''
 | |
| 'UO','DIRECT AIR,INC.','NATL AIR TRANSPORTATION ASSOC,INC.'
 | |
| 'UP','BAHAMASAIR',''
 | |
| 'US','USAIR',''
 | |
| 'UT','U.T.A. - UNION DE TRANSPORTS AERIENS',''
 | |
| 'UW','PERIMETER AIRLINES (INLAND) LTD.',''
 | |
| 'VA','VIASA',''
 | |
| 'VI','VIEQUES AIR LINK,INC.',''
 | |
| 'VW','TRANSPORTES AEROMAR,S.A. DE C.V.',''
 | |
| 'WD','WARDAIR',''
 | |
| 'WJ','LABRADOR AIRWAYS,LTD.',''
 | |
| 'WM','WINDWARD ISLAND AIRWAYS INTERNATIONAL N.V.',''
 | |
| 'WN','SOUTHWEST AIRLINES',''
 | |
| 'WP','ALOHA ISLANDAIR,INC.',''
 | |
| 'WQ','WINGS AIRWAYS','NATL AIR TRANSPORTATION ASSOC,INC.'
 | |
| 'WS','WESTATES AIRLINES','SERVICE TEMPORARILY SUSPENDED'
 | |
| 'WV','MIDWEST AVIATION',''
 | |
| 'XE','SOUTHCENTRAL AIR,INC.',''
 | |
| 'XJ','MESABA AVIATION',''
 | |
| 'XK','RESORT COMMUTER,INC.',''
 | |
| 'XQ','ACTION AIRLINES',''
 | |
| 'XV','PRESIDENTIAL AIRWAYS,INC.',''
 | |
| 'XW','WALKER\'S INTERNATIONAL',''
 | |
| 'XY','RYAN AIR,INC.',''
 | |
| 'YE','GRAND CANYON AIRLINES,INC.','CARRIER PERFORMS SEASONAL SERVICE ONLY'
 | |
| 'YI','AIR SUNSHINE INC.','NATL AIR TRANSPORTATION ASSOC,INC.'
 | |
| 'YL','LONG ISLAND AIRLINES',''
 | |
| 'YN','AIR CREEBEC INC.',''
 | |
| 'YR','SCENIC AIRLINES INC.','NATL AIR TRANSPORTATION ASSOC,INC.'
 | |
| 'YS','SAN JUAN AIRLINES',''
 | |
| 'YU','AEROLINEAS DOMINICANAS,S.A. - DOMINAIR',''
 | |
| 'YV','MESA AIRLINES',''
 | |
| 'YW','STATESWEST AIRLINES,INC.',''
 | |
| 'YX','MIDWEST EXPRESS AIRLINES,INC.',''
 | |
| 'ZD','ROSS AVIATION,INC.','NATL AIR TRANSPORTATION ASSOC,INC'
 | |
| 'ZE','AIR CARIBE INTERNATIONAL,INC.',''
 | |
| 'ZK','GREAT LAKES AVIATION,LTD.',''
 | |
| 'ZO','MOHAWK AIRLINES',''
 | |
| 'ZP','VIRGIN AIR,INC.',''
 | |
| 'ZS','HISPANIOLA AIRWAYS C. POR A.',''
 | |
| 'ZV','AIR MIDWEST',''
 | |
| 'ZW','AIR WISCONSIN',''
 | |
| 'ZX','AIR BC,LTD.',''
 | |
| '2E','HERMENS/MARKAIR EXPRESS',''
 | |
| '2F','FRONTIER FLYING SERVICE',''
 | |
| '2P','PRAIRIE FLYING SERVICE (1976) LTD.',''
 | |
| '2Q','AQUILA AIR LTD',''
 | |
| '2V','NORTHEAST EXPRESS REGIONAL AIRLINES','NATL AIR TRANSPORTATION ASSOC,INC.'
 | |
| '2Z','SERVICIOS AEROS LITORAL S.A. DE C.V.',''
 | |
| '3A','ALLIANCE AIRLINES',''
 | |
| '3C','CAMAI AIR',''
 | |
| '3G','VIRGIN ISLANDS SEAPLANE SHUTTLE','SERVICE TEMPORARILY SUSPENDED'
 | |
| '3H','AIR INUIT (1985) LTD.',''
 | |
| '3L','AIR-LIFT ASSOCIATES,INC',''
 | |
| '3N','PAC AIR',''
 | |
| '3R','AIR MOLOKAI - TROPIC AIRLINES','SERVICE TEMPORARILY SUSPENDED'
 | |
| '3S','SHUSWAP AIR',''
 | |
| '3V','WAGLISLA AIR INC.',''
 | |
| '4A','AIRWAYS INTERNATIONAL,INC.',''
 | |
| '4B','OLSON AIR SERVICE,INC.',''
 | |
| '4E','TANANA AIR SERVICE',''
 | |
| '4F','FRONTIER AIR',''
 | |
| '4G','INLET AIRLINES,INC.',''
 | |
| '4K','KENN BOREK AIR LTD.',''
 | |
| '4L','AIR ALMA INC.',''
 | |
| '4N','AIR NORTH',''
 | |
| '4T','PACIFIC RIM AIRLINES LTD.',''
 | |
| '4V','VOYAGEUR AIRWAYS LTD.',''
 | |
| '4W','WRANGELL AIR SERVICE',''
 | |
| '4Y','YUTE AIR ALASKA,INC.','SERVICE TEMPORARILY SUSPENDED'
 | |
| '5A','ALPINE AVIATION,INC.',''
 | |
| '5B','BELLAIR INC.',''
 | |
| '5E','HUB EXPRESS,INC.',''
 | |
| '5K','KENMORE AIR HARBOR,INC.',''
 | |
| '5L','LAREDO AIR,INC.',''
 | |
| '5N','SEAGULL AIR SERVICE,INC.','SERVICE TEMPORARILY SUSPENDED'
 | |
| '5P','PTARMIGAN AIRWAYS LTD',''
 | |
| '5S','AIRSPEED AVIATION INC.',''
 | |
| '5T','AVIACION DEL NOROESTE',''
 | |
| '5U','SKAGWAY AIR SERVICE,INC.',''
 | |
| '5V','AVIAIR AVIATION (1984) LTD.',''
 | |
| '5W','CHARTAIR,INC.',''
 | |
| '6A','PANAMA AIRWAYS',''
 | |
| '6B','BAXTER AVIATION',''
 | |
| '6C','CAPE SMYTHE AIR SERVICE,INC.',''
 | |
| '6D','ALASKA ISLAND AIR,INC.',''
 | |
| '6E','BURRARD AIR LTD.',''
 | |
| '6G','LAS VEGAS AIRLINES',''
 | |
| '6J','SOUTHERN JERSEY AIRWAYS,INC.',''
 | |
| '6K','KEEWATIN AIR LIMITED',''
 | |
| '6L','AKLAK AIR LTD.',''
 | |
| '6M','40-MILE AIR,LTD.',''
 | |
| '6P','PROPAIR INC.',''
 | |
| '6Q','BARROW AIR,INC.',''
 | |
| '6S','KETCHIKAN AIR SERVICE,INC.',''
 | |
| '6T','TYEE AIRWAYS LIMITED',''
 | |
| '6V','AIR VEGAS,INC.',''
 | |
| '6W','WILDERNESS AIRLINE (1975) LTD.',''
 | |
| '7A','HAINES AIRWAYS,INC.',''
 | |
| '7D','TRUMP AIR',''
 | |
| '7F','FIRST AIR',''
 | |
| '7G','GULFSTREAM AIRLINES,INC.','NATL AIR TRANSPORTATION ASSOC,INC.'
 | |
| '7H','ERA AVIATION',''
 | |
| '7K','LARRY\'S FLYING SERVICE,INC',''
 | |
| '7L','LAKE UNION AIR SERVICE',''
 | |
| '7N','NORTHLAND AIR MANITOBA LIMITED',''
 | |
| '7Q','CALIFORNIA AIR SHUTTLE',''
 | |
| '7R','GCS AIR SERVICE,INC.',''
 | |
| '7T','TRANS COTE INC.',''
 | |
| '7V','ALPHA AIR',''
 | |
| '7W','AIR SASK AVIATION',''
 | |
| '8B','BAKER AVIATION,INC.',''
 | |
| '8D','SKYLINK AIRLINES','SERVICE TEMPORARILY SUSPENDED'
 | |
| '8E','BERING AIR,INC.',''
 | |
| '8F','WILBUR\'S INC.',''
 | |
| '8G','GP EXPRESS AIRLINES,INC.',''
 | |
| '8H','HARBOR AIR SERVICE',''
 | |
| '8K','AIR MUSKOKA',''
 | |
| '8L','SERVICIO AEREO LEO LOPEZ',''
 | |
| '8M','APEX AIRLINES',''
 | |
| '8N','NASHVILLE EAGLE,INC.',''
 | |
| '8P','POCONO AIRLINES',''
 | |
| '8R','WRA,INC.',''
 | |
| '8T','TRI AIR,INC.','SERVICE TEMPORARILY SUSPENDED'
 | |
| '8V','WRIGHT AIR SERVICE,INC.',''
 | |
| '9A','AIR ATLANTIC LTD.',''
 | |
| '9C','ICARUS FLYING SERVICE,LTD.',''
 | |
| '9D','DELTA AIR CHARTER LTD.',''
 | |
| '9E','EXPRESS AIRLINES I,INC.',''
 | |
| '9F','SKYCRAFT AIR TRANSPORT INC.',''
 | |
| '9K','CAPE AIR',''
 | |
| '9M','CENTRAL MOUNTAIN AIR LTD.',''
 | |
| '9N','TRANS STATES AIRLINES,INC.',''
 | |
| '9Q','TAQUAN AIR SERVICE,INC.',''
 | |
| '9S','SABOURIN LAKE AIRWAYS LTD.',''
 | |
| '9V','AIR SCHEFFERVILLE','CARRIER PERFORMS SEASONAL SERVICE ONLY'
 | |
| 'GD','AIR SOUTH,INC.','NATL AIR TRANSPORTATION ASSOC,INC.'
 | |
| 'VL','SUN PACIFIC AIRLINES,INC.',''
 | |
| '3D','EDGARTOWN AIR,INC.',''
 | |
| '4Q','TRANS NORTH AVIATION,LTD.','CARRIER PERFORMS SEASONAL SERVICE ONLY'
 | |
| '4R','RAVEN AIR,INC.',''
 | |
| '4X','L\'EXPRESS AIRLINES',''
 | |
| '5C','CONQUEST AIRLINES CORP.',''
 | |
| '7C','SIERRA VISTA AVIATION','SERVICE TEMPORARILY SUSPENDED'
 | |
| 'MC','MILITARY AIRLIFT COMMAND (MAC)-U.S. DEPARTMENT OF THE AIR FORCE',''
 |