# Service difficulty reports that cite it: Dunlop SB AHA2227-32-1292

A list on [Dunlop SB AHA2227-32-1292](https://openairdocs.org/service-documents/dunlop/aha2227-32-1292.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 CA190511001](https://openairdocs.org/sdr/CA190511001.md): Heat Shield · Dorner DO328300 · May 9, 2019 · Revision 1
  > (CAN) AFTER WHEEL REMOVAL DUE TO A WORN TIRE, THE RIGHT INBOARD BRAKE HEAT PACK P/N AH091447 WAS FOUND WITH BROKEN ROTORS AT CLIPS ATTACHMENT. THE AD D-2004-003, THE SB328J-32-169 AND THE DUNLOP SB AH

## 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 = 'dunlop/aha2227-32-1292' 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/dunlop/aha2227-32-1292/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.
