# MtrAgy

Military Training Route agency contact information including originating and scheduling agencies

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

> Ordered by ROUTE_TYPE_CODE, ROUTE_ID, AGENCY_TYPE. The ordered-by list is also the unique record key. Agency types include originating and up to four scheduling agencies.

## Example query

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

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 |  |  |
| `routeTypeCode` | `RouteTypeCode` | MTR Type Code indicating whether the route is IFR or VFR |  | `IR`=IFR; `VR`=VFR |
| `routeId` | `String` | Route Identifier. Along with ROUTE_TYPE_CODE creates a unique MTR identifier |  |  |
| `artcc` | `String` | List of ARTCC Idents that the MTR traverses. Multiple ARTCCs separated by spaces when route crosses multiple centers |  |  |
| `agencyType` | `AgencyType` | MTR Agency Type Code indicating the role of the agency in relation to the route |  | `O`=Originating; `S1`=Scheduling-1; `S2`=Scheduling-2; `S3`=Scheduling-3; `S4`=Scheduling-4 |
| `agencyName` | `String` | Agency organization name |  |  |
| `station` | `String` | Agency station or installation name |  |  |
| `address` | `String` | Agency mailing or physical address |  |  |
| `city` | `String` | Agency city |  |  |
| `stateCode` | `String` | Agency state using standard two-letter post office abbreviation for US states and territories |  |  |
| `zipCode` | `String` | Agency ZIP code |  |  |
| `commercialNo` | `String` | Agency commercial phone number |  |  |
| `dsnNo` | `String` | Agency Defense Switched Network (DSN) phone number |  |  |
| `hours` | `String` | Agency hours of operation and scheduling availability |  |  |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `routeTypeCode` | `ROUTE_TYPE_CODE` |
| `routeId` | `ROUTE_ID` |
| `artcc` | `ARTCC` |
| `agencyType` | `AGENCY_TYPE` |
| `agencyName` | `AGENCY_NAME` |
| `station` | `STATION` |
| `address` | `ADDRESS` |
| `city` | `CITY` |
| `stateCode` | `STATE_CODE` |
| `zipCode` | `ZIP_CODE` |
| `commercialNo` | `COMMERCIAL_NO` |
| `dsnNo` | `DSN_NO` |
| `hours` | `HOURS` |