Saab SB 340-53-042
Service difficulty reports that cite it · 4
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 = 'saab/sb-340-53-042' 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 = 'saab/sb-340-53-042' 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 SIMA991541Skin · Saab 340BABI - DURING MBV INSPECTION, FOUND CHAFING ON THE LEFT REAR FUSELAGE SKIN PANEL AT HORIZONTAL STABILIZER LEADING EDGE SEAL. BLENDED OUT CHAFE DAMAGE. PERFORMED EDDY CURRENT INSPECTION, WITH NO INDICATSDR SIMA991441Skin · Boeing 7472B4BABI - DURING MBV INSPECTION, FOUND CHAFE ON THE LEFT AFT FUSEALGE AT THE HORIZONTAL STABILIZER FILLET FAIRING INTERFACE. BLENDED THE CHAFE AREA AND PERFORMED AN EDDY CURRENT INSPECTION WITH NO CRACK ISDR SIMA991401Skin · Saab 340BABI - DURING MBV INSPECTION, FOUND A CHAFE ON THE LEFT FUSELAGE AT THE STABILIZER FILLET FAIRING INTERFACE. BLENDED OUT THE CHAFE AREA AND PERFORMED EDDY CURRENT INSPECTION. RESTORED PROTECTIVE TREATMSDR SIMA990786Skin · Saab 340BABI - DURING MBV INSPECTION, FOUND CHAFE ON RT AFT FUSELAGE SKIN PANEL AT HORIZONTAL STABILIZER FILLET FAIRING CONTACT AREA. BLENDED AREA AND PERFORMED AN EDDY CURRENT INSPECTION WITH NO INDICATIONS O
Back to Saab SB 340-53-042