Cessna SB 98-53-02
Service difficulty reports that cite it · 8
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 = 'cessna/sb-98-53-02' 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 = 'cessna/sb-98-53-02' 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 20001121SH004Firewall · Cessna 172SFIREWALL HAD CRACK APPROXIMATELY .75 INCH STARTING AT LOWER LEFT COWL MOUNT TOWARDS BATTERY BOX MOUNT. CESSNA SB 98-53-02. PERTAINS TO THIS SITUATION, BUT IS ONLY ON 172R MODEL. (X)SDR 99ZZZX2790Firewall · Cessna 172RFOUND FIREWALL CRACKED AT LOWER COWL MOUNT BRACKET ADJACENT TO BATTERY BOX WHILE C/W CESSNA SB 98-53-02, REV 1. PATCHED CRACK IAW SB 98-53-02, REV 1.SDR 99ZZZX2788Firewall · Cessna 172RCW CESSNA SB 98-53-02. FOUND FIREWALL CRACKED 1.25 INCHES AT LOWER COWLING MOUNT BRACKET ADJACENT TO FIREWALL. CRACK EXTENDED VERTICALLY BETWEEN TWO RIVET HOLES OF INNER BRACKET. AIRCRAFT NOT AFECTED SDR 99ZZZX2566Firewall · Cessna 172RC/W CESSNA SB 98-53-02. FOUND FIREWALL CRACKED AT LOWER COWLING MOUNT BRACKET ADJACENT TO BATTERY BOX. CRACK EXTENDED THROUGH INNER BRACKET RIVET HOLES APPROXIMATELY 1 INCH TO 2 INCHES IN LENGTH. ALSOSDR 99ZZZX2567Firewall · Cessna 172RC/W CESSNA SB 98-53-02. FOUND FIREWALL CRACKED AT LOWER COWLING MOUNT BRACKET ADJACENT TO BATTERY BOX. CRACK EXTENDED THROUGH INNER BRACKET RIVET HOLES APPROXIMATELY 2.75 INCHES IN LENGTH. ALSO, FOUNDSDR 99ZZZX2581Firewall · Cessna 172RC/W CESSNA SB 98-53-02. FOUND FIREWALL CRACKED AT LOWER COWLING MOUNT BRACKET ADJACENT TO BATTERY BOX. CRACK EXTENDED THROUGH INNER BRACKET RIVET HOLES APPROXIMATELY 2 INCHES IN LENGTH. ALSO FOUND LOWSDR 99ZZZX2582Firewall · Cessna 172RC/W CESSNA SB 98-53-02. FOUND FIREWALL CRACKED AT LOWER COWLING MOUNT BRACKET ADJACENT TO BATTERY BOX. CRACK EXTENDED THROUGH INNER BRACKET RIVET HOLES APPROXIMATELY 2 INCHES IN LENGTH. ALSO, FOUND LOSDR 99ZZZX2583Firewall · Cessna 172RC/W CESSNA SB 98-53-02. FOUND FIREWALL CRACKED AT LOWER COWLING MOUNT BRACKET ADJACENT TO BATTERY BOX. CRACK EXTENDED THROUGH INNER BRACKET RIVET HOLES APPROXIMATELY 2 INCHES IN LENGTH. ALSO, FOUND LO
Back to Cessna SB 98-53-02