I’m working on a program to load in all SWA flights for the current day into a database. I was cross referencing the output of AirlineFlightSchedules with tomorrow’s actual flight schedule. It appears there are 1000 or so flights that are in the actual schedule but not outputting via AirlineFlightSchedules. Not sure if this is related or not, but it looks like as the offset increases (by 15 for example), every 5th or 6th record is a duplicate from a previous query.
I am using v3 Beta. Additionally, if you specify an origin airport, that seems to help output some of the ‘missing’ flights, but doesn’t solve the issue completely.
What are some examples of flights that you believe are missing from AirlineFlightSchedules? In some cases, airlines may fly “unscheduled” legs for repositioning, maintenance, or charter purposes. AirlineFlightSchedules will only return flights that have been planned more than a month in advance.
query FlightAware api
found 15 number of rows, start at offset 0 from FlightAware
ATL BWI 1974 SWA1974-1573278351-airline-0415
ATL LAX 1378 SWA1378-1573278351-airline-0512
ATL BNA 2413 SWA2413-1573278351-airline-0401
ATL CLE 239 SWA239-1573278351-airline-0957
ATL LGA 2401 SWA2401-1573278351-airline-0862
ATL LGA 2420 SWA2420-1573278351-airline-0362
ATL LGA 2995 SWA2995-1573278351-airline-0066
ATL LGA 2568 SWA2568-1573278351-airline-0504
ATL LGA 2530 SWA2530-1573278351-airline-0541
ATL CLE 1155 SWA1155-1573278351-airline-0744
ATL STL 2079 SWA2079-1573278351-airline-0347
ATL CMH 2453 SWA2453-1573278351-airline-0147
ATL STL 2393 SWA2393-1573278351-airline-0668
ATL MSY 1167 SWA1167-1573278351-airline-0345
ATL MSY 449 SWA449-1573278351-airline-0947
found results, looping back
found 15 number of rows, start at offset 15 from FlightAware
ATL CMH 4034 SWA4034-1573278351-airline-0465
ATL DAL 2448 SWA2448-1573278351-airline-0254
ATL DAL 367 SWA367-1573278351-airline-0538
ATL DAL 2280 SWA2280-1573278351-airline-0278
ATL DAL 2536 SWA2536-1573278351-airline-0012
ATL DAL 1157 SWA1157-1573278351-airline-0214
ATL DAL 1352 SWA1352-1573278351-airline-0784
ATL DCA 379 SWA379-1573278351-airline-0976
ATL DCA 2502 SWA2502-1573278351-airline-0282
ATL AUS 2156 SWA2156-1573278351-airline-0176
ATL DEN 335 SWA335-1573278351-airline-0883
ATL DEN 2409 SWA2409-1573278351-airline-0466
ATL DEN 2898 SWA2898-1573278351-airline-0333
ATL DEN 2553 SWA2553-1573278351-airline-0983
ATL DEN 1351 SWA1351-1573278351-airline-0428
found results, looping back
found 15 number of rows, start at offset 30 from FlightAware
ATL DEN 2898 SWA2898-1573278351-airline-0333
ATL FLL 408 SWA408-1573278351-airline-0684
ATL FLL 3635 SWA3635-1573278351-airline-0157
ATL FLL 761 SWA761-1573278351-airline-0174
ATL FLL 376 SWA376-1573278351-airline-0108
ATL GSP 275 SWA275-1573278351-airline-0034
ATL GSP 291 SWA291-1573278351-airline-0488
ATL GSP 2567 SWA2567-1573278351-airline-0373
ATL HOU 3283 SWA3283-1573278351-airline-0446
ATL HOU 1505 SWA1505-1573278351-airline-0274
ATL HOU 1189 SWA1189-1573278351-airline-0813
ATL HOU 1338 SWA1338-1573278351-airline-0396
ATL HOU 383 SWA383-1573278351-airline-0736
ATL IAD 641 SWA641-1573278351-airline-0307
ATL IAD 877 SWA877-1573278351-airline-0893
found results, looping back
found 15 number of rows, start at offset 45 from FlightAware
ATL IND 3190 SWA3190-1573278351-airline-0847
ATL JAX 2454 SWA2454-1573278351-airline-0768
ATL JAX 892 SWA892-1573278351-airline-0915
ATL LAS 2179 SWA2179-1573278351-airline-0242
ATL LAS 236 SWA236-1573278351-airline-0695
ATL LAX 3056 SWA3056-1573278351-airline-0959
ATL LAX 997 SWA997-1573278351-airline-0411
ATL LAX 1378 SWA1378-1573278351-airline-0512
ATL LGA 2420 SWA2420-1573278351-airline-0362
ATL LGA 2995 SWA2995-1573278351-airline-0066
ATL LGA 2568 SWA2568-1573278351-airline-0504
ATL LGA 2530 SWA2530-1573278351-airline-0541
ATL LGA 2401 SWA2401-1573278351-airline-0862
ATL MCI 4059 SWA4059-1573278351-airline-0711
ATL MCI 2532 SWA2532-1573278351-airline-0873
found results, looping back
found 15 number of rows, start at offset 60 from FlightAware
ATL MCI 2429 SWA2429-1573278351-airline-0222
ATL MCO 3293 SWA3293-1573278351-airline-0699
ATL MCO 3206 SWA3206-1573278351-airline-0389
ATL MCO 2585 SWA2585-1573278351-airline-0294
ATL MCO 2011 SWA2011-1573278351-airline-0418
ATL MDW 4067 SWA4067-1573278351-airline-0008
ATL MDW 2506 SWA2506-1573278351-airline-0594
ATL MDW 1104 SWA1104-1573278351-airline-0537
ATL MDW 301 SWA301-1573278351-airline-0785
ATL MDW 2603 SWA2603-1573278351-airline-0317
ATL MDW 463 SWA463-1573278351-airline-0421
ATL MKE 606 SWA606-1573278351-airline-0104
ATL MKE 654 SWA654-1573278351-airline-0830
ATL MSY 1167 SWA1167-1573278351-airline-0345
ATL MSY 2605 SWA2605-1573278351-airline-0002
found results, looping back
found 15 number of rows, start at offset 75 from FlightAware
ATL DCA 2002 SWA2002-1573278351-airline-0732
ATL BWI 369 SWA369-1573278351-airline-0547
ATL IND 3190 SWA3190-1573278351-airline-0847
ATL BWI 1974 SWA1974-1573278351-airline-0415
ATL DEN 1351 SWA1351-1573278351-airline-0428
ATL RIC 2272 SWA2272-1573278351-airline-0987
ATL JAX 2454 SWA2454-1573278351-airline-0768
ATL JAX 892 SWA892-1573278351-airline-0915
ATL DAL 2448 SWA2448-1573278351-airline-0254
ATL AUS 2156 SWA2156-1573278351-airline-0176
ATL BNA 211 SWA211-1573278351-airline-0357
ATL DAL 1157 SWA1157-1573278351-airline-0214
ATL RIC 538 SWA538-1573278351-airline-0670
ATL RIC 894 SWA894-1573278351-airline-0613
ATL LAS 2179 SWA2179-1573278351-airline-0242
found results, looping back
found 10 number of rows, start at offset 90 from FlightAware
ATL RIC 894 SWA894-1573278351-airline-0613
ATL RIC 538 SWA538-1573278351-airline-0670
ATL DEN 1351 SWA1351-1573278351-airline-0428
ATL LAS 2179 SWA2179-1573278351-airline-0242
ATL LAS 236 SWA236-1573278351-airline-0695
ATL DAL 2536 SWA2536-1573278351-airline-0012
ATL TPA 2546 SWA2546-1573278351-airline-0990
ATL BNA 211 SWA211-1573278351-airline-0357
ATL DEN 2553 SWA2553-1573278351-airline-0983
ATL TPA 36 SWA36-1573278351-airline-0842
query virtual airline timetable
2530 ATL 06:00:00 LGA SWA2530-1573278351-airline-0541
3206 ATL 06:05:00 MCO SWA3206-1573278351-airline-0389
236 ATL 06:15:00 LAS SWA236-1573278351-airline-0695
562 ATL 06:15:00 TPA
1378 ATL 06:15:00 LAX SWA1378-1573278351-airline-0512
376 ATL 06:20:00 FLL SWA376-1573278351-airline-0108
2553 ATL 06:20:00 DEN SWA2553-1573278351-airline-0983
4067 ATL 06:20:00 MDW SWA4067-1573278351-airline-0008
369 ATL 07:00:00 BWI SWA369-1573278351-airline-0547
1157 ATL 07:00:00 DAL SWA1157-1573278351-airline-0214
565 ATL 07:15:00 PHX
301 ATL 07:50:00 MDW SWA301-1573278351-airline-0785
383 ATL 08:05:00 HOU SWA383-1573278351-airline-0736
239 ATL 08:20:00 CLE SWA239-1573278351-airline-0957
606 ATL 08:20:00 MKE SWA606-1573278351-airline-0104
877 ATL 08:20:00 IAD SWA877-1573278351-airline-0893
3190 ATL 08:20:00 IND SWA3190-1573278351-airline-0847
2003 ATL 08:25:00 PHL
2429 ATL 08:25:00 MCI SWA2429-1573278351-airline-0222
4034 ATL 08:25:00 CMH SWA4034-1573278351-airline-0465
2152 ATL 08:35:00 SAT
2995 ATL 08:55:00 LGA SWA2995-1573278351-airline-0066
3293 ATL 09:20:00 MCO SWA3293-1573278351-airline-0699
1351 ATL 09:35:00 DEN SWA1351-1573278351-airline-0428
3842 ATL 09:35:00 BWI
2605 ATL 09:40:00 MSY SWA2605-1573278351-airline-0002
761 ATL 09:50:00 FLL SWA761-1573278351-airline-0174
997 ATL 09:50:00 LAX SWA997-1573278351-airline-0411
211 ATL 10:10:00 BNA SWA211-1573278351-airline-0357
2156 ATL 10:10:00 AUS SWA2156-1573278351-airline-0176
36 ATL 10:15:00 TPA SWA36-1573278351-airline-0842
735 ATL 10:15:00 SAN
894 ATL 10:25:00 RIC SWA894-1573278351-airline-0613
1352 ATL 10:25:00 DAL SWA1352-1573278351-airline-0784
2454 ATL 10:25:00 JAX SWA2454-1573278351-airline-0768
1238 ATL N/A 10:30:00 PUJ N/A
379 ATL 10:45:00 DCA SWA379-1573278351-airline-0976
3635 ATL 11:10:00 FLL SWA3635-1573278351-airline-0157
1974 ATL 11:25:00 BWI SWA1974-1573278351-airline-0415
291 ATL 11:30:00 GSP SWA291-1573278351-airline-0488
2506 ATL 11:50:00 MDW SWA2506-1573278351-airline-0594
1338 ATL 12:15:00 HOU SWA1338-1573278351-airline-0396
1800 ATL 12:20:00 STL
229 ATL 12:25:00 TPA
2536 ATL 12:40:00 DAL SWA2536-1573278351-airline-0012
2420 ATL 12:45:00 LGA SWA2420-1573278351-airline-0362
1165 ATL 13:05:00 AUS
2585 ATL 13:25:00 MCO SWA2585-1573278351-airline-0294
1104 ATL 13:30:00 MDW SWA1104-1573278351-airline-0537
2409 ATL 13:30:00 DEN SWA2409-1573278351-airline-0466
2561 ATL 14:25:00 BWI
538 ATL 14:40:00 RIC SWA538-1573278351-airline-0670
1505 ATL 14:40:00 HOU SWA1505-1573278351-airline-0274
2502 ATL 15:10:00 DCA SWA2502-1573278351-airline-0282
654 ATL 15:30:00 MKE SWA654-1573278351-airline-0830
2568 ATL 15:30:00 LGA SWA2568-1573278351-airline-0504
519 ATL 15:35:00 OAK
2393 ATL 15:35:00 STL SWA2393-1573278351-airline-0668
4062 ATL 16:05:00 RDU
2280 ATL 16:10:00 DAL SWA2280-1573278351-airline-0278
3056 ATL 16:15:00 LAX SWA3056-1573278351-airline-0959
4059 ATL 16:15:00 MCI SWA4059-1573278351-airline-0711
2567 ATL 16:30:00 GSP SWA2567-1573278351-airline-0373
2603 ATL 16:40:00 MDW SWA2603-1573278351-airline-0317
1155 ATL 16:45:00 CLE SWA1155-1573278351-airline-0744
641 ATL 17:00:00 IAD SWA641-1573278351-airline-0307
1167 ATL 17:20:00 MSY SWA1167-1573278351-airline-0345
2546 ATL 17:25:00 TPA SWA2546-1573278351-airline-0990
2898 ATL 17:55:00 DEN SWA2898-1573278351-airline-0333
367 ATL 18:20:00 DAL SWA367-1573278351-airline-0538
1316 ATL 18:35:00 BWI
1189 ATL 18:45:00 HOU SWA1189-1573278351-airline-0813
3904 ATL 18:45:00 PHX
2413 ATL 19:05:00 BNA SWA2413-1573278351-airline-0401
2011 ATL 19:50:00 MCO SWA2011-1573278351-airline-0418
2401 ATL 19:50:00 LGA SWA2401-1573278351-airline-0862
408 ATL 19:55:00 FLL SWA408-1573278351-airline-0684
449 ATL 19:55:00 MSY SWA449-1573278351-airline-0947
892 ATL 19:55:00 JAX SWA892-1573278351-airline-0915
2347 ATL 19:55:00 TPA
1778 ATL 20:00:00 SAT
2448 ATL 20:05:00 DAL SWA2448-1573278351-airline-0254
1210 ATL 20:10:00 AUS
2002 ATL 20:30:00 DCA SWA2002-1573278351-airline-0732
2569 ATL 20:30:00 RSW
2179 ATL 20:40:00 LAS SWA2179-1573278351-airline-0242
2132 ATL 20:50:00 PBI
335 ATL 21:20:00 DEN SWA335-1573278351-airline-0883
406 ATL 21:55:00 IND
463 ATL 21:55:00 MDW SWA463-1573278351-airline-0421
2412 ATL 21:55:00 RDU
2453 ATL 21:55:00 CMH SWA2453-1573278351-airline-0147
2532 ATL 21:55:00 MCI SWA2532-1573278351-airline-0873
3303 ATL 21:55:00 BNA
758 ATL 22:00:00 PIT
2272 ATL 22:05:00 RIC SWA2272-1573278351-airline-0987
3283 ATL 22:20:00 HOU SWA3283-1573278351-airline-0446
2079 ATL 22:25:00 STL SWA2079-1573278351-airline-0347
275 ATL 22:30:00 GSP SWA275-1573278351-airline-0034
2138 ATL 22:55:00 BWI
The above queries FlightAware v3 API for all departures out of ATL on 11/11/2019. Then compares to what is in our virtual airline timetable. You will see the flights which do not contain a reference to FlightAware in the virtual airline query.
Hello. Could you help me to solve this issue?
I am sure someone from FA will do that, they usually do. Maybe it got overlooked, most people put the problem description first and then post any query results as an example. 
It looks like there are duplicate results in the query data you got from FlightXML. Since you appear to be looking up a day at a time per airport this behavior can be avoided by using a large howMany paramater instead of paging through results.
If you make a howMany request of 150 and only 100 results are returned only the 100 results will be used for counting billable queries.
A bug has been opened to resolve the duplicate entries appearing when using the offset to page through AirlineFlightSchedule results.