# AtcAtis

ATIS (Automatic Terminal Information Service) information for ATC facilities including hours, phone numbers, and descriptions

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

> Ordered by SITE_NO, SITE_TYPE_CODE, ATIS_NO. The ordered by list is also the unique record key. Derived from the legacy TWR9 record.

## Example query

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

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. Not applicable to TRACON, ARTCC or CERAP. |  |  |
| `siteTypeCode` | `AtcAtisSiteTypeCode` | Facility Type Code indicating the type of landing facility |  | `A`=Airport; `H`=Heliport |
| `facilityType` | `FacilityType` | Facility Type describing the ATC facility classification |  | `ATCT`=Air Traffic Control Tower; `ATCT-A/C`=Air Traffic Control Tower plus Approach Control; `ATCT-RAPCON`=Air Traffic Control Tower plus Radar Approach Control (Air Force Operates ATCT/FAA Operates Approach Control); `ATCT-RATCF`=Air Traffic Control Tower plus Radar Approach Control (Navy Operates ATCT/FAA Operates Approach Control); `ATCT-TRACON`=Air Traffic Control Tower plus Terminal Radar Approach Control |
| `stateCode` | `AtcAtisStateCode` | Associated State Post Office Code, standard two-letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (55 values) |
| `facilityId` | `String` | Location Identifier. Unique 3-4 character alphanumeric identifier assigned to the Landing Facility or TRACON. |  |  |
| `city` | `String` | Airport Associated City Name |  |  |
| `countryCode` | `AtcAtisCountryCode` | Country Post Office Code for the country where the airport is located |  | `AN`, `BM`, `BS`, … (7 values) |
| `atisNo` | `AtisNo` | ATIS Serial Number, used to distinguish multiple ATIS services at a single facility |  | `1`=First ATIS; `2`=Second ATIS; `3`=Third ATIS; `4`=Fourth ATIS |
| `description` | `Description` | Optional Description of Purpose fulfilled by the ATIS |  | `ATIS`=Automatic Terminal Information Service (combined arrival/departure); `D-ATIS`=Digital Automatic Terminal Information Service (combined); `D-ATIS (ARR)`=Digital Automatic Terminal Information Service (Arrivals only); `D-ATIS (DEP)`=Digital Automatic Terminal Information Service (Departures only) |
| `atisHrs` | `String` | ATIS Hours of Operation in Local Time |  |  |
| `atisPhoneNo` | `String` | ATIS Phone Number for voice access to the ATIS broadcast |  |  |

## Enum values

### `stateCode` (`AtcAtisStateCode`)

| Code | Description |
|---|---|
| `AK` | Alaska |
| `AL` | Alabama |
| `AR` | Arkansas |
| `AZ` | Arizona |
| `CA` | California |
| `CO` | Colorado |
| `CT` | Connecticut |
| `DC` | District of Columbia |
| `DE` | Delaware |
| `FL` | Florida |
| `GA` | Georgia |
| `GU` | Guam |
| `HI` | Hawaii |
| `IA` | Iowa |
| `ID` | Idaho |
| `IL` | Illinois |
| `IN` | Indiana |
| `KS` | Kansas |
| `KY` | Kentucky |
| `LA` | Louisiana |
| `MA` | Massachusetts |
| `MD` | Maryland |
| `ME` | Maine |
| `MI` | Michigan |
| `MN` | Minnesota |
| `MO` | Missouri |
| `MP` | Northern Mariana Islands |
| `MS` | Mississippi |
| `MT` | Montana |
| `NC` | North Carolina |
| `ND` | North Dakota |
| `NE` | Nebraska |
| `NH` | New Hampshire |
| `NJ` | New Jersey |
| `NM` | New Mexico |
| `NV` | Nevada |
| `NY` | New York |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `SD` | South Dakota |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |
| `WY` | Wyoming |

### `countryCode` (`AtcAtisCountryCode`)

| Code | Description |
|---|---|
| `AN` | Netherlands Antilles |
| `BM` | Bermuda |
| `BS` | Bahamas |
| `CA` | Canada |
| `TC` | Turks and Caicos Islands |
| `US` | United States |
| `VG` | British Virgin Islands |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `siteNo` | `SITE_NO` |
| `siteTypeCode` | `SITE_TYPE_CODE` |
| `facilityType` | `FACILITY_TYPE` |
| `stateCode` | `STATE_CODE` |
| `facilityId` | `FACILITY_ID` |
| `city` | `CITY` |
| `countryCode` | `COUNTRY_CODE` |
| `atisNo` | `ATIS_NO` |
| `description` | `DESCRIPTION` |
| `atisHrs` | `ATIS_HRS` |
| `atisPhoneNo` | `ATIS_PHONE_NO` |