AirOperations

GET /udl/aircraftsortie/history

Changed on May 29, 2025

Service operation to dynamically query historical data by a variety of query parameters not specified in this API documentation. See the queryhelp operation (/udl/<datatype>/queryhelp) for more details on valid/required query parameter information.

Request

Base URL
https://unifieddatalibrary.com
URL
https://unifieddatalibrary.com/udl/aircraftsortie/history
Auth
none declared

Query parameters

columnsstring

optional, fields for retrieval. When omitted, ALL fields are assumed. See the queryhelp operation (/udl/<datatype>/queryhelp) for more details on valid query fields that can be selected.

plannedDepTimestring date-time required

The scheduled time that the Aircraft sortie is planned to depart, in ISO 8601 UTC format with millisecond precision. (YYYY-MM-DDTHH:MM:SS.sssZ)

firstResultinteger

maxResultsinteger

Response

idstring

Unique identifier of the record, auto-generated by the system.

classificationMarkingstring required

Classification marking of the data in IC/CAPCO Portion-marked format.

origSortieIdstring

The sortie identifier provided by the originating source.

idAircraftstring

Unique identifier of the aircraft.

aircraftAltIdstring

Alternate Aircraft Identifier provided by source.

tailNumberstring

The tail number of the aircraft assigned to this sortie.

aircraftMDSstring

The aircraft Model Design Series designation assigned to this sortie.

aircraftADSBstring

The Automatic Dependent Surveillance-Broadcast (ADS-B) device identifier.

sortieDatestring date

The scheduled UTC date for this sortie, in ISO 8601 date-only format (ex. YYYY-MM-DD).

lineNumberinteger

The external system line number of this sortie.

idMissionstring

The unique identifier of the mission to which this sortie is assigned.

missionIdstring

The mission ID according to the source system.

amcMsnNumstring

The Air Mobility Command (AMC) mission number of the sortie.

amcMsnTypestring

The type of mission (e.g. SAAM, CHNL, etc.).

callSignstring

The call sign assigned to the aircraft on this sortie.

jcsPrioritystring

Joint Chiefs of Staff priority of this sortie.

primarySCLstring

The planned primary Standard Conventional Load of the aircraft for this sortie.

secondarySCLstring

The planned secondary Standard Conventional Load of the aircraft for this sortie.

reqConfigstring

Aircraft configuration required for the mission.

cargoConfigstring

Description of the cargo configuration (e.g. C-1, C-2, C-3, DV-1, DV-2, AE-1, etc.) currently on board the aircraft. Configuration meanings are determined by the data source.

fuelReqnumber double

Mass of fuel required for this leg of the sortie, in kilograms.

oxyReqCrewnumber double

Liquid oxygen required on the aircraft for the crew compartment, in liters.

oxyOnCrewnumber double

Liquid oxygen onboard the aircraft for the crew compartment, in liters.

oxyReqPaxnumber double

Liquid oxygen required on the aircraft for the troop compartment, in liters.

oxyOnPaxnumber double

Liquid oxygen onboard the aircraft for the troop compartment, in liters.

alertStatusCodestring

The Alert Status code.

alertStatusinteger

The amount of time allowed between launch order and takeoff, in seconds.

currentStatestring

The current state of this sortie.

depItineraryinteger

The itinerary identifier of the departure location.

depICAOstring

The departure International Civil Aviation Organization (ICAO) of this sortie.

depIATAstring

The departure International Aviation Transport Association (IATA) code of this sortie.

depFAAstring

The departure Federal Aviation Administration (FAA) code of this sortie.

plannedDepTimestring date-time required

The scheduled time that the Aircraft sortie is planned to depart, in ISO 8601 UTC format with millisecond precision.

estDepTimestring date-time

The current estimated time that the Aircraft is planned to depart, in ISO 8601 UTC format with millisecond precision.

actualDepTimestring date-time

The actual departure time, in ISO 8601 UTC format.

estBlockOutTimestring date-time

The estimated time the Aircraft will begin to taxi from its parking position, in ISO 8601 UTC format with millisecond precision.

actualBlockOutTimestring date-time

