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 QXEA0001297Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 36. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001296Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 35. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001295Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 34. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA00001264Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 15205 AND STRINGER 19. REPAIRED IAW FOKKER SRM 53-02-13, FIGURE 2 AND FOKKER SRM 51-31-01 AND FOKKER SRM 53-02-11, FIGURE 1 AND FOKKER SRM 51-10-01, PARAGRAPH 4B, PAGE 9.SDR QXEA0001263Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 15205 AND STRINGER 21A. REPAIRED IAW FOKKER 53-02-13, FIGURE 2 AND FOKKER SRM 51-31-01.SDR QXEA0001262Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 15205 AND STRINGER 28. REPAIRED IAW FOKKER SRM 53-02-13, FIGURE 2 AND FOKKER SRM 51-31-01.SDR QXEA0001261Clip · crackedPDX - CRACKED CLIP AT AFT CABIN FRAME 15205 AND STRINGER 48. REPAIRED IAW FOKKER SRM 53-02-13, FIGURE 2 AND FOKKER SRM 51-31-01.SDR QXEA0001239Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 15205 AND STRINGER 49. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 AND 51-31-01.SDR QXEA0001238Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 15205 AND STRINGER 55. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2 AND 53-02-15 FIGURE 2.SDR QXEA0001237Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 15205 AND STRINGER 58A. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2, AND 53-02-15 FIGURE 2.SDR QXEA0001199Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12875 AND STRINGER 33R. REPAIRED IAW FOKKER SRM 53-02-12 FIGURE 1.SDR QXEA0001195Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 40. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR QXEA0001194Clip · crackedPDX- CRACKED CLIP AT AFT CABIN FRAME 12405 AND STRINGER 42R. REPAIRED IAW FOKKER SRM 53-02-13 FIGURE 2.SDR UPS00832543Pressure Panel · corrodedINSPECTION TYPE:C2, LT WHEEL WELL PRESSURE PANEL IS CORRODED OUT OF LIMITS AT STA 970, LBL8. REPAIRED AREA IAW SRM 53-2-0.SDR USAA000653Tie Clip · crackedCLT - FOUND TIE CLIP CRACKED .25 INCH, BS 597, STRINGER 4L. INSTALLED NEW TIE CLIP PER EO5393G227. (M)SDR AALA2000775Shear Tie · corrodedTUL - FOUND FRAME SHEAR TIE FORWARD SIDE 680 FRAME BETWEEN STRINGER 27R-28R CORRODED. REMOVED CORROSION SECTION OF SHEAR TIE AND INSTALLED REPAIR PER SRM 53-10-4 FIG 15 PAGE 1. (M)SDR AALA2000776Strap · crackedTUL - LFEC SHOWS CRACK IN BEAR STRAP AT LOWER AFT CORNER OF FORWARD RIGHT GALLEY DOOR FRAME. REQUIRES REPAIR PER SERVICE BULLETIN 727-53-0188 FIG 3. REPAIRED AFT LWER CORNER PER BOEING S/B 727-53-0188 FIG 3 AS DIRECTED. (M)SDR USAA000641Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, STATION 767, STRINGER 5 LEFT. REMOVED AND REPLACED PER EO 5393G227. (M)SDR USAA000640Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 747, STRINGER 10 RIGHT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000639Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 747, STRINGER 7 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000638Clip · crackedCLT - FOUND TIE CLIP CRACKED .500 INCH, BS 747, STRINGER 5 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000637Clip · crackedCLT - FOUND TIE CLIP CRACKED .500 INCH, BS 727B, STRINGER 5 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000636Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 727B, STRINGER 8 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000635Clip · crackedCLT - FOUND TIE CLIP CRACKED .50 INCH, BS 727B, STRINGER 6 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000634Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 727A, STRINGER 5R. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000633Clip · crackedCLT - FOUND TIE CLIP CRACKED, BS 706, STRINGER 10 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000632Clip · crackedCLT - FOUND TIE CLIP CRACKED, .250 INCH, BS 706 STRINGER 3 RIGHT. REPAIRED PER EO 5393G227. (M)SDR USAA000631Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 706, STRINGER 2 RIGHT. REPAIRED PER EO 5393G227. (M)SDR USAA000630Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 685, STRINGER 6 RIGHT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000629Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 685, STRINGER 5 RIGHT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000628Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 685, STRINGER 2 RIGHT. REPAIRED PER EO5393G227. (M)SDR USAA000627Clip · crackedCLT - FOUND TIE CLIP CRACKED .500 INCH, BS 663, STRINGER 10 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000626Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 639, STRINGER 6 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000625Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 639 STRINGER 3 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000624Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 639, STRINGER 2 LEFT. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000623Clip · crackedCLT - FOUND TIE CLIP .25 INCH CRACK, BS 616 STRINGER 5 LEFT. REPLACED PER EO 5393G227. (M)SDR USAA000622Clip · crackedCLT - FOUND TIE CLIP CRACKED .25 INCH, BS 616, STRINGER 4 LEFT. REPAIRED PER EO 5393G227. (M)SDR USAA000621Clip · crackedCLT - FOUND TIE CLIP .250 INCH CRACK, BS 616, STRINGER 2R. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR USAA000620Clip · crackedCLT - FOUND TIE CLIP CRACKED .25 INCH, STATION 616, STRINGER 21. REPAIRED PER EO 5393G227. (M)SDR USAA000619Clip · crackedCLT - FOUND TIE CLIP CRACKED .250 INCH, BS 578, STRINGER 101. REMOVED AND REPLACED TIE CLIP PER EO 5393G227. (M)SDR P2EA00145Beam · crackedSJO - DURING C-CHECK, STUD BEAM WEB CRACKED AT BS 597, RBL 48 AND WL 204. REPAIRED STUD BEAM WEB AT BS 297 FROM RBL 45 TO RBL 56 AND BETWEEN WL 200 TO WL 208 IAW SB 737-53-1061 SECTION III PART III PARA B. SEE COOPESA W/O N10316-1-243, VAM100 NR 783, 912SDA1SDR GAIA00251Shear Tie · corrodedDURING HEAVY C-CHECK AT TIMCO/OSC THE FOLLOWING DISCREPANCY WAS FOUND, STATION 328 BETWEEN STRINGER 24R AND STRINGER 25R SHEAR TIE CORRODED. REPAIRED SHEAR TIE PER IAW SRM 53-10-4. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR UPS00232621Stringer · crackedINSPECTION TYPE:C+SI, CRACK ON STRINGER AT BS 440 AT STR 22L FWD OF CARGO HOLD FWD WALL. REPAIR CARRIED OUT IAW SRM 53-10-3 FIG 2. HFEC INSP CARRIED OUT IAW B727 NDT MANUAL PART 6, 51-00-00 FIG 4. NO DEFECT FOUND POST DAMAGE REMOVAL.SDR UPS00832607Doubler · corrodedINSPECTION TYPE:C2, COCKPIT SUBFLOOR CAN DOUBLER AND FINGER DOUBLER ARE CORRODED BEYOND LIMITS AT STA -18 AT RBL 8. REMOVED, FABRICATED AND REPLACED DOUBLERS IAW DWG 5612298, SRO8530026 AND SRM 51-1-21, 51-1-20D.SDR RRXA000439Clip · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO AFT CARGO SKIN CLIP AT STA 1240 AND LONGERON 34L TO 33R, DAMAGE EXCEEDED LIMITATIONS IAW DC8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC8 SRM 51-1-8, FABRICATED PART AND INSTALLED IAW DC8 SRM 53-4-0 FIG 7 & SDR RRXA000438Clip · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO AFT CARGO SKIN CLIP AT STA 1260 AND LONGERON 36L - 35L, DAMAGE EXCEEDED LIMITATIONS IAW DC8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC8 SRM 51-1-8, FABRICATED PART AND INSTALLED IAW DC8 SRM 51-1-4 AND 51-1-SDR ABXA000247Doubler · corrodedDURING D-CHECK, FOUND INTERNAL DOUBLER CORRODED AT STATION 579 AND LONGERON 30. REPLACED DOUBLER IAW DC9 SRM 51-30-2.SDR TWAA0006802Structure · crackedDURING OP 16 MAINT CHECK, FOUND ON FUSELAGE, THIRD FROM BOTTOM AFT STOP HOLE HAD A CRACK INDICATION PER EDDY CURRENT, FWD ENTRY DOOR, .125 INCH LONG. REPAIRED BY INSTALLING DOUBLER PER EMLR 70776A.SDR GAIA00224Shear Tie · crackedDURING LIGHT C-CHECK AT TIMCO/OSC, THE FOLLOWING DISCREPANCY WAS FOUND, CRACKED SHEAR TIE ON FORWARD SIDE OF BELLY FRAME AT BS 1030, LBL 6. REPAIRED SHEAR TIE IAW SRM 51-30-2. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR RRXA000448Clip · corrodedDURING A MAINTENANCE VISIT, FOUND CORROSION DAMAGE TO SKIN CLIP AT STA 1260 AND LONGERON 36R - 35R, DAMAGE EXCEEDED LIMITATIONS IAW DC8 SRM. REMOVED DAMAGE, TREATED AREA IAW DC8 SRM 51-1-8, FABRICATE PART AND INSTALLED IAW DC8 SRM 51-1-4 & 51-1-8 FIG 7 & 8.
Back to JASC 5310