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 IPXA10562060Frame · damagedINSPECTION TYPE:C2, SCREW STRIKE ON FRAME, INBD FLANGE, AT BS 1580 BETWEEN S-15L AND S-16L. REPAIRED IAW ER 10-3846.SDR FDEA201007282706Frame · dentedAFT CARGO COMPARTMENT BS 1090 ABOVE STR 26L FRAME UPPER FLANGE IS DENTED AT RADIUS. CUT OUT DAMAGED UPPER FLANGE OF FRAME ABOVE STR 25L DIM 1"X1" AND ABOVE STR 26L, DIM 1"X1" IAW SRM 51-10-1. FABRICATED REPAIR DOUBLER FROM 7075 0 .080 DIM 24"X6.3750" IAW SRM SDR FDEA201007282705Frame · corrodedCORROSION ON FRAME AT BS 500 BETWEEN STRINGERS 27R AND 26R. CUT OUT CORRODED SECTION OF FRAME IAW SRM 51-40-2, FIG 1 FABRICATED FILLER AND DOUBLER IAW SRM 51-40-2, FIG 1 AND 53-10-2 INSTALLED REPAIR PARTS IAW SRM 51-40-2 FIG 1 AND 51-30-2, REV 103.SDR K11A2010070272201Frame · corrodedFRAME WEB CORROSION AT RT HORIZONTAL WALKWAY.SDR COMA2010072850157Angle · crackedAT FS 559.00 THE FRAME CAP ANGLE IS CRACKED AT RBL 18.00. REPAIRED RT CAP ANGLE AT RBL 18 IAW REO 601R-53-41-260 RT REP.SDR GLBA20100728FFrame · crackedDURING A SCHEDULED ROUNTINE INSP A CRACK WAS FOUND IN THE FRAME ANGLE AT FS 303, .5" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 10-1900-53-045. MATERIALS UTILIZED ARE INCLUDED IN THE ENGINEERING ORDESDR GLBA20100729GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, A2 CRACKS WAS FOUND IN THE FRAME AT FS 456 AND STRINGER 10R CUTOUT, .45" AND .5" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 10-1900-53-046. MATERIALS UTISDR SWAA104362Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 951, STR 11L. REPAIRED FRAME PER SRM.SDR SWAA104361Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CHORD CRACKED AT BS 348, LBL 50. REPAIRED CHORD PER SRM.SDR USAA2010072891522Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500D BETWEEN S19R TO S22R. REPAIRED FUSELAGE FRAME AT BS 500D BETWEEN S19R TO S22R IAW EA 102060 & B737 SRM 53-00-07.SDR USAA2010072891521Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L IAW B737 SRM 53-00-07.SDR SWAA104311Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 993.5, STR 17R. REPAIRED FRAME PER EO.SDR IPXA10562154Frame · damagedINSPECTION TYPE:C2, MAIN CARGO COMPARTMENT SCREW STRIKES ON INBD FRAME FLANGE, BS 395, S6L. REPAIRED IAW ATS ER 10-3822, DATED 8-24-10.SDR IPXA10562153Frame · damagedINSPECTION TYPE:C2, MAIN CARGO COMPARTMENT SCREW STRIKES ON INBD FRAME FLANGE BS 395 BETWEEN STR 10L AND 11L. REPAIRED IAW ATS ER NR 10-3822, DATED 8-24-10.SDR IPXA10562136Frame · damagedINSPECTION TYPE:C2, MAIN CARGO COMPARTMENT SCREW STRIKES ON INBD FRAME FLANGE BS 345 BETWEEN STR 9L AND 10L. REPAIRED IAW ATS ER10-3823, DATED 8-24-10.SDR IPXA10562135Frame · damagedINSPECTION TYPE:C2, MAIN CARGO COMPARTMENT SCREW STRIKES ON INBD FRAME FLANGE, BS 345 BETWEEN STR 10L AND 11L. REPAIRED IAW ATS ER 10-3823 DATED 8-24-10.SDR IPXA10562134Frame · damagedINSPECTION TYPE:C2, MAIN CARGO COMPARTMENT SCREW STRIKES ON INBD FRAME FLANGE BS345 BETWEEN STR11L AND 12L. REPAIRED IAW ATS ER 10-3823 DATED 8-24-10.SDR ASAA1048220Frame · crackedFRAME AT STA 500G CRACKED BETWEEN STR 27L AND 26L. CUT OUT DAMAGE AND INSTALLED REPAIR.SDR ASAA1048199Frame · crackedCRACKS ON FRAME AT BS 500G. ONE CRACK IS AT RBL 13.8 THE OTHER AT RBL 21. REPAIRED FRAME.SDR ASAA1048195Frame · crackedFRAME AT STATION 827L HAS CRACK BETWEEN STRINGERS 8 & 9 AT OH BIN MOUNT FASTENERS. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1048194Frame · crackedFRAME AT STATION 787L HAS CRACK BETWEEN STRINGERS 8 & 9 AT OH BIN MOUNT FASTENERS. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1048193Frame · crackedFRAME AT STATION 747L HAS CRACK BETWEEN STRINGERS 8 & 9 AT OH BIN MOUNT FASTENERS. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1048192Frame · crackedFRAME AT STATION 727F HAS CRACK BETWEEN STRINGERS 8 & 9 AT OH BIN MOUNT FASTENERS. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1048191Frame · crackedFRAME AT STATION 727D HAS CRACK BETWEEN STRINGERS 8 & 9 AT OH BIN MOUNT FASTENERS. REMOVED DAMAGED AREA INSTALLED REPAIR.SDR ASAA1048190Frame · crackedFRAME AT STATION 440L HAS CRACK BETWEEN STRINGERS 8 & 9 AT OH BIN MOUNT FASTENERS. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR ASAA1048189Frame · crackedFRAME AT STATION 400L HAS CRACK BETWEEN STRINGERS 8 & 9 AT OH BIN MOUNT FASTENERS. REMOVED DAMAGED AREA, INSTALLED REPAIR.SDR FDEA201007262667Frame · misrepairedEXISTING REPAIR AT WASTE TANK COMPARTMENT FRAME STATION 1986 L-50L TO L-50R. PRVIOUSLY ACCOMPLISHED NOT IAN ACCORDANCE WITH SRM REPAIR SCHEME. EXISTING REPAIR REMOVED AND REPLACED WITH NEW REPAIR AS PER SRM 53-30-00 FIG. 5 VOL. 1 REV. 96. EO 8-5100-7-5001 ASDR V0XR20100726002Frame · corrodedDOUBLERS AT FRAME 20 AND 22 AT RY479.0 ARE CORRODED OUT OF LIMITS. DRILLED OFF OLD DOUBLERS, MATCH DRILLED TWO EACH NEW DOUBLERS AND INSTALLED IAW SRM 51-20-03 AND 51-40-02. W/C 1062.SDR ASAA1048144Frame · dentedAFT PIT RT 727F FRAME HAS DENT ON UPPER SURFACE ABOVE STR 24R. REMOVED DAMAGED AREA AND INSTALLED REPAIR.SDR ASAA1048143Frame · dentedAFT PIT LT STA 727F FRAME HAS 2 DENTS ON UPPER SURFACE. REMOVED DAMAGED AREA AND INSTALLED REPAIR.SDR ASAA1048142Frame · dentedAFT PIT RT 747 FRAME DENTED UPPER SURFACE BETWEEN STR 24 & 25. REMOVED DAMAGED AREA AND INSTALLED REPAIR.SDR ASAA1048141Frame · dentedAFT PIT RT 727C FRAME DENTED UPPER SURFACE BETWEEN STR 24 & 25. REMOVED DAMAGED AREA AND INSTALLED REPAIR.SDR DALA1017593269Support · corrodedDURING M-CHECK FOUND CORROSION ON AFT CABIN RT FRAME SUPPORT BETWEEN FR69 & FR70. REPAIRED PER SRM 51-42-11 & SRM 51-44-11.SDR FDEA201007242658Frame · gougedMAIN CABIN, INTERNAL STRUCTURE FRAME BS 180, STRG 14L, STRG 10L, HAVE GOUGES. REPAIR FRAME BS 1280 LT IAW SRM 53-00-07, FIG 201, REPAIR NR 1.THIS IS A CAT B REPAIR WITH SUPPLEMENTAL INSPECTIONS REQUIRED IAW TABLE 203 OF SRM 53-00-07, FIG 201, REPAIR NR 1. MAJSDR VGQY2010120300131Frame · corrodedACFT WAS IN FOR A HEAVY 'D' TRANSITION CHECK). CORROSION WAS FOUND ON INBD FLANGE OF LOWER CHORD. PN 65B10538-151, OTBD OF NR1 ACM BETWEEN STA 1020-1030, LBL 60-80/ AIR-CON PANELS NR191AL & NR191BL SUPPORT FRAME. CORROSION REMOVED AS PER SRM 51-10-01 REV 117SDR AALA20100723TUL14Beltframe · damagedSTATION 887 TOOLING DAMAGE BETWEEN 3L AND 2L IN RADIUS OF FRAME. ACCOMPLISHED REPAIR PER SRM 51-70-11-2R.SDR IPXA10562248Frame · dentedINSPECTION TYPE:C2, FRAME DENTED IN FWD CARGO BAY BS 660 BETWEEN STR 24R - STR 25R. REPAIRED IAW PF SRM 53-00-07-2R-5, DETAIL III.SDR IPXA10562093Frame · dentedINSPECTION TYPE:C2, FRAME DENTED IN FWD CARGO BAY BS 680, BETWEEN STR 24L - STR 25L. REPAIRED IAW SRM 53-00-07-2R-5, DETAIL III.SDR IPXA0562025Frame · dentedINSPECTION TYPE:C2, FRAME DENTED IN FWD CARGO BAY AT BS 820, STR 24L. REPAIRED FRAME AT BS 820, STR 24L IAW SRM 53-00-07-1A1, SRM 53-00-07-2R5, SRM 51-40-02-0G, DWG 140N2002, SHT 158, SRM 51-30-01-0G, DWG 65-88700 SH 1, SRM 51-40-05-0G.SDR IPXA0561981Frame · dentedINSPECTION TYPE:C2, FRAME DENTED IN FWD CARGO BAY AT BS 740, BETWEEN STR 24L - STR 25L. REPAIRED IAW SRM 53-00-07-2R5.SDR USAA2010080691612Frame · corrodedCLT - Q1 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON AFT CARGO FRAME AT BS807 BETWEEN LBL 5 TO RBL 5. REPAIRED AFT CARGO FRAME AT BS 807 BETWEEN LBL 5 TO RBL 5 IAW B737 SRM 53-00-07.SDR USAA2010080691611Fitting · corrodedCLT - Q1 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON AFT CARGO FRAME FOOT AT BS 827 BETWEEN LBL 5 TO RBL 5. REPAIRED AFT CARGO FRAME FOOT AT BS 827 BETWEEN LBL 5 TO RBL 5 IAW B737 SRM 53-00-07 REPAIR 10.SDR IPXA10562255Frame · dentedINSPECTION TYPE:C2 FWD CARGO FRAME HAS DENT IN UPPER FLANGE BS 800, BETWEEN STR 24R-25R. REPAIRED IAW SRM 53-00-07-2R5.SDR IPXA10561881Frame · dentedINSPECTION TYPE:C2, FWD CARGO FRAME HAS DENT IN UPR FLANGE, BS 800, STR 23L-24L. REPAIRED IAW SRM 53-00-007-2R5.SDR IPXA10561879Frame · dentedINSPECTION TYPE:C2, FWD CARGO FRAME HAS DENT IN UPPER FLANGE, BS 800, STR 23L-24L. REPAIRED IAW SRM 53-00-007-2R5.SDR AALA20100722TUL11Frame · crackedFRAME 1418 CRACKED AT LONGERON 2 RIGHT. INSTALLED DOUBLER IAW EA MD80-53-011690.SDR IPXA10561464Shear Tie · bentINSPECTION TYPE:SP, SHEAR TIE BETWEEN STR 14R AND STR 15R AT BS1681 HAS DAMAGE FROM THE FRAME BEING BENT. REPAIRED IAW EO 757-5310-38992-A, SRM51-40-02, ER 10-3727, DATED 02AUG10.SDR FDEA201007222640Frame · misrepairedEXISTING REPAIR AT FWD CARGO FRAME STA 919, L-51L TO L-51R. EVALUATED AND FOUND NOT IN ACCORDANCE WITH ANY SRM. REMOVED AND AND NEW REPAIR ACCOMPLISHED PER SRM 53-00-01 FIG 8 VOL I REV 96 EO 8-5100-7-5001 A7 PT2, REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-10SDR FDEA201007222639Frame · misrepairedEXISTING REPAIR AT FUSELAGE FWD CARGO FLOOR LANDING STA 899 L-49L TO L-50L. EVALUATED AND FOUND NOT CONFORM TO SRM. REMOVED AND REPLACED WITH NEW REPAIR AS PER SRM 53-00-01 FIG 8 VOL 1 REV 96 EO 8-5100-7-5001 A7 P1 REPAIR CLASSIFIED AS MAJOR AS PER GMM 6-2-10SDR IPXA10562254Frame · damagedINSPECTION TYPE:C2, FRAME HAS A DRILL START IN PREVIOUS REPAIR AREA BS 1280, STR 25-26 RT. REPAIR IAW ER 10-3697, DATED 27-AUG-2010.
Back to JASC 5311