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 ABXA070178Window Frame · crackedWHILE COMPLYING WITH WINDOW FRAME MOD EA53000041, FOUND CRACKED FRAME. REPAIRED AREA IAW DC9 SRM 53-03, FIG 34.SDR ABXA070177Window Frame · crackedWHILE COMPLYING WITH WINDOW FRAME MOD EA 53000041, FOUND CRACKED FRAME. REPAIRED AREA IAW DC9 SRM 53-03, FIG 34.SDR USAA070428Door Frame · crackedBS 296.5; FWD UPPER CORNER FRAME OF RIGHT FWD SERVICE DOOR CUTOUT HAS CRACK. DEFECTIVE PART REPLACED WITH IDENTICAL PART PER SRM 51-10-02, DEFECT SIZE: .5 INCH.SDR USAA070431Door Frame · crackedBS 296.5, FWD UPPER CORNER FRAME OF RIGHT FWD SERVICE DOOR CUTOUT AT DOOR STOP FITTING HAS CRACK. REMOVED CRACKED FRAME & INSTALLED NEW PER SRM 51-10-02, DEFECT SIZE: .5 INCH.SDR 2007UALA01827Door Frame · crackedFORWARD CARGO PIT DOORWAY FORWARD FRAME IS CRACKED AT LOWER STOP FITTING. MAJOR REPAIR ACCOMPLISHED: INSTALLED REPAIR DOUBLER ANGLES.SDR 2007UALA01826Door Frame · damagedFWD PIT DOOR CUTOUT AFT FRAME IS DAMAGED. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED AREA & INSTALLED NEW FRAME P/N 65-20723U54.SDR 2007UALA01825Door Frame · crackedFWD PIT DOOR CUTOUT, AFT FRAME CRACKED NEAR LOWER STOP FITTING. MAJOR REPAIR ACCOMPLISHED: REPLACED DAMAGED FRAME AT BS 492 WITH NEW FRAME P/N 65-20723U54.SDR 07FDEA02073Frame · corrodedFOUND FRAME CORRODED. COMPLY WITH EA 6-5310-110742 FUSELAGE MAINFRAME FR 63 RIGHT CORROSION REPAIR COMPLIED WITH EA 6-5310-110742 FUSELAGE, MAINFRAME, FR 63 RIGHT CORROSION REPAIR AND SPLICE AT STR NR 39.SDR DLM88070687Structure · corrodedCORROSION AT STA Y=1271 LONGERONS 9 RT, 5 RT, 3 RT, 2 RT, 4 LT, AND 5 LT. REPAIRED IAW SRM 51-30-5 NR T0056452.SDR ZZDA070602186Door Frame · corrodedFWD CARGO COMPARTMENT DOOR CUTOUT LOWER SECTION HAS SPOTS OF CORROSION. INSTALLED DOOR JAMB LOWER SECTION AT FWD CARGO COMPARTMENT DOOR CUTOUT AS PER B717 SRM 53-20-115.SDR DLM88070686Structure · corrodedCORROSION AT STA Y=1287, LONGERONS 5-4 RT. REPAIRED IAW SRM 51-30-5 NR T0056451.SDR 07FDEA02049Structure · damaged2 HOLES ELONGATED AT FS 54 STRINGER 36 LT NR 16 =.200 BY .220 AND NR 17 = .188 BY .221. REPAIRED HOLES IAW EA 6-5330-110462.SDR 07FDEA02048Structure · damaged2 HOLES ELONGATED AT FS 54 STRINGER 37 LT NR 1 =.187 BY .220 AND NR 2 = .200 BY .239, REPAIRED HOLES IAW EA 6-5330-110462.SDR DLM88070682Structure · corrodedCORROSION AT STA 1193 AND LONGERON 26 LT. REPAIRED IAW SRM 51-30-5 NR T0056323.SDR ASAA0791809Rail · corrodedAFT CARGO PIT RAIL SPLICE CORRODED. REPAIRED IAW 51-40-05 AND 51-40-02.SDR ASAA0791808Rail · corrodedAFT CARGO PIT RAIL SPLICE IS CORRODED. REPAIRED IAW 51-40-02 AND 51-40-05.SDR ASAA0791805Rail · corrodedAFT CARGO PIT FLOOR RAIL CORRODED. REPAIRED IAW EA5310 02724.SDR ASAA0791804Rail · corrodedAFT CARGO PIT SUPPORT RAIL CORRODED. REPAIRED IAW EA 5310 02724.SDR ASAA0791803Rail · corrodedAFT CARGO PIT SUPPORT RAIL CORRODED. REPAIRED IAW EA5310 02724.SDR ASAA0791802Rail · corrodedAFT CARGO PIT SUPPORT RAIL CORRODED. REPAIRED IAW EA 5310 02724.SDR ASAA0791799Rail · corrodedAFT CARGO PIT SUPPORT RAIL CORRODED. REPAIRED IAW EA 5310 02724.SDR ASAA0791798Rail · corrodedAFT CARGO PIT SUPPORT RAIL CORRODED. REPAIRED IAW EA5310 02724.SDR ASAA0791797Rail · corrodedAFT CARGO PIT SUPPORT RAIL CORRODED. REPAIRED IAW EA5310 02724.SDR ASAA0791796Rail · corrodedAFT CARGO PIT SUPPORT RAIL CORRODED. REPAIRED IAW EA5310 02724.SDR ASAA0791795Rail · corrodedAFT CARGO PIT SUPPORT RAILS CORRODED. REPAIRED IAW EA5310 02724.SDR ASAA0791794Rail · corrodedAFT CARGO PIT SUPPORT RAIL CORRODED. REPAIRED IAW EA5310 02724.SDR 2007UALA01759Door Frame · crackedMAIN CABIN FWD ENTERY DOOR SURROUND STA 294.5 STR 7 LT FWD WEB IS CRACKED. [06-26-07] MAJOR REPAIR: REPLACED STR 7L INTERCOSTAL WEB PER AAR EA-I070345 AND US EVA-70301.SDR 2007UALA01756Structure · scratchedLOWER FUSELAGE BENEATH AFT CARGO PIT DOOR APPROX BS 804 HAS SCRATCHES. [06-26-07] MAJOR REPAIR: REPAIRED LOWER SKIN. INSTALLED DOUBLER AND FILLER. REFERENCE EA I070390 REV IR.SDR 2007UALA01755Crease Beam · corrodedLT AFT ENTRY DOOR THRESHOLD INNER CREASE BEAM CHORD ANGLE CORRODED AT BS 963-983 AT WL 208 LBL 53-55. [06-26-07] MAJOR REPAIR: REMOVED CORROSION. REFERENCE PART 4, 51-00-90 AND SRM 53-60-15 FIG 101 PG113.SDR SWAA072770Door Frame · corrodedDURING SCHEDULED 22Y CHECK, FOUND E&E DOOR CUTOUT RIGHT FWD CORNER CORRODED AT BS 328, RBL 15.47. REPAIRED INNER CHORD PER SRM.SDR 07FDEA02026Structure · misrepairedON AGING A/C INSPECTION, FOUND EXISTING REPAIR LOCATED AT STA 520, STR 16R-17-R, DID NOT CONFORM TO SRM. REMOVED AND DISCARDED PREVIOUS ANGLES & INSTALLED NEW REPAIR PARTS, EA I070369 ALL WORK ACCOMPLISHED ON WO 36352/N00878.SDR UPS07450043Doubler · crackedINSPECTION TYPE:C CRACK FOUND AT DOUBLER AT LT SIDE OF BS 820 STR 10A ATTACHED TENSION TIE NR 4 HOLE CRACK LENGTH 3/16" APPROX AT 8 O/C POSITION. M/D BS 820 LT SIDE STR 10A FRAME ATTACH DOUBLER REPLACED AND INSTALLED AS PER SRM 51-10-01 PG 9 AND 51-30-02.SDR HALA0700239Door Frame · crackedFOUND 3/16" CRACK ON FWD DOOR JAMB FRAME, TOP EDGE, RT WHEELWELL. BLENDED OUT CRACK PER HAL M105 FILE NR 484083. PRIMED AND PAINTED.SDR DLM88070681Structure · corrodedCORROSION AT STA 1174 AND LONGERONS 26 LT T0 24 LT. REPAIRED IAW SRM 51-30-3 NR T0056322.SDR DLM88070680Splice · crackedFOUND CRACK ON UNION SPLICE AT STA Y=990 X=-6. ANGLE REMOVED, FABRICATED AND INSTALLED IAW DWG 5936395 NR T0056307.SDR DLM88070679Structure · corrodedCORROSION ON RT WW AFT EDGE STA Y=997, X=-25. REPAIRED IAW DWG 5962021 NR T0056306.SDR DLM88070678Door Frame · corrodedCORROSION ON FED UPPER CORNER OF C2 DOOR JAMB. REPAIRED IAW SRM 51-30-2 NR T0056177.SDR DLM88070649Door Frame · corrodedGENERAL SURFACE CORROSION ON C1 LOWER DOOR JAMB. CORROSION REMOVED, SURFACE THICKNESS WITHIN LIMITS. TREATED AND PAINTED IAW SRM 51-10-3D NR T0056370.SDR SWAA072739Crease Beam · tornDURING SCHEDULED 22Y CHECK, FOUND CREASE BEAM WEB TORN BETWEEN BS 986 AND BS 1019, RBL 40 AND RBL 45. REMOVED AND REPLACED WEB PER SRM.SDR DLM88070688Structure · corrodedCORROSION AT STA Y=256 LONGERON 2 RT. REPAIRED IAW SRM 51-30-5 NR T0056453.SDR DLM88070643Door Frame · crackedCRACK ON LEFT MLG DOOR JAMB AT FWD OUTER SIDE. DOOR JAMB REPLACED IAW DRAWING 5930584 N/R T0056090.SDR DLM88070642Door Frame · crackedCRACK ON DOOR JAMB IN AFT EXTERNAL A/C SERVICE PANEL AT AFT OUTBD CORNER. FABRICATED AND INSTALLED DOUBLER REF SRM.SDR CALA0700267Door Frame · crackedINSPECTION FOUND A .75 INCH CRACK IN FORWARD CARGO DOOR CUTOUT AFT FRAME AT LOWER DOOR STOP FITTING, STA 480-500, S16R TO S28R. THE FRAME WAS REMOVED AND A NEW FRAME WAS INSTALLED IAW SRM 51-40-02, PARAGRAPHS 4 AND 7.SDR SWIA200718332Door Frame · crackedCRACK FOUND AT FS 338.00 FRAME MEMBER ON PAX DOOR, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS AT FS 338.00 ON PAX DOOR PER REO 601R-52-11-402 REV G.SDR 2007UALA01658Door Frame · corrodedCORROSION AT R2 DOOR SILL FRAME 68 AND AT FWD END OF R2 DOOR SILL FR 66. MAJOR REPAIR ACCOMPLISHED: INSTALLED 2EA DOUBLER REPAIRS.SDR USAA070415Shear Plate · corrodedLEFT SHEAR TIE PLATE FRAMES 69 - 70 HAS CORROSION. DEFECTIVE PART REPLACED WITH IDENTICAL. CORR TASK JA-260-53500; LEVEL 1, DEFECT SIZE: 5 X 17 INCHES.SDR SWIA200718512Door Frame · crackedPAX DOOR FRAME IS CRACKED AT LOWER AFT CORNER RADIUS, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLE AND FILLER PER CRJ 200 REO 601R-52-11-279 REV NC 10-18-01.SDR DHL2007740503Torque Box · crackedWHILE IN "C" CHECK, NLG WW STA 294 RT LOWER TORQUE BOX WEB IS CRACKED. TRIMMED OUT CRACKED PORTION IAW B727 SRM 51-10-1. FABRICATED REPAIR DOUBLER FROM 2024T3 .063 PO NR 9005089 DIM 7 1/2 BY 8 1/4 IAW B727 SRM 53-10-2 FIG 2 AND 51-40-2 FIG 1. TREATED AND PRSDR USAA200705U12Beam · corrodedA 1.125 X 2 INCH CORROSION FOUND AT RIGHT AFT SILL BEAM. REPAIRED PER SRM 53-41-14. CORROSION TASK JA-260-53500, CORR LEVEL 1.SDR FDKA200705239Door Frame · corrodedTWO ANGLES ON THE PAX DOOR FRAME, THAT SECURE THE THRESHOLD ARE CORRODED. THE DAMAGED ANGLES HAVE BEEN REMOVED AND REPLACED.
Back to JASC 5310