# IlsBase

Base ILS localizer data including system type, ownership, location, frequency, and operational status

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

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

## Example query

```graphql
# Introspect the IlsBase 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 the landing facility. |  |  |
| `siteTypeCode` | `SiteTypeCode` | Landing Facility Type Code |  | `A`=AIRPORT; `B`=BALLOONPORT; `C`=SEAPLANE BASE; `G`=GLIDERPORT; `H`=HELIPORT; `U`=ULTRALIGHT |
| `stateCode` | `IlsBaseStateCode` | 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` | Associated City Name |  |  |
| `countryCode` | `String` | Country Post Office Code |  |  |
| `rwyEndId` | `String` | ILS Runway End Identifier |  |  |
| `ilsLocId` | `String` | ILS Identification code |  |  |
| `systemTypeCode` | `SystemTypeCode` | ILS System Type code indicating the type of instrument landing system |  | `LS`, `SF`, `LC`, … (9 values) |
| `stateName` | `IlsBaseStateName` | Associated State Name |  | `ALABAMA`, `ALASKA`, `AMERICAN SAMOA`, … (56 values) |
| `regionCode` | `RegionCode` | FAA Region responsible for the NAVAID |  | `AAL`, `ACE`, `AEA`, … (9 values) |
| `rwyLen` | `Int` | ILS Runway Length in whole feet | feet |  |
| `rwyWidth` | `Int` | ILS Runway Width in whole feet | feet |  |
| `category` | `Category` | Category of the ILS system |  | `I`=Category I; `II`=Category II; `III`=Category III; `IIIB`=Category IIIB |
| `owner` | `String` | Concatenation of the ILS Owner Code and ILS Owner Name (e.g. F-FEDERAL AVIATION ADMINISTRATION). Prefix letter indicates ownership type: A=Air Force, C=Coast Guard, F=Federal/FAA, N=Navy, O=Other public, P=Private, R=Army |  |  |
| `operator` | `String` | Concatenation of the ILS Operator Code and ILS Operator Name (e.g. F-FEDERAL AVIATION ADMINISTRATION). Prefix letter indicates operator type: A=Air Force, C=Coast Guard, F=Federal/FAA, N=Navy, O=Other public, P=Private, R=Army |  |  |
| `apchBear` | `Float` | ILS Approach Bearing in degrees magnetic | degrees magnetic |  |
| `magVar` | `Int` | Magnetic Variation in degrees | degrees |  |
| `magVarHemis` | `LongHemis` | Magnetic Variation Direction hemisphere indicator |  | `E`=East; `W`=West |
| `componentStatus` | `ComponentStatus` | Operational Status of the Localizer |  | `OPERATIONAL IFR`=Operational for IFR use; `OPERATIONAL RESTRICTED`=Operational with restrictions; `SHUTDOWN`=Shut down and not operational |
| `componentStatusDate` | `String` | Effective Date of Localizer Operational Status |  |  |
| `latDeg` | `Int` | Localizer Antenna Latitude Degrees | degrees |  |
| `latMin` | `Int` | Localizer Antenna Latitude Minutes | minutes |  |
| `latSec` | `Float` | Localizer Antenna Latitude Seconds | seconds |  |
| `latHemis` | `LatHemis` | Localizer Antenna Latitude Hemisphere |  | `N`=North; `S`=South |
| `latDecimal` | `Float` | Localizer Antenna Latitude in decimal format | degrees |  |
| `longDeg` | `Int` | Localizer Antenna Longitude Degrees | degrees |  |
| `longMin` | `Int` | Localizer Antenna Longitude Minutes | minutes |  |
| `longSec` | `Float` | Localizer Antenna Longitude Seconds | seconds |  |
| `longHemis` | `LongHemis` | Localizer Antenna Longitude Hemisphere |  | `E`=East; `W`=West |
| `longDecimal` | `Float` | Localizer Antenna Longitude in decimal format | degrees |  |
| `latLongSourceCode` | `LatLongSourceCode` | Code indicating source of Latitude/Longitude information |  | `A`, `C`, `D`, … (16 values) |
| `siteElevation` | `Float` | Site Elevation of Localizer Antenna in tenths of a foot MSL | tenths of feet MSL |  |
| `locFreq` | `Float` | Localizer Frequency | MHz |  |
| `bkCourseStatusCode` | `BkCourseStatusCode` | Localizer Back Course Status code |  | `N`=No Restrictions; `R`=Restricted; `U`=Unusable; `Y`=Usable |

