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 FDEA201004241351Floorbeam · corrodedCORROSION FLOORBEAM TOP SECTION MAIN CABIN BS 1130, LBL 45 - LBL 24. CUT-OUT DAMAGED AREA 2 5/8" X 1 3/8" FLOORBEAM BS 1130 LBL 45 TO LBL 24 IAW SRM 53-10-8 FIG 10 REV 102. FABRICATED REPAIR PART FROM 7075T6 .050 DIM: 10 1/4" X 3 1/4" IAW SRM 53-10-8 FIG 10 RSDR DALA108553352Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT Y1456 FR19. REPAIRED IAW 51-74-00, 51-42-11.SDR DALA108423260Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT Y254 FR20. REPAIRED IAW 53-11-14 FIG 201, 51-44-11, 51-42-11, 51-75-12.SDR USAA2010042690843Floorbeam · corrodedBFM - C4 - MAJOR REPAIR - LEVEL 2 CORROSION ON FLOORBEAM UPPER CHORD AT BS 347, LBL 85. REPAIRED FLOORBEAM UPPER CHORD AT BS 347, LBL 85 IAW B767 SRM 53-00-51, 51-40-02 & 51-21-01.SDR ASOA201000616Floorbeam · crackedFLOORBEAM CRACKED AT FS 280.00. INSTALLED NEW FS280 FLOORBEAM IAW SRM 51-23-00-001-001-A01, 51-42-06-001-001-A01, 51-42-21-001-001-A01 & 51-42-13-001-001-A01 & REO 670-53-11-047, REV E 08/13/09.SDR FDEA201004231346Floorbeam · crackedAFT CARGO PIT MDC FLOORBEAM FR 54.3 BETWEEN SEAT TRACK 2R-3R, CRACK LENGTH IS 0.125 IN ROUTED OUT CRACK FABRICATED, TREATED AND PRIMED AND INSTALLED REPAIR CHANNEL AT AFT CARGO PIT MDC FLOORBEAM FR 54.3 BETWEEN SEAT TRACK 2R-3R IAW SRM 53-10-15, PG 257-258, FSDR FDEA201004231338Floorbeam · corrodedCORROSION FLOORBEAM TOP MAIN CABIN BS 380, RBL 25 - RBL 45. CUT-OUT DAMAGED AREA DIM: 34" X 2", FABRICATED UPPER CHORD FROM BAC 1505-100617, DIM: 34" X 2.5". FABRICATED REINFORCEMENT STRAPS FROM BAC 1512 3396-7075-T6 AND BAC 1512-3353 7075-T6 DIM: 34" X 1" ANSDR DALA108443260Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT Y765 FR20. REPAIRED IAW 53-11-14 FIG 105, 51-44-11, 51-42-11, 51-75-12.SDR DALA108433260Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM Y1292 FR66 & FR68. REPAIRED IAW SRM 51-42-11, 51-74-00, 53-41-15, 51-44-11.SDR USAA2010042990862Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR16 TO FR20, -Y254. REPLACED FLOORBEAM BETWEEN FR16 TO FR20, -Y254 IAW A319 SRM 51-72-11.SDR USAA2010042990861Floorbeam · corrodedPIT - S2 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR14, Y495. REPLACED FLOORBEAM AT FR14, Y495 IAW A319 SRM 51-72-11.SDR DL75E100961Floorbeam · crackedDURING PSV 10, THE CABIN FLOORBEAM AT STA 700, LBL 24 WAS FOUND TO BE CRACKED ON THE UPPER CAP. REPAIR WAS ACCOMPLISHED IAW THE SRM AND ERA 481777-14.SDR DALA108233260Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOOR SUPPORT BEAM +Y1292 FR66. REPAIRED IAW SRM 51-42-11, 53-21-11.SDR DALA108223260Floorbeam · corrodedDURING M-CHECK, FOUND CORROSION ON FLOOR SUPPORT BEAM AT Y1162.5 FR68-FR69. REPAIRED IAW SRM 51-42-11, 53-21-01.SDR DALA108213260Floorbeam · damagedDURING M-CHECK FOUND DOUBLE DRILLED FLOOR SUPPORT BEAM AT Y1292 FR66. REPAIRED IAW SRM53-41-15, 51-42-11, 51-75-12.SDR FDEA201004221289Floorbeam · corrodedMAIN DECK FLOORBEAM CORRODED AT STA 345, RBL 45. REMOVED CORROSION ON FLOORBEAM AT STA 345 RBL 45 IAW SRM 51-10-02. FOUND OUT OF LIMITS IAW SRM 53-00-01, FIG 101, DETAIL II. ORIG MAT .125 AFTER REWORK .103. REPAIRED FLOORBEAM LBL 52- RBL 54 IAW SRM 53-00-51 FSDR FDEA201004221287Floorbeam · corrodedMCD FLOORBEAM STA 377 LBL 45 TO LBL 60 HAS CORROSION. R & R FLOORBEAM UPPER CHORD STA 377 LBL 45-60 IAW SRM 53-00-51 REPAIR 3. FABRICATED REPAIR ANGLE ON MAE TRAVELER NR T10/831079. CHORD FOUND OUT OF LIMTS IAW SRM 53-00-51, FIG 101 DETAIL II. CLASSIFIED CATSDR IPXA10559773Floorbeam · corrodedINSPECTION TYPE:C2, MCB FLOORBEAM UPPER SURFACE AT STA 1200, RBL 48- RBL 54 HAS AREAS OF CORROSION. REPAIRED IAW ATS ER NR 10-2548.SDR IPXA10559728Floorbeam · corrodedINSPECTION TYPE:C2, MCB FLOORBEAM UPPER SURFACE AT STA 1200, RBL48-RBL54 HAS AREAS OF CORROSION. REPAIRED IAW ATS ER NR 10-2548.SDR IPXA10559551Floorbeam · corrodedINSPECTION TYPE:C2, UPPER CHORD OF THE BS 297 BEAM IS CORRODED AROUND THE NUTPLATE HOLES LBL 1 TO 20 WL 208. BLENDED CORROSION AND FOUND OUT OF LIMITS AND REPLACED UPPER CHORD.SDR IPXA10559500Floorbeam · corrodedINSPECTION TYPE:C4, CORROSION ON BS 1360 FLOORBEAM LOWER FLANGE, RBL 26.5 TO 34, WL 201. REPAIRED IAW ER NR 10-2331.SDR USAA2010042690842Floorbeam · corrodedPIT - S4 - MAJOR REPAIR - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM BETWEEN FR16 TO FR21, -Y254. REPLACED FLOORBEAM BETWEEN FR16 TO FR21, -Y254 IAW EA 115064 & AIRBUS DRAWING D53110900.SDR REXA201000052Floorbeam · corrodedFS 280 FLOORBEAM BETWEEN FWD AND AFT J-ANGLES AT DOORWAY THRESHOLD BETWEEN LBL 9 AND RBL 9 CORRODED. REPAIRED FLOOR SUPPORT WEB IAW BOMBARDIER REO 601R-53-11-926 REV B.SDR USAA2010050690905Floorbeam · corrodedSAL - S1 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR12 TO FR24, -Y259. REPLACED FLOORBEAM BETWEEN FR12 TO FR24, -Y259 IAW A320 SRM 51-72-11.SDR USAA2010050690904Floorbeam · corrodedSAL - S1 - MAJOR REPAIR - LEVEL 2 FILIFORM CORROSION ON FLOORBEAM BETWEEN FR12 TO FR24, -Y1292. REPLACED FLOORBEAM BETWEEN FR12 TO FR24, -Y1292 IAW A320 SRM 51-72-11.SDR USAA2010050690903Floorbeam · corrodedSAL - S1 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR12 TO FR24, Y1292. REPLACED FLOORBEAM BETWEEN FR12 TO FR24, Y1292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D53112812.SDR USAA2010050690902Support · corrodedSAL - S1 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM SUPPORT BETWEEN FR12 TO FR24, Y254. REPLACED FLOORBEAM SUPPORT BETWEEN FR12 TO FR24, Y254 IAW A320 SRM 51-72-11.SDR ASOA201000600Floorbeam · crackedCABIN FLOOR SUPPORT STRUCTURE FS 280.00 LBL 9.0 IS CRACKED. CUT AWAY DAMAGED SECTION OF ANGLE THAT IS CRACKED IAW REO 601R-53-11-138NC. REPAIR NEEDS COMPLETED. REPAIRED CABIN FLOOR SUPPORT STRUCTURE AT FS 280, LBL 9.0 IAW EC/TC REO 601R-53-11-138.SDR F3LA2010050600418Floorbeam · corrodedCORROSION ON FLOORBEAM JUST INBD OF Y765 AT FRAME 68. R & R FLOORBEAM IAW A319 SRM 51-42-11, PAGE 1, STEP A, 51-44-11, PAGE 1 AND 51-21-11 PAGE 1 TABLE 1.SDR F3LA2010050500417Floorbeam · corrodedREFERENCE C-CHECK NON ROUTINE N0479. CORROSION ON NUT PLATE HOLES AT SPLICE ON FLOORBEAM AT Y-1292 FRAME 69. UPPER AND LOWER SIDES OF BEAM. R & R FLOORBEAM IAW SRM 51-72-11.SDR F3LA2010050500416Floorbeam · corrodedREFERENCE C-CHECK NON ROUTINE N0481. CORROSION ON PREVIOUS REPAIR AT FLOORBEAM, Y1292, FRAME 66. R & R FLOORBEAM IAW SRM 51-72-11, SHEETS 1 THROUGH 6.SDR F3LA2010050200410Floorbeam · corrodedREFERENCE HEAVY MX NON-ROUTINE N0534. CORROSION DISCOVERED ON NUTPLATE HOLES ON FLOORBEAM Y1292. R & R FLOORBEAM.SDR F3LA2010043100397Floorbeam · corrodedREF C-CHECK NON ROUTINE N0478. CORROSION IN (2) AREAS OF FLOORBEAM -Y765 AT FRAME 68. R & R FLOORBEAM IAW A319 SRM 51-42-11 PAGE 11.SDR USAA2010042890857Floorbeam · corrodedSAL - S1 - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR66 + 10 INCHES TO FR67 + 8 INCHES, -Y1292. REPLACED FLOORBEAM BETWEEN FR66 + 10 INCHES TO FR67 + 8 INCHES, -Y1292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING 53472000.SDR USAA2010042890856Floorbeam · corrodedSAL - S1 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR68, -Y1292. REPLACED FLOORBEAM AT FR68, -Y1292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING 53472000.SDR USAA2010042890855Floorbeam · corrodedSAL - S1 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR68, Y1292. REPLACED FLOORBEAM AT FR68, Y1292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING 53472000.SDR USAA2010042890852Floorbeam · corrodedSAL - S1 - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR66 + 10 INCHES TO FR67, Y1292. REPLACED FLOORBEAM BETWEEN FR66 + 10 INCHES TO FR67, Y1292 IAW A320 SRM 51-72-11 & AIRBUS DRAWING D5347217220400.SDR USAA2010042690840Floorbeam · crackedBFM - C4 - MAJOR REPAIR - CRACK ON VERTICAL FLOORBEAM WEB AT BS 246, RBL 18. REPAIRED VERTICAL FLOORBEAM WEB AT BS 246, RBL 18 IAW B767 SRM 51-70-13, 51-40-02 & 51-21-01.SDR ASOA201000584Crossbeam · corrodedCROSSBEAM AT FS 280.00 CORRODED FROM LBL 27.00 TO RBL 27.00. WORK ACCOMPLISHED ON JOB 7105725.SDR FDEA201004191253Floorbeam · corrodedCABIN AFT FLOORBEAM WITH CORROSION AT UPPER CHORD SURFACE AND SURROUNDING FASTENER HOLES AREA AT BS 1661, BETWEEN RBL 58 AND LBL 58. CORRODED BEAM AT BS 1661 R & R IAW SRM 51-40-02 REV 99. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100.SDR COEA2010041704901Floorbeam · corrodedHEAVY CK COE: LEVEL 2 CORROSION & MAJOR REPAIR: FLT DECK, FLOORBEAM 13 RT SIDE HAS SEVERAL AREAS OF CORROSION BETWEEN 10.75 INCHES RIGHT OF BL 0 AND 10.75 INCHES LEFT OF BL 0 WITH MATERIAL LOSS BEYOND SRM LIMITS. BLENDED CORROSION PER SRM AND SUBMITTED M70 TSDR FDEA201004171212Floorbeam · corrodedPREVIOUS REPAIR AT BS1681-8, FLOORBEAM LBL 24.75 TO 32.5 HAS CORROSION ON UPPER FLANGE. PREVIOUS BLEND OUT AT LBL 32.5 IS PITTED. REMOVED EXISTING REPAIR IAW EA NR F5310-131583, FABRICATED REPAIR STRAP FROM MAT 7075-76 0.090", FABRICATED REPAIR ANGLE NR 1,SDR DALA107873260Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON LT AFT CABIN FLOORBEAM AT Y765 FR66-FR70. REPAIRED IAW SRM 51-42-11, 51-44-11, 53-21-01.SDR AALA20100416TUL08Floorbeam · crackedCRACKS IN FLOORBEAM STATION 700 AT LEFT BUTTLINE 24 AND LEFT BUTTLINE 45.5. INSTALLED DOUBLERS ON FLOORBEAM PER AARD 53-30-51-2 REPAIR 2 AND CARD 53-98-01.SDR FDEA201004161205Floorbeam · damagedTHE 144N8007-64 CHORD, LWR FLANGE, AT BS 1160, RBL 8-LBL 8, WILL HAVE SHORT E.D. CONDITION ON 14 EA .250" HOLE LOCATIONS. AT BS 1160, RBL8 - LBL 8, A T-CHORD REPLACEMENT WAS ACCOMPLISHED DUE TO DISCREPANCY EFFECTING PTF CONVERSION, ON MAE MOD W/C 118350451CSDR SWAA102132Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND FLOORBEAM CORRODED AT BS 767, LBL 7.5. REPAIRED BEAM PER EA.SDR DL75E101212Floorbeam · corrodedEXTRUDED FLOORBEAM AT STA 1681 AND DECK PLATE CORRODED BETWEEN AT RBL 4 AND RBL 12. COMPLIED WITH ER/A 481843-14 REV REF NON ROUTINE 154817.SDR AALA20100414TUL08Floorbeam · crackedFLOORBEAM 700 CRACKED AT INBOARD SIDE OF 700 AND NUMBER 1 SEAT TRACK. REMOVED DAMAGED AREA AND INSTALLED T-CHORD REPAIR PER AARD 53-30-51-2, SRM 53-00-51-2R, PATTERN CARD 53-98-01, AND EA B757-53-010107.SDR AALA20100414TUL07Floorbeam · crackedFLOORBEAM 700 CRACKED AT INTERSECTION OF 700 AND NUMBER 2 SEAT TRACK. REMOVED DAMAGED AREA AND INSTALLED T-CHORD REPAIR PER AARD 53-30-51-2, SRM 53-00-51-2R, AND EA B757-53-010107.SDR FDEA201004141185Floorbeam · crackedMAIN CABIN FLOORBEAM AT STA 560, BL 0 IS CRACKED REPAIRED DAMAGED FLOOR BEAM AT STA 560 LBL 11.2 TO RBL 11.2 IAW SRM 53-00-51 FIG 201 REPAIR 1. CRACK FOUND OUT OF LIMITS IAW SRM 53-00-51 FIG 101, DETAIL II. CLASSIFIED CATEGORY "A" MAJOR REPAIR.
Back to JASC 5315