Boeing SB 737-53-1096
Service difficulty reports that cite it · 6
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 = 'boeing/sb-737-53-1096' 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 = 'boeing/sb-737-53-1096' 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 33AY2016FA0000060Door Frame · Boeing 7372T4INSPECTION FOUND AFT CARGO DOORWAY AFT FRAME AT BS 847 CORRODED. REPAIRED IAW AD 93-14-10 AND SB 737-53-1096, REV 5 BY REMOVING THE DAMAGED FRAME SEGMENT AND INSTALLING A NEW FRAME REPAIR KIT WITH PN SDR DL73K010689Door Frame · Boeing 737232C2 CARGO DOOR OPENING FS 794.3, FWD FRAME FOUND WITH A 1.75 IN CRACK. THE CRACK IS TYPICALOF BAC S/B 737-53-1096 AND AD 93-14-10. THE CRACK WAS REMOVED WITH A 2.1 IN TRIMOUT AND REPAIRED WITH AN ALUMISDR DL73K001580Frame · Boeing 737232THE INBOARD STRAP WAS FOUND CORRODED AND CRACKS WERE FOUND IN THE FORWARD FRAME OF THE C2 DOOR OPENING AT APPROX WL 160. THE STRAP WAS REPLACED AND THE FRAME MODIFIED PER S/B 737-53-1096 WITH SOME DEVSDR ASAA9910168Frame · Boeing 737210CPHX - DURING SCHEDULED D-CHECK, THE FRAME AT STATION 847 STRINGER 24R TO 25R WAS FOUND CORRODED. REPAIRED PER SB 737-53-1096. (M)SDR F3LA98138Frame · Boeing 737301PAE - DURING C-CHECK, INSPECTION REPORTED CORROSION ON AFT CARGO DOOR FRAME, BS 794.5, RBL 24. MAINTENANCE REMOVED CORROSION (4.5 INCH BY 39 INCH) AND REMOVED AND REPLACED FRAME FROM STRINGER 16R TO 2SDR DL73S962274Doorway Frame · Boeing 737232AFT FRAME ON THE C-1 DOORWAY WAS FOUND TO BE CRACKED APPROX 6 BELOW THE LOWER STOP FITTING. THE CRACK IS LOCATED WHERE FRAME WAS GOUGED. A 1.10 DIAMETER HOLE WAS REQUIRED TO CLEAN UP THE DAMAGE TO THE
Back to Boeing SB 737-53-1096