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 CALA2012043000312Frame · crackedSUPPORT TASK, PERFORMED MFEC IAW EA 5310-04716, REV C. CRACK INDICATION NOTED AT STA 747 RIGHT, ACCOMPLISHED PERMANENT REPAIR IAW EA 5310-04716.SDR CALA2012043000311Frame · crackedSUPPORT TASK PERFORMED MFEC IAW EA 5310-04716, REV C CRACK INDICATION NOTED AT STA 480. RT REPAIRED FRAME AT STA 480 RT IAW EA 5310-04716, REV C. SEE ATTACHED FORMS 44.0008 FOR WORK PERFORMED.SDR CALA2012043000310Frame · crackedSUPPORT TASK. PERFORMED MFEC IAW EA 5310-04716, REV C. CRACK INDICATION NOTED AT STATION 727D RT REMOVED CRACK AND REPAIR FRAME AT STA 727D RT IAW 5310-04716, REV C AND IAW SRM 51-40-02 REINSTALL BRACKET IAW SRM 51-40-02. SEE ATTACHED FOR 44.0008 FOR ALL WORSDR CALA2012043000309Frame · crackedSUPPORT TASK MFEC INSP SHOWS CRACK INDICATION AT STA 500C LT FRAME. REPAIRED FRAME AT STA 500C LT IAW EA 5310-04176, REV C. SEE ATTACHED FORM 44.0008 FOR WORK PERFORMED.SDR CALA2012043000308Frame · crackedSUPPORT TASK PERFORMED HFEC IAW EA 5310-04716, REV C, CRACK INDICATION NOTED AT STA 440R. REPAIRED FRAME AT STA 440 R IAW EA 5310-04716, REV C. SEE ATTACHED FORM 44.0008 FOR WORK PERFORMED.SDR CALA2012043000307Frame · crackedSUPPORT TASK, PERFORMED MFEC FOUND CRACK AT STA 380R FRAME. REPAIRED FRAME AT STA 380 R IAW ECRA 5310-04716, REV C, SEE 44.0 008 FOR WORK PERFORMED.SDR AALA20120429005Frame · corrodedAFT CARGO FRAME AND SHEAR TIE AT STATION 1460 LEFT BUTTLINE 3 CORRODED. INSTALLED DOUBLER PER EA B757-53-023400.SDR EE4Y2012060500237Frame · crackedLOWER FUSELAGE FR 34 STR 31LT SUPPORT FRAME CRACKED. SUPPORT FRAME REPLACED IAW SRM 51-72-11.SDR USAA2012050800021Frame · crackedFPBH VISIT - CRACK ON FRAME INNER CHORD AT BS 616 BELOW S17L, WL 200. REPAIRED FRAME INNER CHORD AT BS 616 BELOW S17L, WL 200 IAW TYPICAL REPAIR 737-5362-10-0023.SDR USAA2012050800020Frame · crackedFPBH VISIT - CRACK ON FRAME INNER CHORD AT BS 601 BELOW S17L, WL 200, LBBL 60. REPAIRED FRAME INNER CHORD AT BS 601 BELOW S17L, WL 200, LBBL 60 IAW TYPICAL REPAIR TR737-5362-11-0448.SDR USAA2012050800017Frame · crackedFPBH VISIT - CRACK ON FRAME INNER CHORD AT BS 601 BELOW S17R, WL 200. REPAIRED FRAME INNER CHORD AT BS 601 BELOW S17R, WL 200 IAW B737 TYPICAL REPAIR TR737-5362-11-0448.SDR DALA1228056818Frame · corrodedFRAME AT BS 1560 ABOVE S26L IS CORRODED AT FASTENER HOLE. REMOVED FORMER REPLACED FRAME PER DWG 453N1801.SDR CALA2012043000305Frame · crackedSUPPORT TASK - PERFORMED MFEC PER EA 5310-04713 REV C. CRACK INDICATION NOTED AT STATION 827R PERFORMED REPAIR PER EA 5310-04716 REV C.SDR CALA2012043000304Frame · crackedSUPPORT TASK LEFT SIDE FRAME AT STATION 867 CRACKED. PERFORMED REPAIR PER EA 5310-04716 REV C.SDR CALA2012043000303Frame · crackedSUPPORT TASK MFEC INSP SHOWS CRACK INDICATION AT STA 827 LT FRAME. REPAIRED IAW EA 5310-04716 REV C OP 1.SDR DALA1232476306Frame · crackedDURING INSPECTION, FOUND CRACK AT RIGHT BS 800 FRAME AT STRINGER 17. REPAIRED PER ERA 502637-14AD.SDR DALA1232496306Frame · crackedDURING INSPECTION, FOUND CRACK AT RIGHT BS 800 FRAME AT STRINGER 17. REPAIRED PER ERA 502637-14AD.SDR DALA1227141708Failsafe · crackedLEFT FAIL SAFE CORD CRACK INDICATED IN LOWER BOLT HOLE LT FS 955. REPAIRED PER ERA 502507-14AD REV ORIG. ETOPS CATEGORY 'E': PROBLEMS WITH SYSTEMS CRITICAL TO ETOPSSDR AALA20120427011Frame · crackedTHE 1510 CANT FRAME CRACKED BELOW MAINTENANCE LIGHT SWITCH. INSTALLED DOUBLER PER EA MD80-53-023404.SDR SIMA20120426013Frame · crackedFRAME 23 CRACKED AT RT OTBD FLOOR SUPPORT. REPAIRED IAW EO EM-53MR-1808.SDR UALA2012042602506Frame · corrodedAFT CARGO PIT, FRAME AT BS 1241 AND STR 34R, INNER CHORD CORRODED. REMOVED CORROSION & FOUND MATERIAL LOSS OUT OF SRM LIMITS. REMOVED EXISTING TEE. FABRICATED & INSTALLED NEW TEE. MAJOR REPAIR.SDR FDEA201204261596Frame · misrepairedFRAME AT STA 535, LONGERON 24 RT MISREPAIRED. CARRIED OUT REPAIR IAW SRM 53-20-07, FIG 201. REPAIR 1, REV 49 EO 1-5100-7-5001B PART 1. REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 114.SDR FDEA201204261595Frame · misrepairedFRAME AT STA 535, LONGERON 24 LEFT MISREPAIRED. CARRIED OUT REPAIR IAW EA 1-5310-157190 . REPAIR CLASSIFIED MAJOR IAW GMM 6-2-100, REV 114.SDR UHLA2012042600156Frame · damagedMAJOR REPAIR - FR4 LOWER DAMAGED. REMOVED AND REPLACED FR4 LOWER IAW EMB 170 SRM 51-41-02 AND ETD 2012-170-006137.SDR AALA20120426024Frame · crackedFRAME 500C RIGHT IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD FASTENER. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120426023Frame · crackedFRAME 480 RIGHT IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD FASTENER. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120426022Frame · crackedFRAME 440R IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD FASTENER. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120426021Frame · crackedFRAME 400 LEFT IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD ATTACH FASTENER. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120426020Frame · crackedFRAME 887 LEFT IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD ATTACH FASTENER. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120426019Frame · crackedFRAME 727B LEFT IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD ATTACH FASTENER. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120426018Frame · crackedFRAME 500A LEFT IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD ATTACH FASTENER. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120426017Frame · crackedFRAME 500A LEFT IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD ATTACH FASTENER. INSTALLED DOUBLER PER ECO J11569AD.SDR AALA20120426016Frame · crackedFRAME 480L IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD ATTACH FASTENER. INSTALLED DOUBLER PER ECO J1159AD.SDR AALA20120426015Frame · crackedFRAME 400 RIGHT IS CRACKED AT AIR CONDITIONING RAIL BRACKET INBOARD FASTENER. INSTALLED DOUBLER PER ECO J1159AD.SDR FXGA201204251229Frame · gougedFWD CARGO DOOR FRAME WEB REPAIR AT FS 435, GOUGE APPROXIMATELY 2 INCHES ABOVE LONGERON L15 AT FS 435. REMOVE DAMAGE & FABRICATE FILLER FROM MATERIAL SAME AS PARENT 7075-T6 0.071INCHES. FABRICATE DOUBLER FROM 7075-T6 0.80 INCHES TO EXTEND A MINIMUM OF 6 FASTESDR SWAA2012051604045Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012051604044Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012051504007Frame · corrodedFRAME CORRODED BS 787, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR DALA1230620980Frame · corrodedCORROSION IN THE FRAME STA 1271 ATTACH HOLES L30 BILGE AREA OF AFT CARGO COMPARTMENT. REMOVED CORROSION, FOUND OUT OF LIMITS. FABRICATED AND INSTALLED NEW UPPER AND LOWER SPLICES, FILLER ON BS 1271 BETWEEN L29R AND R22R IAW SRM 53-03D PG 16 FIG 2A.SDR UALA2012042502495Frame · corrodedAFT CARGO PIT, FRAME INNER CHORD CORRODED AT BS 1197+88 AND S34L. REMOVED DAMAGE AND FOUND MATERIAL LOSS OUT OF SRM LIMITS. REMOVED DAMAGED UPPER TEE SECTION IN ENTIRETY. FABRICATED AND INSTALLED NEW UPPER TEE REF SRM51-40-02.SDR SWAA2012042703482Frame · corrodedFRAME CORRODED AT BS 927, BETWEEN STR 30R TO STR 29R. REPAIRED FRAME PER SRM.SDR SWAA2012042703476Frame · corrodedFRAME CORRODED AT BS 954, RBL 2. REPAIRED FRAME PER SRM.SDR SWAA2012042703474Frame · corrodedFRAME CORRODED AT BS 927, BETWEEN STR 29L TO STR 29R. REPAIRED FRAME PER SRM.SDR SWAA2012042703471Frame · corrodedFRAME CORRODED AT BS 908, BETWEEN STR 29L TO STR 29R. REPAIRED FRAME PER SRM.SDR GLBA2012042605Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE FRAME AT FS 150 AND STRINGER 9AL, AT NUTPLATE FOR A/S DOOR STRUT LWR MOUNT, .75" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 12-1900-53-028. MAJOR REPAIRSDR GLBA2012042604Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE FRAME AT FS 164 AND STRINGER 9AR AT CUTOUT, .35" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 12-1900-53-026. MAJOR REPAIR.SDR GLBA2012042603Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND TWO CRACKS IN THE FUSELAGE FRAME AT FS 509 AND AFT GAS STRUT MOUNT AREA FROM CENTER OF THE UPPER INBD GAS STRUT NUTPLACE SCREW HOLES. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS I.A.W. ESDR SWAA2012052104198Frame · crackedFRAME CRACKED AT BS 947.5, BETWEEN STR 24R TO STR 25R. REPAIRED FRAME IAW EA AND EO.SDR IPXA12M73629Frame · dentedINSPECTION TYPE: 4C, MAIN CABIN FRAME DENTED IN RADIUS AT BS 655 L12R. REPAIRED FRAME IAW EA 011-5310-01-A3872 AND EO MD11-5310-47213-A.SDR SWAA2012051604046Frame · corrodedFRAME CORRODED AT BS 727D, STR 27R. REPAIRED FRAME IAW SRM.
Back to JASC 5311