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 UPS00433983Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 2000 TO BS 2020 LT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .010. FORGING RE-INSTALLED PER SRM 51-30-02 AND QUERY NOTE 66/2000. BLEND OSDR UPS00433982Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1980 TO BS 2000 LT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .010. FORGING RE-INSTALLED PER SRM 51-30-02 AND QUERY NOTE 66/2000. BLEND OSDR UPS00433981Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 2000 TO BS 2020 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-02 AND 56-20-01. CORROSION REMOVED = .008. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 66/2000. BLENDOUSDR UPS00433980Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1920 TO BS 1940 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .006. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 66/2000. BLEND OSDR UPS00433979Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1820 TO BS 1840 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .005. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 66/2000. BLEND OSDR UPS00433978Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1800 TO BS 1820 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .010. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 66/2000. BLEND OSDR UPS00433977Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1620 TO BS 1640 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .008. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 65/2000. BLEND OSDR UPS00433976Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1600 TO BS 1620 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .010. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 65/2000. BLEND OSDR UPS00433975Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1580 TO BS 1600 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .009. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 65/2000. BLEND OSDR UPS00433974Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1540 TO BS 1560 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .008. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 65/2000. BLEND OSDR UPS00433973Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1520 TO BS 1540 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .007. FORGING RE-INSTALL ED IAW SRM 51-30-02 AND QUERY NOTE 65/2000. BLENDOSDR UPS00433972Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1480 TO BS 1500 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED =.009. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 65/2000 WHICH IS TSDR UPS00433971Forging · crackedINSPECTION TYPE:C, CABIN WINDOW FORGING IS CORRODED AT BS 1460 TO BS 1480 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01. FORGING CRACKED. NEW FORGING FITTED IAW SRM 51-30-02 AND QUERY NOTE 65/2000 WHICH IS TO OVERSIZE HOLES BY SDR UPS00433970Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1394 TO BS 1416 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01 AND 56-20-01. CORROSION REMOVED = .066. FORGING RE-INSTALLL ED IAW SRM 51-30-02 AND QUERY NOTE 29/2000. Q/NOTSDR UPS00433947Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1350 TO BS 1372 RT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01. CORROSION REMOVED = .06. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 40/2000 WHICH IS TO INSTALL TWO SDR UPS00433939Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1416 TO BS 1438 LT. FORGING REMOVED IAW SRM 51-30-02. CORROSION REMOVED IAW SRM 51-10 -01. DEPTH OF CORROSION REMOVED IS .010 IAW SRM 56-20-01 FORGING REFITTED IAW SRM 51-30-02 AND QUERY NOTE 65/2000 WHSDR UPS00433946Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1620 TO BS 1640 LT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01. DEPTH OF CORROSION REMOVED IS .010 IAW SRM 56-20-01. FORGING REFITTED IAW SRM 51-30-02 AND QUERY NOTE 65/2000SDR UPS00433945Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1600 TO BS 1620 LT. FORGING REMOVED IAW SRM 51-30-02 AND CORROSION REMOVED IAW SRM 51-10-01. DEPTH OF CORROSION REMOVED IS .010 IAW SRM 56-20-01. REFIT FORGING IAW SRM 51-30-02 AND QUERY NOTE 65/2000 WHSDR GAIA00399Shear Tie · cutDURING A C-CHECK INSPECTION, FOUND WEB AT BS 1055, WL 208 FOUND CUT. REMOVED AND REPLACED SHEAR TIE WEB PER B727 SRM 51-20-1 AND 51-30-21. (M)SDR GAIA00403Shear Tie · corrodedDURING A C-CHECK INSPECTION, A SHEAR TIE WAS FOUND CORRODED IN THE AFT PIT AREA BS 1010 BETWEEN STRINGER 29R AND STRINGER 30R. REMOVED AND REPLACED ANGLE PER B727 SRM 51-30-2 AND 51-40-3. (M)SDR GAIA00404Shear Tie · corrodedDURING A C-CHECK INSPECTION, A SHEAR TIE WAS FOUND CORRODED IN THE AFT PIT AREA BS 1010 BETWEEN STRINGER 29L AND STRINGER 30L. INSTALLED DOUBLER REPAIR PER B727 SRM 53-10-4, FIG 12. (M)SDR GAIA00405Shear Tie · crackedDURING A C-CHECK INSPECTION, A SHEAR TIE AT BS 321, RBL 30 HAS A SMALL CRACK. REMOVED AND REPLACED SHEAR TIE PER B727 SRM 53-10-4. (M)SDR MWEA00574Shear Tie · crackedCRACK ON SHEAR TIE AT STATION 980, JUST ABOVE LONGERON 16 RIGHT. FABRICATED AND INSTALLED NEW SHEAR TIE.SDR MWEA00580Rib · chafedCHAFE IN STATION 1059 RIB UNDER SOLID LINE STANDOFF. STANDOFF LOCATED AT LONGERON 15 RIGHT. FABRICATED AND INSTALLED REPAIR ANGLE, FILLER, PLATE, HYDRAULIC LINE CLIP, INTERCOSTAL PLATE, INTERCOSTAL FITTING, AND STIFFENER.SDR MWEA00581Rib · chafedCHAFE IN STATION 1076 RIB UNDER SOLID LINE STANDOFF. STANDOFF LOCATED AT LONGERON 15 RIGHT. FABRICATED AND INSTALLED REPAIR PLATE, ANGLE, FILLER, AND SHIMS.SDR ASAA0080442Shear Tie · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON SHEAR TIE, FS 1220, LONGERON 30 TO 29R. REMOVED AND REPLACED SHEAR TIE IAW DC9 SRM 51-30-05. (M)SDR ASAA0080441Shear Tie · corrodedPHX-DURING 30K CHECK CORROSION WAS FOUND ON SHEAR TIE, FS 1211, LONGERON 30 TO 29R.REMOVED AND REPLACED SHEAR TIE IAW DC9 SRM 51-30-05.SDR COMA0060568Structure · bird strikeBIRD STRIKE DURING TAKEOFF. C/W BIRD STRIKE INSPECTION, NO DAMGE FOUND.SDR MWEA00552Door Frame · crackedMKE - FOUND CRACK IN LEFT MAIN LANDING GEAR DOOR JAMB BELOW UPLATCH MECHANISM. MAINTENANCE FABRICATED AND INSTALL REPAIR IAW WITH BOEING STRUCTURAL REPAIR MANUAL 53-01, FIGURE 2, SHEET 4. (M)SDR SIMA2074Structure · corrodedSAW - DURING CPCP-2 INSPECTION, MAINTENANCE FOUND THE RIGHT AFT ZEE MEMBER BETWEEN FRAMES 39 AND 40 CORRODED. MAINTENANCE REMOVED AND REPLACED THE ZEE MEMBER IAW ATR SRM 51-25-03. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR CALA0001054Window Post · crackedINSPECTION FOUND A 1 INCH CRACK IN MAIN CABIN WINDOW FRAME AT UPPER AFT CORNER, STA 1003, LONGERON 11L. THE CRACK WAS STOP DRILLED AND A REPAIR WAS INSTALLED IAW SRM 51-10-03 AND ECRA 5330-02569.SDR RRXA002855Shear Tie · crackedDURING A MAINTENANCE VISIT FOUND A CRACK TO THE SHEAR TIE AT FS 640 AND STR 27R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DC-8 SRM 53-2-0.SDR ABXA000342Shear Tie · crackedEXTRUSION FORWARD OF AFT PRESSURE BULKHEAD T-CAP AT LONGERON 18 LEFT WAS CRACKED AT FLOOR LINE. REPLACED SHEAR TIE ANGLE IAW DC9 SRM 51-30-2.SDR ASAA0080420Service difficultyPHX-DURING 30K CHECK CORROSION WAS FOUND ON SUB FLOOR CUSP WEB, FS 1180, LBL 56.REMOVED DAMAGED MATERIAL AND INSTALLED FILLER AND DOUBLER IAW DC9 SRM 53-14-03.SDR COMA0060554Beam · corrodedTRANSVERSE BEAM AT FS 349 CORRODED BETWEEN LBL 9 AND LBL 27. REPAIRED TRANSVERSE BEAM AT FS 349 IAW WVAC EO 601R-53-1491A.SDR QXEA0001956Structure · gougedPDX- RIGHT HAND AIR CYCLE MACHINE COMPARTMENT, RIGHT HAND NOSE LANDING GEAR BAY SIDEWALL HAS SEVERAL GOUGES BETWEEN AFT UPPER AND LOWER MOUNTS. REPAIRED IAW HORIZON AIR EA 5-53-1266.SDR QXEA0001949Bulkhead · crackedPDX- REAR PRESSURE BULKHEAD, BEAM 1 HAS A CRACK. REPAIRED IAW FOKKER SRM 53-02-18, SRM 51-31-01, AND HORIZON AIR EA 4-53-1251.SDR QXEA0001966Clip · crackedPDX- CRACKED CASTELLATION CLIP, FORWARD SIDE OF OBLIQUE FRAME 50-2 ABOVE STRINGER 27. REPAIRED IAW FOKKER SRM 53-10-5, PAGE 601 AND SRM 51-31-01.SDR QXEA0001946Door Frame · dentedPDX- MIDDLE CARGO DOOR DENT IN AFT APERTURE DOOR FRAME. REPAIRED IAW FOKKER SRM 53-02-16, PAGE 3 AND SRM 51-31-01.SDR USAA000916Stringer Clip · crackedCLT - FOUND TIE CLIP CRACKED .125 INCH, BS 747, STRINGER 7R. REPLACED TIE CLIP PER EO 5393G227. (M)SDR QXEA0001940Frame · corrodedPDX- FRAME 13815B C CHANNEL IS EXFOLIATED ABOVE STRINGER 74. REPAIRED IAW FOKKER SRM 51-31-01, SRM 51-31-05, AND HORIZON AIR EA 4-53-1240.SDR COMA0060553Threshold · corrodedSERVICE DOOR THRESHOLD SILL AT FS 350 HAS SEVERE CORROSION. REMOVED CORRODED SECTION OF SERVICE DOOR THRESHOLD SILL AND INSTALLED REPAIR SPLICE IAW WVAC E.O. 601R-53-1482B.SDR MALA000432Structure · corrodedFOUND DURING C-CHECK, CORROSION AT LBL 18:30 FROM STA 294 TO 363. MAINTENANCE REMOVED CORROSION PER SRM 51-70-40. REMINING MATERIAL IS OUT OF LIMITS STA 294 - 339.SDR MALA000431Structure · corrodedDURING C-CHECK, FOUND CORROSION AT BL 0.0 FROM STA 294.0 TO 363.0. MAINTENANCE REMOVED CORROSION DAMAGE IAW SRM 51-70-40, REPAIR OUT OF LIMIT. REMOVED CORROSION UNDER REPAIR IAW SRM 51-70-10. REMAINING MATERIAL IS OUT OF LIMITS.SDR 00381Flange · drilled throughDISCREPANCY: DURING ROUTINE "C" MAINTENANCE CHECK THE MAIN CARGO DOOR REINFORCEMENT BRACKET DRILLED INTO AT THE INBOARD FLANGE AT BODY STATION 672.0 STRINGER 7 LEFT. CORRECTIVE ACTION: REMOVED AND REPLACED REINFORCEMENT BRACKET IN ACCORDANCE WITH FAA ADVISOR CSDR ABXA000356Shear Tie · crackedSHEAR TIE CRACKED AT STATION 945 BELOW LONGERON 14 LEFT. REPAIRED SHEAR TIE IAW DC9 SRM.SDR COMA0060549Floor Support · crackedFS 621 LEFT FLOOR SUPPORT ANGLE IS CRACKED. REPAIRED I/A/W REO 601R-53-61-117 REV A.SDR C2XA00IA175Crossbeam · crackedIAH - DURING C-CHECK INSPECTION, THE FORWARD GUST LOCK MOUNT STRUCTURE CROSSBEAM WAS FOUND TO BE CRACKED. MAINTENANCE REPAIRED THE BEAM IAW CONTINENTAL EXPRESS ENGINEERING CHANGE AND REPAIR AUTHORIZATION EC5310-01098. (M)SDR QXEA0001835Door Frame · corrodedPDX- SERVICE EMERGENCY DOOR BOTTOM FRAME INTERNAL INBOARD FLANGE HAS CORROSION AROUND RIVETS AND FLANGE EDGE. REPAIRED IAW FOKKER SRM 52-01-01, AND SRM 51-31-01.SDR AALA20001128Door Frame · corrodedTUL - AFT CARGO LOWER DOOR JAMB - CHORD IS CORRODED STA 1155 - STA 1212. REPAIRED AFT CARGO LOWER DOOR JAMB CHORD PER AARD 53-10-00-03. (X)
Back to JASC 5310