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 IPXA12572776Frame · dentedINSPECTION TYPE: C, FWD CARGO RT SIDE FRAME AT BS 840 AT S22R DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07-2R5, REV 83 DETAIL II.SDR IPXA2572373Frame · damagedINSPECTION TYPE:C-CHECK, FWD CARGO COMPARTMENT STA 840 BETWEEN STRINGER 23 AND 24 LEFT HAS DAMAGE. FABRICATED AND INSTALLED REPAIR IAW SRM 53-00-07-2R 5, DETAIL I.SDR CALA2012031400186Frame · crackedRT FRAME CRACKED IN RADIUS AT STA 907 REPAIRED PER ECRA 5310-05471 SEE 44.0008 FOR WORK ACCOMPLISHED.SDR IPXA12572967Frame · dentedINSPECTION TYPE: C, AFT CARGO BAY BS 1260, S25L FRAME DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW EA 120372 EO B757-5310-46640-A.SDR IPXA12572964Frame · dentedINSPECTION TYPE: C, AFT CARGO BAY BS 1280, S26-27L FRAME DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW EA 120373 IR EO B757-5310-46704-A.SDR IPXA12572961Frame · dentedINSPECTION TYPE: C, AFT CARGO BAY BS 1460 S25-26L FRAME DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07-2R5, DETAIL I.SDR IPXA12572960Frame · dentedINSPECTION TYPE: C, CARGO BAY BS 1280, S26-27L FRAME DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW EA 120373 IR/U EO B757-5310-46704-A.SDR IPXA12572956Frame · dentedINSPECTION TYPE: C, AFT CARGO PIT STA 1300 S-26L FRAME HAS A DENT. REPAIRED FRAME IAW EA 120374 IR AND EO B757-5310-46706-A.SDR IPXA2572873Frame · dentedINSPECTION TYPE: C, AFT CARGO BAY BS 1580 S26L FRAME DENTED. REPAIRED FRAME IAW SRM 53-00-07-2R REPAIR 5, DETAIL 3, REV 83.SDR IPXA2572802Frame · dentedINSPECTION TYPE: C, AFT CARGO BAY BS 1480 S25-26L FRAME DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00- 07-2R5, DETAIL III.SDR IPXA2572798Frame · dentedINSPECTION TYPE: C, AFT CARGO BAY BS 1320 S26R, FRAME DENTED. REPAIRED FRAME IAW SRM 53-00-07-2R REPAIR 5, DETAIL 3, REV 83.SDR IPXA12572725Frame · dentedINSPECTION TYPE: C, AFT CARGO BS 1500 S26R FRAME DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07-2R5 DETAIL 1. REPAIR DOUBLER FABRICATED AND HEAT TREATED TO T6 CONDITION.SDR SWAA2012031902317Frame · crackedRT LOWER FRAME SECTION INBD CHORD CRACKED AT BS 616. REPAIRED CHORD IAW EA.SDR SWAA2012031902316Frame · crackedLT FRAME CRACKED AT BS 616 LOWER FRAME SECTION, INBD CHORD. REPAIRED CHORD IAW EA.SDR USAA2012031900010Frame · crackedCDFI VISIT - CRACKS ON INNER CHORD & WEB OF FUSELAGE FRAME AT BS 639, S16R BETWEEN WL 200 TO WL 220, RBBL 60.0. ACCOMPLISHED PARTIAL FRAME REPLACEMENT IAW EA 202009 & TYPICAL REPAIR T/R 737-5362-10-0098A.SDR USAA2012031900009Frame · crackedCDFI VISIT - 1/8 INCH LONG CRACK ON INTERNAL HOLES OF INNER CHORD & WEB AT BS 616, S16R & BETWEEN RBBL 60.00 TO RBBL 70.00. PARTIAL FRAME REPLACEMENT ACCOMPLISHED IAW EA 202000 & TYPICAL REPAIR T/R 737-5362-10-0098A.SDR DALA1216350995Frame · crackedDURING PSV CHECK IN MSP THE 9911842-129 FRAME WAS FOUND WITH A CRACK AT STA 1458, ZR=35.0, X=20.00 AS SHOWN IN FIG 1. THE FRAME IS MADE FROM 0.050" 7075-T6.SDR FDEA201203130914Frame · corrodedAFT CARGO BAY, STA 1380 STR 29L-29R, FRAME LOWER CHORD CORRODED. REMOVED CORROSION ORIG MAT .090 AFTER REWORK MAT WAS .061 WITH MATERIAL LOSS OF .029 FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07, FIG 101, DETAIL 2. INSTALLED FAILSAFE AND TWO VERTICAL SUPPORTS SDR SWAA2012032902672Frame · corrodedFRAME LOWER FLANGE CORRODED AT BS 867, BETWEEN STR 27R TO STR 27L. REPAIRED FRAME IAW SRM.SDR FDEA201203100870Frame · corrodedAFT CARGO BAY BS 1260, STR30 FRAME CORRODED.SDR FDEA201203100869Frame · corrodedAFT CARGO BAY STRINGERS 28-29R, FRAME CORRODED.SDR DALA1214851605Frame · crackedFS 903 STR 21L FRAME INNER CHORD IS CRACKED AND REPAIRED PER ERA 499072-14AD REV ORG.SDR DALA1214841605Frame · crackedFS 903 AT STR 21R FRAME INNER CHORD IS CRACKED AND REPAIRED PER ERA 499071-14 REV ORG.SDR DALA1214830692Frame · dentedFWD CARGO COMPT, FRAME DENTED STA 520, STR 25L. REPAIRED PER ERA 489937-14AD.SDR USAA2012031200004Beltframe · crackedCDFI VISIT - CRACK FOUND ADJACENT TO PREVIOUSLY INSTALLED REPAIR AT BS 500B, S20L, WL 182.5. REMOVED PREVIOUS REPAIR, REMOVED CRACK & INSTALLED REPAIR DOUBLERS IAW B737 SRM 53-00-07-2R-13.SDR DALA1214469259Frame · crackedDURING HMV/MOD FOUND RT FUSELAGE FRAME TAB CRACKED AT RADIUS AT STA 962 UNDER CUSP WEB. REMOVED AND REPLACED FRAME IAW DWG# SG09530019IR.SDR DALA1214293720Frame · crackedINTERIOR CABIN FRAME STA 400 IS CRACKED AT STRINGER 8R. REPAIRED IAW ERA 498947-14AD.SDR DALA1214283720Frame · crackedINTERIOR CABIN FRAME STA 480 IS CRACKED AT STRINGER 8R. REPAIRED IAW ERA 498947-14AD.SDR FDEA201203090830Frame · gougedRIGHT FRAME 24 HAS A GOUGE BETWEEN STGR 12 -13. APPROX L=0.5" W=0.25". REF AMM 53-13-11-06. R & R COUPLING AT RT SIDE FR 24 BETWEEN STR 12R - 13R IAW SRM 51-72-10, PG 1-2.SDR SIMA20120308001Frame · crackedDURING MAINTENANCE BASE INSPECTION FOUND THE LEFT COCKPIT FRAME 10 IS CRACKED BENEATH THE DV WINDOW. REMOVED AND REPLACED FRAME 10 O/B SEGMENT IAW SRM 51-40-02. THE AIRCRAFT WAS RETUERNED TO SERVICE.SDR RAIA201203080004Doubler · corrodedDURING HEAVY CHECK INSPECTION MAINTENANCE FOUND THE DOUBLERS ON FRAMES 20 & 22 BEAM Y-479 HAS CORROSION. MAINTENANCE REMOVED AND REPLACED THE DOUBLERS ON FRAMES 20 & 22 BEAM Y-479.SDR CHQA20120308081Frame · crackedDURING INSPECTION, THE RIGHT FRAME 10 WAS FOUND TO BE CRACKED. THE RIGHT FRAME 10 WAS REPLACED. THE NEW PART WAS INSTALLED WITH A SOLID RIVET IN ACCORDANCE WITH SRM 51-40-02.SDR CHQA20120308080Frame · crackedDURING INSPECTION, THE LEFT FRAME 10 WAS FOUND TO BE CRACKED. THE LEFT FRAME 10 WAS REPLACED. THE NEW PART WAS INSTALLED WITH A SOLID RIVET IN ACCORDANCE WITH SRM 51-40-02.SDR CHQA20120308079Frame · crackedDURING INSPECTION, THE RIGHT FRAME 23, JUST BEHIND THE RIGHT SILL NUMBER 1 WAS FOUND TO BE CRACKED. MAINTENANCE REPAIRED THE RIGHT FRAME 23 JUST BEHIND THE RIGHT SILL NUMBER 1 IN ACCORDANCE WITH ETD 2012-145-003386.SDR AALA20120314002Frame · damagedVERTICAL FRAME AT STATION 291.5 HAS DOUBLE DRILLED HOLE ABOVE CREASE ANGLE. INSTALLED FREEZE PLUG PER EA.SDR DALA1214769202Frame · corrodedCORROSION ON FRAME IN AFT CARGO COMP AT STA 1379 LNGR 28R TO LNGR 25L. CORROSION OF FRAME WAS FOUND OUT OF LIMITS. CORROSION ON SHEAR TIE FOUND OUT OF LIMITS. INTERCOSTAL HAD LIGHT CORROSION. LOCATED AND DRILLED FRAME AND SHEAR TIES, INSTALLED NEW FRAME ANDSDR CALA2012030900174Frame · crackedSUPPORT TASK: RT FRAME AT STA 440 CRACKED. REPAIRED PER EA 5310-04716 REV C.SDR CALA2012030900173Frame · crackedSUPPORT TASK - LT FRAME AT STA 380 CRACKED. REPAIRED FRAME PER EA 5310-04716 REV C.SDR FDEA201203070807Frame · dentedDENT ON FRAME STA 1520, STR 25L-26L. DENTS NOT ALLOWED IN FRAME FLANGE IAW SRM 53-00-07 FIG 101 PG 101. REMOVED AND INSTALLED NEW FRAME IAW SRM 51-40-02. MAJOR REPAIRSDR AALA20120314001Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING STATION 500A R. ACCOMPLISHED NESTED ANGLE REPAIR PER ESO J1159AD.SDR AALA20120313008Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING STATION 500C-R. ACCOMPLISHED NESTED ANGLE REPAIR PER ECO J1159AD-0007.SDR AALA20120311003Frame · crackedEDDY CURRENT INSPECTION INDICATES A CRACK AT STATION 440 LEFT FRAME AT AIR CONDITIONING SUPPORT ATTACH FITTING. INSTALLED REPAIR DOUBLER/ANGLES A AND B PER ECO J1159AD 0006.SDR AALA20120311002Frame · crackedEDDY CURRENT INSPECTION INDICATES A CRACK AT STATION 400 LEFT FRAME AT AIR CONDITIONING SUPPORT ATTACH FITTING. INSTALLED REPAIR DOUBLER/ANGLES A &AND B PER ECO J1159AD CARD 0006.SDR AALA20120311001Frame · crackedEDDY CURRENT INSPECTION INDICATES A CRACK AT STATION 380 LEFT AT AIR CONDITIONING SUPPORT ATTACH FITTING. INSTALLED REPAIR DOUBLER/ANGLES A AND B PER ECO J1159AD 0006.SDR IPXA12572097Frame · damagedINSPECTION TYPE: C, LEFT MLG WHEEL WELL FRAME AT INBD FLAP TRANSMISSION, CHAFING WITH WING UPPER T/E Z-ANGLE. REMOVED DAMAGED AREA, FABRICATED REPAIR ANGLES, AND RE-INSTALLED.SDR QXEA2012030700223Frame · corrodedCORROSION ON FRAME FLANGE AT STA 216, STR 31P -32P. REMOVED 4 RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344. MINIMUM REMAINING THICKNESS .045", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 AND 51-00-06-910-801 PT1. MATERIAL LOSS FOUND TO BE WITHIN LIMITSSDR CALA2012030800172Frame · crackedSUPPORT TASK - RT FRAME AT STA 400 CRACKED. REPAIRED FRAME IAW EA 5310-04716 REV C.SDR CALA2012030800171Frame · crackedLT FRAME AT STA 400 CRACKED. REPAIRED LT FRAME AT STA 400 PER EA 5310-04716 REV C.SDR CALA2012030800170Frame · crackedRT FRAME AT STA 380 CRACKED. REPAIRED PER EA 5310-04716 REV C FIGURE 3.SDR SWAA2012032102457Frame · crackedLT FRAME INNER CHORD CRACKED AT BS 616. REMOVED AND REPLACED CHORD IAW EA.
Back to JASC 5311