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 CALA2013060700388Frame · crackedLEFT FRAME BETWEEN STRINGERS 8 AND 9 BS 727D BOTH FASTENERS HAS A CRACK. LT FRAME BETWEEN STRINGERS 8 AND 9 STA HAS BEEN REPAIRED IAW EA 5310-04716, REV E.SDR DALA13027191402Frame · corrodedCORROSION ON CABIN FRAME BS 1197+132 INBD FACE BETWEEN STRINGER 12-13L, CARRIED OUT REPAIR IAW ER/A514973-14.SDR DALA13027181402Frame · crackedCRACK INDICATION FOUND ON FRAME DURING HFEC INSPECTION ON LT BS 859.5, LBL 89, WL 200 FRAME INNER CHORD TRANSITION RADIUS APPROX 0.5". FRAME REPAIRED.SDR DALA13027171402Frame · crackedCRACK INDICATION FOUND DURING HFEC INSPECTION ON RT BS 883.5, RBL 89, WL 200 FRAME INNER CHORD TRANSITION RADIUS APPROX. 0.5" IN LENGTH AS MARKED. FRAME INNER CHORD REPAIR CARRIED OUT.SDR ASOA20130604171Frame · crackedDURING C-CHECK, FRAME 25 BETWEEN STRINGERS 15-16R IS CRACKED AT TOP FLOOR SILL RIVET. MX PERFORMED REPAIR OF FRAME 25 BETWEEN STRINGER 15R-16R IAW SRM 53-00-04. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR DALA13051683731Frame · crackedDURING INSPECTION, FOUND FRAME CRACKED AD2009-01-02. MX REPAIRED IAW ERA 506369-14AD.SDR ASOA2013071708700Frame · corrodedFUSELAGE FRAME BS 333 CORRODED ON FWD AND AFT SIDES BETWEEN STR 26L AND STR 26R. INSTALLED NEW FRAME SEGMENT IAW SRM 51-42-06 AND 51-42-21.SDR ASOA2013071708699Frame · corrodedFUSELAGE FRAME BS 319.7 CORRODED ON FWD AND AFT SIDES BETWEEN S26L AND 26R. REMOVED CORRODED FRAME SECTOR IAW SRM 51-42-06, 51-42-21. DRILL & LOCATED 319.70 FRAME SECTOR IAW SRM 51-42-06, 51-42-21. INSTALLED NEW SERVICEABLE FRAME IAW SRM 51-42-06 AND 51-42-SDR ASOA2013071708698Frame · corrodedFUSELAGE FRAME BS 310 CORRODED ON THE FWD AND AFT SIDES BETWEEN S26L AND 26R. REMOVED CORRODED FRAME IAW SRM 51-42-06, 51-42-21. LOCATED, DRILLED AND INSTALLED NEW FRAME SEGMENT.SDR SWAA2013061016993Frame · crackedLEFT AFT WING TO BODY FRAME CRACKED AT FL 832, LONG 23L. R & R FRAME IAW SRM.SDR DALA1314870682Frame · misrepairedAFT CARGO FRAME REPAIR DOES NOT COMPLY WITH SRM REQUIREMENTS. BS 1480 S26R. REPLACED REPAIR AND CORRECTED DISCREPANCY IAW SRM 53-00-070, FIG 201, REPAIR 5.SDR CALA2013060300385Frame · crackedBS 727D, FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET ATTACHES IN CABIN. LOCATED BETWEEN STRINGERS 8 AND 9L. REPAIR FRAME IAW EA 5310-04716, REV E.SDR CALA2013060300382Frame · crackedBS 500A FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET EXTRUSION BRACKET ATTACHES IN CABIN. LOCATED BETWEEN STRINGERS 8 AND 9L. FABRICATED AND INSTALLED REPAIR ANGLES TO FRAME AT STA 500A LT BETWEEN STRINGERS 8 AND 9 REF EA 5310-04716, REV E.SDR CALA2013060300368Frame · crackedFRAME BETWEEN STRINGERS 8 AND 9L BS 500C INBD FASTENER HAS A CRACKED. REPAIRED IAW EA 5310-04716, REV E, FIG 3.SDR CALA2013060300367Frame · crackedFRAME BETWEEN STRINGERS 8 - 9L, BS 500A INBD FASTENER HAS A CRACK. REPAIRED IAW EA 5310-04716, REV E FIG 3.SDR CALA2013060300369Frame · crackedCABIN RT FUSELAGE FRAME HAS CRACK INDICATION AT STRINGER 8-9R BS 500C. REPAIRED EA 5310-04716, REV E, FIG 3.SDR EE4Y201306030057Frame · corrodedLOWER FUSELAGE AFT CARGO COMPARTMENT AT BS 767 BETWEEN STRINGER 24R AND STRINGER 27R FRAME OUTER CHORD WITH CORROSION IN SEVERAL PLACES.SDR CHQA20130602213Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE REPAIR ANGLE AT FRAME 23. THE REPAIR DOUBLER WAS REPLACED IAW SRM 51-40-02.SDR CALA2013060300381Frame · crackedBS 400L, FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET EXTRUSION BRACKET ATTACHES IN CABIN. MARKED LOCATED BETWEEN STRINGER 8 AND 9. FABRICATED AND INSTALLED REPAIR ANGLES TO FRAME AT STA 400 LT BETWEEN STRINGERS 8 AND 9 REF EA 5310-04716, REV ESDR CALA2013060300380Frame · crackedBS 400, FRAME CRACKED AT INBD RIVET WHERE AC GRILL OUTLET EXTRUSION BRACKET ATTACHES IN. LOCATED BETWEEN S8-9R. FABRICATED AND INSTALLED REPAIR ANGLES TO FRAME IAW EA 5310-04716, REV E.SDR CALA2013060300366Frame · crackedFRAME BETWEEN STRINGERS 8 - 9L, BS 827 BOTH FASTENERS HAS A CRACK. REPAIRED FRAME IAW EA 5310 -04716, REV E, OP1.SDR CALA2013060300365Frame · crackedFRAME BETWEEN STRINGERS 8 AND 9L, BS 787 INBD FASTENERS HAS A CRACK. REPAIRED EA 5310-04716, OP1, REV E.SDR CALA2013060300364Frame · crackedRT FUSELAGE FRAME HAS A CRACK INDICATION, STRINGER 8-9R, BS 727B. FRAME REPAIRED IAW EA 5310-04716, REV E.SDR CHQA20130601214Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON FRAME 65 AT THE LOWER DOOR PLATE. THE FRAME WAS REPAIRED IAW SRM 53-31-04 AND SRM 51-40-02.SDR CHQA20130601212Frame · corrodedDURING INSPECTION, A GOUGE WAS FOUND ON FRAME 60 BETWEEN STRINGERS 4L AND 5L. THE FRAME WAS REPAIRED IAW SRM 53-00-04.SDR CHQA20130601200Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON FRAME 14 AT STRINGERS 20-21R. FRAME REPAIRED IAW SRM 53-00-04 AND SRM 51-40-02.SDR SWAA2013061217065Former · crackedAFT ACCESSORY COMPARTMENT FORMER CRACKED AT STA 1161, LONG 2R. R & R FORMER IAW SRM.SDR SWAA2013061217064Former · crackedAFT ACCESSORY COMPARTMENT FORMER CRACKED AT STA 1161, LONG 2L. R & R FORMER IAW SRM.SDR DALA1314630682Frame · dentedFWD CARGO BIN BS 600, FRAME DENTED UPPER FLANGE S23-25L. REPAIRED IAW SRM 53-00-07, REPAIR 5.SDR DALA1314440682Frame · corrodedMAIN CABIN FRAME EXFOILIATED AT BS 1720 LBL 56 AFT DECK PLATE FLOOR AND APB. R & R FRAME IAW SRM 51-40-02.SDR DALA1314400682Frame · corrodedAFT CARGO BILGE FRAME CORRODED STA 1440, STR 25L TO STR 25R. R & R PART IAW SRM 51-40-02.SDR IPXA13578608Frame · dentedINSPECTION TYPE:C-16, AFT CARGO PIT INTERIOR SIDE BODY FRAME DENTED ON UPPER SURFACE, BS 1520, STR 25-26L. FABRICATED AND INSTALLED REPAIR IAW SRM 53-60-07-2R-1 AND 53-00-07-2R-5, DETAIL III.SDR IPXA13578606Frame · dentedINSPECTION TYPE:C-16, AFT CARGO BAY INTERIOR SIDE BODY FRAME DENTED ON UPPER SURFACE BS 1300, S26R. FABRICATED AND INSTALLED REPAIR IAW SRM 53-60-07-2R-1 AND 5 3-00-07-2R-6, DETAIL VI.SDR IPXA13578605Frame · dentedINSPECTION TYPE:C-16 AFT CARGO BAY INTERIOR SIDE BODY FRAME DENTED ON UPPER SURFACE BS 1580, S25-26R. FABRICATED AND INSTALLED A REPAIR IAW SRM 53-60-07-2R-1 AND 53-00-07-2R-5, DETAIL III.SDR UALA2013060303823Frame · corrodedBS 1681 FRAME HAS CORROSION ON THE FREE FLANGE BETWEEN S17-18R. CUTOUT DAMAGE AND FABRICATED NEW UPPER TEE FITTING, SHIMS, SPLICE STRAP. MAJOR REPAIR.SDR DALA13026820926Frame · crackedBS 1510, FRAME CRACKED. RT UPPER, AT RUDDER PCU ATTACH. REMOVED UPPER RT TAILCONE LATCH, CUTOUT CRACKS, CUTOUT SIZE 1" X 1.375". HFEC INSP AND NO OTHER CRACKS FOUND. FABRICATED AND INSTALLED REPAIR WORK IAW ERA 515449-14, REV ORG ASSOCIATED ER/A 14-515449,SDR AALA20130531051Frame · crackedBODY STA 294.5 STUB FRAME IS CRACKED AT RT BUTTLINE 55 AND WATERLINE 208. REPAIRED FRAME IAW EA B737-53-030054.SDR WX0A071599Frame · corrodedAFT CARGO COMPARTMENT FS FRAME 1309 LOWER FLANGE IS CORRODED BETWEEN LONGERON 28R TO 28L. REPAIRED DAMAGED AREA OF FRAME.SDR SWAA2013062817728Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17L. REPAIRED FRAME IAW SRM.SDR SWAA2013062717669Frame · corrodedFRAME CORRODED AT BS 993, BETWEEN STRINGER 16R - STRINGER 17R. REPAIRED FRAME IAW ER & EA.SDR SWAA2013062517598Frame · crackedFRAME CRACKED AT BS 188, STRINGER 17R. REPAIRED FRAME IAW SRM.SDR USAA2013061300033Frame · crackedQ4 CHECK - CRACK ON FUSELAGE FRAME AT BS 727B BETWEEN S8R TO S9R. REPAIRED FUSELAGE FRAME AT BS 727B BETWEEN S8R TO S9R IAW TYPICAL REPAIR TR737-5310-10-0287.SDR SWAA2013061217086Support Fitting · corrodedFRAME 965 RT SIDE LOWER SUPPORT FITTING CORRODED. R & R FITTING IAW SRM.SDR DALA1314510682Frame · corrodedAFT CARGO BILGE FRAME, BS 1460, S25L TO 25R, CORRODED. REPLACED FRAME IAW SRM 51-40-02, PG 2 AND 6, FIG 4-12 AND DWG 146N1014.SDR REXA2013060300690Frame · corrodedLOWER FS349 FRAME CORRODED IN AVIONICS BAY BETWEEN S-26L AND S-26R. REPAIRED IAW SRM 51-21-06.SDR SWAA2013070918053Frame · corrodedFRAME CORRODED AT BS 360, BETWEEN STRINGER 28L - STRINGER 28R. REPAIRED FRAME IAW EO & EA.SDR ASAA2013052995434Frame · dentedAFT CARGO FRAME AT BS 727B, DENTED FROM S24 - 25R, ACFT GROUNDED. REPAIRED FRAME IAW EA 400-53EA-10601, REV NEW ISSUED 06/27/2013.SDR SWAA2013062517570Failsafe · corrodedAFT CARGO BAY FAIL SAFE ANGLE CORRODED AT BS 947.5, BETWEEN STRINGER 25R - 26R. R&R FAIL SAFE IAW SRM.SDR USAA2013062100015Frame · crackedQ5 CHECK - CRACK ON FUSELAGE FRAME AT BS827 BETWEEN S8L TO S9L REPAIRED FUSELAGE FRAME AT BS827 BETWEEN S8L TO S9L IAW TYPICAL REPAIR TR 737-5310-10-0287.SDR SWAA2013061917362Frame · crackedFRAME CRACKED AT BS 696, BETWEEN LONGERON 9L TO LONGERON 18L. R & R FRAME IAW SRM AND DWG.
Back to JASC 5311