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 USAA051368Floorbeam · corrodedFOUND CORROSION LT FLOORBEAM (Y254) BETWEEN FS 20-23; CORROSION LEVEL 1; TASK JA-220-53500. REMOVED AND REPLACED DEFECTIVE PART PER SRM 51-72-11, DEFECT SIZE: 1 SQ IN.SDR AWXA200501455Floorbeam · corrodedSAL - DURING BC4 CHECK DISCOVERED CORROSION SPREAD OUT ON FLOORBEAM BETWEEN FS 16 AND FS 20, Y-1292. MAINTENANCE FOUND CORROSION TO BE OUT OF LIMITS IAW AIRBUS 320 SRM 53-11-14. REMOVED AND INSTALLED FLOORBEAM IAW AIRBUS SRM 51-42-11 FROM FS 12 TO FS 24 AND SDR CALA0500404Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 1640, RBL 57. THE CORROSION WAS BLENDED OUT AND REPAIRED IAW ECRA 5321-01316.SDR AWXA200501417Floorbeam · corrodedGYR - DURING C10 CHECK DISCOVERED CORROSION LOCATED ON FLOORBEAM TEE CAP AT BS 365, FROM BL 35.5R TO BL 45.0R. REMOVED CORROSION AND FOUND TO BE OUT OF LIMITS IAW BOEING 757-200 SRM 53-00-51-1A. MAINTENANCE REMOVED UPPER T CAP IAW BOEING 757-200 SRM 51-40-02SDR ABXA050308Floorbeam · corrodedMAIN CABIN, STA 798, BUTT LINE 0 - RT BUTT LINE 48, FLOORBEAM CORRODED. REMOVED NUT PLATES, CLEANED CORROSION ON FLOORBEAM AT STA 798, BUTT LINE 0 - RT BUTT LINE 48, BLENDED AREA, OUT OF LIMITS AT .088 INCH MATERIAL REMAINING FROM ORIGINAL THICKNESS OF .186 ISDR SWAA053592Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND COCKPIT FLOOR Z-CHORD CORRODED AT BS 270, BETWEEN LBL 6 TO RBL 11. REMOVED AND REPLACED Z-CHORD PER SRM.SDR CALA0500399Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 7 TO LBL 26. THE CORRODED SECTIONS WERE TRIMMED OUT AND FILLER AND REPAIR DOUBLERS WERE INSTALLED IAW SRM 53-60-51, FIGURE 201.SDR ASAA0540640Floorbeam · crackedPAE - PREVIOUS REPAIR CRACKED AT FRAME. REMOVED AND REPLACED REPAIR ANGLES IAW EA. (K)SDR ASAA0540636Frame · gougedPAE-MECHANICAL DAMAGE TO FLOOR BEAM AT BSTA 312, LBL 11-54, WL 208. REMOVED AND REPLACED FLOOR BEAM UPPER CHORD AT BSTA 312, WL 208 IAW SRM. (K)SDR 05FDEA03751Floorbeam · crackedAVIONICS COMPT FLOORBEAM FS 10 RBL 40 ANGLE IS CRACKED.SDR ASAA0540645Floorbeam · corrodedYXX - FLOORBEAM AT BSTA 344, BL 0, TO LBL 65 CORRODED AT ANCHOR NUT HOLES. REPAIRED IAW SRM. (K)SDR ASAA0540644Floorbeam · corrodedYXX - CORROSION ON TOP SURFACE OF FLOORBEAM AT BSTA 294.5, LBL 12 TO RBL 12. FLOOR BEAM UPPER CHORD REPAIRED BY SPLICE IAW SRM. (K)SDR LR7A05193Floorbeam · corrodedDURING C-7 CHECK PER HC5313, FOUND RT CHINE CAP CORRODED BEYOND LIMITS, FS 617. REPLACED CHINE CAP IAW SMP 581 91-00-04, NR 0674.SDR LR7A05192Floorbeam · crackedDURING C-7 CHECK PER SB 382-57-85, FOUND BEAM CRACKED 2ND HOLE FROM TOP INBOARD, 2 EA, 3/4 INCH RUNNING UPWARD AND FORWARD AND 7/8 INCH RUNNING DOWN AND AFT TO EDGE OF BEAM, FS588, WL250, RBL62. REPAIRED BEAM IAW DRG R05-028-08, MEA 382-53-05-100, NR 0669.SDR LR7A05191Floorbeam · corrodedDURING C-7 CHECK PER HC5312, FOUND 2 INCH SQUARE AREA OF BEAM CAP CORRODED FS228, WL146, RBL11. REPLACED UPPER T CAP IAW DRG 337665 AND 362653, NR 0628.SDR LR7A05185Floorbeam · corrodedDURING C-7 CHECK PER HC5312, FOUND FWD FUSELAGE LT FLOOR SUPPORT ANGLE EXFOLIATED AT IB END, FS 196, WL146. REPLACED BEAM CAP ANGLE IAW DRG SMP 583 51-70 AND AC43.13-1B 4-57, NR 0545.SDR USAA051354Floorbeam · corrodedFOUND STA 344, LBL42-RBL31; AROUND CLIP NUT HOLES IN FLOOR BEAM CORRODED. REMOVED CORRODED OUT OF LIMITS SECTION OF "T" CAP FROM LBL31 TO RBL31 IAW SRM 53-10-51, FIG 201, DEFECT SIZE: 1" BY 1".SDR USAA051356Floorbeam · crackedFOUND BS28/LBL27 CRACKED. FABRICATED AND INSTALLED STIFFENER IAW SRM 51-10-02, DEFECT SIZE: 1".SDR USAA051359Floorbeam · corrodedFOUND STA 344, LBL 42-RBL3, AROUND CLIP NUT HOLES IN FLOORBEAM. REMOVED AND REPLACED T-CAP FROM LBL 1 TO RBL 32 IAW SRM 53-10-51, FIG 201, DEFECT SIZE: 1" BY 1".SDR USAA051358Floorbeam · corrodedFOUND CORROSION BS 328 AT RBL 15 AND 12. FABRICATED SPLICE ANGLES AND INSTALLED SPLICE ANGLES AND "T" CAP IAW SRM 53-10-51, DEFECT SIZE: 7" BY.65".SDR CALA0500394Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, RBL 24 TO RBL 38. THE FLOORBEAM WAS REPAIRED IAW ECRA 5321-01312.SDR 05FDEA03731Floorbeam · damagedRT SIDE ROLLER TRAY 1 OB OF CENTER AT FS 38 OB LEG HAS 1 EA DOUBLE DRILLED HOLE REF N00468. REPAIRED FLOORBEAM IAW SRM 53-10-15 FIG 207 AND REPLACED ROLLER TRAY IAW SRM 51-75-10.SDR ASAA0540631Floorbeam · corrodedPAE - FOUND FLOORBEAM CORRODED. REMOVED, FABRICATED AND INSTALLED FLOORBEAM IAW B737-400 SRM 53-10-51 REPAIR 5. (M)SDR SWIA200516281Floorbeam · crackedFS 280 RT FLOORBEAM RBL 9.0 I/B AND O/B ATTACH ANGLES CRACKED, ITEM FOUND AT C CHECK INSPECTION. REPLACED ANGLES AT FS 280, RBL 9 I/B AND O/B IAW CRJ SRM 51-42-06, 51-23-00, 51-40-11 AND 51-42-21.SDR SWIA200516278Floorbeam · crackedFS 280 LT FLOORBEAM LBL 9.0 I/B AND O/B ATTACH ANGLES CRACKED, ITEM FOUND AT C CHECK INSPECTION. ANGLES AT FS 280, LBL 9 I/B AND O/B REPLACED IAW CRJ SRM 51-42-06, 51-23-00, 51-40-11 AND 51-42-21.SDR SWIA200516277Floorbeam · crackedMAIN FUSELAGE; FS 280, LBL 9.0, UPPER FLANGE CRACKED ON TRANSVERSE BEAM, ITEM FOUND AT C CHECK INSPECTION. REPAIRED IAW CRJ REO 601R-53-11-138 REV NC.SDR AMTA200501048Floorbeam · corrodedFLOORBEAM STA, 1640, LBL 57 TO RBL 57 CORROSION AROUND CLIP NUT HOLES. REMOVED CORROSION FROM FLOORBEAM STA 1640 AND FOUND AREA WITHIN LIMITS EXCEPT FOR 1 SPOT AT RBL 57 AROUND FASTENER HOLE. TREATED AND PRIMED REPAIR STRAP AREAS AND INSTALLED STRAP IAW REO.SDR AWXA200501440Floorbeam · corrodedSAL - DURING BC4 CHECK DISCOVERED EXFOLIATION CORROSION ON FLOORBEAM AT FS 66+7 AND Y1292. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14. MAINTENANCE REMOVED BEAM FROM FS 66 TO FS 68 IAW AIRBUS 319 SRM 51-42-11. RECEIVED NEW BEAM SECTISDR AWXA200501437Floorbeam · corrodedDURING BC4 CHECK DISCOVERED EXFOLIATION CORROSION ON FLOORBEAM AT FS 66-3 AND -Y765. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14. MAINTENANCE REMOVED BEAM FROM FS 64 TO FS 66 IAW AIRBUS 319 SRM 51-42-11. RECEIVED NEW BEAM SECTION ANDSDR AWXA200501436Floorbeam · corrodedSAL - DURING BC4 CHECK DISCOVERED EXFOLIATION CORROSION ON FLOORBEAM AT FS 67+18 AND Y1292. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14. MX REMOVED BEAM FROM FS 67+18 TO FS 69 IAW AIRBUS 319 SRM 51-42-11. RECEIVED NEW BEAM SECTION ANSDR AWXA200501435Floorbeam · corrodedSAL - DURING BC4 CHECK DISCOVERED EXFOLIATION CORROSION ON FLOORBEAM AT FR 66+3 AND Y1292. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14. MAINTENANCE REMOVED FLOORBEAM FROM FS 64 TO FS 66 IAW AIRBUS 319 SRM 51-42-11. RECEIVED NEW BEAM SDR AWXA200501433Floorbeam · corrodedSAL - DURING BC4 CHECK DISCOVERED EXFOLIATION CORROSION ON FLOORBEAM ON FS 60 AND -Y1292, AFT GALLEY AREA. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-10. MAINTENANCE REMOVED BEAM FROM FS 68 TO FS 69, -Y1292 IAW AIRBUS 319 SRM 51-42-11. SDR AWXA200501397Floorbeam · corrodedSAL - DURING BC4 CHECK DISCOVERED CORROSION ON FLOOR STRUCTURE AT FR 67+17" AND BL -Y1292. CORROSION WAS REMOVED AND FOUND TO BE OUT OF LIMITS IAW AIRBUS 319 SRM 53-00-14 FIG 102. MAINTENANCE REMOVED AND INSTALLED NEW FLOORBEAM AT FR 67+17" AND BL -Y1292 IAWSDR UPS05545741Floorbeam · corrodedFOUND UPPER LOBE FLOORBEAM UPPER CHORD CORROSION, 2 NUTPLATE HOLES STA 1101 LBL33.5 AND LBL40.5. REPAIRED PER EO 05-4661.SDR 05FDEA03719Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM STA 344,BL0-LBL30. REMOVED, FABRICATED, ALODINED. PRIMED AND PAINTED FLOORBEAM REPAIR AT STA 344 AT BL0-LBL30 ALL IAW FX SRZ 27-53007 AND B727 SRM'S 51-30-2,53-10-2 FIG 7 AND 51-20-151.SDR CALA0500389Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 967, RBL 0 TO RBL 51. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51.SDR 05FDEA03693Floorbeam · damagedEXISTING UPPER FLOOR BEAM REPAIR AT BS 1030 LBL 10 WL 208, REPAIR REQUIRED EVALUATION FOR MAJ OR/MINOR DETERMINATION AND IF REPAIR WAS ACCOMPLISHED USIING FAA APPROVED DATA. EVALUATED EXISTING REPAIR TO BS 1030 UPPER FLOORBEAM LBL 10 WL 208, TO BE A MAJORSDR 05FDEA03687Repair · unknownCENTER CARGO COMPT FLOORBEAM SPLICE REPAIR AT STA 1701 RBL 36. PERFORMED A GVI OF EXISTING SPLICE IAW EO8-5100-7-5001 CRITERIA FOUND SPLICE DOUBLER IN COMPLIANCE WITH SRM 53-60-01 PAGE 7.SDR 05FDEA03683Doubler · unknownCENTER CARGO COMPT, FLOOR SUPPORT BEAM FOUND A SPLICE DOUBLE REPAIR AT FUSELAGE STA 1701 BETWEEN X24 AND X48. PERFORMED A GVI OF EXISTING SPLICE IAW EO8-5100-7-5001 CRITERIA, FOUND SPLICE DOUBLER IN COMPLIANCE WITH SRM 53-60-01 PAGE 7.SDR 05FDEA03680Doubler · unknownAFT CARGO COMPT BILGE AREA, FLOOR SUPPORT BEAM FOUND A SPLICE DOUBLER REPAIR LBL 36 STA 1841. PERFORMED A GVI OF EXISTING SPLICE IAW EO8-5100-7-5001 CRITERIA, FOUND SPLICE DOUBLER REPAIR IN COMPLIANCE WITH SRM 53-60-01 PAGE 7.SDR USAA051342Floorbeam · corrodedBS 312, WL 208, LBL 16 TO RBL 16 LEVEL 1 CORROSION. SPLICED IN REPLACEMENT EXTRUSION IAW SRM 53-10-51 FIG 201. DEFECT SIZE: .50 X .50 INCH.SDR USAA051348Floorbeam · corrodedFLOORBEAM Y1292 FR 64-68 CLIP NUT HOLES; CORROSION LEVEL 1; TASK JA-260-53500. REPLACED FLOORBEAM WITH NEW IDENTICAL PARTS PER DWG D53472780. DEFECT SIZE: .5 X .5 INCH AREA EACH HOLE.SDR CALA0500387Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 947, RBL 4 TO LBL 15. THE CORRODED AREAS WERE TRIMMED OUT AND FILLERS AND DOUBLERS WERE INSTALLED IAW SRM 53-60-51, FIGURE 201.SDR SWAA053527Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 773, RBL 8. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053526Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 773, RBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053525Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 773, LBL 12. REPAIRED FLOORBEAM PER SWA EA.SDR SWAA053524Floorbeam · corrodedDURING SCHEDULED 5Y CHECK, FOUND LONGITUDINAL FLOORBEAM CORRODED AT BS 773, LBL 3. REPAIRED FLOORBEAM PER SWA EA.SDR SWIA200516156Floorbeam · crackedAFT FLOOR ANGLE CRACKED FS 280 LBL 11, ITEM FOUND AT C-CHECK INSPECTION. REPAIRED ANGLE PER REO 601R-53-11-138 AND SRM CRJ200 51-31-06 PG 1 PARA 3 PG 3.SDR ASAA0540611Floorbeam · corrodedYXX - FOUND CORROSION ON FLOORBEAM AT BS 312, LBL 12-50. DAMAGED SECTION OF FLOORBEAM REPLACED PER B737-400 SRM 53-10-51 FIG 201. (M)SDR AWXA200501561Floorbeam · corrodedMCN - MAJOR REPAIR - DURING C19 CHECK DISCOVERED LEVEL 2 GALVANIC CORROSION ON THE TRANSVERSE BEAM AT BS 986, FROM BL 44R TO BL 44L AND WL 208. CORROSION WAS FOUND TO BE OUT OF LIMITS IAW BOEING 737-300 SRM 53-60-51-1A1. MAINTENANCE CUT OUT DAMAGED AREA FROM
Back to JASC 5315