# MilOps

Military operations data for landing facilities including military agency type, call signs, and hours of operation

**Source:** NASR table `MIL_OPS` · version `e25086c3e952` · effective 2026-04-16

> Designed from a deconstruction of the legacy TWR.txt Subscriber File as a logical grouping of military data found in the TWR1 and TWR2 records and remarks found in the TWR6 record. Unique record key is SITE_NO + SITE_TYPE_CODE.

## Example query

```graphql
# Introspect the MilOps type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    siteNo
    siteTypeCode
    stateCode
  # }
}
```

Run at https://api.nav.sortie.co/graphql (GraphiQL available in-browser).

## Fields

| Field | Type | Description | Units | Enum |
|---|---|---|---|---|
| `effDate` | `String` | The 28 Day NASR Subscription Effective Date in format YYYY/MM/DD |  |  |
| `siteNo` | `String` | Landing Facility Site Number. A unique identifying number identifying the landing facility. |  |  |
| `siteTypeCode` | `SiteTypeCode` | Facility Type Code indicating the type of landing facility |  | `A`=Airport; `B`=Balloonport; `C`=Seaplane Base; `G`=Gliderport; `H`=Heliport; `U`=Ultralight |
| `stateCode` | `String` | Associated State Post Office Code, standard two-letter abbreviation for US States and Territories |  |  |
| `arptId` | `String` | Location Identifier. Unique 3-4 character alphanumeric identifier assigned to the Landing Facility |  |  |
| `city` | `String` | Airport Associated City Name |  |  |
| `countryCode` | `MilOpsCountryCode` | Country Post Office Code for the country where the airport is located |  | `MH`=Marshall Islands; `US`=United States |
| `milOpsOperCode` | `MilOpsOperCode` | Military Agency Type Code that Operates the Control Facility |  | `A`=U.S. Air Force; `C`=U.S. Coast Guard; `F`=Federal Aviation Administration; `N`=U.S. Navy; `R`=U.S. Army |
| `milOpsCall` | `String` | Radio Call Name for Military Operations at this Control Facility |  |  |
| `milOpsHrs` | `String` | Hours of Military Operations Conducted each Day |  |  |
| `amcpHrs` | `String` | Hours of Operation of the Military Aircraft Command Post (AMCP) located at the facility |  |  |
| `pmsvHrs` | `String` | Hours of Operation of the Military Pilot-To-Metro Service (PMSV) located at the facility |  |  |
| `remark` | `String` | Remark associated with Military Operations at the facility |  |  |

## Column provenance

Every field maps 1:1 to a column in the `MIL_OPS` table of `nasr.db`. Original FAA column names:

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `siteNo` | `SITE_NO` |
| `siteTypeCode` | `SITE_TYPE_CODE` |
| `stateCode` | `STATE_CODE` |
| `arptId` | `ARPT_ID` |
| `city` | `CITY` |
| `countryCode` | `COUNTRY_CODE` |
| `milOpsOperCode` | `MIL_OPS_OPER_CODE` |
| `milOpsCall` | `MIL_OPS_CALL` |
| `milOpsHrs` | `MIL_OPS_HRS` |
| `amcpHrs` | `AMCP_HRS` |
| `pmsvHrs` | `PMSV_HRS` |
| `remark` | `REMARK` |