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 SWIA200819853Floorbeam · crackedFS 280 FLOOR ANGLE IS CRACKED AT LBL 9.0. (FOUND AT C-CHECK) REPAIRED FLOOR ANGLE IAW REO 601R-53-11-138.
SDR SWAA082198Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM WEB CORRODED BETWEEN BS 1016 AND BS 1040, BL 0 AND RBL 38. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082197Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM WEB CORRODED BETWEEN BS 1006 AND BS 1016, LBL 38 AND LBL 39. REMOVED AND REPLACED WEB PER SRM.SDR SWAA082156Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 986.5, LBL 18 TO RBL 50. REPAIRED CHORD PER ER.SDR CALA0800353Floorbeam · corrodedCABIN - STA 303 LBL 17 TO 35 FLOOR SUPPORT FOUND CORRODED. CABIN STA 303 LBL 17 TO LBL 35 FLOORBEAM REPAIRED PER SRM 53-00-51 FIG 201 REPAIR 1, HFEC FOUND NO CRACK.SDR UPS08852397Floorbeam · corrodedINSPECTION TYPE:C3 A PIT CARGO COMP FLOORBEAM AT STA 70, LBL 50 IS CORRODED. CUT OUT DAMAGE, FABBED AND INSTALLED REPAIR ANGLE AND FILLER IAW, SRM 51-1-8, 51-3-0, 53-2-0 FIG 1F.SDR UPS08852386Floorbeam · corrodedINSPECTION TYPE:C3 MAIN CABIN FLOORBEAM HAS INTERGRANULAR CORROSION, LOWER SURFACE OF UPPER AFT FLANGE STA1700 RBL 20 TO 28. REPAIRED MAIN CABIN FLOORBEAM AT STA 1700 RBL 20 TO 28 IAW EA 008- 5310-01-A1369, EO DC8-5310-29405-AAND DWG 5755032.SDR SWAA082136Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 944, RBL 3. REPAIRED FLOORBEAM PER SRM.SDR 2008UALA02369Floorbeam · corrodedFLOORBEAM CORROSION WHERE BEAM Y254 CROSSES FRAME 68 THIS LOCATION IS JUST AFT OF LAV WASTE TANK AND TO LEFT OF AIRCRAFT CENTERLINE ON LEFT SIDE OF FLOORBEAM. REMOVED CORROSION IAW SRM 51-74-00. REMOVED FLOORBEAM IAW SRM 51-42-11. LOCATED , DRILLED AND DEBURRSDR 08FDEA01475Floorbeam · crackedCABIN OVERWING FLOOR SUPPORT BEAM IS CRACKED AT STA 1276 RBL 107; AT R-3 DOOR THRESHOLD. REPAIRED CRACKED BEAM AT STA 1276 BY SPLICING IN A NEW SECTION IN REF TO E.A. 8-5310-118481.SDR 08FDEA01474Floorbeam · crackedCABIN OVERWING FLOORBEAM IS CRACKED AT STA 1295 RBL 107 AT THE R-3 DOOR THRESHOLD. REPAIRED CRACKED BEAM AT STA 1295 BY SPLICING IN A NEW SECTION IN REF TO EA 8-5310-118482.SDR QXEA200800436Floorbeam · crackedPDX C4 CHECK - 280 BEAM HAS 2 CRACKS AT APPROX LBL 9 AND RBL 9. REMOVED 280 BEAM IAW CRJ 700 SRM 51-40-11. HFEC AT CUTOUT AREA IAW NDTM PT 1, 51-20-006 NO CRACKS NOTED. INSTALLED 280 BEAM IAW CRJ 700 SRM 51-42-06 AND 51-42-21.SDR SWIA200819880Buttstrap · corrodedBUTT STRAP IN FRONT OF LAV IS CORRODED. (FOUND AT C-CHECK) REPLACED BUTT STRAP IN FRONT OF LAV IAW SRM 51-10-02 AND SECURED IAW 51-40-07.
SDR DHL2008807502Floorbeam · damagedMAIN CARGO COMPT FLOORBEAM HOLE MISDRILLED STA 660.000 RBL 32.250" (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW SRM 51-2-1 FIG 1 SHEET 9-12, TR NR 51-130 DATED 01-26-04. REMOVED FASTENERS IAW SRM 51-1-20D. CUT OUT DAMAGED SECTION AND FABRICATED REPAIR ANGLE, SDR SWAA082065Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM VERTICAL STIFFENER CRACKED AT BS 639, LBL 46. REMOVED AND REPLACED STIFFENER PER SWA EA.SDR SWAA082064Stiffener · crackedDURING SCHEDULED BRDG CHECK, FOUND LONGITUDINAL FLOORBEAM VERTICAL STIFFENER CRACKED AT BS 639, RBL 46. REMOVED AND REPLACED STIFFENER PER SWA EA.SDR 2008UALA02295Floorbeam · corrodedMAIN CABIN BS 365 TEE CAP HAS CORROSION AT RBL 42. MAJOR REPAIR ACCOMPLISHED: CUTOUT DAMAGE, 1" X 2" FWD EDGE OF TEE CAP. INSTALLED FILLER & ANGLE REPAIR.SDR QXEA200800399Floorbeam · corrodedPDX C4 CHECK ZONE 144 AFT FLOOR SUPPORT ANGLE AT STA X600 IS CORRODED AT Y20L AND Y24L. REMOVED CORROSION IAW CPM CHAP 4. UT THICKNESS IAW -8 200 PT 1, 51-00-04, HI .083 LOW .061. HFEC INSP. IAW -8 200 NDTM PT 6, 51-00-01 NO CRACKS NOTED. REMOVED .022" MATESDR QXEA200800398Floorbeam · corrodedPDX C4 CHECK ZONE 144 AFT FLOOR SUPPORT ANGLE AT STA X600 IS CORRODED AT Y29.5R. REMOVED CORROSION IAW CPM CHAP 4. UT THICKNESS IAW -8 200 PT 1, 51-00-04, HI .083 LOW .077. HFEC INSP. IAW -8 200 NDTM PT 6, 51-00-01 NO CRACKS NOTED. REMOVED .006" MATERIAL FOSDR USAA920081071Floorbeam · crackedMCN - MAJOR REPAIR - C12 CHECK - CRACKED FLOORBEAM UPPER CHORD, BS 700, RBL 24.75 AND RBL 45.5, WL 207. REPLACED FLOORBEAM UPPER CHORD, BS 700, RBL 16.25 - RBL 53.5, WL 207 IAW USAIRWAYS EA 130014.SDR ABXA080147Floorbeam · crackedFLOORBEAM CRACKED ON BOTH SIDES OF INTERCOSTAL AT STA 180, LEFT BUTT LINE 20. REPAIRED IAW DC9 SRM 53-05.SDR CALA0800343Floorbeam · corrodedAFT CABIN STATION 927 BL 0, CORROSION AT CLIP NUT HOLE. BLENDED CORROSION, DAMAGE FOUND TO BE OUT OF LIMITS PER 737-500 SRM 53-60-51 FIG 101. REPAIRED FLOORBEAM AT BS 927 BL-0 PER 737-500 SRM REFS, 53-60-51 FIG 201 REPAIR 3, AND 51-70-11 FIG 1.SDR FDEA200804151418Floorbeam · crackedFLOORBEAM AT FR 60 HAS 1 IN CRACK ON VERTICLE FLANGE, OTBD OF SEAT TRACK 3 RT, - Y1456, ON AFT FACE, REMOVED CRACK AND ACCOMPLISHED FLOORBEAM REPAIR IAW SRM 53-10-15, FIG 211.SDR USAA920081104Floorbeam · corrodedMIA - MAJOR REPAIR - C4 CHECK - CORROSION ON CABIN FLOORBEAM, BS 1480, RBL 40. REPAIRED CABIN FLOORBEAM, BS 1480, RBL 40 IAW B767 SRM 53-00-52 REPAIR 2.SDR ASAA0842864Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM LBL 4 FOUND CORRODED AT FASTENER HOLE LOCATION (CLIP NUT). AFT CABIN FLOOR BEAM AT BS 986 LBL 4 CORROSION AT FASTENER LOCATION REPAIRED IAW B737 400 SRM 53 00 51 FIG 201 REPAIR 3.SDR 08FDEA01418Floorbeam · crackedCROSSBEAM AT FR 60 HAS 1 IN CRACK ON VERTICAL FLANGE, O/B OF SEAT TRACK 3 RT, - Y1456, ON AFT FACE REMOVED CRACK AND ACCOMPLISHED FLOORBEAM REPAIR IAW A300-600 SRM 53-10-15, FIG 211.SDR 08FDEA01417Floorbeam · crackedCROSSBEAM AT FR 60 HAS 1 IN CRACK ON VERTICAL FLANGE, O/B OF SEAT TRACK 3 RT, - Y1456. ON AFT FACE REMOVED CRACK AND ACCOMPLISHED FLOORBEAM REPAIR IAW A300-600 SRM 53-10-15, FIG 211.SDR A6WA200840345Floorbeam · crackedFLOOR LANDING PLATE CRACKED AT FS 605, LBL 43. DAMAGE CUTOUT, NDT PERFORMED ON CUTOUT, REDUNDANT HOLE PLUGGED IAW REO 601R-53-61-433.SDR BEFA200800003Floorbeam · corrodedAFT CABIN FLOORBEAM AT BS 1661 LBL 48 INCH AND LBL 53.5 CORROSION CLEAN-UP IS BEYOND 10 PERCENT LIMIT IAW SRM. REPLACED FLOORBEAM IAW THE SRM TREATED AND PRIMED AREA.SDR ASAA0842863Floorbeam · corrodedAFT CABIN BS 986.5 FLOORBEAM CORRODED AT RBL 40 TO RBL 46 (PREVIOUS REPAIR). REPAIRED WITH REPAIR PART.SDR 08FDEA01400Floorbeam · damagedDURING MD10 MODIFICATION ACF FOUND IN AFT CARGO COMPT STA 1857 AT X 30 BEAM FLOOR WITH DOUBLE HOLE. REPAIRED FOR SRM 53-60-01 FIG 3 VOL I.SDR UPS08852179Floorbeam · corrodedINSPECTION TYPE:C1 C-PIT RIGHT STA 1120, FLOORBEAM JUST I/B OF CUSP IS BLOWN OUT AT FASTENER HOLE WITH CORROSION. REMOVED CORROSION, FABBED AND INSTALLED REPAIR ANGLE IAW SRM 51-1-8, 51-3-0, 53-2-0 FIG 1F, 51-1-20D.SDR SWAA081944Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 17. REPAIRED FLOORBEAM PER SRM.SDR SWAA081943Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 328, RBL 13 TO RBL 31. REPAIRED FLOORBEAM PER SRM.SDR F3LA200800162Floorbeam · corrodedDURING C4 S1 C CHECK INSPECTION REPORTED CORROSION WAS FOUND ON NUT CLIP HOLE FLOORBEAM Y1292 AT FRAME 67 AND WAS FOUND UNSERVICEABLE. MAINTENANCE REMOVED AND REPLACED FLOORBEAM Y1292 AT FRAME 67 IN ACCORDANCE WITH SRM 51-42-11 PARAGRAPHS 5 AND 7 AND AIRBUS DSDR SWIA200819708Floorbeam · crackedRBL 9 LOWER FLOORBEAM IS CRACKED AT FS 280. (FOUND AT C-CHECK) COMPLIED WITH REPAIRS PER REO 601R-53-11-1377.SDR SWIA200819707Floorbeam · crackedFS 280 FLOORBEAM IS CRACKED AT LBL9 AND RBL9. (FOUND AT C-CHECK) INSTALLED REPAIR PARTS PER REO 601R-53-11-136.SDR BEFA200800002Floorbeam · corrodedMAIN CABIN FLOORBEAM UPPER CAP AT BS 1640 CORRODED FROM LT TO RT SIDE. CAP WAS REMOVED AND REPLACED WITH NEW CAP IAW SRM.SDR USAA920080946Floorbeam · crackedMCN - MAJOR REPLACED - C21 CHECK - LEVEL 2 CORROSION ON FLOORBEAM, BS 1002, LBL 11, WL 208. REPLACED FLOORBEAM, BS 1002, LBL 11, WL 208 IAW B737M SRM 51-40-02.SDR F3LA200800190Floorbeam · corrodedDURING C4 S1 C CHECK INSPECTION NOTED CORROSION AT NUT PLATES AFT PIT LEFT FLOORBEAM UNDER COVER PROFILE AT FRAME 56 LOCATED FROM STRINGER 38 LEFT TO 38 RIGHT. MAINTENANCE FABRICATED REPLACEMENT PART IN ACCORDANCE WITH THE REQUIREMENTS OF AIRBUS DRAWING D5347SDR F3LA200800185Floorbeam · corrodedDURING C4 S1 C CHECK INSPECTION NOTED CORROSION AT NUT PLATES AFT PIT LEFT HAND FLOORBEAM UNDER COVER PROFILE AT FRAME 58 LOCATED FROM STRINGER 38 LEFT TO 38 RIGHT. MAINTENANCE FABRICATED AND REPLACED FLOORBEAM SUPPORT FITTING IN ACCORDANCE WITH THE REQUIREMESDR 2008UALA02055Floorbeam · corrodedFOUND BEAM 160 CORRODED WHILE ACCOMPLISHING EQ3700 CALLOUT. REPLACED BEAM 160 WITH NEW BEAM.
SDR 2008UALA02109Floorbeam · corrodedAFT FLOORBEAM CORRODED AT FLOOR BOARD HOLES STA 986.5 RBL 20-32 UPPER AND LOWER SURFACE. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED FLOORBEAM UPPER "T" CAP SPLICE REPAIR.SDR 2008UALA02102Floorbeam · crackedCABIN LONGITUDINAL FLOORBEAM HAS A CRACK AT LIGHTENING HOLE JUST BELOW SEAT TRACK, RBL 25" BS 669. MAJOR REPAIR ACCOMPLISHED: STOP DRILLED CRACK & VERIFIED CRACK TERMINATION WITH HFEC. INSTALLED REPAIR CHANNEL.SDR 2008UALA02101Floorbeam · crackedCABIN LONGITUDINAL FLOORBEAM HAS A CRACK AT LIGHTENING HOLE JUST BELOW SEAT TRACK, LBL 25" BS 665. MAJOR REPAIR ACCOMPLISHED: STOP DRILLED THE CRACKS AND VERIFIED CRACK TERMINATION WITH HFEC. INSTALLED REPAIR CHANNELS AT LBL & RBL 24.5.SDR SWAA081927Floorbeam · crackedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM WEB CRACKED AT BS 799, RBL 17. REMOVED AND REPLACED WEB PER SRM.SDR SWAA081929Floorbeam · corrodedDURING SCHEDULED BRDG CHECK, FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 947, LBL 5. REPAIRED CHORD PER SRM.SDR CALA0800319Floorbeam · corrodedCABIN FLOOR SUPPORT FOUND CORRODED AT BS 303 BETWEEN LBL 21 - 54, AFTER FLOOR PNL REMOVED. CABIN STA 303 BETWEEN LBL 17"- 68" FLOORBEAM REPAIRED AS PER SRM 53-00-51 FIG 201 REPAIR 1 AND HFEC NO CRACK FOUND.SDR USAA920080942Floorbeam · corrodedMCN - MAJOR REPAIR - C21 CHECK - CORROSION ON CABIN FLOORBEAM, BS 1000, RBL 13, WL 208. REPLACED CABIN FLOORBEAM, BS 1000, RBL 13, WL 208 IAW B737 SRM 51-40-02.SDR UIEA200800116Floorbeam · crackedMAIN DECK STATION 2020 RBL 21 FLOORBEAM SUPPORT FITTING FOUND CRACKED. REPLACED FLOORBEAM SUPPORT FITTING IAW SRM 51-10-01.
Back to JASC 5315