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 QXEA2013051201001Frame · corrodedFRAME BS 258.5 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 29S AND 32S. REMOVED CORROSION ON LOWER FLANGES IAW SRM 51-21-00-00-02, REV 12. VERIFIED AFFECTED AREAS TO BE CRACK FREE, REF NDTM PART 1, TASK 51-00-06-910-801, REV 9. BLENDS BETWEEN STR 32-SDR CALA2013051500305Frame · puncturedCARGO BAY FRAME AT BS 947.5 PUNCTURED. INSTALLED PERMANENT REPAIR IAW ECRA 5311-01598.SDR AALA20130511002Frame · crackedFRAME AFT SIDE OF STATION 1418 AT LONGERON 2 RIGHT CRACKED. INSTALLED DOUBLER AND FILLER PER SRM 53-03-00.SDR DALA1313040623Frame · crackedAT PSV, CRACKED FRAME BS 1681.8. REPAIRED IAW ERA 514541-14, REV ORIGINAL.SDR DALA1312793750Frame · dentedAFT CARGO COMPARTMENT BS 727E BETWEEN STR 24R AND 25R FRAME DENTED. REPAIRED IAW ERA 513586-14, REV ORIG.SDR ASOA20130423153Frame · crackedDURING C-CHECK THE LT FRAME 10 WAS FOUND TO BE CRACKED DIRECTLY BELOW THE PILOTS DV WINDOW AT STRINGER 9L. MX R & R THE CRACKED FRAME SECTION IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWAA2013061217112Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 25R TO STR 24R. R & R FRAME IAW SRM AND DWG.SDR SWAA2013061217080Frame · crackedSTUB FRAME CRACKED AT BS 616, LBL 59. REPAIRED FRAME IAW EA.SDR SWAA2013061217079Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT BS 947.5, BETWEEN STR 27L TO STR 27R. R & R FRAME IAW SRM AND DWG.SDR SWAA2013061217073Frame · corrodedFWD CARGO COMPARTMENT FRAME LOWER FLANGE CORRODED AT BS 500B, BETWEEN STR 28L TO STR 28R. REPAIRED FRAME IAW SRM.SDR SWAA2013052916601Frame · crackedFRAME CRACKED AT BS 616, BETWEEN STR 7R TO STR 8R. REPAIRED FRAME IAW SRM.SDR SWAA2013052016209Frame · crackedFRAME WEB CRACKED AT STA 328, BETWEEN S20-21R. R & R WEB IAW EA.SDR QXEA2013051000979Frame · damagedFRAME BS 116 LOWER FLANGES HAVE CORROSION BETWEEN STRINGERS 29P AND 31P. REMOVED CORROSION IAW SRM (REV12) 53-00-00-02-09. VERIFIED AFFECTED AREAS TO BE CRACK FREE, REF NDTM PART 1, TASK 51-00-06-910-801, REV 9. REPAIR IS IN LIMITS IAW SRM 53-00-00-02-09, SDR QXEA2013051000978Frame · corrodedFRAME X19.400, UPPER FLANGE ABOVE STRINGER 30S HAS CORROSION. CLEANED AND SANDED UPPER FLANGE IAW SRM 51-26-00-02-03. MIN THICKNESS NOTED .035" REF NTM 51-00-04-910-801, PT 1 REV 9. VERIFIED AFFECTED AREAS TO BE CRACK FREE, REF NDTM PART 1, TASK 51-00-06-91SDR CALA2013051500302Frame · crackedFRAME CRACKED BS 907 BETWEEN S8 AND 9R. INSTALLED INTERIM DOUBLE REPAIR STEP 1 TO 17 OF ECRA 5311-01597.SDR AALA20130510003Frame · damagedDAMAGED HOLE AT FRAME SPLICE FUSELAGE STATION 200 AT LONGERON 24 LEFT. INSTALLED FREEZE PLUG AND REINFORCING STRAP AT FRAME SPLICE FUSELAGE STATION 200 AND LONGERON 24 LEFT PER EA MD80-53-029731.SDR WVER20130510004Frame · chafedFUSELAGE STATION 1162 FRAME CHAFED AT SPLICE FITTING BETWEEN STRINGERS 7L AND 8L MEASURING 0.6" LONG X 0.25" WIDE X 0.100" DEEP.SDR SWAA2013061817330Frame · crackedSTUB FRAME CRACKED AT BS 294.5, STR 7R. REPAIRED STUB FRAME IAW EO AND EA.SDR DALA1315260682Frame · dentedFWD CARGO FRAME BS 580, S23-25L DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5, DETAIL III.SDR SWAA2013061016976Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 727E, BETWEEN STR 26L TO STR 27L AFT CARGO COMPARTMENT. REPAIRED FLANGE IAW SRM.SDR UALA2013051003279Frame · damagedBS 1380 FRAME ANGLE DAMAGED. REPAIRED FRAME.SDR USAA2013051600017Support · corrodedQ4 CHECK - CRACK ON FRAME SUPPORT AT L1 DOORWAY AT BS 294, S16L. REPLACED FRAME SUPPORT AT L1 DOORWAY AT BS 294, S16L IAW B737 SRM 51-40-02.SDR QXEA2013050900959Frame · corrodedFRAME 32.4, FRAME FLANGE IS CORRODED BY STR 32P. REMOVED (2) EA RIVETS AND CORROSION IAW SRM 51-42-05-02-01 AND 53-00-00-02-09, REV 12. MIN THICKNESS NOTED .038" CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1, REV 9. MATERIAL LOSDR QXEA2013050900958Frame · corrodedFRAME X32.400 LOWER FLANGES AND VERTICAL WEB HAVE CORROSION BETWEEN STRINGERS 30P AND 32P. REMOVED RIVETS TO ACCESS CORROSION IAW SRM REV 12 53-00-00-02-09, REPAIR 09 STEP 6(A). REMOVED CORROSION FROM FRAME X32.400 LOWER FLANGES BETWEEN STRINGER 30P-32P IAW SDR QXEA2013050900957Frame · corrodedFRAME X1.00, LOWER FLANGE HAS CORROSION BETWEEN STRINGERS 29S AND 31S. REMOVED RIVETS FROM FLANGES BETWEEN 29S AND 31S TO FOM SRM 51-42-05-02-01, REV 12, REMOVED CORROSION FROM FLANGES BETWEEN STR 29S AND 31S IAW SRM 51-21-00-00-02, REV 12 MIN THICKNESS NOTEDSDR QXEA2013050900955Frame · corrodedNR 3 MOUNTING FRAME HAS CORRODED RIVETS. R & R CORRODED FASTENERS IAW SRM 51-42-45-02-01, REV 12. APPLIED SURFACE PROTECTION TO FASTENERS IAW SRM 51-25-10-02-01, REV 12.SDR CALA2013051000285Frame · crackedFRAME AT STA 440 BETWEEN STRINGER 8 AND 9R IS CRACKED AT INBD FASTENER OF AIR CONDITIONING OUTLET EXTRUSION BRACKET CRACKED. NOTED DURING VISUAL AND MFEC INSP REF EA 5310-04716, REV E AND NDT 6-53-30-00, PROCEDURE 7. REPAIRED IAW EA 5310-04716, REV E.SDR CALA2013051000284Frame · crackedFRAME AT BS 500C BETWEEN STRINGER 8 AND 9R IS CRACKED AT INBD FASTENER OF AIR CONDITIONING OUTLET EXTRUSION BRACKET. CRACK NOTED DURING VISUAL AND MFEC INSP REF EA 5310-04716, REV E AND NDT 6-53-30-00-PROCEDURE 7 REPAIRED IAW EA 5310-04716, REV E.SDR ASAA2013050994736Frame · crackedFRAME AT BS 500B, LT SIDE FRAME AT BS 500B, LT SIDE HAS A CRACK AT THE FASTENER DIRECTLY ABOVE AND INBD OF THE 1 DIA WIRE PENETRATION HOLE APPROX .1250" LONG EXTENDING INBD BELOW STRINGER 20L, REPAIRED FRAME AT STA 500B IAW ASA EA 400 53, EA 10317.SDR SWAA2013061917397Frame · crackedFRAME CRACKED AT BS 440, STR 24R. R & R FRAME IAW SRM AND DWG.SDR QXEA2013050800962Frame · corrodedFOUND FRAME 156, FLANGE CORRODED STR 32P-33. REMOVED CORRODED RIVET. REMOVED AND BLENDED CORROSION IAW SRM 51-42-05-02-01, REV 12 AND 51-21-00-00-02 MIN. THICKNESS NOTED .040", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801, PT1 & 51-00-06-910-801, PT1, REV 9SDR DALA13022390950Frame · crackedCRACKED FRAME ON STA Y=1174 BTW LONGERON 5LT AND 7LT AT PAX CABIN. CRACKED FRAME WAS REPAIR FABRICATED DOUBLER, TREATED AND PAINTED AND INSTALLED PARTS OF REPAIR IAW ER/A 495237-14MA, REV ORIG ASSOCIATED ER/A 49-523714 ADDED FOR AC 0950.SDR DALA13021556306Frame · crackedTHE RT HALF OF LOWER CHORD (PN 65B073033-33) WAS FOUND A 0.22" LONG CRACK AT STA 320, RBL 30, THE 4 TH FASTENER HOLE STA 320, RBL 30-CRACK AT 4TH FASTENER HOLE FROM THE RT SIDE MOST END OF RT HALF LOWER CHORD (PN 65B076303-33) WAS REPAIRED IAW ERA 512575-14AD,SDR FDEA201305080941Frame · dentedMAIN DECK BS 1701, LONGERON 12R, FRAME FOUND DENTED. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 52. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201305080940Frame · dentedMAIN DECK BS 1661, LONGERON 12R, FRAME FOUND DENTED. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 52. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201305080939Frame · dentedMAIN DECK BS 1741, LONGERON 12L, FRAME FOUND DENTED. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 52. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201305080938Frame · dentedMAIN DECK BS 1701, LONGERON 12L, FRAME FOUND DENTED. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2, REV 52. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201305080937Frame · dentedMAIN DECK BS 1661, LONGERON 12L, FRAME FOUND DENTED. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 2, REVISION 52. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 116.SDR FDEA201305080936Frame · crackedCERNTER FUSELAGE UPPER FRAME 43 BASES-TO-ARCHES JUNCTION ROTAING PROBE INSPECTION FOUND HOLE NR 2 WITH CRACK SIGNAL & THE HOLE DIMESION IS 0.313" (RT SIDE). COMPLIED WITH EA6-5310-168229.SDR ASOA20130508150Frame · crackedDURING C-CHECK, FRAME 10 CRACKED UNDER RT DV WINDOW. MX R & R FRAME 10 AT RT UNDER DV WINDOW IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR QXEA2013050700949Frame · corrodedFRAME X19.400, LOWER FLANGES BETWEEN STRINGERS 29P AND 31P HAVE CORROSION. REMOVED RIVETS AS NECESSARY, BLENDED OUT CORROSION IAW SRM 53-00-00-02-09, REV 12. MIN THICKNESS NOTED .037" REF NTM 51-00-04-910-801, PT 1, REV 9. VERIFIED AFFECTED AREAS TO BE CRACK SDR QXEA2013050700948Frame · corrodedFRAME X19.400, LOWER FLANGES BETWEEN STRINGERS 27S AND 32S HAVE CORROSION. REMOVED RIVETS AS NECESSARY, BLENDED OUT CORROSION IAW SRM 53-00-00-02-09, REV 12 MIN THICKNESS NOTED .036", REF NTM 51-00-04-910-801, PT 1, REV 9. VERIFIED AFFECTED AREAS TO BE CRACKSDR QXEA2013050700934Frame · corrodedFRAME X71.200, LOWER FLANGES HAVE POSSIBLE CORROSION BETWEEN STRINGERS 28S AND 30S. REMOVED RIVETS ON FRAME X71.200 BETWEEN STRINGERS 28S AND 30S TO CLEAN CORROSION IAW SRM 51-42-05-02-01, REV 12 AND SRM 51-21-00-00-02, REV 12. REMOVED CORROSION ON LOWER FLANSDR QXEA2013050700933Frame · corrodedFRAME X71.200, LOWER FLANGES AND VERTICAL WEB HAVE CORROSION BETWEEN STRINGERS 30S AND 31S. REMOVED 6 RIVETS IAW SRM 51-42-05-02-01, REV 12. REMOVED 1 RIVET FROM VERTICAL WEB AND REMOVED CORROSION FROM FRAME FLANGES IAW SRM 51-42-05-02-01, REV 12 AND SRM 53-0SDR QXEA2013050700923Frame · corrodedFRAME FLANGE AT FRAME 71.2 STR 32S HAS CORROSION. REMOVED 5 RIVETS FROM FRAME FLANGE AND 2 FROM VERTICAL WEB IAW SRM 51-42-05-02-01, REV 12. REMOVED CORROSION FROM FRAME FLANGE IAW SRM 53-00-00-02-09, REV 12. VERIFIED AFFECTED AREAS TO BE CRACK FREE REF NDTSDR SWAA2013062417498Frame · crackedLT FRAME CHORD CRACKED AT BS 727, BETWEEN STRINGER 27L TO STRINGER 18L. R&R CHORD IAW EA.SDR SWAA2013062417494Frame · crackedRT FRAME CHORD CRACKED AT BS 727, BETWEEN STRINGER 27R TO STRINGER 18R. R&R CHORD IAW EA.SDR SWAA2013062417493Frame · crackedLT CHORD CRACKED AT BS 727, BETWEEN STRINGER 27L TO STRINGER 18L. R&R CHORD IAW EA.SDR SWAA2013062417488Frame · crackedRT FRAME CHORD CRACKED AT BS 727, STRINGER 27R TO STRINGER 18R. R&R CHORD IAW EA.SDR USAA2013061300036Frame · crackedQ4 CHECK -CRACK ON FUSELAGE FRAME WEB AT BS303.9, S17L. REPAIRED FUSELAGE FRAME WEB AT BS303.9, S17L IAW JOB CARD M1L53001 & SRM 51-40-02.
Back to JASC 5311