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 SWIA200819666Floorbeam · crackedFS 280 AT RBL 9 AND LBL 9 FLOOR SUPPORT ANGLE IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER CRJ200 REO601R 53-11-136.SDR SWIA200819665Floorbeam · crackedFS 280 LOWER BEAM AT LBL 9 IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH REPAIRS PER CRJ200 REO601R-53-11-171.
SDR SWIA200819664Floorbeam · crackedFS 280 LOWER BEAM AT RBL 9 LOWER BEAM IS CRACKED, FOUND AT C-CHECK. COMPLIED WITH REPAIRS PER CRJ200 REO601R-53-11-171.SDR SWIA200819646Floorbeam · crackedLBL9 AT FS 280 LOWER FLOOR SUPPORT IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER CRJ200 REO 601R-53-11-171.SDR SWIA200819645Floorbeam · crackedFS 280 AT RBL9 LOWER FLOOR SUPPORT IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER CRJ200 REO 601R-53-11-171.
SDR SWIA200819644Floorbeam · crackedFS 280 AT RBL9 UPPER FLOOR SUPPORT IS CRACKED, FOUND AT C-CHECK. INSTALLED REPAIR PARTS PER CRJ200 REO 601R-536-11-137.SDR GTIA0800039Floorbeam · corrodedFLOORBEAM AT -Y1732 BETWEEN FR 68 AND FR 70 HAS CORROSION. REMOVED AND REPLACED FLOORBEAM ASSY IAW SRM 51-72-11.SDR SWAA081514Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 41 TO RBL 39. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA081490Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CHORD CRACKED AT BS 667, LBL 24. REPAIRED CHORD PER SRM.SDR CALA0800277Floorbeam · corrodedSTA 70 FLOORBEAM BL 0 TO RBL 12 HAS CORROSION DAMAGE AT BS 270 FLOORBEAM FOUND TO BE OUT OF LIMITS PER 737-300 SRM 53-10-51 FIG 101. REMOVED DAMAGE & REPAIRED PER AVO 350-53-007 CAL REV A. WEIGHT OF REPAIR WITH FASTENERS AS INSTALLED IS LESS THAN 5 LBS.SDR SIMA200808102Floorbeam · corrodedDURING MBV INSPECTION, FOUND TOP SIDE OF FORWARD DIGITAL CORRODED AT FRAME 15. REPAIRED DIGITAL IAW ETA EM-5300-013. AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA081469Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 312, LBL 12 TO RBL 12. REPAIRED CHORD PER SRM.SDR CALA0800230Floorbeam · corrodedCABIN - BS 325 RBL 3" - LBL 56" FLOOR SUPPORT FOUND CORRODED AFTER FLOOR PANEL REMOVED. CABIN BS 325 RB 10" TO LBL 45" FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 53-00-51 REPAIR 1 FIG 201 AND HFEC NO CRACK FOUND AND LBL 45" TO LBL 56" CORROSION REMOVED AS PER SSDR HNA2008F00008Floorbeam · crackedFOUND FLOORBEAM CRACKED AT FUSE STA 253 APPROX, IN FRONT OF RT EMERGENCY EXIT DOOR. REPLACED WITH NEW PART NR 85320471111 AND INSTALLED WITH SOLID RIVETS IAW SRM 51-40-00. (K)SDR SWIA200819640Floorbeam · crackedCRACK FOUND ON UPPER SUPPORT FRAME AT FS280.0 AND RBL9.0, FOUND AT C-CHECK. INSTALLED REPAIR PARTS FOR UPPER SUPPORT FRAME PER REO 601R-53-111-137.
SDR 2008UALA01472Floorbeam · corrodedCABIN FLOORBEAM UPPER SURFACE CORRODED AT BS 947, RBL 29"-48". MAJOR REPAIR ACCOMPLISHED: INSTALLED MAIN DECK FLOORBEAM UPPER CAP REPAIR.SDR ASAA0872797Floorbeam · crackedFLOOR SUPPORT CHANNEL AT STA 540 RBL0 RBL 24.75 INBD AND OUTBD ATTACH POINTS CRACKED FLOOR SUPPORT CHANNEL AT STA 540 RBL0 24.75. REPLACED IAW B737 700 SRM 51 40 02 AND B. DRWG 143A5240.SDR ASAA0872796Floorbeam · crackedFLOOR SUPPORT CHANNEL AT STA 540 LBL0 24.75 IS CRACKED AT INBD ATTACH POINTS FLOOR SUPPORT CHANNEL AT BS 540 LBL0 LBL24.75. REPLACED IAW B737 700 SRM 51 40 02 AND DRWG NR 143A5240.SDR USAA920080641Strap · crackedMCN - MAJOR REPAIR - C18 CHECK - CRACKED FLOORBEAM STABILIZATION STRAP, BS 344, RBL 33. REPAIRED FLOORBEAM STABILIZATION STRAP, BS 344, RBL 33 IAW B737 SRM 53-10-51-2R4.SDR 08FDEA00933Floorbeam · corrodedFWD PIT HAS CORROSION ON THE BOTTOM OF THE FLOORBEAM AT FRAME 37; LBL 103CM (40.5). REMOVED CORROSION FROM THE BOTTOM OF FLOORBEAM 37; Y 1000 TO 1030 IAW SRM 51-74-10; PG 210. ORIGINAL THICKNESS .126 IAW SRM 53-14-15; PG 9 AND DRAWING A53779635. MATERIAL RESDR 08FDEA00932Floorbeam · corrodedFOUND TOP CAP BEAM C 35 LT CORRODED. SPLICE REPAIR PERFORMED IAW SRM 53-10-15 FIG 207.SDR 08FDEA00929Floorbeam · damagedFOUND A DOUBLE HOLE AT CROSSBEAM C 62, Y-405. SPLICE REPAIR PERFORMED IAW. SRM 53-10-15 FIG 207.SDR UIEA200800073Floorbeam · crackedMAIN DECK STA 2020 RBL 62 FLOORBEAM CRACKED. REPLACED FLOORBEAM LOWER SUPPORT FITTING IAW SRM 51-10-01.SDR QXEA200800307Floorbeam · corrodedPDX - C4- CORROSION FOUND ON RT FLOOR SUPPORT FRAME CASTELLATION AT STA 545. REMOVED 5 RIVETS FROM CASTELLATION AND BLENDED OUT CORROSION. REF CPM CHAPTER 4. HFEC INSPECTED BLEND AREA FOR CRACK IAW D-8 200 NDTM PART 6, 51-00-01, NO CRACKS NOTED. UT THICKNESDR 08FDEA00920Floorbeam · corrodedFWD CARGO COMPARTMENT BILGE AREA; FLOORBEAM WEB AFT FACE HAS TOOL MARKINGS ABOVE STR 47R; FS 879. BLENDED AREA IAW SRM 53-00-01; VOL I; FIG 8. ORIGINAL THICKNESS .062 IAW SRM 53-13-01; VOL III; FIG 6; PG 24B AND SRM 51-10-01; FIG 32. REMAINING THICKNESS .0SDR SWAA081407Floorbeam · corrodedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CORRODED AT BS 294, LBL 12 TO RBL 4. REPAIRED FLOORBEAM PER SRM.SDR SWAA081409Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 512A, RBL 14. REPAIRED BEAM PER SRM.SDR A6WA200840217Floorbeam · crackedCRACK FOUND ON FS 280 LBL 9 ON FLOOR STRUCTURE. REPAIRED IAW CRJ200 REO 601-53-11-171 REV D ON FS 280 LBL 9. (M)SDR A6WA200840216Floorbeam · crackedCRACKS FOUND ON FS 280 RBL 9 ON FLOOR STRUCTURE. REPAIRED IAW REO 601R-53-11-1366 REV A. (M)SDR SWAA081375Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 1 TO LBL 9. REPAIRED FLOORBEAM PER SRM.SDR SWAA081374Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 312, LBL 1. REPAIRED FLOORBEAM PER SRM.SDR SWAA081371Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 31 TO LBL 45. REPAIRED FLOORBEAM PER ER.SDR A6WA200840185Floorbeam · crackedCRACK FOUND ON THE FLOORBEAM STRUCTURE AT FS 590, LBL 43 AND WL 73. FLOOR SUPPORT STRUCTURE REPAIRED IAW REO 601R-53-61-433. (M)SDR A6WA200840191Floorbeam · corrodedCRACK FOUND ON THE FLOOR SUPPORT STRUCTURE AT FS 621 LBL 41 WL 73. REPAIR TO FLOOR ANGLE FS 621 CARRIED OUT IAW CRJ 200 REO 601R-53-61-117 REV C. (M)SDR GTIA0800042Floorbeam · corrodedEVIDENCE OF CORROSION ON BEAM Y1292 FR 66 THROUGH FR 69. REMOVED AND REPLACED FLOORBEAM Y1292 FROM FR 66 THROUGH FR 69 IAW A319 SRM 51-72-1.SDR GTIA0800047Floorbeam · corrodedEVIDENCE OF CORROSION ON FLOORBEAM Y1292 FROM FR66 THROUGH FR 68. REMOVED AND REPLACED FLOORBEAM Y1292 FROM FR 66 THROUGH FR 68 IAW SRM 51-72-11.SDR GTIA0800045Floorbeam · corrodedEVIDENCE OF CORROSION ON FLOORBEAM Y254 BEAM 175. REPLACED FLOORBEAM Y254 BEAM 175 IAW SRM 51-72-11.SDR GTIA0800043Floorbeam · corrodedFLOORBEAM AT STAT -Y765 CORRODED BETWEEN FR 66 AND FR 70. REMOVED AND REPLACED FLOORBEAM -Y765 BETWEEN FR 66 AND FR 70 IAW SRM 51-72-11.SDR USAA920080787Floorbeam · corrodedMCN - MAJOR REPAIR - C3 CHECK - LEVEL 2 CORROSION ON FLOORBEAM, BS 1640, BL 0 - RBL 55, WL 208. REPAIRED FLOORBEAM, BS 1640, BL 0 - RBL 55, WL 208 IAW USAIRWAYS TYPICAL REPAIR 53-15-01.SDR SWAA081342Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, RBL 32 TO RBL 50. REPAIRED FLOORBEAM PER SRM.SDR SWAA081328Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 951, RBL 5. REPAIRED FLOORBEAM PER EA.SDR SWAA081318Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 29 TO RBL 42. REPAIRED FLOORBEAM PER SRM.SDR SWAA081334Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, LBL 5 TO RBL 46. REPAIRED FLOORBEAM PER SRM.SDR 08FDEA00824Floorbeam · corrodedCORROSION IS ON THE BOTTOM OF THE FLOORBEAM AT FRAME 47; LBL 103CM IN FWD PIT. FOUND TO BE OUT OF LIMITS IAW SRM 52-30-00. REMOVED EDGE MEMBER IAW SRM 51-40-21. REMOVED SEAL RETAINER IAW SRM 51-40-21. RECEIVED NEW EDGE MEMBER IAW SRM 52-31-00. FABBED DSDR 2008UALA01279Floorbeam · corrodedCABIN FLOORBEAM BS 864 UPPER CAP CORRODED AT FASTENER HOLE FOR EVAC SLIDE HOLD DOWN FITTING RBL 44 INCH. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED UPPER CAP FLOORBEAM REPAIR.SDR 08FDEA00796Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CAP LOWER SURFACE IS CORRODED NUTPLATE BS 1130, LBL 28-38. COMPLIED WITH EA 7-5310-113971 PART 1. CLASSIFIED AS A MAJOR REPAIR.SDR 2008UALA01236Floorbeam · corrodedCABIN FLOORBEAM FRAME UPPER SURFACE IS CORRODED, BS 294.5, RBL 15"-25". MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED BS 294 FLOORBEAM UPPER CAP SPLICE REPAIR.SDR ASAA0892768Floorbeam · corrodedFWD CARGO PIT AFT PANEL BULKHEAD LWR FLOORBEAM CORRODED STA 500 L RBL 24 TO LBL 24. REMOVED DAMAGED FLOORBEAM FABRICATED LOCATED DRILLED AND INSTALLED A REPLACEMENT PART IAW SRM 53-00-53 FIG 103 DWG 143A9485 & 5.0 P.M. 20 41 02 PGS 2 7.SDR 2008UALA01228Floorbeam · corrodedFWD CARGO COMPARTMENT FRONT SIDE OF THE FLOORBEAM AT BS 500 BETWEEN STRINGER 28R AND 27R IS CORRODED. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED SHEAR TIE REPAIR.SDR TRAX200800380Floorbeam · crackedFLOORBEAM AT LBL 36 AND FS 621 HAS POSSIBLE CRACK ON OUTBOARD UNDERSIDE IN RADIUS.
Back to JASC 5315