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 QXEA200601940Floorbeam · corrodedPDX C3 AFT AFT CARGO PIT AFT FLOOR FORWARD RIGHT SIDE OF RIGHT BEAM, ANGLE CORROSION, APPROXIMATELY X784 AND YR11.0. REPAIRED IAW DHC-8-400 SRM 51-21-00-350-001, 51-40-15-330-801 AND SRM 51-42-05-330-801.SDR QXEA200601939Floorbeam · corrodedPDX C3 AFT CARGO PIT AFT FLOOR FORWARD RIGHT SIDE OF BEAM ANGLE CORROSION APROXIMATELY X784 AND YL8.0. REPARIED IAW DHC-8-400 SRM 51-21-00-350-001 AND 51-42-05-330-801.SDR UPS06447475Gusset · crackedRT BS 520 UPPER DECK FLOORBEAM FWD FLANGE AREA 2 FASTENER HOLES FOUND CRACK AT GUSSET AT RBL 35 AND RBL 39.5 (CRACK LENGTH 0.060"). U/DECK BS 820 RBL 31" TO RBL 40" GUSSET REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS06247375Floorbeam · corrodedINSPECTION TYPE-C AND SI CORROSION ON UPPER SURFACE OF FLOORBEAM UPPER FLANGE REPAIR AT BS 560 LBL 37. CORROSION REMOVED IAW SRM 51-10-6 AND FOUND TO BE OUT OF LIMITS. REPA IR STRAP REMOVED, NEW REPAIR STRAP FABRICATED IAW SRM 51-20-1. REPAIR STRAP REPROTESDR 06FDEA2539Floorbeam · corrodedFLOORBEAM CAP CORRODED FS 1110 AT LBL 67 MAIN CABIN. REMOVED DAMAGE, FABRICATED, ALODINED, PRIMED AND INSTALLED FLOORBEAM CAP REPAIR ALL IAW FX B727-200 SRM 53-10-1 FIG 4A, 53-10-8 FIG 3, 51-10-2, 51-30-2.SDR UPS06447661Floorbeam · corrodedBS 520 LBL 33-47 FLOORBEAM FOUND CORROSION AS MARKED. CORROSION BLEND OUT 0.051" BY 1.5" BY 2" EXCEED SRM 53-10-01 FIG 1 LIMITS, AND U/D BS 520 FLOORBEAM UPPER CHORD REPAIRED AS PER HX RS NR R53-25-35537 REFER NRC NR IB70247 FOR WORKING DETAIL AND REF UPS EO SDR UPS06447473Floorbeam · corrodedBS 480 LBL 10- RBL 32 FLOORBEAM UPPER FACE FOUND CORRODED. CORROSION BLEND OUT 0.021" BY 1" BY 2" EXCEED SRM 53-10-01 FIG 1 LIMITS, U/D BS 480 LBL 10" - RBL 32" FLOOR SUPPORT REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR UPS06447414Floorbeam · corrodedBS 540 LBL 9-27 FLOORBEAM FOUND CORROSION AS MARKED. CORROSION BLEND OUT 0.020" BY 1.5" BY 1.5" EXCEED SRM 53-10-01 FIG 1 LIMITS, U/D BS 540 BL 0" TO LBL 35" FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 53-10-07 FIG 21.SDR AWXA200601386Floorbeam · corrodedMCN - FOUND CORROSION ON TOP OF BS 294 FLOORBEAM AT LBL 11. MAINTENANCE BLENDED CORROSION ON TOP OF BS 294 FLOORBEAM AT LBL 11, FOUND TO BE OUT OF LIMITS IAW B737-300 SRM 53-10-13-1A FIG 101. REPAIRED BEAM FROM RBL 12 TO LBL 20 IAW 737-300 SRM 53-10-51-2R FISDR HALA0600659Floorbeam · corrodedCORROSION (767-3-229003) STA 347 FLOORBEAM CORRODED BL 0 TO RBL 55 WL 208. FOUND CORROSION TO BE OUT OF LIMITS, PER SRM 53-00-51. REPAIRED FLOORBEAM AT BS 347, BC 0 TO RBC 34 IAW SRM 53-00-51-22-1. CORROSION .0%. 100% NEW MATERIAL, ORIGNINAL THICKNESS IS .0SDR UPS06447506Floorbeam · corrodedINSPECTION TYPE:C AFT CARGO COMPT LT STA1540 IN BETWEEN LBL 32 AND LBL 45 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.046" BY 1.5" BY 8". AFT CARGO COMPT LT STA 1540 IN BETWEEN LBL 16 TO LT O/B FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40SDR UPS06447503Floorbeam · corrodedINSPECTION TYPE:C AFT CARGO COMPT RT STA1500 IN BETWEEN RBL 30 AND RBL 32 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.033" BY 1" BY 6". AFT CARGO COMPT BS1500 FLOORBEAM UPPER CHORD AT RBL 11 TO RBL 60 AREA REPAIRED AS PER SRM 51-40-04 FIG 2.SDR UPS06447502Floorbeam · corrodedAFT CARGO COMPT LT STA 1760 IN BETWEEN LBL45 AND LBL 58 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.035" BY 2" BY 3". AFT CARGO COMPT BS 1760 LBL16 TO LT MOST O/B FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 2.SDR UPS06447500Floorbeam · corrodedAFT CARGO COMPT LT STA1560 IN BETWEEN LBL32 AND LBL45 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.033" 1/2" BY 8". AFT CARGO COMPT STA 1560 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 2 JUST BETWEEN LBL 16 AND LT MOST O/B AREA.SDR 0601636743Floorbeam · crackedDURING "H" CHECK FOUND CRACK IN UPPER DECK FLOORBEAM ATTACHMENT HOLE AT BS 380. REPAIRED PER EA 67-206280.SDR ASAA0680742Floorbeam · corrodedCABIN FLOORBEAM CORRODED. REPLACED SUPPORT PER SRM 51-30-2.SDR UPS06447674Frame · crackedINSPECTION TYPE:C RT BS 340 UPPER DECK FLOORBEAM UPPER CHORD AREA 1 FASTENER HOLE FOUND CRACKED AT FRAME WEB LAYER THROUGH THICKNESS, CRACK LENGTH 3/32". CABIN U/D BS340 RT FRAME WEB AT WL310 AREA REPAIRED AS PER SRM 53-10-04 FIG 102 AND RS R53-10-35527 REPEASDR UPS06447487Floorbeam · corrodedINSPECTION TYPE:C FWD CARGO COMPT STA 660 IN BETWEEN LBL 7 AND RBL 7 FLOORBEAM UPPER CHORD ATT PLATE FOUND CORROSION. CORROSION BLEND OUT 0.060" BY 1/2" BY 1.5" EXCEED SRM LIMIT. FWD CARGO COMPT BS 600 LBL 7 TO RBL 7 FLOORBEAM UPPER CHORD ATTACH PLATE REPLACSDR UPS06447485Floorbeam · corrodedINSPECTION TYPE:C FWD CARGO COMPT STA 640 BL0 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.090" BY 3/4" BY 1 1/4" EXCEED SRM LIMIT. FWD CARGO COMPT BS 640 LBL12.5 TO RBL 14 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG2.SDR UPS06247461Floorbeam · corrodedINSPECTION TYPE:C CORROSION ON FLOORBEAM TOP CHORD BS 950 RBL 51-56. CORROSION REMOVED AND FOUND OUT OF LIMITS IAW SRM 51-10-06 AND 53-1001. FLOORBEAM TOP CHORD REPLACED IAW SRM 51-30-02.SDR UPS06247430Floorbeam · corrodedINSPECTION TYPE:C CORROSION ON FLOORBEAM TOP CHORD BS 420 RBL 52-55. SPLICE ANGLE AND FILLER INSTALLED IAW SRM 53-10-8.SDR UPS06247369Floorbeam · corrodedINSPECTION TYPE-C AND SI CORROSION ON FLOORBEAM TOP CHORD BS 328 LBL 27-31 CORROSION FOUND TO BE OUTSIDE LIMITS IAW SRM 53-10-1. NEW FLOOBEAM TOP CHORD FABRICATED, PAINTED AND INSTALLED IAW MM 51-21-90 AND SRM 53-10-8.SDR UPS06247368Floorbeam · corrodedINSPECTION TYPE-C AND SI CORROSION ON FLOORBEAM TOP CHORD BS 344 LBL 16-23 CORROSION FOUND TO BE OUTSIDE LIMITS IAW SRM 51-10-6. FLOORBEAM TOMP P CHORD FABRICATED, PAINTED AND INSTALLED IAW SRM 53-10-08 AND MM 51-21- 90.SDR SWAA062351Floorbeam · crackedDURING SCHEDULED 18Y CHECK, FOUND LONGITUDINAL FLOORBEAM CRACKED AT BS 727B, RBL 24. REPAIRED FLOORBEAM PER ER.SDR SWAA062345Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOORBEAM CORRODED AT BS 360 RBL 65 TO RBL 70.5. REMOVED AND REPLACED FLOORBEAM WEB PER SRM.SDR MALA060459Floorbeam · corrodedFLOORBEAM FRAME, AT FS 272, AND RBL 14.0, IS CORRODED OUT OF LIMITS. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO NR S53108. REF: EAMS WORK ORDER 21413 TASK 1502.SDR AWXA200601260Floorbeam · corrodedSAL - MAJOR REPAIR - CHECK NR BC-4 NO NR. 5945288. CORROSION LOCATED ON FLOORBEAM - Y 765 PASSENGER CABIN FRAME 64 + 10". FLOORBEAM WAS REPLACED IAW SRM A319 51 - 42 - 11 AND 51 - 72 - 11 LOCATED BETWEEN FR 64 TO FR 66 - Y 765 PASSENGER CABIN FLOOR STRUCTURE.SDR SWAA062298Floorbeam · corrodedDURING SCHEDULED 18Y CHECK, FOUND FLOOR SUPPORT UPPER CHORD CORRODED AT BS 269 TO BS 270, RBL 11 TO LBL 7. REMOVED AND REPLACED FLOORBEAM UPPER CHORD SECTION PER SRM.SDR A6WA200640278Floorbeam · corrodedFOUND RIGHT SIDE FS 621 FLOOR SUPPORT ANGLE IS CRACKED APPROX .7 INCH LONG. MAINTENANCE CUT AWAY DAMAGE SECTION OF RIGHT 621 FLOOR SUPPORT ANGLE TRIMMED TO FIT P/N 601R53-61-117-2, 601R53-61-117-4, 601R53-61-117-6, AND DRILLED IAW REO 601R-53-61-117. (M)SDR UPS06447508Floorbeam · corrodedAFT CARGO COMPT RT STA 1760 IN BETWEEN RBL 7 AND RBL 25 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.025" BY 1.5" BY 10". AFT CARGO COMPT BS 1760 BETWEEN LBL 16 TO RBL 16 FLOORBEAM UPPER REPAIRED AS PER SRM 51-40-04 FIG 2 RBL 16 TO RBL 25 CORSDR UPS06447507Floorbeam · corrodedAFT CARGO COMPT LT STA1820 IN BETWEEN LBL 12 AND LBL 24 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.025" BY 1.5" BY 2". AFT CARGO COMPT BS 1820 LBL 12.5 TO LBL 14 AREA FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG2 AND FLOORBEAM UPPSDR UPS06447505Floorbeam · corrodedINSPECTION TYPE:C AFT CARGO COMPT RT STA 1620 IN BETWEEN RBL32 AND RBL45 FLOORBEAM CHORD FOUND CORROSION. CORROSION BLEND OUT 0.024" BY 1.5" BY 1.5". AFT CARGO COMPT RT STA 1620 IN BETWEEN RBL 32 AND RBL 45 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 SDR UPS06447504Floorbeam · corrodedAFT CARGO COMPT RT STA1600 IN BETWEEN RBL 32 TO RBL45 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.030" BY 1" BY 2". AFT CARGO COMPT RT STA1600 COR BLEND OUT OF LIMIT UPPER CHORD FROM RBL 36-38 REPAIRED AS PER SRM 51-40-04 FIG 2 RBL32-36 AND SDR UPS06447501Floorbeam · corrodedAFT CARGO COMPT, LT STA1500 IN BETWEEN LBL30 AND LBL45 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.024" BY 1" BY 6". FLOORBEAM UPPER CHORD AT STA 1500 LBL 28 TO MOST O/B REPAIRED AS PER SRM 51-40-04 FIG 2.SDR UPS06447499Floorbeam · corrodedINSPECTION TYPE:C AFT CARGO COMPT RT STA1740 IN BETWEEN RBL32 AND RBL45 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.028" BY 1" BY 1.5". AFT CARGO COMPT BS 1740 AT RBL 34-35.5 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG 2 AND RBL 3SDR UPS06447489Floorbeam · corrodedINSPECTION TYPE:C FWD CARGO COMPT RT STA 800 IN BETWEEN RBL 32 AND RBL 45 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.033" BY 5/8" BY 2" EXCEED SRM LIMIT. FWD CARGO COMPT RT STA 800 IN BETWEEN RBL 18 AND RT O/B FLOORBEAM UPPER CHORD REPAIREDSDR UPS06447488Floorbeam · corrodedINSPECTION TYPE:C FWD CARGO COMPT STA 640-650 BL 0 FLOORBEAM UPPER CHORD ATT PLATE FOUND CORROSION. CORROSION BLEND OUT 0.063" BY 1/2" BY 3/4" EXCEED SRM LIMIT. FWD CARGO COMPT BS 640-650 LBL5-RBL5 FLOORBEAM UPPER CHORD ATTACH PLATE REPLACED AND INSTALLED ASSDR UPS06447486Floorbeam · corrodedINSPECTION TYPE:C FWD CARGO COMPT LT STA 860 IN BETWEEN LBL32-45 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.030" BY 3/4" BY 2" EXCEED SRM LIMIT. FWD CARGO COMPT BS 860 LBL 32 TO LT O/B FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-04 FIG2SDR UPS06447484Floorbeam · corrodedINSPECTION TYPE:C FWD CARGO COMPT LT STA 760 IN BETWEEN LBL40 AND LBL45 FLOORBEAM UPPER CHORD FOUND CORROSION. CORROSION BLEND OUT 0.030" BY 3/4" BY 1 3/4" EXCEED SRM LIMIT. FWD CARGO COMPT BS760 LBL40 - LBL45 FLOORBEAM UPPER CHORD REPAIRED AS PER SRM 51-40-SDR AWXA200601267Floorbeam · corrodedSAL - MAJOR REPAIR - CHECK NR BC-4. NR 5945286. CORROSION LOCATED ON FLOORBEAM - Y 1292 PASSENGER CABIN FR 67 + 17" FRAME 68" , AND FRAME 68 + 2" (3 POINT). REWORKED AREAS FOUND OUT OF LIMITS IAW SRM A319 53 - 00 - 14 FIG 102 PAG 106 AND FLOORBEAM - Y 1292 BETSDR AWXA200601257Floorbeam · corrodedSAL - MAJOR REPAIR - CHECK NR BC - 4. NR 5945287. CORROSION LOCATED ON FLOORBEAM Y 1292 PASSENGER CABIN FR 68. (1 POINT). MAINTENANCE REWORKED AREA AND FOUND OUT OF LIMITS IAW SRM A 319 53 - 00 - 14 FIG 102 PAG 106 AND FLOORBEAM Y 1292 BETWEEN FR 68 TO FR 69 WSDR AWXA200601204Floorbeam · corrodedSAL - MAJOR REPAIR - CHECK NO. BC-4. NR NR 5945290. CORROSION LOCATED ON FLOORBEAM Y 1292 PASSENGER CABIN FR 67, FR 67 + 4", FR 67 + 8" (3 POINT). REWORKED AREA FOUND OUT OF LIMITS IAW SRM A319 53 - 00 - 14 FIG 102 PAG 106 AND FLOOR BEAM Y 1292 BETWEEM FR 66 TSDR CALA0600240Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 325, LBL 0-57. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51, REPAIR 1, FIGURE 201.SDR 06FDEA2456Floorbeam · corrodedAFT CARGO COMPARTMENT, FLOORBEAM UPPER CHORD CORRODED AT STA 1902, LONGERON 49R TO LONGERON 49L. CARRIED OUT REPAIR AS PER FEDEX E.A. 1-5310- 100700, REPAIR CLASSIFIED AS MINOR PER GMM 6-2-100.SDR HALA0600617Floorbeam · damagedFOUND FLOORBEAM WORN AT NUTPLATE HOLES STA 654 LBL 22 - 53, WL 200. REMOVED DAMAGE ON UPPER CHORD OF FLOORBEAM STA 654, LBL 22-53 WL 200 PER B767-300 SRM 51-10-02. UPPER CHORD AFT FLANGE FOUND TO BE WITHIN LIMITS PER B767-300 SRM 53-00-51. UPPER CHORD FWD FSDR CALA0600232Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 303, LBL 22-55. THE CORROSION WAS REMOVED AND THE FLOORBEAM WAS REPAIRED IAW SRM 51-10-02 AND SRM 53-00-51, REPAIR 1, FIGURE 201.SDR HALA0600616Floorbeam · damagedFLOORBEAM WORN AT NUTPLATE HOLES STA 1197 RBL 78 WL 200. BLENDED FWD FLANGE OF UPPER CHORD ON FLOOR AT STR 1197 RBL 78 PER B767-300, SRM STEP 5A, FOUND TO BE OUT OF LIMITS PER B767-300 SRM, 53-00-51 DETAIL 2 AND 3, CUT OUT DAMAGE PER B767-300 SRM 53-00-51 FIGSDR HALA0600615Floorbeam · damagedFLOORBEAM WORN AT NUTPLATE HOLES STA 1197 RBL 35 - 53. BLENDED DAMAGE AT NUTPLATE HOLES IAW SRM 51-40-02. BLENDED HOLE AT RBL 35 IN AN AREA OF .08" BY .09 BY .073". REMOVED .012", IN LIMITS, BLENDED HOLE AT RBL 40 IN AN AREA OF .95" BY .70" BY .077". REMOVSDR CALA0600229Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT FASTENER HOLES, STA 986.5, RBL 29-43. REPAIRED IAW ECRA 5321-01372.SDR CALA0600228Floorbeam · crackedINSPECTION FOUND A 1.25 INCH CRACK ON THE TOP EDGE OF FLOORBEAM WEB AT STA 328, BL 0. A REPAIR WAS INSTALLED IAW ECRA 5321-01373.
Back to JASC 5315