# AtcBase

Base ATC facility information including tower operator, approach/departure control providers, and hours of operation

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

> Ordered by FACILITY_ID, FACILITY_TYPE. The ordered by list is also the unique record key. Not all fields apply to TRACON, ARTCC, or CERAP facilities.

## Example query

```graphql
# Introspect the AtcBase 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` | `AtcBaseSiteTypeCode` | Facility Type Code indicating the type of landing facility |  | `A`, `B`, `C`, … (7 values) |
| `facilityType` | `AtcBaseFacilityType` | Facility Type describing the ATC facility classification |  | `ATCT`, `ATCT-A/C`, `ATCT-RAPCON`, … (9 values) |
| `stateCode` | `AtcBaseStateCode` | Associated State Post Office Code, standard two-letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (58 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` | `AtcBaseCountryCode` | Country Post Office Code for the country where the airport is located |  | `AI`, `AN`, `BM`, … (14 values) |
| `icaoId` | `String` | ICAO Identifier for the facility |  |  |
| `facilityName` | `String` | Official Facility Name |  |  |
| `regionCode` | `RegionCode` | FAA Region Code indicating the FAA region responsible for the facility |  | `AAL`, `ACE`, `AEA`, … (9 values) |
| `twrOperatorCode` | `TwrOperatorCode` | Operator Code of the Agency that Operates the Tower |  | `A`, `C`, `CITY`, … (16 values) |
| `twrCall` | `String` | Radio Call used by Pilot to Contact Tower |  |  |
| `twrHrs` | `String` | Hours of Tower Operation in Local Time |  |  |
| `primaryApchRadioCall` | `String` | Radio Call of Facility That Furnishes Primary Approach Control |  |  |
| `apchPProvider` | `String` | Facility ID (or Provider Description when Provider Type equals S) of the Agency That Operates the Primary Approach Control Facility/Functions |  |  |
| `apchPProvTypeCd` | `ApchPProvTypeCd` | Provider Agency Type Code for Agency that Operates the Primary Approach Control Facility/Functions |  | `A`=Airport (with ATCT); `C`=ARTCC; `S`=Special; `T`=TRACON |
| `secondaryApchRadioCall` | `SecondaryApchRadioCall` | Radio Call of Facility That Furnishes Secondary Approach Control |  | `ALBUQUERQUE ARTCC`, `ATLANTA ARTCC`, `BANGOR`, … (30 values) |
| `apchSProvider` | `ApchSProvider` | Facility ID (or Provider Description when Provider Type equals S) of the Agency That Operates the Secondary Approach Control Facility/Functions |  | `APCH/S CALL IS CHICAGO ARTCC`, `BGR`, `CAE`, … (31 values) |
| `apchSProvTypeCd` | `ApchPProvTypeCd` | Provider Agency Type Code for Agency that Operates the Secondary Approach Control Facility/Functions |  | `A`=Airport (with ATCT); `C`=ARTCC; `S`=Special; `T`=TRACON |
| `primaryDepRadioCall` | `String` | Radio Call of Facility That Furnishes Primary Departure Control |  |  |
| `depPProvider` | `String` | Facility ID (or Provider Description when Provider Type equals S) of the Agency That Operates the Primary Departure Control Facility/Functions |  |  |
| `depPProvTypeCd` | `ApchPProvTypeCd` | Provider Agency Type Code for Agency that Operates the Primary Departure Control Facility/Functions |  | `A`=Airport (with ATCT); `C`=ARTCC; `S`=Special; `T`=TRACON |
| `secondaryDepRadioCall` | `SecondaryApchRadioCall` | Radio Call of Facility That Furnishes Secondary Departure Control |  | `ALBUQUERQUE ARTCC`, `ATLANTA ARTCC`, `BANGOR`, … (30 values) |
| `depSProvider` | `DepSProvider` | Facility ID (or Provider Description when Provider Type equals S) of the Agency That Operates the Secondary Departure Control Facility/Functions |  | `BGR`, `CAE`, `CRW`, … (31 values) |
| `depSProvTypeCd` | `ApchPProvTypeCd` | Provider Agency Type Code for Agency that Operates the Secondary Departure Control Facility/Functions |  | `A`=Airport (with ATCT); `C`=ARTCC; `S`=Special; `T`=TRACON |
| `ctlFacApchDepCalls` | `String` | Approach/Departure Call associated with a Control Facility |  |  |
| `apchDepOperCode` | `ApchDepOperCode` | Agency Type Code that Operates the Control Facility |  | `A`=U.S. Air Force; `F`=Federal Aviation Administration; `N`=U.S. Navy; `R`=U.S. Army |
| `ctlPrvdingHrs` | `String` | Hours of Operation of the Primary Control Facility in Local Time |  |  |
| `secondaryCtlPrvdingHrs` | `String` | Hours of Operation of the Secondary Control Facility in Local Time |  |  |

## Enum values

### `siteTypeCode` (`AtcBaseSiteTypeCode`)

| Code | Description |
|---|---|
| `A` | Airport |
| `B` | Balloonport |
| `C` | Seaplane Base |
| `G` | Gliderport |
| `H` | Heliport |
| `U` | Ultralight |
| `V` | Vertiport |

### `facilityType` (`AtcBaseFacilityType`)

| Code | Description |
|---|---|
| `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 |
| `NON-ATCT` | Non-Air Traffic Control Tower |
| `TRACON` | Consolidated TRACON |
| `ARTCC` | Air Route Traffic Control Center |
| `CERAP` | Center Radar Approach Control Facility |

### `stateCode` (`AtcBaseStateCode`)

| Code | Description |
|---|---|
| `AK` | Alaska |
| `AL` | Alabama |
| `AR` | Arkansas |
| `AS` | American Samoa |
| `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 |
| `QM` | Kwajalein Atoll (US Army Kwajalein Atoll) |
| `QW` | Wake Island |
| `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` (`AtcBaseCountryCode`)

| Code | Description |
|---|---|
| `AI` | Anguilla |
| `AN` | Netherlands Antilles |
| `BM` | Bermuda |
| `BS` | Bahamas |
| `CA` | Canada |
| `FM` | Federated States of Micronesia |
| `IO` | British Indian Ocean Territory |
| `MF` | Saint Martin |
| `MH` | Marshall Islands |
| `PW` | Palau |
| `SH` | Saint Helena |
| `TC` | Turks and Caicos Islands |
| `US` | United States |
| `VG` | British Virgin Islands |

### `regionCode` (`RegionCode`)

| Code | Description |
|---|---|
| `AAL` | Alaska |
| `ACE` | Central |
| `AEA` | Eastern |
| `AGL` | Great Lakes |
| `ANE` | New England |
| `ANM` | Northwest Mountain |
| `ASO` | Southern |
| `ASW` | Southwest |
| `AWP` | Western-Pacific |

### `twrOperatorCode` (`TwrOperatorCode`)

| Code | Description |
|---|---|
| `A` | U.S. Air Force |
| `C` | U.S. Coast Guard |
| `CITY` | City |
| `COUNTY` | County |
| `D` | Canadian Ministry of Transport |
| `F` | Federal Aviation Administration |
| `FCT` | FAA Contract Tower |
| `G` | Federal Government - Not U.S.A. |
| `N` | U.S. Navy |
| `NFCT` | Non-Federal Control Tower |
| `O` | Other |
| `P` | Private |
| `R` | U.S. Army |
| `W` | U.S. Weather Service |
| `X` | Royal Canadian Air Force |
| `Z` | Unknown |

### `secondaryApchRadioCall` (`SecondaryApchRadioCall`)

| Code | Description |
|---|---|
| `ALBUQUERQUE ARTCC` | Albuquerque Air Route Traffic Control Center |
| `ATLANTA ARTCC` | Atlanta Air Route Traffic Control Center |
| `BANGOR` | Bangor Approach Control |
| `BOSTON ARTCC` | Boston Air Route Traffic Control Center |
| `CHARLESTON` | Charleston Approach Control |
| `CHICAGO ARTCC` | Chicago Air Route Traffic Control Center |
| `CLEVELAND ARTCC` | Cleveland Air Route Traffic Control Center |
| `COLUMBIA` | Columbia Approach Control |
| `DENVER ARTCC` | Denver Air Route Traffic Control Center |
| `DETROIT` | Detroit Approach Control |
| `FORT WORTH ARTCC` | Fort Worth Air Route Traffic Control Center |
| `HCF CENTER` | Honolulu Control Facility Center |
| `HOUSTON ARTCC` | Houston Air Route Traffic Control Center |
| `INDIANAPOLIS ARTCC` | Indianapolis Air Route Traffic Control Center |
| `JACKSONVILLE ARTCC` | Jacksonville Air Route Traffic Control Center |
| `KANSAS CITY` | Kansas City Approach Control |
| `KANSAS CITY ARTCC` | Kansas City Air Route Traffic Control Center |
| `L.A. CENTER ARTCC` | Los Angeles Center Air Route Traffic Control Center |
| `MEMPHIS ARTCC` | Memphis Air Route Traffic Control Center |
| `MIAMI` | Miami Approach Control |
| `MIAMI ARTCC` | Miami Air Route Traffic Control Center |
| `MINNEAPOLIS ARTCC` | Minneapolis Air Route Traffic Control Center |
| `NEW YORK ARTCC` | New York Air Route Traffic Control Center |
| `OAKLAND ARTCC` | Oakland Air Route Traffic Control Center |
| `PHOENIX` | Phoenix Approach Control |
| `POTOMAC` | Potomac Approach Control |
| `SALT LAKE ARTCC` | Salt Lake City Air Route Traffic Control Center |
| `SEATTLE ARTCC` | Seattle Air Route Traffic Control Center |
| `SOCAL` | Southern California TRACON |
| `WASHINGTON ARTCC` | Washington Air Route Traffic Control Center |

### `apchSProvider` (`ApchSProvider`)

| Code | Description |
|---|---|
| `APCH/S CALL IS CHICAGO ARTCC` | Chicago ARTCC provides secondary approach control |
| `BGR` | Bangor TRACON |
| `CAE` | Columbia ATCT-TRACON |
| `CRW` | Charleston ATCT |
| `D21` | Detroit TRACON |
| `MCI` | Kansas City ATCT-TRACON |
| `MIA` | Miami ATCT-TRACON |
| `P50` | Phoenix TRACON |
| `PCT` | Potomac TRACON |
| `SCT` | Southern California TRACON |
| `ZAB` | Albuquerque ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZDC` | Washington ARTCC |
| `ZDV` | Denver ARTCC |
| `ZFW` | Fort Worth ARTCC |
| `ZHN` | Honolulu Control Facility |
| `ZHU` | Houston ARTCC |
| `ZID` | Indianapolis ARTCC |
| `ZJX` | Jacksonville ARTCC |
| `ZKC` | Kansas City ARTCC |
| `ZLA` | Los Angeles ARTCC |
| `ZLC` | Salt Lake City ARTCC |
| `ZMA` | Miami ARTCC |
| `ZME` | Memphis ARTCC |
| `ZMP` | Minneapolis ARTCC |
| `ZNY` | New York ARTCC |
| `ZOA` | Oakland ARTCC |
| `ZOB` | Cleveland ARTCC |
| `ZSE` | Seattle ARTCC |
| `ZTL` | Atlanta ARTCC |

### `secondaryDepRadioCall` (`SecondaryApchRadioCall`)

| Code | Description |
|---|---|
| `ALBUQUERQUE ARTCC` | Albuquerque Air Route Traffic Control Center |
| `ATLANTA ARTCC` | Atlanta Air Route Traffic Control Center |
| `BANGOR` | Bangor Approach Control |
| `BOSTON ARTCC` | Boston Air Route Traffic Control Center |
| `CHARLESTON` | Charleston Approach Control |
| `CHICAGO ARTCC` | Chicago Air Route Traffic Control Center |
| `CLEVELAND ARTCC` | Cleveland Air Route Traffic Control Center |
| `COLUMBIA` | Columbia Approach Control |
| `DENVER ARTCC` | Denver Air Route Traffic Control Center |
| `DETROIT` | Detroit Approach Control |
| `FORT WORTH ARTCC` | Fort Worth Air Route Traffic Control Center |
| `HCF CENTER` | Honolulu Control Facility Center |
| `HOUSTON ARTCC` | Houston Air Route Traffic Control Center |
| `INDIANAPOLIS ARTCC` | Indianapolis Air Route Traffic Control Center |
| `JACKSONVILLE ARTCC` | Jacksonville Air Route Traffic Control Center |
| `KANSAS CITY` | Kansas City Approach Control |
| `KANSAS CITY ARTCC` | Kansas City Air Route Traffic Control Center |
| `L.A. CENTER ARTCC` | Los Angeles Center Air Route Traffic Control Center |
| `MEMPHIS ARTCC` | Memphis Air Route Traffic Control Center |
| `MIAMI` | Miami Approach Control |
| `MIAMI ARTCC` | Miami Air Route Traffic Control Center |
| `MINNEAPOLIS ARTCC` | Minneapolis Air Route Traffic Control Center |
| `NEW YORK ARTCC` | New York Air Route Traffic Control Center |
| `OAKLAND ARTCC` | Oakland Air Route Traffic Control Center |
| `PHOENIX` | Phoenix Approach Control |
| `POTOMAC` | Potomac Approach Control |
| `SALT LAKE ARTCC` | Salt Lake City Air Route Traffic Control Center |
| `SEATTLE ARTCC` | Seattle Air Route Traffic Control Center |
| `SOCAL` | Southern California TRACON |
| `WASHINGTON ARTCC` | Washington Air Route Traffic Control Center |

### `depSProvider` (`DepSProvider`)

| Code | Description |
|---|---|
| `BGR` | Bangor TRACON |
| `CAE` | Columbia ATCT-TRACON |
| `CRW` | Charleston ATCT |
| `D21` | Detroit TRACON |
| `DEP/S CALL IS CHICAGO ARTCC` | Chicago ARTCC provides secondary departure control |
| `MCI` | Kansas City ATCT-TRACON |
| `MIA` | Miami ATCT-TRACON |
| `P50` | Phoenix TRACON |
| `PCT` | Potomac TRACON |
| `SCT` | Southern California TRACON |
| `ZAB` | Albuquerque ARTCC |
| `ZAU` | Chicago ARTCC |
| `ZBW` | Boston ARTCC |
| `ZDC` | Washington ARTCC |
| `ZDV` | Denver ARTCC |
| `ZFW` | Fort Worth ARTCC |
| `ZHN` | Honolulu Control Facility |
| `ZHU` | Houston ARTCC |
| `ZID` | Indianapolis ARTCC |
| `ZJX` | Jacksonville ARTCC |
| `ZKC` | Kansas City ARTCC |
| `ZLA` | Los Angeles ARTCC |
| `ZLC` | Salt Lake City ARTCC |
| `ZMA` | Miami ARTCC |
| `ZME` | Memphis ARTCC |
| `ZMP` | Minneapolis ARTCC |
| `ZNY` | New York ARTCC |
| `ZOA` | Oakland ARTCC |
| `ZOB` | Cleveland ARTCC |
| `ZSE` | Seattle ARTCC |
| `ZTL` | Atlanta ARTCC |

## Relationships

| Field | Returns | Joined on |
|---|---|---|
| `atcAtis` | [`[AtcAtis]`](./AtcAtis.md) | `FACILITY_ID` |
| `atcRmk` | [`[AtcRmk]`](./AtcRmk.md) | `FACILITY_ID` |
| `atcSvc` | [`[AtcSvc]`](./AtcSvc.md) | `FACILITY_ID` |

## Column provenance

Every field maps 1:1 to a column in the `ATC_BASE` 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` |
| `icaoId` | `ICAO_ID` |
| `facilityName` | `FACILITY_NAME` |
| `regionCode` | `REGION_CODE` |
| `twrOperatorCode` | `TWR_OPERATOR_CODE` |
| `twrCall` | `TWR_CALL` |
| `twrHrs` | `TWR_HRS` |
| `primaryApchRadioCall` | `PRIMARY_APCH_RADIO_CALL` |
| `apchPProvider` | `APCH_P_PROVIDER` |
| `apchPProvTypeCd` | `APCH_P_PROV_TYPE_CD` |
| `secondaryApchRadioCall` | `SECONDARY_APCH_RADIO_CALL` |
| `apchSProvider` | `APCH_S_PROVIDER` |
| `apchSProvTypeCd` | `APCH_S_PROV_TYPE_CD` |
| `primaryDepRadioCall` | `PRIMARY_DEP_RADIO_CALL` |
| `depPProvider` | `DEP_P_PROVIDER` |
| `depPProvTypeCd` | `DEP_P_PROV_TYPE_CD` |
| `secondaryDepRadioCall` | `SECONDARY_DEP_RADIO_CALL` |
| `depSProvider` | `DEP_S_PROVIDER` |
| `depSProvTypeCd` | `DEP_S_PROV_TYPE_CD` |
| `ctlFacApchDepCalls` | `CTL_FAC_APCH_DEP_CALLS` |
| `apchDepOperCode` | `APCH_DEP_OPER_CODE` |
| `ctlPrvdingHrs` | `CTL_PRVDING_HRS` |
| `secondaryCtlPrvdingHrs` | `SECONDARY_CTL_PRVDING_HRS` |