# Airworthiness directives that cite it: Snow Engineering SL 240

A list on [Snow Engineering SL 240](https://openairdocs.org/service-documents/snow-engineering/sl-240.md).

Newest first, with the revision each cites, as OpenAirDocs read it from the records’ text. OpenAirDocs read these citations from the records’ text, so one can be misread: check it against the record. A newer revision may exist that no record cites.

- [AD 2014-16-17](https://openairdocs.org/ad/2014-16-17.md): Wings · Air Tractor AT-802 and AT-802A · Effective Sep 29, 2014 · Supersedes AD 2010-17-18 R1 · No revision named · incorporated by reference
- [AD 2010-17-18 R1](https://openairdocs.org/ad/2010-17-18-R1.md): Wings · Air Tractor AT-802 and AT-802A · Effective Jan 14, 2011 · Replaced by AD 2014-16-17 · No revision named · incorporated by reference
- [AD 2010-17-18](https://openairdocs.org/ad/2010-17-18.md): Wings · Air Tractor AT-802 and AT-802A · Effective Sep 9, 2010 · Replaced by AD 2010-17-18 R1 · No revision named · incorporated by reference
- [AD 2010-13-08](https://openairdocs.org/ad/2010-13-08.md): Wing main spar lower caps · Air Tractor AT-802 and AT-802A · Effective Jul 28, 2010 · Replaced by AD 2010-17-18 · No revision named · incorporated by reference
- [AD 2006-23-09](https://openairdocs.org/ad/2006-23-09.md): Wing main spar lower caps · Air Tractor AT-602 · Effective Dec 14, 2006 · No revision named · incorporated by reference
- [AD 2006-23-01](https://openairdocs.org/ad/2006-23-01.md): Main landing gear bay · Pilatus PC-7 · Effective Dec 13, 2006 · No revision named · incorporated by reference

## 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, string_agg(DISTINCT c.revision, ', ' ORDER BY c.revision) AS revisions,
  bool_or(c.incorporated_by_reference) AS incorporated_by_reference, bool_or(c.in_regulatory_text) AS in_regulatory_text
FROM 'https://openairdocs.org/data/latest/service_document_citation.parquet' c JOIN 'https://openairdocs.org/data/latest/faa_directive.parquet' d ON d.ad_id = c.record_id
WHERE c.document_id = 'snow-engineering/sl-240' AND c.record_type = 'faa_directive'
GROUP BY ALL
ORDER BY max(c.record_date) DESC
```

This list as a web page: https://openairdocs.org/service-documents/snow-engineering/sl-240/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, except the copies of manufacturers’ service documents, which belong to their rights holders.