# ClsArsp

Class B/C/D/E airspace and airspace hours data for terminal communication facilities, derived from the legacy TWR8 record in TWR.txt

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

> Unique record key is SITE_NO + SITE_TYPE_CODE. Ordered by SITE_NO, SITE_TYPE_CODE. Data is comparable to legacy TWR8 record but may be organized differently.

## Example query

```graphql
# Introspect the ClsArsp 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. Also serves as part of the composite unique record key along with SITE_TYPE_CODE |  |  |
| `siteTypeCode` | `SiteTypeCode` | Facility type code indicating the type of landing facility |  | `A`=Airport; `H`=Heliport; `B`=Balloonport; `C`=Seaplane Base; `G`=Gliderport; `U`=Ultralight |
| `stateCode` | `ClsArspStateCode` | Associated state post office code; standard two-letter abbreviation for US states and territories |  | `AK`, `AL`, `AR`, … (56 values) |
| `arptId` | `String` | Location identifier; unique 3-4 character alphanumeric identifier assigned to the landing facility |  |  |
| `city` | `String` | Airport associated city name |  |  |
| `countryCode` | `ClsArspCountryCode` | Country post office code for the country in which the airport is located |  | `AI`, `AN`, `BM`, … (7 values) |
| `classBAirspace` | `TurnDirectionValid` | Indicates the terminal communication facility contains Class B airspace; designated with Y, else null |  | `Y`=Facility contains Class B Airspace |
| `classCAirspace` | `TurnDirectionValid` | Indicates the terminal communication facility contains Class C airspace; designated with Y, else null |  | `Y`=Facility contains Class C Airspace |
| `classDAirspace` | `TurnDirectionValid` | Indicates the terminal communication facility contains Class D airspace; designated with Y, else null |  | `Y`=Facility contains Class D Airspace |
| `classEAirspace` | `TurnDirectionValid` | Indicates the terminal communication facility contains Class E airspace; designated with Y, else null |  | `Y`=Facility contains Class E Airspace |
| `airspaceHrs` | `String` | Hours of operation for the airspace of the terminal communication facility |  |  |
| `remark` | `Remark` | Remark associated with the class airspace record, referencing the field to which the remark applies in parentheses |  | `(AIRSPACE_HRS) CLASS E AIRSPACE OTR HR.`=Remark on airspace hours: Class E airspace other hours; `(CLASS_B_AIRSPACE) EXPECT TO LEAVE AND RE-ENTER CLASS B ASP DURG MOD TO HVY ARR PDS.`=Abbreviated remark: Expect to leave and re-enter Class B airspace during moderate to heavy arrival periods; `(CLASS_B_AIRSPACE) EXPECT TO LEAVE AND RE-ENTER THE CLASS B AIRSPACE DURING MODERATE TO HEAVY ARRIVAL PERIODS.`=Full remark: Expect to leave and re-enter the Class B airspace during moderate to heavy arrival periods |

## Enum values

### `stateCode` (`ClsArspStateCode`)

| 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 |
| `QM` | Marshall Islands (or other Pacific territories) |
| `RI` | Rhode Island |
| `SC` | South Carolina |
| `SD` | South Dakota |
| `TN` | Tennessee |
| `TX` | Texas |
| `UT` | Utah |
| `VA` | Virginia |
| `VI` | U.S. Virgin Islands |
| `VT` | Vermont |
| `WA` | Washington |
| `WI` | Wisconsin |
| `WV` | West Virginia |
| `WY` | Wyoming |

### `countryCode` (`ClsArspCountryCode`)

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

## Column provenance

Every field maps 1:1 to a column in the `CLS_ARSP` 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` |
| `classBAirspace` | `CLASS_B_AIRSPACE` |
| `classCAirspace` | `CLASS_C_AIRSPACE` |
| `classDAirspace` | `CLASS_D_AIRSPACE` |
| `classEAirspace` | `CLASS_E_AIRSPACE` |
| `airspaceHrs` | `AIRSPACE_HRS` |
| `remark` | `REMARK` |