PiAware Tools
insert-airlines.sql
Go to the documentation of this file.
1INSERT INTO airline (code, name) VALUES
2('AA1','AMERICAN AIRLINES INC'),
3('AA7','AMERICAN AIRLINES INC'),
4('AA8','AMERICAN AIRLINES INC'),
5('AAL','AMERICAN AIRLINES INC'),
6('AAY','ALLEGIANT AIR LLC'),
7('ABX','KALITTA AIR LLC'),
8('AIP','ALPINE AVIATION INC'),
9('AJI','SIERRA AMERICAN CORPORATION'),
10('AMF','AMERIFLIGHT LLC'),
11('AMX','AEROMEXICO'),
12('ARC','UNKNOWN AIRLINE'),
13('ARD','SC TRANSPORT LLC'),
14('ARF','DOG IS MY COPILOT INC'),
15('ARR','AVALAIR AIRCRAFT MANAGEMENT LLC'),
16('ARZ','AVIATION INVENTORY RESOURCES INC'),
17('ASA','ALASKA AIRLINES INC'),
18('ASH','UNITED AIRLINES INC'),
19('ASI','CHRISTIANSEN AVIATION LLC'),
20('ASN','UNITED AIRLINES INC'),
21('ASS','UNITED AIRLINES INC'),
22('ATA','AIRBORNE TACTICAL ADVANTAGE COMPANY LLC'),
23('ATN','AMAZON.COM SERVICES LLC'),
24('AVA','BANK OF UTAH TRUSTEE'),
25('AWI','AIR WISCONSIN AIRLINES LLC'),
26('AXE','LASAI AVIATION II LLC'),
27('BBQ','EASTERN 737 ASSET HOLDINGS LLC'),
28('BKA','BANKAIR INC'),
29('BLK','AERO AIRCRAFT HOLDINGS II LLC'),
30('BOE','BOEING CO'),
31('BOG','UNKNOWN AIRLINE'),
32('BTQ','BOUTIQUE AIR INC'),
33('BVN','FEDERAL EXPRESS CORPORATION'),
34('BYA','BERRY AVIATION INC'),
35('CAP','CIVIL AIR PATROL'),
36('CBC','CB AVIATION INC'),
37('CCK','EXPRESS TRANSPORTATION CORP'),
38('CFS','FEDERAL EXPRESS CORP'),
39('CHR','TANGO JETS LLC'),
40('CIT','TRIANGLE MOUNTAIN PARTNERS LLC'),
41('CKS','KALITTA AIR LLC'),
42('CMB','CARGO AIRCRAFT MANAGEMENT INC'),
43('CMF','PLANE BRILLIANT LLC'),
44('CNS','UNKNOWN AIRLINE'),
45('COL','UNKNOWN AIRLINE'),
46('CON','CONOCOPHILLIPS CO'),
47('CPA','COPA AIRLINES'),
48('CRE','JET OUT LLC'),
49('CSB','KALITTA AIR LLC'),
50('CSI','CSI AVIATION INC'),
51('CTF','MAROON & GOLD LLC'),
52('CTP','WEST CIRQUE LLC'),
53('CWG','UNKNOWN AIRLINE'),
54('CXF','WILMINGTON TRUST CO TRUSTEE'),
55('CXK','AIRLINE TRANSPORT PROFESSIONALS CORP OF USA'),
56('CYO','SKY BALLAS LLC'),
57('DAL','DELTA AIR LINES INC'),
58('DCM','UNKNOWN AIRLINE'),
59('DHR','CREAMER PILOT SERVICES LLC'),
60('DJR','TVPX AIRCRAFT SOLUTIONS INC TRUSTEE'),
61('DL1','DELTA AIR LINES INC'),
62('DL2','DELTA AIR LINES INC'),
63('DLX','UNKNOWN AIRLINE'),
64('DOJ','U S MARSHALS SERVICE'),
65('DOW','HFF XPRESSED LLC'),
66('DRL','UNKNOWN AIRLINE'),
67('DVY','LEGENDS CARGO AIRCRAFT LLC'),
68('DZR','KIEWIT ENGINEERING GROUP INC'),
69('EAL','EASTERN AIRLINES LLC'),
70('EDG','WILMINGTON TRUST CO TRUSTEE'),
71('EDV','DELTA AIR LINES INC'),
72('EJA','UNKNOWN AIRLINE'),
73('EJM','UNKNOWN AIRLINE'),
74('ELZ','UNKNOWN AIRLINE'),
75('EMD','EAGLEMED LLC'),
76('EN3','AMERICAN AIRLINES INC'),
77('ENG','ENG CAPITAL LLC'),
78('ENR','NATIONAL NUCLEAR SECURITY ADMINISTRATION'),
79('ENV','AMERICAN AIRLINES INC'),
80('ENY','AMERICAN AIRLINES INC'),
81('ERY','AIR KENNEDY LLC'),
82('EYN','AMERICAN AIRLINES INC'),
83('FDJ','TOTAL ECLIPSE II LLC'),
84('FDX','FEDERAL EXPRESS CORP'),
85('FEN','PHOENIX AIR GROUP INC'),
86('FFL','UNKNOWN AIRLINE'),
87('FFP','FEDERAL AVIATION ADMINISTRATION'),
88('FFT','UNKNOWN AIRLINE'),
89('FIK','J F AIR TRAFFIC INC'),
90('FLC','FEDERAL AVIATION ADMINISTRATION'),
91('FLT','HUGHES AEROSPACE AVIATION SERVICES LLC'),
92('FRG','UNKNOWN AIRLINE'),
93('FRL','TENAX AEROSPACE LLC'),
94('FTD','UNKNOWN AIRLINE'),
95('FTH','UNKNOWN AIRLINE'),
96('FWK','FLIGHTWORKS INC'),
97('FWR','UNKNOWN AIRLINE'),
98('G42','BANK OF UTAH TRUSTEE'),
99('GDG','007 ENTERPRISES LLC'),
100('GHA','TVPX AIRCRAFT SOLUTIONS INC TRUSTEE'),
101('GJE','JH III LLC'),
102('GLF','GULFSTREAM AEROSPACE CORP'),
103('GLH','CHEVRON U S A INC'),
104('GLT','UNKNOWN AIRLINE'),
105('GRB','PHOENIX AIR GROUP INC'),
106('GTI','ATLAS AIR INC'),
107('GTW','TPC AVIATION LLC'),
108('GTX','GTA AIR INC'),
109('GXA','UNKNOWN AIRLINE'),
110('HAL','HAWAIIAN AIR LINES'),
111('HBA','HIGH ALTITUDE BALLOON'),
112('HER','UNKNOWN AIRLINE'),
113('HNW','HONEYWELL INTERNATIONAL INC'),
114('HOB','HL AIRCRAFT LLC'),
115('HRC','UNKNOWN AIRLINE'),
116('IDD','BANK OF UTAH TRUSTEE'),
117('IFL','IFL GROUP INC'),
118('IJA','UNKNOWN AIRLINE'),
119('JAS','UNKNOWN AIRLINE'),
120('JBU','JETBLUE AIRWAYS CORPORATION'),
121('JCM','UNKNOWN AIRLINE'),
122('JCY','UNKNOWN AIRLINE'),
123('JDS','JAMROCK LEASING LLC'),
124('JEN','UNITED STATES GOVERNMENT'),
125('JIA','AMERICAN AIRLINES INC'),
126('JLG','UNKNOWN AIRLINE'),
127('JNX','JETNEXA TWO LLC'),
128('JNY','UNKNOWN AIRLINE'),
129('JRE','UNKNOWN AIRLINE'),
130('JRT','UNKNOWN AIRLINE'),
131('JSL','SELECTJET LEASE LLC'),
132('JSX','DELUX PUBLIC CHARTER LLC'),
133('JTL','UNKNOWN AIRLINE'),
134('JTM','EAST COAST FLIGHT SERVICES INC'),
135('JTZ','UNKNOWN AIRLINE'),
136('JUS','USA JET AIRLINES INC'),
137('KAI','BANK OF UTAH TRUSTEE'),
138('KCR','KOLOB CANYONS AIR SERVICES INC'),
139('KFB','UNKNOWN AIRLINE'),
140('KFS','KALITTA CHARTERS LLC'),
141('KII','KALITTA CHARTERS II LLC'),
142('KNT','TVPX AIRCRAFT SOLUTIONS INC TRUSTEE'),
143('KOW','UNKNOWN AIRLINE'),
144('KPO','UNKNOWN AIRLINE'),
145('KSL','SEDGWICK COUNTY'),
146('KYE','UMB BANK NA TRUSTEE'),
147('LAE','UNKNOWN AIRLINE'),
148('LBQ','QUEST DIAGNOSTICS CLINICAL LABORATORIES INC'),
149('LFG','UNKNOWN AIRLINE'),
150('LGH','AIRBORNE TACTICAL ADVANTAGE CO LLC'),
151('LJY','UNKNOWN AIRLINE'),
152('LN2','CHARLOTTE MECKLENBURG HOSPITAL AUTHORITY DBA'),
153('LN4','MED FLIGHT AIR AMBULANCE INC'),
154('LN5','MED AIR LLC'),
155('LN6','IHC HEALTH SERVICES INC'),
156('LN9','COOK CHILDRENS HEALTH ENTERPRISES'),
157('LNG','AIRBORNE TACTICAL ADVANTAGE CO LLC'),
158('LSO','BK AVIATION LLC'),
159('LTN','AIRBORNE TACTICAL ADVANTAGE CO LLC'),
160('LXJ','UNKNOWN AIRLINE'),
161('LYM','UNKNOWN AIRLINE'),
162('MAD','MECO AERO LLC'),
163('MDS','MCNEELY CHARTER SERVICE INC'),
164('MJR','BBR AIR LLC'),
165('MR6','AERO LEASING INC'),
166('MRA','MARTINAIRE AVIATION LLC'),
167('MVJ','MIRA VISTA AVIATION INC'),
168('MXY','BREEZE AVIATION GROUP INC'),
169('NAC','NAS AIRCRAFT LEASING CO LLC'),
170('NCR','UNKNOWN AIRLINE'),
171('NGF','GH AVIATION LLC'),
172('NJM','NORTHERN JET MANAGEMENT INC'),
173('NJR','LOS CORALES 601 CORP'),
174('NJZ','DOLLAR AIR LLC'),
175('NKS','SPIRIT AIRLINES LLC'),
176('NOA','UNITED STATES DEPARTMENT OF COMMERCE'),
177('NS2','SPIRIT AIRLINES LLC'),
178('NSH','UNKNOWN AIRLINE'),
179('NTW','MAXAIR LLC'),
180('NUS','CORSA HORIZON LLC'),
181('NXC','UNKNOWN AIRLINE'),
182('OAE','CARGO AIRCRAFT MANAGEMENT INC'),
183('OFT','ONCOURSE AIR LLC'),
184('OKC','UNKNOWN AIRLINE'),
185('OME','AIRCRAFT ENDEAVORS LLC'),
186('ON4','BANK OF UTAH TRUSTEE'),
187('OPT','FLIGHT OPTIONS LLC'),
188('OST','OKLAHOMA STATE UNIVERSITY'),
189('OTA','ORR INVESTMENTS LLC'),
190('OUA','BOARD OF REGENTS OF THE UNIVERSITY OF OKLAHOMA'),
191('PCH','PILATUS BUSINESS AIRCRAFT LTD'),
192('PFT','PERFECT AGREEMENT LEASING INC'),
193('PGR','SMG STARFIRE LLC'),
194('PJC','TVPX AIRCRAFT SOLUTIONS INC TRUSTEE'),
195('PKW','CAREER AVIATION CO INC'),
196('PRD','UNKNOWN AIRLINE'),
197('PRE','UNKNOWN AIRLINE'),
198('PVO','UNKNOWN AIRLINE'),
199('PWA','UNKNOWN AIRLINE'),
200('PWR','UNKNOWN AIRLINE'),
201('PXT','UNKNOWN AIRLINE'),
202('QFA','ATLAS AIR INC'),
203('QHD','MEREGRASS INC'),
204('RAP','VERTICAL AVIATION NO 1 LLC'),
205('RAX','ROYAL AIR FREIGHT INC'),
206('RDN','BOEING COMPANY'),
207('RDY','UNKNOWN AIRLINE'),
208('RJE','THK HOLDINGS LLC'),
209('RJR','MCH AIR LLC'),
210('RKJ','UNKNOWN AIRLINE'),
211('RLI','WHEELS TO WINGS LLC'),
212('RPA','REPUBLIC AIRWAYS INC'),
213('RQT','BPT AVIATION LLC'),
214('RSP','SUPERIOR AIR CHARTER LLC'),
215('RVF','FLOAT ALASKA HOLDINGS LLC'),
216('RVJ','GLEN AVALON LLC'),
217('RVN','FLOAT ALASKA HOLDINGS LLC'),
218('RZN','WILMINGTON TRUST CO TRUSTEE'),
219('S44','AERO SPRAY INC DBA'),
220('SBE','UNKNOWN AIRLINE'),
221('SCJ','CITATION N789XJ LLC'),
222('SCM','TAILWINDS LLC'),
223('SCP','AERO SPRAY INC DBA'),
224('SCR','ISR PLATFORMS LLC'),
225('SCU','UNKNOWN AIRLINE'),
226('SCW','SKYWEST AIRLINES INC'),
227('SCX','SUN COUNTRY INC'),
228('SGX','JST SHUTTLE HOLDINGS LLC'),
229('SIS','UNKNOWN AIRLINE'),
230('SIY','VALIAIR LC TRUSTEE'),
231('SJJ','JD76 AIR LLC'),
232('SKK','UNITED AIRLINES INC'),
233('SKW','SKYWEST AILINES INC'),
234('SKX','SKYWEST AIRLINES INC'),
235('SLH','UNKNOWN AIRLINE'),
236('SLW','SKYWEST AIRLINES INC'),
237('SPA','SIERRA PACIFIC AIRLINES INC'),
238('STK','AIRBORNE TACTICAL ADVANTAGE COMPANY LLC'),
239('STR','AIRBORNE TACTICAL ADVANTAGE COMPANY LLC'),
240('STT','SOUTHPORT AIR LLC'),
241('STV','UNKNOWN AIRLINE'),
242('SVL','UNKNOWN AIRLINE'),
243('SWA','SOUTHWEST AIRLINES INC'),
244('SWK','SKYWEST AIRLINES INC'),
245('SWW','SKYWEST AIRLINES INC'),
246('T88','WESTERN PILOT SERVICE INC'),
247('TAI','UNKNOWN AIRLINE'),
248('TAS','FEDERAL AVIATION ADMINISTRATION'),
249('TBL','TERRIBLE HERBST INC'),
250('TCN','UNKNOWN AIRLINE'),
251('TEK','EXA LLC'),
252('TEX','STATE OF TEXAS'),
253('TFF','UNKNOWN AIRLINE'),
254('TIV','UNKNOWN AIRLINE'),
255('TKH','MATER LOGISTICS LLC'),
256('TKM','JM AVIATION HOLDINGS LLC'),
257('TKR','WESTERN PILOT SERVICE INC'),
258('TMP','CENTENE MANAGEMENT CO LLC'),
259('TOG','JVWL LLC'),
260('TR ','US DEPARTMENT OF HOMELAND SECURITY'),
261('TRF','UNKNOWN AIRLINE'),
262('TRO','DEPARTMENT OF HOMELAND SECURITY'),
263('TTE','TETON LEASING LLC'),
264('TWY','UNKNOWN AIRLINE'),
265('TXG','BANK OF UTAH TRUSTEE'),
266('TYS','UNKNOWN AIRLINE'),
267('UA1','UNITED AIRLINES INC'),
268('UAL','UNITED AIRLINES INC'),
269('UCA','UNITED AIRLINES INC'),
270('ULA','BAYSIDE UNIT LLC'),
271('UPS','UNITED PARCEL SERVICE CO'),
272('USC','KALITTA CHARTERS LLC'),
273('VAD','L-3 COMMUNICATIONS ADVANCED AVIATION LLC'),
274('VET','REGIONS EQUIPMENT FINANCE CORP'),
275('VFR','UNKNOWN AIRLINE'),
276('VJ0','BANK OF UTAH TRUSTEE'),
277('VJA','UNKNOWN AIRLINE'),
278('VNT','UNKNOWN AIRLINE'),
279('VOI','VOLARIS AIRLINES'),
280('VR4','AIRBORNE TACTICAL ADVANTAGE COMPANY LLC'),
281('VTE','CORPORATE FLIGHT MANAGEMENT INC'),
282('VTO','WILMINGTON TRUST CO TRUSTEE'),
283('VXP','BANK OF UTAH TRUSTEE'),
284('VYR','YOUR JET LLC'),
285('WDE','BANK OF UTAH TRUSTEE'),
286('WEJ','LOXODONTA AVIATION LLC'),
287('WGN','MOBILITY AIR LLC'),
288('WML','WOLFPACK AVIATION LLC'),
289('WMN','UNKNOWN AIRLINE'),
290('WOL','UNKNOWN AIRLINE'),
291('WSN','RANCHO PACIFIC HOLDINGS LLC'),
292('WUP','WHEELS UP PARTNERS LLC'),
293('WWI','UNKNOWN AIRLINE'),
294('XAA','UNKNOWN AIRLINE'),
295('XEN','UNKNOWN AIRLINE'),
296('XFL','UNKNOWN AIRLINE'),
297('XGN','TVPX 2022 MSN 9218 BUSINESS TRUST'),
298('XLJ','XCEL JET MANAGEMENT INC'),
299('XLS','NEVADA JET VENTURES LLC'),
300('XSR','EXECUTIVE AIRSHARE LLC'),
301('XXA','UNKNOWN AIRLINE'),
302('YEL','TRANSMEDICS INC');