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 SWAA106729Frame · crackedDURING SCHEDULED 16Y CHECK, FOUND FRAME WEB CRACKED AT BS 303.9, STR 16L. REPAIRED WEB PER ACO AND EA.SDR GLBA20101027GFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP MX FOUND A .5" CRACK IN THE LT HEAVY ANGLE IN THE BEND RADIUS AT FS 303.25. MX REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 10-1900-53-061. MATERIALS UTILIZED ARE INCLUDED IN THESDR FOTR2016911019Frame · corrodedFRAME STA. 1485 RT VERTICAL STIFFNER CORRODED. REPAIRED NR 11019 FASI W/0 20169.SDR FOTR201728912Frame · crackedFRAME CRACKED AT STA 328 BETWEEN S13-14R. REPAIRED ON NR 8912 W/O 20172.SDR FOTR201728911Frame · crackedFRAME CRACKED AT STA 312 BETWEEN S13-14R. REPAIRED ON NR 8911 FASI W/O 20172.SDR AALA20101028AFW02Frame · damagedFOUND EXTENSIVE DAMAGE TO STATION 500 FUSELAGE CIRCUMFERENTIAL FRAME INNER CHORD BETWEEN STRINGER 28 TO 31 LEFT DUE IMPACT DAMAGE FROM CARGO PALLETS. PERFORMED HIGH FREQUENCY EDDY CURRENT SURFACE SCAN TRIMMED EDGES OF REMAINING CHORD, REMOVED ALL NICKS, SCRATSDR SWAA106684Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REPAIRED FRAME PER EA.SDR SWAA106683Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8R. REPAIRED FRAME PER EA.SDR SWAA106682Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER EA.SDR SWAA106681Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8R. REPAIRED FRAME PER EA.SDR SWAA106680Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA106679Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727A, STR 8L. REPAIRED FRAME PER EA.SDR SWAA106667Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER EA.SDR SWAA106654Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 847, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR V0XR201010220001Frame · corroded(V0XR) FRAME AT STN 270.5 BETWEEN STR 28P - 29P CORRRODED BEYOND LIMITS. REMOVED AND REPLACED ANGLE. W/C 1079SDR AALA20101026TUL02Frame · crackedCRACK IN THE FRAME AT STATION 1418 AT LONGERON 2 RIGHT AND LONGERON 2 LEFT. REPAIRED PER SRM 53-03 FIGURE 31A AND EA MD80-53-013742.SDR SIMA201030102Frame · crackedDURING MAINTENANCE INSPECTION FOUND FRAME 23 CRACKED BETWEEN STRINGERS 15 RIGHT AND 16 RIGHT UNDERNEATH AFT SERVICE DOOR SILL. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 23 IAW EO EM-53-MR-1681. AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA106608Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER SRM AND BAC DWG.SDR CALA2010102500498Frame · crackedSUPPORT TASK - WHEN PERFORMED EA 5310-04659 OP 2 INSPECTION FOUND CRACK ON FRAME WEB STA 303.9 AT STR 16L. REPAIR FRAME WEB AT STA 303.9 AT STRINGER 16L PER EA 5310-0465 9 OP 2.SDR DALA1029459002Frame Splice · corrodedAFT CARGO STA 1231 FRAME SPLICE AT LONGERON 29RT TO 30RT HAS CORROSION. REPLACED FRAME SPLICE PER SRM 53-14-3 FIG 3A, 53-01 FIG 1, AND DRAWING 9919603. (DLM88102925)SDR FDEA201010244159Frame · damagedMAIN DECK - WHILE CARRYING OUT EO 1-2620-7-5005C PT1, 3 EACH EXTRA HOLES DRILLED ON FRAME AT STA 1964 BETWEEN LONGERON 2L TO LONGERON 3L. 03 EACH EXTRA HOLES DRILLED AT MAIN DECK WHILE CARRYING OUT EO 1-2620-7-5005 C PT1 AT STA 1964 BETWEEN LONGERON 2L TO 3L RSDR SWAA106581Frame · corrodedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 947, RBL 17. REPAIRED FRAME PER SRM.SDR DALA1050356902Frame · dentedFWD E/E FRAME DENTED STA 231. REPAIRED IAW ERA 486859-14, REV O.SDR DALA1029369002Frame · corrodedAFT ACC COMP STA 1380, FRAME CORRODED IN SEVERAL PLACES FROM LONGERON 24L TO 24R. REMOVED AND REPLACED FRAME IAW MD88 SRM 51-30-2 AND DRAWING 5911429. (DLM88102907)SDR DALA1029269002Frame · corrodedDURING HMV AT PEMCO DHN FOUND CORRODED FRAME AT STA 1309 BETWEEN L28L AND L28R. REMOVED CORROSION FOUND TO BE OUT OF LIMITS IAW 53-01 FIG 1. CUT OUT DAMAGE SECTION, OBTAINED NEW FRAME, LOCATED, DRILLED AND INSTALLED FRAME, REPAIR ANGLES, SPLICE PLATES IAW MDSDR DALA1028789865Frame · crackedDURING M-CHECK FOUND CRACK IN FRAME AT BS 541 L17L AT FASTENER ATTACHMENT. REPAIRED PER SRM 53-03 FIGURE 32.SDR V0XR201010220005Frame · corroded(V0XR) FRAME FLANGE STN 488.5 BETWEEN 33 & 32 IS CORRODED BEYOND LIMITS. FABRICATED REPAIR FLANGE.SDR AALA20101022TUL01Frame · crackedSTATION 1497 CANT FRAME CRACKED BELOW RIGHT LOUVER BOX. REPAIRED CANT FRAME 1497 PER EA MD80-53-011694.SDR FDEA201010214141Frame · dentedMAIN DECK CARGO, RT INTERIOR FUSELAGE FRAME STA 1661 L-11R FOUND DENTED. REPAIR CARRIED OUT AS PER SRM 53-00-07, FIGURE 201, REPAIR 2, REVISION 44. REPAIR CLASSIFIED AS MAJOR PER GMM 6-2-100, REVISION 111.SDR FDEA201010214142Frame · damagedMISDRILLED HOLES COMMON TO 143N1002-18 FRAME WEB, 143N1002-9 FRAME DOUBLER AND 143N1114-3 INBD CHORD AT STA 460, BETWEEN S-13L AND S-14L. A REPAIR WAS ACCOMPLISHED ON STAM EA 757-5332-16-F2898 FOR MISDRILLED HOLES COMMON TO THE 143N1002-18 FRAME WEB, 143N1SDR SWAA106511Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME PER EA.SDR DALA1098742840Frame · crackedDURING M-CHECK FOUND CRACK IN FUSELAGE EXTERIOR CANTED FRAME AT BS 1303 BETWEEN L14L & L15L. REPAIRED PER SRM 53-01 FIGURE 9 SHEET 4.SDR AALA20101021TUL01Frame · corrodedFRAME CORRODED AT STATION 1117. REPLACED FRAME PER SRM 51-30-05 AND EA MD-80-51-013637.SDR FDEA201010214132Frame · misrepairedFWD CARGO COMPARTEMENT - PREVIOUS REPAIR FOUND AT FR20A NOT IAW FAA APPROVED DATA. NEW REPAIR TO THE FR20A PERFORMED IAW EA 6-5310-144063.SDR QXEA2010102100660Frame · corrodedC4 CHECK - DURING INSP FOUND CORROSION AT FRAME FS 265 ON THE FRAME STIFFENING ANGLE ATTACH FLANGE BETWEEN STR 26L AND 26R AT THE MIDDLE OF THE STIFFENER. BLENDED CORROSION 4"L X 1.6"W X .001"D IAW SRM 51-21-06-001-001-A01, ORIGINAL THICKNESS .050", REMOVED .SDR SIMA201029501Frame · corrodedDURING MAINTENANCE BASE VISIT FRAME 22 FOUND CORROSION APPROXIMATELY 4 INCHES ABOVE THE DOOR CENTER SILL. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED FRAME 22 AFT LOWER THRESHOLD NUT PLATE HOLE YAW EON EM-53MR-1677. THE AIRCRAFT WAS RETURNED TO SERVICESDR FDEA201010194113Frame · crackedFWD CARGO AFT FRAME WEB AT NO.6 DOOR STOP FITTING FASTENER HOLE (QTY 1), SEAL RETAINER FASTENER HOLES (QTY 1) AT STA 620 FOUND WITH CRACKS. CRACKS AT FRAME WEB IN FWD CARGO AFT FRAME AT RH STA 620 REPAIRED IAW SRM 53-00- 07 FIG. 201 REPAIR 2 REV. 100. REPAISDR SWAA106509Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER SRM.SDR SWAA106460Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 19L TO STR 22L. REPAIRED FRAME PER SRM.SDR DALA1027669865Attach Fitting · crackedDURING M-CHECK FOUND CRACK IN MAIN CABIN FORMER ATTACH CLIP AT BS 1167 L16L-L17L. REPAIRED PER SRM 51-30-5 & SRM 53-10-25 PAGE 205.SDR DALA1027659865Attach Fitting · crackedDURING M-CHECK FOUND CRACK IN MAIN CABIN FORMER ATTACH CLIP AT BS 1167 L15L APB NR 3. REPAIRED PER SRM 51-30-5, SRM 53-10-25 PAGE 205.SDR DALA1027649865Former · crackedDURING M-CHECK FOUND CRACK IN MAIN CABIN FORMER AT BS 1167 L15- L16L APB NR 3. REPAIRED PER SRM 53-10-25 PAGE 205.SDR DALA1027639865Former · crackedDURING M-CHECK FOUND CRACK IN MAIN CABIN FORMER AT BS 1167 L16L-L17L AT AFT PRESSURE BULKHEAD. REPAIRED PER SRM 53-10-25.SDR DALA1027629865Former · crackedDURING M-CHECK FOUND CRACK IN MAIN CABIN FORMER AT BS 1167 LONGERON 15L APB NR 3. REPAIRED PER SRM 53-10-25.SDR DALA1027619865Former · crackedDURING M-CHECK FOUND CRACK IN MAIN CABIN FORMER AT BS 1167 L15 TO L16. REPAIRED PER SRM 51-10-25.SDR DALA1027609865Frame · damagedDURING M-CHECK FOUND MAIN CABIN RIGHT FRAME AT BS 237 STRINGER 10 HAS 6 EA HOLES. REPAIRED PER SRM 53-03 FIGURE 4 PAGE 5.SDR SWAA106555Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND SHEAR TIE CORRODED AT BS 767, STR 26R. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA106554Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR GLBA20101018FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, MX FOUND A 1.7" CRACK IN THE RT HEAVY ANGLE FROM FS 288 GOING AFT 1.7" IN BEND RADIUS. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. EO 10-1900-53-058. MATERIALS UTILISDR SWAA106449Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 259.5, BETWEEN STR 11L TO STR 12L. REPAIRED FRAME PER SRM.
Back to JASC 5311