NOTAM AIXM Mapping

Required roles: AIS PIB API Data via Cloud — Roles
Base endpoint: none
Reference documents: AIXM 5.1 schema set (aixm.aero) · AIXM 5.1 Event extension (aixm.aero) · FAA NOTAM Management System API (NMS-API), Version 1.0.17 (24/10/25)
Attribution: none
Data sources: none
Last updated: 18 OCT 2026

About the reference documents: Related Documents and Resources

The columns of the notams table of the NOTAM Data database and where their values come from.

The source sends each NOTAM as an AIXM 5.1 message (AIXMBasicMessage): the NOTAM itself is described with the AIXM 5.1 Event extension (namespace http://www.aixm.aero/schema/5.1/event), and the FAA adds its own data in the FNSE extension (http://www.aixm.aero/schema/5.1/extensions/FAA/FNSE). The column names follow the AIXM 5.1 element names. The prefix of a column shows its origin:

Prefix Origin
aixm_ Element of event:NOTAM (AIXM 5.1 Event extension)
fns_ Element of fnse:EventExtension (FAA FNSE extension)
ibo_ Field added by ibonav.aero: derived values, geometry, status

All aixm_ and fns_ columns are stored as text; times are ISO 8601 in UTC (YYYY-MM-DDTHH:MM:SSZ).

AIXM 5.1 Event: NOTAM

Column Element of event:NOTAM NOTAM item Notes
id gml:id of the message (NMS_ID_…) — Record ID of the source, without the prefix
aixm_series series Series
aixm_number number Number Stored as the full display number (e.g. A1234/25), taken from the ICAO text; rebuilt from series, number and year when the text has none
aixm_year year Year
aixm_type type NOTAMN / NOTAMR / NOTAMC N, R or C
aixm_issued issued — Issue time
aixm_affected_fir affectedFIR Q) FIR Filled from the Q line when the element is empty
aixm_selection_code selectionCode Q) NOTAM code e.g. QMRLC; filled from the Q line when empty
aixm_traffic traffic Q) Traffic Filled from the Q line when empty
aixm_purpose purpose Q) Purpose Filled from the Q line when empty
aixm_scope scope Q) Scope Filled from the Q line when empty
aixm_min_fl minimumFL Q) Lower limit Filled from the Q line when empty; 000 when none is given
aixm_max_fl maximumFL Q) Upper limit Filled from the Q line when empty; 999 when none is given
aixm_coordinates coordinates Q) Coordinates Filled from the Q line when empty
aixm_radius radius Q) Radius Filled from the Q line when empty
aixm_location location A)
aixm_effective_start gml:TimePeriod/beginPosition, else effectiveStart B)
aixm_effective_end gml:TimePeriod/endPosition, else effectiveEnd C) Empty for a permanent NOTAM (ibo_permanent = 1)
aixm_estimated endPosition with indeterminatePosition="approximate", or estimated C) EST true / false
aixm_schedule schedule D)
aixm_text text E)
aixm_lower_limit lowerLimit F)
aixm_upper_limit upperLimit G)
aixm_cancelation_date — — For NOTAMC: the start of validity of the cancelling NOTAM
aixm_icao_text NOTAMTranslation/formattedText (type ICAO) — Full NOTAM in ICAO format
aixm_local_text NOTAMTranslation/simpleText (type LOCAL) — Domestic format of the NOTAM

FAA FNSE extension

Column Element of fnse:EventExtension Notes
fns_classification classification NOTAM classification of the source: INTL, MIL, DOM, FDC
fns_account_id accountId Issuing account
fns_xover_account_id xoveraccountID
fns_xover_notam_id xovernotamID
fns_airport_name airportname
fns_qline qline The Q line as text
fns_origin_id originID
fns_last_updated lastUpdated Last update at the source
fns_icao_location icaoLocation

Additional fields

Column Type Content
ibo_message_type text NOTAM, SNOWTAM, ASHTAM or Other, from the message text
ibo_q_23 text 2nd–3rd letters of the NOTAM code (subject)
ibo_q_45 text 4th–5th letters of the NOTAM code (condition)
ibo_topic text Subject group of the 2nd–3rd letters (NOTAM Code, PANS-ABC)
ibo_geometry text Geometry as GeoJSON
ibo_geom_source text Where the geometry comes from: aixm (AIXM surface), text (coordinate list in Item E)), ashtam, qline (Q line circle), qline_center, aixm_point, none
ibo_min_lon, ibo_min_lat, ibo_max_lon, ibo_max_lat real Bounding box of the geometry
ibo_map_preferred integer 1 when the geometry is reliable enough to show on a map
ibo_active integer 1 while the NOTAM is in force, 0 when it is expired or no longer in the source
ibo_permanent integer 1 for a permanent NOTAM (C) PERM)
ibo_raw_aixm text The AIXM message as received
ibo_fetched_at text Time the record was stored
ibo_updated_at text Last update (fns_last_updated, else the storing time)