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 SWAA113138Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER EA.SDR SWAA113131Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CRACKED AT BS 663, STR 3L. REPAIRED FRAME PER SRM.SDR IPXA1566653Frame · dentedINSPECTION TYPE:C1, LOWER FWD CARGO PIT FRAME AT STA BS 840, BELOW STRINGER 24L FREE FLANGE IS DENTED. REPAIRED FRAME AT BS 840 STR 24L IAW EA 110439.SDR IPXA1566652Frame · dentedINSPECTION TYPE:C1, LOWER FWD CARGO COMPARTMENT FRAME AT STA 870, AT STR 24L, INBD FREE FLANGE IS DENTED. CUT OUT DAMAGE. FABRICATED REPAIR J, SHEAR TIE AND STRINGER CLIP INSTALLED IAW SRM 53-00-07-2R 5 DETAIL III AND EA 110438.SDR IPXA1566651Frame · dentedINSPECTION TYPE:C1, AFT CARGO COMPARTMENT STA 1260, STR 26L FRAME IS DENTED ON INBD FLANGE. CUT OUT DAMAGE. FABRICATED AND INSTALLED REPAIR ANGLE, SHEAR TIE AND STRINGER CLIP IAW SRM 53-00-07-2R 5 DETAIL III AND EA 110443 IR.SDR IPXA1566649Frame · dentedINSPECTION TYPE:C1, AFT CARGO COMPARTMENT STA 1260 JUST BELOW STR 25R, FRAME IS DENTED ON INBD FLANGE CUT OUT DAMAGE. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R-5 AND EA11044 IR.SDR IPXA1566647Frame · dentedINSPECTION TYPE:C1, LOWER FWD CARGO PIT FRAME AT BS 660 BETWEEN STRINGER 24R AND 25R, IS DENTED ON INBD FREE FLANGE CUT OUT DAMAGE. FABRICATED AND INSTALLED REPAIR ANGLES SHEER TIE AND STRINGER CLIPS IAW SRM 53-00-07-2R 5 DETAIL III AND EA 110434 IRSDR FDEA201104251611Frame · dentedCABIN RT STATION 1741 L-11 FRAME FOUND DENT. REPAIRED AS PER SRM 53-00-07 FIG 201 REVISION 46. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REVISION 112. REPETITIVE INSPECTION AT 9500 AND INITIAL INSPECTION AT 14500 BY HFEC METHOD AS PER SRM 53-00-07 FIG 201 SDR FDEA201104251610Frame · dentedCABIN RT STA 1721 L-11 FRAME FOUND DENTED. REPAIRED AS PER SRM 53-00-07 FIG 201 REVISION 46. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REVISION 112. REPETITIVE INSPECTION AT 9500 AND INITIAL AT 14500 BY HFEC METHOD AS PER SRM 53-00-07 FIG 201 REVISION 46.SDR DALA1133696313Floorbeam · corrodedCORROSION ON FLOORBEAM ATTACHMENT CROWN AT BS 520-540, RBL 98.5. S:2"X1" IN MAIN DECK. REPLACED THE CROWN WITH NEW ONE PER SRM 51-40-02 P1.SDR IPXA1566353Frame · dentedINSPECTION TYPE:C1, LOWER FWD CARGO PIT FRAME AT BS 720 BELOW STRINGER 23L, IS DENTED. REMOVED DAMAGED SECTION OF FRAME AT STA 720, STR 23L. FABRICATED REPAIR PARTS FROM 7075-T6.071. INSTALLED REPAIR IAW SRM 53-00-07-2R5, DETAIL 1.SDR SWAA113104Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 27R TO STR 28R. REPAIRED FRAME PER SRM.SDR DALA1128709871Frame · chafedFS 1190 AT L16R FRAME HAS HOLE CHAFED THRU BY ORIGINAL AUG VALVE. CUT OUT DAMAGED AREA 1 1/2"X 3/4" IAW SRM 53-03 FIG4. NDT VERIFIED DAMAGE REMOVED. NO CRACKS IAW NDT SPM 06-10-01.001 REC REPAIR ANGLE. LOCATED, DRILLED IAW SRM 51-10-4. FABRICATED DOUBLER PLSDR SWAA113078Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA113077Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME PER EA.SDR SWAA113076Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR SWAA113063Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND FRAME CORRODED AT BS 500C, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA113060Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 380, STR 16L. REPAIRED FRAME PER SRM.SDR SWAA113040Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 794, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA113039Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 794, STR 25R. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA113038Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND AFT CARGO COMPARTMENT FRAME CORRODED AT BS 794, LOWER DOOR SILL WEB ATTACH ANGLE. REPAIRED FRAME PER SRM AND BAC DWG.SDR SWAA113037Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR JR2R2011042500165Frame · corrodedFRAME AT STA 364 CORRODED AT STR 27R. REPAIRED FRAME 364 STR 27R IAW CRJ RO CRJ9-53-0646.SDR DALA1131319866Support Fitting · corrodedFWD CARGO STA 465 LEFT LONGERON 29 ON AFT SIDE OF FRAME SUPPORT CLIP HAS CORROSION REMOVED CLIP IAW DC9 SRM 51-30-5 TO GAIN ACCESS REMOVED CORR L 3" X W 2" IAW DC9 SRM 51-10-3 ORG .063 IAW DAC DWG DL5911412 REV DV. REMOVED .013 REMAINING.050 OUT OF LIMITS IAWSDR DALA1133910688Frame · dentedDURING HMV A DENT WAS FOUND IN THE BULK CARGO COMP FRAME STA 1540 AT S26L. FRAME WAS REPAIRED IAW SRM 53-00-07 REPAIR 5 FIG 201 SHEETS (1-15).SDR USAA2011050291714Frame · crackedCLT - Q2 CHECK - CRACK ON FRAME AT BS 500B, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME AT BS 500B, BETWEEN STR 20R TO STR 21R IAW B737-400 SRM 53-00-07 AND BOEING SB 737-53A1279.SDR AALA20110422TUL04Frame · crackedFRAME CRACKED AT CANT 1463. REMOVED AND REPLACED CRACKED FRAME PER AARD 51-10-00-5.SDR DALA1137009866Frame · crackedAFT ACC COMPT STA 1234 CANTED FR CRACKED. REMOVED TAIL ANTI-ICE DUCT REPAIRED FRAME STA 1234 LT IAW DC-9 SRM 51-30-1 AND REINSTALLED TAIL ANTI-ICE DUCT LEAK AND OPS CHECKED GOOD P134 27 MAY 11. REQUIRED INSPECTION COMPLETED.SDR SIMA201111201Frame · corrodedDURING MAINTENANCE BASE VISIT INSPECTION FOUND FRAME 23 CRACKED JUST BELOW FLOOR LEVEL. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIR COMPLIED WITH AS PER EO EM-53MR-1805 FOR FRAME 23RT SPLICE. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR AALA20110421TUL04Frame · crackedAFT ACCESSORY 1418 FRAME CRACKED AT LONGERON 2 RIGHT. DOUBLER INSTALLED PER SRM 53-03-00.SDR HNAA2011050600113Frame · crackedFRAME STA 128.1 CRACKED BETWEEN STRINGER 25R AND 26R. REPAIRED FRAME STATION 128.1 BETWEEN STRINGER 25R AND 26R IAW -8300 SRM 53-20-21, PAGE 2.SDR U2RA486DHN027Frame · dentedAFT CARGO COMPARTMENT AT FUSELAGE STA BS 1340, BETWEN STRINGER S22L AND S23L. FRAME TOP LEG DENTED ABOVE SPLICE.SDR JR2R2011042000147Frame · corrodedFRAME AT STA 319 CORRODED STR 26L TO STR 26R. REPAIRED FRAME IAW CRJ 9 RO CRJ9-53-0654.SDR SWAA113287Frame · corrodedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO COMPARTMENT CORROSION ON LOWER FRAME BS 867 BETWEEN STR 26R TO STR 27R. REPAIRED PER SRM.SDR GLBA20110420JFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND THE CARGO DOOR FUSELAGE FRAME AT FS 500 AND STRINGERS 4L & 5L CRACKED AT THE STRUT MOUNT UPPER IB NUTPLATE AREA, .65" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL RESDR GLBA20110420HFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSPECTION MAINTENANCE FOUND A CRACK IN THE CARGO DOOR FUSELAGE FRAME AT FS 456 AND STRINGER 3L & 4L AT THE GAS STRUCT MOUNT UPPER IB NUTPLATE AREA, .25" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMEDSDR KHS2011F00000Frame · crackedINSTALLED DUAL HOIST ON ACFT. MX WAS NOTIFIED THRU A COMPANY SAFETY REPORT OF A POTENTIAL PROBLEM WITH A FRAME ASSY ON THE DUAL HOIST. MX CLEANED THE EFFECTED AREAS FOR INSP, AND FOUND CRACKS PROPAGATING LOGITUDINALLY AT THE UPPER AND LOWER ATTACHMENTS AND MSDR ASAA1149483Frame · corrodedFOUND HOLE IN EXISTING FRAME LOWER FLANGE FORWARD CARGO BAY STA 500G FRAME CORRODED BETWEEN STR 27L- 26L. REMOVED OLD REPAIR, FABRICATED NEW REPAIR AND INSTALLED IAW B737 400 SRM 51 40 02 AND SRM 53 00 07 FIG 201.SDR ASAA1149482Frame · corrodedFORWARD CARGO BAY STA 500G FRAME CORRODED BETWEEN STR 26R AND 27R. REPAIRED THE 500G FRAME IAW B737 400 SRM 53 00 07 FIG 201. REPAIR IS CATEGORY "B" REPAIR AND REQUIRES INSPECTION AT 66000 TOTAL FLIGHT CYCLES.SDR DALA1127309871Frame · crackedAFT ACCESSORY, RT STA 1209, FRAME WEB IS CRACKED MULTIPLE PLACES BETWEEN L9R AND L13R. REMOVED WEB AT STA 1209, BL L9R-L13R IAW SRM 51-30-2. RECEIVED MAT FOR DOUBLER & REPAIR .032, 7075-T6, PO 1022537 & .040 7075-T6 IAW SRM 51-70-4 FIG 1 FABRICATED, LOCATEDSDR SWAA112944Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS360, STR 8R. REPAIRED FRAME PER EA.SDR SWAA112927Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 639, WL 203.5. REMOVED AND REPLACED FRAME PER SRM AND BAC DWG.SDR SWAA112913Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER EA.SDR SWAA112912Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER EA.SDR SWAA112911Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500, BETWEEN STR 13L TO STR 14L. REPAIRED FRAME PER EA.SDR SWAA112910Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 460, BETWEEN STR 13R TO STR 14R. REPAIRED FRAME PER EA.SDR SWAA112901Frame · crackedDURING SCHEDULED 26Y CHECK, FOUND FRAME CORRODED AT BS 787, STR 27L. REPAIRED FRAME PER SRM.SDR SWAA112877Frame · crackedDURING SCHEDULED 18Y CHECK, FOUND FRAME CRACKED AT BS 500B, BETWEEN STR 20L TO STR 21L. REPAIRED FRAME PER SRM.SDR IPXA11566585Frame · dentedINSPECTION TYPE:C3, AFT PIT STA 1300 AT S-21R FRAME IS DENTED. REPAIRED AFT PIT FRAME STA 1300-S-21R IAW EA 110395.SDR ABXA2011051039Fitting · corrodedLEFT SIDE FRAME FITTING HAS CORROSION IN THE AFT CENTER AND AFT OUTBOARD POCKET. REMOVED CORROSION IAW B767 SRM 51-10-02. AREA REPAIRED IAW REA B653-59259-MR.
Back to JASC 5311