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 ASAA9940081Floorbeam · corrodedPHX - DURING SI CHECK, FOUND THE UPPER HORIZONTAL CAP OF THE FLOORBEAM AT STATION 360 CORRODED FROM RBL 14 TO RBL 28. REPAIRED PER EA 5310-01666. (M)SDR ASAA9940080Floorbeam · corrodedPHX - DURING SI CHECK, FOUND THE UPPER HORIZONTAL CAP OF THE FLOORBEAM AT STATION 986.5 CORRODED IN NUMEROUS AREAS FROM LBL 45 TO RBL 31. REPAIRED PER EA 5310-01667. (M)SDR ASAA9910070Floorbeam · corrodedPHX - DURING D-CHECK, FOUND THE MAIN CABIN FLOORBEAM AT STATION 947 CORRODED FROM LBL 32 TO RBL 54, TOP AND BOTTOM OF UPPER CHORD. REPAIRED PER SRM 51-30-2. (M)SDR ABXA9900301Floorbeam · crackedFLOORBEAM CRACKED AT STATION 351 BL 0 TO LBL 5. REPAIRED FLOORBEAM IAW ABX REA D953-27445MR.SDR RRXA991237Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1160 AND STA 1270 AT BL 54 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRMSDR RRXA991236Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1000 AND STA 1160 AT BL 54 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED REPAIR DOUBLERS IAW DC8 SRM 51-1-8 PG 16SDR RRXA991235Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1460 AND STA 1500 AT BL 26 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER AND FILLER SDR RRXA991234Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1270 AND STA 1300 AT BL 54 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRMSDR RRXA991233Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PANEL BETWEEN STA 1360 AND STA 1420 AT BL 22 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRMSDR RRXA991232Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1360 AND STA 1440 AT BL 12 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRMSDR RRXA991231Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 580 AND STA 700 AT BL 28 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM SDR RRXA991230Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 760 AND STA 800 AT BL 32 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLERS IAW DC8 SRM SDR RRXA991229Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 600 AND STA 740 AT BL 6 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLERS IAW DC8 SRM 5SDR RRXA991228Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 420 AND STA 520 AT BL 12 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 5SDR RRXA991227Ffloorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSEALAGE, CABIN FLOOR PLANK BETWEEN STA 580 AND STA 700 AT BL 36 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM SDR AALA990602Floorbeam · corrodedTUL - FOUND TOP OF FLOORBEAM AT BS 380 IS CORRODED FROM RBL 48 TO 64 RBL. FLOORBEAM REPAIR COMPLETE AFT FLANGE OF UPPER CHORD STATION 380 RBL 48 TO 65 AS PER AARD 53-10-07-02 PAGE 1-3 FIG 1. (M)SDR QXEA9900909Floorbeam · crackedPDX - FLOORBEAM BL1127R WL-560 FROM FRAME 3450 TO FRAME 3820 IS CRACKED IN TWO SPOTS. REPAIRED IAW FOKKER SRM 53-01-01 (3)(A) AND SRM 53-02-01, FIGURE 5.SDR ASAA9910063Floorbeam · corrodedPHX - DURING D-CHECK, FOUND THE FLOORBEAM END CAP UPPER SURFACE CORRODED AT STATION 420, LBL 60. REPAIRED PER EA 5310-01658. (M)SDR ASAA9910062Floorbeam · corrodedPHX - DURING D-CHECK, FOUND THE AFT CARGO COMPARTMENT FLOORBEAM LOWER SURFACE CORRODED AT STATION 787, LBL 20 TO LBL 24. REPAIRED PER EA 5310-01656. (M)SDR ASAA9910061Floorbeam · corrodedPHX - DURING D-CHECK, FOUND THE FLOORBEAM LOWER CAP, LOWER SURFACE, FORWARD FLANGE CORRODED AT STATION 500B BETWEEN LBL 25 AND LBL 45. REPAIRED PER EA 5310-01655. (M)SDR ASAA9910052Floorbeam · corrodedPHX - DURING D-CHECK, FOUND TEH MAIN CABIN FLOORBEAM CORRODED AT STATION 727B FROM RBL 25 TO RBL 60, LBL 45 TO LBL 60. REPAIRED PER SRM 51-30-2. (M)SDR ASAA9910049Floorbeam · corrodedPHX - DURING D-CHECK, FOUND THE FLOORBEAM CORRODED AT STATION 328, RLB 73. REPAIRED PER SRM 51-10-6 AND 53-10-9. (M)SDR ASAA9910044Floorbeam · corrodedPHX - DURING D-CHECK, FOUND THE FLOORBEAM CORRODED AT STATION 520, LBL 45 TO RBL 60. REPAIRED PER SRM 51-30. (M)SDR ASAA9910042Floorbeam · corrodedPHX - DURING D-CHECK, FOUND THE FORWARD CARGO COMPARTMENT FLOORBEAM LOWER FLANGE CORRODED AT STATION 460, LBL 24 TO LBL 44. REPAIRED PER EA 5310-01663. (M)SDR ASAA9910041Floorbeam · corrodedPHX - DURING D-CHECK, FOUND THE MAIN CABIN FLOORBEAM CORRODED ON THE UPPER CAP AT STATION 967, RLB 8 TO RBL 45. REPAIRED PER EA 5310-01662. (M)SDR ASAA9910038Floorbeam · gougedPHX - DURING D-CHECK, FOUND THE FLOORBEAM GOUGED AT STATION 294.5, LBL 10 TO RBL 50. REPAIRED PER SRM 53-10-09. (M)SDR UPS99229553Floorbeam · corrodedINSPECTION TYPE:SI, CORROSION (C53-224-01.05-02) ON FLOORBEAM UPPER CHORD BS 846 THRU 842, LBL 44, WL 208. REPAIRED ER 99-5239.SDR SWAA990576Floorbeam · corrodedDURING SCHEDULED 1/2D CHECK, FOUND CORROSION ON NUT PLATE HOLES AT FLOORBEAM BS 312, LBL 20 - LBL 45. REPAIRED PER SRM.SDR CALA9900328Floorbeam · crackedINSPECTION FOUND A 3 INCH CRACK IN FORWARD CARGO COMPARTMENT OVERHEAD FLOORBEAM AT STA 237, LBL 8. THE CRACKED AREA WAS CUT OUT IAW SRM 53-05, PAGE 216A. A DOUBLER AND REPAIR ANGLES WERE INSTALLED IAW SRM 53-05, PAGE 216A.SDR AWXA9900157Floorbeam · corrodedFLOORBEAM UPPER CHORD CORRODED RBL 6 TO RBL 52 AT STA 294.5. FABRICATED T-CHORDS AND REPAIRED AS PER AWA ER 3-53-1529 INSTRUCTIONS.SDR AWXA9900156Floorbeam · corrodedCORROSION AROUND SCREW HOLES TOP AND BOTTOM OF UPPER TEE CHORD RBL 21-56, FRAME STA 328 RT. FABRICATED T-CHORD AND REPAIR AS PER AWA ER 3-53-1529 INSTRUCTIONS.SDR SWAA990569Floorbeam · misdrilledDURING SCHEDULED D-CHECK, FOUND FLOORBEAM AT BS 967 WITH AN OBLONG HOLE THRU UPPER CHORD, RBL 51.5, WL 208. REPAIRED BEAM PER SRM.SDR SIMA990841Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND FLOORBEAM 38 AND 39 CORRODED. REMOVED AND REPLACED BOTH FLOORBEAMS IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (M)SDR RRXA991242Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE,CABIN FLOOR PLANK BETWEEN STA 1240 AND STA 1280 AT BL 12 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLESDR RRXA991241Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK AT STA 1220 AND BL 18 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53-2-3 PGS 39/4SDR RRXA991240Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1120 AND 1140 AT BL 12 RIGHT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED DOUBLER IAW DC8 SRM 53-2-3 FISDR RRXA991239Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1040 AND STA 1060 AT BL 32 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM SDR RRXA991238Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION , FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 1100 AND STA 1120 AT BL 32 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRMSDR 99ZZZM249Floorbeam · corrodedSAW - DURING CPCP-4 INSPECTION, FOUND FLOORBEAM 38 AND 39 CORRODED. REMOVED AND REPLACED BOTH FLOORBEAMS IAW SRM 51-25-02. AIRCRAFT RETURNED TO SERVICE. (M)SDR UPS99229344Floorbeam · corrodedINSPECTION TYPE:C+SI, LIGHT SURFACE CORROSION ON TOP FLOORBEAM CAP BS 344 LBL 25.75 TO 0. REPAIR CARRIED OUT IAW SRM 53-10-8 FIG 7.SDR RRXA991243Floorbeam · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION, FUSELAGE, CABIN FLOOR PLANK BETWEEN STA 717 AND STA 759 AT BL 36 LEFT. DAMAGE EXCEEDED LIMITS IAW DC-8 SRM. REMOVED DAMAGED, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR DOUBLER IAW DC8 SRM 53SDR LR7A9981Floorbeam · corrodedDURING SCHEDULED C1 INSPECTION PER HSP53161, FOUND FS 257 FLOORBEAM CAP CORRODED AROUND ANCHOR NUT LOCATION AT WL 146, RBL 43. REPLACED FLOORBEAM CAP IAW SMP 583-53-40-01.SDR 99ZZZX1751Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 720L, STR 27.SDR CALA9900307Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 947.5, RBL 24 TO LBL 17. A REPAIR WAS INSTALLED IAW SRM 53-60-51.SDR AT9900261Floorbeam · corrodedSCHEDULED INSPECTION AT AERO CORP, FL. FOUND THE FLOORBEAM AT BS 965 LBL 35 CORRODED. FABRICATED NEW FLOOR SUPPORT FITTING AND INSTALLED IAW DC9 SRM 53-11-3.SDR ABXA9900264Floorbeam · corrodedDURING C-CHECK, FOUND FLOORBEAM AT STATION 313 EXFOLIATED FROM BL 0 TO LBL 14. REPAIRED IAW REA D953-27121MR.SDR UPS99229093Floorbeam · corrodedINSPECTION TYPE:C CORROSION ON FLOORBEAM TOP FLANGE BS 344 LBL 14 - RBL 12 WL 208. REMOVED AND REPLACED FLOORBEAM UPPER CHORD PER SRM 53-10-8 FIG 9.SDR CALA9900301Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CAP IN FORWARD GALLEY AREA CORRODED AT STA 328. A FLOORBEAM REPAIR WAS INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR C2XA99IA200Floorbeam · corrodedIAH - DURING C-CHECK INSPECTION, THE LEFT FLOORBEAM AT FRAME TWENTY WAS FOUND TO BE CORRODED. MAINTENANCE REPAIRED THE DAMAGED SECTION OF FLOORBEAM IAW WITH CONTINENTAL EXPRESS ENGINEERING CHANGE/REPAIR AUTHORIZATION EC5310-01101, AND THE AIRCRAFT WAS APPROVESDR RAAA99B2021Floorbeam · gougedDURING SCHEDULED C CHECK, FOUND FLOORBEAM UPPER CHORD FORWARD FLANGE LOWER SURFACE GOUGED AT BS 600 AND LBL 2. BLENDED FLOORBEAM UPPER CHORD FWD FLANGE LOWER SURFACE IAW SRM 53-10-01.
Back to JASC 5315