# Service difficulty reports that cite it: Continental SB 96-12

A list on [Continental SB 96-12](https://openairdocs.org/service-documents/continental/sb-96-12.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 99ZZZX1936](https://openairdocs.org/sdr/99ZZZX1936.md): Cylinder · Blanca 1730A · Apr 26, 1999 · N4058B · No revision named
  > ENGINE LOG ENTRY JANUARY 3, 1991, FOR REMOVAL AND REPLACEMENT OF ALL 6 ENGINE CYLINDERS. CYLINDERS INSTALLED WERE CERMICRON CYLINDERS, FLANGES WERE PAINTED ORANGE. AIRCRAFT EXPERIENCED ENGINE FAILURE
- [SDR 97ZZZX1589](https://openairdocs.org/sdr/97ZZZX1589.md): Cylinder · Mar 21, 1997 · No revision named
  > DURING ANNUAL INSPECTION, FOUND NR 2 CYLINDER HEAD SEPARATING FROM BARREL. THE HEAD WAS TURNED COUNTERCLOCKWISE 4 DEGREES AND WAS.0625 INCH FARTHER FROM FIRST CYLINDER FIN THAN OTHER CYLINDERS. LEAK
- [SDR 97ZZZX1233](https://openairdocs.org/sdr/97ZZZX1233.md): Cylinder · Cessna 210R · Mar 6, 1997 · N962CC · No revision named
  > WHILE PERFORMING TCM SB 96-12, CONTINUED AIRWORTHINESS INSTRUCTIONS FOR TCM CYLINDERS, BUBBLES WERE FOUND ACCUMULATING AROUND THE NR 2 CYLINDER UPPER SPARK PLUG HOLE. INSPECTION REVEALED A CRACK AT TH

## 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 = 'continental/sb-96-12' 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/continental/sb-96-12/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.
