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 UALA2010082003070Frame · corrodedAFT CARGO BAY, STA 1460, RBL 16 TO 20, FRAME IS CORRODED. REMOVED CORROSION FROM FRAME SM1460 RBC 16-20 ORIGINAL THICKNESS .063 MATERIAL REMOVED .0004 MATERIAL REMAINING .059, FOUND TO BE WITHIN LIMITS, REINSTALLED ATTACH FITTINGS OF TRANSITION PANEL.SDR AALA20100819TUL01Frame · crackedCRACK FRAME STATION 1418 AND LONGERON 2 LEFT. INSTALLED DOUBLER PER SRM 53-03-00 FIG 31.SDR SWAA104919Failsafe · corrodedDURING SCHEDULED 24Y CHECK, FOUND FAIL SAFE CHORD CORRODED AT BS 500D, STR 28L. REMOVED AND REPLACED CHORD PER SRM AND BAC DWG.SDR SWAA104918Failsafe · corrodedDURING SCHEDULED 24Y CHECK, FOUND FAIL SAFE CHORD CORRODED AT BS 500D, STR 28R. REMOVED AND REPLACED CHORD PER SRM AND BAC DWG.SDR FDEA201008173015Frame · deformedMAIN DECK CARGO - FRAME AT STA 1761, LONGERON 12L, FOUND DEFORMED. MAIN DECK CARGO - FRAME AT STATION 1761 LONGERON 12L REPAIRED AS PER SRM 53-00-07 FIGURE 201 REVISION 44. THIS REPAIR IS CLASSIFIED AS MINOR AS PER FEDEX GMM 6-2-100 REVISION 110.SDR FDEA201008173016Frame · deformedMAIN DAECK CARGO - FRAME AT STA 1681, LONGERON 12L, FOUND DEFORMED. MAIN DECK CARGO - FRAME AT STATION 1681 LONGERON 12L REPAIRED AS PER SRM 53-00-07 FIGURE 201 REVISION 44. THIS REPAIR IS CLASSIFIED AS MINOR AS PER GMM 6-2-100 REVISION 110.SDR USAA2010082391752Frame · crackedCLT - Q5 - MAJOR REPAIR - FRAME AT BS 380, BELOW S13R CRACKED. REPAIRED FRAME AT BS 380 BELOW S13R IAW EA 102125 & 102085.SDR GLBA20100818FFrame · crackedDURING A SCHEDULED ROUNTINE INSP, A CRACK IN THE FRAME AT FS 456 WAS FOUND AT STRINGER CUTOUT 10R, .25" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 10-1900-53-050. MATERIALS UTILIZED ARE INCLUDED IN TSDR UALA2010081703006Frame · corrodedAFT CARGO BAY, STA 1460, LBL 1 TO 9, FRAME IS CORRODED. MAJOR REPAIR ACCOMPLISHED: SMC005 ON NONROUTINE CARD 2217N00334 .SDR VGQY2010081700113Frame · crackedCABIN - DURING HFEC INSPECTION ON TENSION TIE AND FRAME AT RT BS 840, FOUND 01EA HOLE CRACK INDICATION ON FRAME WEB AND DOUBLER STACK UP. FRAME AT RIGHT BS 840 CUT OUT PER SRM 53-10-04 FIGURE 133 REVISION 117. HFEC INSPECTION CARRIED OUT ON CUT OUT AREA & FSDR FDEA201008163006Frame · crackedFWD PIT DOOR FRAME BELOW DOOR MOTOR HAS STRESS CRACK ON LOWER SURFACE. REMOVED DAMAGE IAW SRM 53-50-00, PERFORMED HFEC OF REMOVAL AREA IAW NTSPM 06-10-01 WITH NO CRACK INDICATIONS NOTED. REPLACED TEE ANGLE AT STA 919 FROM EXTRUSION 60-10846 BATCH 0001894810 IASDR SWAA104840Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 663.75, STR 2L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA104838Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 663.75, STR 1. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA104834Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FWD CARGO BAY FRAME CRACKED AT BS 500C, STR 20R TO STR 21R. REPAIRED FRAME PER EA.SDR SWAA104794Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 500D RT. REPAIRED FRAME PER SRM.SDR SWAA104793Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 663.75, STR 2R. REMOVED AND REPLACED FRAME PER SRM.SDR C2XA10SH267Frame · crackedSHV - DURING C-CHECK RT FRAME 10 HAS WORKING RIVET BELOW DV WINDOW. MAINTENANCE REMOVED AND REPLACED RT FRAME 10 IAW EMB-145 SRM 51-40-02. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA1021860193Frame · crackedCABIN RT BS 903 BTWN S20R-21R. FRAME INNER CHORD FOUND CRACKED. REPAIRED IAW ER/A 482276-14AD.SDR ASOA201001123Frame · corrodedCORROSION FWD AND AFT SIDE OF 349 FRAME AND LOWER LEG BTWN STRINGER 26L AND 26R (BELLY) NEW 349, FRAME NEEDS TO BE DRILLED AND INSTALLED. DRILLED NEW FRAME SRM 22 51-40-11. INTERCOSTALS AT STR 25L & 25R, VERTICAL POST AT FS 349L, DRAIN MAST CHANNEL, SUPPORT SDR U2RA227DHN020Frame · chafedMAIN CABIN STA 1280 BETWEEN S13R AND S10R FRAME CHAFED 3 EA PLACES.SDR VGQY2010081300092Frame · crackedCABIN - DURING HFEC OPEN HOLE INSPECTION ON TENSION TIE AND FRAME AT LT BS 820, FOUND 01 EA HOLE CRACK INDICATION ON FRAME WEB AND DOUBLE STACK UP. REPAIR CARRIED OUT AS PER B747 SRM 53-10-11 REV 117 FIGURE 2.SDR DALA1021870193Frame · crackedCABIN LT BS 903 BTWN S20L-21L. FRAME INNER CHORD FOUND CRACKED AND REPAIRED IAW ER/A 482276-14AD.SDR ASOA201001100Frame · corrodedCORROSION ON AFT SIDE OF FRAME FS 333 BETWEEN 26L & 26R. REINSTALL REMOVED FASTENERS AND RESTORE FINISH. INSTALLED 3 FASTENER, RESTORED FINISH, AND APPLIED CIC PER SRM 51-42-06, 51-21-16, AND 51-21-11.SDR SIMA201022805Frame · damagedDURING MAINTENANCE BASE VISIT INSPECTION FOUND THAT RIGHT FRAME 64 HAS TOOL MARKS BETWEEN STRINGER 8 RIGHT AND 9 RIGHT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED RIGHT FRAME 64 BETWEEN STRINGER 8 RIGHT AND 9 RIGHT IAW EO EM-53MR-1621. AIRCRAFT WAS RETSDR SIMA201022804Frame · crackedDURING MAINTENANCE BASE VISIT INSPECTION FOUND FRAME 70 ON THE RIGHT BETWEEN STRINGER 12 RIGHT AND 13 RIGHT TO HAVE A CRACK .5 INCH LONG. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 70 ON THE RIGHT BETWEEN STRINGER 12 RIGHT AND 13 RIGHT IAW EO EM-5SDR AALA20100812TUL05Failsafe · damagedFAIL SAFE CORD DAMAGED AT STATION 907 AT FLOOR LINE. REPAIRED PER EA B737-53-012272.SDR AALA20100812TUL01Frame · crackedCRACK FOUND IN RADIUS OF FRAME STATION 864 RIGHT SIDE. COMPLETED INSTALL FRAME REPAIR PER SR 09530282 AND K3290AG AND SERVICE BULLETIN MD80-53A301.SDR SWAA104760Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 420, STR 1. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA104747Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 277, STR 16L. REPAIRED FRAME PER SRM.SDR K11A2010081172201Frame · crackedFRAME CRACKED ABOVE R1 DOOR.SDR A6WA201040584Frame · crackedFOUND RBL 9 CRACKED INBD SIDE FROM LOWEST RIVET TO EDGE OF POST REPAIR BY INCORPORATION OF REO 601R-53-41-260, REV D, 601R-53-41-609, REV B & REO 601R-53-41-1116, REV A TO LT AND RT SIDES, LBL 27 TO RBL.SDR USAA2010082691819Support · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 CORROSION ON FRAME SUPPORT BETWEEN FR69 TO FR70, S23R. REPLACED FRAME SUPPORT BETWEEN FR69 TO FR70, S23R IAW A320 SRM 51-42-11.SDR ASOA201001170Frame · corrodedTHERE IS AN AREA OF LIGHT SURFACE CORROSION ON AFT FACE OF FS 349 JUST LT OF 6 O'CLOCK POSITION INTERNALLY. UPON ASSESSING THE DAMAGE, FOUND THE CORROSION ON AFT FACE OF FS 349.00 BOTTOM FRAME SECTION TO BE BEYOND ALLOWABLE LIMITS IAW SRM 53-00-00, FIG 102 (SDR CALA2010081300388Frame · crackedSUPPORT TASK CRACK IN FRAME AT STA 303.9, S16L IN INSP ARE IAW FIG 7 OF EA5310-04659. LWR OTBD RADIUS OF OVAL HOLE APPROX .700 IN LONG. REPAIRED CRACK IAW ECRA 5311-01501. DIP INITIATED LP 9719570 LOG PAGE ENTERED IN DEF STATUS IN ERROR. DIP FOR THIS L/P WASSDR USAA2010081291653Support · corrodedPIT - S5 - MAJOR REPAIR - LEVEL 2 CORROSION ON FRAME SUPPORT BETWEEN FR69 TO FR70, S23R. REPLACED FRAME SUPPORT BETWEEN FR69 TO FR70, S23R IAW A320 SRM 51-42-11.SDR SWAA104712Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, RBL 21. REPAIRED FRAME PER ER.SDR SWAA104711Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, RBL 21. REPAIRED FRAME PER ER.SDR SWAA104710Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, RBL 21. REPAIRED FRAME PER ER.SDR UALA2010081102905Frame · damagedINTERNAL FRAME 5 LT SIDE EXPERIENCED TOOLING DAMAGE DURING INSTALLATION OF PREVIOUS DOUBLER REPAIR ABOVE STATIC PORT. REMOVED & REPLACED FRAME NR 5 FROM BELOW CAPTAINS WINDOW TO JUST BELOW SKIN LAP.SDR UALA2010081102904Frame · damagedINTERNAL FRAME 4 LT SIDE EXPERIENCED TOOLING DAMAGE DURING INSTALLATION OF PREVIOUS DOUBLER REPAIR ABOVE STATIC PORT. R & R FRAME NR4 FROM BELOW CAPTAIN'S WINDOW TO JUST BELOW SKIN LAP.SDR ASOA201001090Frame · corrodedCORROSION ON FWD AND AFT SIDE OF 349 FRAME AND LOWER LEG BETWEEN STRINGERS 26L TO 26R BELLY. REMOVED FASTENERS THROUGH SKIN, DRILLED OUT FASTENERS THROUGH TOP OF FRAME FROM STR25L TO 25R, REMOVED GUSSETE & TRACK SUPPORT. REMOVED FASTENERS THROUGH TIE STRAP SDR FDEA201008092895Frame · crackedCABIN RT STA 1781, STR 11R, FRAME FOUND CRACKED. REPAIRED IAW SRM 53-30-00, FIG 5 (SHEET 1) VOL I, REV 96. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 110. INITIAL INSP TO BE CARRIED OUT ON 12,000 FLIGHT CYCLES AND REPETITIVE INSP ON 8,000 FLIGHT CYCLES.SDR FDEA201008092892Frame · damagedMAIN DECK CARGO RT STA 5-53 L-12 FRAME FOUND DAMAGED. REPAIRED IAW SRM 53-00-07, FIG 201 REPAIR 4, REV 44. REPETITIVE INSP REQUIRED INITIAL AT 12,000 CYCLES AND REPETITIVE AT 8,000 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07, FIG 201, REPAIR 4 REV 44. REPAIR CSDR FDEA201008092891Frame · dentedMAIN DECK CARGO RT STA 5-33 L-12 FRAME FOUND DENTED. REPAIR CARRIED OUT IAW SRM 53-00-07, REPAIR 2 FIG 201, REV 44. INITIAL INSP TO BE CARRIED OUT ON 14,500 FLT CYCLE AND REPETITIVE INSP ON 9,500 FLT CYCLE IAW SRM 53-00-07, REPAIR 2, TABLE 201, REV 44. REPAISDR SWAA104697Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 727E, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA104695Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 867, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA104694Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 500A, BETWEEN STR 28L TO STR 28R. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA104691Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 747, BETWEEN STR 26R TO STR 27R. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA104688Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 887, BETWEEN STR 27R TO STR 27L. REMOVED AND REPLACED FRAME PER SRM.SDR SWAA104685Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME CRACKED AT BS 807, STR 25L. REPAIRED FRAME PER SRM.
Back to JASC 5311