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 USAA2010072691493Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - BEAM Y254 HAS SIGNS OF CORROSION FROM FRAME 66 TO 68. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, Y254 IAW AIRBUS DRAWING D53472780.SDR USAA2010072691492Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - FLOORBEAM Y1292 HAS SIGNS OF CORROSION AT FRAME 66. REPLACED FLOORBEAM AT FR66, Y1292 IAW A320 SRM 51-72-11.SDR USAA2010072691491Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - FLOORBEAM Y1292 HAS SIGNS OF CORROSION FROM FR68 TO FR69. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, Y1292 IAW A320 SRM 51-72-11.SDR V0XR20100726004Floorbeam · corrodedDIGITAL PLATE AT FRAME 15, LY780.0 TO RY780.0 CORRODED OUT OF LIMITS. REPLACED DIGITAL PLATE AT FRAME 15 FROM LY780.0 TO RY 780.0 IAW SRM 21-20-02, 51-10-02, 51-40-02, 51-40-09, AND 51-20-03. W/C 1065.SDR ASAA1048219Floorbeam · corrodedFLOORBEAM AT STATION 986 HAS CORROSION AT FIRST FASTENER HOLE NEXT TO L2 DOOR SILL. REPAIRED FLOORBEAM.SDR K11A2010072472201Floorbeam · corrodedFLOORBEAM UPPER CHORD CORROSION 10 INCHES.SDR FDEA201007242761Floorbeam · corrodedFLOORBEAM CORRODED STA 440 LBL 45 TO 62.5 CUT OUT DAMAGED AREA DIMS 2.15" X .90". FABRICATED TWO ANGLES USING 7075-O .090 DIMS 14.5" X 2.5" AND 11.3" X 2.4" HEAT TREATED PARTS FROM 7075-O TO 7075T-6 CONDITION IAW FASI ENG REPORT 2-37153-801 REV A, FABRICATSDR FDEA201007242759Floorbeam · corrodedFLOORBEAM CORRODED STA 720A RBL 45 TO 62.5 CORROSION OUT OF LIMITS. CUT OUT DAMAGED AREA DIMS 5" X .9". FABRICATED REPAIR USING BAC1505-100617 DIMS 21.3", FABRICATED SUPPORT ANGLE USING BAC1490-2685 DIMS 16.75" X 2.5" AND BAC1490-2785 DIMS 21.3" X 2.7", FABRICSDR USAA2010072691500Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - CORROSION ON FLOORBEAM AT FORWARD SIDE OF RT SILL STRUCTURE AT -Y1732 FRAME 66. REPLACED FLOORBEAM AT FORWARD SIDE OF RIGHT SILL STRUCTURE AT -Y1732 FRAME 66 IAW AIRBUS DRAWING D5347250.SDR USAA2010072691499Floorbeam · corrodedCLT - DROP-IN - MAJOR REPAIR - FLOORBEAM -Y254 HAS SIGNS OF CORROSION AT FRAME 70. REPLACED FLOORBEAM BETWEEN FR68 TO FR70, -Y254 IAW AIRBUS DRAWING D5347200.SDR AALA20100723TUL09Floorbeam · crackedSTATION 700 BEAM UPPER T-CAP CRACKED. STATION 700 FLOORBEAM CRACK REPAIR PER SRM 53-00-51-2R REPAIR 3.SDR IPXA10562223Floorbeam · damagedINSPECTION TYPE:C2, FLOORBEAM AFT FLANGE BS 560 HAS DAMGED HOLES LBL 5-14. REPAIRED IAW ER 10-3797.SDR IPXA10561542Floorbeam · corrodedINSPECTION TYPE:C2, FLOORBEAM UPPER CHORD HAS CORROSION BS 297, LBL 11, WL 208. REMOVED, FABRICATED AND INSTALLED IAW SRM51-40-02, AND SRM 53-10-51-0I 1.SDR ASOA201001032Floorbeam · corrodedFLOORBEAM CAP AT LBL 27 FROM FS 574.00-621.00 IS CORRODED. REMOVED FLOORBEAM CAP IAW SRM 51-42-06 AND 51-42-21. LOCATED FASTENER HOLES IAW SRM 51-40-11. INSTALLED NEW SERVICEABLE FLOORBEAM UPPER CAP IAW REO 601R-53-61-3744. EC/TC COMPLIANCE STATEMENT RESDR USAA2010080291559Strap · crackedCLT - Q5 - MAJOR REPAIR - CRACK IN FLOORBEAM STABILIZER STRAP AT BS 328, LBL 45, WL 201. REPLACED FLOORBEAM STABILIZER STRAP AT BS 328, LBL 45, WL 201 IAW B737 SRM 51-10-02.SDR FDEA201007232651Floorbeam · corrodedSTA 680 FLOORBEAM, RBL 45 TO RBL 60 UPPER FLANGE CORRODED. REMOVED CORROSION, OUT OF LIMITS IAW SRM 53-00-51, P.103, FIG.101, NEW FLOORBEAM FABRICATED IAW DWG 143N5013. INSTALLED NEW FLOORBEAM. MAJOR REPAIR .SDR USAA2010072891515Floorbeam · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FLOORBEAM UPPER CHORD AT BS 663, RBL 24.8. REPAIRED FLOORBEAM UPPER CHORD AT BS 663, RBL 24.8 IAW EA 102032.SDR AALA20100722TUL07Floorbeam · corrodedCORROSION ON FLOORBEAM STATIONS 1640 TO 1658. REPAIRED PER IAW SRM 53-00-51-2R 3.SDR IPXA10562027Floorbeam · corrodedINSPECTION TYPE:C2, FUSELAGE UPPER LOBE FLOORBEAM HAS CORROSION AROUND NUT PLATED HOLES STA 1380, RBL52, WL208. FLOORBEAM WAS REPAIRED IAW ATS EO 10-3674, DATED 8-13-10.SDR AALA20100812TUL06Floorbeam · misalignedSEAT BACK HOLES ARE MISALIGNED. REMOVED AND REPLACED UPPER FLOORBEAM STATION 907 LEFT BUTTLINE 45 PER EA B737-53-012005.SDR IPXA10561438Floorbeam · crackedINSPECTION TYPE:C2, MCB FLOOR SUPPORT PLATE CRACKED BS 900, RBL 21, WL 208. R & R COVER PLATE IAW SRM 51-40-02-OG.SDR IPXA10561434Floorbeam · scratchedINSPECTION TYPE:C2, MCB FLOOR SUPPORT PLATE HAS SCRATCHES ON UPPER SURFACE BS 900, RBL 27 TO RBL 40, WL 208. R & R COVER PLATE IAW SRM 51-40-02-OG.SDR USAA2010072891514Floorbeam · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FLOORBEAM UPPER CHORD AT BS 663, LBL 24.8. REPAIRED FLOORBEAM UPPER CHORD AT BS 663, LBL 24.8 IAW EA 101986.SDR FDEA201007222645Floorbeam · damagedDURING INSTALLATION OF FLOOR PANELS PN 11861180-1 AND FLOOR PANEL 11861182-15 WAS MISSED DRILLED INTO FLOORBEAM AT STA. 365.25 RBL 13.95 AND LBL 6.80 ON MOD FLOOR PANEL INSTL-SECTION. REMOVED AND REPAIRED FLOORBEAM STA 365.25 RBL 50 TO LBL 15 IAW SRM 53-00-SDR 2010F00178Floorbeam · corrodedFLIGHT DECK, FLOORBEAM 11 ABOVE STRINGER 20L HAS SURFACE CORROSION ON UPPER SURFACE AND ON INTERCOSTAL JUST AFT OF BEAM CORROSION BEYOND SRM LIMITS. (LEVEL II) REMOVED CORROSION IAW ATR 72 SRM 51-21-42 REV 77. VERIFY CORROSION REMOVAL ON FLOORBEAM 11. PRIMESDR AALA20100721TUL04Floorbeam · corrodedCORROSION ON TOP OF FLOORBEAM STATION 986.5 AND APPROX RIGHT BUTTLINE 43. REPAIRED PER SRM 53-00-51-2R AND EA B737-53-011891.SDR IPXA10561533Floorbeam · corrodedINSPECTION TYPE:C2, MCB FLOOR SUPPORT SHIM PLATE HAS CORROSION ON UPPER SURFACE BS 1055, WL 208, LBL 4 TO LBL 22. REMOVED, FABRICATED, INSTALLED REPLACEMENT SHIM PLATE.SDR IPXA10561433Floorbeam · scratchedINSPECTION TYPE:C2, MCB FLOOR SUPPORT PLATE UPPER SURFACE HAS SEVERAL SCRATCHES BS 1020, LBL 3 TO LBL 22, WL 208. R & R COVER PLATE IAW SRM 51-40-02-OG.SDR IPXA10561432Floorbeam · scratchedINSPECTION TYPE:C2, MCB FLOOR SUPPORT PLATE UPPER SURFACE HAS SEVERAL SCRATCHES BS 900, LBL 27.5 TO LBL 43.5, WL 208. R & R COVER PLATE IAW SRM 51-40-02-OG.SDR SWIA201024590Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C-CHECK) REPAIR PER REO.SDR R61A20100356Floorbeam · corrodedWHILE AIRCRAFT WAS IN FOR HEAVY CHECK. LEVEL 2 CORROSION WAS FOUND ON FLOORBEAM BETWEEN FRAMES 85 AND 86. MAINTENANCE REMOVED AND REPLACED FLOORBEAM STRAP IAW EMB 170 SRM 51-40-02, 51-41-01 AND 51-43-01. A/C STILL OUT OF SERVICE FOR HEAVY CHECK COMPLETION.SDR USAA2010072891517Floorbeam · crackedCLT - Q1 - MAJOR REPAIR - CRACKS ON FLOORBEAM WEB ON LOWER CHORD AT BS 706, LBL 24.8. REPAIRED FLOORBEAM WEB ON LOWER CHORD AT BS 706, LBL 24.8 IAW EA 102064.SDR SWAA104233Floorbeam · crackedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CRACKED AT BS 294.5, STR 17L. REPAIRED BEAM PER SRM.SDR AALA20100719TUL02Floorbeam · crackedCABIN OVERWING FLOORBEAM CRACKED STATION 927 LONGERON 18 RIGHT. INSTALLED NEW FLOORBEAM PER SRM 51-30-05.SDR A6WA201040558Floorbeam · crackedFLOOR SUPPORT CRACKED (AFT FACE) LBL 12 APPROX FS 280. REPAIR IAW 601R-53-11-138, REV NC AND 601R-53-11-1942.SDR SWIA201024801Floorbeam · crackedFS 280 FLOORBEAM CRACKED LT & RT SIDES. (C-CHECK) REMOVED AND REPLACED FS 280 FLOORBEAM PER SRM.SDR FDEA201007172578Floorbeam · corrodedAFT CARGO - WHILE REMOVING FLOORBEAM IN AFT UPPER CHORD ABOVE LONGERON 45R AT STA 1841, FLOORBEAM FOUND CORRODED. REPAIR CARRIED OUT IAW EA 8-5310-132456, THIS REPAIR IS CLASSIFIED MAJOR IAW GMM 6-2-100, REV 110.SDR FDEA201007162562Floorbeam · crackedMAIN DECK STA 475, LBL 77 TO 107, FLOORBEAM IS CRACKED/DAMAGED. FABRICATED FLOORBEAM SEC REPAIR FROM 7075-T6 .071 BATCH NR 183113 IAW SRM 53-00-01, FIG 9, SHEET 7. TREATED AND PRIMED REPAIR IAW SRM 51-21-01. INSTALLED REPAIR IAW SRM 51-31-01. PAINTED AREA ISDR FDEA201007152554Floorbeam · misrepairedEXISTING REPAIR FOUND AT FORWARD CARGO COMPARTMENT FLOORBEAM FLANGE STATION 1059 RBL 24. EXISTING REPAIR FOUND AT FORWARD CARGO COMPARTMENT FLOORBEAM FLANGE STATION 1059 RBL 24. EVALUATED AND FOUND NOT IN ACCORDANCE WITH SRM REPAIR. REPAIR ON FLOORBEAM FLASDR SWAA104127Strap · crackedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM SHEAR STRAP CRACKED AT BS 312, LBL 12. REMOVED AND REPLACED SHEAR STRAP PER SRM.SDR FDEA201007142516Floorbeam · crackedCABIN: STA 1275, 'X' = -100 FLOORBEAM FOUND CRACKED. CABIN: STA 1275, 'X' = -100 FLOORBEAM REPAIRED AS PER E.A. 8-5310-132440, REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100, REVISION 110.SDR SWIA201024555Floorbeam · crackedFS 280 FLOORBEAM CRACKED. (C-CHECK) REPLACE FLOORBEAM.SDR FDEA201007142509Floorbeam · damagedELONGATED HOLES IN FLOORBEAM WEB AT STA 680 LBL 24.75 AT STA 680 LBL 24.75 FLOORBEAM WEB REPAIR WAS ACCOMPLISHED DUE TO DISCREPANCY EFFECTING THE P TO F CONVERSION ON MAE MOD W/C 118350497BZ2R04 AND MAE EA NR 757-5335-16-F2674 REV - DATED MAY 11, 2010. THIS SDR AALA20100714AFW01Floorbeam · corrodedCORROSION WAS FOUND AT STATION 325 FLOOR BEAM AT LEFT BUTTLINE 2 AND RIGHT BUTTLINE 4. A REPAIR STRAP WAS INSTALLED OVER THE TWO BLENDS TO RESTORE LOST STRENGTH. REMOVED CORROSION PER SRM STANDARD PRACTICES, DO NOT EXCEED 0.063 INCH MINIMUM REMAINING. FABRISDR SWIA201024800Floorbeam · crackedFS 280.00 FLOORBEAM CRACKED. (C-CHECK) REMOVED AND REPLACED FS 280 FLOORBEAM PER SRM.SDR FDEA201007132501Floorbeam · corrodedSTA 365, FLOORBEAM CORRODED AND GOUGED FROM BL 0 RBL 55. REMOVED CORROSION AND GOUGES FROM FLOOR BEAM UPPER CHORD STA 365 BL0-RBL55 IAW SRM 51-10-02. BOTH FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51 FIG 101 DETAIL III. ORIG MATERIAL .125 REMOVED 0.017. L=1.0 SDR IPXA10661172Stiffener · crackedINSPECTION TYPE:C, MEC COMPT STA 246 FLOORBEAM ATT STIFFENER FOUND CRACK AT LBL40" MEC COMPT BS 246 LBL40" FLOORBEAM ATT STIFFENER REPAIRED IAW SRM 53-10-51-2R4, FIG 201, ORG MATL IS BAC1490-2793-7075T62, CRK LENGTH IS 1", THIS REPAIR IS CLASSIFIED AS A MAJOSDR SWIA201024556Angle · crackedCAP ANGLE AT FS 559.0 CRACKED. (C-CHECK) REPAIR PER REO.SDR USAA2010071991462Floorbeam · corrodedPIT - MAJOR REPAIR - S4 - GALVANIC CORROSION ON FLOORBEAM BETWEEN FR 20-21, STR 23R, BL -Y765. REPLACED FLOORBEAM BETWEEN FR 20-21, STR 23R, BL -Y765 IAW A319 SRM 51-72-11.SDR FDEA201007132503Floorbeam · corrodedCABIN FLOORBEAM TEE AT STA 345.0 BETWEEN LBL 24.75 AND LBL 45.5 HAS CORROSION. REMOVED CORROSION FROM T-CAP STA 345, LBL24-45, IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DETAIL III. ORIG MATERIAL .125 AFTER REWORK .106. L=20" W=.
Back to JASC 5315