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 SWAA2013112022612Frame · crackedFRAME FWD FLANGE CRACKED AT BS 727, STRINGER 18A LT. REPAIRED FLANGE IAW EA.SDR SWAA2013112022611Frame · crackedFRAME FWD FLANGE CRACKED AT BS 727, STRINGER 18A RT. REPAIRED FLANGE IAW SWA EA.SDR SWAA2013111122211Frame · crackedFRAME FORMER CRACKED AT BS 1053, LONGERON 3L. R & R CLIP IAW DRAWING & SRM.SDR SWAA2013110521998Former · crackedFRAME FORMER CRACKED AT STATION 1152, LONGERON 3R. R & R ANGLE IAW SRM & DRAWING.SDR DALA13050946812Frame · dentedDENT ON FUSELAGE FRAME UPPER FLANGE IN AFT CARGO BAY BS 1400 BETWEEN STRINGERS 26-27L. TRIMMED DAMAGE IAW SRM 53-00-07, REPAIR 5, FIG 201. REPAIRED IAW SRM 53-00-07, REPAIR 5, FIG 201.SDR FDEA201310032399Support Frame · corrodedAPU INLET DOOR SHROUD CUT-OUT FWD SUPPORT FRAME CORRODED. FOUND OUT OF LIMITS IAW SRM 53-80-15, FIG. 101, DETAIL 2. REMOVED AND REPLACED IAW SRM 51-40-02 AND DWG 148N3105. CAT "A" MAJOR REPAIR.SDR SIMA20131003013Frame · damagedFRAME 65 DENTED AND GOUGED BETWEEN S12-13R. REPAIRED IAW EO-EM-53MR-2212.SDR SIMA20131003011Frame · gougedFR 65 GOUGED BETWEEN STR 12R/13R JUST BELOW STR 12R. PERFORMED REPAIR IAW EO-EM-53MR-2213.SDR V0XR201310050261Frame · corrodedFUSELAGE FRAME FS 310 BETWEEN LBL 7 AND RBL 2 CORRODED. BLENDED AREA TO WITHIN LIMITS, IAW REO 670-53-21-1015.SDR DALA13049416812Frame · dentedFRAME UPPER ANGLE IS DENTED AT AFT CARGO BAY BS 1420 BETWEEN S26-27L. TRIMMED -OUT DENTED AREA ON FRAME. REPAIRED IAW SRM 53-00-07, REPAIR 5, FIG 201.SDR CHQA20131002365Frame · damagedDURING INSPECTION, A DAMAGED HOLE IN FRAME 26 BETWEEN STRINGERS 15R AND 16R WAS FOUND. THE DAMAGE WAS REPAIRED IAW ETD 2013-145-045443.SDR SWAA2013101121071Frame · crackedFRAME CRACKED AT BS 827 BETWEEN STRINGER 8L & STRINGER 9L. REPAIRED FRAME IAW EA.SDR DALA13050906812Frame · dentedFRAME IS DENTED, UPPER FLANGE AT BS 600 IN FWD CARGO ABOVE STRINGER 24L. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5.SDR DALA13050090956Frame · crackedCRACKED FRAME ANGLE BS 1418 AND LONG 2L AT AFT ACCESSORY BAY. DAMAGE LONGERON SECTION AND CRACKED FRAME ANGLE WERE REMOVED, NEW LONGERON SPLICE AND NEW FRAME ANGLE WERE DRILLED AND ADJUSTED, TREATED, AND PAINTED. INSTALLED IAW SRM 53-02, FIG 18 51-10-3, PAR SDR DALA13049060956Frame · crackedCRACK ON FRAME AT BS 1174 AND LONGERON 6L. REPAIRED IAW ER/A 495237-14MA AND AMR 0953914 REV.SDR GLBA2013100200332Frame · crackedDURING A SCHEDULED INSPECTION, FOUND A CRACK IN THE FUSELAGE FRAME ANGLE IN THE BEND RADIUS AT FS 451 AND STRINGER 10R, .875 INCH IN LENGTH. REPAIRED IAW EO 13-1900-53-068. MAJOR REPAIR.SDR ASOA2013102909283Frame · corrodedFRAME BS 333 AFT SIDE CORRODED BETWEEN S26L & 26R. REPAIRED IAW REO 670-53-21-1023.SDR ASOA2013102909282Frame · corrodedFRAME CORRODED BS 349 AT S27. REPAIRED IAW REO 670-53-21-1023.SDR ASOA2013102909280Frame · corrodedFRAME BS 319.7 FWD FACE CORRODED BETWEEN S26L AND 26R. REPAIRED FRAME IAW REO 670-53-21-799.SDR ASOA2013102909279Frame · corrodedFWD FACE OF FRAME BS 310 CORRODED BETWEEN S26L AND 26R. COMPLIED WITH REO 670-53-21-1023.SDR ASOA2013102909278Frame · corrodedFRAME BS 295, CORRODED S26R. COMPLIED WITH REO 670-53-21-1023.SDR SWIA201335067Frame · chafedCHAFED FRAME ON RT HYD BAY FWD SIDE. C-CHECK REPLACED RT HYD BAY FWD CUT OUT FRAME PN 120-44444-002 IAW SRM.SDR GLBA2013100200330Frame · crackedDURING A SCHEDULED INSPECTION FOUND A CRACK BS 107 AND STRINGER 8R FRAME, 0.5 INCH IN LENGTH. REPAIRED IAW EO 13-1900-53-070. MAJOR REPAIR.SDR GLBA2013100200331Frame · crackedDURING A SCHEDULED INSPECTION, FOUND A CRACK IN THE FRAME LT SIDE OF FS 107 BY STRINGER 8L, .125 INCH IN LENGTH. REPAIRED IAW EO 13-1900-53-069. MAJOR REPAIR.SDR GLBA2013100200333Frame · crackedDURING A SCHEDULED INSPECTION FOUND TWO CRACKS IN FUSELAGE FRAME, STRINGER 8L BS 438.25, .999 INCH IN LENGTH. REPAIRED IAW EO 13-1900-53-067. MAJOR REPAIR.SDR GLBA2013100200328Frame · crackedDURING A SCHEDULED INSPECTION, FOUND TWO CRACKS IN THE FUSELAGE FRAME ON EITHER SIDE OF STRINGER 2L AT FS 378.25, ONE INCH IN LENGTH. REPAIRED IAW EO 13-1900-53-072. MAJOR REPAIR.SDR CHQA20131001363Frame · bentDURING INSPECTION, FRAME 72 WAS FOUND TO BE BENT BETWEEN STRINGERS 15L AND 16L. THE FRAME WAS REPAIRED IAW ETD 2013-145-045154, REV B.SDR SWAA2013101121070Frame · crackedFRAME CRACKED AT BS 480 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013101121069Frame · crackedFRAME CRACKED AT BS 827 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013101121068Frame · crackedFRAME CRACKED AT BS 747 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013101121067Frame · crackedFRAME CRACKED AT BS 727D STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013101121066Frame · crackedFRAME CRACKED AT BS 400 STRINGER 8R. REPAIRED FRAME IAW EA.SDR SWAA2013101121060Frame · crackedFRAME CRACKED AT BS 500C STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013101121059Frame · crackedFRAME CRACKED AT BS 440 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013101121058Frame · crackedFRAME CRACKED AT BS 400 STRINGER 8L. REPAIRED FRAME IAW EA.SDR SWAA2013101121057Frame · crackedFRAME CRACKED AT BS 380 STRINGER 8L. REPAIRED FRAME IAW EA.SDR V0XR2013100500262Frame · corrodedAFT FACE OF FRAME FS 295 BETWEEN LBL 9 AND RBL 1 HAS CORROSION. CUT OUT CORRODED SECTION OF FRAME AND INSTALLED SERVICEABLE FRAME IAW REO 670-53-21-1012, REV A.SDR WX0A20131004713Frame · chafedAPU COMPT FWD FRAME AT FS X=1350 IS CHAFED THRU AT RT CORNER AT THE APU ANGLE AT AIR INTAKE FLANGE. FABRICATED REPAIR ANGLE AND INSTALLED REPAIR IAW (STS) EA 05-2013-094.SDR WX0A20131004712Frame · chafedAPU FWD SHROUD IS CHAFING AT FWD LT CORNER OF THE APU ANGLE TO FUSELAGE SKIN AT AIR INTAKE FLANGE. FABRICATED NEW REPAIR ANGLE AND INSTALLED REPAIR IAW (STS) EA 05-2013-094.SDR CALA2013100200723Frame · crackedINBD RIVET HOLE FOR STATION 440R SUPPORT BRACKET FOR A/C OUTLET EXTRUSION BETWEEN STRINGERS 8 & 9 IS CRACKED. COMPLETED REPAIR FOR FRAME STATION 440R BETWEEN STRINGERS 8 & 9 IAW EA 5310-04716 REV. F.SDR FDEA201309302350Frame · dentedFWD E/E BAY BS 231.25, BL 0 FRAME INNER FLANGE DENTED. REPAIRED IAW EA F-5310-T0304068 PART 1. REPAIR CLASSIFIED AS MAJOR.SDR SIMA20130930010Shear Tie · crackedDURING HMBV INSPECTION, FOUND LT SIDE UPPER SHEAR TIE ON FRAME 80 CRACKED. REMOVED AND REPLACED SHEAR TIE IAW SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR SIMA20130930004Frame · crackedDURING HMBV INSPECTION, FOUND LT UPPER FRAME 10 CRACKED. REMOVED AND REPLACED FRAME IAW SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR IPXA201310210639Frame · dentedINSPECTION C-8, FUSELAGE FRAME DENTED IN FWD CARGO BAY BS 640, STR 23R. FABRICATED AND INSTALLED FRAME REPAIR.SDR IPXA2013102100638Frame · dentedINSPECTION C-8, FUSELAGE FRAME DENTED IN FWD CARGO BAY BS 660, STR 2R. ACCOMPLISHED EO B757-5310-52404-ASDR CALA2013100200722Frame · crackedINBD RIVET HOLE AT STATION 727D LT FOR SUPPORT BRACKET FOR A/C OUTLET EXTRUSION IS CRACKED BETWEEN STRINGERS 8 AND 9. COMPLETED REPAIR FOR FRAME 727D LT BETWEEN STRINGERS 8L & 9L IAW EA 5310-04716 REV F.SDR CALA2013100200721Frame · crackedINBD RIVET HOLE STATION 400R FOR SUPPORT BRACKET FOR A/C OUTLET EXTRUSION BETWEEN STRINGERS 8 & 9 IS CRACKED. COMPLETED WITH REPAIR FRAME OF 400R BETWEEN STRINGERS 8 & 9 IAW EA 5310-04716 REV F.SDR DALA13048436811Frame · dentedDURING MX, BS 540 FRAME WAS FOUND DENTED. REPAIRED IAW ER/A 518268-14.SDR CALA2013093000717Frame · crackedIB RIVET HOLE STA 787L FOR SUPPORT BRACKET FOR A/C OULET EXTRUS ION IS CRACKED BETWEEN STRINGERS 8 AND 9 REF EA 5310-04 716. COMPLIED WITH REPAIR OF FRAME STA 787L BETWEEN STRINGERS 8 AND 9 REF EA 5310-04716 REV F.SDR CALA2013093000716Frame · crackedINBD RIVET HOLE FOR STATION 787R SUPPORT BRACKET FOR A/C OUTLET EXTRUSION IS CRACKED BETWEEN STRINGERS 8 & 9. COMPLIED WITH REPAIR OF FRAME 787R BETWEEN STRINGERS 8 & 9 IAW EA 5310-04716 REV F.
Back to JASC 5311