# IlsMkr

ILS Marker Beacon component data including inner, middle, and outer markers with location, frequency, and associated NAVAID information

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

> Ordered by SITE_NO, SITE_TYPE_CODE, RWY_END_ID, ILS_COMP_TYPE_CODE. This combination is also the unique record key.

## Example query

```graphql
# Introspect the IlsMkr 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. References SITE_NO in ILS_BASE. |  |  |
| `siteTypeCode` | `SiteTypeCode` | Landing Facility Type Code |  | `A`=AIRPORT; `B`=BALLOONPORT; `C`=SEAPLANE BASE; `G`=GLIDERPORT; `H`=HELIPORT; `U`=ULTRALIGHT |
| `stateCode` | `IlsMkrStateCode` | Associated State Post Office Code, standard two letter abbreviation for US States and Territories |  | `AK`, `AL`, `AR`, … (47 values) |
| `arptId` | `String` | Location Identifier. Unique 3-4 character alphanumeric identifier assigned to the Landing Facility |  |  |
| `city` | `String` | Associated City Name |  |  |
| `countryCode` | `String` | Country Post Office Code |  |  |
| `rwyEndId` | `String` | ILS Runway End Identifier |  |  |
| `ilsLocId` | `String` | ILS Identification code. References ILS_LOC_ID in ILS_BASE. |  |  |
| `systemTypeCode` | `SystemTypeCode` | ILS System Type code indicating the type of instrument landing system |  | `LS`, `SF`, `LC`, … (9 values) |
| `ilsCompTypeCode` | `IlsCompTypeCode` | Marker Beacon type indicating which marker this record represents |  | `IM`=Inner Marker; `MM`=Middle Marker; `OM`=Outer Marker |
| `componentStatus` | `ComponentStatus` | Operational Status of the Marker Beacon |  | `OPERATIONAL IFR`=Operational for IFR use; `OPERATIONAL RESTRICTED`=Operational with restrictions; `SHUTDOWN`=Shut down and not operational |
| `componentStatusDate` | `String` | Effective Date of Marker Beacon Operational Status |  |  |
| `latDeg` | `Int` | Marker Beacon Latitude Degrees | degrees |  |
| `latMin` | `Int` | Marker Beacon Latitude Minutes | minutes |  |
| `latSec` | `Float` | Marker Beacon Latitude Seconds | seconds |  |
| `latHemis` | `LatHemis` | Marker Beacon Latitude Hemisphere |  | `N`=North; `S`=South |
| `latDecimal` | `Float` | Marker Beacon Latitude in decimal format | degrees |  |
| `longDeg` | `Int` | Marker Beacon Longitude Degrees | degrees |  |
| `longMin` | `Int` | Marker Beacon Longitude Minutes | minutes |  |
| `longSec` | `Float` | Marker Beacon Longitude Seconds | seconds |  |
| `longHemis` | `LongHemis` | Marker Beacon Longitude Hemisphere |  | `E`=East; `W`=West |
| `longDecimal` | `Float` | Marker Beacon Longitude in decimal format | degrees |  |
| `latLongSourceCode` | `LatLongSourceCode` | Code indicating source of Latitude/Longitude information |  | `A`, `C`, `D`, … (16 values) |
| `siteElevation` | `Float` | Site Elevation of Marker Beacon in tenths of a foot MSL | tenths of feet MSL |  |
| `mkrFacTypeCode` | `MkrFacTypeCode` | Facility/Type of Marker/Locator code indicating what type of facility is at the marker location |  | `M`=MARKER - Marker Beacon Only; `MC`=MARKER/COMLO - Marker/Compass Locator; `MR`=MARKER/NDB - Marker/Nondirectional Radio Beacon; `C`=COMLO - Compass Locator; `R`=NDB - Nondirectional Radio Beacon |
| `markerIdBeacon` | `String` | Location Identifier of beacon at the marker |  |  |
| `compassLocatorName` | `String` | Name of the Marker Locator Beacon |  |  |
| `freq` | `Float` | NAVAID Frequency when marker is collocated, else Locator Frequency | kHz |  |
| `navId` | `String` | Location Identifier of Navigation Aid collocated with the marker. Blank indicates marker is not collocated with a NAVAID. |  |  |
| `navType` | `String` | Collocated NAVAID Type |  |  |
| `lowPoweredNdbStatus` | `String` | Low Powered NDB Status of Marker Beacon |  |  |

## Enum values

### `stateCode` (`IlsMkrStateCode`)

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

### `systemTypeCode` (`SystemTypeCode`)

| Code | Description |
|---|---|
| `LS` | ILS - Instrument Landing System |
| `SF` | SDF - Simplified Directional Facility |
| `LC` | LOC - Localizer |
| `LA` | LDA - Localizer-Type Directional Aid |
| `LD` | ILS/DME - Instrument Landing System/Distance Measuring Equipment |
| `SD` | SDF/DME - Simplified Directional Facility/Distance Measuring Equipment |
| `LE` | LOC/DME - Localizer/Distance Measuring Equipment |
| `LG` | LOC/GS - Localizer/Glide Slope |
| `DD` | LDA/DME - Localizer-Type Directional Aid/Distance Measuring Equipment |

### `latLongSourceCode` (`LatLongSourceCode`)

| Code | Description |
|---|---|
| `A` | Air Force |
| `C` | Coast Guard |
| `D` | Canadian AIRAC |
| `F` | FAA |
| `FS` | Tech Ops (AFS-530) |
| `G` | NOS (Historical) |
| `K` | NGS |
| `M` | DOD (NGA) |
| `N` | US Navy |
| `O` | Owner |
| `P` | NOS Photo Survey (Historical) |
| `Q` | Quad Plot (Historical) |
| `R` | Army |
| `S` | SIAP |
| `T` | 3rd Party Survey |
| `Z` | Surveyed |

## Column provenance

Every field maps 1:1 to a column in the `ILS_MKR` 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` |
| `rwyEndId` | `RWY_END_ID` |
| `ilsLocId` | `ILS_LOC_ID` |
| `systemTypeCode` | `SYSTEM_TYPE_CODE` |
| `ilsCompTypeCode` | `ILS_COMP_TYPE_CODE` |
| `componentStatus` | `COMPONENT_STATUS` |
| `componentStatusDate` | `COMPONENT_STATUS_DATE` |
| `latDeg` | `LAT_DEG` |
| `latMin` | `LAT_MIN` |
| `latSec` | `LAT_SEC` |
| `latHemis` | `LAT_HEMIS` |
| `latDecimal` | `LAT_DECIMAL` |
| `longDeg` | `LONG_DEG` |
| `longMin` | `LONG_MIN` |
| `longSec` | `LONG_SEC` |
| `longHemis` | `LONG_HEMIS` |
| `longDecimal` | `LONG_DECIMAL` |
| `latLongSourceCode` | `LAT_LONG_SOURCE_CODE` |
| `siteElevation` | `SITE_ELEVATION` |
| `mkrFacTypeCode` | `MKR_FAC_TYPE_CODE` |
| `markerIdBeacon` | `MARKER_ID_BEACON` |
| `compassLocatorName` | `COMPASS_LOCATOR_NAME` |
| `freq` | `FREQ` |
| `navId` | `NAV_ID` |
| `navType` | `NAV_TYPE` |
| `lowPoweredNdbStatus` | `LOW_POWERED_NDB_STATUS` |