Continental SB 651
Service difficulty reports that cite it · 3
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.
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR 2022FA0000469Magneto · Piper PA32RT300TWHILE 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 CLEARANCSDR 20000720SH036Capacitor · Beech 35BEECHCUSTOMER 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 MELTSDR 95ZZZX2950Contact Assy · Piper PA32RT300PILOT 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
Back to Continental SB 651