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 QXEA200601308Frame · corrodedYYC - C4 FUSELAGE INTERIOR UNDERFLOOR FRAME FLANGES BETWEEN STRINGERS 32P - 32S HAVE CORROSION AROUND RIVETS AT STATION X 405. REPAIRED IAW SRM 51-40-1.SDR 2006UALA00818Frame · crackedFOUND CABIN BS 400 BETWEEN STRINGERS 8R-9R FRAME CRACKED AT PSU SUPPORT RAIL.SDR 2006UALA00817Frame · crackedFOUND AFT PIT FRAME CRACKED AND DENTED STA 907 BTWN STRINGER 20-22R.SDR 2006UALA00816Frame · crackedFOUND CABIN FRAME CRACK AT STATION 400 BTWN 7-8L AT PSU ATTACH BRACKET.SDR 2006UALA00815Frame · crackedFOUND CABIN FRAME CRACKED STA 927 BETWEEN STRINGERS 8-9 AT PSU BRACKET.SDR ASAA0640504Failsafe · corrodedFOUND CORROSION ON FAILSAFE. REMOVED AND REPLACED FAILSAFE PER SRM 51-40-02.SDR ASAA0640502Frame · corrodedFOUND CORROSION ON FRAME. REPAIRED DAMAGED PER SRM 51 70 11.SDR ABXA060179Frame · crackedLEFT FORWARD MAIN FRAME FS 699 AFT FLANGE CRACKED AT POINTS F - E AND POINTS H - I. REQUIRED 5935650 REPAIR INSTALLED. REPLACED LEFT FORWARD MAIN FRAME FS 699 IAW DC9 JOB CARD EA53400321-001-2.SDR DU4R2006402Frame · corrodedFOUND CORROSION ON FRAME ANGLE BS 1360 BETWEEN S-27L AND S-25L (AFT PIT). FABRICATED AND INSTALLED CHANNEL REPAIR 31" BY 3" FROM 2024-T3 .050" IAW B757 SRM 51-20-01, 51-40-02 AND BOEING DRAWING 453N1801.SDR USAA060622Frame · crackedFOUND BS 616 LT FRAME LOWER END UNDER CABIN FLOOR CRACKED. CUT OUT CRACKED END OF CHORD IAW TR 53-62-01, DEFECT SIZE: 1".SDR UIEA200600085Frame · crackedRT STA 360 FRAME WEB AT STR 14E CUT OUT FOUND CRACKED 7.5". CRACKS WERE FOUND ON FRAME WEB. REPAIR DOUBLERS WERE INSTALLED IAW BOEING MESSAGE NR 1-175762603, AND FAA FORM 8100-9.SDR UIEA200600086Frame · crackedRT STA 300 FRAME WEB AT STA 14D CUT OUT FOUND CRACKED 7.1". CRACKS WERE FOUND ON FRAME WEB. REPAIR DOUBLER AND WAS INSTALLED IAW BOEING MESSAGE 1-175762603.SDR ASAA0680480Frame · corrodedFOUND FRAME CORRODED. REPLACED DAMAGED SECTION OF FRAME BY INSTALLING FOUR REPAIR ANGLES AND FOUR SPLICE PLATES PER SRM 53 03 FIG 2A.SDR USAA060614Frame · crackedFOUND CRACK AFT CARGO FS 727F JUST BELOW S-22L. REMOVE DAMAGED AREA AND INSTALLED FABRICATED DOUBLER IAW SRM 53-00-01, DEFECT SIZE: 2".SDR USAA060613Frame · crackedFOUND CARGO FRAME CRACKED FUSELAGE, 727E AND 3" BELOW S-22L. CUTOUT DAMAGE AND INSTALLED FABRICATED FRAME IAW SRM 53-00-01, DEFECT SIZE: 3".SDR ASAA0640492Frame · corrodedFOUND FRAME SHEAR TIE CORRODED. REPAIRED PER SRM 53 00 07.SDR SWAA061390Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061389Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FRAME CRACKED BS 867, STR 8R AND STR 8L. REMOVED AND REPLACED FRAME SECTIONS PER SRM.SDR SWAA061388Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA061387Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FRAME CRACKED AT BS 787, STR 8R AND STR 8L. REPAIRED FRAME SECTIONS PER SRM.SDR SWAA061386Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061383Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND FRAME CORRODED AT BS 986.5, WL 208. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA061382Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8R. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR ZZDA060423001Frame · crackedAFT FUSELAGE COMPARTMENT CANTED FRAME 1178 AND LEFT HAND LONGERON 17, AREA HAS CRACK. CUT OUT DAMAGE ON CANTED FRAME STA 1178 LEFT SIDE L-17L TO 18L (2.5 X 1.375 INCHES) IAW B717 SRM 51-70-11 FIG 201. FABRICATED REPAIR ANGLE AND FILLER MATERIAL USED 7075. T6SDR DU4R2006391Frame · crackedFOUND CANTED FRAME HAD APPROX 2 INCH LONG CRACK AT FS 1508 LT SIDE AT 8 O'CLOCK POSITION. STOP DRILLED CRACK HFEC CRACK CONTAINED IAW MD-80 SPM 06-10-01-.001. FABRICATED AND INSTALLED REPAIR DOUBLERS 5.0" AND 6.7" X 5.7" FROM 7075-T6 .025 AND IAW MD-80 SRM 5SDR 2006UALA00761Frame · crackedFOUND FRAME BS 727 HAS A CRACK LOCATED JUST BELOW STRINGER 14L. REMOVED DAMAGE, FABRICATED FILLER AND SPLICE ANGLE AND INSTALLED PER AAR EA I060181 AND UAL EVA UA-EVA-60252.SDR DU4R2006425Frame · corrodedFOUND CORROSION, AFT PIT, ON ATTACH ANGLE FOR FLOOR AND SIDEWALL PANELS (ALSO MISDRILLED HOLES, LOOSE FASTENERS) BS 1640 S-22R TO S-22L. FABRICATED AND INSTALLED REPAIR ATTACH ANGLE 3.5 X 1.5 INCH AND 2 EA ATTACH ANGLES 1.5 X 2.5 INCH FROM 2024-T3 .050 IAW B7SDR 2006UALA00763Frame · damagedFOUND STA 298.5 LT FRAME OUTER CHORD AT STR 28-30 IS DAMAGED. TEMPORARY REPAIR AND REPETITIVE INSPECTION WAS PERFORMED PER EVA G95-7785A. PERMANENT REPAIR OF THE DAMAGE WAS ACCOMPLISHED PER EVA G95-7785B .SDR 06FDEA1566Frame · corrodedSTA 970 BETWEEN STR 29L AND STR 30, CORROSION ON FRAME OUTBOARD FLANGE. *S/D* REPAIRED PER SRM 53-10-4.SDR DL76L060296Frame · crackedTHE LT FRAME IS CRACKED AT BS 903.5. A REPAIR ANGLE WAS INSTALLED.SDR CALA0600134Frame · corrodedLOWER FORWARD BULKHEAD CORROSION AT STA 227.SDR 2006UALA00740Frame · crackedFUSELAGE FRAME CRACKED AT BS 294 & STR 2R. CUT OUT DAMAGE, FABRICATED & INSTALLED ANGLE REPAIR DOUBLER REF SRM 53-00-07 REPAIR 2.SDR DU4R2006395Frame · crackedCANTED FRAME AT FS 1485 ON LT SIDE HAS A CRACKED WEB. CUT OUT CRACKED WEB ON FRAME 1485 ON LT SIDE. FABRICATED AND INSTALLED DOUBLERS 9.5 X 2.2 X 9.25 INCHES, 5.4 X 7.25 X 6 X 4.5 INCHES AND 1.1 X 2.7 INCHES FROM 7075-T6 .032 AND FILLER FROM 7075-T6 .025 IASDR SWAA061345Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT UPPER INBOARD FASTENER. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA061342Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 787, S8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061341Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME SECTION PER SRM.SDR SWAA061340Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 907, STR 8L. REPAIRED FRAME SECTION PER SRM.SDR SWAA061336Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 64, WL 201. REPAIRED FRAME SECTION PER ER.SDR KCSA061149Frame · crackedBULK PIT FUSELAGE FRAME WEB CRACKED AT BS 2080, LBL 18.SDR KCSA061148Frame · crackedBULK PIT FUSELAGE FRAME WEB CRACKED AT BS 2080, RBL 18.SDR 06FDEA1539Frame · wornAIR COND COMPT LT SIDE DEEP WEAR ON FRAME AT STA 590 X 63. TRIMMED OUT WORN SECTION OF FRAME, INSTALLED REPAIR DOUBLER IAW SRM 53-30-00 FIG 4 VOL 1. FABRICATED PART IAW DETAIL PART TRAVELER F176660-3 REPAIR DOUBLER IAW SRM 53-30-00 FIG 4 AND 4A VOL 1.SDR QXEA200601508Frame · corrodedYYC C3 AFT BAGGAGE COMPARTMENT, TOWER SKIN ATTACH FLANGE FOR FRAME STATION X783.102 AT LEFT HAND STRINGER 31 AND 33, IS CORRODED. REPAIRED IAW Q400 SRM 51-42-05-330-801, 51-21-00-800-801, 51-21-10-380-001 AND 51-25-10-370-001SDR 2006UALA00742Frame · crackedCABIN FRAME STA 663.75 IS CRACKED AT STR 1 CUTOUT. REMOVED DAMAGE, FABRICATED AND INSTALLED ANGLE DOUBLER AND NEW STRINGER SPLICE PER SRM 53-00-07.SDR QXEA200601563Frame · corrodedYYC - C3 CENTER FUSELAGE UNDER FLOOR PANEL 143BZ, FRAME X489 AND RIGHT HAND STRINGER 31, FRAME FLANGE ATTACHED TO SKIN IS CORRODED. REPAIRED IAW DHC-8-400 SRM 51-21-00-350-801, 51-42-05-330-001, 51-25-10-370-801 AND SRM 51-25-15-370-301.SDR QXEA200601562Frame · corrodedYYC - C3 CENTER FUSELAGE UNDER FLOOR PANEL 132GZ, FRAME X301 AND RIGHT HAND STRINGER 30, FRAME FLANGE ATTACHING TO SKIN IS CORRODED. REPAIRED IAW DHC-8-400 SRM 51-21-00-350-801, 51-42-05-330-001, 51-25-10-370-801 AND SRM 51-25-15-370-801.SDR QXEA200601561Frame · corrodedYYC - C3 FORWARD FUSELAGE UNDER FLOOR PANEL 133FZ FRAME 216.0 AND RIGHT HAND STRINGERS 31 AND 32, FRAME FLANGE ATTACHING TO SKIN IS CORRODED. REPAIRED IAW DHC-8-400 SRM 51-21-00-350-801, 51-42-05-330-001, 51-25-10-370-801 AND SRM 51-25-15-370-801.SDR QXEA200601545Frame · corrodedYYC C3 FORWARD FUSELAGE, UNDER FLOOR PANEL 133BZ, FRAME X19.4 AND RIGHT HAND STRINGER 31, FRAME FLANGE ATTACHING TO SKIN IS CORRODED. REPAIRED IAW DHC-8 Q400 SRM 51-42-05-330-801, 51-21-00-350-801, 51-25-10-370-001, 51-42-05-330-801 AND SRM TASK 51-25-15-370-0SDR QXEA200601541Frame · corrodedYYC C3 FUSELAGE INTERIOR - AFT BAGGAGE PIT UNDERFLOOR, FRAME WEB AT STATION X836 HAS CORROSION ON FORWARD SIDE AT RBL24, AND ON AFT SIDE AT RBL 10. REPAIRED IAW DHC-8 Q400 SRM 51-21-00-350-801, 51-42-05-330-801 AND 51-21-41-340-801.SDR 2006UALA00730Frame · crackedOVERWING BODY FRAME TO STUB BEAM JOINT HAS CRACK FRAME INNER CHORD WEB STA 616 TH SIDE. INSTALLED FRAME REPAIR ANGLE DOUBLER PER MM 53-11-89.SDR 2006UALA00727Frame · crackedCABIN FRAME CRACKED AT STA 663, AFT SIDE OF FRAME, JUST I/B OF STR 2R. INSTALLED NESTED ANGLE FRAME REPAIR AND NEW STR SPLICE SECTIONS AT STR'S 2R & 3R PER SRM 53-00-07 REPAIR 9.
Back to JASC 5311