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 SWAA105051Support Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME SUPPORT ANGLE CRACKED AT BS 360, STR 9L. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR SWAA105050Support Angle · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME SUPPORT ANGLE CRACKED AT BS 360, STR 11L. REMOVED AND REPLACED ANGLE PER SRM AND DWG.SDR AALA20100829TUL02Frame · crackedAFT ACCESSORY FRAME CRACKED AT STATION 1418 LONGERON 2 LEFT. INSTALLED DOUBLER REPAIRS ON FORWARD AND AFT SIDE OF FRAME 1418 AT LONGERON 2 LEFT PER AARD 53-10-00-15 AND SRM 53-03-00.SDR AALA20100829TUL05Frame · crackedAFT ACCESSORY STATION 1418 FRAME CRACKED LONGERON 2 RIGHT. INSTALLED REPAIR DOUBLER ON FORWARD SIDE OF FRAME STATION 1418 LONGERON 2 RIGHT PER SRM 53-03-00.SDR FDEA201008283170Frame · damagedNUMEROUS DRILLED HOLES IN FRAME BS 480 RADIUS WHERE NUT-PLATES ARE INSTALLED STR 6L- 9L. ( 7 EA ) REMOVED DAMAGED FRAME, LOCATED & DRILLED NEW FRAME & INSTALLED NEW FRAME IAW SRM 51-30-2 & EA 7-5310-135585.SDR GLBA20100827FFrame · crackedDURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND A THE CARGO PARTITION FUSELAGE ATTACH POINT HOLES ARE WORN, TOP LEFT, TOP CENTER, AND TOP RIGHT. MAINTENANCE INSPECTED AND FOUND THE REPAIR TO BE A MINOR REPAIR - REPAIRED PARTITION ATTACH POINTS, TOP, TSDR AALA20100827TUL03Strap · gougedFRAME STRAP AT LEFT CUSP STATION 1136 GOUGED OUT OF LIMITS. REPLACED STRAP PER SRM 51-30-05.SDR USAA2010083091846Frame · crackedMAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 727B BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 727B BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010083091845Frame · crackedMAJOR REPAIR - CRACK ON FRAME AT BS 616, LBL 63 AT LEVEL OF PRESSURE DECK CENTER SECTION STRUCTURE. REPAIRED FRAME AT BS 616, LBL 63 AT LEVEL OF PRESSURE DECK CENTER SECTION STRUCTURE IAW EA 133033.SDR AALA20100827TUL02Strap · gougedFRAME STRAP AT LEFT CUSP STATION 1127 FOUND GOUGED OUT OF LIMITS. REPLACED STRAP PER SRM 51-30-05.SDR GLBA20100826GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP MX FOUND A CRACK ON THE LT HEAVY FRAME ANGLE AT FS 288 FWD BEND RADIUS, 1.4" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 10-1900-53-053. MATERIALS UTILIZEDSDR FDEA201008263147Frame · corrodedFORWARD CARGO COMPT - FRAME AT STA 740 S 24R - S25R HAS CORROSION REMOVED CORROSION PER SRM 51-20-01. CHECKED LIMITS; ORIG. MATL.; .063", MATL. LOSS; .010", REMAINING; .053". FOUND TO BE OUT OF LIMITS PER SRM 53-00-07, FIG.101, SEC. A- A, P.103. REMOVED SPSDR FDEA201008263158Frame · corrodedAFT PIT, FRAME 990, AFT SIDE SURFACE HAS CORROSION BETWEEN 26R AND 27R. CUT OUT DAMAGE ON BS 990 FRAME BETWEEN STRINGER 26R AND 27R IAW SRM, REV 103, 51-40-4 FIG 2. FABRICATED FILLER, & DOUBLERS IAW SRM 51-40-4 FIG 2. INSTALLED DOUBLERS AND FILLER IAW SRM 51SDR SWAA105044Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR SWAA105043Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER EA.SDR SWAA105015Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8L. REPAIRED FRAME PER EA.SDR SWAA105013Frame · puncturedDURING SCHEDULED 22Y CHECK, FOUND RT FRAME PUNCTURED AT BS 500A, BETWEEN STR 14R TO STR 14L. REPAIRED FRAME PER EA.SDR DALA1024700617Frame · dentedAFT CARGO FRAME DENTED AT STA 1500, STR26L. REPAIRED IAW 53-00-07, PG201, REPAIR 5.SDR USAA2010082591802Frame · crackedPIT - S3 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT FR43, S21L. REPAIRED FUSELAGE FRAME AT FR43, S21L IAW EA 116028.SDR FDEA201008253141Frame · corrodedSURFACE CORROSION ON FORWARD AND AFT SIDES OF STUB FRAME WEB, STATION 950E PLUS 4", STRINGER 29 - 28R REMOVED STUB FRAME AT STATION 950E PLUS 4", STRINGER 29 - 28R IAW SRM, REV 103, 51-30-2. FABRICATED NEW FRAME USING 7075-0, .040" X 21 3/4" X 7" IAW SRMSDR FDEA201008253134Frame · gougedMAIN CABIN, FRAME BS 1280 S10-13R HAVE GOUGES. REMOVED DAMAGE AT STRG 11R- 13R IAW SRM 51-10-02, FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL II, REMOVED DAMAGE FRAME FROM STRG 11-13R, STOP 4(B) HFEC REWORK AREA IAW NTM 51--00-19 PH 6. NO CRACKSDR FDEA201008253128Frame · chafedAFT CARGO BAY FRAME AT STA 1480 , S23R CHAFED. BLENDED CHAFE PER SRM 51-10-02 ORIG MATERIAL THICKNESS 0.063, MATERIAL LOSS 0.033, MATERIAL REMAIN 0.030 FOUND AREA OUT OF LIMITS PER SRM 53-00-07 INSTALLED REPAIR SPLICE PER SRM 51-40-02 AND 51-20-05 . FOUNSDR DALA1024690617Frame · dentedFUSELAGE FRAME DENTED STA 1340 STR 26R. INSTALLED REPAIR DOUBLER IAW 53-00-07 REPAIR 5 PG 204.SDR GUUA93853082410CFrame · crackedDURING SCHEDULED ROUTINE MX DISCOVERED ASD ANGLE CRACKED AT FS 150 STRINGER 5L APPROX. REMOVED DAMAGED SECTION OF ANGLE AND INSTALLED FRAME ANGLE REPAIR.SDR USAA2010082591795Frame · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FRAME AND FRAME RE-ENFORCEMENT AT BS 500B, BETWEEN S20R TO S21R. REPAIRED FRAME AND FRAME RE-ENFORCEMENT AT BS 500B, BETWEEN S20R TO S21R IAW B737 SRM 53-00-07 REPAIR 13.SDR SWAA104974Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME PER EA.SDR SWAA104973Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SIMA201023701Frame · crackedDURING MAINTENANCE BASE VISIT INSPECTION FOUND THE RIGHT FRAME 23 CRACKED IN 2 LOCATIONS BETWEEN STRINGERS 15 RIGHT AND 14 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. THE CRACK LENGTHS ARE .25 AND .75 INCH. REPAIRED FRAME 23R IAW EO EM-53MR-1634. THE ACFSDR VGQY2010082400122Strap · damagedMAIN DECK - BS 720 RT FOUND FRAME STRAP WITH DEEP CUTTING MARKS BETWEEN STR 22-23. COMPLIED WITH EN1180-10, ALTERNATE FABRICATION OF FRAME STRAP 65B01729-197 AT STA 720, BETWEEN S-22R & S-23R.SDR FDEA201008233105Frame · misrepairedFWD CARGO - EXISTING REPAIR AT CARGO SIDE AFT DOOR JAMB. EXISTING REPAIR AT FWD CARGO, CARGO SIDE AFT DOOR JAMB EVALUATED AND FOUND PREVIOUSLY ACCOMPLISHED NOT IAW SRM REPAIR SCHEME. NEW REPAIR CARRIED OUT IAW EA 8-5310-143729. TITLE: FUSELAGE - MAIN FRAME - FSDR FDEA201008233113Frame · crackedAFTER REMOVAL OF TV MONITOR BRACKETS FOUND FRAME CRACKED STA 377-7, BETWEEN S-1 TO S-2L. CRACKED FRAME STA 377.7 S-5L TO S4R FOUND OUT OF LIMITS IAW SRM 53-00-07 FIG 101 DETAIL I. REMOVED AND REPLACED FRAME IAW SRM 51-40-02. CLASSIFIED CATEGORY "A" MAJSDR FDEA201008233107Frame · gougedMAIN CARGO DOOR FWD FRAME INNER SKIN IS GOUGED IN NUMEROUS PLACES BS 480. REMOVED DAMAGED FWD INNER SKIN , FABRICATED NEW INNER SKIN & INSTALLED NEW SKIN AT CUTOUT FWD IAW SRM 51-30-5, SRM 51-30-2, & DWG NR 53FX1551.SDR SWAA104938Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER SRM.SDR FDEA201008223091Frame · crackedFUSELAGE - FWD AVIONICS COMPARTMENT STA 348 FRAME AT LONGERON 28 RT FOUND CRACKED. FUSELAGE - FWD AVIONICS COMPARTMENT STA 348, FRAME AT LONGERON 28 RT. R & R IAW SRM 51-31-01, VOL II, REV 96. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 110.SDR IPXA10562055Frame · dentedINSPECTION TYPE:C2, FRAME DENTED BS1500, STR 25-26 RT. REPAIRED IAW SRM 53-00-07-2R5.SDR IPXA10562054Frame · dentedINSPECTION TYPE:C2, FRAME DENTED BS 1480, STR 23-24 LT. REPAIRED IAW SRM53-00-07-2R5.SDR IPXA10562053Frame · dentedINSPECTION TYPE:C2, FRAME DENTED BS 1500 STR 23-24 LT REPAIRED IAW SRM 53-00-02-1A, 53-00-07-2R5.SDR IPXA10562052Frame · dentedINSPECTION TYPE:C2, FRAME DENTED BS 1340 STR 25-26 LT. REPAIRED IAW SRM53-00-07-2R5.SDR FDEA201008203056Frame · misrepairedFWD CARGO - EXISTING REPAIR AT LOWER FRAME STA 1099, "X" = -38 TO "X" = -48. EXISTING REPAIR AT FWD CARGO LOWER FRAME STA 1099, "X" = -38 TO "X" = -48 EVALUATED AND FOUND PREVIOUSLY ACCOMPLISHED NOT IAW ANY APPROVED DATA. EXISTING REPAIR FOUND TO BE ACCEPTABSDR USAA2010090791925Frame · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FRAME AT AIR CONDITIONING SUPPORT BRACKET AT BS 827 BETWEEN S8R & S9R. REPAIRED FRAME AT BS 827 BETWEEN S8R & S9R IAW TYPICAL REPAIR 53-10-20E & B737 SRM 51-40-02.SDR USAA2010082591794Frame · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 616, RBL 63. REPAIRED FUSELAGE FRAME AT BS 616, RBL 63 IAW EA 133033.SDR USAA2010092092036Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 747 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 747 BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010092092035Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 827 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 827 BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010083191877Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 440 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 440 BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010083191876Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 480 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 480 BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010083091866Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 787 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 787 BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010082791830Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500C BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 500C BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010082791829Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 400 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 400 BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR USAA2010082791828Frame · crackedCLT - Q2 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 827 BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 827 BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR QMLA2010081910053Doubler · damagedUPON INSP REQUIRED FOR AAIP FLIP, A CRACK WAS DISCOVERED ON THE CO-PILOTS 25 DEGREE FRAME DOUBLER THAT WAS INSTALLED IAW SB 53.00.41. DOUBLER WAS RE-RIVETED IN PLACE, AND SEALED. NO FURTHER DEFECTS OR DISCREPANCIES NOTED. ACFT RETURNED TO SERVICE.
Back to JASC 5311