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 COMA2012032250023Frame · corrodedFRAME FS 589.00 IS CORRODED BELOW FLOOR. FRAME FS 589.00 WAS REPAIRED IAW BOMBARDIER REO 601R-53-61-4444.SDR COMA2012032250021Frame · corrodedFRAME FS 605.00 IS CORRODED BELOW FLOOR. FRAME FS 605.00 WAS REPAIRED IAW BOMBARDIER REO 601R-53-61-4444.SDR KCSA201203201036Frame · corrodedRT WING GEAR WHEEL WELL AT BS 1335 FOUND CORROSION ON FRAME 6" UP FROM OVERWING LONGERON.SDR DALA1231209255Frame · corrodedCORROSION UNDER FRAME 1344 BETWEEN L28R AND L29R. CUTOUT DAMAGE AND REPAIRED PER SRM 53-10-02 VOL I.SDR SWAA2012041303105Frame · corrodedFRAME CORRODED AT BS 1006, BETWEEN STR 21R TO STR 23R. REPAIRED FRAME IAW EO AND EA.SDR SWAA2012041203045Frame · corrodedFRAME CORRODED AT BS 807, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012041203044Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 26R TO STR 27R. REPAIRED FRAME IAW SRM.SDR DALA1221516304Frame · crackedFRAME STA 1255, BETWEEN S-4L TO S-5L FOUND ONE WEB CRACK AS MARKED. CRACKED FRAME WEB AT STA 1255 BETWEEN S-4L TO S-5L AREA REMOVED AS PER SRM 51-40-02. NEW WEB FABRICATED AS PER DWG 65B04913 REV E. NEW FRAME WEB AT STA 1255 BETWEEN S-4L TO S-5L AREA INSTALSDR SWAA2012041002970Frame · crackedFRAME CRACKED AT BS 787, BETWEEN STR 27L TO STR 26L. REPAIRED FRAME IAW SRM.SDR SWAA2012041002969Frame · corrodedFRAME CORRODED AT BS 787, BETWEEN STR 25R TO STR 26R. REPAIRED FRAME IAW SRM.SDR IPXA12672745Frame · crackedINSPECTION TYPE: 8C, BS 1809.5 BULKHEAD FWD OUTER FRAME STRINGERS 6 TO 7R RADIUS AREA FOUND CRACKED. REPAIRED IAW SRM 53-80-08-2R9, FIG 201, REV 52, CRACK LENGTH APPROX 2 INCHES IN LENGTH, FRAME CUTOFF LENGTH 4.875 INCHES, CLASSIFIED AS A CATEGORY B MAJOR REPSDR ASOA201200958Frame · corrodedFRAME BS 333.00 CORRODED BETWEEN STR 26L AND 26R. REPAIRED IAW REO 601R-53-21-2276.SDR ASOA201200950Frame · corrodedFRAME BS 364 HAS CORROSION BETWEEN STR 26L & 26R. REPAIRED IAW REO 601R-53-21-2276.SDR GLBA2012031902Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE FRAME AT FS 150.6 BETWEEN STRINGERS 2R AND 3R, .9" IN LENGTH. REPAIRED IAW EO 12-1900-53-016. MAJOR REPAIRSDR SWAA2012042403360Frame · corrodedFUSELAGE FRAME CORRODED AT BS 351.25, BETWEEN STR 27- AND STR 28L. REPAIRED FRAME PER SRM.SDR SWAA2012041002968Frame · corrodedFRAME CORRODED AT BS 767, BETWEEN STR 26L TO STR 27L. REPAIRED FRAME IAW SRM.SDR SWAA2012040902876Frame · crackedFRAME CRACKED AT BS 847, BETWEEN STR 12L TO STR 13L. REPAIRED FRAME IAW SRM.SDR DALA1216729262Frame · corrodedAFT CARGO STATION 1288 FRAME CORRODED ON UPPER SURFACE AND REAR SIDE. REPAIRED PER MD90 SRM 53-10-02 FIG 2.SDR DALA1216791606Frame · crackedCABIN FS 903 BETWEEN STR 20L - 21L FRAME INNER CHORD IS CRACKED AND IS BEING WORKED ON A PRI_(NRC 51497).SDR IPXA12572944Frame · crackedINSPECTION TYPE: C, MAIN CARGO COMPARTMENT BS 345, S10R, FRAME INNER CHORD BENT OTBD AND CRACKED. REPAIRED FRAME IAW EA 120421 IR EO B757-5310-46712 -A.SDR SWAA2012032602583Frame · crackedFRAME INNER CHORD CRACKED AT BS 616, LBL 65. REPAIRED CHORD PER EA.SDR DALA1216739262Frame · corrodedFRAME AT STATION 1307 CORRODED FROM 27L TO 28R. REPAIRED IAW MD90 SRM 53-10-02 FIG 2.SDR CALA2012031900193Frame · crackedLT FRAME AT STA 520 CRACKED. REPAIRED FRAME AT STA 520 LT PER ECRA 5310-05473.SDR CALA2012031900192Frame · crackedLT FRAME AT STA 480 CRACKED IN RADIUS. REPAIRED FRAME AT STA 480 PER AVO CGH-12-03-06-1A ECRA 5310-05473.SDR CALA2012031900191Frame · crackedLT FRAME AT STA 827 CRACKED IN THE RADIUS. REPAIRED FRAME AT STA 827 LT PER ECRA 5310-05473.SDR CALA2012031900190Frame · crackedRT FRAME AT STA 787 CRACKED IN THE RADIUS. REPAIRED FRAME AT STA 787 PER ECRA 5310-05473.SDR CALA2012031900189Frame · crackedLT FRAME AT STA 727D CRACKED. REPAIRED FRAME AT STA 727 D PER ECRA 5310-05473.SDR IPXA12572968Frame · damagedINSPECTION TYPE: C, MAIN CARGO RT SIDE FRAME AT BS 600, STR 16R+3 DAMAGED. REMOVED DAMAGE AND REPAIRED FRAME IAW EA 120422 IR EO B757-5310-46713-A.SDR IPXA12572945Frame · damagedINSPECTION TYPE: C, MAIN CARGO RT SIDE FRAME AT BS 580, STR 16R+3 DAMAGED. REPAIRED FRAME IAW EA 120419 IR EO B75 7-5310-46711-A.SDR IPXA12572941Frame · damagedINSPECTION TYPE: C, MAIN CARGO BS 1580 FRAME, INBD FLANGE, INBD SURFACE DAMAGE BELOW S15R, REPAIRED FRAME INBD FLANGE, INBD SURFACE BELOW STR 15R IAW EA 1204 77 IR EO B757-5310-46718-A.SDR IPXA2572872Frame · dentedINSPECTION TYPE: C, MAIN CARGO BAY, RT SIDE FRAME AT BS 520 S16R DENTED. REPAIRED MAIN CARGO BAY IAW EA 120420 IR AND EO B B757-5310-46701-A.SDR CHQA20120316099Frame · crackedDURING INSPECTION THE LEFT AND RIGHT FRAME 10 WERE FOUND TO BE CRACKED. MAINTENANCE REPLACED THE LEFT AND RIGHT FRAME 10. THE NEW PARTS WERE INSTALLED WITH A SOLD RIVET IN ACCORDANCE WITH SRM 51-40-02.SDR CHQA20120316098Frame · crackedDURING INSPECTION THE LEFT AND RIGHT FRAME 10 WERE FOUND TO BE CRACKED. MAINTENANCE REPLACED THE LEFT AND RIGHT FRAME 10. THE NEW PARTS WERE INSTALLED WITH A SOLD RIVET IN ACCORDANCE WITH SRM 51-40-02.SDR SROM201203200012Frame · damagedDAMAGED FRAME AT BS 867 S26R.SDR SROM201203160001Frame · damagedDAMAGE /DRILL START ON FRAME.SDR SROM201203200011Frame · crackedFRAME CRACKED AT AIR CONDITIONING BRACKET.SDR SROM201203200010Frame · crackedCRACKED FRAME AT AIR CONDITIONING SUPPORT BRACKET.SDR USAA2012032000002Angle · crackedC4 CHECK - CRACK ON FORWARD SIDE OF FRAME L-ANGLE AT BS 350, S7L. REPLACED FRAME L-ANGLE AT BS 350, S7L IAW B757 SRM 51-40-10.SDR SWAA2012041203056Frame · crackedSTUB FRAME CRACKED AT BS 296.5, STR 7R. REPAIRED FRAME IAW E/A AND E/O.SDR IPXA2572799Frame · dentedINSPECTION TYPE: C, AFT CARGO BAY BS 1320, S26L, FRAME DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07-2R 5 DETAIL 1. REPAIR DOUBLER FABRICATED AND HEAT TREATED TO T6 CONDITION.SDR FDEA201203150950Frame · dentedFRAME BS 1741 LONGERON 11 LEFT, FOUND DENTED. REPAIRED IAW SRM 53-00-07, FIG 201, REV 48. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100, REV 114.SDR FDEA201203150949Frame · dentedFRAME BS 1661 LONGERON 11 LEFT, FOUND DENTED. REPAIRED IAW SRM 53-00-07, FIGURE 201, REV 48. REPAIR CLASSIFIED AS MAJOR, GMM 6-2-100, REV 114.SDR FDEA201203150954Frame · dentedDENT ON AFT CARGO BAY FRAME BS 1420 BETWEEN S25-26L. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-07 FIG 101, NO DENTS ALLOWED. R & R FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR DALA1216310180Strap · crackedFS 955 LT REAR SPAR BULKHEAD FTG ATTACH FAIL SAFE STRAP IS CRACKED AND REPAIRED PER ERA 500331-14AD REV ORG. REF NR 50642 AND NR 50641 FOR "T" FITTING REPLACEMENT AT SAME LOCATION.SDR AALA20120315017Frame · crackedFRAME CRACKED AT AIR CONDITIONING SUPPORT FITTING AT STATION 380.STRINGER 9 RIGHT. INSTALLED REPAIR ANGLE PER ECO J1159-0007.SDR FDEA201203150953Frame · dentedDENTS ON AFT CARGO FRAME BS 1460, LT SIDE BETWEEN STR 25-26L. FOUND TO BE NOT ALLOWED IAW SRM 53-00-07, FIG 101, DETAIL II. R & R FRAME IAW SRM 51-40-02. MAJOR REPAIR.SDR IPXA2572884Frame · dentedINSPECTION TYPE: C, FWD CARGO RT SIDE FRAME AT BS 840 AT S22R IS DENTED. REMOVED DAMAGE AND REPAIRED IAW SRM 53-00-07- 2R5.SDR IPXA12572779Frame · dentedINSPECTION TYPE: C, FWD CARGO LEFT SIDE FRAME AT S 680 BETWEEN S24L AND S25L DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07-2R5 REV 83 DETAIL III.SDR IPXA12572778Frame · dentedINSPECTION TYPE: C, FWD CARGO RT SIDE FRAME AT BS 720 BETWEEN S24R AND S25R DENTED. REMOVED DAMAGE AND REPAIRED FRAME IAW SRM 53-00-07-2R5 REV 83 DETAIL III.SDR IPXA12572777Frame · dentedINSPECTION TYPE: C, FWD CARGO RT SIDE FRAME AT BS 820 AT S22R DENTED. REMOVED AND REPAIRED FRAME IAW SRM 53-00-07-2R5, REV 83, DETAIL II.
Back to JASC 5311