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 QXEA0003230Floorbeam · corrodedPDX- CORROSION AROUND NUT PLATE ON FLOORBEAM AT STATION 3450 AND BL1127RH TOP AND BOTTOM. REPAIRED IAW FOKKER SRM 51-10-4 PAGE 9.SDR RAIA0011042Floorbeam · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND CORROSION AT FLOOR BEAM 41. MAINTENANCE REMOVED CORROSION AND TREATED FLOOR BEAM 41 IAW ATR42 SRM.SDR RAIA0011032Floorbeam · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND CORROSION AT FLOOR BEAM 37. MAINTENANCE REPLACED FLOOR BEAM 37 IAW ATR42 SRM.SDR RAIA0011031Floorbeam · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION AT FLOOR BEAM 38. MAINTENANCE REPLACED FLOOR BEAM 38 IAW ATR42 SRM.SDR RAIA0011026Floorbeam · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND CORROSION AT TOP CAP OF FLOOR BEAM 39. MAINTENANCE REPLACED FLOORBEAM 39 IAW ATR42 SRM.SDR RAIA0011013Floorbeam · corrodedMX-STL-DURING MAINTENANCE CHECK FOUND CORROSION ON LEFT OUTBOARD WEB BETWEEN FLOOR BEAMS 39 AND 40. MAINTENANCE REPLACED WEB BETWEEN FLOOR BEAM 39 AND 40 IAW ATR42 SRM.SDR RAIA0011044Floorbeam · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION AT FLOORBEAM 40. MAINTENANCE REPLACED FLOORBEAM 40 IAW ATR42 SRM.SDR RAIA0011043Floorbeam · corrodedMX-STL- DURING MAINTENANCE CHECK FOUND CORROSION AT FLOORBEAM 10. MAINTENANCE REPAIRED FLOORBEAM 10 IAW ATR42 SRM.SDR 20001120SH045Floorbeam · damagedEXISTING CUT OUT IN THE AFT PT FLOORBEAM, UPPER CAP STA 1760, LBL 4.0 - RBL 6.0. REPAIRED PER ECRA 621-53-0004. (X)SDR 20001120SH044Floorbeam · misdrilledMAIN DECK FLOOR BEAM UPPER CHORD STA 900 MULTIPLE MISDRILLED HOLES. REPAIRED PER ECRA 621-53-005. (X)SDR ASAA0040134Floorbeam · corrodedPAE - DURING SI CHECK, FOUND FLOORBEAM UPPER CHORD AT BS 986, WL 208, LBL 65 - RBL 65 IS CORRODED AROUND NUTPLATE. REPAIRED IAW EA 5310-01885. (M)SDR USAA001972Floorbeam · crackedFLOORBEAM CRACKED. INSTALLED DOUBLER AND RADIUS BLOCKS INSTALLED PER EA68253SDR USAA001971Floorbeam · crackedFLOORBEAM CRACKED. DOUBLER INSTALLED PER EA68253SDR USAA001966Floorbeam · crackedFLOORBEAM CRACKED. STOP DRILLED CRACK, HFEC VERIFIED CRACK REMOVED, INSTALLED REPAIR DBLRS PER EA 68328SDR TWAA0018408Floorbeam · corrodedDURING CHECK-C MAINT, THE CABIN FLOOR AND GALLEY DRAIN PAN SUPPORT WAS CORRODED AT STA 160, RBL 53 INCHES. INSTALLED SUPPORT ANGLE PER SRM 51-30. REMADE FLOOR SUPPORT FROM RAW STOCK.SDR SWAA002392Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAMS CORRODED AT BS 947, RBL 53 TO LBL 53 & BS 1006, RBL 10. REPAIRED FLOORBEAMS PER SRM & T1-253-024.SDR AWXA0000893Floorbeam · crackedMAIN DECK FLOORBEAM CRACKED AT FS 380 LBL 61.5 WL 207. REMOVED BEAM AT STA 380 IAW SRM 51-40-02; DRILLED REPLACEMENT BEAM IAW 51-40-05; INSTALLED BEAM IAW 51-40-02 & DWG 65-46802 & SRM 53-30-51 (R815933).SDR AWXA0000887Floorbeam · misdrilledCABIN FLOORBEAM AT STA 420 LBL 57 HAS HI-LOK WITH NO EDGE DISTANCE. REMOVED FLOORBEAM, FAB FLOORBEAM FROM 7075T6 BAC1518-338 QQA2002/11 R815933, TREATED AND PRIMED TOP COAT AND INSTALLED IAW SRM 51-40-00 AND ENGINEERING RESPONSES DATED 11/7/00 SRM 53-30-51, SSDR SWAA002366Floorbeam · crackedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM UPPER CHORD CRACKED AT BS 294.5, RBL 53. REPAIRED FLOORBEAM PER SRM.SDR MWEA001180Floorbeam · corrodedFLOORBEAM AT STATION 980 HAS LIGHT CORROSION AROUND FASTENER HOLE LEFT HAND SIDE 15 INCHES INBOARD OF FRAME. FABRICATED AND INSTALLED ANGLE REPAIR.SDR MWEA001155Floorbeam · dentedFORWARD BAG PIT RIGHT HAND SIDE FLOOR BEAM STRUT AT STATION 465 IS DENTED. FABRICATED AND INSTALLED NEW STANCTION.SDR ABXA000506Floorbeam · crackedFLOORBEAM SUPPORT CRACKED AT FS 560. MAINTENANCE REPAIRED THE SUPPORT IAW DC-9 SRM DRAWING K05159.SDR ABXA000505Floorbeam · crackedFLOORBEAM SUPPORT CRACKED AT LOWER INBOARD FASTENER. MAINTENANCE REPAIRED IAW DC-9 SRM DRAWING K05159.SDR WXOA00012Floorbeam · crackedMHV - DURING AIRCRAFT SCHEDULED INSPECTION AT REPAIR STATION, FOUND CRACK IN CABIN FLOORBEAM AT FS 1080, LBL 45, STRINGER 18 FLOOR WEB. CRACK REPORTED APPROXIMATELY .75 INCH LONG. STOP DRILLED CRACK AND FABRICATED AND INSTALLED DOUBLER PER DC-9 SRM 53-01. (SDR SWAA002331Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED ON UPPER FLANGE AT BS 967, RBL 50 TO LBL 50. REPAIRED FLOORBEAM PER T1-453-037 AND T1-453-057.SDR SWAA002330Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND FLOORBEAM CORRODED AT BS 987, RBL 45 TO LBL 45. REPAIRED FLOORBEAM PER T1-253-024 AND T1-453-037.SDR DL73E002241Floorbeam · crackedTHE UPPER CAP OF THE BL 0.07 LONGITUDINAL FLOORBEAM WAS FOUND WITH CRACKS COMMON TO THE FLOOR PANEL ATTACH HOLES BETWEEN FS 660 & 664. THE CRACKS ARE TYPICAL OF BAC S/B 737-57-1210. THE CAP CRACKS WERE REPAIRED WITH ALUMINUM REPAIR ANGLES PER THE S/B AND PERSDR L1GA200000319Floorbeam · chafedA 22 INCH AREA OF CHAFING AT FS 579 BL 0 TO LBL 22 FLOORBEAM. FABRICATED AND INSTALLED WEAR STRIPS.SDR L1GA200000434Floorbeam · damagedFLOORBEAM UPPER FLANGE DOUBLE DRILLED AT FUS STA 160 RBL 50. REAMED OUT NUT PLATE HOLE TO NEXT SIZE.SDR L1GA200000509Floorbeam · chafedCHAFING STATION 405 BL 0 TO 22 LT. INSTALLED ANGLE REPAIR.SDR L1GA200000361Floorbeam · corrodedA 22 INCH AREA OF CHAFING ON FLOORBEAM. REMOVED CORROSION, TREATED AND PRIMED AND REPLACED RUB STRIPS.SDR L1GA200000343Floorbeam · chafedA 22 INCH CHAFED AREA AT FS 484 FLOORBEAM. INSTALLED FLOORBEAM REPAIR.SDR L1GA200000342Floorbeam · chafedCHAFED AREA ON FLOORBEAM FS 503. INSTALLED REPAIR ANGLE.SDR L1GA200000340Floorbeam · chafedCHAFED AND WORN FLOORBEAM STATION 541. BLENDED, TREATED AND PRIMED.SDR L1GA200000338Floorbeam · chafedCHAFING ON FLOOR BOARD SUPPORT STATION 460 BL 0 TO XL22 BEAM. BLENDED, TREATED AND PRIMED AREA.SDR L1GA200000442Floorbeam · corrodedFLOORBEAM CORRODED AT NUT PLATES. SPLICED IN NEW UPPER ANGLE.SDR L1GA200000441Floorbeam · chafedCHAFED FLOORBEAM STATION 408. BLENDED AND INSTALLED WEAR STRIP.SDR AALA20001900Floorbeam · misdrilledTUL - FOUND FLOORBEAM MISDRILLED AT GALLEY TRACK FASTENER HOLE STATION 360 RBL 43. INSTALLED REPAIR PER ESO 11697 DATED 11/13/00. (M)SDR AALA20001898Floorbeam · corrodedTUL - FOUND TOP FLANGE UPPER SURFACE FLOORBEAM 380 CORRODED RBL 11 INCHES TO RBL 63 INCHES. REMOVED CORROSION. INSTALLED DOUBLER REPAIRS PER SRM 53-10-8. (M)SDR SCNA00388Floorbeam · corrodedDURING HEAVY MAINTENANCE INSPECTION CORROSION WAS FOUND OUT OF LIMITS ON FLOORBEAM AT STA 1110 RBL 12. REMOVED CORROSION IAW B727 SRM 511006. REMOVED DAMAGED SECTION IAW B727 SRM 511001 AND 531008. FABRICATED FLOOR BEAM REPAIR FROM BAC 14902773 7075 AND 0.125 SDR COMA0060915Floorbeam · damagedMIDSRILLED HOLE ON LBL9 FS 409 + 10 I/B SIDE OF FLANGE ON BEAM CAP. REPAIRED MISDRILLED HOLE ON LBL9, FS 409+ 10 I/B SIDE IAW WVAC EO 601R-53-1905.SDR SWAA002321Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 344, LBL 24 TO LBL 64. REPAIRED FLOORBEAM PER SRM.SDR P2EA00405Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND THE PASSENGER CABIN FLOORBEAM UPPER FLANGE BS 312 RBL 8 TO LBL 14 WITH CORROSION OUT OF LIMITS, LENGTH 22 INCHES, WIDTH 2 INCHES, DEPTH .030 INCH. REPAIRED THE PASSENGER CABIN FLOORBEAM UPPER FLANGE BS 312 RBL 8 TO LBL 14 IAW BOEINSDR P2EA00381Floorbeam · corrodedSJO - DUIRNG Q-CHECK, FOUND THE PASSENGER CABIN FLOORBEAM UPPER FLANGE BS 312 RBL 8 TO LBL 14 WITH CORROSION OUT OF LIMITS. (M)SDR COMA0060900Angle · corrodedFWD J-ANGLE AT FS 280.00 BETWEEN LBL 9 AND RBL 9 IS CORRODED. REMOVED DAMAGED J-ANGLE AND INSTALLED NEW FWD J-ANGLE P/N 600-34017-351 I/A/W WVAC EO 601R-53-1890.SDR COMA0060899Floorbeam · crackedFLOOR MEMBER P/N 600-34017-17 AT FS 280.00 IS CRACKED .5 INCH LONG, LOCATED TO THE RIGHT OF FLOOR SUPPORT AT RBL 9. TRIMMED OUT DAMAGED AREA, LPI, FABRICATED REPAIR ANGLE, AND INSTALLED I/A/W WVAC EO 601R-53-1889.SDR SWAA002297Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND FLOORBEAM CORRODED AT BS 987, LBL 43. REPAIRED FLOORBEAM PER TI-453-037.SDR AALA20001899Floorbeam · corrodedTUL - FOUND CORROSION ON TOP FLANGE OF FLOORBEAM STATION 344 RBL 19. INSTALLED REPAIR ANGLE DOUBLER ON UPPER FLANGE OF FLOORBEAM 344, RBL 11 TO RBL 22 PER SRM 51-40-4. (M)SDR AALA20004078Floorbeam · corrodedAFW - FLOORBEAM AT STATION 1640 RBL 58 HAD CORROSION BLENDED BEYOND SRM LIMITS. INSTALLED REPAIR STRAP AS SHOWN IN ATTACHED FIGURE. FABRICATE REPAIR STRAP FROM 301 1/2H STAINLESS STEEL .050 THICK. ALODINE ALL BARE ALUMINUM SURFACES. FINISH BLENDS AND REPAISDR COMA0010377Buttstrap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 132-01Z THE FORWARD RH FLOOR SUPPORT BUTTSTRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED I/A/W EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.
Back to JASC 5315