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 USAA2009042891014Floorbeam · corrodedSAL - C19 - MAJOR REPAIR - INTERGRANULAR CORROSION ON FLOORBEAM UPPER FLANGE AT BS 986.5 BETWEEN LBL 43 TO RBL 43. REPAIRED FLOORBEAM AT BS 986.5 BETWEEN LBL 43 TO RBL 43 IAW US AIRWAYS TYPICAL REPAIR 53-10-05B.SDR A6WA200940191Floorbeam · crackedCROSSBEAM AT FS 280.00, RBL 9.00, WL 70.00 IS CRACKED IN THE LOWER RADIUS. CROSSBEAM REPAIRED IAW REO 601R-53-11-171, REV D, SCHEME B. (K)SDR LR7A2009040900055Beam · corrodedDURING SCHEDULED C-4 CHECK PER JOB CARD HC5321, FOUND FLOORBEAM WEB CORROSION EXCEEDING 30% OF SKIN THICKNESS AT FS817E, WL146, RBL39. REPAIRED IAW SMP583 FIG 51-140-12.SDR LR7A2009040900052Floorbeam · corrodedDURING SCHEDULED C-4 CHECK PER JOB CARD 5313, FOUND CABIN FLOOR BEAM UPPER CAP CORROSION EXCEEDING LIMITS AT TIE-DOWN POINTS FS245E, WL146, LBL24 TO RBL37. REPAIRED BY REPLACING UPPER BEAM CAP IAW SMP583 CHAPTER 51-60 AND 51-70.SDR LR7A2009040900050Floorbeam · corrodedDURING SCHEDULED C-4 CHECK PER JOB CARD HC5313, FOUND CABIN FLOOR BEAM UPPER CAP WITH EXFOLIATION CORROSION AT FS277, LBL40, WL146. REPAIRED IAW SMP583 FIG 51-140-22.SDR LR7A2009040900049Floorbeam · corrodedDURING SCHEDULED C-4 CHECK PER JOB CARD HC5313, FOUND CABIN FLOORBEAM UPPER CAP WITH EXFOLIATION CORROSION AT FS257E, WL146, LBL20 TO LBL40. REPAIRED IAW SMP583 FIG 51-140-22.SDR LR7A2009040900042Floorbeam · chafedDURING SCHEDULED C-4 CHECK PER JOB CARD HC5313, FOUND CARGO COMPARTMENT BEAM ASSEMBLY WITH DEEP CHAFFING MARKS AT FS817E, WL146, LBL61 TO RBL61. REPAIRED BY REPLACING BEAM ASSEMBLY IAW SMP583 CHAPTER 51-7.SDR UALA2009040600961Floorbeam · corrodedCORROSION CABIN FLOORBEAM CAP AT STA 287, AT RBL 15. MAJOR REPAIR ACCOMPLISHED: REPLACED PREVIOUS DOUBLER REPAIR. INSTALLED NEW T-CAP SECTION AND SPLICES.SDR SWIA200921954Flange · crackedFS 280 FLANGES CRACKED. (C CHECK) REPAIRED PER REO.SDR DL757090737Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER CAP SURFACE CORRODED AROUND FASTENER HOLES STA 344 LBL 10-LBL 20. REPLACED FLOORBEAM SECTION AT SAA SAT ON N/R CARD 127243.SDR SWAA092134Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND FLOORBEAM OVER CENTER WING BOX CRACKED AT BS 673, LBL 24. REPAIRED BEAM PER AAR EA.SDR A6WA200940197Floorbeam · crackedOTBD ANGLES CRACKED AT FS 280.00, LBL 9.0, WL 72.00 (L+.200 INCH AND .300 INCH) OTBD + INBD ANGLES AT FS 280.00, LBL 9.0, WL 72, INSTALLED IAW SRM 51-42-21. (K)SDR A6WA200940190Floorbeam · crackedMWC 132400-83 - RT INBD ANGLE AT FS 280.00, RBL 8.00, WL 72.00 CRACKED, CRACK LENGTH .350 INCH RT INBD ANGLE AT FS 280.00, RBL 8.00, WL 72.00. REMOVED AND REPLACED IAW SRM 51-42-06 AND 51-42-21. (K)SDR SWAA092106Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED BEAM PER SRM.SDR SWAA092091Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 670, BBL 0, WL 207. REPAIRED BEAM PER SI.SDR SWAA092086Floorbeam · corrodedDURING SCHEDULED 22Y CHECK, FOUND FLOORBEAM CORRODED AT BS 312, BL 0. REPAIRED BEAM PER SRM.SDR SWAA092049Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM I/B UPPER CHORD CRACKED AT BS 727A+17, LBL 45. REPAIRED CHORD PER SWA EA.SDR FDEA200903311709Floorbeam · corrodedN1322 AFT CARGO COMPT - FLOORBEAM WITH CORROSION AT FR 63 AND BTW 44-55 LH. THE BEAM WAS REPLACED IN ACCORDANCE WITH 51-72-10.SDR SWAA092080Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BS 676, RBL 34.8. REPAIRED BEAM PER AAR EA.SDR SWAA092079Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 663 TO BS 669, RBL 24.8. REPAIRED BEAM PER AAR EA.SDR SWAA092078Floorbeam · crackedDURING SCHEDULED 20Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B, RBL 45.5. REPAIRED BEAM PER AAR EA.SDR DL75E090775Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 1640 BL0 LBL 59 HAS MULTIPLE AREAS OF CORROSION. REPAIRED PER ERA474162-14 REV ORIG DURING HMV IN SAT ON NRC 134488.SDR DL75E090764Floorbeam · corrodedFLOORBEAM STA 324 RBL47 HAS CORROSION. REPAIR C/W ON NR 127584 IAW SRM 53-10-08 FIG 202 AT SAA IN SAA DURING HMV.SDR IPXA09555661Floorbeam · corrodedINSPECTION TYPE:C CORROSION ON MAIN DECK FLOORBEAM AT STA 1200 BETWEEN LBL 3.6 AND 5.6 CORROSION IS OUT OF LIMITS. REMOVED CORROSION. FOUND OUT OF LIMITS IAW SRM 53-00-51-1A1 DETAIL II. REMOVED CEILING PNL PER SRM 51-40-02. REMOVED CLIP FWD FLOORBEAM. FABSDR COEA2009033003912Floorbeam · corrodedIN HEAVY CHECK MAJOR REPAIR: FOUND LEVEL 2 CORROSION ON TOP SIDE OF FLOORBEAM 17 AT FRAME 17. CORROSION REMOVED AND BLENDED FOUND TO EXCEED DAMAGE TOLERANCE. CUT OUT AND FABRICATED REPAIR SPLICE FOR FLOORBEAM.SDR SWAA092018Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 772, RBL 8. REPAIRED BEAM PER AAR EA.SDR SWAA092017Floorbeam · corrodedDURING SCHEDULED 8Y CHECK, FOUND FLOORBEAM CORRODED AT BS 986, BETWEEN LBL 55 TO RBL 5. REMOVED AND REPLACED BEAM PER SRM.SDR SWIA200922017Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C CHECK) REPAIRED PER REO.SDR DL75E090770Floorbeam · corrodedMAIN CABIN FLOORBEAM STA 1660 LBL57 CORRODED. REPAIRED PER ERA 4741455-14 REV O DURING HMV IN SAA AT SAT ON NR 134572.SDR DL757090542Floorbeam · damagedDURING AN SRM REPAIR WHILE IN HMV, ATS MAINTENANCE CREATED SHORT EDGE DISTANCE PROBLEMS COMMON TO THE REPLACEMENT FLOORBEAM UPPER CHORD AND THE FLOORBEAM WEB AT FS 365. A REPAIR WAS DESIGNED BY BOEING AND INSTALLED BY ATS.SDR AALA20090707TUL11Floorbeam · crackedFLOORBEAM CRACKED REPAIRED IAW EA B757-53-005762 DATED 26 MAR 09.SDR AALA20090707TUL12Floorbeam · crackedFLOORBEAM CRACKED. REPAIRED IAW EA B757-53-005762.SDR AALA20090707TUL10Floorbeam · crackedFLOORBEAM CRACKED. REPAIRED IAW EA B757-53-005762 DATED 26 MAR 09.SDR FDEA200903251406Floorbeam · corrodedZONE 100 - FUSELAGE - PREVIOUS REPAIR AT FLOORBEAM LOCATED AT FR 55/58 AT Y-1200. REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF IT WAS ACCOMPLISHED USING FAA APPROVED DATA. THE REPAIR WAS REMOVED BECAUSE THE FLOORBEAM WAS REPLACED AS PER THSDR IPXA09555494Floorbeam · corrodedINSPECTION TYPE:C2 FLOOR STRUCTURE AT BS 1100, LBL 14, WL 208 IS CORRODED. REPAIRED PER ATS ER 09-2166.SDR ASOA200900369Floorbeam · corrodedWORK ORDER 50921 ZONE 1000 ITEM 13 280 FLOOR SUPPORT BEAM CORRODED AT RBL 9.0 AND LBL 9.0.SDR ASAA0944899Floorbeam · damagedFLOORBEAM WHERE SEAT TRACK ATTACHES AFT FASTENER HOLE IS A DOUBLE HOLE. REPAIRED FLOORBEAM AT BS 727D.SDR SWAA091985Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 24. REPAIRED BEAM PER AAR EA.SDR FDEA200903251038Floorbeam · corrodedTHE BULK CARGO COMPARTMENT FLOOR SUPPORT BEAM AT FRAME 67 AND RBL 46 HAS CORROSION (PITTING) IN THE AREA OF THE CARGO TIE DOWN. REMOVED CORROSION IAW SRM 51-74-10; PG 1. ANGLE WAS FOUND TO BE OUT OF LIMITS. LOCATED, DRILLED AND REPLACED NUT PLATES IAW SRSDR FDEA200903251037Floorbeam · corrodedTHE MAIN DECK FLOORBEAMS ARE CORRODED AT FRAME C-14; RBL 36. REMOVED CORROSION IN REF TO SRM 51-74-10. FOUND TO BE OUT OF LIMITS IAW SRM 53-12-15. REMOVED FLOORBEAM IAW SRM 51-72-10 PG 2. DRILLED NEW SUPPORT IAW SRM 51-72-10 PG 2. INSTALLED NEW FLOORBEAMSDR USAA2009042891008Floorbeam · crackedSAL - Q6 - MAJOR REPAIR - CRACK IN FLOORBEAM UPPER CHORD AT BS 727A + 17 INCHES, RBL 45.5. REPAIRED FLOORBEAM UPPER CHORD AT BS 727A + 17 INCHES, RBL 45.5 IAW US AIRWAYS EA 132351.SDR USAA2009042790990Floorbeam · crackedSAL - Q6 - MAJOR REPAIR - CRACK ON FLOORBEAM SUPPORT "T" CHORD UPPER FLANGE AT BS 727 +17 INCHES, RBL 24.75. REPAIRED FLOORBEAM SUPPORT "T" CHORD UPPER FLANGE AT BS 727 +17 INCHES, RBL 24.75 IAW US AIRWAYS EA 132351.SDR IPXA09555527Floorbeam · corrodedINSPECTION TYPE:C3 CORROSION ON FLOORBEAM BS 310, LBL 59, WL 208 UPPER SURFACE. REMOVED DAMAGE HFEC INSPECT, FABRICATED REPAIR PARTS, INSTALLED REPAIR PARTS WITH FAYING SURFACE SEAL, PER ER NR 09-2129 DATED 09APR09.SDR USAA2009032790707Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON FLOORBEAM, FR 67 + 16" - FR 69 + 5", -Y1165. REPLACED FLOORBEAM, FR 67 + 16" - FR 69 + 5", -Y1165 IAW A320 SRM 51-72-11.SDR USAA2009032790706Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON FLOORBEAM HARD-POINT, FR 64 - FR 67 + 10", -Y465. REPLACED FLOORBEAM, FR 64 - FR 67 + 10", -Y465 IAW A320 SRM 51-72-11.SDR USAA2009032790705Floorbeam · corrodedSAL - MAJOR REPAIR - C7 CHECK - CORROSION ON FLOORBEAM HARD-POINT, FR 68 - FR 70, -Y160. REPLACED FLOORBEAM, FR 68 - FR 70, -Y160 IAW A320 SRM 51-72-11.SDR SWAA091960Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BETWEEN BS 706 TO BS 714, BL 0. REPAIRED BEAM PER ER.SDR SWAA091938Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 663, LBL 24. REPAIRED BEAM PER AAR EA.SDR C8GA20090101Splice Plate · corrodedWHILE IN HEAVY MAINTENANCE PERFORMING INSPECTION IT WAS NOTED THAT THE LOWER FLOORBEAM SPLICE AT BS 640 STR 17L WAS CRACKED. SPLICE PLATE WAS REMOVED AND NEW SPLICE PLATE WAS FABRICATED FROM 2024 T3 .125 DIM 18 X 9 INCHES. INSTALLED NEW SPLICE PLATE, NO OTHESDR USAA2009061591476Floorbeam · corrodedMIA - C1 - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FR 68, RBL 48. REPAIRED FLOORBEAM AT FR 68, RBL 48 IAW A320 SRM 53-41-14.
Back to JASC 5315