SkyFollower

Appearance

Netherlands 🇳🇱 ILT Registry ​

Namenl-ilt-registry
CountryNetherlands
Registration prefixPH-
Data sourcehttps://www.ilent.nl/documenten/lijsten/luchtvaart/databestanden/luchtvaartregister-data
FormatODS spreadsheet (date-stamped filename, changes monthly, discovered via index page)
Run frequencyWeekly (Thursday, 05:10 UTC)
Depends on Mictronics for ICAO hexNo — the ILT register publishes the ICAO hex directly in its X-Ponder column, so records can be written to aircraft:registry:{icao_hex} without a RediSearch reverse lookup, and without mictronics having run first.

How it works ​

The ILT index page is scraped with a regex for a URL (absolute or relative) containing the known filename stem luchtvaartuigregister-ilt-datas2...*.ods; the file is downloaded to a temp path and parsed with odfpy. Row 0 holds annotated headers (bracket suffixes like [details=n][kolom=j] are stripped off), row 1 is an informational text row that is skipped, and row 2 onward is data. Cells that carry OpenDocument's numbercolumnsrepeated attribute are expanded so that merged/repeated blank cells don't shift later columns out of alignment (with a guard against implausibly large repeat counts on trailing empty cells, which are collapsed back to one). A row is only written if X-Ponder is a valid 6-hex ICAO code and Registration is non-empty. Every written record explicitly sets military: false — this register is exclusively civil, and the explicit value ensures a stale military: true flag (from Mictronics or a prior record on a reused hex) is corrected on re-registration.

Whenever a record has an aircraft.type_designator, aircraft:type:{type_designator} is looked up in Redis (populated by the mictronics runner) and, if found, its manufacturer_model and description_code (ICAO Doc 8643 description code, e.g. L2J) are set directly on this record — unconditionally, regardless of whether Mictronics also has values for the same hex. This runner's own type_designator is sourced directly from the ILT register and is authoritative; merge_aircraft.lua's "registry wins over mictronics" precedence rule guarantees these values take priority at read time either way. The lookup is not a hard dependency — a missing reference table entry, or the table not existing yet, leaves the record exactly as it would have been without this step.

Columns ​

Source columnImportedNotes
Flag❌Present in source; not read by this runner
Registration✅→ top-level registration
Registered❌Present in source; not read by this runner
LatestOwnerChange❌Present in source; not read by this runner
PrevCountry❌Present in source; not read by this runner
PrevMark❌Present in source; not read by this runner
Manufacturer✅→ aircraft.manufacturer
ManufacturedIn❌Present in source; not read by this runner
Model✅→ aircraft.model
Serial✅→ aircraft.serial_number
X-Ponder✅Validated as a 6-hex ICAO code; used directly as icao_hex (no Mictronics lookup needed)
Built✅→ aircraft.manufactured_date (YYYY-01-01T00:00:00Z), only if a 4-digit year
Group✅→ aircraft.type, mapped through a fixed table (e.g. Small aeroplane → Airplane, Rotorcraft → Helicopter); unmapped values pass through unchanged
Configuration❌Present in source; not read by this runner
MTOM❌Present in source; not read by this runner
MLM❌Present in source; not read by this runner
ICAO-code✅→ aircraft.type_designator; also used to look up aircraft:type:{type_designator} in Redis, setting aircraft.manufacturer_model and aircraft.description_code when found
AOC❌Present in source; not read by this runner
83Bis❌Present in source; not read by this runner
Representative❌Present in source; not read by this runner
Mortgage❌Present in source; not read by this runner
Volume❌Present in source; not read by this runner
LegalBase❌Present in source; not read by this runner
Engines✅→ aircraft.powerplant.count, only if numeric
EngKind✅→ aircraft.powerplant.type, mapped through a fixed table; "Engine - not defined" is dropped rather than stored
EngManufacturer✅→ aircraft.powerplant.manufacturer; the literal value "Unknown" is filtered out
EngModel✅→ aircraft.powerplant.model; values containing "not further defined" are filtered out
Props❌Present in source; not read by this runner
PropKind❌Present in source; not read by this runner
PropManufacturer❌Present in source; not read by this runner
PropModel❌Present in source; not read by this runner
NoiseRequirements❌Present in source; not read by this runner
NoiseCat❌Present in source; not read by this runner
NoiseRcrd❌Present in source; not read by this runner
LevelApp❌Present in source; not read by this runner
LevelFo❌Present in source; not read by this runner
LevelOf❌Present in source; not read by this runner
LevelSl❌Present in source; not read by this runner
LevelTo❌Present in source; not read by this runner
RegistrIssued❌Present in source; not read by this runner
RegistrExpiry❌Present in source; not read by this runner
CofA (Form24/25)_Iss.❌Present in source; not read by this runner
AirwIssued❌Present in source; not read by this runner
AirwExpiry❌Present in source; not read by this runner
AirwKind❌Present in source; not read by this runner
AirwVal❌Present in source; not read by this runner
NoiseIssued❌Present in source; not read by this runner
NoiseExpiry❌Present in source; not read by this runner
RegBlock❌Present in source; not read by this runner
Site2Title❌Present in source; not read by this runner
Site2Descr1❌Present in source; not read by this runner
Site2Descr2❌Present in source; not read by this runner
Site2Tech1❌Present in source; not read by this runner
Site2Tech2❌Present in source; not read by this runner
Site2Tech3❌Present in source; not read by this runner
Site2Tech4❌Present in source; not read by this runner
Site2Tech5❌Present in source; not read by this runner
Site2Noise1❌Present in source; not read by this runner
Site2Noise2❌Present in source; not read by this runner
Site2Doc1❌Present in source; not read by this runner
Site2Doc2❌Present in source; not read by this runner
Site2Doc3❌Present in source; not read by this runner

