# Service difficulty reports that cite it: Continental SB 651

A list on [Continental SB 651](https://openairdocs.org/service-documents/continental/sb-651.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 2022FA0000469](https://openairdocs.org/sdr/2022FA0000469.md): Magneto · Piper PA32RT300T · Jul 28, 2022 · N3027J · No revision named
  > WHILE ENROUTE ENGINE FAILURE OCCURRED CAUSING A FORCED LANDING INTO A WOODED AREA. INVESTIGATION FOUND THAT CAM FOLLOWER ON RIGHT SIDE OF SINGLE SHAFT MAGNETO WAS MELTED WITH NO CONTACT POINT CLEARANC
- [SDR 20000720SH036](https://openairdocs.org/sdr/20000720SH036.md): Capacitor · Beech 35BEECH · Jun 28, 2000 · No revision named
  > CUSTOMER REPORTED THE RIGHT MAGNETO FAILED. INVESTIGATION REVEALED THE POINTS WERE NOT OPENING. TCM SB 651 DESCRIBES ONE CAUSE FOR THIS TO BE CAPACITOR FAILURE CAUSING POINTS TO ARC, HEAT UP, AND MELT
- [SDR 95ZZZX2950](https://openairdocs.org/sdr/95ZZZX2950.md): Contact Assy · Piper PA32RT300 · May 3, 1995 · N36590 · No revision named
  > PILOT NOTED A DEAD MAG IN THE RIGHT POSITION. INVESTIGATION REVEALED THE POINTS NOT OPENING. CONTACT ASSEMBLY HAS TIP BROKEN OFF. PART TOTAL TIME 30 HRS. TCM IGNITION SB 651 COVERS THIS, BUT IS NOT WE

## 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-651' 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-651/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.