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 USAA000504Floorbeam · corrodedCLT - FOUND BEAM T-CAP CORRODED 1 INCH BY 2 INCH, FLOORBEAM STATION BS 1681.8, 12 AREAS. REPLACED AFT GALLEY WEB PER SRM 53-60-51 AND 51-10-00. (M)SDR USAA000501Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED .5 INCH BY .5 INCH, BS 1660, LBL 37. INSTALLED REPAIR ANGLE PER TR 53-15-02. (M)SDR USAA000493Floorbeam · corrodedCLT - FOUND T-CAP OF FLOORBEAM CORRODED 2 INCHES BY 2 INCHES, BS 1042 AT LBL 9. REPAIRED PER SRM 53-50-12 FIG 101. (M)SDR USAA000490Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES, STATION 344 AT BL 0, LBL 22. CORROSION LEVEL 1. INSTALLED FLOORBEAM TOP CAP PER SRM 51-70-12. (M)SDR USAA000500Floorbeam · corrodedCLT - FOUND .5 INCH BY .5 INCH CORROSION, BS 1016, LBL 7 TO LBL 16. INSTALLED STRAP REPAIR PER EA 66920. (M)SDR USAA000499Floorbeam · corrodedCLT - FOUND 2 INCHES OF CORROSION ON FLOORBEAM, BS 312 AT BL 0, LBL 7 AND LBL 10. INSTALLED T-CAP REPAIR PER TR 53-10-13. CORROSION LEVEL 1. (M)SDR 0001602275Floorbeam · corrodedDURING H CHECK FOUND CORROSION ON FLOORBEAM UPPER CHORD. REPAIRED PER EA 22-175134.SDR SWAA000593Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND BS 986.5 UPPER SURFACE OF FLOORBEAM CORRODED, LBL 10 TO LBL 44. REPAIRED FLOORBEAM PER ER 00-245P2 AND SRM.SDR 00FDEA00192Floorbeam · corrodedCORROSION ON FLOORBEAM AT BS 1030, RBL 15, WL 208 (C53-224-01).SDR USAA000483Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCHES BY 24 INCHES, STATION 345, BL 0 TO LBL 24. INSTALLED REPAIR T-CAP AND ANGLE PER TR 53-15-01. (M)SDR USAA000489Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 1 INCH BY 1 INCH, STATION 1681.8, REPLACED FLOORBEAM PER SRM 53-60-61 AND 51-40-00. (M)SDR USAA000481Floorbeam · corrodedCLT - FOUND FLOORBEAM CORRODED 2 INCH BY 63 INCHES, STATION 345, BL 0 TO R 1 SILL. REPLACED T-CAP PER TR 53-15-01. (M)SDR USAA000480Floorbeam · crackedCLT - FOUND TWO CRACKS IN FLOORBEAM, STATION 706, BL 0 LOWER CHORD FLOORBEAM WEB. REPAIRED FILLER AND DOUBLER PER TR 57-10-05. (M)SDR AT0000204Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND CABIN FLOORBEAM AT BS 160 RBL 6 AND RBL 44 CORRODED BEYOND LIMITS. REPLACED FLOOR SUPPORT IAW DC9 SRM 51-30-02, 51-10-03, 51-30-05, 51-10-02, AND 53-11-01.SDR AT0000164Floor Support · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND CABIN FLOOR SUPPORT CORRODED BEYOND LIMITS AT BS 176 - 185, LBL 44. CORRECTIVE ACTION: REMOVED, FABRICATED, AND INSTALLED NEW FLOOR SUPPORT IAW DC9 SRM 51-30-02, 51-10-02, 51-10-03, SDR AT0000162Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND CABIN FLOOR SUPPORT CORRODED AT BS 200, RBL 1 - 57. CORRECTIVE ACTION: REMOVED AND FABRICATED NEW FLOOR SUPPORT IAW DC9 SRM 53-11-01, 51-30-05, 51-30-02, 51-10-04, AND 51-10-03.SDR AALA20004010Floorbeam · corrodedAFW - FLOORBEAM AT STATION 1480 HAD CORROSION BLENDED BEYOND SRM LIMITS. REMOVED CORROSION PER REF /D/. VERIFY CRACK FREE. APPLY ALODINE AND TWO COATS PRIMER TO BLENDED AREAS. FILL BLENDED AREAS WITH BMS5-95. RETURN TO SERVICE WITH NOTED CONDITION. (M)SDR AALA20004009Floorbeam · corrodedAFW - FLOORBEAM AT RBL 11, STATION 798 HAD CORROSION BLENDED ON TOP SURFACE BEYOND SRM LIMITS. REMOVE CORROSION PER REF /D/ AND ENSURE CORROSION HAS BEEN COMPLETELY REMOVED. ROTO PEEN, APPLY ALODINE AND 2 COATS PRIMER TO BLEND AREA. FILL BLENDED AREA WITH BSDR AALA20004008Floorbeam · corrodedAFW - FLOORBEAM AT STATION 764 HAD CORROSION BLENDED UNDER SPLICE PLATE BEYOND LIMITS. REMOVE CORROSION PER REF /D/. ENSURE CORROSION HAS BEEN COMPLETELY REMOVED. APPLIED ALODINE AND TWO COATS OF PRIMER TO ALL BARE SURFACES. FILL BLENDED AREA WITH BMS5-95 SDR AALA20004007Floorbeam · corrodedFLOORBEAM AT STATION 764 HAD TWO AREAS OF CORROSION BLENDED BEYOND SRM LIMITS. REMOVED CORROSION PER REF D. VERIFY BLENDED AREA IS CRACK FREE. APPLIED ALODINE, TWO COATS OF PRIMER TO BLENDED AREA. FILL BLENDS WITH BMS5-95. RBL 33 FABRICATE REPAIR STRAP OUSDR AALA20004006Floorbeam · corrodedAFW - FLOORBEAM AT LBL 33, STATION 791 HAD CORROSION BLENDED BEYOND SRM LIMITS. REMOVE CORROSION PER REF /D/. VERIFY CRACK FREE ROTOPEEN, APPLY ALODINE AND TWO COATS PRIMER TO BLENDED AREA. FILL BLENDED AREA WITH BMS5-95. RETURN TO SERVICE WITH NOTED CONDISDR AALA20004005Floorbeam · corrodedFLOORBEAM AT STATION 347 HAS CORROSION REMOVAL ON UPPER SURFACE BEYOND SRM LIMITS. REMOVED CORROSION PER REF D, VERIFY CRACK FREE. APPLY ALODINE AND TWO COATS PRIMER TO BLENDED AREA. FILL BLEND WITH BK155-95. RETURN TO SERVICE WITH NOTED CONDITION. (M)SDR AALA2000384Floorbeam · corrodedTUL - FLOORBEAM UPPER CHORD CORRODED AT STATION 344, LBL 28 TO RBL 10. SPLICED IN NEW T-CAP PER SRM 53-10-8. (M)SDR AALA2000378Floorbeam · misdrilledTUL - PARTIALLY DRILLED HOLE IN UPPER FLANGE OF FLOORBEAM STATION 480 RBL 45. REMOVED DAMAGE IN UPPER FLANGE OF FLOORBEAM AND REPAIRED PER ESO 11697, DATED 1/19/00. (M)SDR AALA20000582Floorbeam · damagedTUL - FOUND ELONGATED HOLE GOING THROUGH FLOORBEAM. INSTALLED DOUBLER PER SRM 53-05 PART 1 PAGE 31 AND 51-60-00-05. (M)SDR UPS00232189Floorbeam · corrodedINSPECTION TYPE: C, CORROSION ON FWD SIDE OF FLOORBEAM AT CARGO DOOR LATCH FITTING 5.0 I/B FROM NR 3 LATCH AT BS 580, WL 207. REMOVED CORROSION ON FWD SIDE OF FLOORBEAM UPPER FLANGE, LOWER SURFACE PER SRM 51-10-6. REMOVED .029X1.0X2.5 FROM ORIGINAL THICKSDR 00FDEA00177Floorbeam · corrodedCORROSION AT FASTENER HOLES ON UPPPER CHORD OF FLOORBEAM BS 1050, RBL 35, WL 208 (C53-224-01). *S/D* REMOVED AND REPLACED PER IAW FEDEX SRM 53-10-8 FIG 8.SDR AWXA0000181Floorbeam · corrodedC-CHECK, CORROSION LEVEL 2, FLOORBEAM CORRODED OUT OF LIMITS AT FS 967 LBL 42. CLEANED DAMAGED AREA, FABRICATED REPAIR STRAP AND FILLER IAW 737 SRM 53-00-51 FROM (7075T6 QQA 250 /13, FILLER .80 7075 T6 QQA 250/13), TREATED IAW 737 SRM 51-20-1, INSTALLED PARTSDR AWXA0000180Floorbeam · corrodedC-CHECK, CORROSION LEVEL 2, TOP OF FLOORBEAM AT FS 986.5 LBL 16 TO RBL 44 CORRODED OUT OF LIMITS. REMOVED EXISTING REPAIR IAW 737 SRM 53-60-51, FABRICATED PARTS IAW 737 SRM 53-00-51 FROM (T-CAP 7075T6 R699452 .063, STRAP BAC 1490 7075 T6R690227 .064, ANGLE 7SDR AWXA0000179Floorbeam · corrodedC-CHECK, CORROSION LEVEL 2, CABIN FLOORBEAM AT FS 967 LBL 5 CORRODED OUT OF LIMITS. REMOVED AND INSTALLED STRAP IAW B737 SRM 51-40-02, FABRICATED REPAIR STRAP FROM (7075 T6 .125 QQA 250/13 R 713961) IAW B737 SRM 53-00-51 FIG 203. TREATED AND PRIMED PART IAW SDR AWXA0000178Floorbeam · corrodedC-CHECK, TOP OF FLOORBEAM CORRODED AT FS 1016 RBL 16. CUT OUT TOP FLANGE OF BEAM IAW 737 SRM 53-00-51, FABRICATED REPAIR PARTS IAW 737 SRM 51-20-01, INSTALLED PARTS IAW 737 SRM 51-30-2, MATERIAL USED (ANGLE BAC 1505-100617, BAC 1490-2734, STRAP 7075 T6 .071, SDR AWXA0000176Floorbeam · corrodedC-CHECK, CORROSION LEVEL 1, CABIN FLOORBEAM BS 344 LBL 10 AND 19 CLIP NUT HOLES CORRODED BEYOND LIMITS. REMOVED DAMAGED BEAM IAW B737 SRM 53-10-51 FIG 205, FABRICATED REPAIR PARTS FROM (BAC 1505-100 246 R719469 - BAC 1490- 2734 R 67366) IAW 737 SRM 53-10-51 FSDR AT0000168Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND CABIN FLOOR SUPPORT CORRODED BEYOND LIMITS AT BS 161 - 197, RBL 44. CORRECTIVE ACTION: REMOVED, FABRICATED, AND INSTALLED NEW FLOOR SUPPORT IAW DC9 SRM 51-30-02, 51-10-30, AND 5SDR AALA20000579Floorbeam · crackedTUL - FOUND FLOORBEAM CRACKED ON FORWARD SIDE AT RIGHT OUTBOARD END AT STATION 927 FRAME ATTACHMENT. REMOVED AND REPLACED FLOORBEAM STATION 927 PER SRM 51-01. (M)SDR AT0000167Floorbeam · corrodedDURING A SCHEDULED INSPECTION AT TIMCO IN LAKE CITY FL, FOUND CABIN FLOOR SUPPORT CORRODED BEYOND LIMITS AT BS 196, LBL 1-38. CORRECTIVE ACTION: REMOVED, FABRICATED, AND INSTALLED NEW FLOOR SUPPORT IAW DC9 SRM 51-30-02, 51-10-02, 51-10-03, AND 51-30-SDR USAA000456Floorbeam · corrodedFOUND FLOORBEAM CORRODED 1.5 INCH BY 2 INCHES, BS 312, LBL 20, RBL 20. INSTALLED UPPER T-CAP PER SRM 53-10-51 FIG 205. (M)SDR ASAA0080210Floorbeam · damagedPHX - DURING 30K CHECK, TEH LEFT AFT LAVATORY TOP SURFACE OF THE FLOORBEAM WAS FOUND WITH AN ELONGATED HOLE AND CORRODED AROUND THE NUTPLATE. REMOVED CORROSION AND REPAIRED PER EA 5310-01805. (M)SDR C2XA00IA084Floorbeam · corrodedDURING CONTINENTAL EXPRESS AIRLINES C-CHECK, FOUND CORROSION ON FLOORBEAM AT FRAME 39. REMOVED CORROSION, FABRICATED AND INSTALLED REPAIR DOUBLERS IAW CONTINENTAL EXPRESS EC5310-01037 AND SRM 51-25-02. AIRCRAFT APPROVED FOR RETURN TO SERVICE. (M)SDR USAA000458Floorbeam · corrodedCLT - FOUND FLOORBEAM 20 INCH BY 2 INCH, STATION 324, FROM RBL 45 TO R1 SILL. REPAIRED PER EA 66865 AND EA 66826. CORROSION LEVEL 1. (M)SDR AWXA0000172Floorbeam · corrodedC-CHECK, CORROSION LEVEL 1 ON TOP CHORD OF STA 1681 FLOORBEAM LBL 55 RBL 55 WL 208. REPAIRED BS 1681 FLOORBEAM IAW ER 19-5365-00046-JS2A.SDR AWXA0000170Floorbeam · corrodedC-CHECK, FLOORBEAM AT BS 740 LBL 55, LBL 58 WL 208 CORRODED. REMOVED DAMAGED SECTION OF FLOORBEAM, FABRICATED REPAIR PART, ALODINED, PRIMED, PAINTED, INSTALLED PARTS IAW B757 SRM 53-00-51 FIG 203.SDR USAA000442Floorbeam · corrodedCLT - FOUND FLOORBEAM 2 INCH BY 63 INCH, BS 365 BL 0 TO R1 DOOR SILL. REPAIRED DOUBLER T-CAP PER TR 53-15-01. CORROSION LEVEL 1. (M)SDR USAA000443Floorbeam · corrodedCLT - FOUND FLOORBEAM 3 INCH BY 14 INCH, STATION 377.7, BL 0 TO RBL 15. REPAIRED DOUBLER AND T-CAP PER TR 53-15-01. CORROSION LEVEL 1. (M)SDR AWXA0000162Floorbeam · corrodedC-CHECK, AFT CABIN SUPPORT BEAM Y765 RT CORRODED AT FS 68. CORROSION REMOVED IAW A320 SRM 51-74-00, FLOOR SUPPORT BEAM Y 765 RT REPAIRED IAW ER 26-5341-00045-JL1.SDR QXEA0000819Floorbeam · crackedPDX- THERE IS A CRACK IN THE ANGLE THAT ATTACHES THE FLOOR SUPPORT BEAM TO THE REAR PRESSURE BULKHEAD AT BL330R. REPAIRED IAW FOKKER SRM 51-31-01 AND 51-30-02.SDR USAA000438Floorbeam · corrodedCLT - FOUND T-CAP BEAM CORRODED 2.25 INCH, STATION 986.5 TOP OF FLOORBEAM. REPLACED T-CAP AND INSTALLED DOUBLER PER TR 53-10-05 AND SRM 53-10-02. (M)SDR EISA2000035Floorbeam · corrodedDUIRNG ACCOMPLISHMENT OF A ROUTINE C-CHECK WORK CARD, FOUND CORROSION ON FLOORBEAM AT FUSELAGE STATION 312 LBL 54 BOTTOM OF UPPER T-CAP. TRIMMED DAMAGED AREA PER SRM 53-10-8. FABRICATED AND INSTALLED REPAIR PER SRM 53-10-8. (M)SDR CALA0000327Floorbeam · corrodedINSPECTION FOUND FLOORBOARD SUPPORT BEAM CORRODED AT STA 420, X=28L. A SPLICE REPAIR WAS INSTALLED IAW SRM 53-70-00, FIGURE 13.SDR AWXA0000154Floorbeam · corrodedC-CHECK, CORROSION LEVEL 2 ALL ALONG FLOORBEAM AT STA 1640 RBL 17 LBL 20. REMOVED AND REPLACED FLOORBEAM IAW ER 19-5310-00018 RC1.SDR TWAA0004904Floorbeam · corrodedDURING CHECK-C MAINT, THE FLOOR SUPPORT AT STA 160 TO 200, RBL 45 HAD CORROSION. REMOVED AND REPLACED FLOOR SUPPORT PER SPM 6-70-01.
Back to JASC 5315