# Registered aircraft: AD 2018-04-01 A list on [AD 2018-04-01](https://openairdocs.org/ad/2018-04-01.md). Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability. Page 1 of 3 · 135 aircraft - [N202HA](https://openairdocs.org/aircraft/N202HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2017 · S/N 7917 - [N204HA](https://openairdocs.org/aircraft/N204HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2017 · S/N 7959 - [N205HA](https://openairdocs.org/aircraft/N205HA.md): Alaska Airlines Inc · Seatac, WA · Built 2018 · S/N 8092 - [N208HA](https://openairdocs.org/aircraft/N208HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2018 · S/N 8123 - [N209HA](https://openairdocs.org/aircraft/N209HA.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2018 · S/N 8186 - [N212HA](https://openairdocs.org/aircraft/N212HA.md): Alaska Airlines Inc · Seatac, WA · Built 2018 · S/N 8129 - [N213HA](https://openairdocs.org/aircraft/N213HA.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2018 · S/N 8237 - [N214HA](https://openairdocs.org/aircraft/N214HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2018 · S/N 8157 - [N215HA](https://openairdocs.org/aircraft/N215HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2018 · S/N 8266 - [N216HA](https://openairdocs.org/aircraft/N216HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2018 · S/N 8471 - [N217HA](https://openairdocs.org/aircraft/N217HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2018 · S/N 8578 - [N218HA](https://openairdocs.org/aircraft/N218HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2019 · S/N 8764 - [N220HA](https://openairdocs.org/aircraft/N220HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2019 · S/N 8872 - [N223HA](https://openairdocs.org/aircraft/N223HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2019 · S/N 9060 - [N226HA](https://openairdocs.org/aircraft/N226HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2019 · S/N 9127 - [N227HA](https://openairdocs.org/aircraft/N227HA.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2019 · S/N 9223 - [N228HA](https://openairdocs.org/aircraft/N228HA.md): Hawaiian Airlines Inc · Honolulu, HI · Built 2019 · S/N 9274 - [N230HA](https://openairdocs.org/aircraft/N230HA.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2020 · S/N 9547 - [N402FR](https://openairdocs.org/aircraft/N402FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2025 · S/N 12857 - [N405FR](https://openairdocs.org/aircraft/N405FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2025 · S/N 12896 - [N409FR](https://openairdocs.org/aircraft/N409FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2025 · S/N 12900 - [N413FR](https://openairdocs.org/aircraft/N413FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2025 · S/N 12982 - [N414FR](https://openairdocs.org/aircraft/N414FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2025 · S/N 12936 - [N430FR](https://openairdocs.org/aircraft/N430FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2025 · S/N 12991 - [N432FR](https://openairdocs.org/aircraft/N432FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2025 · S/N 12920 - [N434FR](https://openairdocs.org/aircraft/N434FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2026 · S/N 13015 - [N435FR](https://openairdocs.org/aircraft/N435FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2026 · S/N 13042 - [N436FR](https://openairdocs.org/aircraft/N436FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2026 · S/N 13045 - [N437FR](https://openairdocs.org/aircraft/N437FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2026 · S/N 13075 - [N438FR](https://openairdocs.org/aircraft/N438FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2026 · S/N 13118 - [N439FR](https://openairdocs.org/aircraft/N439FR.md): Umb Bank Na Trustee · Salt Lake City, UT · Built 2026 · S/N 13133 - [N440FR](https://openairdocs.org/aircraft/N440FR.md): Umb Bank N A Trustee · Salt Lake City, UT · Built 2026 · S/N 13176 - [N441FR](https://openairdocs.org/aircraft/N441FR.md): Umb Bank N A Trustee · Salt Lake City, UT · Built 2026 · S/N 13355 - [N528VL](https://openairdocs.org/aircraft/N528VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2016 · S/N 7051 - [N529VL](https://openairdocs.org/aircraft/N529VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2017 · S/N 7102 - [N530VL](https://openairdocs.org/aircraft/N530VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2017 · S/N 7553 - [N531VL](https://openairdocs.org/aircraft/N531VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2017 · S/N 7626 - [N532VL](https://openairdocs.org/aircraft/N532VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2017 · S/N 7804 - [N533VL](https://openairdocs.org/aircraft/N533VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2018 · S/N 7862 - [N534VL](https://openairdocs.org/aircraft/N534VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2018 · S/N 7941 - [N535VL](https://openairdocs.org/aircraft/N535VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2018 · S/N 8087 - [N536VL](https://openairdocs.org/aircraft/N536VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2018 · S/N 8264 - [N537VL](https://openairdocs.org/aircraft/N537VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2018 · S/N 8144 - [N538VL](https://openairdocs.org/aircraft/N538VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2018 · S/N 8366 - [N539VL](https://openairdocs.org/aircraft/N539VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2018 · S/N 8490 - [N541VL](https://openairdocs.org/aircraft/N541VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2019 · S/N 8844 - [N542VL](https://openairdocs.org/aircraft/N542VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2019 · S/N 8603 - [N543VL](https://openairdocs.org/aircraft/N543VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2019 · S/N 9070 - [N544VL](https://openairdocs.org/aircraft/N544VL.md): Wilmington Trust Co Trustee · Wilmington, DE · Built 2019 · S/N 9343 - [N545VL](https://openairdocs.org/aircraft/N545VL.md): Umb Bank Na Trustee · Salt Lake City, UT · S/N 10495 Next page: https://openairdocs.org/ad/2018-04-01/aircraft.md?page=2 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2018-04-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2018-04-01') ORDER BY n_number ``` This list as a web page: https://openairdocs.org/ad/2018-04-01/aircraft --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.