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 061067Frame · crackedFOUND FUSELAGE FRAME IS CRACKED AT STA 1335, STR 9L.SDR 061066Frame · crackedFOUND FUSELAGE FRAME IS CRACKED AT STA 1320, STR 9L.SDR UPS06846691Frame · corrodedFOUND HEAVY CORROSION ON STA 1700 FRAME L36-L35L FWD SIDE. CUT OUT SECTION OF CORRODED FRAME FROM STA 1700 BETWEEN L36 AND L35R IAW SRM 53-2-0. FABRICATED AND INSTALLED 4 REPAIR SPLICES, -7 SPLICE AND FRAME SECTION REPAIR IAW DWG 5612142, AND SRM'S 53-02-00 SDR DL73S060240Frame · crackedTHE STA 787 FRAME WEB AT S-13L IS CRACKED. INSTALLED REPAIRS PER SRM 53-10-4, FIG 1.SDR 2006UALA00612Frame · crackedFOUND FUSELAGE FRAME AT STA 440 CRACKED BETWEEN STR 8L AND 9L PSU RAIL ATTACH BRACKET. REMOVED DAMAGE & CHECK FOR CRACK CONTAINMENT USING NDT. FABRICATED & INSTALLED NESTED ANGLE DOUBLER REPAIR REF MM53-10-84 RPR NR 3.SDR 2006UALA00611Frame · crackedFRAME STA 927 IS CRACKED BETWEEN STR 8L AND 9L AT THE INBD RIVET OF THE PSU RAIL SUPPORT BRACKET. REMOVED DAMAGE & CHECK FOR CRACK CONTAINMENT USING NDT. FABRICATED & INSTALLED NESTED ANGLE DOUBLER REPAIRS REF SRM 53-00-07-201.SDR 2006UALA00610Frame · crackedBS 727 BULKHEAD FRAME WAS FOUND CRACKED AT THE STR 15L CUT-OUT EMANATING UPWARD FROM THE STRINGER CUT-OUT. REMOVED DAMAGE & VERIFIED CRACK CONTAINMENT WITH NDT. FABRICATED & INSTALLED NESTED ANGLE REPAIR & STRUCTURAL FILLERS REF. AAR ENGINEERING AUTHORIZATIONSDR ASAA0640311Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED. REMOVED DAMAGED PORTION OF FRAME FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0640307Frame · corrodedFOUND CORROSION ON FRAME. REMOVED CORRDED AREA OF FRAME SHEARTIE FABRICATED REPAIR PARTS AND INSTALLED PER SRM 53 00 07.SDR ASAA0610294Frame · corrodedFRAME CORRODED. REPAIRED FRAME PER SRM 53-10-4 FIG 6.SDR ASAA0610293Frame · corrodedAFT CARGO PIT FRAME SPLICE CORRODED. REPLACED FRAME SPLICE PER SRM 53-10-1 FIG 1.SDR C2XA06TY017Frame · crackedPAX DOOR FRAME CUTOUT AFT LOWER STOP STRUCTURE LOWER OUTBOARD HOLE HAS A CRACK. REAMED HOLE AND INSTALLED BUSHING AND BRACKET. ALL WORK PERFORMED IAW EC 5310-01377, EA 5310- 01054 AND SRM 57-21-03. AC PRESSURE CHECKED GOODSDR 061050Frame · corrodedFORWARD PIT FUSELAGE FRAME UPPER FLANGE CORRODED AT BS 900, LBL 58.SDR KCSA061044Frame · corrodedCORROSION ON FUSELAGE FRAME LOWER CHORD AT BS 2200 ABOVE STR 42R. REPAIRED CHORD IAW B747 SRM 51-40-04.SDR 06FDEA1253Frame · corrodedBULK CARGO FLOOR LEVEL RIGHT SIDE AT FRAME 67 ANGLE HAS 1 EACH AREA OF CORROSION. REMOVED AND REPLACED IAW A310-200 SRM 51-72-10.SDR GAIA06019Frame · crackedDURING INSPECTION A FRAME WAS FOUND BENT AND CRACKED AT STA 580 BY STR 11R. ACCOMPLISHED FUSELAGE FRAME REPAIR TO STA 580 IAW SRM. AIRCRAFT RETURNED TO SERVICE. (K)SDR GAIA06018Frame · crackedDURING INSPECTION A FRAME WAS FOUND BENT AND CRACKED AT STA 560 BY STR 11R. ACCOMPLISHED FUSELAGE FRAME REPAIR TO STA 560 IAW SRM. AIRCRAFT RETURNED TO SERVICE. (K)SDR GAIA06013Frame · crackedDURING INSPECTION, A FRAME WAS FOUND BENT AND CRACKED AT STA 600 BY STR 11R. ACCOMPLISHED FUSELAGE FRAME REPAIR TO STA 600 IAW SRM. AIRCRAFT RETURNED TO SERVICE. (K)SDR MWEA060036Frame · lightning strikeFOUND LIGHTNING STRIKE AT FRAME STATION 242, LONGERON 9 LEFT. FABRICATED AND INSTALLED DOUBLER.SDR MWEA060031Frame · damagedLIGHTNING STRIKE AT FRAME STATION 898, LONGERON 5 LEFT. FABRICATED AND INSTALLED DOUBLER AND FILLER.SDR UIEA200600059Frame · crackedFUSELAGE FRAME BS 480 RT FOUND WITH 1 CRACKS AT STRINGER 11 CUT OUT. CRACKED FRAME REPAIRED IAW BOEING MSG NR 1-166738303-4, DATED 03 MARCH 06. FABRICATED 2 OFF DOUBLERS MATERIAL 2024-T3 0.063" & 0.063". FABRICATED 1 OFF CUP MATERIAL 2024-T42 0.050".SDR UIEA200600058Frame · crackedFUSELAGE FRAME BS 480 LT FOUND WITH 1 CRACKS AT STRINGER 12 CUT OUT. CRACKED FRAME REPAIRED IAW BOEING MSG NR 1-166738303-4 DATED 03 MARCH 06. FABRICATED 2 OFF DOUBLERS MATERIAL 2024-T3 0.063" & 0.032" RESPECTIVELY. FABRICATED 1 OFF CUP MATERIAL 2024-T42 0.SDR UIEA200600057Frame · crackedFUSELAGE FRAME BS 500 RT FOUND WITH 2 CRACKS AT STINGER 11 CUT OUT AND 1 CRACK AT STRINGER 10A. CRACKED FRAME REPAIRED IAW BOEING MSG NR 1-1667383034 DATE 06 MARCH 06. FABRICATED 3 OFF DOUBLERS MATERIAL 2024-T3, 0.063", 0.032", 0.063" RESPECTIVELY. FABRICATSDR UIEA200600056Frame · crackedFUSELAGE FRAME BS 500 LT FOUND WITH 1 CRACKS AT STRINGER 11 CUT OUT. CRACKED FRAME REPAIRED IAW BOEING MSG NR 1-166738303-4, DATED 06 MARCH 06. FABRICATED 2 OFF DOUBLERS MATERIAL 2024-T3 0.63" & 0.032" RESPECTIVELY. FABRICATED 1 OFF CUP MATERIAL 2024-T42 0.SDR UIEA200600055Frame · crackedFUSELAGE FRAME BS 520 RT FOUND WITH 2 CRACKS AT STRINGER 11 CUT OUT. CRACKED FRAME REPAIRED IAW BOEING MSG NR 1-166738303-4. DATE 06 MARCH 2006. FABRICATED 03 OFF DOUBLERS MATERIAL 2024-T3.(0.063",0.032",0.063" RESPECTIVELY). FAB 1 OFF CUP MATERIAL 2024-T3 SDR SWAA061056Frame · crackedDURING SCHEDULED SPECIAL VISIT, FOUND FUSELAGE FRAME CRACKED AT FWD CARGO DOOR CUTOUT, BS 492, STR 24R. REPAIRED FRAME PER SWA EA.SDR EIA2006073Frame · crackedDURING C CHECK, A 3.0 IN CRACK WAS FOUND ON INNER CHORD ANGLE AT STA 1265 AND WL170 INNER CHORD ANGLE SECTION REPAIRED PER SRM 51-40-04, SRM 51-10-07. ALSO, CONFORM TO DWG 65B10365 AND RESTORED FINISH PER AMM 51-21 HFEC INSPECTION C/W ON TRIM LINE TO ENSURE DSDR QXEA200600826Frame · chafedPDX - C4 CARGO COMPARTMENT FRAME 636 CHAFED RIGHT SIDE FLOOR LEVEL. REPAIRED IAW DHC-8-200 SRM 51-40-11.SDR QXEA200600825Frame · chafedPDX - C4 CARGO COMPARTMENT FRAME 653 CHAFED RIGHT SIDE AT FLOOR LEVEL. REPAIRED IAW DHC-8-200 SRM 51-20-16, 51-20-36 AND 51-20-26.SDR CALA0600112Frame · crackedINSPECTION FOUND A 1.5 INCH CRACK IN ABB DOOR CUTOUT FORWARD FRAME AT STA 794.3 ALONG UPPER THREE STOP PAD MOUNTS. THE FRAME WAS REPLACED IAW SRM 51-41-02.SDR KCSA061030Frame · corrodedFORWARD BILGE FUSELAGE FRAME UPPER FLANGE CORRODED AT BS 860, LBL 32. FRAME REPAIRED IAW B747 SRM 51-40-04 FIG 1.SDR DLM88070363Frame · crackedFOUND 2 CRACKS .8 IN FS 1446 OUTER CAP AT S5R. REPAIRED ON EA 09-062073-12 OPN 0103 SRM 53-03 FIG 30 SHEET 8.SDR DLM88070361Frame · crackedFOUND .8 IN CRACK FS 1446 FRAME OUTER CAP AT S3L. REPAIRED ON EA 09-062073-12 OPN 0103 SRM 53-03 FIG 30 SHEET 8.SDR MALA060200Frame · chafedDURING 2 YEAR CHECK IN BNA, FOUND INNER FLANGE OF FRAME AT FS 686.888 HAS BEEN CHAFED OUT OF LIMITS FROM CONTACT WITH THE INTERIOR CARGO PANEL. THE DAMAGE HAS BEEN REPAIRED IAW MESABA EO#S53356. REF: EAMS WORK ORDER 213664 TASK 2502.SDR ASAA0640278Frame · crackedFRAME IS CRACKED BETWEEN STRINGERS. REMOVED AND REPLACED FRAME SECTION IAW SRM 51-10-02.SDR SWAA061042Frame · corrodedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CORRODED AT BS 792, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME PER SRM.SDR SWAA061041Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, RBL 60, WL 204. REPAIRED FRAME PER BFG ER.SDR USAA060515Frame · crackedBS 400 BETWEEN S8R AND 9R CRACK. FABRICATED AND INSTALLED REPAIR ANGLES IAW TR 53-10-20D, DEFECT SIZE: .5 INCH.SDR USAA060516Frame · crackedBS 440 BETWEEN STRINGERS 8R AND 9R CRACK. FABRICATED AND INSTALLED REPAIR ANGLES IAW TR 53-10-20D, DEFECT SIZE: .5 INCH.SDR ASOA06340Frame · crackedDURING C-CHECK, THE LT SIDE 718 FRAME, BETWEEN STR 10 AND 11, WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE LT SIDE 716 FRAME, BETWEEN STR 10 AND 11, IAW EO. (K)SDR 06FDEA1203Frame · dentedMAIN DECK COMPARTMENT RIGHT FUSELAGE FRAME FOUND WITH DENT AT STA 1681 LONGERON 12R. DENT MARK ON MAIN DECK COMPARTMENT RIGHT FUSELAGE FRAME AT STA 1681 LONGERON 12R EXISTING REPAIR DOUBLER REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. ACCOMPLISH AN INITIASDR 06FDEA1202Frame · dentedMAIN DECK COMPARTMENT RIGHT FUSELAGE FRAME FOUND WITH DENT AT STA 1701 LONGERON 12R. DENT ON MAIN DECK COMPARTMENT RIGHT FUSELAGE FRAME AT STA 1701 LONGERON 12R REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. ACCOMPLISH AN INITIAL INSPECTION AT OR BEFORE REASDR SWAA061021Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 616, LBL 60, WL 200. REPAIRED FRAME PER SRM.SDR A6WA200640113Doubler · crackedRT SIDE FS 640 FRAME DOUBLER IS CRACKED AT STRINGER 10R APPROX 1.0 INCH LONG. CORRECTIVE ACTION IN PROGRESS. (K)SDR 06FDEA1201Frame · dentedMAIN DECK COMPARTMENT LEFT FUSELAGE FRAME FOUND WITH DENT AT STA 1681 LONGERON 12L. DENTED FRAME ON MAIN DECK COMPARTMENT LEFT FUSELAGE AT STA 1681 LONGERON 12L REPAIRED AS PER SRM 53-30-00 FIGURE 1 VOLUME I. ACCOMPLISH AN INITIAL INSPECTION AT OR BEFORE REASDR 06FDEA1199Frame · dentedFOUND MAIN DECK COMPARTMENT LT FUSELAGE FRAME FOUND WITH DENT AT STA 535 BETWEEN STRINGER 20-21L. MAIN DECK COMPARTMENT LT FUSELAGE DENTED FRAME AT STA 535 BETWEEN STRINGER 20-21L, REPAIR CARRIED OUT AS PER DWG SRZ-53-503. REPAIR CLASSIFIED AS MAJOR AS PESDR 06FDEA1200Frame · dentedFOUND MAIN DECK COMPARTMENT LT FUSELAGE FRAME FOUND WITH DENT AT STA 535 BETWEEN STRINGER 23-24L. MAIN DECK COMPARTMENT LT FUSELAGE DENTED FRAME AT STA 535 BETWEEN STRINGER 23-24L, REPAIR CARRIED OUT AS PER DWG SRZ-53-503. REPAIR CLASSIFIED AS MAJOR AS PERSDR 2006UALA00558Frame · crackedCABIN BODY FRAME WEB IS CRACKED AT 1 EACH STRINGER CUTOUTS BS 663 STR 3L. REMOVED DAMAGE, MANUFACTURED REPAIR ANGLE FILLERS AND STRINGER SPLICE AND INSTALLED REF SRM 53-00-07.SDR 2006UALA00549Frame · crackedCABIN UPPER LOBE FRAME STA 927 IS CRACKED BETWEEN STRINGERS 8L & 9L. *S/D* REMOVED DAMAGE & ACP NDT FOR CRACKS. FABRICATED & INSTALLED NESTED ANGLE REPAIR REF SRM 53-00-07 & AMM 53-11-99 REPAIR IX.SDR SWAA061001Frame · crackedDURING SCHEDULED D-CHECK, FOUND FUSELAGE STUB FRAME CRACKED AT BS 188, RT SIDE, WL 207. REPAIRED STUB FRAME PER SRM.
Back to JASC 5311