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 CALA2013090600630Frame · crackedMAIN CABIN LT FRAMES STATION 440L BETWEEN STRINGER 8 & 9 CRACK FOUND ON MFEC. REPAIR IAW EA 5310-04716 REV E OP 2 SEE FLEET CYCLE FOR ALL WORK PERFORMED.SDR FDEA201309052134Frame · corrodedAFTER REMOVING THE FLOORBEAM AT BS 1681, CORROSION WAS FOUND ON FRAME AT RBL 02, WL 208.10, BS 1681, RT SIDESDR ASAA2013090496007Frame · crackedRT FUSELAGE FRAME, BS 480 CRACKED ABOVE SHEAR WEB. R & R FRAME ASSY IAW SRM 51-40-05 AND 51-40-02.SDR CALA2013090600636Frame · crackedIAW AD2009-01-02, EA5310-04716 REV E. FRAME AT STATION 440L, BETWEEN STRINGER 8 & AMP; 9 INBD RIVET HOLE HAS A CRACK INDICATION. REPAIRED FRAME AT STATION 440L BETWEEN STRINGER 8 & AMP; 9 IAW EA5310-04716 R EV E. SEE WIPS & TASKS FOR ALL WORK PERFORMED.SDR CALA2013090600629Frame · crackedFUSELAGE FRAME IS CRACKED AT BS 480 BETWEEN STRINGER 8L & 9L REPAIRED FUSELAGE CRACK. REF: ECRA 5310-04716.SDR CALA2013090600628Frame · crackedMAIN CABIN AREA RT FRAME BS 380R BETWEEN STRINGER 8 & STRINGER 9, CRACK FOUND ON MFEC PROCEDURE. REPAIRED RT FRAME AT BS 380 BETWEEN S-8 & AMP; S-9 IAW EA 5310-04716 REV E.SDR CALA2013090600627Frame · crackedMAIN CABIN AREA RT FRAME BS 440R BETWEEN STRINGER 8 & STRINGER 9, CRACK FOUND ON MFEC PROCEDURE. REPAIRED BS 440R FRAME BETWEEN S-8 & AMP; S-9 IAW EA 5310-04716 REV E.SDR CALA2013090600626Frame · crackedREF AD 2009-01-02, EA 5310-04716 REV E FRAME AT STA 400L, BETWEEN STRINGERS 8 & 9, INBOARD RIVET HOLE HAS A CRACK INDICATION. REPAIRED STA 400L FRAME BETWEEN S-8 & S-9 IN ACCORDANCE WITH EA 5310-04716 REV E.SDR CALA2013090600625Frame · crackedREF AD 2009-01-02, EA 5310-04716 REV E FRAME AT BS 400R, BETWEEN STRINGERS 8 & AMP; 9, INBOARD RIVET HOLE HAS A CRACK INDICATION. REPAIRED BS 400R FRAME BETWEEN STRINGERS 8 & AMP; 9 IAW EA 5310-04716 REV E.SDR CALA2013090600624Frame · crackedREF AD 2009-01-02, EA 5310-04716 REV E FRAME AT BS 727D L, BETWEEN STRINGERS 8 & AMP; 9, INBOARD RIVET HOLE HAS A CRACK INDICATION. REPAIRED BS 727D L/H FRAME IAW EA 5310-04716 REV E.SDR CALA2013090600623Frame · crackedREF AD 2009-01-02, EA 5310-04716 REV E FRAME AT BS 500A R, BETWEEN STRINGERS 8 & AMP; 9. INBOARD RIVET HOLE HAS A CRACK INDICATION. REPAIRED FRAME AT BS 500A R/H BETWEEN STRINGERS 8 & AMP; 9 IN IAW EA 5310-04716 REV E.SDR SIMA20130904007Frame · corrodedUNDERFLOOR FRAME AT FS 333 IS CORRODED ON RT SIDE. REPAIRED FRAME IAW EO CR-53MR-344.SDR SIMA20130903016Frame · crackedFRAME 10 IS CRACKED AT THE TOP BELOW THE F/O DV WINDOW SILL. REMOVED AND REPLACED THE UPPER HALF OF RT SIDE FR 10 IAW SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR SIMA20130903014Frame · crackedFRAME 72 IS BENT AND CRACKED JUST ABOVE THE RT OTBD FLOOR SUPPORT. COMPLIED WITH REPAIR OF FRAME IAW SRM 53-00-04. AIRCRAFT RETURNED TO SERVICE.SDR SIMA20130903015Frame · crackedFRAME 23 IS CRACKED BETWEEN STRINGERS 14 AND 15 RIGHT. REPAIRED FRAME IAW SRM 53-00-04. AIRCRAFT RETURNED TO SERVICE.SDR FOTR23161NR52321Frame · crackedSTA 1178.225 CANTED FRAME, FRAME TO SKIN ATTACH ANGLE (FRAME CAP) IS CRACKED BETWEEN FASTENERS 3" BELOW LONGERON 17L. REPAIR ON FAS WO 23161, NR 52321.SDR AALA20130910017Frame · gougedFRAME 231 IS DENTED & GOUGED FROM ACCESS DOOR 113AL LOCKING PIN. INSTALLED A DOUBLER IAW EA B757-53-031426.SDR AALA20130903008Frame · crackedFS FRAME CRACKED AT FWD SIDE OF STATION 1322 & LONGERON 17 RT. ACCOMPLISHED NESTED ANGLE REPAIR IAW SRM 53-03-00 FIGURE 51.SDR AALA20130903007Frame · crackedFS FRAME FWD SIDE IS CRACKED AT STATION 1322 & LONGERON 17 LT. ACCOMPLISHED NESTED ANGLE REPAIR IAW SRM 53-03-00 FIGURE 51.SDR DALA13042426711Frame · dentedAFT CARGO COMPT, FRAME HAS TWO DENTS BS 1480, S25-27L. TRIMMED OUT DAMAGE, TWO DENTS ON FRAME. INSTALLED PERMANENT REPAIR IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR SWAA2013090619914Frame · crackedFRAME CRACKED AT STATION 747, STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013090919995Repair · crackedEMPENNAGE COMPARTMENT LT SIDE CANTED FRAME REPAIR CRACKED AT FS 1225 AT 11 O'CLOCK POSITION. R&R PANEL IAW SRM.SDR CALA2013090300618Frame · crackedDURING INSPECTION FOUND CRACK INDICATION AT FRAME BS 727B R BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME. REPAIRED FRAME IAW ECRA 5310-04716 REV E. SEE ENTRIES BELOW FOR ALL WORK ACCOMPLISHED.SDR CALA2013090300617Frame · crackedDURING INSPECTION FOUND CRACK INDICATION AT FRAME BS 480 L BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME. REPAIRED FRAME IAW ECRA 5310-04716 REV E. SEE ENTRIES BELOW F OR ALL WORK ACCOMPLISHED.SDR CALA2013090300615Frame · crackedDURING INSPECTION (MID-FEC) FOUND CRACK INDICATION AT FRAME BS 727D R, BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME, MARKED. PER EA5310-04716 REV.E OPT 1. COMPLIED WITH STEPS 1-13 OF EA5310-04716 REV. E TO SDR CALA2013090300614Frame · crackedDURING INSPECTION (MID-FEC) FOUND CRACK INDICATION AT FRAME BS 827 R, BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME, MARKED. PER EA 5310-04716 REV E. COMPLIED WITH REPAIR AT FRAME BS 827 R BETWEEN STRINGERS SDR CALA2013090300613Frame · crackedDURING INSPECTION (MID-FEC) FOUND CRACK INDICATION AT FRAME BS 867R BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME. PER EA 5310-04716 REV E OPT 1. CUT DAMAGED AREA OF FRAME, FABRICATED & INSTALLED REPAIR ANGLSDR CALA2013090300602Frame · crackedFUSELAGE FRAME IS CRACKED @ BS 500D BETWEEN STRINGER 8L & 9L. FABRICATED & AMP; INSTALLED REPAIR PARTS, IAW F-EA 5310-04716 REV E OP 2.SDR CALA2013090300601Frame · crackedFUSELAGE FRAME IS CRACKED @ BS 480 BETWEEN STRINGER 8R & 9R. REPAIRED FRAME BS 480 BETWEEN STRINGER 8R & 9R. IAW EA 5310-04716 REV E OP 02.SDR ASOA20130901217Frame · crackedDURING C-CHECK, FRAME 10 CRACKED UNDER LT DV WINDOW CUTOUT. MX R & R FRAME 10 CHANNEL UNDER LT DV WINDOW CUTOUT SIDE IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR FDEA201308312095Frame · dentedAFT CARGO, BS 1320 S25L, FRAME UPPER FLANGE DENTED. FOUND OUT OF LIMITS IAW SRM 53-00-07, FIG 101, SHT 1. REMOVED AND REPLACED FRAME SECTION IAW SRM 51-40-02 AND DWG 146N1007. MAJOR REPAIR.SDR SWAA2013100320753Frame · crackedFRAME CRACKED AT BS 520 STRINGER 21R. REPAIRED FRAME IAW EA.SDR SWAA2013091820226Frame · crackedFRAME T CHORD CRACKED AT STATION 251.5, WL 221. REPAIRED T CHORD IAW SWA EA.SDR FDEA201308312097Frame · damagedAFT CARGO, STA 1420, FRAME, S25L-S26L, INBD FLANGE HAS 4 EA DRILLED HOLES. FOUND FRAME OUT OF LIMITS IAW SRM 53-00-07, FIG 101. REMOVED FRAME IAW SRMM 51-40-02. FABRICATED NEW FRAME AND INSTALLED IAW SRM 51-40-02 AND DWG 146N1012 SH 3. MAJOR REPAIR.SDR CALA2013090300612Frame · crackedDURING INSPECTION (MID-FEC) FOUND CRACK INDICATION AT FRAMES 787 L BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME. PER EA 5310-04716 REV E OPT 1. INSTALLED REPAIR AT BS 787 L BETWEEN STRINGERS 8 & 9 PER EA 5SDR CALA2013090300611Frame · crackedDURING INSPECTION (MID-FEC) FOUND CRACK INDICATION AT FRAME BS 787 R, BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME. PER EA 5310-04716 REV E. INSTALLED REPAIR AT BS 787 R BETWEEN STRINGERS 8 & 9 PER EA 5310-0SDR CALA2013090300610Frame · crackedDURING INSPECTION (MID-FEC) FOUND CRACK INDICATION AT FRAME BS 380 R BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME MARKED. PER EA 5310-04716 REV E OPT 1. INSTALLED REPAIR AT BS 380 R BETWEEN STRINGERS 8 & 9 SDR CALA2013090300609Frame · crackedDURING INSPECTION (MID-FEC) FOUND CRACK INDICATION AT FRAME BS 500C R BETWEEN STRINGERS 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME. PER EA 5310-04716 REV E OPT 1, INSTALLED REPAIR AT BS 500C R BETWEEN STRINGERS 8 & 9 PER ESDR CALA2013090300608Frame · crackedDURING INSPECTION (MID-FEC) FOUND CRACK INDICATION AT FRAME BS 480 R, BETWEEN STRINGER 8 & 9 AT AIR CONDITIONING OUTLET EXTRUSION SUPPORT ATTACHMENT TO FUSELAGE FRAME. PER EA 5310-04716 REV E. INSTALLED REPAIR AT BS 480R BETWEEN STINGERS 8 AND 9 PER EA 5310-0SDR CALA2013090300606Frame · crackedFUSELAGE FRAME IS CRACKED @ BS 440 BETWEEN STRINGER 8R & 9R. CUT OUT CRACKS & INSTALLED REPAIR ANGLES IAW EA 5310-04716 REV E - OPERATION 02.SDR CALA2013090300605Frame · crackedIAW AD 2009-01-02, EA 5310-04716 REV E. FRAME AT BS 440R, BETWEEN STRINGER 8 & AMP; 9 INBOARD RIVET HOLE HAS A CRACK INDICATION. REPAIRED FRAME AT BS 440R BETWEEN STRINGER 8 & AMP; 9 PER EA 5310-04716 REV E. SEE WIPS & AMP; TASKS FOR ALL WORK PERFORMEDSDR CALA2013090300604Frame · crackedFUSELAGE FRAME CRACKED @ BS 440 BETWEEN STRINGER 8L & 9L. INSTALLED REPAIR DOUBLERS ON CABIN FRAME @ BS 440 BETWEEN STRINGER 8L & 9L, IAW EA 5310-04716 REV E.SDR CALA2013090300600Frame · crackedFUSELAGE FRAME IS CRACKED @ BS 500D BETWEEN STRINGER 8R & 9R. REPAIRED FRAME @ BS 500D BETWEEN STRINGER 8R & 9R IAW ECRA#5310-0 4716 REV E.SDR CALA2013090300599Frame · crackedFUSELAGE FRAME IS CRACKED @ BS 500A BETWEEN STRINGER 8L & 9L. REPAIRED FRAME AT BS 500A BETWEEN STRINGER 8L & 9L IAW EA 5310-04 716 REV. ESDR CALA2013090300598Frame · crackedFUSELAGE FRAME CRACKED @ BS 867 BETWEEN STRINGER 8R & 9R. FABRICATED & AMP; INSTALLED REPAIR PARTS, REF-EA 5310-04716 REV E OP2 .SDR CALA2013090300597Frame · crackedFUSELAGE FRAME IS CRACKED @ BS 500A BETWEEN STRINGER 8R & 9R. INSTALLED REPAIR ANGLES "A&B" IAW EA 5310-04716 REV-E.SDR CALA2013090300596Frame · crackedFUSELAGE FRAME IS CRACKED @ BS 400 BETWEEN STRINGER 8R & 9R. FABRICATED & AMP; INSTALLED REPAIR PARTS, IAW EA 5310-04716 REV E OP 2.SDR CALA2013090300595Frame · crackedFUSELAGE FRAME IS CRACKED AT BS 400 BETWEEN STRINGER 8L-9L. CUT-OUT DAMAGED AREA, FABRICATED REPAIR PARTS & INSTALLED AT FUSELAGE FRAME BS 400 STRINGER 8L-9L IAW EA 5310-04716 REV E.SDR DALA13042376711Frame · dentedAFT CARGO BAY FRAME DENTED BS 1500 STR 26-27L. COMPLETED PERMANENT REPAIR IAW SRM 53-00-07 REPAIR 5, PG 201, FIG 201, STEPS 1-1.SDR SWAA2013110521932Former · crackedLT TENSION BRACKET CRACKED AT STATION 1022. R & R FORMER IAW SRM & DRAWING.
Back to JASC 5311