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 USAA980522Floorbeam · corrodedCLT - DURIGN Q-2 CHECK VISUAL INSPECTION, FOUND A 52 INCH ACROSS FLOORBEAM EACH SCREW HOLE 1 INCH BY 2 INCH AREA OF CORROSION STATION 294.5, LBL 7 RBL 45 FLOORBEAM UPPER CHORD. CORROSION TASK NR C 53-107-02. BURNISHED FLOORBEAM EXCEPT AT STATION LBL 7, REPAISDR CALA9801982Floorbeam · corrodedINSPECTION FOUND LT AFT LAV FLOORBEAM CORRODED AT STA 1006, LBL 16 TO LBL 28. REPAIRED IAW SRM 53-00-51.SDR CALA9801981Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOORBEAM NUT PLATES AND ON DOUBLER AT STA 312 TO 328. THE CORROSION WAS REMOVED AND A REPAIR WAS INSTALLED IAW SRM 51-70-12.SDR 98FDEA00661Floorbeam · corrodedUPPER LOBE CABIN, CORROSION ON UPPER AND LOWER SIDE OF FWD TOP FLOORBEAM FLANGE AT BS 540 RBL 10, 5 INCHES FROM CENTER OF A/C. REMOVED CORROSION PER SRM 51-10-6, BEYOND LIMITS. INSTALLED DOUBLER, ACCOMP PER AARD 53-10-01-1 FIG 2.SDR ARWA981051Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM MAIN CARGO COMPARTMENT STATION W60 RBL 25, CUT OUT AREA OF CORROSION FABRICATED FILLER AND ANGLE AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371015 WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 5085A. (M)SDR ARWA981047Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM UPPER FORWARD FLANGE, MAIN CABIN STATION 1040 RBL 43.5 TO RBL 55. CUT OUT AREA OF CORROSION, FABRICATED ANGLE AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371030. WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 5994. (SDR ARWA981042Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM CARGO COMPARTMENT STATION 55, RBL 12 TO RBL 12. REMVOED CORROSION, BEYOND LIMITS. FABRICATED ANGLES TWO AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371031 WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 4392. (M)SDR ARWA981041Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM MAIN CARGO COMPARTMENT STATION 1300 RBL 17 CUT OUT AREA OF CORROSION. FABRICATED FILLER AND ANGLE AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371032. WORK ACCOMPLISHED UNDER ARROW AIR JW3B CPCP CONTROL 5990. (M)SDR ARWA981038Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM MAIN CARGO COMPARTMENT STATION 70, RBL 29. REMOVED CORROSION SRM 51-1-8. FABRICATED ANGLE AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371033. WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 5091A. (M)SDR ARWA981035Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM, UPPER AFT MAIN CARGO COMPARTMENT STATION 600 RBL 33 CUT OUT AREA OF CORROSION. FABRICATED FILLER AND ANGLE AND INSTALLED IAW WITH EO JOSSAIR, CON NR 18R5371011. WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 5090SDR ARWA981034Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM UPPER AFTR FLANGE STATION 160 RBL 25, CUT OUT AREA OF CORROSION. FABRICATED FILLERS AND ANGLES AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371017. WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CONTROL 5081A. (M)SDR ARWA981033Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM MAIN CARGO COMPARTMENT STATION 180, CUT OUT AREA OF CORROSION. FABRICATED FILLERS ANGLE AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371014. WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 5082A. (M)SDR ARWA981031Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM MAIN CARGO COMPARTMENT STATION 140, REMOVED CORROSION SRM 51-1-8. FABRICATED BEAM AND INSTALLED IAW EO JOSS AIR , CO NR 18R5371013 WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 5080A. (M)SDR ARWA981030Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM FLIGHT COMPARTMENT STATION 55, LBL 29 TO LBL 47, CUT OUT OF CORROSION. FABRICATED BEAM UPPER CHORD AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371001, WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 4420. (M)SDR ARWA981029Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM UPPER AFTER FLANGE MAIN CABIN STATION 100 RBL 34 CUT OUT AREA OF CORROSION FABRICATED ANGLE AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371016, WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 5078A. (M)SDR ARWA981028Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM FLIGHT COMPARTMENT STATION 55, RBL 12 TO RBL 29 CUT OUT AREA OF CORROSION. FABRICATED BEAM UPPER CHORD AND INSTALLED IAW EO JOSS AIR NR 18R5371004, WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 4419. (M)SDR ARWA981027Floorbeam · corrodedLAP - FOUND CORROSION ON FLOORBEAM MAIN CARGO COMPARTMENT STATION 80. CUT OUT AREA OF CORROSION, FABRICATED ANGLE AND INSTALLED IAW EO JOSSAIR, CO NR 18R5371002 WORK ACCOMPLISHED UNDER ARROW AIR FORM JW3B CPCP CONTROL 5077A. (M)SDR 98FDEA00664Floorbeam · corrodedCORROSION ON TOP FLANGE AND BOTTOM OF TOP FLANGE ON FLOORBEAM BS 1110, LBL 65. REPAIRED FLOORBEAM AT BS 1110, LBL 65 PER SRM 53-10-8 AND EA 7-5310-29647.SDR CALA9801978Floorbeam · corrodedINSPECTION FOUND LT AFT LAV FLOORBEAM CORRODED AT FASTENER HOLE, STA 1016, WL 208, LBL 5 TO LBL 38. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03450.SDR CALA9801977Floorbeam · corrodedINSPECTION FOUND FLOORBEAM T CAP CORRODED AT STA 986.5, WL 208, BBL 0 TO RBL 15. THE T CAP WAS REPLACED IAW SRM 53-00-51.SDR EIAA980345Floorbeam · crackedHKG - DURING C6 CHECK, AFT CARGO FLOORBEAM WEB FOUND CRACKED AT BS 1540 ABOVE STRINGER 44R. REPAIRED PER SRM 53-40-02 FIG 1. (M)SDR CALA9801969Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT NUTPLATES LOCATED IN E/E COMPARTMENT AT STA 312, RBL 3.5 TO 17. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 51-70-12, FIGURE 1.SDR SWAA982564Floorbeam · crackedDURING SCHEDULED SPECIAL VISIT TO DLF, FOUND CENTER FLOORBEAM IN PAX CABIN CRACKED AT BS 660. REPAIRED PER SWA RA NR 1-357-0579.SDR AALA984207Floorbeam · corrodedAFW - FLOORBEAM AT STATION 347 RBL 34 HAD LIGHT CORROSION BLENDED FROM THE UPPER AND LOWER SURFACE OF THE TOP CAP. REFER TO FIG 1, COMPLETELY REMOVED CORROSION, ALODINE ALL BARE ALUMINUM SURFACES. FINISHED BLENDED AREA WITH TWO COATS OF PRIMER. FILL BLENDS SDR AALA984205Floorbeam · corrodedAFW - FLOORBEAM AT STATION 287 HAS CORROSION REMOVAL ON UPPER SURFACE. REFER TO FIGURES 1, 2 AND 3, ALODINE ALL BARE ALUMINUM SURFACES, REFINISH THE BLENDED AREA WITH 2 COATS OF PRIMER, FILL BLENDS WITH PROSEAL 870. (M)SDR AALA984206Floorbeam · corrodedAFW - FOUND FLOORBEAM AT STATION 1480 HAS CORROSION REMOVAL ON UPPER SURFACE. FABRICATE REPAIR STRAP OUT OF 301.5 H STAINLESS STEEL, .050 THICK. ALODINE AND PRIME ALL BARE SURFACES. FILL BLENDS WITH BMS 5-92. INSTALL REPAIR STRAP WET WITH BMS-95 SEALANT. SDR SWAA982550Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORRODED LT AND RT FLOORBEAM NUT PLATE HOLE FROM BS 847 TO 947. REMOVED AND REPLACED FLOORBEAM PER BOEING SRM.SDR UPS98828016Floorbeam · crackedINSPECTION TYPE:C F/S 1160 AT THE RT CUSP, THE FLOORBEAM TO CUSP FITTING IS CRACKED. REMOVED, FABRICATED, AND INSTALLED REPLACEMENT FITTING IAW SRM 51-1-21 AND DWG 3754946.SDR DL73E982128Floorbeam · crackedTHE UPPER CAP OF THE RBL 24.82 OVERWING PASSENGER FLOORBEAM WAS FOUND WITH A .5 INCH CRACK EMANATING FROM A CUTOUT FOR A SEAT TRACK ATTACH POINT. THE CRACK WAS STOP DRILLED AND REPAIRED WITH AN ALUMINUM REPAIR DOUBLER AND TRIPLER PER ER/A 365847-14, REV B.SDR ABXA9800894Floorbeam · crackedDURING C-CHECK, FOUND FLOORBEAM AT STATION 996 CRACKED JUST BELOW LONGERON 18R. REPAIRED FLOORBEAM IAW DC9 SRM 51-30-5, 51-30-1 AND ABX SSRM DRAWING K05019.SDR 98ZZZM810Floorbeam · corrodedABI - SEAT TRACK, FLOOR SUPPORT WEBS AND ENTRY FLOORBEAMS ARE CORRODED BETWEEN FRAMES 36 AND 39. REMOVED AND REPLACED SEAT TRACK, WEBS AND FLOORBEAM. AIRCRAFT RETURNED TO SERVICE. (M)SDR DL757982103Floorbeam · corrodedMID VISIT, FLOORBEAM CORRODED AT STA 345 TO 379 BL 0, REPAIRED.SDR DL757982100Floorbeam · corrodedMID VISIT, FLOORBEAM AT STA 1640 LBL 0 TO LBL 58 CORRODED, REPAIRED.SDR CALA9801933Floorbeam · corrodedFLOORBEAM TOP HAS SURFACE CORROSION FS 1130 RBL 12-12. REMOVED FASTENERS. CUT OUT ANGLE DAMAGE. FABRICATED NEW ANGLE, SPLICES. FABRICATED NEW FLOORBEAM TREATED AND INSTALLED PER SRM 51-10-2 AND 51-40-3.SDR AALA984204Floorbeam · corrodedAFW - FLOORBEAM AT RBL 33 HAS CORROSION REMOVAL ON UPPER SURFACE AS SHOWN ON SKETCH. BLEND OUT ALL CORROSION. DYE PENETRANT INSPECT AND ROTO-PEEN REPAIRS AREA. ALODINE ALL BARE SURFACES. FINISH WITH 2 COATS OF BMS-10-11 PRIMER. FILL BLEND WITH BMS5-95. (SDR AALA984203Floorbeam · corrodedAFW - FLOORBEAM AT STATION 1480 HAS CORROSION REMOVAL ON UPPER SURFACE AS SHOWN ON SKETCHES. FABRICATED STRAP FROM 301.5 HARD STAINLESS STEEL .050 INCH THICK APPLIED TWO COATS OF BMS-10-11 PRIMER TO THE STRAP AND FLOORBEAM. FILLED BLENDED AREA WITH BMS5-92. SDR AALA981961Floorbeam · corrodedTUL - TOP OF FLOORBEAM CORRODED OUT OF LIMITS RBL 49 TO RBL 71. REPAIRED 380 FLOORBEAM PER SRM 53-10-08 WITH FILLER ON TOP WHERE CUT OUT AND AN ANGLE ON BOTH SIDES OF FLOORBEAM. (M)SDR AALA981960Floorbeam · damagedTUL - REPAIRED 380 FLOORBEAM RBL 7 TO RBL 30 WITH FILLER ON TOP AND ANGLE ON BOTH SIDES PER SRM 53-10-08. (M)SDR AALA981959Floorbeam · corrodedTUL - FLOORBEAM UPPER FLANGE CORRODED STATION 400 RBL 21 TO LBL 21. REMOVED CORROSION, INSTALLED FILLER RBL 2 TO 4.5, INSTALLED REPAIR WITH ANGLE ON BOTH SIDES OF FLOORBEAM. (M)SDR AALA981958Floorbeam · corrodedTUL - FLOORBEAM CORRODED ON UPPER FLANGE RBL 24 TO RBL 63 AT STATION 480. REPAIRED PER SRM 53-10-8, WITH APPROX 6 INCHES FILLER ON TOP FLANGE WITH ANGLES ON BOTH SIDES OF BEAM. (M)SDR AALA981957Floorbeam · corrodedTUL - FOUND UPPER FLANGE OF FLOORBEAM CORRODED. REMOVED AND REPLACED TOP CHORD OF STATION 344 FROM RBL 6 INCHES TO LBL 67 INCHES. DRILLED HOLES ALODINED AND PRIMED PER SRM 51-10-2 AND REINSTALLED TWO WEB STIFFENERS STATION 344 BL 0 AND RBL 8 PER SRM 53-10-8.SDR AALA981955Stringer · crackedTUL - STRINGER 15R CRACKED AT STATIO N720B PLUS 4 INCH JUST FORWARD OF ICE LIGHT. INSTALLED REPAIR TO STRINGER 15R AT STATION 720B PER SRM 53-10-3 FIGURE 5. (M)SDR EIAA980314Floorbeam · corrodedPHX - DURING C-CHECK, MAIN CABIN FLOORBEAM HAS CORROSION AT FS 756 LEFT SIDE AND INTERCOSTAL FS 737-756 LBL 56 HAS CORROSION. (M)SDR CKSA98579Floorbeam · corrodedTHE I/B SIDE OF FLOORBEAM WEB AT STA 1270 TO 1300, RBL 33, WL 189 CORRODED BEYOND SRM LIMITS. REPAIRED IAW CKF-CA-007 SUPP SHEET 1, SRM 53-10-07 PG 7, CKF-CA-019, CKF-CA-015 SUPP SHEET 1. FOUND DURING ACCOMPLISHMENT OF C D AND CPCP AT BOEING WICHITA (KIAB). SDR CKSA98570Floorbeam · corrodedFLOORBEAM UPPER CAP IN ZONE 200, STA 1780, WL 199, LBL 23 FOUND 1.5 SQUARE AREA OF CORROSION BEYOND SRM LIMITS. ALSO AT LBL 35 FOUND 1.5 X 2 AREA OF CORROSION BEYOND SRM LIMITS. REPAIRED IAW CKF-AMD-087 SUPP SHEETS 1-3. FOUND DURING ACCOMPLISHMENT OF C D ANSDR CKSA98562Floorbeam · corrodedAFTER REMOVAL OF CORROSION ON FLOORBEAM UPPER CAP REMAINING MATERIAL BEYOND SRM LIMITS. LOCATION STA 1680, WL 200, LBL 40. REPAIRED IAW CKF-AMD-038 SHEET 1. FOUND DURING ACCOMPLISHMENT OF C D AND CPCP AT BOEING WICHITA (KIAB). WORK ORDER NUMBER MO280, CORRSDR CKSA98560Floorbeam · corrodedFLOORBEAM UPPER CAP HAS AREA OF CORROSION APPROX 1.5 BY 2, ZONE 140, STA1700, WL200, LBL40. REPAIRED IAW CKF-AMD-063 SUPP SHEET 1. FOUND DURING ACCOMPLISHMENT OF C, D CHECK, CPCP WORK CARD ACCOMPLISHMENT. WORK ORDER NUMBER MO280, CORROSION TASK CARD NUMBER SDR CKSA98558Floorbeam · corrodedFLOORBEAM UPPER CAP CORRODED AT ZONE 260, STA 1740, WL199, LBL37. AREA APPROX 21 SQ INCHES. REPAIRED IAW BOEING AMMENDMENT CKF-AMD-034 SUPP SHEET. FOUND DURING ACCOMPLISHMENT OF C, D CHECK, CPCP WORK CARD ACCOMPLISHMENT. WORK ORDER NUMBER MO280, CORROSION SDR TWAA9816609Floorbeam · corrodedDURING CHECK-C, MAINT FOUND FLOORBEAM CAP CORRODED AT STA 1070, LBL 54. REPLACED FLOORBEAM CAP USING (P/N 10136-3005) AND TWA DRAWING C03050.SDR RRXA99639Floorbeam · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO FLOORBEAM AT STA 1000 AND BL 23 LEFT, DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC-8 SRM 53-2-0. (CORROSION DAMAGE
Back to JASC 5315