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 WVER201303149131Frame · chafedFRAME 1144 CHAFED FROM LOOSE WATER EJECTOR LINE FROM RIGHT ACM AT STR 9R.SDR ASOA2013040403302Frame · corrodedFRAME BS 333 AT THE BOTTOM IS CORRODED. REMOVED CORRSION IAW SRM 51-21-06-001-001, ORIG MAT .050, DWG SH670-31356. COMPLIED WITH EO CL600-2024-53-I00204.SDR ASOA2013040403301Frame · corrodedFRAME BS 319 CORRODED AT THE BOTTOM. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. ORIGINAL THICKNESS .050 IAW SRM 53-21-06-001-002-A01.SDR SWAA2013040414482Frame · corrodedFRAME CORRODED AT BS 500B, BETWEEN STR 28L-28R. REPAIRED FRAME PER ER AND EA.SDR SWAA2013040114343Frame · crackedFRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME IAW ATS ER.SDR SWAA2013032113973Frame · crackedFRAME CRACKED AT BS 827, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013032113972Frame · crackedFRAME CRACKED AT BS 500A, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013032113971Frame · crackedFRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013032113970Frame · crackedFRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013032113969Frame · crackedFRAME CRACKED AT BS 400, STR 8L. REPAIRED FRAME IAW EA.SDR SWAA2013032113960Frame · crackedFRAME CRACKED AT BS 867, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013032113959Frame · crackedFRAME CRACKED AT BS 787, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013032113958Frame · crackedFRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013032113957Frame · crackedFRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME IAW EA.SDR SWAA2013032113956Frame · crackedFRAME CRACKED AT BS 400, STR 8R. REPAIRED FRAME IAW EA.SDR AALA20130313035Frame · crackedTHE 1510 CANT FRAME CRACKED AT LOWER RIGHT TAIL CONE ALIGNMENT PIN. INSTALLED DOUBLER PER SRM 53-01-00.SDR QXEA2013031300569Frame · corrodedFRAME 49.5, FLANGES ARE CORRODED STR 33-29S. REMOVED CORROSION IAW SRM 51-21-00-00-02, REV 12. CONFIRMED CRACK FREE CONDITION REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1 REV 9. FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013031300568Frame · corrodedFRAME 32.4, FLANGES ARE CORRODED STR 30P-32P. REMOVED CORROSION IAW SRM REV 12 53-00-00-02-09. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1 REV 9. WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013031300567Frame · corrodedFRAME 32.4, FLANGES ARE CORRODED STR 33-30S. REMOVED CORROSION IAW SRM REV 12 53-00-00-02-09. VERIFIED BLEND CRACK FREE IAW NTM 51-00-06-910-801, PART 1, REV 8. IN LIMITS IAW SRM 53-00-00-02-09, REV 12.SDR QXEA2013031300566Frame · corrodedFRAME FLANGE AT FR 94.8 STR 29P-28P HAS CORROSION. REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1 REV 9. FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00-02-09, REV 12SDR ASOA2013040403300Frame · corrodedFRAME BS 310 IS CORRODED AT THE BOTTOM. REMOVED CORROSION BS 310 BETWEEN STR 25-26R IAW SRM 51-21-06-001-001-A01. COMPLIED WITH EO CL600-2024-53-I00181.SDR ASOA2013040403299Frame · corrodedFRAME BS 349 IS CORRODED AT THE BOTTOM. REPAIRED IAW SRM 51-21-06-001-001-A01.SDR ASOA2013040403297Frame · corrodedAT THE BOTTOM OF FRAME BS 280 THE RING BELOW THE FRAME IS CORRODED. REMOVED CORROSION FROM FS 280 BUTTSTRAP STR 26L-26R IAW SRM 51-21-06-001-001. ORIG MAT .080 IAW DWG SH670-35254. RECEIVED AND COMPLIED WITH EO IAW NDTM PT-1, 51-20-006-250-A01.SDR SWAA2013032514038Failsafe · corrodedFAILSAFE CORRODED AT BS 807, STR 26R. REMOVED AND REPLACED FAILSAFE PER SRM AND DWG.SDR SWAA2013031913800Frame Splice · corrodedFRAME SPLICE CORRODED AT BS 787 STR 25R. REMOVED AND REPLACED SPLICE IAW SRM.SDR SIMA20130312006Frame · crackedDURING MAINTENANCE INSPECTION FOUND THE LEFT FRAME 10 IS CRACKED BELOW DV WINDOW. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED LEFT FRAME 10 IAW SRM 51-40-02. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR QXEA2013031200562Frame · corrodedFRAME 19.4 FLANGE IS CORRODED STR 31S-32S. REMOVED CORROSION IAW SRM 51-42-05-02-01, REV 12 AND SRM 51-21-00-00-02, REV 12, CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1, REV 7. FOUND TO BE WITHIN LIMITS IAW SRM SDR QXEA2013031200561Frame · corrodedFRAME 19.4 FLANGE IS CORRODED STR 30-31P. REMOVED CORROSION IAW SRM 51-42-05-02-01 REV 12 AND SRM 51-21-00-00-02, REV 12. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801, PT 1, REV 9. FOUND TO BE WITHIN LIMITS IAW SRM SDR QXEA2013031200560Frame · corrodedFRAME 321, FLANGE IS CORRODED STR 30P-29P. REMOVED CORROSION IAW SRM 53-00-00-02-09, REV 12. CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801 PT 1 REV 9. REMAINING THICKNESS FOUND TO BE WITHIN LIMITS IAW SRM 53-00-00-02SDR DALA1307686802Frame · dentedAFT CARGO FRAME IS DENTED AND GOUGED AT BS 1500 BETWEEN S26 AND 27L. REPAIRED IAW SRM 53-00-07 REPAIR 5.SDR EE4Y2013032000021Frame · dentedAFT CARGO COMPARTMENT ON STR 24R FRAME UPPER FLANGE WITH DENT. FRAME REPAIRED IAW MESSAGE AMX-13-0016-03B.SDR GLBA2013031300205Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND A CRACK IN THE FRAME AT FS 177.35 BETWEEN STR 13 - 14L AFT SIDE, 1 INCH IN LENGTH. REPAIRED IAW EO 13-1900-53-023. MAJOR REPAIR.SDR GLBA2013031300204Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE LT SIDEWALL AT FS 107 AT THE UPPER END OF THE FRAME AT THE LAST ATTACHING FASTENER AREA, .75" IN LENGTH. REPAIRED IAW EO 13-1900-53-024. MAJOR REPAIR.SDR GLBA2013031300203Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION FOUND 2 CRACKS IN THE RT SIDEWALL FRAME AT FS 107 IN THE BEND RADIUS (UPPER END OF FRAME) AND AT UPPER FASTENER AREA, 1.25" IN LENGTH. REPAIRED IAW EO 13-1900-53-025. MAJOR REPAIR.SDR DALA13011309013Frame · crackedCRACK AT BS 1418, LONGERON L2R WITHIN FRAME BACKUP ANGLE. REPAIR ANGLE PRIMED AND HOLES PICKED UP. OK TO INSTALL ANGLE C/W PRI 512493-14 REV 0.SDR DALA1307666802Frame · dentedAFT CARGO FRAME HAS A DENT AT BS 1420 S26L. REPAIRED IAW SRM 53-00-07, REPAIR 5.SDR DALA13011250944Frame · corrodedDURING SCHEDULED MX, CORROSION WAS FOUND ON FRAME TEE STA Y=1380 BTW X=24 TO X=-24 AT THE AFT ACCESSORY COMPARTMENT TAIL BUMPER AREA. DAMAGED FRAME WAS REPLACED IAW DWG 9912246, SRM 51-30-2, 51-30-5.SDR DALA1307656802Frame · dentedAFT CARGO FRAME HAS A DENT AT BS 1446 BETWEEN S25 AND 26L. REPAIRED IAW SRM 53-00-07 FIG 201, REPAIR 5.SDR EE4Y2013032600026Frame · crackedLOWER FUSELAGE FWD CARGO COMPARTMENT, BS 332, BETWEEN LONGERON 28R AND 28L, FRAME AREA, TITANIUM ANGLE WITH CRACK. DAMAGED ANGLE WAS REPAIRED IAW EO COO-9-53-039-13, UNDER THE W/O A1B089, SUBJOB 1, ITEM 91.SDR SWAA2013032614132Frame · corrodedSHEAR TIE CORRODED AT BS 767, BETWEEN STR 27L AND STR 26R. REMOVED AND REPLACED FRAME IAW SRM.SDR SWAA2013032614152Frame · corrodedSHEAR TIE CORRODED BS 767, BETWEEN STR 26L AND STR 27L LBL 10. REMOVED AND REPLACED FRAME IAW SRM.SDR CALA2013031400158Frame · crackedFUSELAGE FRAME AT STA 907 BETWEEN STR 8L AND 9L SHOWS CRACK INDICATION AT INNER FASTENER OF AIR CONDITION OUTLET SUPPORT ATTACHMENT BRACKET. REPAIRED IAW ECRA 5310-05696.SDR CALA2013031400157Frame · crackedFUSELAGE FRAME AT STA 500C BETWEEN STR 8R AND 9R SHOWS CRACK INDICATION AT INNER FASTENER OF AIR CONDITION OUTLET SUPPORT ATTACHMENT BRACKET. REPAIRED IAW ECRA 5310-05697.SDR CALA2013031400156Frame · crackedSUPPORT TASK FUSELAGE FRAME AT STA 500A BETWEEN STR 8R AND 9R SHOWS CRACK INDICATION AT INNER FASTENER OF AIR CONDITION OUTLET SUPPORT ATTACHMENT BRACKET. FRAME REPAIRED IAW ECRA 5310-05697 ACCOMP A.SDR CALA2013031400155Frame · crackedSUPPORT TASK FUSELAGE FRAME AT BS 400 BETWEEN STR 8 - 9R SHOWS CRACK INDICATION AT INNER FASTENER OF AIR CONDITION OUTLET SUPPORT ATTACHMENT BRACKET NOTED REF STEP 4 OF EA 5310-047 16, REV D, OP 1 REPAIRED IAW ECRA 5310-05697 ACCOMP A.SDR CALA2013031400154Frame · crackedFUSELAGE FRAME AT BS 907 BETWEEN S8-9R SHOWS CRACK INDICATION AT INNER FASTENER OF AIR CONDITION OUTLET SUPPORT ATTACHMENT BRACKET NOTED REF STEP 4 OF EA 5310-04716, REV D, OP 1, FRAME 907R HAS BEEN REPAIRED IAW ECRA 5310-05696 ACCOMP A PERMANENT REPAIR PRIOR SDR C77A20130313001Frame · crackedDAMAGE WAS SUSTAINED TO FUSELAGE FRAME 27 AND STR 22 - 25R AT REAR OF FWD CARGO DOOR CUTOUT AREA. REPLACED FUSELAGE FRAME, TRIMMED THE DAMAGE FROM THE INTERNAL BONDED DOUBLER, AND INSTALLED REPAIR DOUBLERS IAW STANDARD SRM IAW ETD ETD2013-170-002854-A AND ETSDR UIEA2013031000122Frame · gougedFRAME CRACKED AND GOUGED ON THE LT FRAME IN APU BAY AT BS 2664, WL 305. REPAIRED IAW NR T2013A53B-431, REV 00 AND REV 01.SDR CALA2013031300150Frame · crackedDURING THE ACCOMPLISHMENT OF EA 5310-04716, REV D, CRACK WAS FOUND IN THE INBD TRANSITION RADIUS OF FRAME BETWEEN STRINGER 8 & 9L AT BS 827. PERFORMED INTERM REPAIR IAW PART 1 OF ECRA.SDR CALA2013031400152Frame · crackedDURING ACCOMPLISHMENT OF EA 5310-04716, REV D, CRACK WAS FOUND IN THE INBD TRANSITION RADIUS OF FRAME BETWEEN STRINGER 8 & 9 AT BS 727 RT SIDE. PERFORMED INTERM REPAIR IAW PART 1 OF ECRA.
Back to JASC 5311