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 UALA2012112806805Frame · crackedSTA 1180 LT TENSION TIE TWO HOLES CRACK REPAIRED. REPLACED THE STA 1180 FRAME PER SRM.SDR QXEA2012112801463Frame · corrodedFRAME BS 341, FLANGE IS CORRODED STRINGER 32P-31P. REMOVED RIVETS FOM IAW SRM 51-42-05-02-01. BLENDED CORROSION IAW RD 8/4-53-2344. MIN NOTED THICKNESS .053" REF NTM 51-00-4-910-801 PT 1, VERIFIED AFFECTED AREA TO BE CRACK FREE USING HFEC REF NTM 51-00-06-910SDR QXEA2012112801458Frame · corrodedFRAME BS 136 FLANGES ARE CORRODED STRINGER 30P-32P. REMOVED RIVETS IAW SRM 51-42-05-02-01 AND REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN REMAINING THICKNESS .038" REF NDTM PT 1 51-00-04-910-801. INSPECTED BLENDS FOR CRACKS USING HFEC, NO CRACKS NOTED REF NSDR SWAA2012121810763Frame · corrodedAD DRIVEN AFT CARGO COMPARTMENT FRAME AT BS 947 CORRODED BETWEEN STRINGERS 25R AND 26R. REMOVED AND REPLACED FRAME WITH NEW AT BS 947 51-12-32L-23R IAW SRM 51-40-02 AND BOEING DWG 65-46560.SDR SWAA2012121810762Failsafe · corrodedCARGO COMPARTMENT FAIL SAFE CHORD AT BS 947 CORRODED. REMOVED AND REPLACED IAW SRM AND DWG.SDR QXEA2012112701496Frame · corrodedFRAME BS 176 FLANGES ARE CORRODED STRINGER 30-32S. REMOVED RIVETS FOM CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .039, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. FOUND IN LIMITS IAW RD 8/4-53-2344. ASDR QXEA2012112701435Frame · corrodedFRAME BS 258.5, FLANGE IS CORRODED STRINGER 30P-27P. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .040, CONFIRMED AFFECTED AREAS CRACK FREE IAW NTM 51-00-06-910-801 PT 1 AND NTM 51-00-04-910-801 PT 1. FOUND TO BE IN LIMITS IAW RD 8SDR WVER2012112791101Frame · bentFS 193.00 FRAME IS BENT ON LEFT SIDE LOCATION COMMON TO TRU DOOR AFT SEAL STRIKER, DUE TO BIRD STRIKE. REPAIRED FS 193 FRAME FROM BL 0 TO LEFT PRODUCTION SPLICE IAW CRJ 900 SRM 51-42-+06-001-001-A01, SRM 51-42-21-001-001-A01, AND BOMBARDIER REO 690-53-11-447.SDR ASOA2012121302647Frame · corrodedTEN NUTPLATE HOLES FROM FS 559+80 TO 559+112 ON LBL 36 ARE CORRODED. REPAIRED IAW REO 601R-53-51-206.SDR DALA1256443739Frame · crackedBS 500A FRAME CRACKED JUST BELOW S8R. REPAIRED IAW ER/A 509137-14AD REV ORIGINAL IND ON NR 26243-2400-0024, NR 26243-2400-0024, 509137-14AD.SDR SWAA2012121010420Frame · crackedBS 500B LEFT SIDE FRAME CRACKED AT GENERATOR FEED THRU HOLE. REMOVED AND REPLACED FRAME IAW SRM.SDR QXEA2012112601444Frame · corrodedFRAME BS 258.5 FLANGE IS CORRODED STRINGER 31P-33. REMOVED RIVETS AND CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS .036" CONFIRMED AFFECTED AREAS CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL FOUND TO BE IN LIMITS IAW SDR WX0A071399Frame · gougedCABIN LEFT FRAME GOUGED AT STATION 1212 NEAR LONGEON 17L. REMOVED DAMAGED AREA, FABRICATED REPAIR ANGLE, FILLER, STRAP AND INSTALLED.SDR GLBA2012112600113Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND FUSELAGE FRAME AT FS 107 AND STRINGER 8R CRACKED AT INBD FLANGE AT UPPER FASTENER HOLE, .5" IN LENGTH. MX REPAIRED THE AFFECTED AREA IAW EO 12-1900-53-070. MAJOR REPAIR.SDR GLBA2012112600112Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND FUSELAGE FRAME AT FS 107.00 AND STRINGER 8L CRACKED AT INBD FLANGE TO UPPER FASTENER HOLD, .5" IN LENGTH. MX REPAIRED THE AFFECTED AREA IAW EO 12-1900-53-071. MAJOR REPAIR.SDR ABXA20121126300Failsafe · crackedRIGHT FAILSAFE CRACKED VERIFIED WITH HFEC CRACK FOUND ON FREE EDGE (AFT) LOWEST FASTENER OF INSP AREA. PERFORMED RIGHT FAILSAFE TRIM OUT REPAIR PER EA 53500014-003 AND AMES DOCUMENT 47008, ACFT WAS GROUNDED.SDR WX0A071393Frame · gougedCABIN LEFT FRAME GOUGED AT STATION 1231 NEAR LONGERON 17L. REMOVED DAMAGED AREA, FABRICATED REPAIR ANGLE, FILLER, STAMP AND INSTALLED.SDR DALA12013860935Frame · crackedCRACK ON FRAME BS 1510 . FRAME REPLACED IAW SRM DRD 53-3D, FIG 802 D AND DWG 9911843, REV AC.SDR DALA12013850935Frame · corrodedCORROSION ON FRAME TEE BS 1380 BETWEEN LONGERON 25L-25R AND ON FRAME FWD CAP. FRAME REPLACED IAW DWG 9912246 REV CE.SDR SWAA2013010711187Frame · crackedFRAME WEB CRACKED AT BS 440, STR 16R. REMOVED AND REPLACED WEB IAW EO AND EA.SDR CALA2012112600821Frame · crackedFRAME BS 440 BETWEEN STRINGERS 8R AND 9R CRACKED AT AIR CONDITIONING OUTLET ATTACH BRACKET REF STEP 7 OF EA 5310-04716 REV D, FRAME 440 R HAS BEEN REPAIRED IAW ECRA 5310-05616.SDR CALA2012112600820Frame · crackedFRAME AT BS 400 BETWEEN STRINGERS 8R AND 9R CRACKED AT AIR CONDITIONING OUTLET BRACKET REF EA 5310 -04716 REV D STEP 7 FRAME 400 R HAS BEEN REPAIRED IAW ECRA 5310-05616.SDR CALA2012112600819Frame · crackedFRAME AT BS 480 BETWEEN STRINGERS 8R AND 9R CRACKED AT AIR CONDITIONING OUTLET ATTACH BRACKET REF STEP 7 OF EA 5310-04716 REV D OP 1 FRAME 480 R HAS BEEN REPAIRED IAW ECRA 5310-05616.SDR CALA2012112600818Frame · crackedFRAME AT STA 907 BETWEEN STR`S 8R AND 9R CRACKED AT AIR CONDTIONING OUTLET ATTACH BRACKET REF STEP 7 OF EA 5310-04716. REPAIR ACCOMPLISHED IAW ECRA 5310-05620.SDR CALA2012112600814Frame · crackedFRAME 440 CRACKED BETWEEN STR 8L AND 9L AT ATTACH BRACKET FRAME FASTENER HOLE. FRAME HAS BEEN REPAIRED IAW EA 5310-04716 OP 1 REV DSDR DALA1255230183Frame · corrodedBS 1439, S16 TO 18L FRAME OTBD FLANGE CORRODED. AREA TRIMMED OUT AND REPAIRED IAW ERA 507547-14 REV 0.SDR DALA1255210183Frame · crackedBS 903 FRAME CRACKED AT S21R. REPAIRED IAW ERA 507534-14 REV0.SDR DALA1255200183Frame · crackedBS 903 FRAME CRACKED AT S21L. REPAIRED IAW ERA 507533-14 REV0.SDR SWAA2013010811264Frame · crackedFRAME CRACKED AT BS 947.5, STR 19R. REMOVED AND REPLACED FRAME IAW EA.SDR USAA2012121000005Frame · crackedQ3 CHECK - .250 INCH CRACK IN FUSELAGE FRAME WEB & .30 INCH CRACK IN DOUBLER AT BS303.9 BETWEEN S14L TO S18L. REPLACED FUSELAGE FRAME WEB & DOUBLER IAW ENGINEERING JOB CARD # M1L53001.SDR R61A201211230689Frame · damagedWHILE AIRCRAFT WAS OUT OF SERVICE AND DURING ACCOMPLISHMENT OF A REPAIR, MAINTENANCE MISDRILLED RIVET HOLE IN FRAME 1, 5TH HOLE OUTBOARD OF STRINGER 28R. MAINTENANCE REPAIRED MISDRILLED HOLE IAW ETD 2012-190-017046. (MAJOR REPAIR) THE AIRCRAFT IS OUT OF SERSDR QXEA2012112301424Frame · corrodedFRAME 321, FLANGE IS CORRODED STRINGER 30S-29S. REMOVED FASTENERS TO ACCESS CORROSION IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AFFECTED AREA IS CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FSDR QXEA2012112301422Frame · corrodedFRAME 321, FLANGES ARE CORRODED STRINGER 29P-31P. REMOVED NECESSARY RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND TO BE IN LIMITS IAW RD 8/4-5SDR SWAA2012121810748Failsafe · crackedBS 967 BETWEEN AT S19R FAILSAFE CHORD IS CRACKED. REMOVED AND REPLACED CRACKED FAILSAFE CHORD P/N 65-46563-8 PO 760882.1 BS 967 UPPER SECTION AT STRINGER 19R IAW BAC DWG 65-46563 AND B737-300 SRM 51-40-02.SDR SWAA2012121810747Failsafe · crackedBS 967 BETWEEN STR 23-24R FAILSAFE CHORD CRACKED. REMOVED AND REPLACED CHORD IAW BAC DWG.SDR FDEA201211214107Frame · crackedFRAME END CAP AT BS 555, NEAR LONGERON 32R, IN AIR CONDITION PACK NR 3 COMPARTMENT, FOUND CRACKED. REMOVED AND REPLACED IAW SRM 51-35- 01, REVISION 51.. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REVISION 115.SDR SWAA2012120510249Frame · crackedFRAME WEB CRACKED ON UPPER EDGE BS 243.7 WL 230 LEFT FRAME. FRAME WEB CRACK ON UPPER EDGE BS 243.7 WL 230 LEFT FRAME WAS REPAIRED PER ER 12-03612 AND EA 1-753-21163.SDR QXEA2012112101419Frame · corrodedFRAME 94.8 FLANGES ARE CORRODED STRINGER 33-30S. REMOVED RIVETS AND CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. VERIFIED BLEND AREAS CRACK FREE IAW NTM 51-00-06-910-801 PT 1 AND NTM 51-00-04-910-801 PT 1. FLANGES FOUND TO BE IN LIMITS IAW RD 8/4-53-23SDR QXEA2012112101418Frame · corrodedFRAME 116 FLANGES CORRODED STRINGER 30S-32S. REMOVED NECESSARY RIVETS AND CORROSION IAW RD 8/4-53-2344. VERIFIED BLEND AREAS IAW NTM 51-00-06-910-801 PT 1 AND NTM 51-00-04-910-801 PT 1. NOMINAL FRAME THICKNESS .040". FLANGES FOUND TO BE IN LIMITS IAW RD 8/4-SDR FDEA201211214108Frame · damagedFRAME AT BS 1620, S2L TO S3L FOUND WITH DEEP DRILL MARK. REPAIRED IAW PART 1 OF EA: F-5310-163848. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100.SDR SIMA20121121003Frame · corrodedDURING 2C CHECK FOUND CORROSION AT FS 319.7 ON THE FLANGE SEGMENT BETWEEN STRINGER 26L AND 27L. THE AIRCRAFT WAS REMOVED FROM SERVICE. COMPLETED REPAIR OF THE LOWER FRAME SEGMENT AT FS 319.7 BETWEEN STRINGER 26 LEFT AND 26 RIGHT IAW EO CR-53MR-303. THE AIRCSDR SIMA20121121002Frame · corrodedDURING 2C CHECK FOUND FRAME AT FS 549.00 CORRODED. THE AIRCRAFT WAS REMOVED FROM SERVICE. COMPLETED FRAME REPAIR AT FS 549.00 IAW EO CR-53MR-304. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR SWAA2013010811263Frame · crackedCRACK ON FRAME WEB AT BS 727C AT STR 14R. REPAIRED WEB IAW EA AND EO.SDR SWAA2012122710888Frame · crackedCRACK ON FRAME AT BSTA 320 STR E/E COMPARTMENT. REPLACED FRAME AT BS 320 STR 18L/20L E/E COMPARTMENT IAW SRM.SDR SWAA2012121710727Frame · crackedPASSENGER CABIN STA 727, STR 14R, FRAME CRACKED. REMOVED AND REPLACED FRAME IAW EA.SDR SWAA2012121010443Frame · corrodedCORROSION ON FRAME BETWEEN S-27L AND S-26L AT BS 360 E/E COMPARTMENT. PERFORMED REPAIR ON FRAME LOCATED BETWEEN S-27L AND S-26L AT BS 360 E/E COMPARTMENT IAW SRM B737-300 53-00-07 REPAIR 7 DETAIL II TABLE 1.SDR SWAA2012121010442Frame · corrodedCORROSION ON FRAME LOCATED BETWEEN S-27R AND S-28R AT BS 380 E/E COMPARTMENT. PERFORMED REPAIR ON FRAME LOCATED BETWEEN S-27R AND S-28R AT BS 380 E/E COMPARTMENT IAW SRM B737-300, 53-00-07 REPAIR 4 DETAIL II.SDR DALA12014705653Frame · dentedAFT CARGO COMPARTMENT FRAME IS DENTED AT UPPER SURFACE AT BS 1480, S23 AND 26L. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07, REPAIR 5, FIG 201. THIS IS A CATEGORY B REPAIR.SDR DALA12014695653Frame · dentedAFT CARGO COMPARTMENT, FRAME IS DENTED AT UPPER SURFACE AT BS 1400, BETWEEN S23 AND 26L FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-R5, FIG 201.SDR DALA12014675653Frame · dentedAFT CARGO COMPARTMENT, FRAME IS DENTED AT UPPER SURFACE AT BS 1400, BETWEEN S23 AND 26L. GAINED ACCESS, FABRICATED AND FRAME BS 1400 BETWEEN S23 AND 26L.
Back to JASC 5311