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 UPS00434090Shear Tie · crackedINSPECTION TYPE:C, MAIN DECK SHEAR TIE IS CRACKED AT BS 2120 BETWEEN STR 20 AND 22 LT. NEW SHEAR TIE FABRICATED IAW EO100617 AND FITTED IAW SRM 51-30-02.SDR UPS00434087Shear Tie · crackedINSPECTION TYPE:C, MAIN DECK SHEAR TIE IS CRACKED AT BS 2140 BETWEEN STR 20 AND 22 LT. NEW SHEAR TIE FABRICATED IAW EO100617 AND FITTED IAW SRM 51-30-02.SDR AALA20001310Door Frame · corrodedTUL - FOUND CORROSION ON AFT CARGO DOOR JAMB FROM STATION 1158 TO STATION 1209. REMOVED CORROSION AND INSTALLED DOUBLER PER ESO 80559 DATED 7/17/2000. (M)SDR AALA20001296Structure · dentedTUL - FOUND MINOR 2 INCH CIRCULAR DENT AND SURFACE SCATCH 2 FT A HEAD OF AND 1 FT BELOW LEFT PRESSURE RELIEF VALVES. INSTALLED DOUBLER PER SRM 53-04 FIG 38 SHEET 20. (M)SDR MWEA00573Shear Tie · deterioratedFLOORBOARD C-8 HAS DETERIORATED EDGE DISTANCE BY SCREW HOLE LOCATED AT STATION 742. MAINTENANCE REPAIRED EDGE DISTANCE WITH FIBERGLASS REPAIR.SDR RRXA003077Angle · crackedDURING A MAINTENANCE VISIT FOUND A CRACK BEHIND WEB ON THE FRAME ATTACH ANGLE AT STA 1185 AND L21R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, ALODINED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED SDR RRXA003058Door Frame · crackedDURING A MAINTENANCE VISIT FOUND A CRACK TO THE ATTACH ANGLE AT CABIN AFT DOOR JAMB (LOWER) AT STA 1660, 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 51-1-4 AND 51-3-3SDR AALA20001235Shear Tie · crackedTUL - FOUND SHEAR TIE ON AFT SIDE OF 1431 L2-4 LEFT AND RIGHT CRACKED. REMOVED AND REPLACED CRACKED SHEAR TIES LEFT AND RIGHT 1431 PER SRM 51-01. (M)SDR AWXA0000491Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 372 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000490Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 367 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000489Door Frame · crackedINSPECTION C/W, FOUND FRAME 1 AT STA 382 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000488Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 382 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000487Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 418 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000486Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 422 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000485Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 438 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000484Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 458 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000483Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 462 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000482Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 478 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000481Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 482 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000480Door Frame · crackedINSPECTION C/W, FOUND FRAME ANGLE AT STA 488 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000479Door Frame · crackedINSPECTION C/W, FOUND FRAME 2 AT STA 369 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000478Frame · crackedINSPECTION C/W, FOUND FRAME 1 AT STA 369 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000477Door Frame · crackedINSPECTION C/W, FOUND FRAME 2 AT STA 480 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000476Door Frame · crackedINSPECTION C/W, FOUND FRAME 1 AT STA 480 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000475Door Frame · crackedINSPECTION C/W, FOUND FRAME 2 AT STA 440 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000473Door Frame · crackedINSPECTION C/W, FOUND FRAME 1 AT STA 420 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000472Door Frame · crackedINSPECTION C/W, FOUND FRAME 2 AT STA 420 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000471Door Frame · crackedINSPECTION C/W, FOUND FRAME 1 AT STA 460 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR AWXA0000470Door Frame · crackedINSPECTION C/W, FOUND FRAME 2 AT STA 460 CRACKED. REPLACED FRAME (SAME P/N) IAW PEMCO SRM SUPPLEMENT 52-90-1 AND AWA ER 03523000691BW1.SDR COMA0060585Structure · bird strikeBIRD STRIKE AFTER TAKEOFF. C/W BIRD STRIKE INSPECTION. NO DAMAGE FOUND.SDR COMA0060584Structure · bird strikeAIRCRAFT FLEW THRU FLOCK OF BIRDS. C/W BIRD STRIKE INSPECTION. NO DAMAGE FOUND.SDR RRXA003070Splice · corrodedDURING A MAINTENANCE VISIT FOUND CORROSION DAMAGE ON THE FRAME LEG IN THE AFT CARGO COMPT AT STA 1420 AND L34R-L36R, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. /////CORRECTIVE ACTION///// REMOVED DAMAGE, TREATED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTASDR MWEA00556Shear Tie · gougedSHEAR TIE SECTION AT STATION 332 FROM LONGERON 15 RIGHT TO 17 RIGHT HAS SEVERAL GOUGES. FABRICATED AND INSTALLED SHEAR CLIP REPAIR.SDR SWAA001316Crease Beam · crackedDURING SCHEDULED 1/2D CHECK, FOUND CREASE BEAM CRACKED AT HORIZONTAL FLANGE, BS 637 LT SIDE. REPAIRED BEAM PER SRM.SDR USAA001187Beam · corrodedPIT - FOUND BEAM CORRODED 1 INCH BY 4 INCH AREA, 328 LBL 10 UPPER CHORD LOWER SURFACE. CORROSION LEVEL 1, TASK NR C53-107-01. REMOVED AND REPLACED T-CAP PER SRM 53-10-51. (M)SDR CALA0001085Door Frame · corrodedINSPECTION FOUND FORWARD CARGO COMPARTMENT DOOR JAMB CORRODED. REPAIRED IAW SRM 53-05, FIGURE 44.SDR USAASB00190Structure · vibrationPVD - FLT 2851 - ON CLIMB-OUT FROM BOS, AIRCRAFT EXPERIENCED A CONTINUOUS AIRFRAME VIBRATION OF UNKNOWN SOURCE. ATTEMPTS TO ISOLATE THE NATURE OF THE SOURCE WERE NO HELP. THE ONLY IMPROVEMENT WAS WHEN THE AIRCRAFT SLOWED TO 250 KNOTS. CAPTAIN THOUGHT OF DIVSDR AALA20001233Shear Tie · damagedTUL - FOUND INTERIM REPAIR ON SHEAR TIE, STATION 1307 LONGERON 14L SHEAR TIE CRACKED. INSTALLED REPAIR PER ESO 80559 DATED 1/22/97. (M)SDR UPS00434060Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 280 - 300 LT. FORGING REMOVED IAW SRM 51-30-02, CORROSION REMOVED IAW SRM 51-10 -01 & B 56-20-01. CORR REMOVED DEPTH .009. REWORK SPLICED IN SECTION OF Z-STRINGER 22 LT IAW QUERY NOTE 10/200.SDR SWAA001288Crease Beam · crackedDURING SCHEDULED D-CHECK, FOUND I/B CREASE BEAM CRACKED AT TWO PLACES, BS 520, RBL 64. REPAIRED CREASE BEAM PER SRM.SDR UPS00434045Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 880 - 900 RT. FORGING REMOVED IAW SRM 51-30-02. CORROSION REMOVED IAW 51-10-01 & 56-20-01 CORR DEPTH .008. BLEND OUTS AND HOLES OVERSIZED, NDT INSP ACCOMP IAW QUERY NOTE 64/2000. FORGING REFITTED IAW SDR UPS00434044Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING AT BS 860 - 880 RT SIDE CORRODED. REWORK OF WINDOW FORGING REMOVED IAW SRM 51-30-02 CORROSION REMOVED IAW SRM 51-10-01 & 56-20-01. DEPTH OF CORR .008. CORR AND HOLES REWORKED IAW QUERY NOTE 19 /2000 HOLES O/SIZED ANSDR UPS00434042Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORROSION FOUND BS 1020 - 1040 LT. FORGING REMOVED IAW SRM 51-30-02. CORR REMOVED IAW SRM 51-10-01 & 5 6-20-01. DEPTH OF CORR .008. BLEND OUTS AND HOLE REWWORK O/SIZE AND NDT INSP IAW QUERY NOTE 64/2000. FORGING SDR UPS00434037Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 920 - 900 RT SIDE. FORGING REMOVED IAW SRM 51-30-02. CORROSION REMOVED IAW SRM 51-10-01 & 56-20-01. CORR DEPTH .008. BLEND OUTS AND HOLE REWORK O/SIZE AND NDT INSP IAW QUERY NOTE 17/2000. FORGING RE-ISDR UPS00434002Forging · 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 = .068. FORGING RE-INSTALLED IAW SRM 51-30-02 AND QUERY NOTE 29/2000. CORROSIONSDR UPS00434001Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 1500 TO BS 1520 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 PER SRM 51-30-02 AND QUERY NOTE 46/2000. BLEND OSDR UPS00433993Forging · 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. BLEND OSDR UPS00433992Forging · crackedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AB BS 1460 TO BS 1480 RT. FORGING REMOVED IAW SRM 51-30-02. CORROSION REMOVED AND FORGING FOUND CRACKED. NEW FORGING FITTED IAW SRM 51-30-02 AND QUERY NOTE 65/2000. BLEND OUT ALL CORROSION AND OVERSIZE HOLESSDR UPS00433985Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 2180 TO BS 2200 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 UPS00433984Forging · corrodedINSPECTION TYPE:C, CABIN WINDOW FORGING CORRODED AT BS 2060 TO BS 2080 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 O
Back to JASC 5310