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 FDEA201301250176Frame · dentedAFT CARGO BAY RT FRAME AT STA BS 1340 BETWEEN STRINGER 26-27R, DENTED. REMOVED FRAME IAW SRM 51-40-02. FABRICATED FRAME IAW DWG 146N1028, LOCATED AND DRILLED IAW SRM 51-40-05. INSTALLED LOWER FRAME IAW SRM 51-40-02 AND DWG 146N1008. MAJOR REPAIR.SDR FDEA201301250175Frame · gougedMAIN DECK CARGO FRAME AT BS 760, FROM STRINGER S8-S9R, GOUGED. FOUND OUT OF LIMITS IAW SRM 53-00-07, FIG 101 AD 2. REPAIRED FRAME IAW SRM 53-00-07, FIG 201, REPAIR NR 3. THIS IS A CAT 'B' REPAIR.SDR FDEA201301250174Frame · gougedMAIN DECK CARGO FRAME AT BS 780, FROM STRINGER S8-S9R, GOUGED. REPAIRED FRAME IAW SRM 53-00-07, FIG 201, REPAIR NR 3. THIS IS A CATEGORY "B" REPAIR. REPAIR LOCATED AT STA 780.SDR QXEA2013012400128Frame · corrodedFRAME 71.2 FLANGE IS CORRODED STR 32S-31S. REMOVED NECESSARY RIVETS AND REMOVED CORROSION IAW RD 8/4-53-22344 AND SRM 51-42-05-02-01. CONFIRMED CRACK FREE REF NTM 51-00-06-910-801 PT 1. MIN REMAINING THICKNESS .037" REF DTM PT 1 51-00-04-910-801. INSTALLED RSDR QXEA2013012400127Frame · corrodedFRAME 71.2 FLANGE IS CORRODED, STRINGER 32P-31P. REMOVED NECESSARY RIVETS AND REMOVED CORROSION IAW RD 8/4-53-2344 AND SRM 51-42-05-02-01, MIN REMAINING THICKNESS .042", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1. INSTALLED SDR QXEA2013012400126Frame · corrodedFRAME 32.4 HAS CORROSION ON THE FORWORD SIDE OTBD OF STRINGER 32P. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN THICKNESS NOTED .039", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1. FRAME WAS FOUND TO BE IN LIMITS IAW RD 8/4-SDR QXEA2013012400124Frame · corrodedFRAME 1.0 UPPER FLANGE IS CORRODED STR 32P-33. REMOVED NECESSARY RIVET AND BLENDED OUT CORROSION IAW SRM 51-42-05-02-01, AND 51-21-00-00-02. NOMINAL THICKNESS .050" AND NO REPAIRS ALLOWED IAW SRM 53-20-15-00-01. MIN THICKNESS NOTED .050" CONFIRMED CRACK FRSDR AALA20130124002Beltframe · corrodedLOWER INNER FLANGE OF BELTFRAME CORRODED AT STATION 1250 BETWEEN LONGERONS 29 LEFT AND 29 RIGHT. INSTALLED FRAME DOUBLER PER AARD 53-10-00-14.SDR CALA2013012500060Frame · crackedCABIN FRAME STA 480 BETWEEN STRINGERS 8-9R IS CRACKED AT SUPPORT BRACKET. CUT OUT DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES IAW EA 5310-04716, REV D.SDR CALA2013012500055Frame · crackedCABIN FRAME BS 440 BETWEEN STRINGERS 8-9R IS CRACKED AT SUPPORT BRACKET. CUTOUT DAMAGE, FABRICATED AND INSTALLED REPAIR ANGLES IAW EA 5310-04716 RE D.SDR FDEA201301240171Frame · corrodedAFT CARGO BAY LT SIDE, BS 1300 FRAME CORRODED AT STR 27L. REMOVED CORROSION IAW SRM 53-00-07, FIG 101, DETAIL II, FOUND OUT OF LIMITS. REMOVED DAMAGED FRAME AND INSTALLED FABRICATED FRAME IAW SRM 51-40-02. CAT "A", MAJOR REPAIR.SDR WX0A071495Frame · corrodedE&E BAY COMPARTMENT FRAME AT FS 200 CORRODED AT AFT SIDE BETWEEN L28L AND L28R. CUT OUT DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED.SDR SWAA2013031513687Frame · crackedFUSELAGE FRAME CRACKED AT STA 727, STR 18R. REPAIRED FRAME PER EA.SDR AALA20130213001Frame · dentedDENT ON TOP OF FRAME AT STATION 580 BETWEEN STRINGERS 24 AND 25 LEFT. ACCOMPLISHED FRAME REPAIR SPLICE PER SRM 53-00-07-2R 5 DETAIL 3.SDR QXEA2013012300110Frame · corrodedX196 FRAME FLANGE HAS CORROSION BETWEEN STRINGERS 28P AND 29P. REMOVED RIVETS COMMON TO FRAME FLANGE AND STRINGER IAW SRM 51-42-05-02-01, REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS NOTED .038", CONFIRMED AFFECTED AREA CRACK FREE REF NTM 51-SDR QXEA2013012300109Frame · corrodedX196 FRAME FLANGES AND VERTICAL LEG HAVE CORROSION BETWEEN STRINGERS 30P AND 33. REMOVED RIVETS COMMON TO FRAME FLANGE AND STRINGER IAW SRM 51-42-05-02-01, REMOVED CORROSION IAW RD 8/4-53-2344. MIN REMAINING THICKNESS NOTED .032", CONFIRMED AFFECTED AREAS CRASDR QXEA2013012300108Frame · corrodedX196 FRAME FLANGES AND VERTICAL LEG HAVE CORROSION BETWEEN STRINGERS 30S AND 33. REMOVED RIVETS COMMON TO FRAME FLANGE AND STR IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW RD 8/4-53-2344 MIN REMAINING THICKNESS NOTED .026, CONFIRMED AFFECTED AREAS CRACK FRESDR QXEA2013012300103Frame · corrodedCORROSION ON MATING SURFACE OF FRAME 49.5 AND STANCHION, STR 31S. STANCHION FOUND TO BE OUT OF LIMITS IAW SRM 53-20-43-00-01, NO DAMAGE ALLOWED. MATCH DRILLED NEW STATION IAW SRM 51-42-05-02-01.SDR AALA20130123007Frame · wornFOUND WEAR MARK ON FRAME AT STATION 231 AT 6 O`CLOCK POSITION. INSTALLED REPAIR ANGLE.SDR DALA1301770172Frame · crackedFWD CARGO DOOR CUTOUT AFT FRAME FOUND CRACKED AT FS 615, RBL 65. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 3.SDR CALA2013012500054Frame · crackedCABIN FRAME BS 727B R STRINGERS 8-9R IS CRACKED AT SUPPORT BRACKET. CUT-OUT DAMAGE AREA AND INSTALLED REPAIR ANGLE A AND B IAW EA5310-04716, REV. D.SDR CALA2013012500053Frame · corrodedCORROSION ON UPPER SURFACE OF FRAME BS 986.5 APPROX LBL 48 TO RBL 48. REPAIRED IAW SRM 53-70-51, TABLE 201, REPAIR 4. REPAIRED SRM 53-70-51, TABLE 201, REPAIR 4.SDR CALA2013012500051Frame · crackedCABIN FRAME BS 500A R BETWEEN STRINGERS 8-9R IS CRACKED AT SUPPORT BRACKET. INSTALLED REPAIR ANGLES ON FUSELAGE FRAME IAW EA 5310-04716, REV D.SDR SWAA2013012511822Frame · crackedEXTERNAL POWER DOOR AFT SIDE OF FRAME CRACKED BY MIDDLE LATCH STRIKER PLATE. REPAIRED PER SRM 53-10-15-1A-4.SDR WX0A071494Frame · corrodedAFT CARGO PIT FRAME AT STATION 1099 CORRODED AT LONGERON 29R 3029L ATTACH POINT. REMOVED DAMAGED AREA, FABRICATED REPAIR PARTS AND INSTALLED.SDR CALA2013012300049Frame · crackedCABIN FRAME, STA 400R BETWEEN STRINGERS 8-9R IS CRACKED AT SUPPORT BRACKET CUT OUT. DAMAGED AREA, FABRICATED, TREATED, PRIMED, AND INSTALLED REPAIR ANGLES, REF EA 5310-04716, REV D, FIG 3.SDR SWAA2013031513686Frame · crackedFUSELAGE FRAME CRACKED AT STA 727, STR 18L. REPAIRED FRAME PER EA.SDR ASOA2013030703114Frame · corrodedFRAME BS 333 CORRODED AT S27. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01 AND 51-42-06-001-001-A0. DAMAGE IS NOT PERMITTED ON FRAME IAW SRM 53-21-06-101-002-A01,-006-A01. COMPLIED WITH REO 670-53-21-826 AND REO 670-53-21-926.SDR ASOA2013030703113Frame · corrodedFRAME BS 319.70 CORRODED BETWEEN STGR 26L AND 27. REMOVED FRAME 319.70 STR21L-23R IAW SRM 51-42-06-001-001-A01. INSTALLED NEW SERVICEABLE FRAME AT FS319.0, STGR23L TO STGR23R IAW SRM 51-40-11-00-001-001-A01 AND 51-42-06-001-001-A01.SDR ASOA2013030703112Frame · corrodedFRAME 310 CORRODED BETWEEN STGR 26RT & 26LT. REMOVED CORROSION FROM PREVIOUSLY TREATED AREA IAW SRM 51-21-26-001-001-A01 FROM FS 310 BETWEEN STGR 26 RT AND 26 LT. COMPLIED WITH STEP 1 REO 670-53-21-923.SDR ASOA2013022103055Frame · corrodedFRAME BS 295 CORRODED AT S27 FWD & AFT SIDES. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01. COMPLIED WITH REO 670-53-21-922.SDR DALA1304626704Frame · dentedFRAME DENTED AT BS 600. REPAIRED IAW SRM 53-00-07, FIG 201, REPAIR 5 TO 108/100.SDR SWAA2013020712384Frame · crackedFRAME CRACKED AT RAIL SUPPORT FITTING, BS 480, STR 8 LT. REPAIRED CRACKED FRAME AT RAIL SUPPORT FITTING, BS 480, STR 8 LT IAW EA 1-A53-121114.SDR SWAA2013020712383Frame · crackedFRAME CRACKED AT RAIL SUPPORT FITTING, BS 747, STR 8 RT. REPAIRED FRAME AT BS 747, STR 8 RT PER EA 1-A53-12114 7020U 26JAN13.SDR SWAA2013013112181Frame · crackedFRAME CRACKED AT RAIL SUPPORT FITTING, BS 360, STR 8 RIGHT. REPAIRED FRAME AT BS 360 STR 8 RT PER ER 13-01279 AND EA 1-753-21590.SDR SWAA2013012912073Frame · crackedFRAME CRACKED AT RAIL SUPPORT FITTING, BS 400, STR 8 LEFT. REPAIRED FRAME AT BS 400 STR 8 LT PER EA1-A53-12114R2 7020U 25JAN13SDR SWAA2013012811991Frame · crackedFRAME CRACKED AT RAIL SUPPORT FITTING, BS 787, STR 8 RIGHT. REPAIRED FRAME BS 787 STR 8RT PER EA 1-A53-12114.SDR SWAA2013012811990Frame · crackedFRAME CRACKED AT RAIL SUPPORT FITTING, BS 400, STR 8 RIGHT. REPAIRED CRACKS FRAME AT BS 411 STR 8 RT IAW EA 1-A53-12114 R2.SDR SWAA2013012811989Frame · crackedFRAME CRACKED AT RAIL SUPPORT FITTING, BS 867, STR 8 LEFT. REPAIRED FRAME AT BS 867, STR 8 LEFT PER EA 1-A53-12114 7020U 24JAN13.SDR SWAA2013012811988Frame · crackedFRAME CRACKED AT RAIL SUPPORT FITTING, BS 867, STR 8 RIGHT. REPAIRED CRACKS FRAME AT BS 867 STR 8RT IAW EA 1-A53-12114.SDR USAA2013012800020Frame · crackedQ6 CHECK - CRACK ON FUSELAGE FRAME AT BS 500G BETWEEN S20L TO S21L. REPAIRED FUSELAGE FRAME AT BS 500G BETWEEN S20L TO S21L IAW B737 SRM 53-00-07-2R-13.SDR QXEA2013012100098Frame · corrodedBS 564.5 FRAME FLANGE HAS CORROSION BETWEEN STRINGERS 31S AND 32S. REMOVED NECESSARY RIVETS FOM IAW SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. MIN THICKNESS NOTED .047", CONFIRMED CRACK FREE REF NTM 51-00-04-910-801 PT 1 AND 51-00-06-910-801SDR QXEA2013012100087Frame · corrodedBS 321 FRAME FLANGE HAS CORROSION BETWEEN STR 32P & 33. REMOVED NECESSARY RIVETS AND BLENDED CORROSION IAW SRM 51-42-05-02-01 AND 51-21-00-00-02. MIN THICKNESS .047" CONFIRMED CRACK FREE AREA REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801, PT 1. MATERIASDR QXEA2013012100086Frame · corrodedX529 FRAME FLANGE HAS CORROSION BETWEEN STR 31S & 32S. REMOVED NECESSARY RIVETS IAW Q400 SRM 51-42-05-02-01. REMOVED CORROSION IAW SRM 51-21-00-00-02. CONFIRMED CRACK FREE REF NTM 51-00-04-910-801, PT 1 AND 51-00-06-910-801 PT 1. MATERIAL LOSS FOUND IN LIMITS SDR DALA1301453741Frame · crackedFRAME CRACKED, COMMON TO PSU RAIL AT SUPPORT CLIP, STA 400 S8L REPAIRED IAW ERA 509144-14AD REV O.SDR DALA1301443741Frame · crackedRT PASSENGER CABIN STA 400, FRAME CRACKED AT STRINGER 8R. REPAIRED IAW ERA 509144-14AD REV O.SDR DALA1301433741Frame · crackedRT PASSENGER CABIN STA 440, FRAME IS CRACKED AT STRINGER 8R. REPAIRED IAW ERA 509144-14AD, REV O.SDR DALA1301413741Frame · crackedCABIN SIDEWALL FRAME CRACKED AT PSU RAIL SUPPORT CLIP, BS 480 S8L. REPAIRED IAW ERA 509144-14AD, REV O.SDR DALA1301403741Frame · crackedCABIN SIDEWALL FRAME CRACKED COMMON TO PSU RAIL SUPPORT CLIP BS 380 S8L. REPAIRED IAW ERA 509144-14AD.SDR CHQA20130120037Frame · gougedDURING INSPECTION, A GOUGE WAS FOUND IN FRAME 60 BETWEEN STRINGERS 4L AND 5L. THE FRAME WAS REPAIRED IN ACCORDANCE WITH SRM 53-00-04 AND SRM 53-00-01.
Back to JASC 5311