# FixChrt

Chart depiction table identifying which aeronautical charts each fix is depicted on

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

> Ordered by FIX_ID, ICAO_REGION_CODE, CHARTING_TYPE_DESC. This ordering also serves as the unique record key. Replaces legacy FIX.txt Subscriber File.

## Example query

```graphql
# Introspect the FixChrt type in GraphiQL at https://api.nav.sortie.co/graphql
# Example shape (pair with a compatible root query field):
{
  # ...rootQuery... {
    effDate
    fixId
    icaoRegionCode
    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 |  |  |
| `fixId` | `String` | Fixed Geographical Position Identifier. References FIX_ID in FIX_BASE. |  |  |
| `icaoRegionCode` | `CifpEnrouteWaypointIcaoCode2` | International Civil Aviation Organization (ICAO) Code. In general, the first letter refers to the country, the second letter discerns the region within the country. References ICAO_REGION_CODE in FIX_BASE. |  | `CY`, `K`, `K1`, … (22 values) |
| `stateCode` | `FixBaseStateCode` | Associated State Post Office Code - standard two letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (61 values) |
| `countryCode` | `FixBaseCountryCode` | Country Post Office Code identifying the country associated with the fix |  | `AS`, `BS`, `CA`, … (13 values) |
| `chartingTypeDesc` | `ChartingTypeDesc` | Description of the chart type on which the fix is to be depicted |  | `AREA`, `CONTROLLER`, `CONTROLLER HIGH`, … (25 values) |

## Enum values

### `icaoRegionCode` (`CifpEnrouteWaypointIcaoCode2`)

| Code | Description |
|---|---|
| `CY` | Canada |
| `K` | Contiguous United States |
| `K1` | Contiguous United States Region 1 |
| `K2` | Contiguous United States Region 2 |
| `K3` | Contiguous United States Region 3 |
| `K4` | Contiguous United States Region 4 |
| `K5` | Contiguous United States Region 5 |
| `K6` | Contiguous United States Region 6 |
| `K7` | Contiguous United States Region 7 |
| `MD` | Maryland/Mid-Atlantic |
| `MM` | Mexico |
| `MY` | Bahamas |
| `NZ` | New Zealand |
| `P` | North Pacific |
| `PA` | Alaska |
| `PG` | Guam/Mariana Islands |
| `PH` | Hawaii |
| `TI` | US Virgin Islands |
| `TJ` | Puerto Rico |
| `TN` | Caribbean |
| `UH` | Russia Far East |
| `UL` | Russia |

### `stateCode` (`FixBaseStateCode`)

| 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 |
| `OA` | Pacific Ocean Area |
| `OG` | Gulf of Mexico Area |
| `OH` | Ohio |
| `OK` | Oklahoma |
| `OP` | Pacific Ocean |
| `OR` | Oregon |
| `PA` | Pennsylvania |
| `PR` | Puerto Rico |
| `QM` | Atlantic Ocean Area |
| `QW` | Atlantic Ocean |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `SD` | South Dakota |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | US Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |
| `WY` | Wyoming |

### `countryCode` (`FixBaseCountryCode`)

| Code | Description |
|---|---|
| `AS` | American Samoa |
| `BS` | Bahamas |
| `CA` | Canada |
| `DO` | Dominican Republic |
| `FM` | Federated States of Micronesia |
| `IB` | International/High Seas |
| `MH` | Marshall Islands |
| `MP` | Northern Mariana Islands |
| `MX` | Mexico |
| `PW` | Palau |
| `RU` | Russia |
| `TC` | Turks and Caicos Islands |
| `US` | United States |

### `chartingTypeDesc` (`ChartingTypeDesc`)

| Code | Description |
|---|---|
| `AREA` | Area chart |
| `CONTROLLER` | Controller chart |
| `CONTROLLER HIGH` | Controller high altitude chart |
| `CONTROLLER LOW` | Controller low altitude chart |
| `ENROUTE HIGH` | Enroute high altitude chart |
| `ENROUTE LOW` | Enroute low altitude chart |
| `GULF COAST VFR CHART` | Gulf Coast VFR chart |
| `HELICOPTER ROUTE` | Helicopter route chart |
| `IAP` | Instrument Approach Procedure chart |
| `IFR GOA VERTICAL FLT` | IFR Gulf of Alaska vertical flight chart |
| `MILITARY IAP` | Military Instrument Approach Procedure chart |
| `MILITARY SID` | Military Standard Instrument Departure chart |
| `MILITARY STAR` | Military Standard Terminal Arrival Route chart |
| `NORTH ATLANTIC ROUTE` | North Atlantic route chart |
| `NORTH PACIFIC ROUTE` | North Pacific route chart |
| `NOT REQUIRED` | Not required for charting |
| `PRIVATE IAP` | Private Instrument Approach Procedure chart |
| `SECTIONAL` | Sectional aeronautical chart |
| `SID` | Standard Instrument Departure chart |
| `SPECIAL DP` | Special Departure Procedure chart |
| `SPECIAL IAP` | Special Instrument Approach Procedure chart |
| `STAR` | Standard Terminal Arrival Route chart |
| `VFR FLYWAY PLANNING` | VFR Flyway Planning chart |
| `VFR TERMINAL AREA` | VFR Terminal Area chart |
| `WESTERN ATLANTIC ROUTE` | Western Atlantic route chart |

## Column provenance

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

| GraphQL field | SQLite column |
|---|---|
| `effDate` | `EFF_DATE` |
| `fixId` | `FIX_ID` |
| `icaoRegionCode` | `ICAO_REGION_CODE` |
| `stateCode` | `STATE_CODE` |
| `countryCode` | `COUNTRY_CODE` |
| `chartingTypeDesc` | `CHARTING_TYPE_DESC` |