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 UPS99829590Floorbeam · corrodedINSPECTION TYPE:C3, FS 70 FLOORBEAM AT RBL 48 IS CORRODED BEYOND LIMITS. REPAIRED FLOORBEAM IAW DHC SK840-349.SDR TWAA9907001Floorbeam · corrodedDURING OP 16 MAINT CHECK, FOUND FLOORBEAM AT STA 160, RBL 48, WITH CORROSION MATERIAL LOSS BEYOND LIMITS TO THE TOP CAP AFT FLANGE. REPAIRED PER SRM 53-05, FIG 20A.SDR SWAA990837Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION ON UPPER CHORD OF FLOORBEAM, BS 328, RBL 57. REPAIRED BEAM PER SRM.SDR SWAA990835Floorbeam · corrodedDURING SCHEDULED D CHECK, FOUND CORROSION AT FASTENER HOLE ON FLOORBEAM, BS 967, RBL 27. REPAIRED BEAM PER SRM.SDR TWAA9907301Floorbeam · crackedDURING OP 16 MAINT CHECK, FOUND CABIN FLOORBEAM REPAIR CRACKED 2 INCHES LONG IN UPPER CAP RADIUS AT FWD SIDE OF STA 180, LBL 15. REPLACED FLOORBEAM TEE UPPER CAP PER SRM 53-11-1, FIG 13 SHEET 1, PAGE 45 AND 47, FIG 13 SHEET 2 AND DAC DRAWING 9923484. INSTALLSDR SWAA990819Floorbeam · crackedDURING SCHEDULED SPECIAL VISIT CHECK, FOUND CRACKED CENTER FLOORBEAM AT BS 663, BL O. REPAIRED BEAM PER SWA RA 1-357-0679, AND ACO 658-57.SDR SWAA990818Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON FLOORBEAM, AFT CARGO AREA, BS 860, LBL 17. REPAIRED BEAM PER SRM.SDR SWAA990817Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON FLOORBEAM, AFT CARGO AREA, BS 730, RBL 3 - RBL 8. REPAIRED BEAM PER SWA RA NR 1-A53-2021.SDR SWAA990816Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION ON FLOORBEAM, AFT CARGO AREA, BS 771, LBL 12 - RBL2.5. REPAIRED BEAM PER SWA RA NR 1-A53-2021.SDR SWAA990815Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM, BS 987, LBL 40 - 43, INSIDE CABIN. REPAIRED BEAM PER EO 99-5313.SDR GAIA9955Floorbeam · corrodedDURING ROUTINE SCHEDULED MAINTENANCE, THE FLOORBEAM AT STATION 1130, RBL 45 TO 60 WAS FOUND TO HAVE CORROSION AND OUT OF SRM REPAIR TOLERANCE. REPAIRED DAMAGED FLOORBEAM IAW AMERICAN INTERNATIONAL ENGINEERING INSTRUCTIONS. REF AIA/E/2948, DATED 4/5/99. THISSDR UF6A990506Floorbeam · corrodedSBN - FLOORBEAM AT STATION 289AS HAS CORROSION ON RIGHT SIDE. MAINTENANCE REMOVED CORROSION AND WAS FOUND TO BE WITHIN LIMITS IAW BAE ATP SRM 51-10-00. AREA WAS ALODINED AND PRIMED. (M)SDR UF6A990505Floorbeam · corrodedSBN - FLOORBEAM AT STATION 343AS HAS CORROSION ON RIGHT SIDE. MAINTENANCE REMOVED CORROSION AND WAS FOUND TO BE WITHIN LIMITS IAW BAE ATP SRM 51-10-00. AREA WAS ALODINED AND PRIMED. (M)SDR UF6A990504Floorbeam · corrodedSBN - FLOORBEAM AT STATION 325AS HAS CORROSION ON RIGHT SIDE. MAINTENANCE REMOVED CORROSION AND WAS FOUND TO BE WITHIN LIMITS IAW BAE ATP SRM 51-10-00. AREA WAS ALODINED AND PRIMED. (M)SDR UF6A990503Floorbeam · corrodedSBN - FLOORBEAM AT STATION 308AS HAS CORROSION ON RIGHT SIDE. MAINTENANCE REMOVED CORROSION AND WAS FOUND TO BE WITHIN LIMITS AW BAE ATP SRM 51-10-00. AREA WAS ALODINED AND PRIMED. (M)SDR SWAA990808Floorbeam · corrodedDURING SCHEDULED 1/4D CHECK, FOUND CORROSION AT FLOORBEAM BS 860 LBL 12- RBL 2.5. REPAIRED BEAM PER SWA RA NR 1-A53-2021.SDR CALA9900483Floorbeam · corrodedFLOORBEAM CORRODED AT SCREW HOLE FS 400 RBL 35. CUT OUT DAMAGED SECTION. FABRICATED REPAIR PARTS, PICKED UP HOLES, TREATED, PRIMED, AND INSTALLED REPAIR PER SRM 51-10-6 AND 53-10-8 FIG 8.SDR ASAA9940106Floorbeam · corrodedPHX - DURING SI CHECK, FOUND MAIN CABIN FLOORBEAM CORRODED AT STATION 344, LBL 14. REPAIRED PER EA 5310-01682. (M)SDR SWAA990800Floorbeam · corrodedDURING SCHEDULED D-CHECK, FOUND CORROSION ON BS 344 FLOORBEAM LBL 38, 31 AND 12 INSIDE CABIN. REPAIRED BEAM PER SRM.SDR SIMA991232Floorbeam · corrodedSAW - DURING CPCP-2 INSPECTION, FOUND FLOORBEAM 36 CORRODED. MAINTENANCE REPAIRED FLOORBEAM 36 IAW SRM 53-00-00 FIGURE 435. AIRCRAFT RETURNED TO SERVICE. (M)SDR ASAA9940115Floorbeam · corrodedPHX - DURING SI CHECK, FOUND MAIN CABIN FLOORBEAM CORRODED AT STATION 312, LBL 1. REPAIRED PER SRM 53-10-51, FIG 205. (M)SDR ASAA9940113Floorbeam · corrodedPHX - DURING SI CHECK, FOUND MAIN FLOORBEAM T-CAP AT BS 986, LBL 34 CORRODED AROUND SCREW HOLES. REPAIRED PER SRM 53-60-51, FIG 203. (M)SDR ASAA9940112Floorbeam · corrodedPHX - DURING SI CHECK, FOUND MAIN FLOORBEAM T-CAP AT BS 967, LBL 30 CORRODED AROUND SCREW HOLES ON TOP AND BOTTOM SIDES. REPAIRED PER SRM 53-60-51, FIG 203. (M)SDR ASAA9940111Floorbeam · corrodedPHX - DURING SI CHECK, FOUND FLOORBEAM T-CAP AT BS 947.5, RBL 48 CORRODED AROUND SCREW HOLES ON FORWARD SIDE. REPAIRED PER SRM 53-60-51, FIG 203. (M)SDR ASAA9940110Floorbeam · corrodedPHX - DURING SI CHECK, FOUND FLOORBEAM T-CAP AT BS 986, RBL 8 CORRODED ON AFT FLANGE. REPAIRED PER SRM 53-00-51, FIG 203. (M)SDR USAA990427Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND CORROSION AT STATION 986.5 ALONG ENTIRE FLOORBEAM CORROSION TASK NR C53-107-02. INSTALLED NEW T-CAP, STRAPS, AND SPLICE PER TR 53-60-01. (M)SDR USAA990412Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 32 INCH AREA OF CORROSION AT STATION 947.5 LT AND RT OF BL 0 FLOORBEAM. REPAIRED 'T' CAP PER TR 53-60-02. (M)SDR USAA990398Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 1 INCH AREA OF SPOTTED CORROSION FROM STATION 787 TO 847 RBL 14 FLOORBEAM. CORROSION TASK NR C53-208-01. REMOVED AND REPLACED PER TR 53-00-53. (M)SDR SWAA990792Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON FLOORBEAM AROUND FASTENER HOLES AT BS 947, LBL 5-RBL 5. REPAIRED FLOORBEAM PER SRM.SDR CALA9900458Seat Track · corrodedHOU - LEFT INBOARD CABIN SEAT TRACK HAS CORROSION AT STA 907 TO STA 947. FABRICATED AND INSTALLED NEW SECTION OF SEAT TRACK PER SRM 53-00-52 FIG 204. (X)SDR SWAA990785Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CRACK EXTENDING FROM OVAL CUTOUT OF FLOORBEAM, BS 667, LBL 24.75 UNDER SEAT TRACK. REPAIRED BEAM PER SWA RA NR 1-357-0680.SDR USAA990422Floorbeam · corrodedCLT - DURING C-4 CHECK VISUAL INSPECTION, FOUND A 2 INCH BY 4 INCH AREA OF CORROSION AT STATION 346 FLOORBEAM. INSTALLED REPAIR ANGLE PER EA 64434. (M)SDR CALA9900460Floorbeam · crackedHOU - FLOORBEAM WEB CRACKED .35 INCH AT STATION 328 LBL 1. INSTALLED REPAIR PER EC/RA 5310-03847. (M)SDR CALA9900459Seat Track · corrodedHOU - CABIN SEAT TRACK LEFT OUTBOARD CORRODED AT STA 370. FABRICATED AND INSTALLED SEAT TRACK PER SRM 53-00-52. (X)SDR 9902502295Floorbeam · corrodedDURING M CHECK, FOUND CORROSION ON NUT PLATE LOCATION ON 1175 FLOORBEAM. REPAIRED PER EA 22-166634.SDR SWAA990771Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM, BS 312,LBL 14 - RBL 14, INSIDE CABIN. REPAIRED PER SRM.SDR UPS99829422Floorbeam · damagedINSPECTION TYPE-A, FLOORBEAM MOUNT HOLES ELONGATED AT STA 1680 AT LT O/B SEAT TRACK. THIS ITEM ACCOMPLISHED ON N/R CARD 544810.SDR SCNA99705Floorbeam · corrodedDURING A HEAVY MAINTENANCE CHECK, FOUND CORROSION OUT OF LIMITS ON FLOORBEAM AT BS312 BL0. REMOVED CORROSION IAW SRM 511006, OUT OF LIMITS PER SRM 531001. CUTOUT DAMAGED AREA IAW SRM 514004. FABRICATED REPAIR DOUBLER FROM EXTRUSION BAC14902831 7075 T6 IAW SSDR 99FDEA00162Floorbeam · corrodedFLOORBEAM BLENDED THRU AT RBL - 9.0 & LBL 4.0 REPAIR PER DALFORT XEA-X1-53-698 DATED 4/19/99. THE ABOVE MENTIONED NR CREATED AN XEA TO ACCOMPLISH THE REPAIR. REPAIR IN PROGRESS. *S/D* REPAIRED PER FEDEX ENG AUTH NR 7-5310-45238 & DAL AERO LP XEA-X1-53-698.SDR ASAA9980092Floorbeam · corrodedPHX - DURING 15K CHECK, FOUND CORROSION ON FLOORBEAM CAP, LBL 42 AT FS 1338. BLENDED DAMAGED AREA AND INSTALLED DOUBLER ANGLE AND WEAR STRIP IAW DC9 SRM 53-05, FIG 20A. (M)SDR UPS99829513Floorbeam · corrodedINSPECTION TYPE:SV, FLOORBEAM STATION 1600 AFT FACE 36 FROM LEFT CUSP HAS CORROSION. REPAIRED IAW REO 06439 REV A PER TIMCO DWG DC08-53-0351 REV A -501 INSTALLATION AND UPS REPAIR AUTHORIZATION DC8-53-2583.SDR SWAA990751Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION AT FLOORBEAM, BS 294.5, LBL 14-RBL 11. REPAIRED BEAM PER SRM.SDR USAA990390Floorbeam · corrodedCLT - DURING A Q-2 CHECK, VISUAL INSPECTION FOUND A 1 INCH AREA OF CORROSION AT STATION 312 LBL 12 FLOORBEAM. INSTALLED NEW 'T' CAP WITH SPLICES AND REPAIR STRAPS PER TR 53-10-13. (M)SDR USAA990382Floorbeam · corrodedCLT - DURING A Q-2 CHECK, VISUAL INSPECTION FOUND A 1 INCH AREA OF CORROSION AT STATION 312 LBL 1 FLOORBEAM. INSTALLED NEW 'T' CAP WITH SPLICES AND REPAIR STRAPS PER TR 53-10-13. (M)SDR USAA990303Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND A 2 INCH AREA OF CORROSION AT BS 947 RBL 6 FLOORBEAM. INSTALLED REPAIR ANGLES AND FILLERS PER SRM 53-10-09 PAGE 26 THROUGH PAGE 30. (M)SDR USAA990302Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM STATION 986.5. SPLICED IN NEW SECTION OF FLOORBEAM 'T' CAP PER TR 53-60-01 AND EA 64288. (M)SDR USAA990301Floorbeam · corrodedCLT - DURING A Q-2 CHECK, VISUAL INSPECTION, FOUND CORROSION ALONG TOP SURFACE OF FLOORBEAM AT STATION 967, CORROSION TASK NR C53-107-02. SPLICED IN NEW 'T' CAP AND DOUBLER PER SRM 53-10-9 FIG 2 AND EA 64204. (M)SDR USAA990300Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM STATION 328 LBL 12 AND RBL 1. INSTALLED NEW 'T' CAP REPAIR ANGLES AND STRAPS PER TR 53-10-13. (M)SDR USAA990299Floorbeam · corrodedCLT - DURING Q-2 CHECK VISUAL INSPECTION, FOUND CORROSION ON FLOORBEAM STATION 294.5 BL 0. SPLICED IN NEW 'T' CAP PER TR 53-10-04B. (M)SDR USAA990297Floorbeam · corrodedCLT - DURING A Q-2 CHECK, VISUAL INSPECTION, FOUND SEVERAL 1 INCH AREAS OF CORROSION AT STATION 967 BETWEEN LBL 10 AND RBL 50 FLOORBEAM. SPLICED IN NEW 'T' CAP PER SRM 53-10-09 AND EA 64202. (M)
Back to JASC 5315