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 AALA20130204006Door Frame · crackedRIGHT NUMBER 1 DOOR FOWARD LOWER STUB FRAME CRACKED COMMON TO CREASE ANGLE. INSTALLED REPAIR DOUBLER AND FILLERS PER EA 737-53-0281.SDR SWAA2013021912775Door Frame · crackedFORWARD CABIN R-1 DOORWAY FWD FRAME WEB CRACKED AT STA 312 RBL 53.5 WL 209. REMOVED DAMAGED AREA, HAD NDT INSPECT AREA TO ENSURE NO MORE DAMAGE EXISTS, AND INSTALLED NEW REPAIR DUE TO FWD CABIN R1 DOORWAY FWD FRAME WEB CRACK IAW SRM 51-70-11-2R-0. REPAIRED PSDR DALA13006283213Stop Fitting · chafedDURING INSPECTION, FOUND LT AFT PASSENGER ENTRANCE FRAME 68 ROLLER STOP FITTING ON MID OUTER SURFACE HAS CHAFED. REPLACED ROLLER STOP FITTING AT LT AFT PAX ENTRANCE ON FRAME 68 IAW SRM 51-49-00 (TR14925 TORQUE WRENCH USED) DUE TO NO ESTABLISHED LIMIT FOUND IASDR UALA2013020400637Crease Beam · corrodedCABIN FWD WET AREA. CREASE BEAM INNER STRUCTURE CORRODED AT BS 415-419 RBL 63. REMOVED CORROSION FROM BEAM OUT OF LIMITS. REMOVED & FABRICATED NEW CREASE BEAM IAW 53-00-51, 51- 40-02, 51-40-05, 51-20-01 AND INSTALLED CREASE BEAM SRM 51-40-02 & DWG 141N 842SDR UALA2013020400632Tension Tie · crackedBS 1160 RT FWD TENSION TIE CRACKED. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR IAW SRM 53-40-30 REPAIR 2. MAJOR REPAIR.SDR UALA2013020400631Tension Tie · crackedBS 1120 LT FWD TENSION TIE CRACKED. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR IAW SRM 53-40-30 REPAIR 2. MAJOR REPAIR.SDR SWAA2013020812439Crease Beam · corrodedSERVICE DOOR R2 THRESHOLD/ CREASE BEAM HAD CORROSION BETWEEN BS 951R AND 992.8R. R & R BEAM IAW SRM AND DWG.SDR FDEA201302020261Crease Beam · corrodedRIGHT CREASE BEAM AT BS 755- 900 HAS SCRATCHES AND CORROSION. REMOVED CORROSION IAW SRM 51-20-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-30 -13 FIG 101, DETAIL III. R & R CREASE BEAM SECTION IAW SRM 51-40-02 AND DWG 143N8322. MAJOR REPAIR.SDR UALA2013020400635Crease Beam · corrodedCABIN FWD AREA CREASE BEAM INNER CHORD CORRODED AT STA 439 RBL 63. MAJOR REPAIR ACCOMPLISHED. REMOVED BEAM STA 349 FABRICATED NEW BEAM TAG A42735, INSTALLED BEAM IAW SRM 53-00-51,51-4 0-02, 51-40-05, 51-40-05, 51-20-01, 53-60-51 & DWG 140N0504.SDR CA130201010Strap · cracked(CAN) RIGHT STRAP ON BOTTOM OF BOXBEAM FOUND CRACKED DURING ANNUAL INSPECTION.SDR QXEA2013020100219Rib · corrodedRIB AT STATION 698, STRINGER 24P CORRODED. REPAIRED.SDR SWAA2013022213006Door Frame · corrodedFORWARD PIT CARGO DOOR JAMB HAS CORROSION IN A FEW AREAS. FABRICATED SPLICES 2024T3 P/O 90015407 LOCATED & DRILLED NEW PAN IAW B717 SRM 51-40-08 & 53-20-15 REPAIR 6.SDR QXEA2013020100238Adapter · corrodedFOUND LOWER TCAS ADAPTER PLATE CORRODED. REMOVED ADAPTER PLATE AND MATCH DRILLED NEW IAW SRM 51-40-07-02-01, 51-42-05-02-01. INSTALLED ADAPTER PLATE IAW SRM 51-42-05-02-01. PRIMED AND APPLIED TOP COAT IAW SRM 51-25-10-02-01 AND 51-25-15-02-01.SDR QXEA2013020100227Angle · corrodedFRAME BS 547, REINFORCEMENT ANGLE AT S24P IS CORRODED. REMOVED FASTENERS AS NECESSARY AND BLENDED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. FOUND ANGLE OUT OF LIMITS IAW SRM 53-30-15-00-01. REMOVED ANGLE IAW SRM 51-42-05-02-01, MATCH DRILLED NEW SDR QXEA2013020100226Angle · corrodedFRAME BS 116, REINFORCMENT ANGLE AT S24P IS CORRODED. REMOVED REINFORCEMENT ANGLE IAW SRM 51-42-05-02-01. MATCH DRILLED ANGLE IAW SRM 51-40-07-02-01. ALODINED, PRIMED AND PAINTED NEW PART IAW SRM 51-21-10-02-01, 51-25-10-02-01, 51-25-15-02-01. INSTALLED ANGLSDR SWAA2013021212590Crease Beam · corrodedCORROSION ON CREASE BEAM AT STA 727D TO 727E STR 17R UPPER SURFACE. REMOVED & REPLACED CREASE BEAM WEB FROM STA 727D TO STA 727E AT STR 17R IAW B737-300 SRM 51-40-02 & BOEING DWG 65C26402 REV A.SDR QXEA2013020100224Structure · corrodedCORROSION ON STRAP AND RIVETS BETWEEN STR 32P AND 31P, AND X19.4 AND X49.5. REMOVED RIVETS TO FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. CHECKED MIN REMAINING THICKNESS USING UT .042" MIN REF NDTM 51-00-04-910-801 PT 1. INSPECTED USDR UALA2013020100595Structure · crackedBS 1120 FWD AND AFT TENSION RT TIE TWO HOLES CRACKED. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-40-30 REPAIR 1.SDR UALA2013020100594Door Frame · crackedNR 5 RT MED DOOR FRAME WEB CRACKED AT STA 2235 S22R. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-60-15 REPAIR 3.SDR SWAA2014012024205Window Frame · crackedLT NR 1 WINDOW CUTOUT FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW ER & SWA EA.SDR UALA2013013100584Door Frame · crackedFWD CARGO DOOR CUT OUT, AFT FRAME IS CRACKED ON AFT SIDE OF FRAME IN RADIOUS ADJACENT TO UPPER INBOARD CORNER OF LOWER BOTTOM STOP FITTING VERIFIED BY HFEC. REMOVED CRACK AND ACCOMPLISHED ANGLE REPAIR PER MM 53-30-75.SDR N6WA2013013104Crossbeam · crackedCROSSBEAM AT FS 280 CRACKED. R & R FS 280 SPLICE BEAM LT SIDE IAW REO 670-53-11-047, REV E.SDR FDEA201301310243Crease Beam · corrodedRT CREASEBEAM AT BS 660 -690 CORRODED. REMOVED CORROSION IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-30-13, FIG 101, DETAIL VIII. R & R RT INBD CREASE BEAM IAW SRM 51-40-02 AND DWG 143N8322. MAJOR REPAIR.SDR FDEA201301310242Crease Beam · corrodedRT CREASE BEAM AT BS 660 -690 HAS CORROSION.SDR FDEA201301310241Crease Beam · corrodedRT CREASE BEAM AT BS 660 -690 HAS CORROSION.SDR DALA13004890943Window Frame · crackedPASSENGER LT CABIN WINDOW FRAME LOWER FWD CORNER CRACKED BETWEEN STA-1041 AND 1022, REMOVED FASTENERS AND CUTOUT DAMAGED AREA. FABRICATED ANGLE REPAIR, SHIM, & INSTALLED ALL AT PASSENGER LT CABIN WINDOW FRAME LOWER CORNER BETWEEN STA 1041 TO 1022 IAW SRM 51-3SDR 29GA2013022795453Door Frame · crackedDURING SCHEDULED ROUTINE STRUCTURAL INSPECTION DISCOVERED CRACK AT LOWER CORNER FOR AIRSTAIR DOOR FUSELAGE SIDE. REMOVED DAMAGED AREA AND INSTALLED A DOUBLER AND SPLICE REPAIR.SDR FDEA201301280206Door Frame · crackedLOWER CENTER CARGO DOOR UPPER FRAME AT DOOR ACTUATOR ARM AREA FOUND CRACKED. REPAIRED IAW EA 1-5310-163577 TITLE: FUSELAGE - MAINFRAME- CENTER CARGO DOOR UPPER JAMB BEAM - CRACK REPAIR. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 116.SDR ASAA2013012893896Door Frame · corrodedL1 DOOR FRAME CORRODED AT BS 303 AT CUSP AREA. REMOVED CORROSION, OUT OF LIMITS IAW SRM 53-00-07, DAMAGE 1, DETAIL C LIMITS, ACCOMPLISHED REPAIR IAW REO-G15946, REV A.SDR DALA2013122707359Mount · corrodedNAVIGATION-RADIO ALTIMETER LEFT, FWD ANTENNA MOUNT CORROSION. REMOVED AND REPLACED IAW ERA 511063-14 REV ORIG SECTION II.SDR DALA2017020301757Door Frame · damagedFOUND SCRATCH ON LOWER FWD CORNER OF BULK CARGO DOOR FRAME AREA. BLENDED AND TREATED DAMAGE ON BULK CARGO FWD CORNER IAW SRM 53-00-01.SDR ASOA2013031103128Crossbeam · crackedBS 280 CROSSBEAM CORRODED AND CRACKED IN CENTER. COMPLIED WITH EC/TC REO 670-53-11-047 AND REO 670-53-11-047, REV E.SDR UALA2013012800485Door Frame · crackedR5 DOOR FWD FRAME WEB CRACKED BS 2223 S23L. REMOVED DAMAGE. FABRICATE AND INSTALL REPAIR PARTS IAW SRM 53-60-15 REPAIR 3. MAJOR REPAIRSDR UALA2013012800487Door Frame · crackedL5 DOOR FWD FRAME WEB CRACKED BS 2225 S23L. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR PARTS IAW SRM 53-60-15 REPAIR 3. MAJOR REPAIRSDR QXEA2013012500171Nut Plate · corrodedAFT ENTRY DOOR FWD FRAME NUT PLATES FOR NR 5 STOP FITTING CORRODED. REMOVED 2 NUT PLATES IAW RD 8/4-52-492. NO FURTHER CORROSION NOTED. ALODINED AND PRIMED IAW RD 8/4-52-492. INSTALLED BOLTS AND APPLIED CPC IAW RD 8/4-52-492.SDR QXEA2013012400178Nut Plate · corrodedFWD BAG DOOR AFT FRAME HAS MULTIPLE CORRODED NUT PLATES UNDER STOP FITTINGS AND AT LINER ATTACH POINTS. REMOVED INNER SKIN FOR ACCESS IAW SRM 51-42-45-02-01. R & R CORRODED NUT PLATES IAW SRM 51-42-05-02-01, NO CORROSION NOTED UNDER STOP FITTINGS. ALODINED, SDR QXEA2013012400173Nut Plate · corrodedFWD BAG DOOR AFT FRAME HAS MULTIPLE CORRODED NUT PLATES UNDER STOP FITTINGS AND AT LINER ATTACH POINTS. R & R CORRODED NUT PLATES FROM FWD BAG DOOR AFT FRAME AND LINER ATTACH POINTS IAW SRM 51-42-05-02-01. NO CORROSION NOTED UNDER FITTINGS. ALODINED, PRIMED SDR HYIA20130124002Spar · damagedDURING A REGULARLY SCHEDULED MX EVENT, DAMAGE WAS DISCOVERED ON THE REAR SPAR WEBS IN BOTH FORWARD AND AFT POSITIONS. DAMAGE WAS MAPPED AND SENT. REPAIRS WERE CARRIED OUT IAW REPAIR PLANS SUPPLIED AND SUBSTANTIATED.SDR HYIA20130124001Spar · crackedDURING A SCHEDULED MX EVENT, CRACKS WERE DISCOVERED ON THE REAR SPAR WEBS FORWARD AND AFT AT FLOOR ATTACH POINTS. DAMAGE WAS MAPPED AND SENT. REPAIRS WERE CARRIED OUT IAW REPAIR PLANS SUPPLIED AND SUBSTANTIATED.SDR ASOA2013030803123Post · corrodedCOCKPIT ENTRY DOOR POST AT FS280 CORRODED AT LT LOWER SECTION. REMOVED CORROSION FROM INBD & OTBD SIDE OF LT LWR DOOR POST AT FS280 IAW SRM 51-42-06-001-001, 51-21-06-001-001 ORIG MAT THICKNESS .032" IAW SRM 53-11-10-991-803. RECEIVED AND COMPLIED WITH REO 6SDR DALA13004943214Door Frame · corrodedDURING INSPECTION, FOUND RT AFT DOOR CUT OUT FR 68 FWD FACE HAS CORROSION APPROX 1" ABOVE DOOR SILL. REMOVED CORROSION IAW SRM 51-74-00, CHECKED LIMITS, L=1.5"X W =1"X D=.021" FOUND OUT OF LIMITS IAW SRM 53-41-12. REPAIRED IAW SRM 53-41-12, FIG 201. PRINCIPLESDR DALA1301780172Structure · corrodedFOUND CORROSION AT FS 246, RBL 57, REPAIRED IAW ERA 510092-14, REV ORG.SDR SIMA20130122010Structure · corrodedCARGO DOOR CUT-OUT LOWER FWD SECTION CORRODED. REPAIRED CARGO DOOR CUT-OUT FWD SECTION IAW EO EM-53MR-1129.SDR COEA2013022801913Crease Beam · corrodedHEAVY CHECK COE/MINOR REPAIR: RIGHT CREASE BEAM INNER CHORD HAS MULTIPLE AREAS OF LEVEL 2 CORROSION AND MISSING PAINT FR19-25. REPLACE WITH OEM PART PER ATR42 SRM.SDR QXEA2013012200210Door Frame · corrodedAFT SERVICE DOOR AFT FRAME HAS CORROSION AROUND THREE FASTENER HOLES FOR LINER. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN THICKNESS NOTED .047", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MAPPED DAMAGE AND SUBMITTED TO ENSDR QXEA2013012200209Door Frame · corrodedAFT ENTRY DOOR FWD FRAME HAS CORROSION AROUND 5 FASTENER HOLES FOR LINERS. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN THICKNESS NOTED .048", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND IN LIMITS IAW RD 8SDR QXEA2013012200208Door Frame · corrodedAFT ENTRY DOOR, AFT FRAME HAS CORROSION AROUND FASTENER HOLE FOR LINER. REMOVED CORROSION AROUND FASTENER HOLES IAW SRM 51-21-00-00-02. MIN THICKNESS NOTED .065", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1 MATERIAL LOSS FOUNDSDR QXEA2013012200170Door Frame · corrodedAFT SERVICE DOOR FWD FRAME HAS CORROSION AROUND 5 FASTENER HOLES FOR LINER. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS NOTED .050", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MAPPED DAMAGE AND SUBMITTEDSDR QXEA2013012200169Door Frame · chafedFORWARD BAG DOOR CUTOUT TOP FLANGE AREA CHAFED. BLENDED OUT CHAFE IAW SRM 51-14-00-02-03. MIN THICKNESS NOTED .059", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. DAMAGE FOUND TO BE IN LIMITS IAW DWG 35329501, NOMINAL THICKNESSDR COEA2013021502913Crease Beam · corrodedDURING HEAVY CHECK, CORROSION ON UPPER AND LOWER SURFACE OF RIGHT CREASE BEAM WEB, FR 23-24. FABRICATED NEW, REMOVE AND REPLACED IAW SRM.
Back to JASC 5310