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 RAIA0001035Floorbeam · corrodedMX- DURING INSPECTION FOUND CORROSION AT FRAME 39 FLOORBEAM. MAINTENANCE REPLACED FLOORBEAM AT FRAME 39 IAW ATR42 SRM.SDR UPS00831698Floorbeam · corrodedINSPECTION TYPE:C123 MAIN CABIN, FLOOR SUPPORT HAS CORROSION ON UPPER AND LOWER SURFACE AT STA 1722-1726.5, LBL 18..5-21. REMOVED CORROSION FROM FLOOR SUPPORTS IAW DC8 SRM 51-1-8. MAT REMOVAL OUT OF LIMITS IAW DC8 SRM 53-2-0, MAT ID FOR NEW SUPPORT 52912399 SDR RRXA001660Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE AFT LWR CARGO COMPT TOP OF FLOORBEAM AT STA 1060, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED HOLES, FABRICATED DOUBLERS FROM 7SDR RRXA000962Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 440, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLSDR P2EA00062Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 360, BETWEEN RBL 65 AND LBL 65. REPAIRED FLOORBEAM AT BS 360 BETWEEN RBL 4 AND RBL 65 IAW EO COO-3-53-071-00 DATED 2/9/2000. REMOVED CORROSION FROM LBL 65 TO RBL 4 IAW SRM 51-10-6. (M)SDR P2EA00044Floorbeam · crackedSJO - DURING Q-CHECK, FOUND FLOORBEAM CRACKED AT BS 520, LBL 45 AND WL 208. REPAIRED FLOORBEAM FROM LBL 40.5 TO LBL 50.5 IAW SB 737-53-1120, SECTION III, PART VI, FIG 28 AND FOG 29 DATED MAY 13, 1993. (M)SDR RRXA000114Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM 1380 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR QXEA0000190Floorbeam · crackedPDX - FLOOR SUPPORT BEAM CRACKED AT ATTACH POINT TO AFT PRESSURE BULKHEAD BL340L. REPAIRED IAW HORIZON AIR EA 4-53-980SDR QXEA0000189Floorbeam · crackedPDX - FLOOR SUPPORT BEAM CRACKED AT ATTACH POINT TO AFT PRESSURE BULKHEAD BL340R. REPAIRED IAW HORIZON AIR EA 4-52-980.SDR P2EA00042Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND CORROSION FLOORBEAM AT BS 328 BETWEEN BL 0 AND LBL 63. REPAIRED FLOORBEAM FROM LBL 65 TO RBL 65 IAW SRM 53-10-9 FIG 5. (M)SDR DHL200071781DFloorbeam · crackedAT D-CK, FLOORBEAM CRACK AT B/S 344 LBL 31. REMOVED FLOORBEAM UPPER CHORD FROM LBL 60 TO RBL 60 BS 344 PER B727 SRM 51-30-2. INSTALLED NEW FLOOR UPPER CHORD PER B727 SRM 53-10-2 FIG 1, AND 51-30-2. REF: N/R 3775.SDR COMA0060102Floorbeam · crackedTHE FLOOR MEMBER (P/N 600-34017-17) AT FS 280 WAS CRACKED .25 APPROX 1 INCH TO THE RIGHT OF FLOOR SUPPORT AT RBL 9. PERFORMED A MAJOR REPAIR TO FLOOR MEMBER (P/N 600-34017-17) AT FS 280, 1 INCH TO THE RIGHT OF RBL 9 IAW WVAC EO 601R-53-0901.SDR CALA0000107Floorbeam · crackedINSPECTION FOUND FLOOR SUPPORT CRACKED AT FS 1098, L24L, IN AFT CARGO PIT. THE FLOOR SUPPORT WAS REMOVED AND A NEW FLOOR SUPPORT WAS INSTALLED IAW SRM 51-70-01 AND 51-30-02.SDR RRXA001632Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 560, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBLSDR RRXA000948Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM STA 280, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED ALL MISDRILLED HOLES, FABRICATED DOUBSDR RRXA000947Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE FWD LWR CARGO COMPT TOP OF FLOORBEAM AT STA 300, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED ALL HOLES, FABRICATED DOUBLER FROMSDR TWAA0002301Floorbeam · corrodedDURING CHECK-C MAINTENANCE, FOUND CORROSION IN THE AFT CARGO COMPT ON FLOOR SUPPORT STA 1212, RBL 9 TO 15. INSTALLED NEW SUPPORT PN 5936597-509 PER SRM 51-30-2 AND 51-30-0.SDR SWAA000173Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND FLOORBEAM UPPER SURFACE CORRODED, BS 986, RBL 14-36. REPAIRED BEAM PER ER NR 99-0047A.SDR P2EA00034Floorbeam · corrodedSJO - DURING Q-CHECK, FOUND CORROSION ON FLOORBEAM AT BS 967, FROM LBL 17 TO LBL 51. REPAIRED FLOORBEAM UPPER FLANGE FROM LBL 36 TO LBL 50 IAW SRM 53-10-9 FIG 7. (M)SDR CALA0000102Floorbeam · corrodedINSPECTION FOUND TOP CAP OF FLOORBEAM CORRODED ATSTA 720, LBL 60 TO RBL 60. THE TOP CAP OF FLOORBEAM WAS REPLACED IAW TRAMCO ENGINEERING DRAWING 95-030.SDR CALA0000094Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER FLANGE CORRODED AT STA 680 FROM LBL 24 TO RBL 15. THE CORROSION WAS REMOVRD IAW SRM 51-30-51 AND ECRA 5321-01078.SDR DHL200080312CFloor Support · crackedAT C-CHECK, AFT BAGGAGE COMPARTMENT FLOOR SUPPORT ANGLE CRACKED 1 INCH AT STA 1360.000 L-35R. REMOVED FASTENERS FROM AFFECTED AREA, FABRICATED DOUBLER. INSTALLED FLOOR DOUBLER WITH FASTENERS AND RIVETS IAW SRM 53-2-0 PG 12 2BA AND 2B. WORK DONE ON NONE ROUTSDR AALA2000209Floorbeam · corrodedTUL - FOUND AFT CARGO FLOOR SUPPORT BEAM T FRAME 62 HAS CORROSION JUST INBOARD OF TRACK 6. INSTALLED FLOORBEAM SUPPORT AND SPLICE PER SRM 53-10-15. (M)SDR RRXA001659Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE AFT LWR CARGO COMPT TOP OF FLOORBEAM AT STA 1080, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED DISCREPANT HOLES, FABRICATED DOUBSDR TWAA0001903Floorbeam · corrodedDURING CHECK-C MAINT, THE AFT CARGO FLOOR SUPPORT AND ANGLE THRESHOLD TRANSITION HAD CORROSION AT NUT PLATE AREA. REMOVED OLD ANGLE AND REPLACED WITH PER DAC DRAWING 5936587 AND SPM 6-70-01, PAGE 3 PARA B. ALSO SRM 51-30-2 RIVETS 51-30-1 AND 51-20-0.SDR RRXA000136Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM, AT STA 1140 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000135Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1160 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000134Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1180 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000133Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1200 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000132Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1220 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000131Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1240 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000130Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1260 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000129Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1280 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000128Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1300 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000127Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1320 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000126Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1340 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000125Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1360 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000124Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1400 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000123Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1420 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR RRXA000122Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, FLOORBEAM AT STA 1440 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.SDR QXEA0000420Floorbeam · corrodedPDX - CORROSION ON TOP OF GALLEY FLOOR SUPPORT AT NUT PLATE AREA, BEAM 3820, BL940R. REPAIRED IAW FOKKER SRM 51-10-4, PAGE 9.SDR DHL200071750DFloorbeam · corrodedAT D-CK, FWD FLANGE OF FLOOR SUPPORT HAS CORROSION AT STA 328 LBL 20. CUTOUT DAMAGED AREA AT FLOOR SUPPORT, FABRICATED AND INSTALLED REPAIR AT STA 328 LBL 20 PER B727 SRM 53-10-8 AND 51-30-2. REF: N/R 5614.SDR COMA0060111Floorbeam · corrodedLBL 9 FLOORBEAM CAP CORRODED BEYOND LIMITS FS 280 TO FS 390. INSTALLED NEW SECTION OF CAP IAW REO 601R-53-00027.SDR COMA0060100Floorbeam · corrodedRBL 27 FLOORBEAM CAP CORRODED BEYOND LIMITS FROM FS 280 TO FS 353. INSTALLED NEW FLOORBEAM CAP IAW REO 601R53-00-027 REV N/C AND WVAC EO 601R-53-0919.SDR AWXA0000039Floorbeam · crackedMAIN CABIN CENTERLINE FLOORBEAM BS 706-716 BL 0 VERTICAL WEB HAS SEVERAL CRACKS MIGRATING UP AND FORWARD FROM FASTENERS. CUT OUT DAMAGED WEB IAW SB 737-57-1210, FABRICATED DOUBLER AND WEB FRM (7075-T6 .040 QQA 250/12 R702259 AND 7075-T6 .050 QQA 250/12 R7022SDR AWXA0000038Floorbeam · crackedCABIN FS 706 LBL 24 LOWER T ANGLE ON SEAT TRACK WEB CRACKED 1/2, EXTENDING FROM UNDER RADIUS BLOCK. HFEC IAW B737 NTM PT6, 51-00-00 FIG 23, STOP DRILLED CRACK PER ER 2-53-13-20. FABRICATED REPAIR ANGLE IAW ER 2-53-13-20 FRM (BAC 1505-100257 7075-T6 R9816251SDR AWXA0000034Floorbeam · crackedSUSPECTED CRACKS MIGRATING FROM FASTENERS ON VERTICAL WEB COMMON TO LOWER CHORD AT MAIN CABIN RT FLOORBEAM BS700-727 RBL 25. HFEC INSP IAW B737 NTM PT 6 51-00-00 FIG 23 REVEALED 8 CRACKS OF DIFFERENT LENGTHS. REMOVED DAMAGED WEB PSDR RRXA000945Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES TO THE TOP OF FLOORBEAM IN THE FWD LWR CARGO COMPT AT STA 340, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED ALL DISCREPANT HOLES, FABRISDR RRXA001525Floorbeam · misdrilledDURING A MAINTENANCE VISIT, FOUND NUMEROUS DRILLED HOLES IN THE CABIN FLOORBEAM AT STA 660 CUSP TO CUSP, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. PLUGGED HOLES, FABRICATED DOUBLER FROM 7075-T6 ANDSDR RRXA000139Floorbeam · misdrilledDURING A MAINTENANCE VISIT FOUND MISDRILLED HOLES, FUSELAGE, CABIN FLOORBEAM AT STA 742 CUSP TO CUSP. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8.
Back to JASC 5315