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 SWAA105745Floorbeam · corrodedDURING SCHEDULED 16Y CHECK, FOUND FLOORBEAM CORRODED AT BS 947, LBL 48. REPAIRED BEAM PER EA.SDR SWAA105735Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 727B, RBL 45. REPAIRED CHORD PER EA.SDR SWAA105734Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED BETWEEN BS 709 TO BS 713, LBL 25. REPAIRED CHORD PER EA.SDR SWAA105733Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CHORD CRACKED AT BS 664, BBL 0. REPAIRED CHORD PER EA.SDR SWAA105732Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM WEB CRACKED AT BS 662, RBL 24.8. REPAIRED WEB PER EA.SDR SWAA105730Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED AT BS 987, BETWEEN RBL 34 TO RBL 46. REPAIRED BEAM PER SRM.SDR DALA1024289868Floorbeam · crackedDURING M-CHECK, FOUND CRACK IN E & E COMPARTMENT FLOORBEAM LT ATTACH ANGLE AT BS 180 BL 0. REPAIRED IAW SRM 51-30-2, DWG 9923484 REV 4E ITEM 21, SRM 51-30-5.SDR DALA1024309868Floorbeam · crackedDURING H-CHECK FOUND CRACK IN MAIN CABIN FLOORBEAM AT BS 636 LBL22-LBL 44. REPAIRED IAW SRM 51-30-2 & DWG S914617.SDR ASOA201001440Floorbeam · crackedFS 280, AFT FLOOR SUPPORT ANGLE IS CRACKED OTBD OF RBL 9 AND LBL 9 & CORRODED ON TOP SIDE ALONG BULKHEAD AT RBL 9 AND LBL 9. FS 280 BULKHEAD WEB IS CRACKED BELOW FLOOR OTBD OF RBL 9 AND LBL 9. FS 280 FLOOR SUPPORT CLIPS ARE CRACKED INBD AND OTBD AT LBL 9 ANSDR DALA1024089886Floorbeam · damagedDURING H-CHECK, FOUND DAMAGE TO FLOORBEAM AT BS 218 AT RBL 56. REPAIRED IAW SRM 51-30-5, DWG 3912075 & SRM 51-10-.SDR DALA1024410177Floorbeam · unknownFS 324, FLOORBEAM UPPER CHORD REPLACED IAW SRM 53-00-51, REPAIR 1, FIG 201.SDR F3LA2010072500506Floorbeam · corrodedC-CHECK: NON ROUTINE N0410, AFT MAIN CABIN FLOORBEAM Y1292 AT FRAME 68R HAS 2 AREAS OF CORROSION. REMOVED AND REPLACED FLOORBEAM - Y1292 FROM FRAME 68R TO FRAME 69R IAW A319 SRM 51-42-11 PARA 7.SDR SWAA105706Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 897 TO BS 1006, LBL 55. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA105705Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 967 TO BS 987, LBL 50. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA105704Floorbeam · corrodedDURING SCHEDULED 12Y CHECK, FOUND FLOORBEAM CORRODED BETWEEN BS 296 TO BS 325, RBL 52. REPAIRED BEAM PER SRM AND BAC DWG.SDR FDEA201009233670Floorbeam · misalignedSHORT EDGE MARGIN CONDITIONS FOUND IN 146N5044-4 FLOORBEAM UPPER FLANGE AT STA 1280, RBL 24.75 AND RBL 45.50 AT STA 1280, RBL 24.75 AND 45.5 FLOORBEAM UPPER FLANGE REPAIR WAS ACCOMPLISHED ON MAE EA 757-5365-16-F2762, REV- DATED JUN 24, 2010. MAJOR REPAIR.SDR FDEA201009233667Floorbeam · damagedDISCREPANT FASTNER HOLE IN FLOORBEAM AT STA 460, LBL 68 AT STA 460, LBL 68. FLOORBEAM REPAIR WAS ACCOMPLISHED ON MAE EA 757-5335-16-F2740 REV- DATED JUN 17, 2010. MAJOR REPAIR.SDR AALA20100922TUL05Floorbeam · corrodedTHE CABIN STRUCTURE FLOORBEAM UPPER FLANGE IS CORRODED AT STATION 986 AND LEFT BUTTLINE 29 ON FORWARD SIDE OF BEAM. REPAIRED PER SRM 53-00-51-2R1.SDR AALA20100922TUL04Floorbeam · corrodedTHE CABIN STRUCTURE FLOORBEAM UPPER FLANGE AT STATION 986 AND LEFT BUTTLINE 21 HAS CORROSION ON AFT SIDE OF BEAM. REPAIRED PER SRM 53-00-51-2R1.SDR FDEA201009223619Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOORBEAM UPPER CHORD CORRODED AROUND HOLES BS 480. FLOORBEAM WITHIN LIMITS AND CONSIDERED A MINOR REPAIR.SDR HALA2010092100445Floorbeam · corrodedLEVEL 2 CORROSION AT STA. 1540, RBL 21. REMOVED, FABRICATED FLOORBEAM AND INSTALLED IAW SRM 53-00-51-2R1, REPAIR 1.SDR ASOA201001429Floorbeam · corrodedUPPER MODSUM DOUBLER AT LT FS 280 FLOORBEAM CORRODED. BLENDED CORROSION DAMAGE IS GREATER THAN 10 PERCENT OUT OF LIMITS REF SRM 53-00-00. FABRICATED NEW DOUBLER OUT OF 7075T62 .050 P/O T000004626 IAW DWG BA670-30069, REV A. PRIMED & APPLIED PROTECTIVE TOPCSDR DALA1023790177Floorbeam · corrodedSTA 1518 RBL 13" - 53" FLOORBEAM FOUND CORRODED AND REPAIRED IAW SRM 53-00-51, REPAIR 1, FIG 201.SDR SWAA105670Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 727B-4, LBL 45. REPAIRED CHORD PER EA.SDR SWAA105613Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, LBL 44. REPAIRED BEAM PER ER AND EA.SDR SWAA105612Floorbeam · crackedDURING SCHEDULED 24Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 26. REPAIRED BEAM PER ER AND EA.SDR AALA20100920TUL17Floorbeam · corrodedFLOORBEAM AT STATION 986 AND RIGHT BUTTLINE 29 IS CORRODED OUT OF SRM LIMITS. REPAIRED THE FLOORBEAM PER SRM 53-00-51-2R 1.SDR DALA1023419886Floorbeam · corrodedDURING H-CHECK FOUND CORROSION ON FLOORBEAM AT BS 200 RBL 1 TO RBL 20. REPAIRED IAW SRM 53-01 FIGURE 1 & SRM 51-10-4.SDR FDEA201009203560Floorbeam · corrodedMAIN CARGO COMPARTMENT FLOORBEAM UPPER CHORD HAS CHAFED MARK AND CORRODED AROUND HOLES BS 740, RBL 42. REMOVED CORRSION IAW SRM 51-10-02 , CHECKED LIMITS OF BLENDED AREA L=3.01' W= 2.00', D = .015 ORIGINAL MATERIAL .125 , REMAINING. 110, OUT OF LIMITS IAWSDR FDEA201009203559Floorbeam · corrodedFLOORBEAM UPPER CHORD LOWER SURFACE BS-720 LBL-58 HAS CORROSION. REMOVED CORROSION ON FLOORBEAM UPPER CHORD AT STA 720, LBL 58 IAW SRM 51-10-02. BLEND OUT DIM. =3.5" L2.0" W .019"D, ORIG MATL THICKNESS = .125, FOUND OUT OF LIMITS IAW SRM 53-00-51, FIG 101, DSDR 2010FA0001032Floorbeam · corrodedCORROSION ON CABIN FLOORBEAM FR 16 Y 1292. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. FLOORBEAM IS LISTED AS PRIMARY STRUCTURE. REMOVED AND REPLACED FLOORBEAM IAW A320 SRM 51-42-11.SDR 2010FA0001031Floorbeam · corrodedCORROSION ON CABIN FLOOR SUPPORT BEAM FR 16 Y254. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. BEAM IS LISTED AS PRIMARY STRUCTURE. R & R BEAM IAW SRM 51-42-11.SDR 2010FA0001028Floorbeam · corrodedCORROSION ON AFT CABIN FLOOR SUPPORT BEAM FR 70 -Y 254. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. BEAM IS LISTED AS PRIMARY STRUCTURE. R & R BEAM IAW SRM 51-42-11.SDR 2010FA0001027Floorbeam · corrodedCORROSION ON AFT CABIN FLOOR SUPPORT BEAM FR 68 TO FR 70 -Y 765. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. BEAM IS LISTED AS PRIMARY STRUCTURE. R & R BEAM IAW SRM 51-42-11.SDR 2010FA0001026Floorbeam · corrodedCORROSION ON AFT CABIN FLOOR SUPPORT BEAM FR 68 TO FR 69 -Y 1292. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. BEAM IS LISTED AS PRIMARY STRUCTURE. REMOVED AND REPLACED BEAM IAW A320 SRM 51-42-11.SDR 2010FA0001025Floorbeam · corrodedCORROSION ON AFT CABIN FLOOR SUPPORT BEAM FR 66 -Y 765. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. BEAM IS LISTED AS PRIMARY STRUCTURE. R & R BEAM IAW A320 SRM 51-42-11.SDR 2010FA0001023Floorbeam · corrodedCORROSION ON AFT CABIN FLOOR SUPPORT BEAM FR 66 Y 1292. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. BEAM IS LISTED AS PRIMARY STRUCTURE. R & R BEAM IAW SRM 51-42-11.SDR 2010FA0001022Floorbeam · corrodedCORROSION ON AFT CABIN FLOORBEAM FR 66 Y 765. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. BEAM IS LISTED AS PRIMARY STRUCTURE. R & R FLOORBEAM IAW SRM 51-42-11.SDR 2010FA0001021Floorbeam · corrodedCORROSION ON AFT CABIN FLOORBEAM FR 66 Y 254. NO CORROSION REMOVAL LIMITS AVAILABLE IN SRM. BEAM IS LISTED AS PRIMARY STRUCTURE. R & R FLOORBEAM IAW SRM 51-42-11.SDR SWAA105758Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED BETWEEN BS 706 TO BS 713, LBL 24.5. REPAIRED CHORD PER ER AND EA.SDR SWAA105757Floorbeam · crackedDURING SCHEDULED 22Y CHECK, FOUND LONGITUDINAL FLOORBEAM UPPER CHORD CRACKED AT BS 662, RBL 24.5. REPAIRED CHORD PER ER AND EA.SDR ASOA201001413Floorbeam · crackedFS280 BEAM CRACKED ON LT SIDE, LT OF PULLEY BRACKET AT LBL9. REPAIRED FS 280 BEAM IAW EC/TC REO 601R-53-11-171 AND REO 601R-53-11-171. (CLOSED)SDR ASOA201001409Floorbeam · crackedFS 280.00, LT FLOORBEAM CRACKED. REMOVED LT FS280 FLOORBEAM IAW SRM 51-42-06 & 51-42-13. DRILLED-UP NEW FOORBEAM REF SRM 51-40-11-001-001-A01. NDT FLOORBEAM LT CUT LINE IAW NDTM 51-20-06. NO DEFECTS NOTED REF ATTACHED NDT REPORT. INSTALLED FLOORBEAM IAW SRMSDR AALA20100919TUL05Floorbeam · damagedG-1 GALLEY MOUNT HOLES OVERSIZED AT STATION 160 AT RIGHT BUTTLINE 45 TO 51 THROUGH FLOORBEAM. INSTALLED REPAIR STRAP ON TOP OF FLOORBEAM STATION 160 RIGHT BUTTLINE 42 TO 58 PER EA MD80-53-013020.SDR IPXA10562695Floorbeam · corrodedINSPECTION TYPE:C3, MCB FLOOR PANEL SUPPORT COVER PLATE UPPER SURFACE CORRODED STA 1020, BL 0 TO LBL 25. R & R SUPPORT PLATE IAW SRM 51-40-02-0GSDR ASOA201001401Floorbeam · crackedFS 280 OTBD OF LBL 9, WL 73 FLOOR SUPPORT J-ANGLE CRACKED AT ALTERNATE EXTENTION PULLEY BRACKET. COMPLIED WITH EC/TC REO 601R-53-11-926 IAW REO 601R-53-11-926, REV B.SDR USAA2010092392084Floorbeam · crackedSAL - C22 - MAJOR REPAIR - CRACK ON HOLE OF FLOORBEAM UPPER CHORD AT BS 328, RBL 35 FWD PAX CABIN. REPAIRED FLOOR BEAM UPPER CHORD AT BS 328, RBL 35 IAW B737 SRM 53-10-51 REPAIR 6.SDR USAA2010092392083Floorbeam · crackedSAL - C22 - MAJOR REPAIR - CRACK ON FLOORBEAM AT BS 328, LBL 30. REPAIRED FLOORBEAM AT BS 328, LBL 30 IAW B737 SRM 53-10-51 REPAIR NR 6.SDR FDEA201009173531Floorbeam · corrodedFLOORBEAM STA 377, BL 0, RBL 10, UPPER TEE CORRODED. REMOVED CORROSION PER SRM 51-10-02. CHECKED LIMITS AND FOUND TO BE OUT OF LIMITS PER SRM 53-00-51, FIG.101, DETAIL 3. REMOVED DAMAGED AREA OF THE FLOORBEAM PER SRM 53-00- 51. FABRICATED NEW TEE AND REPAIRSDR ASOA201001394Floorbeam · corrodedFS 280.00 COCKPIT FLOORBEAM CORRODED. REMOVED FS280 COCKPIT FLOORBEAM ANGLE REF SRM 51-42-06-001-001-A01 AND SRM 51-42-21-001-001-A01 AND SRM 51-42-22-001-001-A01. INSTALLED NEW FS280 COCKPIT FLOORBEAM ANGLE REF SRM 51-42-06.
Back to JASC 5315