# Service difficulty reports that cite it: Bell ASB 206L-09-158

A list on [Bell ASB 206L-09-158](https://openairdocs.org/service-documents/bell/206l-09-158.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.

- [SDR EVCA2012012200029](https://openairdocs.org/sdr/EVCA2012012200029.md): Fitting · Bell 206L4 · Feb 22, 2012 · N493AE · No revision named
  > UPON COMPLETING ASB 206L-09-158, FOUND CRACKED TAIL BOOM FITTING.
- [SDR CA110629003](https://openairdocs.org/sdr/CA110629003.md): Attach Fitting · Bell 206L3 · Jun 26, 2011 · Revision B
  > UPPER LT (FUSELAGE) TAILBOOM ATTACHMENT FITTING FOUND WITH 1" VERTICAL CRACK THROUGH 1 FASTENER HOLE. FOUND ON DAILY INSP. PART REPLACED WITH NEW FITTING. ACFT MFG RECENTLY INCREASED THE INSP CRITERIA
- [SDR EVCA00005](https://openairdocs.org/sdr/EVCA00005.md): Fitting · Bell 206L3 · May 7, 2010 · N4338D · No revision named
  > UPPER LT ATTACHMENT FITTING FOUND CRACKED DURING INSPECTION OF TAILBOOM. UPPER LT ATTACHMENT FITTING IAW ASB 206L-09-158. UPPER LT ATTACHMENT FITTING R & R.
- [SDR HEEA126213](https://openairdocs.org/sdr/HEEA126213.md): Fitting · Bell 206L3 · Oct 11, 2009 · N3116L · No revision named
  > FOUND CRACK DURING ASB 206L-09-158 INSPECTION. REPLACED FITTING. NOTE: PREVIOUSLY SUBMITTED ON 10/15/09.

## The whole list in SQL

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

```sql
SELECT s.sdr_id, s.difficulty_date, s.aircraft_make, s.aircraft_model, s.part_name, 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_service_difficulty_report.parquet' s ON s.sdr_id = c.record_id
WHERE c.document_id = 'bell/206l-09-158' AND c.record_type = 'faa_service_difficulty_report'
GROUP BY ALL
ORDER BY max(c.record_date) DESC
```

This list as a web page: https://openairdocs.org/service-documents/bell/206l-09-158/reports

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