The actual time the Aircraft begins to taxi from its parking position, in ISO 8601 UTC format with millisecond precision.

depPurposeCodestring

Purpose code at the departure location of this sortie.

arrItineraryinteger

The itinerary identifier of the arrival location.

arrICAOstring

The arrival International Civil Aviation Organization (ICAO) of this sortie.

arrIATAstring

The arrival International Aviation Transport Association (IATA) code of this sortie.

arrFAAstring

The arrival Federal Aviation Administration (FAA) code of this sortie.

plannedArrTimestring date-time

The scheduled time that the Aircraft sortie is planned to arrive, in ISO 8601 UTC format with millisecond precision.

estArrTimestring date-time

The current estimated time that the Aircraft is planned to arrive, in ISO 8601 UTC format with millisecond precision.

actualArrTimestring date-time

The actual arrival time, in ISO 8601 UTC format with millisecond precision.

estBlockInTimestring date-time

The estimated time the Aircraft will come to a complete stop in its parking position, in ISO 8601 UTC format with millisecond precision.

actualBlockInTimestring date-time

The actual time the Aircraft comes to a complete stop in its parking position, in ISO 8601 UTC format with millisecond precision.

arrPurposeCodestring

Purpose code at the arrival location of this sortie.

dhdstring date-time

Due home date by which the aircraft must return to its home station, in ISO 8601 UTC format with millisecond precision.

dhdReasonstring

Reason the aircraft must return to home station by its due home date.

aircraftEventstring

Aircraft event text.

soestring

Indicates the group responsible for recording the completion time of the next event in the sequence of events assigned to this sortie (e.g. OPS - Operations, MX - Maintenance, TR - Transportation, etc.).

legNuminteger

The leg number of this sortie.

flightTimenumber double

The planned flight time for this sortie, in minutes.

gndTimenumber double

Scheduled ground time, in minutes.

rawFileURIstring

When crew papers are associated to this sortie, the system updates this value. This field is the URI location in the document repository of that raw file. To download the raw file, prepend https://udl-hostname/scs/download?id= to this field's value.

papersVersionstring

The version number of the crew paper.

filenamestring

Name of the uploaded PDF.

filesizeinteger

Size of the supporting PDF, in bytes.

paperStatus'PUBLISHED' | 'DELETED' | 'UPDATED' | 'READ'

The status of the supporting document.

pprStatus'NOT REQUIRED' | 'REQUIRED NOT REQUESTED' | 'GRANTED' | 'PENDING'

The prior permission required (PPR) status.

missionUpdatestring date-time

Time the associated mission data was last updated in relation to the aircraft assignment, in ISO 8601 UTC format with millisecond precision. If this time is coming from an external system, it may not sync with the latest mission time associated to this record.

delayCodestring

The primary delay code.

commanderNamestring

The last name of the aircraft commander.

fmDeskNumstring

Desk phone number of the flight manager assigned to the sortie. Null when no flight manager is assigned.

fmNamestring

Last name of the flight manager assigned to the sortie. Null when no flight manager is assigned.

rvnReq'N' | 'R' | 'C6' | 'R6'

Type of Ravens required for this sortie (N - None, R - Raven (Security Team) required, C6 - Consider ravens (Ground time over 6 hours), R6 - Ravens required (Ground time over 6 hours)).

passengersinteger

The number of passengers tasked for this sortie.

parkingLocstring

The POI parking location.

objectiveRemarksstring

Remarks concerning the sortie objective.

aircraftRemarksstring

Remarks concerning the aircraft.

scheduleRemarksstring

Remarks concerning the schedule.

resultRemarksstring

Remarks concerning the results of this sortie.

createdAtstring date-time

Time the row was created in the database, auto-populated by the system.

createdBystring

Application user who created the row in the database, auto-populated by the system.

updatedAtstring date-time

Time the row was updated in the database, auto-populated by the system.

updatedBystring

Application user who updated the row in the database, auto-populated by the system.

sourceDLstring

The source data library from which this record was received. This could be a remote or tactical UDL or another data library. If null, the record should be assumed to have originated from the primary Enterprise UDL.