See specs/data-dictionary.yaml (nl-ilt-registry entry) for full column semantics and cross-source schema notes.

Example Output ​

Read back the merged record for a given ICAO hex (combines this runner's data with Mictronics and any other sources that have written to the same key):

bash
docker run --rm --network host redis:latest redis-cli EVAL "$(cat ./shared/lua/merge_aircraft.lua)" 0 484674 | python3 -m json.tool --sort-keys --no-ensure-ascii
json
{
    "aircraft": {
        "description_code": "L1P",
        "manufactured_date": "2007-01-01T00:00:00Z",
        "manufacturer": "Piper Aircraft, Inc.",
        "manufacturer_model": "PIPER PA-28-140/150/160/180",
        "model": "PA-28-181",
        "powerplant": {
            "count": 1,
            "manufacturer": "AVCO Corporation, Lycoming Division",
            "model": "O-360-A4M",
            "type": "Piston"
        },
        "serial_number": "2843664",
        "type": "Airplane",
        "type_designator": "P28A"
    },
    "data_sources": [
        "mictronics",
        "nl-ilt-registry"
    ],
    "icao_hex": "484674",
    "military": false,
    "registration": "PH-WKB"
}
bash
docker run --rm --network host redis:latest redis-cli EVAL "$(cat ./shared/lua/merge_aircraft.lua)" 0 484F73 | python3 -m json.tool --sort-keys --no-ensure-ascii
json
{
    "aircraft": {
        "description_code": "L2J",
        "manufactured_date": "2012-01-01T00:00:00Z",
        "manufacturer": "Airbus S.A.S. (Société par Actions Simplifiée)",
        "manufacturer_model": "AIRBUS A-330-300",
        "model": "A330-303",
        "powerplant": {
            "count": 2,
            "manufacturer": "General Electric Company, Aircraft Engine Group",
            "model": "CF6-80E1A3",
            "type": "Turbo-fan"
        },
        "serial_number": "1300",
        "type": "Airplane",
        "type_designator": "A333"
    },
    "data_sources": [
        "mictronics",
        "nl-ilt-registry"
    ],
    "icao_hex": "484F73",
    "military": false,
    "registration": "PH-AKD"
}

Configuration ​

See Data Runners for the full list of environment variables every runner reads. This runner writes aircraft:registry:{icao_hex} with a fixed 14-day TTL (ENRICHMENT_TTL_SECONDS in shared/timing.py).

MQTT ​

Published once, at the end of a run, to SkyFollower/runner/nl-ilt-registry/statistic/{name} (all retained):

Topic suffixValueFormat
records_importede.g. 271Integer as string
last_run_ate.g. 2026-07-07T14:32:01.123456+00:00ISO 8601 UTC
last_run_statusSuccess or FailureString

Home Assistant autodiscovery configs are also published (retained) to homeassistant/sensor/SkyFollower_runner_nl_ilt_registry_{name}/config for each of the three stats above.