JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 = '5310' 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 = '5310' 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 FDEA201010254161Crossbeam · damagedFWD CARGO COMPARTMENT - CROSSBEAM UPPER FLANGE AT FR25 DAMAGED BTW Y480 & Y- 480. CROSSBEAM WAS REPAIRED IAW SRM 53-10-15 FIG 207.SDR DALA1030089016Fitting · corrodedAFT CARGO DOORWAY AFT FRAME LOWER CORNER FITTING CORRODED. REPLACED FITTING (DLM88102969).SDR DALA1031999853Window Frame · crackedDURING M-CHECK FOUND CABIN/ WINDOW FRAME CRACKED BETWEEN STA 794 AND 813 (WINDOW 31L) AT TOP FWD FASTENER. REMOVED DAMAGE AT STA 794-813 IAW 53-05 FIG 122, NDT GOOD, FABRICATED PART 7075-T3 PO 0922430 IAW 53-05, ALODINED, PRIMED REPAIR IAW 51-10-3, INSTALLED SDR CA101025001Structure · crackedDURING A 100 HR INSP, IT WAS DISCOVERED THE THERMOSTATIC OIL COOLER DOOR WAS CRACKED ON BOTH ENDS AND A SHEARD RIVET ON THE RT END. THE COOLER DOOR IS CONTROLLED BY A THERMOSTATIC VALVE INSTALLED IN THE OIL COOLER AND OPENS AND CLOSES TO MAINTAIN PROPER OIL TSDR AALA20101022TUL07Pan · crackedLEFT WINDOW RING PAN UPPER AFT CORNER FORWARD OF STATION 1022 CRACKED. INSTALLED DOUBLER PER AARD 53-10-00-25.SDR DALA1028799865Door Frame · damagedDURING M CHECK FOUND AFT PRESSURE BULKHEAD DOOR JAMB FRAME UPPER FRAME FLANGE HAD 2 MISLOCATED HOLES. REPAIRED PER SRM 51-70-5 FIGURE 1, SRM 51-10-4, SRM 51-10-3 DWG 5917463 REV N, SRM 51-30-5, SRM 51-20-0.SDR FDEA201010214138Structure · damagedSMOKE DETECTOR CUT OUTS INCORRECTLY LOCATED AT STA'S 1620, STA 1640 AND STA 1661, LBL 28.25. A REPAIR WAS ACCOMPLISHED ON STAM EA-757-5365-16-F2884, FOR THE SMOKE DETECTOR CUT OUTS INCORRECTLY LOCATED AT STA 1620, 1640, AND 1661, LBL 28.25. AN 8110-3, DATED SDR SWAA106527Crease Beam · corrodedDURING SCHEDULED 14Y CHECK, FOUND RT CREASE BEAM CORRODED AT BS 986.5. REMOVED AND REPLACED BEAM PER BAC DWG.SDR FDEA201010214130Crease Beam · corrodedCORROSION REPAIR ON CREASE BEAM CARRIED OUT IAW EA F-5310-137687 REV A. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR FDEA201010204118Door Frame · misrepairedEXISTING REPAIR - AFT CARGO DOOR AFT JAMB AT STA 1964, LONGERON 39 TO 42 LT. EXISTING REPAIR AT AFT CARGO DOOR AFT JAMB AT STA 1964, LONGERON 39 TO 42 LT EVALUATED AND FOUND PREVIOUSLY ACCOMPLISHED IAW SRM 53-00-15, FIG 203, REPAIR 8 REV 44. HOWEVER, REPAISDR DALA1028970903Door Frame · corrodedEXFOLIATION CORROSION ON LWR DOOR JAMB BETWEEN STA X=17 TO -17 AT AFT ENTRY DOOR JAMB STA 1350. REPAIRED PER ERA 485913 REV ORG. (DLM88102874)SDR ASOA201001634Crossbeam · corrodedCROSSBEAM FOUND TO BE CORRODED AT RT AND LT SIDE PANEL NUTPLATE LOCATIONS. INSTALLED 5 EA RIVETS CROSSBEAM IAW SRM 51-42-06-001-001-A01. RESTORED A023 FINISH IAW SRM 51-21-16-001-001-A01. APPLIED CIC AT REPAIRED AREA IAW SRM 51-21-11-001-001-A01.SDR ASOA201001629Frame · corrodedFRAME HAS CORROSION AT FS 310 AND BETWEEN STR 27 AND 26L. REMOVED COATINGS AND CORROSION IAW SRM 51-21-00-001-A01. BLENDED CORRODED AREAS IAW SRM 51-21-00-001-A01. PERFORMED UT THICKNESS MEASUREMENT ON BLEND AREA IAW MAC NDT INSP PROCEDURE UT-3 MINIMUN MATSDR ASOA201001627Intercostal · corrodedCORROSION ON INTERCOSTAL AT FS 364 AND STR 27RT. REMOVED CORROSION FROM INTERCOSTAL IAW SRM 51-21-00-001-A01, SRM 51-42-06-001-A01. BLENDED AREA FS 364 & STR 27R IS WITHIN ALLOWABLE DAMAGE LIMITS IAW SRM 53-21-23-101-003-A01.SDR AALA20101019TUL06Pan · crackedLEFT WINDOW RING PAN CRACKED UPPER AFT CORNER FORWARD OF STATION 1079. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR AALA20101019TUL05Pan · crackedLEFT WINDOW RING PAN CRACKED UPPER AFT CORNER FORWARD OF STATION 1060. INSTALLED REPAIR ANGLE PER AARD 53-10-00-25.SDR COEA2010101954803Crease Beam · corrodedCOE HEAVY CHECK / LEVEL 2 CORROSION / MAJOR REPAIR: RT CREASE BEAM WEB BETWEEN FRAMES 12 & 13 HAS AREAS OF LEVEL 2 CORROSION (LENGTH 3", WIDTH 2", DEPTH .011") ON TOP AND BOTTOM SURFACES. REMOVED CREASE BEAM WEB, FABRICATED AND INSTALL REPLACEMENT CREASE BEASDR V0XR413Y101910004Crossbeam · crackedBS 280 CROSSBEAM CRACKED. REPLACED CROSSBEAM STA 280 IAW REO 670-53-11-047, REV E.SDR IPXA10563513Floorbeam · corrodedINSPECTION TYPE:C4, FOR RCD PURPOSE SW BS 1200 FLOORBEAM REQUIRES REINFORCEMENT BETWEEN LBL 8 AND RBL 60, WL 208. REPAIRED IAW ER 10-05127, DATED 30OCT2010.SDR FOTR2016911082Door Frame · corrodedCORROSION ON FWD CARGO LOWER FRAME BETWEEN STA 370 TO 435. NR11082 WO20169.SDR CALA2010101800483Door Frame · crackedSUPPORT TASK - FWD PASSENGER ENTRY DOOR AT BS 303.9 FRAME WEB HAS ABOUT 1 INCH CRACK AT STRINGER 16L. INSTALLED DOUBLERS REPAIR IN REF EA 5310-04659 OP.02.SDR IPXA10M63554Torque Box · crackedINSPECTION TYPE:4C, R3 DOOR FWD JAMB TORQUE BOX LIGHTENING HOLE CRACKED. CUT OUT DAMAGE AT R3 DOOR FWD JAMB TORQUE BOX LIGHTENING HOLE. FABRICATED AND INSTALLED REPAIR DOUBLER SRM 53-40-15, REPAIR 3, FIG 201, REV 44.SDR QXEA2010101900656Stop Fitting · corrodedC5 CHECK - FWD FUSELAGE PAX DOOR OPENING, ALL TEN DOOR STOP FITTINGS HAVE AREAS OF MISSING PAINT AND LIGHT CORROSION. REMOVED CORROSION FROM ALL DOOR STOP FITTINGS. AMOUNT OF MATERIAL REMOVED WAS LESS THAN .005, FITTING REQUIRE REPLACEMENT IAW SRM 53-20-23 SSDR AALA20101015TUL03Stop Fitting · crackedAFT CABIN VAULT DOOR OPENING. LOWER LEFT DOOR STOP FITTING IS CRACKED ALONG LOWER RADIUS ON AFT SIDE. NEW FITTING INSTALLED PER SRM 51-01-00.SDR QXEA2010101500612Beam · gougedC4 CHECK - DURING INSP, DISCOVERED 2 GOUGES ON AFT CARGO BAY DOOR STRUCTURE LINTEL. NR1 AT FS 1000 AND NR2 AT FS 1047.00. BLENDED GOUGED AREAS IAW SRM 51-12-00-001-001-A01. FOUND TO BE OUT OF LIMITS, PART IS IN A NO DAMAGE ALLOWED AREA IAW SRM 53-61-23-101-0SDR FDEA201010134038Seat Track · corrodedSEAT TRACK CORRODED, STA 610 TO STA 690, RBL25. REMOVED SEAT TRACK SECTION IAW SRM 51-30-2. FABRICATED NEW SEAT TRACK MATERIAL USED BAC 1520-792-7178-T6511 DIMENSIONS: 17FT AND 30 INCHES IAW SRM 53-10-5 FIG 1. INSTALLED NEW SEAT TRACK RBL 25 BS 480 TO BSSDR N6WA20101001Crossbeam · crackedFS280 CROSSBEAM IS CRACKED. REPAIRED CROSSBEAM 280.00 IAW REO 670-53-11-047, REV E.SDR AALA20101013TUL14Pan · crackedCRACK IN UPPER FORWARD TAB OF CABIN WINDOW PAN STATION 807. REPAIR DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA20101013TUL13Pan · crackedCRACK AT LOWER FORWARD TAB OF CABIN WINDOW PAN AT STATION 1098. REPAIR DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA20101013TUL12Pan · crackedCRACK AT UPPER FORWARD CORNER OF CABIN WINDOW PAN STATION 946. REPAIR DOUBLER INSTALLED PER AARD 53-10-00-25.SDR AALA20101013TUL11Pan · crackedCRACK IN UPPER AFT CORNER OF WINDOW PAN AT STATION 1041 LEFT. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101013TUL10Pan · crackedCRACK IN LOWER FORWARD CORNER OF WINDOW PAN AT STATION 1060 RIGHT. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR AALA20101013TUL09Pan · crackedUPPER AFT CORNER OF WINDOW PAN CRACKED AT STATION 1250 RIGHT. INSTALLED REPAIR DOUBLER PER AARD 53-10-00-25.SDR GTIA1000109Beam · corrodedZ BEAM, LT AT FRAME 68-69 HAS CORROSION. REMOVED LT Z BEAM, 68-69 IAW SRM 51-72-11, 82110. INSTALLED NEW LT Z BEAM, 68-69 IAW SRM 82110. PRIMED AND PAINTED ATTACH POINTS OF NEW BEAM IAW SRM 51-75-12 82095.SDR GTIA1000108Beam · corrodedRT Z BEAM AT FRAME 67-68 HAS CORROSION. REMOVED RT Z BEAM, FRAME 67-68 IAW SRM 51-72-11. INSTALLED NEW RT Z BEAM, FRAME 67-68 IAW SRM 51-72-11. PRIMED AND PAINTED ATTACH POINTS OF NEW BEAM - IAW SRM 51-75-12.SDR GTIA1000106Beam · corrodedRT Z BEAM AT FRAME 68-69 HAS CORROSION. REMOVED RT Z BEAM, FRAME 68-69 IAW SRM 51-72-11. INSTALLED NEW RT Z BEAM, FRAME 68-69 IAW SRM 51-72-11. PRIMED AND PAINTED ATTACH POINTS OF NEW BEAM IAW SRM 51-75-12.SDR FDEA201010124024Web · gougedC-1 DOOR CUTOUT AFT FRAME BS 620 WEB IS GOUGED ON FWD SIDE AT STR 22R BETWEEN DOOR STOPS NR 3 AND NR 4. REMOVED C-1 DOOR AFT FRAME WEB IAW SRM 51-30-2 FABRICATED NEW FRAME WEB FROM 7075 T6 .071" DIM 106" X 6" IAW 53-10-2 FIG 3 AND 51-30-5 INSTALLED NEW FSDR DALA1028980903Door Frame · corrodedC3 CARGO DOOR SURROUND LOWER JAMB BEAM CORROSION. REPAIRED PER ERA 482650-14. (DLM88102878)SDR ASOA201001592Beam · corrodedTRANSVERSE BEAM CAP BETWEEN LBL 9 AND LBL 27 AT APPROX FS 585 HAS MINOR CORROSION. TRANSVERSE BEAM CAP CORROSION UPON INVESTIGATION IS OVER THE LIMIT. REQUIRES REPLACEMENT AND INSTALLATION. REMOVED AND DRILLED NEW BEAM CAP IAW SRM 51-42-06 AND SRM 51-42-21.SDR ASOA201001591Structure · corrodedMINOR CORROSION AROUND VARIOUS NUTPLATE HOLES ON RBL 36 FROM FS 621 TO 559+96. USING NR40 DRILL BIT, REMOVED NUTPLATES FROM THRESHOLD. REMOVED LIGHT CORROSION ON THE SURFACE IAW SRM 41-21-06 3A(1)B(1)(2)(3)(4)(5). REINSTALLED NEW SERVICEABLE NUTPLATES IAW SRSDR SWAA106233Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND CREASE BEAM CORRODED BETWEEN BS 294 TO BS 328, RBL 54. REPAIRED BEAM PER SRM AND BAC DWG.SDR SWAA106231Crease Beam · corrodedDURING SCHEDULED 12Y CHECK, FOUND CREASE BEAM CORRODED AT BS 947.5, RBL 52. REPAIRED BEAM PER SRM.SDR SWAA106154Crease Beam · crackedDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB ATTACHED ANGLE CRACKED AT BS 947.5, STR 17R. REMOVED AND REPLACED ANGLE PER SRM.SDR AALA20101012TUL04Pan · crackedFORWARD LOWER CORNER OF WINDOW PAN CRACKED STATION 1136 RIGHT SIDE. CUT OUT CRACKED AREA. FABRICATED DOUBLER, TREATED, PRIMED, AND INSTALLED DOUBLER PER AARD 53-10-00-25.SDR FDEA201010113991Vertical Beam · damagedMISSED DRILLED HOLES VERTICAL BEAM LBL 20 AFT CARGO PIT BS 1183. REPAIRED MISDRILLED HOLES AT VERTICAL BEAM IAW E.A. 7-5310-135599. REMOVED PREVIOUS STRAP & DOUBLER IAW SRM 51-30-2, TRIMMED OUT BEAM APT FLANGE (DIM: 33 1/4") & WEB (MISDRILLED AREAS, 8 TOTAL),SDR ASOA201001547Post · crackedINDICATION NOTED AT FS 409+128 VERTICAL POST RBL 18, WL 69.00 OTBD CHANNEL 90 PERCENT FULL SCREEN HEIGHT APPROX .25IN LENGTH VERTICALLY. AREA MARKED ON ACFT. REMOVED POST ASSY IAW SRM 51-42-06. INSTALLED POST IAW REO 601R-53-41-889 ITEM 3.SDR ASOA201001546Post · crackedINDICATION NOTED AT FS 409+128 VERTICAL POST BL 0.00 WL 69.00 RT CHANNEL 50 PERCENT FULL SCREEN HEIGHT APPROX .20 IN LENGTH VERTICALLY. AREA MARKED ON ACFT. REMOVED POST ASSY IAW SRM 51-42-06. INSTALLED FS 409+128 BL 0 POST ASSY IAW REO 601R-53-41-889.SDR ASOA201001545Post · crackedINDICATION NOTED AT FS 409+128 VERTICAL POST IN RADIUS OF THE OTBD CHANNEL 95 PERCENT FULL SCREEN HEIGHT APPROX .25IN LENGTH VERTICALLY (LBL 18 WL 69.00). AREA MARKED ON ACFT. REMOVED FS 409+128, LBL 18, POST ASSY & SEPARATED HALVES OF CHANNEL IAW SRM 51-42-0SDR ASOA201001540Crossbeam · corrodedBS 280 CROSSBEAM FOUND TO BE CORRODED AT RT AND LT SIDE FLOOR PANEL NUTPLATE LOCATIONS. FOUND DAMAGED AREA TO BE OUT OF LIMITS IAW SRM. REMOVED CROSSBEAM IAW SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01, 51-42-13-001-001-A01. INSTALLED NEW CROSSBEAM IAW SRMSDR AALA20101012TUL01Pan · crackedFORWARD LOWER CORNER OF WINDOW PANE CRACKED AT STATION 160 RIGHT SIDE. DOUBLER INSTALLED PER AARD 53-10-00-25.
Back to JASC 5310