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 SWAA097446Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA097445Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 360, STR 8R. REPAIRED FRAME PER EA.SDR FDEA200911244144Frame · corrodedFWD CARGO BS 840 STR 26R TO 26L FRAME CORRODED. CORRODED STANCHION STUB BEAM (FRAME) AT BS 840 REMOVED AND REPLACED IAW SRM 51-40-02 REV. 98. REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911244137Frame · chafedCABIN - LT STA 1741 BETWEEN LONGERON 11 LT AND LONGERON 12 LT FOUND CHAFED. REPAIRED IAW SRM 53-00-07, FIGURE 201, REPAIR 2, REVISION 42. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9,500 CYCLES TO BE CARRIED OUT AS IAW SRM 5SDR AALA20091123TUL04Frame · crackedFRAME 1418 CRACKED AT LONGERON 2 LEFT FORWARD AND AFT SIDES. INSTALLED REPAIR DOUBLERS ON FORWARD AND AFT SIDES OF FRAME 1418 AT LONGERON 2 LEFT PER EA NR MD80-53-008197.SDR AALA20091123TUL03Frame · crackedFRAME 1418 CRACKED AT LONGERON 2 LEFT FORWARD AND AFT SIDES. INSTALLED REPAIR DOUBLERS ON FORWARD AND AFT SIDES OF FRAME 1418 AT LONGERON 2 LEFT PER EA NR MD80-53-008197.SDR GLBA20091124GFrame · crackedDURING ROUTINE SCHEDULED MX, A CRACK ON FRAME AT STR 9R AND FS 163.975 WAS FOUND AT THE RELIEF CUTOUT. CRACK LENGTH APPROX .375 ". MAINTENANCE REPLACED THE RIGHT HAND HEAVY ANGLE/CLOSING ANGLE AT F.S. 303.25 AND PERFORMED THE REQUIRED RII INSPECTIONS I.A.SDR USAA2009120293282Frame · corrodedCLT - Q3 - MAJOR REPAIR - LEVEL 2 EXFOLIATION CORROSION ON FORWARD & AFT SIDES OF FUSELAGE FRAME LEG AT BS 807, BL 0 TO LBL 6. REPAIRED FUSELAGE FRAME LEG AT BS 807, BL 0 TO LBL 6 IAW B737 SRM 53-00-07 REPAIR 4 & 53-00-10 REPAIR 19.SDR SWAA097411Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 16L. REPAIRED FRAME PER ACO.SDR SWAA097408Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 303.9, STR 15L. REPAIRED FRAME PER ER.SDR SWAA097403Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 19R TO STR 20R. REPAIRED FRAME PER ER.SDR SWAA097401Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 500D, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER EO.SDR SWAA097400Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 520, BETWEEN STR 20R TO STR 21R. REPAIRED FRAME PER EO.SDR SWAA097399Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 360, BETWEEN STR 19R TO STR 20R. REPAIRED FRAME PER EO.SDR SWAA097395Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 344, BETWEEN STR 22L TO STR 23L. REPAIRED FRAME PER EO.SDR SWAA097393Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER SRM.SDR SWAA097392Frame · crackedDURING SCHEDULED MV2 CHECK, FOUND FRAME CRACKED AT BS 400, STR 16R. REPAIRED FRAME PER SRM.SDR FDEA200911234134Frame · corrodedAFT CARGO COMPARTMENT FRAME CORRODED AT STA 1560 LBL 20" BELOW TIE DOWN FITTING. CORRODED FRAME AT STA 1560 REPAIRED IAW SRM 53-00-07, REPAIR 5, DETAIL I, FIG 201, REV 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRTERIA.SDR FDEA200911234133Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED AT STA 1560, AT S-26R DENTED FRAME AT STA 1560 REPAIRED IAW SRM 53-00-07 REPAIR 5, FIG 201, DETAIL II, REV. 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR FDEA200911234132Frame · corrodedAFT CARGO BS 1400 STR 27L FRAME CORRODED. CORRODED FRAME AT STA 1400 REMOVED AND REPLACED IAW SRM 51-40-02 REV 98. REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100.SDR FDEA200911234131Frame · corrodedAFT CARGO COMPARTMENT FRAME AT STA 1460, RBL 24 CORRODED. CORRODED FRAME AT STA 1460 REPAIRED IAW EA F-5310-133447 (MAIN FRAME - LWR FAILSAFE CHORD CORROSION REPAIR). REPAIR IS CLASSIFIED AS MINOR IAW GMM 6-2-100 CRITERIA.SDR FDEA200911234130Frame · dentedAFT CARGO COMPARTMENT FRAME DENTED AT STA 1480, BETWEEN S-25L AND S-26L. DENTED FRAME AT STA 1480 REPAIRED IAW EA F-5310-133429 (FRAME DENT REPAIR IN THE AFT CARGO BS 1480 BETWEEN S 25L-S 26L). REPAIR IS CLASSIFIED AS MAJOR IAW GMM 6-2-100 CRITERIA.SDR SIMA200932710Frame · corrodedDURING MAINTENANCE BASE INSPECTION FOUND THE LEFT FRAME 280 TO BE CORRODED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED THE LEFT FRAME 280 BULKHEAD IAW EO CR-53MR-174. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR FDEA200911234119Frame · crackedMAIN CABIN FOUND CRACK ON FRAME. REPAIRED AREA IAW SRM 53-30-00 FIG 5 VOL I.SDR FDEA200911234118Frame · crackedMAIN CABIN FOUND CRACK ON FRAME. REPAIRED AREA IAW SRM 53-30-00 FIG 5 VOL I.SDR SWAA097374Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8L. REPAIRED FRAME PER EA.SDR C2XA09SH450Frame · corrodedSHV - DURING C-CHECK, FR 65 HAS CORROSION BETWEEN STR 16L-17L. REPAIRED FR 65 IAW EC 5320-01501. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR USAA2009112393193Frame · crackedCLT - Q3 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500E BETWEEN S20L TO S21L IAW B737 SRM 53-00-07 REPAIR 13.SDR AALA20091120TUL11Frame · corrodedCORROSION ON FRAME 1287, LONGERON 29 RIGHT TO LONG 29 LEFT. INSTALLED FORMER REPAIR SPLICE PER SRM 53-03-00.SDR FDEA200911204094Frame · damagedMAIN DECK BS 820, S2L, AFTER REMOVAL OF TV MONITOR, DOUBLERS FOUND DOUBLE DRILLED HOLES. CUTOUT DAMAGED FRAME AT BS 820, S5L-S5R IAW SRM 53-00-07, FIG. 201, REPAIR NR 1. REMOVED 2 EA ACFT BRACKETS, LAV BRACKET, ELEV BRACKET FOR FOM IAW SRM 51-40-02. FABRSDR SWIA200923731Frame · crackedFS 559 FRAME CAP ANGLE CRACKED. (C CHECK) REPAIRED PER REO.SDR USAA2009122893436Frame · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 727B BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 727B BETWEEN S8L TO S9L IAW TYPICAL REPAIR 53-10-20E.SDR USAA2009122293405Frame · crackedSAL - Q4 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 907 BETWEEN S8R TO S9R. REPLACED FUSELAGE FRAME AT BS 907 BETWEEN S8R TO S9R IAW TYPICAL REPAIR 53-10-20E.SDR CNQ8918CASpar · damagedDURING INSP, FOUND SEVERAL HOLES DRILLED IN THE FD WING CARRY-THRU SPAR. HOLES APPEAR TO HAVE BEEN DRILLED DURING AN INTERIOR INSTALLATION. MFG HAS DEEMED THE SPAR UNREPAIRABLE AND MUST BE REPLACED.SDR USAA2009113093262Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK ON FUSELAGE FRAME AT BS 727, S14L. REPAIRED FUSELAGE FRAME AT BS 727, S14L IAW EA 101527.SDR USAA2009112593229Frame · crackedCLT - Q1 - MAJOR REPAIR - CRACK IN FUSELAGE FRAME AT BS 616, LBL 50. REPAIRED FUSELAGE FRAME AT BS 616, LBL 50 IAW TYPICAL REPAIR 53-62-01.SDR ASAA0977036Frame · crackedFRAME STR 8 RT BS 400 IS CRACKED AT BIN RAIL TO FRAME ATTACHED POINT. TRIMMED OUT DAMAGE AND INSTALLED REPAIR ANGLES.SDR ASAA0977035Frame · crackedFRAME STR 8 RT BS 480 IS CRACKED AT BIN ATTACHED POINT. TRIMMED OUT DAMAGE AND INSTALLED REPAIR ANGLES.SDR ASAA0977034Frame · crackedFRAME STR 8 RT BS 380 IS CRACKED AT BIN ATTACHED POINT. TRIMMED OUT DAMAGE AND INSTALLED REPAIR ANGLES.SDR ASAA0977033Frame · crackedFRAME IS CRACKED AT FRAME TO BIN ATTACH POINT. TRIMMED OUT DAMAGE AND INSTALLED REPAIR ANGLES.SDR ASAA0977032Frame · crackedFRAME IS CRACKED AT FRAME TO BIN ATTACH POINT. TRIMMED OUT DAMAGE AND INSTALLED REPAIR ANGLES.SDR FDEA200911184018Frame · dentedMAIN DECK UPPER SIDEWALL FRAME AT LT STA 1621, 13L FOUND DENTED. MAIN DECK DENTED FRAME AT LT STA 1621 13L REPAIRED IAW SRM 53-00-07 FIG. 201. REPAIR 2 REV 42. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9.500 CYCLES TO BE CASDR FDEA200911184017Frame · dentedMAIN DECK UPPER SIDEWALL FRAME AT LT STA 1741, 13L FOUND DENTED. MAIN DECK DENTED FRAME AT LT STA 1741 13L REPAIRED IAW SRM 53-00-07 FIG 201, REPAIR 2 REV 42. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9.500 CYCLES TO BE CARRSDR FDEA200911184016Frame · dentedMAIN DECK UPPER SIDEWALL FRAME AT LT STA 1761, 13L FOUND DENTED. REPAIRED IAW SRM 53-00-07 FIG 201 REPAIR 2 REV 42. REPETITIVE INSP REQUIRED, INITIAL AT 14,500 CYCLES AND REPETITIVE INSP AT 9.500 CYCLES TO BE CARRIED OUT IAW SRM 53-00-07 FIG 201 REPAIR 2, SDR FDEA200911184013Frame · damagedMAIN DECK STA 800 L/BL8 (APPROX) AFTER REMOVAL OF TV MONITOR DOUBLERS FOUND WITH DOUBLE DRILLED HOLES. CUT OUT DAMAGED FRAME AT STA 800 STR 5L TO 5R IAW SRM 53-00-07 FIG 2014 R1,REMOVED 2 EA. ACFT BRACKET 1 EA LAV BRACKET 1 EA ELEV BRACKET FOR FOM IAW SRM 51-SDR SWAA097332Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20L TO STR 21L. REPAIRED FRAME PER SRM AND ER.SDR SWAA097331Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20L TO STR 21L. REPAIRED FRAME PER SRM AND ER.SDR SWAA097330Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500B, STR 20R TO STR 21R. REPAIRED FRAME PER SRM AND ER.SDR SWAA097308Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 500C, STR 20R TO STR 21R. REPAIRED FRAME PER SRM & EA.SDR SWAA097307Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FUSELAGE FRAME CRACKED AT BS 380, STR 16R. REPAIRED FRAME PER ACO.
Back to JASC 5311