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 FDEA201107122663Frame Splice · gougedAFT CARGO BAY FRAME, BS 1340 SPLICE. DEEP GOUGE BETWEEN STRINGERS 23L AND 24L. REMOVED GOUGE IAW SRM 51-10-02. FOUND OUT OF LIMITS IAW SRM 53-00-07, FIG 101. R & R SPLICE IAW SRM 51-40-02. MAJOR REPAIR.SDR FDEA201107122650Frame · crackedAVIONICS COMPARTMENT STA 447 FRAME FOUND WITH CRACK BETWEEN LONGERON 47 AND 48L. REPAIR CARRIED OUT IAW EA 1-5310-150781, REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 112.SDR SWAA114971Frame · corrodedDURING SCHEDULED 12Y CHECK, FOUND STUB FRAME CHORD CORRODED AT BS 320, STR 23L. REPAIRED CHORD PER SRM AND DWG.SDR CALA2011071200486Frame · crackedCABIN FRAME CRACKED.STA>1580 BETWEEN STR 8L AND 9L. CUTOUT DAMAGE AND INSTALLED REPAIR CHANNELS REF SRM 53-00-07 REPAIR 1. INITIATED DIP 11725 FOR SUPPLEMENTAL DVI INSPECTIONS REF ZONE 2 OF TABLE 203 OF SRM 53-00-07. FRAME CRACKED BETWEEN STR 8LT AND STR 9LSDR CALA2011071200485Frame · crackedCABIN FRAME CRACKED AT STA 1580 BETWEEN STR 8R AND 9R. CUTOUT DAMAGE AND INSTALLED REPAIR CHANNELS REF SRM 53-00-07 REPAIR 1. INITIATED DIP 11726 FOR SUPPLEMENTAL DVI INSPECTIONS REF ZONE 2 OF TABLE 203 OF SRM 53-00-07. FRAME CRACKED BETWEEN STR 8RT AND STRSDR SWAA114994Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME WEB CRACKED AT BS 178, RBL 17.0. REPAIRED WEB PER SRM.SDR SWAA114964Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867 STR 8R. REPAIRED FRAME PER EA.SDR SWAA114963Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 787 STR 8L. REPAIRED FRAME PER EA.SDR SWAA114962Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 747 STR 8L. REPAIRED FRAME PER EA.SDR SWAA114961Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 727D, STR 8L. REPAIRED FRAME PER EA.SDR SWAA114960Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA114959Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA114946Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR C2XA11TY105Frame · crackedFRAME 10 BELOW THE PILOTS DV WINDOW IS CRACKED. REMOVED AND REPLACED FRAME 10 IAW EMB145 SRM 51-40-02.SDR FDEA201107092868Frame Splice · corrodedFRAME SPLICE SEGMENT AT BS 620, STRINGER 27- 26 LT IS CORRODED. REMOVED FRAME SPLICE SEGMENT AT BS 620, STR 27L TO 26L IAW SRM 51-30-2. FABRICATED FRAME SEGMENT IAW DWG 51FX521 AND 53FX1497. INSTALLED FRAME SEGMENT IAW SRM 51-30-2.SDR CALA2011071100476Frame · crackedSUPPORT TASK FOUND ON GV INSP OF EA 5310-04716 REV C OP 2 STEP 3.0 STRUCTURAL DAMAGE CRACK BETWEEN STR 8R AND STR 9R ON FRAME 480 RT. REPAIRED CRACK AT FRAME 480 RT BETWEEN STR 8R AND STR 9R IAW EA 5310-04716 REV C OP 2.SDR ABXA2011070885Failsafe · crackedRT FAILSAFE STRAP CRACKED. REMOVED AND REPLACED RT FAILSAFE STRAP IAW REA B653-59411-MR, REA B653-59428-MR.SDR FDEA201107082611Frame · damagedDURING ACCOMPLISHMENT OF EO 6-5310-7-5017 A5 PART 4, HOLES A-N AT FRAME 47 RT FOUND TO BE IN OVERSIZED CONDITION. ACCOMPLISHED REPAIR PER EA 6-5310-143612, REPAIR CLASSIFIED AS MINOR PER GMM 6-2-100 REV 112.SDR FDEA201107082610Frame · damagedDURING ACCOMPLISHMENT OF EO 6-5310-7-5017 A5 PART 3, HOLES A-N AT FRAME 47 LT ARE FOUND TO BE IN OVERSIZED CONDITION. REPAIRED PER EA 6-5310-143612, REPAIR CLASSIFIED AS MINOR PER GMM 6-2-100 REV 112.SDR CALA2011070800470Frame · crackedSUPPORT TASK FOUND ON GENERAL VISUAL INSPECTION OF EA 5310- 04716 REV C OPS 2 STEP 3 STRUCTURE DAMAGE (CRACK ) BETWEEN STRINGER 8R & 9R. REPAIRED FRAME AT STA 440 RT PER EA 5310 04716 REV C OPS 2 FIG 3.SDR CHQA201100276Frame · crackedDURING INSPECTION, FRAME 10 LEFT SIDE WAS FOUND TO BE CRACKED ON THE UPPER INBOARD SIDE. MAINTENANCE REMOVED THE CRACKED FRAME AND INSTALLED THE NEW FRAME IN ACCORDANCE WITH SRM 51-40-02.SDR IPXA1568565Frame · dentedINSPECTION TYPE:C-CK, FWD CARGO FRAME 720 HAS A DENT AT STRINGER 23L AND A DENT JUST ABOVE STRINGER 24L. FABRICATED AND INSTALLED REPAIR IAW SMR 53-00-07-2R, REPAIR 5, DETAIL II II.SDR DALA1147240672Frame · dentedAFT CARGO FRAME DENTED STA 1620 BETWEEN STR 25-26L. REMOVED DAMAGE AND INSTALLED REPAIR DURING HMV.SDR IPXA11568435Frame · dentedINSPECTION TYPE:C3, FWD CARGO COMPARTMENT, STA 780, RBL 39 SIDE FRAME IS DENTED. REPAIRED IAW SRM 53-00-07-2R-5.SDR FDEA201107072604Frame · damagedFRAME LOCATED AT STA 1640,S-6R-S-7R DAMAGED. ACCOMPLISHED E.A. F5310-152613.SDR UIEA2011070700366Frame · corrodedCORROSION ON FWD LOWER CHORD (PN 65B15207-15) OF BULKHEAD AT STA 1348, RBL 49.5. (REPAIR IAW EI NR T2011A53B-1529, REV 00 AND REV 01 AND REV 02.)SDR IPXA11568141Frame · damagedINSPECTION TYPE:C-1, MAIN CARGO COMPARTMENT FRAME 600 HAS DOUBLE DRILLED ON INNER CHORD NEAR STRINGER 12R AND 13R. FABRICATED AND INSTALLED FRAME REPAIR IAW EA110822 IR.SDR USAA2011071300014Frame · elongatedCABIN FRAME INSP - SEVERAL ELONGATED HOLES IN FUSELAGE FRAME AT BS 794.3 BETWEEN S16R & S27R. REPLACED FUSELAGE FRAME AT BS 794.3 BETWEEN S16R & S27R IAW BOEING DRAWING 65-47959.SDR CALA2011070700466Frame · crackedSUPPORT TASK PAX CABIN HAS CRACKED FRAME 500FL BETWEEN STR 9L AND 8L. REPAIRED CRACKED FRAME AT STA 500F LEFT SIDE. REF EA 5310-04716 REV C OPS 2.SDR SWAA114889Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 747, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA114890Angle · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME ANGLE CRACKED AT BS 867, STR 8L. REPAIRED ANGLE IAW EA.SDR SWAA114908Angle · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME ANGLE CORRODED AT BS 360, STR 27L. REPAIRED ANGLE IAW SRM AND DWG.SDR SWAA114883Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 867, BETWEEN STR 8R TO STR 9R. REPAIRED FRAME PER EA.SDR AALA20110707TUL17Frame · damagedFRAME DAMAGE AT FORWARD FLANGE STATION 1401. REPAIR STRAP DOUBLER INSTALLED PER EA MD80-53-017853.SDR CHQA201100269Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE LEFT CHANNEL FRAME AT FRAME 65 BETWEEN STRINGER 15L AND 16L. THE CORRODED AREA MEASURED 2.9" BY 0.8". MAINTENANCE REPLACED FRAME 65 BETWEEN STRINGERS 15L AND 16L. THE NEW PART WAS INSTALLED WITH A SOLID RIVET ISDR CALA2011070700468Frame · crackedSUPPORT TASK FOUND ON GV INSP OF EA 5310-04716 REV C OP 2 STEP 3.0 STRUCTURE DAMAGE CRACK BETWEEN STR 8R AND STR 9R ON FRAME 380 RT SIDE REPAIRED DAMAGE AT FRAME 380 RT SIDE PER EA 5310-04716 REV C FIG 3.SDR JR2R2011070700276Frame · corrodedFS 364 FRAME HAS CORROSION AT FASTENERS.SDR JR2R2011070700275Frame · corrodedFRAME CORRODED AT FS 333 FROM STRINGER 26R TO 26R.SDR IPXA11568140Frame · damagedINSPECTION TYPE:C-CK, MAIN CARGO COMPARTMENT RT SIDE FRAME 560 BETWEEN STRINGER 15R AND 16R HAS DOUBLE DRILLED FASTENERS THROUGH FREE FLANGE CUT OUT DAMAGE. FABRICATED AND ISNTALLED REPAIR IAW EA 110763 IR.SDR CALA2011070700463Frame · crackedPASSENGER CABIN, RT SIDEWALL,STA 480 & S-8R. FRAME APPEARS TO BE CRACKED AT I/B FASTENER WHERE PSU BRACKET ASSEMBLY ATTACHES TO FRAME (MARKED). REPAIRED CRACKED FRAME PER EA5310-04716 REV C OP02.SDR CALA2011070700464Frame · crackedSUPPORT TASK STA 400R HAS CRACKED FRAME BETWEEN STR8-9 AT PSU ATTACH BRACKET. REPAIRED PER EA 5310-04716 REV C.SDR SWAA114872Frame · corrodedDURING SCHEDULED 16Y CHECK, FOUND FORWARD CARGO COMPARTMENT FRAME CORRODED AT BS 500C, BETWEEN STR 27L TO STR 28L. REPAIRED FRAME IAW SRM.SDR SWAA114869Frame · corrodedDURING SCHEDULE 16Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 807, BETWEEN STR 25L TO STR 26L. REPAIRED FRAME PER SRM.SDR CALA2011070700465Frame · crackedSUPPORT TASK - STA 380R HAS CRACKED FRAME BETWEEN STR 8-9 PSU AT TACH BRACKET. REPAIRED FRAME STA 380R, STR 8-9 PER EA 5310-04716 REV C.SDR FDEA201107062600Frame · damagedFRAME LOCATED AT BS 1400 BETWEEN S-25L TO S-26L DAMAGED. REPAIRED IAW F-5310-146538. CATEGORY "A" MAJOR REPAIR.SDR FDEA201107062598Frame · misrepairedFRAME AT STA 1260 BETWEEN S-25R AND S-26R MISREPAIRED. REMOVED EXISTING REPAIR ANGLE IAW EA F-5310-147706. MAJOR REPAIR.SDR FDEA201107062597Frame · damagedFRAME LOCATED AT BS 1320 BETWEEN S-23R DAMAGED.SDR AALA20110725DWH01Frame · brokenAIRCRAFT STRUCK BY LAVATORY SERVICE CART. FRAME AND FORMERS WERE DAMAGED UNDER SKIN. REPAIRED FRAME AND FORMERS PER SRM AND EA MD-80-53-018225.SDR SWAA114849Fitting · corrodedDURING SCHEDULED 12Y CHECK, FOUND FRAME FITTING CORRODED AT BS 360, STR 28L. REMOVED AND REPLACED FITTING IAW SRM AND DWG.SDR AALA20110705TUL07Frame · corrodedAFT CARGO, CORROSION ON STATION 1322 FRAME, FORWARD SIDE, AT LONGERON 30. CUT OUT DAMAGE AND INSTALLED "J" ANGLE REPAIR PER AARD 53-10-00-17.
Back to JASC 5311