## Enum values

### `stateCode` (`IlsBaseStateCode`)

| 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 |
| `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 |

### `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 |

### `stateName` (`IlsBaseStateName`)

| Code | Description |
|---|---|
| `ALABAMA` | Alabama |
| `ALASKA` | Alaska |
| `AMERICAN SAMOA` | American Samoa |
| `ARIZONA` | Arizona |
| `ARKANSAS` | Arkansas |
| `CALIFORNIA` | California |
| `COLORADO` | Colorado |
| `CONNECTICUT` | Connecticut |
| `DELAWARE` | Delaware |
| `DIST. OF COLUMBIA` | District of Columbia |
| `FLORIDA` | Florida |
| `GEORGIA` | Georgia |
| `GUAM` | Guam |
| `HAWAII` | Hawaii |
| `IDAHO` | Idaho |
| `ILLINOIS` | Illinois |
| `INDIANA` | Indiana |
| `IOWA` | Iowa |
| `KANSAS` | Kansas |
| `KENTUCKY` | Kentucky |
| `LOUISIANA` | Louisiana |
| `MAINE` | Maine |
| `MARYLAND` | Maryland |
| `MASSACHUSETTS` | Massachusetts |
| `MICHIGAN` | Michigan |
| `MINNESOTA` | Minnesota |
| `MISSISSIPPI` | Mississippi |
| `MISSOURI` | Missouri |
| `MONTANA` | Montana |
| `N MARIANA ISLANDS` | Northern Mariana Islands |
| `NEBRASKA` | Nebraska |
| `NEVADA` | Nevada |
| `NEW HAMPSHIRE` | New Hampshire |
| `NEW JERSEY` | New Jersey |
| `NEW MEXICO` | New Mexico |
| `NEW YORK` | New York |
| `NORTH CAROLINA` | North Carolina |
| `NORTH DAKOTA` | North Dakota |
| `OHIO` | Ohio |
| `OKLAHOMA` | Oklahoma |
| `OREGON` | Oregon |
| `PENNSYLVANIA` | Pennsylvania |
| `PUERTO RICO` | Puerto Rico |
| `RHODE ISLAND` | Rhode Island |
| `SOUTH CAROLINA` | South Carolina |
| `SOUTH DAKOTA` | South Dakota |
| `TENNESSEE` | Tennessee |
| `TEXAS` | Texas |
| `UTAH` | Utah |
| `VERMONT` | Vermont |
| `VIRGIN ISLANDS` | Virgin Islands |
| `VIRGINIA` | Virginia |
| `WASHINGTON` | Washington |
| `WEST VIRGINIA` | West Virginia |
| `WISCONSIN` | Wisconsin |
| `WYOMING` | Wyoming |

### `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 |

### `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 |

## Relationships

| Field | Returns | Joined on |
|---|---|---|
| `ilsGs` | [`[IlsGs]`](./IlsGs.md) | `SITE_NO, RWY_END_ID` |
| `ilsDme` | [`[IlsDme]`](./IlsDme.md) | `SITE_NO, RWY_END_ID` |
| `ilsMkr` | [`[IlsMkr]`](./IlsMkr.md) | `SITE_NO, RWY_END_ID` |
| `ilsRmk` | [`[IlsRmk]`](./IlsRmk.md) | `SITE_NO, RWY_END_ID` |

## Column provenance

Every field maps 1:1 to a column in the `ILS_BASE` 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` |
| `stateName` | `STATE_NAME` |
| `regionCode` | `REGION_CODE` |
| `rwyLen` | `RWY_LEN` |
| `rwyWidth` | `RWY_WIDTH` |
| `category` | `CATEGORY` |
| `owner` | `OWNER` |
| `operator` | `OPERATOR` |
| `apchBear` | `APCH_BEAR` |
| `magVar` | `MAG_VAR` |
| `magVarHemis` | `MAG_VAR_HEMIS` |
| `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` |
| `locFreq` | `LOC_FREQ` |
| `bkCourseStatusCode` | `BK_COURSE_STATUS_CODE` |