Boeing SB 737-53-1061
Service difficulty reports that cite it · 15
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-1061' 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-1061' 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 AWXA200300608Floorbeam · Boeing 737277DURING C-15 CHECK A 2 INCH CRACK WAS FOUND ON TRANSVERSE FLOORBEAM WEB OUTBOARD OF LBL 45.50, BS 639. MAINTENANCE REMOVED DAMAGED ON WEB AT LBL 45.50, BS 639; FABRICATED REPAIR DOUBLERS AND A STRAP PESDR AWXA200300638Floorbeam · Boeing 737277YVR - MAJOR REPAIR - DURING C-15 CHECK A .25 INCH CRACK WAS ON FLOORBEAM WEB ANGLE AT BS 639, LBL 45.50. MAINTENANCE REMOVED DAMAGED FLOORBEAM WEB ANGLE AT BS 639, LBL 45.50; FABRICATED A NEW REPLACEMSDR AWXA200300609Frame · Boeing 737277YVR - MAJOR REPAIR - DURING C-15 CHECK A .25 INCH CRACK WAS FOUND ON LT FUSELAGE FRAME AT BS 639. MAINTENANCE REMOVED DAMAGED SECTION OF LT FUSELAGE FRAME AT BS 639; FABRICATED SPLICE REPAIR AND NEW SSDR P2EA00145Beam · Boeing 737247SJO - DURING C-CHECK, STUD BEAM WEB CRACKED AT BS 597, RBL 48 AND WL 204. REPAIRED STUD BEAM WEB AT BS 297 FROM RBL 45 TO RBL 56 AND BETWEEN WL 200 TO WL 208 IAW SB 737-53-1061 SECTION III PART III PASDR P2EA00154Beam · Boeing 737247SJO - DURING C-CHECK, FOUND CABIN STUB BEAM WEB AT BS 616 FROM RBL 45 TO RBL 56 BETWEEN WL 208 AND WL 200 HAS CRACK. L = 0.373 INCH. W = 0.0005 INCH. REPAIRED STUB BEAM AT BS 616 FROM RBL 45 TO RBL 56SDR P2EA00155Beam · Boeing 737247SJO - DURING C CHECK, FOUND CABIN STUB BEAM WEB AT BS 639 FROM RBL 45 TO RBL 56 BETWEEN WL 208 AND WL 200 HAS CRACK. L = 0.373 INCH, W = O.0005 INCH. REPAIRED CABIN STUB BEAM WEB AT BS 639 FROM RBL 45SDR P2EA00161Web · Boeing 737247SJO - DURING C-CHECK, FOUND STUB BEAM WEB BS 639 LBL 62 WL 204, WITH CRACK. L = 1.125 INCH. REPAIRED STUB BEAM WEB BS 639 LBL 62 WL 204, IAW BOEING SB 737-53-1061, REV 4 DATED 7-16-92 SECTION III, PARSDR P2EA00140Frame · Boeing 737247SJO - DURING C-CHECK, FRAME CRACKED AT BS 597, STR 17L. REPAIRED STR 17L AT BS 597 BETWEEN STR 15L AND WING CHORD IAW SB 737-53-1061 REV 4 SECTION III PART III. SEE COOPESA W/O N10316-2-199, VAM100 NRSDR P2EA00141Frame · Boeing 737247SJO - DURING C-CHECK, FRAME CRACKED AT BS 597 STR 17R. REPAIRED FRAME FROM STR 15R TO WING CHORD IAW SB 737-53-1061 REV 4 SECTION III PARA II. SEE COOPESA W/O N10316-2-201, VAM100 NR 620, 912SDA125 ANSDR P2EA00053Beam · Boeing 737222SJO - DURING Q-CHECK, STUD BEAM WEB CRACKED AT BS 639. REPAIRED STUD BEAM WEB AT BS 639, BETWEEN LBL 46 AND LBL 56.5 AND FROM WL 200 TO WL 208 IAW SB 737-53-1061 REV 4 PART III FIG 2 DATED JULY 16, 19SDR P2EA00052Frame · Boeing 737222SJO - DURING Q-CHECK, FRAME WEB CRACKED AT BS 639, BETWEEN 16L AND 17L. REPAIRED FRAME WEB AT BS 639 IAW SB 737-53-1061, REV 4 DATED JULY 16, 1992. (M)SDR AWXA9900294Angle · Boeing 737277C-CHECK, FLOORBEAM ATTACH ANGLE TO FUSELAGE AT STA 598 WL 208 LT CUSP LINE CRACK STR 17L. REMOVED, FABRICATED, AND INSTALLED REPAIR PARTS PER AWA ER 2-53-15-86 + SB 737-53-1061.SDR P2EA99291Floorbeam · Boeing 737247SJO - FLOORBEAM WEB CRACKED AT BS 578 BETWEEN RBL 55 AND RBL 55 AT WL 206. REPAIRED IAW SERVICE BULLETIN 737-53-1061 REVISION 4. (M)SDR ASAA9910177Fitting · Boeing 737210CPHX - DURING SCHEDULED D-CHECK, THE OVERWING STUB FRAME ATTACH FITTING STATION 639 RBL 45.5 CRACKED WERE FRAME TIES INTO SEAT TRACK FRAME WEB. REPAIRED PER SB 737-53-1061. (M)SDR P2EA98291Angle · Boeing 737281SJO - ANGLE CRACKED AT BS 559, RBL 46, WL 205 DEFECT SIZE LENGTH .4375. REPLACED FUSELAGE LOWER CHORD AT BS 559, WL 204, BETWEEN RBL 46 INCHES AND RBL 70 INCHES PER BOEING SERVICE BULLETIN 737-53-1061
Back to Boeing SB 737-53-1061