JASC 5315
Service difficulty reports · 44,223
Reports filed under 5315 · Fuselage Main, Floor Beam, newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5315' ORDER BY difficulty_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 sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE jasc_code = '5315' ORDER BY difficulty_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 2001UALA02434Floorbeam · gougedCABIN FLOORBEAM UPPER SURFACE OF UPPER CAP HAD GOUGE AT STATION 640 STRINGER 17R AT 12 RBL TO 20 RBL. MAJOR REPAIR ACCOMPLISHED. BLENDED OUT GOUGE AND AFT. INSTALLED TWO TAPERED STRAPS BELOW FWD AND AFT.SDR 2001UALA02433Floorbeam · corrodedBODY STATION 347 LBL 48-88 T-CAP IS CORRODED. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED SECTION AND SPLICES.SDR SIMA200201713Floorbeam · corrodedABI - LEVEL 2 CORROSION ON AFT DIGITAL. BLENDED OUT CORROSION IAW EMB GST-4055/01. (M)SDR SIMA200201710Floorbeam · corrodedABI - CORROSION ON LT OMEGA BEAM AT FRAMES 49 AND 50. BLENDED OUT CORROSION IAW EMB GST 4053/01. (M)SDR SIMA200201804Floorbeam · corrodedABI - LEVEL 2 CORROSION ON CENTER BEAM FLOOR RAMP. REPLACED CENTER BEAM FLOOR RAMP IAW EMB 145 SRM 51-40-02. (M)SDR SIMA200201805Floorbeam · corrodedLEVEL 2 CORROSION ON PREVIOUS REPAIR OF LT OMEGA BEAM AT FRAME 20. BLENDED OUT CORROSION AND INSTALLED DOUBLER ON LEFT OMEGA BEAM AT FRAME 20 IAW EMB 145 SRM 51-40-02 AND 53-21-10. (M)SDR 0105175504Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN FLOORBEAM UPPER CAP AT BS 700 LBL 25. REPAIRED PER EA 55-187429.SDR 2001UALA02424Floorbeam · gougedMID CABIN FLOORBEAM T-CAP STATION 700 LBL 15 TO RBL 23 GOUGED. MAJOR REPAIR ACCOMPLISHED. REPAIR STRAP AND ANGLE INSTALLED.SDR SWAA013342Beam · crackedDURING SCHEDULED 1/4D CHECK, FOUND BS 663 FLOORBEAM CRACKED, BBL 0. REPAIRED BEAM PER BOEING SB 737-57-1210SDR 2002F00168Floorbeam · corrodedFOUND CABIN UPPER FLOORBEAM CHORD AT BS 312 LBL 1 HAS CORROSION. (M)SDR 2001UALA02419Floorbeam · corrodedCABIN FLOORBEAM UPPER T-CAP CORRODED AT STATION 324 FROM 6 LBL OUT TO RBL AT STRINGER 17L-R. MAJOR REPAIR ACCOMPLISHED. SPLICED IN NEW T-CAP BEAM.SDR AWXA200100648Floorbeam · crackedMCN - MAJOR REPAIR - C - DURING C-15 CHECK MAINTENANCE FOUND A CRACK IN THE LIGHTENING HOLE ON THE UPPER CHORD OF LONGITUDINAL FLOORBEAM BS 664, LBL 25. MAINTENANCE STOP DRILLED CRACK AND PERFORMED HFEC INSPECTION TO VERIFY CRACK DID NOT PROCEED THROUGH HOLE,SDR DL76S011947Floorbeam · crackedTHE WEB AND LOCAL REINFORCING DOUBLER OF THE LBL 24 LONGITUDINAL FLOORBEAM WAS FOUND CRACKED NEAR AT FS 680. THE CRACKED REINFORCING DOUBLER WAS REMOVED AND WEB CRACK TRIMMED OUT. A NEW REINFORCING DOUBLER WAS INSTALLED AND AN ALUMINUM REPAIR DOUBLER. THE UPSDR 2001UALA02414Floorbeam · corrodedCABIN FLOORBEAM STATION 365 RBL 13 TO 28 CORRODED ON FWD SIDE OF FLANGE. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR SIMA200135206Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 24. REMOVED CORROSION BY BLENDING OUT. FABRICATED A Z-PROFILE REPAIR DOUBLER. REPAIR DONE IAW EMB GST-3862/01, ITEM 14 AND STANDARD SRM PRACTICES. (M)SDR SIMA200135205Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF AIRCRAFT, FOUND CORROSION ON THE GALLEY CENTER FLOORBEAM AT FRAMES 20 AND 23. REMOVED CORROSION BY BLENDING OUT AT FRAME 20 AND 23. FABRICATED TWO U-CHANNEL REPAIR DOUBLERS. REPAIR DONE IAW EMB GST-3862-/01, ITEM 10 AND STASDR DL73K011948Floorbeam · crackedTHE 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 WEB DAMAGE WAS TRIMMED OUT AND REPAIRED WITH AN ALUMINUM DOSDR ZW0A0112203Floorbeam · corrodedDURING CHECK-C MAINT ON CABIN FLOOR, FOUND CORROSION ON FLOORBEAM AT STA 1338, RBL 56. MADE CLIP PER SAMPLE AND DRAWING 9930612.SDR SIMA200135201Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION ON THE FORWARD DIGITAL. REMOVED CORROSION BY BLENDING OUT. FABRICATED A REPAIR DOUBLER 7.875 INCH BY 17 INCH .040 INCH THICK. REPAIR DONE IAW EMB GST-3851/01A, ITEM 2 AND STANDARD SRM PRACTICES. (M)SDR SIMA200135203Floorbeam · corrodedABI - DURING AN IMBV INSPECTION, FOUND CORROSION ON THE RIGHT GALLEY FLOORBEAM AT FRAME 20. REMOVED CORROSION BY BLENDING OUT. FABRICATED AN U-CHANNEL REPAIR DOUBLER. WORK DONE IAW EMB GST 3862/01, ITEM 12 AND STANDARD SRM PRACTICES. (M)SDR AWXA200100645Angle · crackedMCN - MAJOR REPAIR - "C"- DURING C-15 CHECK MAINTENANCE FOUND CRACK ON VERTICAL SUPPORT ANGLE AT BS 639, BL 45 L/H. MAINTENANCE REMOVED, FABRICATED, AND INSTALLED NEW SUPPORT ANGLE AT BS 637, BL 45 L/H, IAW DWG 65-46540 AND 737-300 SRM 51-40-02, PG 10-11.SDR C2XA01TY197Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE FORWARD DIGITAL PLATE LOCATED BELOW THE FLOORING AND JUST AFT OF THE COCKPIT ENTRANCE WAS FOUND TO HAVE SEVERAL AREAS OF CORROSION. MAINTENANCE REMOVED AND REPLACED THE FORWARD DIGITAL IAW EMB-135 SRM 51-40-02, THE REPASDR C2XA01TY194Floorbeam · corrodedTYS DURING A SCHEDULED INSPECTION THE LEFT HAND CENTER OMEGA BEAM AT FRAME 20 WAS FOUND TO HAVE SEVERAL AREAS OF CORROSION. MAINTENANCE REMOVED THE CORRODED AREA AND ACCOMPLISHED A DOUBLER REPAIR IAW EMB-135 SRM 53-21-10, THE REPAIR WAS SATISFACTORY. THE AISDR QXEA0102113Floorbeam · corrodedPDX - CENTER FLOORBEAM CORRODED ON TOP FLANGE AT STATION 6805. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8, PARAGRAPH 4-C, STEP 3.SDR QXEA0102112Floorbeam · corrodedPDX - CENTER FLOORBEAM CHAFED AND FRETTING CORROSION AROUND FASTENER HOLE, 4 INCHES FORWARD OF FRAME 13815B. REPAIRED IAW FOKKER SRM 53-01-01, PAGE 8, PARAGRAPH 4-C, STEP 2 AND 3.SDR SIMA200134703Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING ON A CORROSION REPAIR ITEM. GALLEY CENTER BEAM CORRODED. INSTALLED REPAIR DOUBLERS ON GALLEY CENTER BEAM ON FRAME 20-23 IAW EMB GST-3862/01. (M)SDR SIMA200134704Floorbeam · corrodedABI - THIS IS LEVEL 2 FINDING. FORWARD DIGITAL CORRODED. REPAIRED IAW EMB GST-3862/01. (M)SDR SIMA200134706Floorbeam · corrodedABI - THIS IS A LEVEL 2 FINDING, GALLEY AFT DIGITAL CORRODED. REPAIRED IAW EMB GST-3862/01. (M)SDR 2001UALA02404Floorbeam · damagedSTATION 1700 FLOORBEAM UPPER CHORD HAS EXCESSIVE MATERIAL AT RBL 44. ANGLES AND STIFFENERS ANGLES INSTALLED.SDR SIMA200134707Floorbeam · corrodedABI - THIS IS LEVEL 2 FINDING. LEFT OMEGA AT FRAME 20 HAS CORROSION ON PREVIOUS REPAIR. REPAIRED IAW EMB145 SRM 53-21-10. (M)SDR SIMA200134711Floorbeam · corrodedTHIS IS A LEVEL 2 FINDING. RIGHT GALLEY FLOORBEAM CORRODED. INSTALLED REPAIR DOUBLER AT FRAME 20 IAW EMB 145 GST 3862/01. (M)SDR 2001UALA02405Floorbeam · crackedTHE BODY STATION 246 FLOORBEAM MID CHORD IS CRACKED AT LBL7.88, RBL26.06 AND RBL 38.00. MAJOR REPAIR ACCOMPLISHED. A NEW ANGLE SECTION WAS SPLICED PER SRM 53-10-51-201 REPAIR 2.SDR ASAA0140169Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM AT BS 1016, LBL 29 AND WL 208 IS CORRODED. REPAIRED PER EA. (M)SDR ASAA0140171Floorbeam · corrodedPAE - DURING SI CHECK, FOUND CORROSION ON FLOORBEAM AT STATION 344, LBL 60 AND WL 206. REPAIRED IAW EA. (M)SDR ASAA0140172Floorbeam · corrodedPAE - DURING SI C-CHECK, FOUND CORROSION ON TOP OF FLOORBEAM AT BS 344, LBL 17 TO 43. REPAIRED PER EA. (M)SDR ASAA0110654Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BODY STATION 312, WATERLINE 208 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR SIMA200134504Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF A/C, FOUND CORROSION ON THE GALLEY CENTER FLOORBEAM. REMOVED CORROSION BY BLENDING. PERFORMED AN NDT INSPECTION OF THE AREA WITH NO REJECTABLE INDICATIONS. FABRICATED A U-CHANNEL REPAIR DOUBLER. REPAIR DONE IAW EMB GST390SDR SIMA200134503Floorbeam · corrodedABI - DURING AN IMBV INSPECTION OF A/C, FOUND CORROSION ON THE LEFT OMEGA BEAM AND PREVIOUS REPAIR AT FRAME 20. REMOVED PREVIOUS REPAIR AND CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE, FILLER, PLATE AND TWO SHIMS. REPAIR DONE IAW EMB 145 9SRM145/1142 CSDR DL73K011922Floorbeam · crackedINSPECTION OF THE RBL 24 FLOORBEAM UPPER CAP PER AD 2001-17-18 REVEALED A TYPICAL CRACK AT FS 680 AT THE AILERON QUADRANT CUTOUT IN THE FLOORBEAM. A PREVIOUS ALUMINUM DOUBLER REPAIR WAS INSTALLED FOR THE WEB. THE CRACKED UPPER CHORD WAS REMOVED, THE WEB INSPSDR 01FDEA01053Floorbeam · corrodedN 1288 UPPER CHORD OF FLOORBEAM CORRODED BS 340, RBL 40-55, WL 208.1. R&R FLOORBEAM PER SRM 53-10-8.SDR 01FDEA01052Floorbeam · corrodedN 1289 UPPER CHORD OF FLOORBEAM CORRODED AT BS 340, RBL 2-8, WL 208.1. R&R FLOORBEAM PER SRM 53-10-8.SDR 2001UALA02397Floorbeam · corrodedMAJOR CABIN FLOORBEAM CORRODED BS 340, RBL 88. CORROSION REMOVAL EXCEEDS SRM LIMITS. MAJOR REPAIR ACCOMPLISHED. REPAIRED FLOORBEAM.SDR SIMA200134202Floorbeam · corrodedABI - DURING AN IMBV, FOUND CORROSION ON THE LEFT OMEGA BEAM AT FRAME 20. REMOVED CORROSION BY CUT OUT. FABRICATED A DOUBLER ANGLE, FILLER, PLATE, AND SHIMS. REPAIR DONE IAW EMB145 (SRM145/1142 CHAPTER 53 REV 16) 53-21-10 AND STANDARD SRM PRACTICES. (M)SDR 0104775506Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN FLOORBEAM UPPER CAP AT BS 700 LBL 25. REPAIRED PER EA 55-186814SDR ZW0A0112003Floorbeam · corrodedDURING CHECK-C MAINT FOUND CORROSION ON TOP OF FLOOR BEAM CAP AT STA 1250 FROM LBL 24 TO LBL 43. REMOVED PART AND REMOVED CORROSION PER SPM 6-80-01. INSTALLED PART PER SRM 51-30-2.SDR 2001UALA02223Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN FLOORBEAM UPPER CAP AT BS 700 LBL 25. REPAIRED PER EA 55-186814SDR AWXA200100661Floorbeam · corrodedMCN - MAJOR REPAIR - C - DURING C-15 CHECK MAINTENANCE DISCOVERED SURFACE OF CABIN FLOORBEAM CORRODED AT BS 986.5, LBL 16 TO RBL 45. MAINTENANCE CLEANED CORROSION, BLENDED AREA, AND MEASURED SURFACE LOSS AT .025 (OUT OF LIMITS PER B737-300 SRM 53-60-51). LOWSDR AWXA200100659Web · crackedMCN - MAJOR REPAIR - DURING C-15 CHECK MAINTENANCE DISCOVERED WEB ON LONGITUDINAL FLOOR BEAM CRACKED IN 4 PLACES, BS 706, LBL .07. MAINTENANCE REMOVED 4 EACH WEB STIFFNERS (BS 700, 706, 711, 715) AND DAMAGED SECTION OF FLOOR BEAM WEB AT LBL .07 BS 700 TO 715. SDR 0104715506Floorboard · crackedDURING "H" CHECK FOUND CRACK IN FLOORBEAM UPPER CAP AT BS 700 LBL 45. REPAIRED PER EA 55-186813.SDR ASOA01275Floorbeam · corrodedDURING C-CHECK INSPECTION AT BNA, CORROSION WAS FOUND AT THE FLOOR OMEGA BEAM, FRAME STATION 4088, LEFT SIDE. MAINTENANCE REPAIRED THE CORRODED FLOOR OMEGA BEAM IAW ASA EO 120-53-0170. (M)
Back to JASC 5315