sourcestring required

Source of the data.

originstring

Originating system or organization which produced the data, if different from the source. The origin may be different than the source if the source was a mediating system which forwarded the data on behalf of the origin system. If null, the source may be assumed to be the origin.

dataMode'REAL' | 'TEST' | 'SIMULATED' | 'EXERCISE' required

Indicator of whether the data is REAL, TEST, EXERCISE, or SIMULATED data:

REAL: Data collected or produced that pertains to real-world objects, events, and analysis.

TEST: Specific datasets used to evaluate compliance with specifications and requirements, and for validating technical, functional, and performance characteristics.

EXERCISE: Data pertaining to a government or military exercise. The data may include both real and simulated data.

SIMULATED: Synthetic data generated by a model to mimic real-world datasets.

origNetworkstring

The originating source network on which this record was created, auto-populated by the system.

Example response

[
  {
    "id": "AIRCRAFTSORTIE-ID",
    "classificationMarking": "U",
    "origSortieId": "A0640",
    "idAircraft": "REF-AIRCRAFT-ID",
    "aircraftAltId": "ALT-AIRCRAFT-ID",
    "tailNumber": "Tail_1",
    "aircraftMDS": "C017A",
    "aircraftADSB": "AE123C",
    "sortieDate": "2021-01-01",
    "lineNumber": 99,
    "idMission": "fa18d96e-91ea-60da-a7a8-1af6500066c8",
    "missionId": "ABLE",
    "amcMsnNum": "AJM512571333",
    "amcMsnType": "SAAM",
    "callSign": "BAKER",
    "jcsPriority": "1A3",
    "primarySCL": "ABC",
    "secondarySCL": "ABC",
    "reqConfig": "C-1",
    "cargoConfig": "C-1",
    "fuelReq": 20000.1,
    "oxyReqCrew": 12.3,
    "oxyOnCrew": 12.3,
    "oxyReqPax": 12.3,
    "oxyOnPax": 12.3,
    "alertStatusCode": "C1",
    "alertStatus": 22,
    "currentState": "Park",
    "depItinerary": 100,
    "depICAO": "KCOS",
    "depIATA": "AAA",
    "depFAA": "FAA1",
    "plannedDepTime": "2021-01-01T01:01:01.123Z",
    "estDepTime": "2021-01-01T01:01:01.123Z",
    "actualDepTime": "2021-01-01T01:01:01.123Z",
    "estBlockOutTime": "2021-01-01T00:55:01.123Z",
    "actualBlockOutTime": "2021-01-01T00:55:01.123Z",
    "depPurposeCode": "P",
    "arrItinerary": 101,
    "arrICAO": "KCOS",
    "arrIATA": "AAA",
    "arrFAA": "FAA1",
    "plannedArrTime": "2021-01-01T01:01:01.123Z",
    "estArrTime": "2021-01-01T01:01:01.123Z",
    "actualArrTime": "2021-01-01T01:01:01.123Z",
    "estBlockInTime": "2021-01-01T01:06:01.123Z",
    "actualBlockInTime": "2021-01-01T01:06:01.123Z",
    "arrPurposeCode": "O",
    "dhd": "2021-01-03T01:01:01.123Z",
    "dhdReason": "Due for maintenance",
    "aircraftEvent": "Example event",
    "soe": "OPS",
    "legNum": 14,
    "flightTime": 104.5,
    "gndTime": 387.8,
    "rawFileURI": "Example URI",
    "papersVersion": "1.1",
    "filename": "ExampleFileName",
    "filesize": 12,
    "paperStatus": "PUBLISHED",
    "pprStatus": "PENDING",
    "missionUpdate": "2024-09-09T01:01:01.123Z",
    "delayCode": "500",
    "commanderName": "Smith",
    "fmDeskNum": "7198675309",
    "fmName": "Smith",
    "rvnReq": "R",
    "passengers": 17,
    "parkingLoc": "KCOS",
    "objectiveRemarks": "Some objective remark about aircraft A",
    "aircraftRemarks": "Some remark about aircraft A",
    "scheduleRemarks": "Some schedule remark about aircraft A",
    "resultRemarks": "Some remark about aircraft A",
    "createdAt": "2022-01-01T16:00:00.123Z",
    "createdBy": "some.user",
    "updatedAt": "2018-01-01T16:00:00.123Z",
    "updatedBy": "some.user",
    "sourceDL": "AXE",
    "source": "Bluestaq",
    "origin": "THIRD_PARTY_DATASOURCE",
    "dataMode": "TEST",
    "origNetwork": "OPS1",
    "crew": {
      "id": "bdad6945-c9e4-b829-f7be-1ad075541921",
      "classificationMarking": "U",
      "origCrewId": "JHJDHjhuu929o92",
      "crewName": "falcon",
      "status": "APPROVED",
      "idSortie": "4ef3d1e8-ab08-ab70-498f-edc479734e5c",
      "missionId": "AJM123456123",
      "missionAlias": "PACIFIC DEPLOY / CHAP 3 MOVEMENT",
      "crewSource": "ACTIVE",
      "crewRole": "DEADHEAD",
      "crewType": "AIRLAND",
      "personnelType": "AIRCREW",
      "stageName": "Falcon Squadron",
      "crewWing": "60AMW",
      "crewSquadron": "21AS",
      "maleOfficerQty": 1,
      "femaleOfficerQty": 1,
      "maleEnlistedQty": 3,
      "femaleEnlistedQty": 2,
      "commanderId": "763a1c1e8d2f3c16af825a11e3f1f579",
      "commanderName": "John Doe",
      "commanderLast4SSN": "1234",
      "legalAlertTime": "2022-01-01T16:00:00.123Z",
      "legalBravoTime": "2022-01-01T16:00:00.123Z",
      "alertedTime": "2022-01-01T16:00:00.123Z",
      "lastAlertTime": "2024-01-01T16:00:00.123Z",
      "alertType": "ALPHA",
      "pickupTime": "2024-01-01T16:00:00.123Z",
      "returnTime": "2022-01-01T16:00:00.123Z",
      "adjReturnTime": "2024-01-01T16:00:00.123Z",
      "adjReturnTimeApprover": "Smith",
      "preRestStart": "2024-01-01T16:00:00.123Z",
      "postRestEnd": "2024-01-02T16:00:00.123Z",
      "postRestOffset": "+05:00",
      "stageTime": "2024-01-01T16:00:00.123Z",
      "stage1Qual": "1AXXX",
      "stage2Qual": "2AXXX",
      "stage3Qual": "3AXXX",
      "initStartTime": "2024-01-01T16:00:00.123Z",
      "currentICAO": "KCOS",
      "idSiteCurrent": "b677cf3b-d44d-450e-8b8f-d23f997f8778",
      "fltAuthNum": "KT001",
      "reqQualCode": [
        "AL",
        "CS"
      ],
      "assignedQualCode": [
        "AL",
        "CS"
      ],
      "transportReq": true,
      "crewRMS": "ARMS",
      "crewUnit": "00016ALSQ",
      "fdpEligType": "A",
      "fdpType": "A",
      "tripKit": "TK-1234",
      "aircraftMDS": "C017A",
      "armsCrewUnit": "00016ALSQ",
      "crewMembers": [
        {
          "lastName": "Smith",
          "firstName": "Freddie",
          "middleInitial": "G",
          "gender": "F",
          "memberId": "12345678abc",
          "last4SSN": "1234",
          "dodID": "0123456789",
          "username": "fgsmith",
          "dutyPosition": "IP",
          "crewPosition": "EP A",
          "memberType": "AIRCREW",
          "branch": "Air Force",
          "rank": "Capt",
          "wing": "60AMW",
          "squadron": "21AS",
          "flySquadron": "141ARS",
          "loanedTo": "Thunderbirds",
          "memberSource": "ACTIVE",
          "dutyStatus": "AGR",
          "memberStageName": "Falcon Squadron",
          "rmsMDS": "C017A",
          "phoneNumber": "+14155552671",
          "lodging": "Peterson SFB",
          "memberTransportReq": true,
          "memberPreRestTime": "2024-01-01T16:00:00.123Z",
          "memberLegalAlertTime": "2024-01-01T16:00:00.123Z",
          "memberSchedAlertTime": "2024-02-26T09:15:00.123Z",
          "memberActualAlertTime": "2024-02-26T09:15:00.123Z",
          "memberLastAlertTime": "2024-01-01T16:00:00.123Z",
          "memberPickupTime": "2024-02-26T10:15:00.123Z",
          "showTime": "2024-02-26T10:15:00.123Z",
          "memberReturnTime": "2024-01-01T16:00:00.123Z",
          "memberAdjReturnTime": "2024-01-01T16:00:00.123Z",
          "memberAdjReturnTimeApprover": "Smith",
          "memberInitStartTime": "2024-01-01T16:00:00.123Z",
          "memberPostRestTime": "2024-01-02T16:00:00.123Z",
          "memberPostRestOffset": "+05:00",
          "allSortie": true,
          "attached": true,
          "funded": true,
          "approved": true,
          "notified": true,
          "alerted": true,
          "emailed": true,
          "extraTime": true,
          "grounded": true,
          "guestStart": "2024-01-01T16:00:00.123Z",
          "guestStop": "2024-01-01T16:00:00.123Z",
          "physAvCode": "D",
          "physAvStatus": "OVERDUE",
          "physDue": "2024-01-01T16:00:00.123Z",
          "trainingDate": "2024-01-01T16:00:00.123Z",
          "lastFltDate": "2024-01-01T16:00:00.123Z",
          "fltRecDate": "2024-01-01T16:00:00.123Z",
          "fltRecDue": "2024-01-01T16:00:00.123Z",
          "fltCurrencyExp": "2024-01-01T16:00:00.123Z",
          "fltCurrencyExpId": "SS05AM",
          "gndCurrencyExp": "2024-01-01T16:00:00.123Z",
          "gndCurrencyExpId": "AH03YM",
          "remarkCode": "ABE33",
          "memberRemarks": "Crew member remark"
        }
      ],
      "createdAt": "2022-01-01T16:00:00.123Z",
      "createdBy": "some.user",
      "updatedAt": "2022-01-01T16:00:00.123Z",
      "updatedBy": "some.user",
      "sourceDL": "AXE",
      "source": "Bluestaq",
      "origin": "THIRD_PARTY_DATASOURCE",
      "origNetwork": "OPS1",
      "dataMode": "TEST"
    },
    "sortiePPR": [
      {
        "id": "SORTIEPPR-ID",
        "classificationMarking": "U",
        "idSortie": "4ef3d1e8-ab08-ab70-498f-edc479734e5c",
        "externalId": "aa714f4d52a37ab1a00b21af9566e379",
        "number": "07-21-07W",
        "startTime": "2024-01-01T01:01:01.123Z",
        "endTime": "2024-01-01T01:01:01.123Z",
        "requestor": "jsmith1",
        "grantor": "SMITH",
        "type": "M",
        "remarks": "PPR remark",
        "createdAt": "2022-01-01T16:00:00.123Z",
        "createdBy": "some.user",
        "updatedAt": "2018-01-01T16:00:00.123Z",
        "updatedBy": "some.user",
        "sourceDL": "AXE",
        "source": "Bluestaq",
        "origin": "THIRD_PARTY_DATASOURCE",
        "origNetwork": "OPS1",
        "dataMode": "TEST"
      }
    ]
  }
]

Changes

May 29, 20254e1cbc17e814 Revision changes
- info
  added the new optional query request parameter firstResult
- info
  added the new optional query request parameter maxResults
Apr 16, 202575f764c843a9 Revision changes
- warning
  removed the optional property // from the response with the status
- warning
  removed the optional property // from the response with the status
- warning
  removed the optional property // from the response with the status
- warning
  removed the optional property // from the response with the status
- info
  api operation id findAllHistory_2 removed and replaced with
- info
  the endpoint scheme security BasicAuth was removed from the API
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property //// to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status
- info
  added the optional property // to the response with the status

Some revisions have not been checked yet.

Operation history