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 CALA0600091Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 328, RBL 12. THE CHORD WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR UPS06446540Floorbeam · crackedBS 2060 RBL 60 LATERAL FLOOR SUPPORT LWR SUPT ANGLE FOUND CRACKED, CRACK LENGTH 3" AND 2.5". SUPPORT ANGLE REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR CALA0600090Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 344, LBL 9. A DOUBLER WAS INSTALLED IAW SRM 53-10-51.SDR SWAA060931Floorbeam · corrodedDURING SCHEDULED 10Y CHECK, FOUND COCKPIT FLOORBEAM UPPER CHORD CORRODED AT BS 261, BETWEEN LBL 9 TO RBL 10, WL 208. REPAIRED FLOORBEAM PER BFG ER.SDR UPS06146495Floorbeam · bentMAIN CABIN FLOORBOARD CROSSBEAM BENT AT FS 48 RBL 25. REMOVED AND REPLACED CROSSBEAM PER A300 SRM 51-40-00.SDR SWIA200616882Fitting · crackedSTA 280 RBL 9 BOTH FLOORBEAM CLIPS CRACKED RT SIDE I/B AND O/B, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED 2 ANGLE BRACKETS P/N 601R3113-58 IAW CRJ200 SRM 51-42-13;52-42-21 AND STANDARD REPAIR 601R 53-0057A.SDR 06FDEA1098Floorbeam · damagedCOMPLY WITH AGING 9-AGING-INSP. PREVIOUS REPAIR INSTALLED ON RIGHT HAND MCD FLOORBEAM AT FR 15A TO FR 16A, FS 1245 TO FS 1267 AND -YB 195.9. UNABLE TO DETERMINE APPROVED REPAIR DATA AT TIME OF AIRCRAFT INSPECTION NEED EVALUATION FOR MAJOR/MINOR CLASSIFICATIOSDR 06FDEA1097Floorbeam · damagedCOMPLY WITH AGING 9-AGING-INSP. PREVIOUS REPAIR INSTALLED ON RIGHT HAND MCD FLOORBEAM AT FR 14 TO FR 14C, FS 1204 TO FS 1232 AND YB 195.9. UNABLE TO DETERMINE APPROVED REPAIR DATA AT TIME OF AIRCRAFT INSPECTION NEED EVALUATION FOR MAJOR/MINOR CLASSIFICATION SDR CALA0600088Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 303, LBL 21-36. REPAIRED IAW SRM 53-00-51, REPAIR 1, FIGURE 201.SDR CALA0600087Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 325, LBL 35-55. REPAIRED IAW SRM 53-00-51, REPAIR 1, FIGURE 201.SDR ASAA0610267Floorbeam · corrodedAFT CARGO PIT FLOORBEAM UPPER CHORD CORRODED. REPAIRED PER WORKCARD 4930579 ERO 5404 AND EA 5330 02503.SDR SWAA060842Floorbeam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CABIN FLOORBEAM CRACKED AT BS 294, LBL 53. REPAIRED FLOORBEAM PER SRM.SDR UPS06446611Floorbeam · crackedBS 660 UPPER DECK FLOORBEAM HORIZ FWD FLANGE FOUND CRACKED AT LBL 67" ONE FASTENER HOLE 0.030" IN LENGTH RUNNING FWD O/B AND AT LBL 79" ONE FASTENER HOLE 0.030" IN LENGTH RUNNING AFT. BS 660 FLOORBEAM HORIZ FWD FLANGE LBL 67" & LBL 79" HOLES REPAIRED AS PER USDR UPS06446609Floorbeam · crackedBS 400 UPPER DECK FLOORBEAM FWD HORIZ FLANGE RBL 13" FASTENER HOLE FOUND CRACKED APPROX 0.040" IN LENGTH RUNNING FWD. BS 400 UPPER DECK FLOORBEAM FWD HORIZ FLANGE RBL 13" REPAIRED AS PER UPS EO# B747-5310-23043 APPENDIX D FIG 9 PLAN C.SDR UPS06446608Floorbeam · crackedBS 600 UPPER DECK FLOORBEAM AFT HORIZ FLANGE FOUND CRACK AT RBL 54, 57 AND 60 APPROX 1/8", 1/8 , 1/16" RESPECTIVELY ALL RUNNING AFT. U/D BS 600 FLOORBEAM AFT HORIZ FLANGE RBL 54, 57 AND 60. REPAIRED AS PER UPS EO NR B747-5310-23043 APPENDIX D FIG 14 PLAN H.SDR UPS06446588Floorbeam · corrodedBS 1170 LBL11 TO RBL11 LATERAL FLOORBEAM FOUND CORRODED. CORROSION BLEND OUT 0.042" BY 3/4" BY 2" EXCEED SRM LIMIT. BS 1170 LBL 11 TO RBL 11 FLOORBEAM REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS06446574Floorbeam · corrodedBS 1253 LBL 11 TO RBL 11 LATERAL FLOOR SUPPORT FOUND CORRODED. CORROSION BLEND OUT 0.045" BY 1.5" BY 2" EXCEED SRM LIMIT. FLOOR SUPPORT REPLACED AS PER SRM 51-10-01 PG9 AND INSTALLED AS PER SRM 51-30-02.SDR UPS06446566Floorbeam · corrodedBS 1200 LBL 78 TIE DOWN FTG FLANGE FOUND CORRODED. CORROSION BLEND OUT 0.037" BY 3/4" BY 1" EXCEED SRM LIMIT. TIE DOWN FTG REPLACED AS PER MM 53-42-00.SDR UPS06446553Floorbeam · corrodedBS 2060 RBL98-116 FLOORBEAM LWR FACE FOUND CORRODED. CORROSION BLEND OUT 0.035" BY 1.5" BY 2" EXCEED SRM LIMIT. FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 1 JUST AT BS 2060 RBL40 TO MOST RT O/B.SDR UPS06446550Floorbeam · corrodedBS 2100 RBL 98-116 FLOORBEAM FOUND HEAVY CORROSION. CORROSION BLEND OUT 0.060" BY 2" BY 3" EXCEED SRM 53-10-01 FIG 1 LIMITS. BS 2100 RBL 22" TO RT MOST O/B FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 1.SDR UPS06446526Floorbeam · corrodedBS 2240 LBL 33 TO 75 FLOORBEAM FOUND CORODED. CORROSION BLEND OUT 0.064" BY 2" BY 3" EXCEED SRM 53-10-01 FIG 1 LIMITS, M/D BS 2240 LBL 13 TO LT O/B FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 1.SDR UPS06446525Floorbeam · corrodedBS 2280 LBL 74-78 FLOORBEAM FOUND CORODED. CORROSION BLEND OUT 0.062" BY 2" BY 2" EXCEED SRM 53-10-01 FIG 1 LIMITS, M/D - BS 2280 LBL 46 TO MOST LT O/B FLOORBEAM REPAIRED AS PER SRM 51-40-04 FIG 1.SDR 06FDEA1048Floorbeam · misdrilledWHILE WORKING ON ATTACHING L-ANGLE FOUND FLOOR BEAM AT BS 720D,WL 208, LBL 64 WITH MISDRILLED HOLE. REMOVED DAMAGE ON FLOORBEAM BS 720D, WL 208, LBL 64 AND REPAIRED IAW FED-EX SR 27-53-034.SDR ASAA0640255Floorbeam · corrodedFLOORBEAM CORRODED. REMOVED CORRODED AREA AND INSTALLED REPAIR PER EA 5310 02591.SDR UPS06446551Floorbeam · corrodedBS 1580 RBL 78-96 FLOORBEAM FOUND CORRODED. CORROSION BLEND OUT 0.093" BY 3/4" BY 1.5" EXCEED SRM 53-10-01 FIG 1 LIMITS. BS 1580 RBL 78 TO RT MOST O/B FLOOR BEAM REPAIRED AS PER SRM 51-40-04 FIG 3.SDR UPS06446637Floorbeam · crackedBS 340 FLOORBEAM UPPER CHORD HORIZONTAL FWD FLANGE 1 HOLE AT LBL 46" CRACKED RUNNING FWD APPROX 3/16" LONG. CHORD REPAIRED AS PER UPS EO NR B747-5320-12407-F APPENDIX D FIG 3 PLAN C.SDR UPS06446610Floorbeam · crackedBS 380 FLOORBEAM UPPER CHORD HORIZONTAL AFT FLANGE HOLE AT LBL 10 CRACKED RUNNING AFT APPROX 0.030" LONG. BS 380 FLOORBEAM UPPER CHORD HORIZONTAL AFT FLANGE LBL 10" REPAIRED AS PER UPS EO NR B747-5310-23043 APPENDIX D FIG 9 PLAN C.SDR 2006UALA00461Floorbeam · corrodedFLOORBEAM CORRODED ON UPPER SURFACE LOCATED AT STA 986.5 FROM RBL 23 TO RBL 45 WL 208. *S/D* REMOVED DAMAGED T-CAP AND FABRICATED REPAIR T-CAP AND INSTALLED PER SRM 53-60-51.SDR 2006UALA00460Floorbeam · corrodedFLOORBEAM UPPER SURFACE CORRODED AT BS 947.5 RBL 25 TO RBL 46 WL 208. REMOVED CORROSION, FABRICATED REPAIR ANGLE & INSTALLED PER MM 53-10-95.SDR 2006UALA00457Floorbeam · damagedTOOLING DAMAGE AT TWO LOCATIONS STA 927 LBL 27 AND LBL 42 ON TOP OF FLOORBEAM. REMOVED DAMAGE AND INSTALLED ANGLE REPAIR PER MM 53-10-95.SDR UPS06446591Floorbeam · crackedRT BS 340 U/D FLOORBEAM AT FRAME CONNECTION AREA 1 FASTENER HOLE CRACK AT FLOORBEAM WEB, CRACK LENGTH 1/16". U/D FLOORBEAM WEB REPAIRED AT BS 340 RBL 48 TO RT MOST O/B AREA AS PER SRM 53-10-07 FIG 11 REFER NRC6117 FOR WORKING DETAIL.SDR UPS06446590Floorbeam · crackedFOUND RT BS 340 U/D FLOORRBEAM AT FRAME CONNECTION AREA HAS 1 HOLE CRACK AT FLOORBEAM WEB, CRACK LENGTH 1/16". FLOORBEAM WEB REPAIRED AT BS 340 RBL 48 TO RT MOST O/B AREA AS PER SRM 53-10-07 FIG 11.SDR UPS06446586Floorbeam · corrodedFTG ATT FLR SUPPORT PLATE AT BS 1780 LBL 55-70 FOUND CORROISON. CORROSION BLEND OUT 0.029" BY 1" BY 1" EXCEED SRM LIMIT. TIE DOWN FTG AND SUPPORT PLATE REPLACED AS PER MM 53-42-00. PART NUMBER : 69B62271-3 / 69B62265-1 / 69B62271-1.SDR UPS06446585Floorbeam · corrodedFLR FTG ATT FLR SUPPORT PLATE AT BS 1820 LBL 50 FOUND CORROSION. CORROSION BLEND OUT 0.055" BY 1.5" BY 1.5" EXCEED SRM LIMIT. SUPPORT PLATE REPLACED AS PER MM 53-42-00.SDR UPS06446565Floorbeam · corrodedFLOOR FTG ATT FLOOR SUPPORT PLATE AT BS 1820 LBL11-30 FOUND CORRODED. CORROSION BLEND OUT 0.020" BY 0.5" BY 0.5" EXCEED SRM LIMIT. FLOOR FTG REPLACED AS PER MM 53-42-00.SDR UPS06446564Floorbeam · corrodedFLOOR FTG ATT FLOOR SUPPORT PLATE FOUND CORROSION AT BS 1860 LBL35. CORROSION BLEND OUT 0.026" BY 0.5" BY 1" EXCEED SRM LIMIT. FLOOR FTG REPLACED AS PER MM 53-42-00.SDR UPS06446563Floorbeam · corrodedFLOOR FTG ATT FLOOR SUPPORT PLATE FOUND CORROSION AT BS 1840 LBL35. CORROSION BLEND OUT 0.034" BY 1" BY 1" EXCEED SRM LIMIT. TIE DOWN FTG REPLACED AS PER MM 53-42-00.SDR UPS06446562Floorbeam · corrodedFLOOR FTG ATT FLOOR SUPPORT PLATE AT BS 1700 RBL35-55 FOUND CORROSION. CORROSION BLEND OUT 0.027" BY 1" BY 3" EXCEED SRM LIMIT. TIE DOWN FTG ASSY REPLACED AS PER MM 20-51-01.SDR UPS06446561Floorbeam · corrodedFLOOR FTG ATT FLOOR SUPPORT PLATE AT BS 1780 RBL60 FOUND CORROSION. CORROSION BLEND OUT 0.024" BY 1.5" BY 1.5" EXCEED SRM LIMIT. TIE DOWN FITTING REPLACED AS PER MM 53-42-00.SDR UPS06446560Floorbeam · corrodedFLT FTG ATT FLR SUPPORT PLATE AT BS1720 LBL65 FOUND CORRODED. CORROSION BLEND OUT 0.021" BY 0.5" 1" EXCEED SRM LIMIT. SUPPORT PLATE REPLACED AS PER MM 53-42-00.SDR UPS06446559Floorbeam · corrodedFLOOR FTG ATT FLR SUPPORT PLATE AT BS 1800 LBL55-60 FOUND CORROSION. CORROSION BLEND OUT 0.020" BY 1" BY 3" EXCEED SRM LIMIT. TIE DOWN FTG REPLACED AS PER MM 53-42-00.SDR UPS06446557Floorbeam · corrodedFLOOR FTG ATT FLR SUPPORT PLATE AT BS 1780 RBL 78 FOUND CORROSION. CORROSION BLEND OUT 0.070" BY 0.5" BY 2" EXCEED SRM LIMIT. FLOOR FTG REPLACED AS PER MM 20-51-01.SDR UPS06446556Floorbeam · corrodedFLOOR FTG ATT FLOOR SUPPORT PLATE AT BS 1800 LBL 55 FOUND CORROSION. CORROSION BLEND OUT 0.023" BY 1" BY 2" EXCEED SRM LIMIT. FLOOR FTG REPLACED AS PER MM 20-51-01.SDR 06FDEA0997Floorbeam · maint errorDOUBLE HOLE BS 400 RBL 12.5 WL 208. *S/D* REMOVED DAMAGED AREA ON FLOORBEAM UPPER CHORD 8.5 INCHES LONG BY 1 INCH WIDE. FABRICATED & INSTALLED REPAIR IAW SRM 51-30-2, 53-10-8.SDR 2006UALA00447Floorbeam · crackedCABIN LONGITUDINAL FLOOR SUPPORT AT LBL45.5 WAS FOUND CRACKED AT THE OUTBOARD FLANGE FASTENER HOLE OF THE UPPER CHORD WHERE THE ASSY IS ATTACHED TO THE BS 727B FLOORBEAM. REMOVED DAMAGED AREA. ACP NDT FOR CRACKS. FABRICATED & INSTALLED TWO STRAPS, FILLER & SSDR YENA200624Floorbeam · corrodedON C4 CHECK, CORROSION ON FLOORBEAM LOCATED PAX CABIN BETWEEN FR 67 AND FR 68 RT Y1292. FLOORBEAM WAS REPLACED LOCATED AT FR 67 TO FR 68 RT Y1292 IAW SRM A-320.SDR ASAA0610251Floorbeam · corrodedFLOORBEAM DOUBLER WEB CORRODED. REPLACED WITH FABRICATED REPAIR PART PER SRM 51-30-02 AND 51-30-5 FIG 3.SDR ASAA0610250Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED PER SRM 51-30-2.SDR ASAA0610249Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT LOWER FLANGE. REPLACED WITH FABRICATED PARTS PER SRM 51-10-1 AND 51-30-02.SDR 06FDEA0991Floorbeam · corrodedMAIN DECK COMPARTMENT FLOOR SUPPORT FOUND WITH CORROSION AT STATION 5-73 RBL 47-75. CORRODED FLOOR SUPPORT AT STATION 5 - 73 RBL 47 - 75 REMOVED AS PER SRM 51-31-01 VOLUME II AND NEW FLOOR SUPPORT INSTALLED AS PER SRM 51-31-01 VOLUME II. NEW FLOOR SUPPORT FA
Back to JASC 5315