# Airworthiness directives that may apply: N786AV

A list on [N786AV](https://openairdocs.org/aircraft/N786AV.md).

Matched by this aircraft’s airframe and engine models. Each AD’s applicability may narrow it by serial number, part number or equipment.

- [AD 2026-20-16](https://openairdocs.org/ad/2026-20-16.md): Powerplant · Effective Nov 23, 2026
- [AD 2026-20-10](https://openairdocs.org/ad/2026-20-10.md): Flight Controls · Effective Nov 12, 2026 · Supersedes AD 2019-20-07
- [AD 2026-20-01](https://openairdocs.org/ad/2026-20-01.md): Fuselage · Effective Nov 2, 2026
- [AD 2026-20-02](https://openairdocs.org/ad/2026-20-02.md): Air · Effective Oct 14, 2026
- [AD 2026-17-02](https://openairdocs.org/ad/2026-17-02.md): Wings · Effective Oct 1, 2026
- [AD 2026-13-07](https://openairdocs.org/ad/2026-13-07.md): Equipment/furnishings · Effective Aug 6, 2026
- [AD 2026-12-07](https://openairdocs.org/ad/2026-12-07.md): Auto flight · Effective Jul 20, 2026
- [AD 2026-13-11](https://openairdocs.org/ad/2026-13-11.md): Navigation · Effective Jul 1, 2026
- [AD 2026-13-02](https://openairdocs.org/ad/2026-13-02.md): Navigation · Effective Jul 1, 2026
- [AD 2026-09-01](https://openairdocs.org/ad/2026-09-01.md): Water/waste · Effective Jun 3, 2026 · Supersedes AD 2023-08-04
- [AD 2026-05-01](https://openairdocs.org/ad/2026-05-01.md): Navigation · Effective Apr 16, 2026
- [AD 2026-02-10](https://openairdocs.org/ad/2026-02-10.md): Water/waste · Effective Mar 9, 2026 · Supersedes AD 2024-01-01
- [AD 2025-23-05](https://openairdocs.org/ad/2025-23-05.md): Fuselage · Effective Jan 13, 2026
- [AD 2025-20-03](https://openairdocs.org/ad/2025-20-03.md): Equipment/furnishings · Effective Nov 6, 2025
- [AD 2025-18-02](https://openairdocs.org/ad/2025-18-02.md): Oxygen · Effective Oct 22, 2025
- [AD 2025-11-05](https://openairdocs.org/ad/2025-11-05.md): Fuselage · Effective Jul 8, 2025
- [AD 2025-09-12](https://openairdocs.org/ad/2025-09-12.md): Fuselage · Effective Jun 18, 2025
- [AD 2025-06-10](https://openairdocs.org/ad/2025-06-10.md): Stabilizers · Effective May 2, 2025
- [AD 2025-01-09](https://openairdocs.org/ad/2025-01-09.md): Windows · Effective Mar 11, 2025
- [AD 2024-22-05](https://openairdocs.org/ad/2024-22-05.md): Landing gear · Effective Dec 31, 2024
- [AD 2024-18-02](https://openairdocs.org/ad/2024-18-02.md): Equipment/furnishings · Effective Nov 12, 2024
- [AD 2024-16-07](https://openairdocs.org/ad/2024-16-07.md): Navigation · Effective Oct 23, 2024
- [AD 2024-13-05](https://openairdocs.org/ad/2024-13-05.md): Nacelles/pylons · Effective Sep 24, 2024
- [AD 2024-16-14](https://openairdocs.org/ad/2024-16-14.md): Equipment/furnishings · Effective Aug 21, 2024
- [AD 2024-01-04](https://openairdocs.org/ad/2024-01-04.md): Turbine/turboprop engine · Effective Mar 7, 2024 · Supersedes AD 2020-26-08
- [AD 2023-25-10](https://openairdocs.org/ad/2023-25-10.md): Equipment/furnishings · Effective Feb 7, 2024
- [AD 2023-19-09](https://openairdocs.org/ad/2023-19-09.md): Auto flight · Effective Nov 6, 2023 · Supersedes AD 2020-24-04
- [AD 2023-10-09](https://openairdocs.org/ad/2023-10-09.md): Fire Protection · Effective Jun 26, 2023
- [AD 2023-12-10](https://openairdocs.org/ad/2023-12-10.md): Navigation · Effective Jun 21, 2023 · Supersedes AD 2022-02-16
- [AD 2023-08-02](https://openairdocs.org/ad/2023-08-02.md): Cargo and accessory compartments · Effective Jun 20, 2023 · Supersedes AD 2018-05-06, AD 2021-08-19
- [AD 2023-10-02](https://openairdocs.org/ad/2023-10-02.md): Indicating/Recording System, Navigation · Effective May 26, 2023 · Supersedes AD 2021-23-12
- [AD 2023-05-04](https://openairdocs.org/ad/2023-05-04.md): Hydraulic power · Effective May 12, 2023
- [AD 2022-24-11](https://openairdocs.org/ad/2022-24-11.md): Fire protection · Effective Jan 18, 2023
- [AD 2022-14-04](https://openairdocs.org/ad/2022-14-04.md): Fuel · Effective Oct 6, 2022
- [AD 2022-15-01](https://openairdocs.org/ad/2022-15-01.md): Stabilizers · Effective Aug 25, 2022
- [AD 2022-09-08](https://openairdocs.org/ad/2022-09-08.md): Stabilizers · Effective Jul 7, 2022
- [AD 2022-03-21](https://openairdocs.org/ad/2022-03-21.md): Fuel · Effective Apr 11, 2022
- [AD 2022-02-14](https://openairdocs.org/ad/2022-02-14.md): Main landing gear · Effective Mar 30, 2022
- [AD 2021-24-14](https://openairdocs.org/ad/2021-24-14.md): Thrust Reverser · Effective Feb 15, 2022
- [AD 2021-23-21](https://openairdocs.org/ad/2021-23-21.md): Fuselage · Effective Jan 10, 2022
- [AD 2021-23-20](https://openairdocs.org/ad/2021-23-20.md): Fuselage · Effective Jan 10, 2022
- [AD 2021-02-06](https://openairdocs.org/ad/2021-02-06.md): Fire protection · Effective Mar 30, 2021 · Supersedes AD 2019-02-03
- [AD 2020-20-09](https://openairdocs.org/ad/2020-20-09.md): Flight Controls · Effective Nov 13, 2020 · Supersedes AD 2015-14-07, AD 2016-07-10
- [AD 2020-17-13](https://openairdocs.org/ad/2020-17-13.md): Air conditioning · Effective Oct 8, 2020
- [AD 2020-17-02](https://openairdocs.org/ad/2020-17-02.md): Fuel, Engine · Effective Aug 25, 2020
- [AD 2020-05-26](https://openairdocs.org/ad/2020-05-26.md): Nacelles/Pylons · Effective May 4, 2020
- [AD 2020-06-14](https://openairdocs.org/ad/2020-06-14.md): Integrated Modular Avionics · Effective Apr 7, 2020
- [AD 2020-03-22](https://openairdocs.org/ad/2020-03-22.md): Wings · Effective Apr 2, 2020
- [AD 2020-02-12](https://openairdocs.org/ad/2020-02-12.md): Flight Controls · Effective Mar 12, 2020 · Supersedes AD 2017-15-04
- [AD 2019-23-07](https://openairdocs.org/ad/2019-23-07.md): Landing gear · Effective Jan 16, 2020
- [AD 2019-19-10](https://openairdocs.org/ad/2019-19-10.md): Fuel · Effective Jan 16, 2020
- [AD 2019-22-09](https://openairdocs.org/ad/2019-22-09.md): Fuselage · Effective Jan 13, 2020
- [AD 2019-22-01](https://openairdocs.org/ad/2019-22-01.md): Landing gear · Effective Dec 17, 2019
- [AD 2019-20-07](https://openairdocs.org/ad/2019-20-07.md): Flight controls · Effective Oct 11, 2019
- [AD 2019-16-10](https://openairdocs.org/ad/2019-16-10.md): Stabilizers · Effective Sep 19, 2019
- [AD 2019-08-05](https://openairdocs.org/ad/2019-08-05.md): Hydraulic Power · Effective Jun 6, 2019
- [AD 2019-06-13](https://openairdocs.org/ad/2019-06-13.md): Flight Controls · Effective Jun 3, 2019
- [AD 2019-01-04](https://openairdocs.org/ad/2019-01-04.md): Navigation · Effective Mar 22, 2019
- [AD 2019-01-01](https://openairdocs.org/ad/2019-01-01.md): Power plant · Effective Feb 4, 2019
- [AD 2018-23-12](https://openairdocs.org/ad/2018-23-12.md): Equipment/furnishings · Effective Dec 28, 2018
- [AD 2018-22-09](https://openairdocs.org/ad/2018-22-09.md): Navigation · Effective Dec 10, 2018
- [AD 2018-22-04](https://openairdocs.org/ad/2018-22-04.md): Flight control systems · Effective Nov 28, 2018 · Supersedes AD 2017-01-02
- [AD 2018-20-15](https://openairdocs.org/ad/2018-20-15.md): Electrical power · Effective Nov 20, 2018 · Supersedes AD 2015-09-07
- [AD 2018-17-03](https://openairdocs.org/ad/2018-17-03.md): Ice/Rain protection system wiring · Effective Sep 19, 2018
- [AD 2018-15-03](https://openairdocs.org/ad/2018-15-03.md): Engine Exhaust System · Effective Aug 27, 2018
- [AD 2018-12-06](https://openairdocs.org/ad/2018-12-06.md): Air conditioning · Effective Jul 16, 2018
- [AD 2018-11-13](https://openairdocs.org/ad/2018-11-13.md): Wings · Effective Jul 10, 2018
- [AD 2018-10-02](https://openairdocs.org/ad/2018-10-02.md): Equipment/furnishings · Effective May 29, 2018
- [AD 2018-07-19](https://openairdocs.org/ad/2018-07-19.md): Landing gear · Effective May 21, 2018
- [AD 2018-09-05](https://openairdocs.org/ad/2018-09-05.md): Powerplant · Effective Apr 26, 2018
- [AD 2018-08-03](https://openairdocs.org/ad/2018-08-03.md): Power plant · Effective Apr 17, 2018
- [AD 2018-05-07](https://openairdocs.org/ad/2018-05-07.md): Oxygen · Effective Apr 11, 2018
- [AD 2017-10-16](https://openairdocs.org/ad/2017-10-16.md): Wings · Effective Jun 29, 2017
- [AD 2017-09-08](https://openairdocs.org/ad/2017-09-08.md): Electrical power · Effective Jun 27, 2017
- [AD 2017-06-09](https://openairdocs.org/ad/2017-06-09.md): Fuselage · Effective May 1, 2017
- [AD 2016-26-06](https://openairdocs.org/ad/2016-26-06.md): Wings · Effective Feb 15, 2017
- [AD 2016-25-21](https://openairdocs.org/ad/2016-25-21.md): Air conditioning · Effective Jan 26, 2017
- [AD 2016-25-02](https://openairdocs.org/ad/2016-25-02.md): Flight Control Systems · Effective Jan 20, 2017
- [AD 2016-22-17](https://openairdocs.org/ad/2016-22-17.md): Fuselage · Effective Dec 27, 2016
- [AD 2016-19-04](https://openairdocs.org/ad/2016-19-04.md): Equipment/furnishings · Effective Oct 31, 2016
- [AD 2016-17-11](https://openairdocs.org/ad/2016-17-11.md): Wings · Effective Sep 12, 2016
- [AD 2016-14-04](https://openairdocs.org/ad/2016-14-04.md): Water/Waste, Fuselage · Effective Aug 12, 2016
- [AD 2016-12-11](https://openairdocs.org/ad/2016-12-11.md): Equipment/Furnishings · Effective Jul 27, 2016
- [AD 2016-11-18](https://openairdocs.org/ad/2016-11-18.md): Landing Gear · Effective Jul 12, 2016
- [AD 2016-11-17](https://openairdocs.org/ad/2016-11-17.md): Electrical power · Effective Jul 12, 2016
- [AD 2016-10-09](https://openairdocs.org/ad/2016-10-09.md): Powerplant · Effective Jun 24, 2016
- [AD 2016-07-25](https://openairdocs.org/ad/2016-07-25.md): Hydraulic Power · Effective May 18, 2016
- [AD 2016-08-12](https://openairdocs.org/ad/2016-08-12.md): Engines · Effective May 9, 2016
- [AD 2016-06-10](https://openairdocs.org/ad/2016-06-10.md): Nacelles/pylons · Effective May 3, 2016
- [AD 2016-06-08](https://openairdocs.org/ad/2016-06-08.md): Engines · Effective Mar 18, 2016
- [AD 2016-04-23](https://openairdocs.org/ad/2016-04-23.md): Equipment/furnishings · Effective Mar 15, 2016
- [AD 2016-04-08](https://openairdocs.org/ad/2016-04-08.md): Wings · Effective Mar 9, 2016
- [AD 2015-22-09](https://openairdocs.org/ad/2015-22-09.md): Fuselage · Effective Dec 10, 2015
- [AD 2015-19-09](https://openairdocs.org/ad/2015-19-09.md): Fuel · Effective Nov 3, 2015
- [AD 2015-17-24](https://openairdocs.org/ad/2015-17-24.md): Flight Controls · Effective Oct 7, 2015
- [AD 2014-24-06](https://openairdocs.org/ad/2014-24-06.md): Equipment/furnishings · Effective Jan 9, 2015
- [AD 2014-23-12](https://openairdocs.org/ad/2014-23-12.md): Oxygen · Effective Dec 31, 2014
- [AD 2014-17-02](https://openairdocs.org/ad/2014-17-02.md): Communications · Effective Sep 9, 2014 · Supersedes AD 2013-18-09
- [AD 2013-24-01](https://openairdocs.org/ad/2013-24-01.md): Power plant · Effective Nov 27, 2013
- [AD 2013-15-07](https://openairdocs.org/ad/2013-15-07.md): Communications · Effective Jul 26, 2013
- [AD 2013-08-12](https://openairdocs.org/ad/2013-08-12.md): Electrical Power · Effective Apr 26, 2013 · Supersedes AD 2013-02-51
- [AD 2012-24-07](https://openairdocs.org/ad/2012-24-07.md): Fuel · Effective Dec 5, 2012
- [AD 2026-16-08](https://openairdocs.org/ad/2026-16-08.md): Turbine Engine Compressor Section · Effective Sep 18, 2026
- [AD 2026-10-21](https://openairdocs.org/ad/2026-10-21.md): Engine Bleed Air System · Effective Jul 9, 2026 · Supersedes AD 2023-26-04
- [AD 2026-12-06](https://openairdocs.org/ad/2026-12-06.md): Turbine Section · Effective Jun 30, 2026 · Supersedes AD 2020-05-01
- [AD 2025-26-03](https://openairdocs.org/ad/2025-26-03.md): Engine (Turbine/Turboprop) · Effective Jan 27, 2026
- [AD 2025-23-10](https://openairdocs.org/ad/2025-23-10.md): Turbine Engine Compressor Section · Effective Dec 8, 2025
- [AD 2025-02-14](https://openairdocs.org/ad/2025-02-14.md): Turbine Engine Compressor Section · Effective Apr 1, 2025
- [AD 2024-23-04](https://openairdocs.org/ad/2024-23-04.md): Engine (Turbine/Turboprop) · Effective Jan 6, 2025 · Supersedes AD 2023-21-08
- [AD 2024-21-03](https://openairdocs.org/ad/2024-21-03.md): Engine (Turbine/Turboprop) · Effective Jan 6, 2025 · Supersedes AD 2023-24-06
- [AD 2024-10-14](https://openairdocs.org/ad/2024-10-14.md): Turbine Section · Effective Aug 13, 2024
- [AD 2024-08-06](https://openairdocs.org/ad/2024-08-06.md): Engine Fuel and Control · Effective Jun 10, 2024
- [AD 2024-05-12](https://openairdocs.org/ad/2024-05-12.md): Engine Fuel and Control · Effective May 22, 2024
- [AD 2023-22-04](https://openairdocs.org/ad/2023-22-04.md): Turbine Section · Effective Dec 26, 2023
- [AD 2023-12-21](https://openairdocs.org/ad/2023-12-21.md): Engine · Effective Aug 15, 2023 · Supersedes AD 2021-26-13
- [AD 2023-12-16](https://openairdocs.org/ad/2023-12-16.md): Turbine Engine Combustion Section · Effective Aug 15, 2023
- [AD 2022-08-16](https://openairdocs.org/ad/2022-08-16.md): Turbine Engine Compressor Section · Effective May 31, 2022 · Supersedes AD 2020-20-07
- [AD 2022-04-02](https://openairdocs.org/ad/2022-04-02.md): Turbine Section · Effective Mar 29, 2022
- [AD 2021-18-05](https://openairdocs.org/ad/2021-18-05.md): Turbine Engine Compressor Section · Effective Oct 21, 2021 · Supersedes AD 2020-15-12
- [AD 2021-17-12](https://openairdocs.org/ad/2021-17-12.md): Engine Fuel Pump · Effective Oct 13, 2021 · Supersedes AD 2020-13-07
- [AD 2021-07-11](https://openairdocs.org/ad/2021-07-11.md): Turbine Section · Effective May 11, 2021
- [AD 2020-15-08](https://openairdocs.org/ad/2020-15-08.md): Turbine Engine Compressor Section · Effective Aug 31, 2020
- [AD 2020-14-04](https://openairdocs.org/ad/2020-14-04.md): Turbine Engine Compressor Section · Effective Jul 23, 2020
- [AD 2019-20-05](https://openairdocs.org/ad/2019-20-05.md): Turbine Engine, Turbine Section · Effective Oct 30, 2019 · Supersedes AD 2018-15-01
- [AD 2019-16-14](https://openairdocs.org/ad/2019-16-14.md): Turbine Engine Compressor Section · Effective Sep 11, 2019 · Supersedes AD 2018-25-01
- [AD 2019-15-05](https://openairdocs.org/ad/2019-15-05.md): Turbine Section · Effective Aug 16, 2019
- [AD 2019-07-09](https://openairdocs.org/ad/2019-07-09.md): Turbine Engine Compressor Section · Effective May 28, 2019
- [AD 2017-10-19](https://openairdocs.org/ad/2017-10-19.md): Turbine Engine, Compressor Section · Effective Jul 20, 2017
- [AD 2017-02-01](https://openairdocs.org/ad/2017-02-01.md): Turbine/Turboprop Engine/Turbine Section · Effective Mar 14, 2017
- [AD 2014-22-02](https://openairdocs.org/ad/2014-22-02.md): Engine electronic controller (EEC) software · Effective Nov 14, 2014
- [AD 2024-01-01](https://openairdocs.org/ad/2024-01-01.md): Water/waste · Historical · Effective Mar 7, 2024 · Replaced by AD 2026-02-10
- [AD 2023-08-04](https://openairdocs.org/ad/2023-08-04.md): Water/waste · Historical · Effective Jun 29, 2023 · Replaced by AD 2026-09-01
- [AD 2022-02-16](https://openairdocs.org/ad/2022-02-16.md): Navigation · Historical · Effective Jan 19, 2022 · Replaced by AD 2023-12-10
- [AD 2021-08-19](https://openairdocs.org/ad/2021-08-19.md): Fire protection · Historical · Effective May 5, 2021 · Replaced by AD 2023-08-02
- [AD 2021-02-19](https://openairdocs.org/ad/2021-02-19.md): Fire protection · Historical · Effective Mar 8, 2021 · Replaced by AD 2021-08-19
- [AD 2020-26-08](https://openairdocs.org/ad/2020-26-08.md): Engine Exhaust · Historical · Effective Jan 27, 2021 · Replaced by AD 2024-01-04
- [AD 2020-24-04](https://openairdocs.org/ad/2020-24-04.md): Auto flight · Historical · Effective Dec 18, 2020 · Replaced by AD 2023-19-09
- [AD 2019-02-03](https://openairdocs.org/ad/2019-02-03.md): Fire protection · Historical · Effective Feb 22, 2019 · Replaced by AD 2021-02-06
- [AD 2018-05-06](https://openairdocs.org/ad/2018-05-06.md): Equipment/Furnishings · Historical · Effective Apr 11, 2018 · Replaced by AD 2023-08-02
- [AD 2017-15-04](https://openairdocs.org/ad/2017-15-04.md): Flight controls · Historical · Effective Aug 25, 2017 · Replaced by AD 2020-02-12
- [AD 2017-01-02](https://openairdocs.org/ad/2017-01-02.md): Flight Control Systems · Historical · Effective Feb 21, 2017 · Replaced by AD 2018-22-04
- [AD 2016-24-09](https://openairdocs.org/ad/2016-24-09.md): Flight Controls · Historical · Effective Dec 2, 2016 · Replaced by AD 2020-20-09
- [AD 2016-09-12](https://openairdocs.org/ad/2016-09-12.md): Equipment/Furnishings · Historical · Effective May 23, 2016 · Replaced by AD 2018-05-06
- [AD 2016-07-10](https://openairdocs.org/ad/2016-07-10.md): Flight controls · Historical · Effective Apr 14, 2016 · Replaced by AD 2020-20-09
- [AD 2015-14-07](https://openairdocs.org/ad/2015-14-07.md): Flight Controls · Historical · Effective Aug 20, 2015 · Replaced by AD 2020-20-09
- [AD 2015-09-07](https://openairdocs.org/ad/2015-09-07.md): Electrical power · Historical · Effective May 1, 2015 · Replaced by AD 2018-20-15
- [AD 2013-18-09](https://openairdocs.org/ad/2013-18-09.md): Communications · Historical · Effective Oct 3, 2013 · Replaced by AD 2014-17-02
- [AD 2013-02-51](https://openairdocs.org/ad/2013-02-51.md): Electrical power · Historical · Effective Feb 22, 2013 · Replaced by AD 2013-08-12
- [AD 2023-26-04](https://openairdocs.org/ad/2023-26-04.md): Engine Bleed Air System · Historical · Effective Feb 7, 2024 · Replaced by AD 2026-10-21
- [AD 2023-24-06](https://openairdocs.org/ad/2023-24-06.md): Engine (Turbine/Turboprop) · Historical · Effective Jan 31, 2024 · Replaced by AD 2024-21-03
- [AD 2023-21-08](https://openairdocs.org/ad/2023-21-08.md): Engine (Turbine/Turboprop) · Historical · Effective Dec 19, 2023 · Replaced by AD 2024-23-04
- [AD 2021-26-13](https://openairdocs.org/ad/2021-26-13.md): Engine (Turbine/Turboprop) · Historical · Effective Jan 27, 2022 · Replaced by AD 2023-12-21
- [AD 2021-25-04](https://openairdocs.org/ad/2021-25-04.md): Engine (Turbine/Turboprop) · Historical · Effective Jan 19, 2022 · Replaced by AD 2023-24-06
- [AD 2021-21-13](https://openairdocs.org/ad/2021-21-13.md): Engine (Turbine/Turboprop) · Historical · Effective Dec 2, 2021 · Replaced by AD 2023-21-08
- [AD 2020-20-07](https://openairdocs.org/ad/2020-20-07.md): Turbine Engine Compressor Section · Historical · Effective Nov 10, 2020 · Replaced by AD 2022-08-16
- [AD 2020-15-12](https://openairdocs.org/ad/2020-15-12.md): Turbine Engine Compressor Section · Historical · Effective Aug 31, 2020 · Replaced by AD 2021-18-05
- [AD 2020-13-07](https://openairdocs.org/ad/2020-13-07.md): Engine Fuel Pump · Historical · Effective Jul 13, 2020 · Replaced by AD 2021-17-12
- [AD 2020-05-01](https://openairdocs.org/ad/2020-05-01.md): Turbine Section · Historical · Effective Mar 25, 2020 · Replaced by AD 2026-12-06
- [AD 2018-25-01](https://openairdocs.org/ad/2018-25-01.md): Turbine Engine Compressor Section · Historical · Effective Dec 21, 2018 · Replaced by AD 2019-16-14
- [AD 2018-15-01](https://openairdocs.org/ad/2018-15-01.md): Turbine Engine, Turbine Section · Historical · Effective Aug 7, 2018 · Replaced by AD 2019-20-05
- [AD 2018-13-07](https://openairdocs.org/ad/2018-13-07.md): Turbine Engine Compressor Section · Historical · Effective Aug 7, 2018 · Replaced by AD 2018-25-01
- [AD 2018-08-02](https://openairdocs.org/ad/2018-08-02.md): Turbine Engine Compressor Section · Historical · Effective Apr 24, 2018 · Replaced by AD 2020-15-12

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
SELECT d.ad_number, d.status, d.subject, d.effective_date, m.matched_by
FROM (
  SELECT ad_id, min(rank) AS rank, arg_min(matched_by, rank) AS matched_by
  FROM (SELECT ad_id, 1 AS rank, 'airframe' AS matched_by FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE aircraft_model_code = '1388002'
    UNION ALL SELECT ad_id, 2, 'engine' FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE engine_model_code = '54544')
  GROUP BY ad_id
) m JOIN 'https://openairdocs.org/data/latest/faa_directive.parquet' d USING (ad_id)
ORDER BY d.status = 'Historical', m.rank, coalesce(d.effective_date, d.publication_date, d.issue_date) DESC, d.ad_number DESC
```

This list as a web page: https://openairdocs.org/aircraft/N786AV/ads

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