Boeing SB 737-57-1139
Service difficulty reports that cite it · 14
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-57-1139' 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-57-1139' 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 AWXA200300647Floorbeam · Boeing 737277DURING C-15 CHECK 2 EACH 1 INCH CRACKS WERE FOUND ON FLOOR BEAM UPPER STRUCTURE AT AFT END OF AILERON QUADRANT CUTOUT BS 676, RBL 24.5. MAINTENANCE CUTOUT DAMAGE ON FLOORBEAM UPPER STRUCTURE BS 676, RSDR AWXA200300648Floorbeam · Boeing 737277YVR - MAJOR REPAIR - DURING C-15 CHECK 2 EACH 1INCH CRACKS WERE FOUND ON FLOORBEAM STRUCTURE AT AFT END OF AILERON TOWER SHAFT QUADRANT CUTOUT BS 676, LBL 24.5. MAINTENANCE REMOVED ANGLE AND STIFFENERSDR DL73K020299Floorbeam · Boeing 737232CENTER WING / LONGITUDINAL OVERWING FLOORBEAM / BL 24.82 / FS 678 : CHORD AND WEB CRACK REPAIR INSPECTION OF THE LBL & RBL 24.82 LONGITUDINAL FLOORBEAMS PER AD 2001-17-18 REVEALED TYPICAL CRACKS IN THSDR DL73K011948Floorbeam · Boeing 737247THE OVERWING LONGITUDINAL FLOORBEAM AT RBL 24 WAS FOUND WITH A CRACK IN THE WEB, WEB REINFORCING DOUBLER AND UPPER CAP AT FS 680. THE UPPER CAP AND REINFORCING DOUBLER WERE REMOVED AND REPLACED. THE WSDR AWXA200100498Floorbeam · Boeing 737277YVR - C19 CK -LONGITUDINAL SEAT TRACK SUPPORT BEAM, LBL 24.5 CRACKED AT BOLT RELIEF HOLE, BS 679. MAINTENANCE MADE REPAIRS IAW AWA ER 15-5710-01269-JS1, REFERENCING BOEING S/B 737-57-1139, REV 4, FIG6SDR AWXA200100495Floorbeam · Boeing 737277YVR - C19 CK -RT OVERWING SEAT TRACK AILERON CUTOUT STRUCTURE AT RT I/B SEAT TRACK BS 658 VERT FLANGE CRACKED .3125 INCH. VISIBLE THROUGH CUTOUT UNDER STRUCTURE OF CLOSED FLOOR PANEL. MAINTENANCE STOPSDR DL73K010733Floorbeam · Boeing 737232THE LONGITUDINAL FLOORBEAM OVER THE CENTER WING AT RBL 24 WAS FOUND WITH A CRACK IN THE BEAM WEB DOUBLER AT FS 678 AND IN THE FLOOR BEAM UPPER CHORD AT FS 674. THE CRACKED WEB DOUBLER AND UPPER CHORD SDR DL73K010734Floorbeam · Boeing 737232THE LBL 24 LONGITUDINAL FLOORBEAM OVER THE CENTER WING WAS FOUND WITH A CRACK IN THE BEAM WEB DOUBLER AT FS 678. THE CRACKED WEB DOUBLER WAS REMOVED. A NEW WEB DOUBLER WAS INSTALLED AND THE BEAM MODIFSDR DL73K010691Floorbeam · Boeing 737232THE LONGITUDINAL FLOOR BEAM AT RBL 24 WAS FOUND WITH A TYPICAL CRACK IN THE BEAM WEB AND WEB DOUBLER AT FS 678. THE BEAM UPPER CHORD WAS FOUND CRACKED AT FS 674. THE UPPER CHORD WAS REMOVED AND REPLACSDR P2EA00339Doubler · Boeing 737247SJO - DURING Q-CHECK, FOUND DOUBLER ON PREVIOUS REPAIR ON FLOORBEAM AT AILERON CONTROL QUADRANT AT BS 678 LBL 24.82 CRACKED. L = 1.00 INCH. W = 0.002 INCH. IDENTIFIED AS REPORTABLE ON 11-7-00. REPLACESDR SPAA0000010Floorbeam · Boeing 7372T4DURING C4 CHECK, THE LONGITUDINAL FLOORBEAM WEB WAS FOUND CRACKED, BS 677, RBL 25, 2 BELOW FLOOR LEVEL AT THE RT AILERON QUADRANT CUT-OUT. THE DAMAGE WAS REPAIRED PER BOEING SERVICE BULLETIN 737-57-11SDR SPAA0000011Floorbeam · Boeing 7372T4DURING C4 CHECK, THE LONGITUDINAL FLOORBEAM WEB WAS FOUND CRACKED, BS 677, LBL 25, 2 BELOW FLOOR LEVEL AT THE LT AILERON QUADRANT CUT-OUT. THE DAMAGE WAS REPAIRED PER BOEING SERVICE BULLETIN 737-57-11SDR F3LA97120Splice · Boeing 7372L9PAE - FLT 1 - WHILE WORKING FUSELAGE 00021, (EO 53-11-737-001) FOUND SPLICE PLATE CRACKED AT BS 675, LBL 24.82, WL 205. REPAIRED CRACK AT BS 675 LBL 24.82, WL 205 IAW AEO. 041797. STOP DRILLED END OF SDR AWXA960198Floor Beam · Boeing 737275PAE - FLT 3802 - DURING ROUTINE SCHEDULED C-7 MAINTENANCE CHECK, FOUND CRACK ON FLOOR BEAM BS 678, RBL 25, WL 205. REMOVED CRACKED DOUBLER BS 678, RBL 25, WL 205. FABRICATED NEW DOUBLER, ALODINED AND
Back to Boeing SB 737-57-1139