JASC 5311
Service difficulty reports · 61,554
Reports filed under 5311 · Fuselage Main, Frame, 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 = '5311' 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 = '5311' 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 CALA2013031300151Frame · crackedDURING ACCOMPLISHMENT OF EA 5310-04716, REV D, CRACK WAS FOUND IN THE INBD TRANSITION RADIUS OF FRAME BETWEEN STRINGER 8 & 9 AT BS 380 RT SIDE. PERFORMED INTERM REPAIR IAW PART 1 OF ECRA. ACCOMPLISH A PERMANENT REPAIR PRIOR TO MARCH 6, 2015. PLANNING TO CONTSDR DALA1307636707Frame · gougedAFT CARGO, FOUR GOUGES IN UPPER REAR SIDE OF FRAME BS 1520 S23 AND S26R. REPAIRED IAW SRM 53-00-07, FIG 201, PG 208.SDR SWAA2013032214018Frame · crackedFRAME CRACKED AT BS 360, BETWEEN STR 19R TO STR 20R. REPAIRED FRAME IAW EA.SDR FDEA201303050499Frame · corrodedUPPER LOBE BS 1701 FRAME HAS CORROSION STR 2R & 3R. REMOVED CORROSION IAW SRM 51-10-03. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL II SECTION A-A. R & R UPPER FRAME IAW SRM 51-40-02 AND DWG 146N1043. MAJOR REPAIR.SDR SIMA20130304015Frame · crackedFRAME 23 AT STRINGER 15R IS CRACKED. REPAIRED IAW EO EM-53MR-1797.SDR HYIA20130308002Spar · crackedDURING A SCHEDULED MX EVENT, CRACKS WERE NOTED IN THE FORWARD AND AFT SPAR WEBS ON THE REAR SPAR. DAMAGE WAS LOCATED AT FLOOR SUPPORT ATTACH POINTS. ENGINEERING WAS REQUESTED AND RECEIVED AND REPAIRS ARE CURRENTLY UNDERWAY.SDR GLBA2013030500194Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND TWO CRACKS AT FS 588.1 STRINGER 9L, 1.25 INCH IN LENGTH. REPAIRED IAW EO 13-1900-53-019. MAJOR REPAIR.SDR QXEA2013030300509Spar · damagedCENTER WING REAR SPAR UPPER CAM LOCK RECEPTACLE FLANGE BETWEEN LT WING STA YW45 AND RT WING STA YW45 IS CHAFED. SMOOTHED CHAFE DAMAGE IAW SRM 57-10-05-02-01 R.12. CONFIRMED AFFECTED AREAS CRACK FREE REF NTM 51-00-04-910-801 PT1 & 51-00-06-910-801 PT1 REV 7. SDR LR7A2013030300440Frame · crackedDURING SCHEDULED B-1 CHECK, FOUND FS 968 FRAME CRACKED AT UPPER R5 CORNER, RBL 59, WL 280. REPAIRED IAW SMP583, SRM FIG 53-50-06/ NR 2-5-2.SDR SIMA20130303012Frame · chafedDURING MAINTENANCE INSPECTION FOUND CHAFE DAMAGE TO FRAME 1144.00-IAW EO CR-5300-321 PTB. THE AIRCRAFT WAS REMOVED FROM SERVICE. COMPLIED WITH REPAIR ORDER EO CR-53MR-321 PT B. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA2013032013887Frame · corrodedFRAME CORRODED AT BS 889, BETWEEN L29L TO L29R. REPAIRED FRAME IAW SRM.SDR SWAA2013031813752Frame · crackedFRAME CRACKED AT BS 715, LBL 54.5. REMOVED AND REPLACED FRAME IAW SRM.SDR QXEA2013030200485Frame · corrodedFRAME FLANGES AT FR 341, STR 31 & 30 HAVE CORROSION. REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1 REV 8. FOUND WITHIN LIMITS SRM 53-00-00-02-09.SDR FDEA201303020489Frame · damagedMAIN DECK FRAME BS 1140 HAS A DOUBLE DRILLED HOLE BETWEEN S-2R & S-3R (INCOMING CONDITION). REMOVED DAMAGED AREA OF FRAME STA 1140 BETWEEN S-2R AND S-3R IAW SRM 51-10-02, SRM 53-00-07, REPAIR 3. FABRICATED REPAIR CHANNELS AND FILLER IAW SRM 53-00-07 FIG 2SDR ASOA20130302278Frame · corrodedACFT IS IN FOR A C-CHECK WHEN CORROSION WAS FOUND UNDER THE LWR FWD CHAFED PLATE AT CARGO DOOR FRAME 65,STRINGER 17L. MX CUT OUT DAMAGE AREA AND INSTALL A NEW REPAIR ON THE FRAME REF SRM 53-31-04. ALL WORK ACCOMPLISHED AND WILL BE RELEASED AT THE END OF THE CSDR QXEA2013030100447Frame · corrodedFRAME 32.4, RT STANCHION HAS CORROSION ON FORWARD SIDE. REMOVED CROSS BRACE FROM FRAME 19.4-32.4 IAW SRM REV 12 51-41-05-00-01. REMOVED STANCHION IAW SM 51-42-05-02-01. BACK DRILLED NEW STANCHION IAW SRM 51-40-07-02-01, REV 12. OK TO INSTALL STANTION MINUSDR AALA20130301011Frame · crackedFRAME CRACKED AT INBOARD ATTACH RIVET OF AIR CONDITIONING SUPPORT BRACKET AT STATION 500C LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE.SDR AALA20130301010Frame · crackedPERFORMED HFEC AND LFEC SURFACE SCAN, CRACK INDICATION AT INBOARD RIVET ON STATION 727D RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE.SDR AALA20130301009Frame · crackedFRAME CRACKED AT INBOARD ATTACH RIVET OF AIR CONDITIONING SUPPORT BRACKET AT STATION 500A LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE.SDR AALA20130301008Frame · crackedFRAME CRACKED AT INBOARD ATTACH RIVET OF AIR CONDITIONING SUPPORT BRACKET AT STATION 480 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE.SDR SIMA20130301004Frame · crackedDURING MAINTENANCE INSPECTION FOUND FRAME 23 CRACKED BETWEEN STRINGERS 15R - 16-R. THE AIRCRAFT WAS REMOVED FROM SERVICE. CUT OUT DAMAGED SECTION, SPLICED IN NEW SECTION PER EO-EM-53MR-1808. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR AALA20130301015Frame · crackedCRACK INDICATION ON FRAME RIVET HOLE AT STATION 440 RIGHT INBOARD RIVET HOLE. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE 0007.SDR AALA20130301014Frame · crackedFRAME CRACKED AT INBOARD ATTACH RIVET OF AIR CONDITIONING SUPPORT BRACKET AT STATION 887 LEFT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE 0007.SDR AALA20130301013Frame · crackedPERFORMED HFEC AND LFEC SURFACE SCAN, CRACK INDICATION ON INBOARD RIVET AT STATION 480 RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE.SDR AALA20130301012Frame · crackedPERFORMED HFEC AND LFEC SURFACE SCAN, CRACK INDICATION ON RIVET AT STATION 727B RIGHT. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AE CARD 0007.SDR FDEA201303010487Frame · damagedMAIN DECK FRAME BS 1100 HAS A DOUBLE DRILLED HOLE BETWEEN S-2R AND S-3R. REMOVED DAMAGE IAW SRM 53-00-07. REPAIR FRAME IAW SRM 53-00-07, FIG 201, REPAIR NR 3, CATEGORY "B" REPAIR LOCATED STA 1100 BETWEEN S-2-3R.SDR FDEA201303010481Frame · corrodedAFT CARGO BAY LEFT SIDE FRAME BS 1360 HAS CORROSION ON FRAME UPPER FLANGE BETWEEN STR 25 AND 26L. REPAIRED FRAME FROM S16-25L IAW EA F-5310-163861, PART 1. REPAIR IS CAT B, MAJOR.SDR ASOA2013031803218Frame · corrodedCORROSION FOUND ON FS 333.00, BETWEEN ON STGRS 27 & 25L. REPAIRED IAW CL6002D24-53-I00153 AND SRM 51-21-06-001-001.SDR QXEA2013022800459Frame · corrodedFRAME FLANGE AT FR 136 STR 33-32S HAS CORROSION. REMOVED RIVETS AS NEEDED AND BLENDED CORROSION IAW SRM REV 12 53-00-00-02-09. MIN THICKNESS NOTED .046", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1, REV 8. APPLIESDR AALA20130301018Frame · crackedTHE 1510 CANT FRAME CRACKED BELOW MAINTENANCE LIGHT SWITCH. INSTALLED DOUBLER PER SRM 53-01-00.SDR DALA13009600943Frame · crackedAFT VAULT DOOR FRAME HAS CRACK PROPAGATING BEYOND STOP DRILL. CRACK IS 0.5 IN LONG LOCATED ON UPPER RT CORNER, 5 IN RT OF CENTER LINE. REPLACED UPPER FRAME AT AFT VAULT DOOR IAW SRM 51-30-2 AND 51-30-5.SDR AALA20130228006Frame · crackedSTATION 380 FRAME HAS TOOLING MARKS AND CRACKED OUTBOARD OF STRINGER 2 LEFT. INSTALLED REPAIR DOUBLER PER EA B737-53-028553.SDR SWAA2013040114306Frame · crackedFRAME CRACKED AT BS 452.4, STR 24R. REMOVED AND REPLACED FRAME IAW EO AND EA.SDR SWAA2013031913820Frame · corrodedFRAME CORRODED AT BS 727E, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR QXEA2013022700427Frame · corrodedFRAME FLANGES AT FR 258.5 STR 33-30P HAVE CORROSION. REMOVED FASTENERS AT FRAME 258.5 FROM STRINGER 30P-33 IAW SRM REV 12 51-42-05-02-01. REMOVED CORROSION FROM SKIN FLANGES AT FRAME 258.5 FROM STRINGER 30P-33 IAW SRM REV 12 53-00-00-02-09. MIN THICKNESS NOSDR QXEA2013022700426Frame · corrodedFRAME FLANGES AT FR 258.5 STR 32-30S HAVE CORROSION. REMOVED FASTENERS AT FRAME X258.5 FROM STRINGER 30S-32S IAW SRM REV 12 51-42-05-02-01. REMOVED CORROSION FROM X258.5 FRAME FLANGES AT STRINGER 30S-32S IAW SRM REV 12 53-00-00-02-09. MIN THICKNESS NOTED .0SDR QXEA2013022700425Frame · corrodedFRAME FLANGES AT FR 116 STR 33-29S HAVE CORROSION. REMOVED 22 RIVETS AND CORROSION FROM FRAME 116 FLANGES STR 33-29S IAW SRM REV 12 53-00-00-02-09. MIN THICKNESS NOTED .026", CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801, PSDR ASAA2013022793999Frame · corrodedUPON REMOVAL OF AFT PIT FLOOR PANEL FOR CARGO TRACK REPAIR FOUND FRAME SHEAR TIE AT STA 867 BETWEEN STR 27L AND 27R CORRODED. REMOVED CORROSION BY BLENDING, FOUND TO BE OUT OF LIMITS REPAIRED AREA IAW SRM 53-00-07, FIG 101 AND 53-60-07, FIG 201.SDR SWAA2013040114307Frame · crackedFRAME CRACKED AT BS 452.4, STR 24R. REMOVED AND REPLACED FRAME IAW EO AND EA.SDR SWAA2013032113951Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013031913809Frame · crackedFRAME CRACKED AT BS 500C, BETWEEN STR 20R AND STR 21R. REPAIRED FRAME IAW SRM.SDR SWAA2013031813715Frame · corrodedAFT CARGO COMPMENT FRAME CORRODED AT BS 946, BETWEEN L-28L TO L-27L. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2013031413629Frame · crackedFUSELAGE FRAME CRACKED AT STA 1022 BETWEEN LONGERONS 13L & 13L. REPAIRED FRAME PER SRM.SDR DALA1306623745Frame · crackedCABIN SIDEWALL FRAME CRACKED, AT S8R BS 480.SDR DALA1306613745Frame · crackedCABIN SIDEWALL FRAME CRACKED AT S8L STA 500A.SDR DALA1306603745Frame · crackedCABIN SIDEWALL FRAME CRACKED AT S8L BS 400. REPAIRED CRACKED FRAME IAW ERA 511653-14AD ORIG 1710055 511653-14.SDR DALA1306593745Frame · crackedCABIN SIDEWALL FRAME CRACKED COMMON TO PSU RAIL SUPPORT BRACKET AT S8L, BS 400.SDR QXEA2013022600479Frame · corrodedFRAME FLANGES, ST FR 236, STR 33-30P HAVE CORROSION. REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. CONFIRMED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801, PT 1 REV 8. FOUND IN LIMITS SRM 53-00-00-02-09, REV 12.SDR QXEA2013022600469Frame · corrodedFRAME FLANGES AT FR 1.0 STR 32-29S HAVE CORROSION. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1 REV 8. FOUND WITHIN LIMITS IAW SRM 53-00-00-02-09 REV 12.SDR QXEA2013022600463Frame · corrodedFRAME FLANGES AT FR 1.0 STR 32-29P HAVE CORROSION. REMOVED RIVETS TO FOM REMOVED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02, REV 12 MIN THICKNESS NTOED .046, CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801, PT 1 REV
Back to JASC 5311