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 AU000442Structure · damaged(AUS) NOSE LANDING GEAR INADVERTANTLY RETRACTED DURING OVERNIGHT MAINTENANCE. EXTENSIVE DAMAGE WAS CAUSED TO THE FUSELAGESTRUCTURE IN THE NOSESDR UPS00832827Shear Tie · corrodedINSPECTION TYPE:C123, STA 640 SHEAR TIE IS CORRODED BEYOND LIMITS BETWEEN LONG 34L AND 34R. REMOVED, FABRICATED AND REPLACED SHEAR TIE IAW DWG 5616509 AND SRM 51-1-21.SDR UPS00832812Fitting · crackedINSPECTION TYPE:C123, STA 440 - 460 LONG 31L SPLICE FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3750257 AND SRM 51-1-20D.SDR COMA0010119Shear Tie · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 231-012, WHILE GAINING ACCESS THE LT FUSELAGE SKIN SUPPORT BETWEEN FRAMES 12 AND 13 WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010118Shear Tie · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 232-012, THE FUSELAGE FRAME 13A SKIN SUPPORT AT STRINGER 14R WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPAIRED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3653-1, REV IR, 5-6-00.SDR COMA0010117Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 164-012, THE CARGO COMPARTMENT FLOOR SUPPORT AFT RT BUTT STRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3661-1, REV IR, 5-15-SDR COMA0010116Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 163-012, THE CARGO COMPARTMENT FLOOR SUPPORT AFT LT BUTT STRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3661-1, REV IR, 5-15-SDR COMA0010115Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 162-012, THE CARGO COMPARTMENT FLOOR SUPPORT FORWARD RT BUTT STRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB 120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES AND AERODESIGN REPORT NR 3661-1, REV IR, 5SDR COMA0010111Support Bracket · crackedRIVET HEAD WAS NOTICED CRACKED ON LEFT SIDE OF FUSELAGE AT FRAME 9. INTERNAL INVESTIGATION FOUND THE SKIN SUPPORT TO BE CRACKED. THE SKIN SUPPORT WAS REPLACED IAW EMB-120 SRM STANDARD PRACTICES AND AERODESIGN REPORT NR 660-1, REV IR, 2-16-93.SDR CALA0000723Door Frame · crackedINSPECTION FOUND A 1 INCH CRACK IN AFT CARGO DOOR OUTER FRAME AT AFT LATCH. THE CRACKED AREA WAS REMOVED AND A REPAIR DOUBLER WAS INSTALLED IAW SRM 52-05, FIGURE 29.SDR UPS00832826Shear Tie · corrodedINSPECTION TYPE:C123, STA 1480 BETWEEN LONG 35L AND 36 SHEAR TIE IS CORRODED BEYOND LIMITS. REPAIRED IAW SRM 53-2-0 FIG 2A.SDR UPS00832809Fitting · crackedINSPECTION TYPE:C123, STA 1690 LONG 26L END FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 4641324 AND SRM 51-1-20D.SDR UPS00832808Fitting · crackedINSPECTION TYPE:C123, STA 1690 LONG 34R END FITTING IS CRACKED. REMOVED AND REPLACED END FITTING IAW DWG 4641324 AND SRM 51-1-20D.SDR UPS00832790Fitting · crackedINSPECTION TYPE:C123, STA 980 - 1000 LONG 23L END FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 3753306 AND SRM 51-1-20D.SDR UPS00832771Fitting · crackedINSPECTION TYPE:C123, STA 1690 LONG 32R END FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 4641324N AND SRM 51-1-20D.SDR ASAA0080294Door Frame · damagedPHX - DURING 30K CHECK, FOUND ON AFT CARGO COMPARTMENT LOWER DOOR JAMB, FS 1155 TO 1212, LONGERON 28R. REMOVED AND REPLACED DOOR JAMB IAW DC9 SRM 51-30. (M)SDR ASAA0080292Splice · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON LONGERON SPLICE, LONGERON 29L, FS 589. REMOVED AND REPLACED SPLICE IAW DC9 SRM 51-30-05. (M)SDR ASAA0080271Splice · corrodedPHX - DURING 30K CHECK, FOUND CORROSION LONGERON SPLICE, LONGERON 26L, FS 1200. REMOVED AND REPLACED SPLICE IAW DC9 SRM 51-30. (M)SDR ASAA0080308Web · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON FLOORWEB, FS 160 TO 200, LBL 44 TO LBL 56. REMOVED AND REPLACED WEB IAW DC9 SRM 53-14-01. (M)SDR ASAA0080305Shear Tie · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON SHEAR TIE, FS 1155, LONGERON 30. REMOVED AND REPLACED SHEAR TIE IAW DC9 SRM 53-01. (M)SDR ASAA0080304Shear Tie · corrodedPHX - DURING 30K CHECK, FOUND CORROSION WAS FOUND ON SHEAR TIE, FS 435, LONGERON 29L TO 29R. REMOVED AND REPLACED SHEAR TIE IAW DC9 SRM 53-14-02, FIG 2. (M)SDR ASAA0080320Fastener · corrodedPHX - DURING 30K CHECK, FOUND CORROSION ON FUSELAGE SKIN FASTENER, FS 560, LBL 0. REMOVED FASTENER AND INSTALLED DOUBLER IAW DC9 SRM 53-04, FIG 12B. (M)SDR UPS00832834Fitting · crackedINSPECTION TYPE:C123, STA 798 LONG 18L INTERCOSTAL TO FRAME FITTING IS CRACKED. REMOVED, FABRICATED AND REPLACED FITTING IAW DWG 4751639 AND SRM 51-1-20D.SDR UPS00832816Fitting · crackedINSPECTION TYPE:C123, STA 660 -680 LONG 11L END FITTING IS CRACKED. REMOVED AND REPLACED FITTING IAW DWG 5750540 AND SRM 51-1-20D.SDR AALA20000886Bracket · corrodedTUL - FOUND CORROSION ON CUSP UNDER GIRT BAR BRACKET AT STATION 1174. CUTOUT CORROSION, FABRICATED AND INSTALLED DOUBLER 53-01-00. (M)SDR AALA2000815Door Frame · corrodedTUL - FOUND LOWER CARGO DOOR FRAME CORRODED AT STATION 950E AFT SIDE OF BELL FRAME. FABRICATED AND INSTALLED FRAME REPAIR AND STRAP PER SRM 51-00-3. (M)SDR QXEA0001350Door Frame · chafedPDX- DOUBLER ON FRAME AT AFT BAGGAGE DOOR SURROUND HAS 2 CHAFE MARKS, STATION X597.6, 2141.0. REPAIRED IAW DASH 8 SRM 51-20-11, PAGE 3, SECTION B, AND SRM 51-20-16, PAGE 4, SECTION C AND SRM 51-20-36, PAGE 6, SECTION F-J SRM 51-20-51.SDR 00FDEA00340Beltframe · crackedDURING ROUTINE INSPECTION, CRACK IN FWD UPPER FLANGE BELTFRAME BS 1010 BETWEEN STR 26L AND 27L. REMOVED AND REPLACED PER IAW SRM 51-40-3.SDR RRXA002754Door Frame · crackedDURING A MAINTENANCE VISIT FOUND A BENT AND CRACKED DOOR FRAME AT A PIT DOOR LOWER DOOR FRAME, DAMAGE EXCEEDED LIMITATIONS IAW DC-8 SRM. REMOVED DAMAGE, TREATED AND PRIMED AREA IAW DC-8 SRM 51-1-8. FABRICATED AND INSTALLED REPAIR IAW DC-8 SRM 51-1-24 AND 52-SDR QXEA0001405Clip · crackedPDX- CRACKED CLIP ON FRAME 17565 BETWEEN STRINGERS 7 - 5. REPAIRED IAW FOKKER SRM 53-10-05 PAGE 601A AND 53-01-13 PAGE 4.SDR QXEA0001404Clip · crackedPDX- CRACKED CLIP ON FRAME 17565 BETWEEN STRINGERS 8 - 9. REPAIRED IAW FOKKER SRM 53-10-05 PAGE 601A.SDR QXEA0001403Clip · crackedPDX- CRACKED CLIP ON FRAME 17565 BETWEEN STRINGERS 9 - 10. REPAIRED IAW FOKKER SRM 53-10-05 PAGE 601A.SDR QXEA0001371Beam · damagedPDX- REAR PRESSURE BULKHEAD BEAM III REQUIRES REPAIRED IAW FOKKER SRM 53-02-18 AT AREA OF PREVIOUS REPAIR AT APPROXIMATELY BL 800 LEFT. REPAIRED IAW HORIZON AIR EA 4-53-1055 C.SDR CALA0000678Door Frame · corrodedINSPECTION FOUND AFT CARGO PIT DOOR JAMB FORWARD FACE CORRODED AT STA 1155 - 1212. THE DOOR JAMB WAS REMOVED AND REPLACED IAW SRM 51-10-1 AND 51-10-2.SDR QXEA0001382Clip · crackedPDX- CRACKED CLIP AT FRAME 3820, 25 LEFT OF CL, BELOW FLOORBOARD SUPPORT. REPAIRED IAW FOKKER SRM 51-31-01 AND 51-30-02.SDR UPS00832703Door Frame · crackedINSPECTION TYPE:C2, AFT PIT C-3 DOOR AFT FRAME SECTION CRACKED. REMOVED SEAL RETAINER FOR FOM, FABRICATED REPAIR ANGLES IAW DC8 SRM 52- 2-0, ALODINED AND PRIMED IAW DC8 SRM 51-1-8. INSTALLED REPAIR ANGLES IAW DC8 SRM 52-2-0, INSTALLED HIGH-SHEAR FASTENERS IASDR COMA0060428Strap · crackedPAX DOOR SEAL STRIKER AT FS 349.00 STRINGER 4.5 HAS DAMAGE TO PREVIOUS REPAIR. REPAIRED SEAL STRIKER AT FS 349.00 STRINGER 4.5 IAW CANADAIR REO 6 01R-52-11-008 REPAIR B.SDR AALA2000822Shear Tie · crackedTUL - FOUND SHEAR TIE CRACKED AT STATION 1263 LEFT STRINGER 11 AND ANGLE BEHIND THIS SHEAR TIE ALSO CRACKED. FABRICATED 301H/H STAINLESS STEEL DOUBLER, DRILLED AND INSTALLED BACK TO BACK WITH LIKE ANGLE AND REPLACED SHEAR TIES PER SRM 51-40-3 FIG NR 1. (M)SDR AALA2000823Shear Tie · corrodedTUL - FOUND CORROSION ON SHEAR TIE AFT SIDE CORNER ABOVE 26 RIGHT AT STATION 720A. REMOVED AND REPLACED SHEAR TIE PER SRM 51-10-01. TREATED AND PRIMED ALL AREAS. APPLIED OVERCOAT PRIMER PRIOR TO DYNATROL. (M)SDR DL72S001057Shear Tie · corrodedAT HMV2 FOUND AFT B/B SHEAR TIE CORRODED AT FS 1166 FROM STR 28L TO 28R. REMOVED FASTENERS TO GAIN ACCESS TO CORRODED AREA, CORROSION ON SHEAR TIE FROM STR 29-28 OUT OF LIMITS AND FRAME WEB BELOW FAIL-SAFE CHORD OUT OF LIMITS AS PER SRM 53-10-1 FIG 1. REMOVESDR QXEA0001301Splice · corrodedPDX- LIGHT CORROSION AT AFT CABIN SPLICE ANGLE LOCATED AT FRAME 15205 AND STRINGER 18. REPAIRED IAW FOKKER SRM 51-10-04 PAGE 9.SDR QXEA0001285Splice · corrodedPDX- LIGHT CORROSION AFT CABIN SPLICE ANGLE, LOCATED AT FRAME 15205 AND STRINGER 57. REPAIRED IAW FOKKER SRM 51-10-01 PAGE 9.SDR QXEA0001279Rivet · wrong partPDX- NON-SRM GROUP OF RIVETS INSTALLED IN 6 X 6 AREA OF NOSE LANDING GEAR BAY RIGHT HAND SIDEWALL FORWARD OF FRAME 2650. OUT OF 19 RIVETS, 6 ARE OVERLAPING. REPAIRED IAW HORIZON AIR EA 4-53-11-66.SDR USAA000694Beltframe · corrodedCLT - BELT FRAME HAD LEVEL 2 CORROSION, .250 INCH BY .250 INCH, BS 727B, RBL 04. INSTALLED DOUBLER PER SRM 53-10-4. (X)SDR COMA0010097Support Bracket · crackedUPON COMPLIANCE OF 2C INSPECTION TASK 5320-141/142-01I, THE FUSELAGE SKIN SUPPORT AT FRAME 21, BETWEEN STRINGERS 21L AND 21R, WAS FOUND TO BE CRACKED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010096Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 163-01Z, THE LT AFT FUSELAGE BUTT STRAP (SILL) WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010095Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 162-01Z, THE RT FUSELAGE FLOOR SUPPORT BUTT STRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010094Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 161-01Z, THE LT FUSELAGE FLOOR SUPPORT BUTT STRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010087Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 131-01Z, THE LT FUSELAGE FLOOR SUPPORT BUTT STRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.SDR COMA0010086Strap · corrodedUPON COMPLIANCE OF 2C INSPECTION TASK 152-01Z, THE RT FLOOR SUPPORT BUTT STRAP WAS FOUND TO BE CORRODED. THE DAMAGED PART WAS REPLACED IAW EMB-120 STRUCTURAL REPAIR MANUAL STANDARD PRACTICES.
Back to JASC 5310