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 CALA2013052300338Frame · crackedFRAME BS 480 BETWEEN S8-9R CRACKED AT INBD FASTENER OF AIR CONDITIONING OUTLET EXTRUSION BRACKET. CRACK NOTED DURING VISUAL AND MFEC INSP REF EA 5310-04716 REV E AND NDT 6-53-30-00 PROCEDURE 7, REPAIRED IAW ECRA 5310-05747.SDR CALA2013052300337Frame · crackedFRAME BS 400 BETWEEN S8-9R CRACKED AT INBD FASTENER OF AIR CONDITIONING OUTLET EXTRUSION BRACKET. CRACK NOTED DURING VISUAL AND MFEC INSP, REF EA 5310-04716 REV E AND NDT 6-53-30-00. PROCEDURE 7, REPAIRED IAW ECRA 5310-05747.SDR CALA2013052300336Frame · crackedFRAME BS 400, BETWEEN S8-9L CRACKED AT INBD FASTENER OF AIR CONDITIONING OUTLET BRACKET CRACK NOTED DURING VISUAL AND MFEC REF EA 5310-04716, REV E AND NDT 6-53-30-00, PROCEDURE 7. REPAIRED IAW ECRA 5310-05747.SDR CALA2013052300335Frame · crackedFRAME AT BS 380 BETWEEN STR 8 - 9 R CRACKED AT INBD FASTENER OF AIR CONDITIONING OUTLET EXTRUSION BRACKET. CRACKED NOTED DURING VISUAL AND MFEC REF EA 5310-04716, REV E AND NDT 6-53-30- 00 PROCEDURE 7 . REPAIRED IAW ECRA 5310-05747.SDR CALA2013052300340Frame · crackedFRAME CRACKED BS 400 BETWEEN S8-9L. REPAIRED FRAME IAW EA5310-04716, REV E.SDR SWAA2013060616861Frame · crackedLEFT FRAME WEB CRACKED AT STA 1178. REPAIRED WEB IAW SRM.SDR SWAA2013060516794Former · crackedFORMER CRACKED AT BS 1022, LONG 14R. REPAIRED FORMER IAW SRM AND DWG.SDR WX0A071591Frame · crackedLEFT FUSELAGE AT STATION 1474 CANT FRAME CRACKED. REPAIRED LEFT FUSELAGE AT STATION 1474 CANT FRAME.SDR FDEA201305221067Frame · damagedCENTER FUSELAGE FRAME 46 RT SIDE HOLE H25 AND H27: IN THE FRAME FOOT, FRAME REINFORCING, FRAME HOLE DIMENSION AT 9.92MM PRESENT NO CRACK INDICATION, STRAP AT 7.26MM PRESENT, NO CRACK INDICATION. COMPLIED WITH EA6-5310-168229.SDR FDEA201305221066Frame · damagedCENTER FUSELAGE FRAME 45, RT SIDE HOLE H22: IN THE FRAME FOOT AND FRAME DOUBLER HOLE DIMENSION AT 14MM WITH NO CRACK INDICATION, IN THE FRAME HOLE DIMENSION AT 9.92 WITH NO CRACK INDICATION. COMPLIED WITH EA6-5310-168229.SDR FDEA201305221065Frame · damagedCENTER FUSELAGE FRAME 45, LT HOLE H15: IN THE FRAME FOOT, FRAME DOUBLER, FRAME AND BRACKET FR45 HOLE DIMENSION AT 9.92 MM WITH NO CRACK INDICATION; HOLE H22: IN THE FRAME FOOT, FRAME DOUBLER AND FRAME HOLE DIMENSION AT 9.92MM WITH NO CRACK INDICATION; HOLESDR FDEA201305221064Frame · damagedCENTER FUSELAGE FRAME 44 RT HOLE H12 AND H13 DIMENSION AT 8.73MM PRESENT NO CRACK INDICATION, HOLE H10 DIMENSION AT 6.76MM PRESENT NO CRACK INDICATION, HOLE H11 DIMENSION AT 7.52MM PRESENT NO CRACK INDICATION. COMPLIED WITH EA6-5310-168229.SDR FDEA201305221063Frame · crackedCENTER FUSELAE FRAME 44 LT SIDE HOLE H5 WITH NO CRACK INDICATION & HOLE DIMENSION IS 19MM, AND FRAME 44 LT SIDE HOLE H13 WITH SHORT EDGE DISTANCE, HOLE H13 EDGE DISTANCE IS 11.17 MM LESS THAN 12 MM REQUIRED IN THE SB53-2124. COMPLIED WITH EA 6-5310-168229SDR CALA2013052300333Frame · crackedFRAME CRACKED BS 440 BETWEEN S8-9L. CUT OUT DAMAGE AREA AND INSTALLED REPAIR ANGLE A AND B REF EA 5 310-04716, REV E.SDR CALA2013052300332Frame · crackedCABIN FRAME 400 CRACK AT SUPPORT FITTING BETWEEN STR 8 AND 9 RT. CUT OUT DAMAGE AREA AND INSTALLED REPAIR ANGLE A AND B, REF EA 5 310-04716, REV E.SDR AALA20130522023Frame · crackedCABIN FRAME CRACKED AT BODY STATION 400, STRINGER 8 RT, AIR CONDITIONING RAIL SUPPORT BRACKET FASTNER HOLE. ACCOMPLISHED NESTED ANGLE REPAIR IAW J1159-0009.SDR AALA20130522022Frame · crackedCABIN FRAME CRACKED AT BODY STATION 380, STRINGER 8 LT, AIR CONDITIONING RAIL SUPPORT BRACKET FASTNER HOLE. ACCOMPLISHED NESTED ANGLE REPAIR IAW J1159-0008.SDR AALA20130522021Frame · crackedCABINE FRAME CRACKED AT BODY STATION 440, STRINGER 8 LT, AIR CONDITIONING RAIL SUPPORT BRACKET FASTNER HOLE. ACCOMPLISHED NESTED ANGLE REPAIR IAW J1159-0008.SDR AALA20130522019Frame · crackedCABIN FRAME CRACKED AT BODY STATION 480, STRINGER 8 LT, AIR CONDITIONING SUPPORT BRACKET FASTENER HOLE. ACCOMPLISHED NESTED ANGLE REPAIR IAW J1159-0008.SDR AALA20130522017Frame · crackedCABIN FRAME CRACKED AT BODY STATION 440 AND STRINGER 8 RT, AIR CONDITIONING RAIL SUPPORT BRACKET FASTNER HOLE. ACCOMPLISHED NESTED ANGLE REPAIR IAW ECO J1159-0009.SDR SIMA20130521011Frame · crackedDVI FWD FUSELAGE FRAME 8 LOWER AVIONIC DOOR OPENING CRACKED. PERFORM DVI FWD FUSELAGE FRAME 8 LOWER AVIONIC DOOR IAW EO EM-53MR-2092, PART B ONLY NO FUTHER DAMAGE NOTED CONTINUED ON TDMI63253083F.SDR SWAA2013061917374Frame · crackedFRAME OTBD CHORD CRACKED AT BS 727, STR 18A RT. REPAIRED CHORD IAW ER AND EA.SDR SWAA2013061817329Frame · crackedFRAME OTBD CHORD FWD FLANGE CRACKED AT BS 727, STR 18A LT. REPAIRED CHORD IAW ER & EA.SDR SWAA2013061817274Frame · crackedLEFT MAIN WHEEL WELL FRAME FWD FLANGE CRACKED AT STA 727, STR 18A. REPAIRED CHORD IAW SWA EA.SDR SWAA2013061817245Frame · crackedRIGHT MAIN WW FRAME FWD FLANGE FWD LOWER CHORD CRACKED AT STA 727. STRINGER 18A. REPAIRED CHORD IAW SWA EA.SDR USAA2013061300034Frame · crackedQ4 CHECK - CRACK ON FUSELAGE FRAME AT BS 727D BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 727D BETWEEN S8L TO S9L IAW TYPICAL REPAIR TR737-5310-10-0827.SDR WX0A071590Frame · crackedAFT FUSELAGE CANTED FRAME AT STATION 1463 UPPER LEFT SIDE WEB CRACKED. REPAIRED CANTED FRAME WEB.SDR DALA1313533751Frame · crackedPASS CABIN FRAME STA 727B AT STRINGER 8L CRACKED AT INBD HOLE OF STOW BIN RAIL ATTACH CLIP. REPAIRED IAW ERA 513594-14AD.SDR DALA1313523751Frame · crackedPASSENGER CABIN FRAME BS 500A AT STRINGER 8L CRACKED AT INBD HOLE OF STOW BIN RAIL ATTACH CLIP. REPAIRED IAW ERA 513594-14AD.SDR DALA1313503751Frame · crackedPASSENGER CABIN FRAME STA 440 AT STRINGER 8L CRACKED AT INBD HOLE OF STOW BIN RAIL ATTACH CLIP. REPAIRED IAW 513594-14AD. NR 1916365SDR DALA1313493751Frame · crackedPASSENGER CABIN FRAME AT BS 380, STRINGER 8R, CRACKED AT INBD HOLE OF STOW BIN RAIL ATTACH CLIP. REPAIRED IAW ERA 513594-14AD.SDR DALA1313483751Frame · crackedPASSENGER CABIN FRAME BS 380 AT STRINGER 8L CRACKED AT INBD HOLE OF STOW BIN RAIL ATTACH CLIP. REPAIRED IAW ERA 513594-14AD.SDR DALA1313463751Frame · crackedPASSENGER CABIN FRAME, BS 480 AT STR 8L CRACKED AT INBD HOLE OF STOW BIN RAIL ATTACH CLIP. REPAIRED FRAME IAW ERA 513594-14AD.SDR DALA13023640127Frame · corrodedBS 977 FRAME WEB AT S21-22R CORRODED. FRAME WEB REPAIRED IAW PRI 514000-14, REV ORIGINAL, 1, 2, 3 AND 4.SDR CALA2013052100318Frame · crackedCABIN FRAME AT BS 440, CRACKED AT SUPPORT FITTING BETWEEN S8-9 RT. INSTALLED REPAIR ANGLES IAW EA 5310-04716, REV E, OP2.SDR CALA2013052100317Frame · crackedCABIN FRAME BS 380 CRACK AT SUPPORT FITTING BETWEEN S8-9 RT. INSTALLED REPAIR ANGLES A & B AT BS 380R, IAW EA 5310-04716 REV E, OP 2.SDR CALA2013052100316Frame · crackedFRAME CRACKED BS 480 BETWEEN S8-9L. ACCOMPLISHED FRAME REPAIR IAW EA 5310-04716, REV E.SDR CALA2013052100315Frame · crackedCABIN FRAME IS CRACKED AT BS 727D, RT BETWEEN STR 8 AND 9 RT INSTALLED REPAIR REF. STEPS 1-13 OF EA 5310-04716, REV E.SDR DALA1315910683Frame · dentedDENT LOCATED ON THE INNER FLANGE OF FUSELAGE FRAME, BS 1280 ABOVE STR 26L WAS NOT IDENTIFIED DURING INITIAL INSPECTION. PERMANENT REPAIR INSTALLED IAW ERA 515763-14, REV ORIG AT SAT HMV VISIT ON NR 100-296.SDR USAA2013061300035Frame · crackedQ4 CHECK - CRACK ON FUSELAGE FRAME AT BS787 BETWEEN S8L TO S9L. REPAIRED FUSELAGE FRAME AT BS 787 BETWEEN S8L TO S9L IAW TYPICAL REPAIR TR 737-5310-10-0287.SDR IPXA13578598Frame · dentedINSPECTION TYPE:C-16, FWD CARGO COMPARTMENT BS 700 AT STR 24R FRAME IS DENTED ON UPPER FLANGE. FABRICATED AND INSTALLED REPAIR IAW SRM 53-30-07-2R-1 AND 0 53-00-07-2R-5, DETAIL III.SDR DALA1313473751Frame · crackedPASSENGER CABIN FRAME AT STA 480, STRINGER 8R, CRACKED AT INBD HOLE OF STOW BIN RAIL ATTACH CLIP. REPAIRED IAW ERA 513594-14AD.SDR DALA13023490124Frame · crackedDURING HFEC INSPECTION ON BS 1809, BULKHEAD LT FORWARD OUTER FRAME S6-7L FOUND CRACKED. REPAIRED FRAME.SDR FDEA201305201049Frame · chafedBS 1280, FRAME FOUND CHAFED JUST BETWEEN S10-14L. REMOVED DAMAGE IAW SRM 51-10-02, REV 109 AND FOUND EXCEED 10 PERCENT LIMIT IAW SRM 53-00-07. ALLOWABLE DAMAGE 2, FIG 101, REV 109. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 3, REV 109. REPAIR CLASSIFIED SDR DALA13027050126Floorbeam · corrodedFWD CARGO BAY BS 654 + 44, LBL 20 -44 FLOORBEAM UPPER & LWR SURFACE FOUND CORROSION. FWD CARGO STA654+44 CARGO FLOORBEAM REPLACED AND INSTALLED IAW SRM 51-10-02, 51-40-02, 51-40-05.SDR SWAA2013052816525Former · crackedFORMER CRACKED AT BS 1144, LONG 2R. R & R FORMER IAW SRM & DWG.SDR FDEA201305191022Frame · corrodedBS 1280 FRAME FOUND CORROSION JUST BETWEEN STR 15L-16L.SDR FDEA201305191021Frame · chafedBS 395, FRAME INBD EDGE FOUND CHAFED BETWEEN STR 15-16R. DAMAGE REMOVED IAW SRM 51-10-02, REV 109, FOUND WITHIN LIMITS OF SRM 53-00-07 ALLOWABLE DAMAGE 2, FIG 101, REV 109. REPAIR IS MINOR.SDR FDEA201305191020Frame · corrodedMAIN DECK BS 1100 STR 16-17L FRAME WEB INBD EDGE CORROSION. REPAIRED IAW EA F-5310-168326. MINOR REPAIR.SDR FDEA201305191019Frame · corrodedMAIN DECK BS 1160, FRAME WEB INBD EDGE CORROSION BETWEEN S16-17R. FRAME REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 4, REV 109. REPAIR IS CAT B, MAJOR.
Back to JASC 5311