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 FDEA201007302732Floorbeam · damagedFLOORBEAM HAS DOUBLE DRILL HOLES BS 480 LBL 45. OVERSIZED HOLES TO 5/32" AND INSTALLED FASTENERS IAW SRM 51-30-5. WITHIN LIMITS IAW SRM 53-10-1 FIGURE 4B.SDR DALA1017913270Support · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM SUPPORT AT +Y465 BETWEEN FR64 & FR67. REPAIRED PER SRM 51-42-11, SRM 51-44-11.SDR SWAA104443Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM WEB CORRODED AT BS 1010, RBL 44. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA104442Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, RBL 46. REPAIRED BEAM PER SRM.SDR SWAA104422Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 947.5 TO BS 967, RBL 30. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA104420Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CHORD CRACKED AT BS 727B, LBL 24.8. REPAIRED BEAM PER EO.SDR SWAA104389Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 664, LBL 24.5. REPAIRED BEAM PER EO.SDR FDEA201007302735Floorbeam · corrodedFLOORBEAM CORRODED STA 1680, LBL 7 TO LBL 24. REMOVED CORROSION IAW SRM 51-10-02. CHECKED LIMITS BEFORE: .150", AFTER: .122", LOSS: .028" / L=25", W=2.7", D= .028", FOUND OUT OF LIMITS IAW SRM 53-00-51, FIG.101, DETAIL 3. ACCOMPLISHED FLOORBEAM REPAIR IAW SRMSDR IPXA0561938Floorbeam · corrodedINSPECTION TYPE:C2, FLOORBEAM CORRODED BS 1200, WL 207.5, RBL 26 TO RBL 43 REPAIRED IAW ER10-3761, DATED 12-AUG-2010.SDR IPXA0561937Floorbeam · corrodedINSPECTION TYPE:C2, FLOORBEAM, BS 1200, LBL 44 TO LBL 61, CORRODED ON UPPER SURFACE AT FASTENER HOLES REPAIRED IAW ER 10-3761, DATED 12-AUG-2010.SDR AALA20100729TUL08Strap · crackedAFT CARGO FLOORBEAM STABILIZER STRAP CRACKED AT APPROXIMATELY STATION 1360 RIGHT BUTTLINE 60 AFT CARGO CEILING AREA. CUT AND DRILLED REPAIR PLATE. SEALED AND RIVETED REPAIR PER SRM 51-20-02-0G, 51-40-01-0G.SDR AALA20100729TUL07Floorbeam · corrodedTHE STATION 328 FLOORBEAM UPPER CHORD IS CORRODED AT RIGHT BUTTLINE 21. INSTALLED UPPER TEE CHORD REPAIR OF FLOORBEAM AT STATION 328 PER SRM 53-10-51-2R 7.SDR USAA2010081091638Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM JOINT COVER BETWEEN FR12 TO FR14, Y50. REPLACED FLOORBEAM JOINT COVER BETWEEN FR12 TO FR14, Y50 IAW A320 SRM 51-72-11.SDR IPXA10561591Floorbeam · bentINSPECTION TYPE:C2, E & E BAY FLOOR SUPPORT IS BENT AT BS 460, RBL 25. R & R FLOOR SUPPORT IAW SRM 51-40-02-0G AND DWG 284N1308.SDR USAA2010080691610Floorbeam · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 GALVANIC CORROSION IN SEVERAL AREAS ON FLOORBEAM BETWEEN FR12 TO FR14, Y505. REPLACED FLOORBEAM BETWEEN FR12 TO FR14, Y505 IAW A320 SRM 51-72-11.SDR SWAA104368Floorbeam · crackedDURING SCHEDULED 26Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED BETWEEN BS 710 TO BS 715, LBL 24.5. REPAIRED WEB PER ER.SDR SWAA104364Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, BETWEEN LBL 21 TO RBL 5. REPAIRED BEAM PER SRM.SDR SWAA104331Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 665, RBL 24.8. REPAIRED BEAM PER ER.SDR SWAA104330Floorbeam · crackedDURING SCHEDULED SPV CHECK, FOUND FLOORBEAM CRACKED AT BS 665, LBL 24.8. REPAIRED BEAM PER ER.SDR DALA1017753270Floorbeam · corrodedDURING M-CHECK FOUND CORROSION ON FLOORBEAM AT Y254, FR20. REPAIRED IAW SRM 53-11-14 FIGURE 203, SRM 51-42-11.SDR USAA2010072991534Floorbeam · corrodedCLT - FLOOR MAT CHANGE - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR68, Y765. REPLACED FLOORBEAM AT FR68, Y765 IAW AIRBUS DRAWING D5347280.SDR ASOA201001054Floorbeam · crackedFS 484, FLOOR SUPPORT INTERCOSTAL ANGLE CRACKED .1" LONG AT LBL 27. R & R ANGLE IAW SRM 51-42-06 AND 51-42-21.SDR FDEA201007282707Floorbeam · corrodedFLOORBEAM CORRODED STATION 620, LBL 25-45. CUT OUT DAMAGED AREA DIMS 2 3/8" X 1". FABRICATED 2 EACH ANGLES USING 7075-O .090 DIMS 15 3/4" X 2 1/2" AND 10 3/8" X 2 3/8", HEAT TREATED ANGLES TO T6 CONDITION IAW ER 2-37153-801 REV A. FABRICATED FILLER USING 7SDR AALA20100728TUL03Floorbeam · corrodedSTATION 947 LEFT BUTTLINE 51.5 HAS DEEP CORRODED PIT IN FLOORBEAM TOP CAP. REPAIRED FLOORBEAM PER EA B737-53-011786.SDR U2RA227DH010Floorbeam · corrodedAFT CARGO COMPT FLOORBEAM AT STA 1681.8 LBL 58 SHIM FOR NUTPLATE CORRODED.SDR FDEA201007282695Floorbeam · corrodedAFT CARGO COMPARTMENT, UPPER MAIN CARGO DECK FLOORBEAM AT FRAME 54.3 HAS CORROSION AROUND A FASTENER HOLE, LT SIDE, BL-41L. REPAIRED FLOORBEAM IAW EA 6-5310-136372 "FUSELAGE - CROSSBEAM AT FR 54.3, CORROSION ON LOWER FLANGE".SDR COMA2010072850160Angle · corrodedFOUND CORROSION BETWEEN LBL 9 AND RBL 9 AT FS 280.00 ON FORWARD FLOOR ANGLE. TREATED CORROSION IAW SRM 51-25-01 AND REPAIRED SUPPORT ANGLE IAW REO 601R-53-11-137.SDR COMA2010072850159Angle · corrodedFOUND CORROSION BETWEEN LBL 9 AND RBL 9 AT FS 280.00 ON FORWARD FLOOR ANGLE. TREATED CORROSION IAW SRM 51-25-01 AND REPLACED CAM-LOC ANGLE IAW SRM 51-42-06.SDR IPXA10562124Floorbeam · cutINSPECTION TYPE:C2, MCB LONGNITUDINAL FLOORBEAM UPPER CHORD HAS A CUT AT BS 1020, RBL 2, WL 208. REPAIRED IAW ATS ER 10-3740.SDR IPXA0561993Floorbeam · dentedINSPECTION TYPE:C2, MCB FLOOR SUPPORT IS CORRODED AND DENTED OUTWARD AT BS 1060 BETWEEN BL0-RBL25, WL 208. REPLACED IAW DWG 144N5005, SRM 51-40-05-0G.SDR IPXA0561985Floorbeam · damagedINSPECTION TYPE:C2, MCB LONGITUDINAL FLOORBEAM HAS MECHANICAL DAMAGE AT BS 1060, RBL 1.5, WL 208. DAMAGED AREA FOUND OUT OF LIMITS, REPLACED IAW SRM 53-00-51-1A AND SOPM 20-50-01.SDR FDEA201007272808Floorbeam · corrodedFLOORBEAM CORRODED STA 1130 RBL35-55. CUT OUT DAMAGED AREAS DIMS 3 1/8" X 1" AND 2 3/4" X 7/8". FABRICATED ANGLE USING 7075-O .071 DIMS 27 1/8" X 2 1/2", HEAT TREATED PART TO T6 CONDITION IAW FASI ENG REPORT 2- 37153-801 REV A. FABRICATED TWO FILLERS USING 7SDR IPXA10561541Floorbeam · corrodedINSPECTION TYPE:C2, MCB FLOOR SUPPORT IS DENTED ON AFT SIDE WITH PLATE CORRODED AT BS 1016 BETWEEN RBL 25-45 WL 208. REPLACED IAW SRM 51-40-08. 51-40-05, DWG 144N5003.SDR IPXA10561478Floorbeam · damagedINSPECTION TYPE:C2, MCB FLOOR SUPPORT PLATE UPPER SURFACE IS DAMAGED AT BS 1020, BL0-RBL 25, WL 208. REPLACED MCB FLOOR SUPPORT PLATE UPPER SURFACE AT BS 1020, BL0-RBL 25, WL 208 IAW DWG 144N5003-6 & SRM 51-40-06.SDR AALA20100726AFW01Floorbeam · crackedSTATION 347 FLOORBEAM BETWEEN RIGHT AND LEFT BUTTLINE 27 CRACKED. ACCOMPLISHED REPAIR PER EA B767-53-011744.SDR FDEA201007262768Floorbeam · corrodedFLOORBEAM CORRODED STA 560 LBL 25-45 CUT OUT DAMAGED AREA DIMS 5.8" X .8". FABRICATED 2 ANGLES USING 7075-O .090 DIMS 18 3/4" X 2 7/8" AND 14" X 2 5/8". HEAT TREATED PARTS TO T6 CONDITION IAW FASI ENG REPORT 2-37153-801 REV A. FABRICATED FILLER USING 7075T-6 .SDR FDEA201007262760Floorbeam · corrodedFLOORBEAM CORRODED STA 380 RBL 25 T0 45 CUT OUT DAMAGED AREAS DIMS 2" X 9". FABRICATED 2 ANGLES USING 7075-O .090 DIMS 24" X 1.8" AND 17.375" X 1.6" AND FILLER USING 7075T-6 .125 DIMS 2" X 9". HEAT TREATED PARTS TO T6 CONDITION IAW FASI ENG REPORT 2-37153-801SDR FDEA201007262668Floorbeam · misrepairedEXISTING REPAIR AT FORWARD CARGO FLOORBEAM STATION 979. EXISTING REPAIR AT FORWARD CARGO FLOORBEAM STATION 979 EVALUATED AND FOUND PREVIOUSLY ACCOMPLISHED NOT INACCORDANCE WITH SRM REPAIR SCHEME. EXISTINGREPAIR REMOVED AND REPLACED WITH NEW REPAIR AS PER E.A.SDR SWAA104246Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 773, RBL 8. REPAIRED FLOORBEAM PER EA.SDR SWAA104245Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 773, RBL 14. REPAIRED FLOORBEAM PER EA.SDR SWAA104244Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 773, LBL 12.5. REPAIRED FLOORBEAM PER EA.SDR SWAA104243Floorbeam · corrodedDURING SCHEDULED 6Y CHECK, FOUND FLOOR SUPPORT CORRODED AT BS 773, LBL 8. REPAIRED FLOORBEAM PER EA.SDR USAA2010072691507Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - FLOORBEAM Y765 HAS SIGNS OF CORROSION FROM FRAME 64 TO 66. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, Y765 IAW AIRBUS DRAWING D53472000.SDR USAA2010072691506Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - AFT THREE FLOORBEAMS AT -Y1292 HAVE AREAS OF CORROSION. DAMAGE BEAMS HAVE BEEN REMOVED. REPLACED FLOORBEAM P/N D5347218920400 IAW AIRBUS DRAWING D17053472000.SDR USAA2010072691505Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - AFT THREE FLOORBEAMS AT -Y1292 HAVE AREAS OF CORROSION. DAMAGE BEAMS HAVE BEEN REMOVED. REPLACED FLOORBEAM P/N D5347217220390 IAW AIRBUS DRAWING D17053472000.SDR USAA2010072691501Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, Y254. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, Y254 IAW AIRBUS DRAWING D53472780.SDR USAA2010072691497Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - AFT THREE FLOORBEAMS AT -Y1292 HAVE AREAS OF CORROSION. DAMAGE BEAMS HAVE BEEN REMOVED. REPLACED FLOORBEAM P/N D5347219021100 IAW AIRBUS DRAWING D17053472000.SDR USAA2010072691496Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - FLOORBEAM Y765 HAS SIGNS OF CORROSION FROM FRAME 70 TO 67. REPLACED FLOORBEAM BETWEEN FR67 TO FR70, Y765 IAW AIRBUS DRAWING D53472000.SDR USAA2010072691495Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - FLOORBEAM Y765 HAS SIGNS OF CORROSION AT FRAME 65. REPLACED FLOORBEAM AT FR65, Y765 IAW A320 SRM 51-72-11.SDR USAA2010072691494Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - FLOORBEAM Y254 HAS SIGNS OF CORROSION FROM FRAME 66 TO 64. REPLACED FLOORBEAM BETWEEN FR64 TO FR66, Y254 IAW AIRBUS DRAWING D53472780.
Back to JASC 5315