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 USAA2009101692784Frame · crackedSAL - MAJOR REPAIR - Q2 CHECK - CRACKED STUB FRAME AT BS 294.5, S6R - S17R, R1 DOOR CUTOUT AREA. REPAIRED STUB FRAME AT BS 294.5, S6R - S17R, R1 DOOR CUTOUT AREA IAW B737 SRM 51-30-11.SDR SWAA096633Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 320, STR 21L. REPAIRED FRAME PER SRM.SDR SWAA096618Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 807, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096617Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 727C, STR 8L. REPAIRED FRAME PER EA.SDR SWAA096611Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 294.5, STR 9L. REPAIRED FRAME PER SRM.SDR SWAA096610Frame · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME WEB CRACKED AT BS 294.5, STR 8L. REPAIRED FRAME PER SRM.SDR SWAA096602Skin · crackedDURING SCHEDULED 22Y CHECK, FOUND FRAME CRACKED AT BS 336.5, STR 21L. REPAIRED SKIN PER SRM.SDR SWAA096588Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 8L. REPAIRED FRAME PER EA.SDR SWAA096587Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 520, STR 13L. REPAIRED FRAME PER EA.SDR COEA2009101404821Frame · corrodedHEAVY CHECK: MAJOR REPAIR: LIGHT SURFACE CORROSION ON FRAME 44 AFT SIDE AT BLO. REMOVED FRAME SECTION TO REMOVE CORROSION. CORROSION REMOVED. PERFORMED FRAME SPLICE TO ACCESS CORROSION PER ATR SRM.SDR SWAA096544Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096543Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 727B, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096542Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 827, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096541Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 500A, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096540Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 480, STR 8R. REPAIRED FRAME PER EA.SDR SWAA096539Frame · crackedDURING SCHEDULED 14Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8R. REPAIRED FRAME PER EA.SDR USAA2009101492770Frame · crackedCRACK ON FUSELAGE FRAME AT BS 500, LBL 4, REPAIRED FUSELAGE FRAME AT BS 500, LBL 4 IAW EA 101431. (K)SDR FDEA200910123625Frame · corrodedE AND E COMPARTMENT BS 400 STR 19R CORROSION NEXT TO TOOLING HOLES. REMOVED CORROSION AND FOUND OUT OF LIMITS, CUT OUT DAMAGED AREA DIMS 1" DIAMETER, FABRICATED NEW FRAME REPAIR USING 7075-0 .050 PO NR 29016223, DIMS 9 3/4" X 5 1/2", HEAT TREATED PART TO T6SDR DL757091627Frame · corrodedDURING SCHEDULED PSV CHECK, MX FOUND CORROSION ON THE STA 1460 FRAME BETWEEN STRINGERS 29L AND 29R. MX PERFORMED A REPAIR TO THE FRAME IAW ERA 477433-14.SDR SWAA096504Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FRAME CRACKED AT BS 500A, BETWEEN STR 21L TO STR 22L. REPAIRED FRAME PER SRM.SDR SWAA096492Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 500C, STR 8L. REPAIRED FRAME PER EA.SDR SWAA096491Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 440, STR 8L. REPAIRED FRAME PER EA.SDR SWAA096490Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND FRAME CRACKED AT BS 867, STR 13R. REPAIRED FRAME PER EA.SDR SWAA096486Frame · crackedDURING SCHEDULED 12Y CHECK, FOUND FWD LOWER STUB FRAME CRACKED AT BS 295.5, STR 17R. REPAIRED FRAME PER SRM.SDR QXEA2009101300781Frame · damagedDURING INSP FOUND TOOLING DAMAGE OF FS 597 FRAME ATTACH FLANGE BETWEEN STR 23R AND 22R. REMOVED RIVETS FOR FOM, BLENDED OUT TOOLING MARKS AND PERFORMED LPI IAW SRM 51-42-06, 51-21-06 AND NDTM 51-20-006. TREATED, PRIMED, INSTALLED RIVETS AND PAINTED WORKED ARSDR QXEA2009101300780Frame · corrodedDURING INSP, FOUND CORROSION AT FS 597 ON FRAME ATTACH FLANGES AT STR 27 RBL4"- LBL4". REMOVED RIVETS ALONG FRAME IAW SRM 51-42-06-001-001-A01. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01 FOUND TO BE WITHIN LIMITS IAW 53-31-06-101-003-A01. TREATED, PRIMESDR SWAA096519Frame · corrodedDURING SCHEDULED OTS CHECK, FOUND FRAME CORRODED AT BS 767, BETWEEN STR 27L TO STR 27R. REPAIRED FRAME PER SRM.SDR SWAA096518Frame · corrodedDURING SCHEDULED OTS CHECK, FOUND FRAME CORRODED AT BS 747, STR 27L. REPAIRED FRAME PER SRM.SDR ASAA0976785Frame · dentedDENTED FRAME BS 727B STR 23 RT. REPAIRED DENT.SDR UALA2009101203195Frame · crackedAFT CARGO COMPARTMENT, FRAME CRACKED STA 1351, STR 26R AND 25R. MAJOR REPAIR ACCOMPLISHED. CUT OUT DAMAGED SECTION OF FRAME WEB, FABRICATED & INSTALLED REPAIR PLATE (DOUBLER), -14 STIFFENER AND FILLERS.SDR C2XA09SH328Frame · corrodedSHV - DURING C-CHECK FRAME 65 STR 17L-16L NUT PLATE HOLE AT EDGE HAS CORROSION (LEVEL 2 LOCAL). MAINTENANCE PERFORMED REPAIR OF FRAME 65 STR 17L-16L NUT PLATE HOLE AT EDGE IAW EMB-145XR EC5310-01479. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWIA200923479Frame · crackedC-CHECK - FS 559 PRESSURE BULKHEAD FRAME CAP ANGLE RADIUS CRACKED. REPAIRED PER REO.SDR DLM88091611Frame · crackedDURING HMV A CRACK WAS FOUND ON FUSELAGE FRAME OVERWING STA Y=864 X=-52 RT. FRAME WAS REPLACED IAW DWG SR09530282.SDR WX0A070432Frame · crackedFRAME CRACKED AT STATION 886 IN RADIUS, ADDRESSED AS REQUIRED.SDR IPXA09557701Frame · gougedINSPECTION TYPE:C2 FRAME UPPER FLANGE DAMAGED AFT CARGO BAY STA 1360 STR 23L. REPAIRED FRAME PER SRM 53-00-07-2R5.SDR USAA2009101692785Frame · crackedSAL - MAJOR REPAIR - Q2 CHECK - CRACKED FRAME AT BS 616, S17R. REPAIRED CRACKED FRAME AT BS 616, S17R IAW TYPICAL REPAIR 53-62-01.SDR ASOA200901120Frame · corrodedON 559+96 FRAME BETWEEN S26-27L HAS CORROSION LOWER FRAME. REMOVED FRAME PER SRM 51-42-06. INSTALLED NEW FRAME STRINGERS PER SRM 51-42-06.SDR ZZDA2009292Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 4. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW TASK CARD 17-5310-2989.SDR QXEA2009101200772Frame · corrodedDURING INSP FOUND CORROSION OF FS629 FRAME ATTACH FLANGE AT STR 27 TO RBL 6". REMOVED FASTENERS FOR FOM. CLEANED AND BLENDED CORROSION IAW SRM 51-21-06. ORIGINAL MATERIAL .063" MATERIAL REMOVED .005, REMAINING THICKNESS .058", WITHIN LIMITS IAW SRM 53-31-0SDR IPXA09557760Frame · crackedINSPECTION TYPE:C2 WHILE ACCESSING AFT CARGO BAY LT SIDEWALL SUPPORT STRUCTURE FOUND FRAME CRACKED AT BS 1400 STR 20L. REPAIRED CRACKED FRAME AT BS 1400 STR 20L IAW SRM 53-00-07-2R SRM 51-40-02-0G AND ER NR 09-5026.SDR WX0A070431Frame · corrodedSTA 1309 - L28R - L28L, CORROSION ON FRAME. REPAIRED PER AMERICAN AIRLINES AARD 53-10-00-14 WITH ESO 80559 APPROVAL DATE 10-8-09.SDR FDEA200910093527Frame · corrodedBULK CARGO COM, STA 1500 BETWEEN STR 28L-29L, WL 138 FRAME CORRODED AND HAVE MISSING SHEAR TIE. FRAME FOUND OUT OF LIMITS IAW SRM 53-60-07 FIG 101 DET 1, REMOVED 2 EA, INTERCOSTAL AND REINSTALLED IAW SRM 51-40-02. REMOVED AND REPLACED FRAME ASSY STA 1500 BETSDR F3LA2009100900198Frame · corrodedDURING C4 C-CHECK, INSP NOTED AFT PIT FRAME 52 CTR TIE DOWN POINT HAS EVIDENCE OF CORROSION AT FASTENER HOLES. MX REMOVED AND REPLACED PLATE IAW SRM 51-42-11, SRM 53-41-14, SRM 51-31-00 AND SRM 51-72-11.SDR ZZDA2009310Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 4. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW TASK CARD 17-5310-2989.SDR ZZDA2009309Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW TASK CARD 17-5310-2980.SDR AALA20091019TUL07Frame · crackedFRAME CRACKED AT STATION 1418 AT LONGERON 2 RIGHT. INSTALLED DOUBLER PER ENGINEERING AUTHORITY MD80-53-007708 DATED 10-8-09.SDR ZZDA2009266Frame · damagedINSTALLED FRAME REPAIR PARTS AT STA 180 BETWEEN LONGERON 22R AND 24R PER EA 17-53-02050IR DATED 09/28/09, B717 SRM 53-20-07, 53-20-07 PAGE 20, 51-41-05 AND 51-41-02. SEE NR 3245 AND 2233.SDR ZZDA2009262Frame · damagedEO 17-5310-2895 AFT RIGHT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, RIGHT SIDE IAW AIRTRAN TASK CARD 17-5310-2990.SDR ZZDA2009261Frame · damagedEO 17-5310-2937 AFT LEFT STA 1178 CANTED FRAME INSPECTION IDENTIFIED CONFIGURATION 2 CONDITION 5. ACCOMPLISHED REPAIR TO AFT FUSELAGE FRAME CAP, CANTED STA 1178.225, LEFT SIDE IAW AIRTRAN TASK CARD 17-5310-2980.SDR FDEA200910083520Frame · damagedMAIN CABIN BS 1040 STR 8L FRAME HAS ELONGATED HOLE. ELONGATED HOLES (2 EA) ON CABIN BS 1040 STR 8L FRAME REPAIRED IAW STA EA 757-5340-08-E0458. (REF EA F-5340-132623 : ELONGATED HOLES ON BS 1040 REAR SPAR BULKHEAD -REPAIR). REPAIR IS CLASSIFIED AS MAJOR ALTE
Back to JASC 5311