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 USAA2009122193389Floorbeam · corrodedMAJOR REPAIR - NR 6154383 - LEVEL 2 CORROSION ON FLOORBEAM AT FR 64 +9 INCHES, Y 765. REPLACED FLOORBEAM BETWEEN FR 64 TO FR 66, Y765 IAW SRM 51-72-11 DWG D53472000. (K)SDR USAA2009122193390Floorbeam · corrodedMAJOR REPAIR - NR 6154385 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR 64 +4 INCHES. Y1292. REPLACED FLOORBEAM BETWEEN FR 64 + 4 INCHES TO FR 67 + 16 INCHES, Y1292 IAW A320 SRM 51-72-11 & DWG D53472000. (K)SDR USAA2009121793363Floorbeam · corrodedSAL - BC7 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON CABIN FLOORBEAM BETWEEN FR 68 TO FR 69, -Y1292. REPLACED CABIN FLOORBEAM BETWEEN FR 68 TO FR 69, -Y1292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53472000.SDR SWAA097496Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 662, RBL 24.5. REPAIRED WEB PER ER.SDR F3LA2009120800246Floorbeam · corrodedREF NON ROUTINE C075818. DURING DEN C4/S1 C-CHECK, INSP NOTED CORRODED NUT PLATE HOLES ON THE FLOORBEAM LOCATED AT FRAME 68 AND STA Y1292. MX REMOVED AND REPLACED THE FLOORBEAM IAW SRM 51-42-11, SRM 51-44-11 AND SRM 51-72-11.SDR F3LA2009112800238Floorbeam · corrodedDURING C4 S1 C-CHECK, INSP NOTED CORROSION AT NUT PLATE HOLES ON Y1292 LT AT FRAME 68. MX REMOVED AND REPLACED FLOORBEAM IAW SRM 51-42-11, SRM 51-44-11 AND SRM 51-72-11.SDR F3LA2009120900254Profile · corrodedDURING DEN C4/S1 C-CHECK, INSP NOTED CORROSION ON THE FLOORBEAM LOCATED IN THE AFT CARGO COMPARTMENT AT FRAME 60 AND STRINGER 40R. MX PERFORMED REPAIR IAW SRM 51-42-11, SRM 51-44-00, SRM 51-21-11, SRM 51-75-12 AND EA A8-53R-31553.SDR ASAA0977085Floorbeam · scratchedMAIN CABIN FLOOR STRUCTURE T CAP HAS SCRATCH MARKS. REPAIRED FLOORBEAM CUTOUT DAMAGE INSTALLED REPAIR PARTS.SDR FDEA200911254187Floorbeam · damagedDOUBLE DRILLED HOLE IN FLOORBEAM UPPER TEE BS 1166, BL 0. CUTOUT DAMAGED AREA DIMS 5 1/4" X 2", FABRICATED UPPER TEE, 2 SUPPORT ANGLES, 3 ANGLE SUPPORTS, REINFORCEMENT STRAP, INSTALLED IAW SRM 53-10-8, 53-10-2 AND 51-30-2.SDR GTIA0900037Floorbeam · corrodedFLOORBEAM AT FR59 HAS CORROSION. REMOVED AND REPLACED FLOORBEAM.SDR SIMA200932801Floorbeam · corrodedDURING MAINTENANCE BASE INSPECTION FOUND THE RIGHT AND LEFT FRAME 280 TO BE CORRODED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE RIGHT AND LEFT FRAME 280 BEAM IAW EO CR-53MR-134R1. THE DEFECT LOCATION WAS 8 INCHES FROM EITHER SIDE OF THSDR K11A2009112372504Floorbeam · corrodedMAIN DECK FLOORBEAM UPPER CHORD, AFT LWR FLANGE HAS CORROSION.SDR SWAA097402Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 714, BBL 0.07. REPAIRED WEB PER SRM.SDR SWAA097398Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 663 TO BS 673, LBL 24.5. REPAIRED CHORD PER EO.SDR SWAA097397Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 706 TO BS 714, BBL 0.07. REPAIRED WEB PER EO.SDR SWAA097396Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 717, BBL 0.07. REPAIRED BEAM PER EO.SDR FDEA200911234127Floorbeam · damagedMIS-DRILLED FASTENER HOLES STA 1166 FLOORBEAM RBL 25 TO RBL 65. CUTOUT DAMAGED AREA DIMS 34" LONG, FABRICATED UPPER TEE, 2 SUPPORT ANGLES, AND 2 REINFORCEMENT STRAPS. INSTALLED IAW SRM 53-10-8, 53-10-2 AND 51-30-2.SDR FDEA200911234126Floorbeam · damagedMIS-DRILLED FASTENER HOLES STA 1166 FLOORBEAM LBL 25 TO LBL 65. CUTOUT DAMAGED AREA DIMS 3 3/4" X 2", FABRICATED UPPER TEE, SUPPORT ANGLES AND 2 REINFORCEMENT STRAPS. INSTALLED IAW SRM 53-10-8, 53-10-2 AND 51-10-2.SDR FDEA200911234125Floorbeam · damagedMIS-DRILLED FASTENER HOLES STA 1148 FLOORBEAM RBL 25 TO RBL 65. CUT OUT DAMAGED AREA DIMS 95 1/8" X 2", FABRICATED UPPER TEE REPAIR, SUPPORT ANGLES, REINFORCEMENT STRAP AND INSTALLED ALL PARTS IAW SRM 53-10-8, 53-10-2 AND 51-30-2.SDR FDEA200911234124Floorbeam · damagedMIS-DRILLED FASTENER HOLES STA 1148 FLOORBEAM LBL 25 TO LBL 65. CUTOUT DAMAGED AREA DIMS 3 3/8" X 2", FABRICATED UPPER TEE, 2 ANGLES AND 2 REINFORCEMENT STRAPS. INSTALLED IAW SRM 53-10-8, 53-10-2, AND 51-30-2.SDR FDEA200911234123Floorbeam · damagedMIS-DRILLED FASTENER HOLES STA 1130 FLOORBEAM RBL 25 TO RBL 65. REMOVED WEB AT STA 1130-1148, CUT-OUT DAMAGED AREA DIMS 2" X 1 1/4", FABRICATED ANGLE, HEAT TREATED PART TO T6 CONDITION IAW FASI ER NR 2-37153-801 REV A ON FASI FORM NR FAS0115 REV 19, MADE ISDR FDEA200911234122Floorbeam · damagedMIS-DRILLED FASTENER HOLES STA 1130 FLOORBEAM LBL 25 TO LBL 65. REMOVED WEB AT STA 1130-1148 FOR ACCESS, CUT OUT DAMAGED AREA DIMS 2" X 1 1/4", FABRICATED ANGLE, HEAT TREATED PART TO T6 CONDITION IAW FASI ENGINEERING REPORT NR 2-37153-801 REV A ON FASI FORMSDR SWIA200923810Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPAIRED PER REO.SDR USAA2010012290170Floorbeam · corrodedSAL - Q4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 1016 BETWEEN RBL 38 TO LBL 38. REPAIRED FLOORBEAM AT BS 1016 BETWEEN RBL 38 TO LBL 38 IAW EA 132773.SDR USAA2010011190065Floorbeam · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FLOORBEAM AT BS 727B, LBL 45.5. REPAIRED FLOORBEAM AT BS 727B, LBL 45.5 IAW EA 132761.SDR ASAA0977063Floorbeam · corrodedCORROSION COCKPIT FLOOR STRUCTURE (ENTRY WAY) RBL 12 TO LBL 11 WL 208 FABRICATED NEW INTERCOSTAL PRIMED AND INSTALLED.SDR FDEA200911204092Floorbeam · corrodedMAIN CABIN FLOOR STR STA 324 RBL 39 TO 46 FLOORBEAM UPPER SURFACE HAS AREAS OF CORROSION. REMOVED FLOOR T-CHORD, AND ATTACHING PARTS, FABRICATED NEW TEE , WEB, & EXTRUSION. INSTALLED NEW TEE, NEW WEB, NEW EXTRUSION AND ATTACHING PARTS STA 324- 344, LBL 60-RSDR USAA2009112393201Floorbeam · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT BS 967, LBL 20. REPAIRED FLOORBEAM AT BS 967, LBL 20 IAW TYPICAL REPAIR 53-10-05B & B737 53-10-02.SDR FDEA200911194045Floorbeam · corrodedFWD CARGO BS 786 BETWEEN STR 28R AND 28L SUPPORT ANGLE CORRODED. CORRODED SUPPORT ANGLE AT BS 786 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911194020Floorbeam · corrodedAFT CARGO BS 1340 RBL 8 TO RBL 12 FLOOR SUPPORT BRACKET CORRODED. CORRODED SUPPORT BRACKET AT BS 1340 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR USAA2009122193392Floorbeam · corrodedSAL - Q4- MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON UPPER REPAIR ANGLE OF FLOORBEAM AT BS 344 BETWEEN LBL 45.5 TO RBL 10. REPAIRED FLOORBEAM AT BS 344 BETWEEN LBL 45.5 TO RBL 10 IAW B737 SRM 53-10-51 & BOEING DRAWING 65-45815.SDR USAA2010011290084Floorbeam · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON OVAL CUTOUT BELOW FLOORBEAM AT UPPER CHORD. REPAIRED OVAL CUTOUT BELOW FLOORBEAM AT UPPER CHORD IAW EA 132755A.SDR USAA2010011190066Floorbeam · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FLOORBEAM BETWEEN BS 689 TO BS 645, RBL 24.75. REPAIRED FLOORBEAM BETWEEN BS 689 TO BS 645, RBL 24.75 IAW EA 312755.SDR USAA2010010890054Floorbeam · corrodedSAL - Q4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT BS 986.5 BETWEEN LBL 8 TO LBL 50. REPAIRED FLOORBEAM AT BS 986.5 BETWEEN LBL 8 TO LBL 50 IAW EA 132752.SDR USAA2009122193339Floorbeam · corrodedMAJOR REPAIR - NR 6165830 - LEVEL 2 GALVANIC CORROSION ON UPPER REPAIR ANGLE OF FLOORBEAM AT BS 344 BETWEEN LBL 45.5 TO RBL 10. REPAIRED FLOORBEAM AT BS 344 BETWEEN LBL 45.5 TO RBL 10 IAW SRM 53-10-51 AND DWG 65-45815. (K)SDR USAA2009121893374Floorbeam · corrodedSAL - Q4 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM UPPER CHORD REPAIR ANGLE FLAP AT BS 312 BETWEEN LBL 20 TO RBL 22. REPAIRED FLOORBEAM UPPER CHORD REPAIR ANGLE FLAP AT BS 312 BETWEEN LBL 20 TO RBL 22 IAW B737 SRM 53-10-51 REPAIR 5.SDR USAA2009121793362Floorbeam · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FLOORBEAM UPPER FLANGE AT BS 328 BETWEEN LBL 14 TO RBL 65. REPAIRED FLOORBEAM UPPER FLANGE AT BS 328 BETWEEN LBL 14 TO RBL 65 IAW B737 SRM 53-10-15.SDR 2009F00111Floorbeam · corrodedCOROSSION FOUND BELOW CABIN CTR SECTION FLOOR STRUCTURE ON REAR SPAR UPPER CHORD AT STA 955.1 BETWEEN LT BL 54.81 AND 74.81 DURING INSP IAW TASK CARD NR 53-510-00. (NOTE THAT THERE IS A PREVIOUS REPAIR AT THIS AREA AND THE COROSSION IS FOUND BENEATH IT).SDR USAA2009112393202Floorbeam · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 967, LBL 44. REPAIRED FLOORBEAM T-CAP AT BS 967, LBL 44 IAW TYPICAL REPAIR 53-10-05B.SDR USAA2009111893163Floorbeam · corrodedCLT - Q1 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM T-CAP AT BS 986 BETWEEN LBL 52 TO RBL 52. REPAIRED FLOORBEAM T-CAP AT BS 986 BETWEEN LBL 52 TO RBL 52 IAW TYPICAL REPAIR 53-60-01 REV A.SDR SWAA097286Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24.8. REPAIRED FLOORBEAM PER EO.SDR AALA20091117TUL01Floorbeam · corrodedCABIN FLOOR BEAM WITH REPAIR DOUBLER CORRODED. REMOVED CORROSION AND REPLACED DOUBLER.SDR USAA2009113093252Intercostal · corrodedCLT - Q1 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM INTERCOSTAL AT BS 950, RBL 50. REPLACED FLOORBEAM INTERCOSTAL AT BS 950, RBL 50 IAW B737 SRM 51-10-02.SDR SWAA097276Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 706 TO BS 711, LBL 24.5. REPAIRED FLOORBEAM PER EO.SDR SWAA097275Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 706, RBL 24.5. REPAIRED FLOORBEAM PER EO.SDR QXEA2009111800961Floorbeam · corrodedFS 280 BEAM IS CORRODED RT AND LT. BEAMS CORRODED THROUGHOUT, REMOVED 280 BEAMS IAW SRM 51-42-06-001-001-A01. PERFORMED LPI ON CROSSBEAM CUTLINE IAW REO 670-53-11-047. LOCATED FASTENER HOLES IN NEW BEAMS IAW 51-40-11-001-001-A01. INSTALLED BEAMS IAW REO 6SDR USAA2009111793127Floorbeam · corrodedCLT - Q1 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT BS 967, LBL 16. REPAIRED FLOORBEAM AT BS 967, LBL 16 IAW B737 SRM 53-00-51 REPAIR 2.SDR QXEA2009111600958Floorbeam · crackedFLOORBEAM FS280 HAS A CRACK EMANATING FROM A RIVET AT THE ATTACHMENT OF THE FLOOR POST AT LBL 11.16. VERIFIED 2 CRACKS USING HFEC IAW NDTM PART 6, 53-00-000. REMOVED LT HALF OF 280 BEAM IAW REO 670-53-11-047. ALODINED AND PRIMED NEW BEAM IAW SRM 51-25-06 ANDSDR AALA20091113AFW01Floorbeam · corrodedCORROSION WAS FOUND AT CLIP NUT ATTACHMENT HOLES ALONG THE INNER CHORD OF THE STATION 325 FLOORBEAM. THE CORROSION WAS FOUND BETWEEN RIGHT BUTTLINE 35 AND RIGHT BUTTLINE 9. THE CORROSION WAS REMOVED BY BLENDING PER SRM STANDARD PRACTICES AND A 0.050 INCH 301SDR AALA20091113TUL02Floorbeam · corrodedFLOORBEAM CORRODED AT STATION 986 FROM LEFT BUTTLINE 24 TO RIGHT BUTTLINE 17. BLENDED OUT CORROSION, INSTALLED REPAIR DOUBLERS PER SRM 53-00-00-7.
Back to JASC 5315