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 AALA20110210AFW01Frame · dentedDENT DAMAGE TO THE STATION 500 FUSELAGE FRAME INNER CHORD BETWEEN STRINGERS 30 TO 31 LEFT. DAMAGE REPAIRED ON EA B767-53-014931.SDR DALA1109899857Frame · crackedAFT ACCESSORY COMPARTMENT CANTED FRAME 1245 CRACKED AT FASTENER HOLE L4L. REMOVED DAMAGED CANTED FRAME 1245 IAW SRM 51-30-2 & 51-30-5. LOCATED, DRILLED, & INSTALLED NEWFRAME IAW SRM 51-30-2, 51-30-5. REQUIRED INSP COMPLETED.SDR DALA1109750178Frame · crackedLEFT FS 1809 OUTER CHORD INNER FLANGE CRACKED AT 1 EA FASTENER HOLE AND REPAIRED IAW EA 01-074914-12, ME 07, REV S.SDR CALA2011021000079Frame · crackedCABIN INTERIOR FRAME CRACKED AT PSU RAIL ATTACH POINT STA 1580 BETWEEN S-8R AND S-9R (MARKED). REPAIRED FRAME AT STA 1580 BETWEEN S-8 AND S-9R PER ECRA 5310-05353.SDR FOTR2022201681Frame · dentedMAIN CABIN - FRAME DENTED AT BS 380 BETWEEN STRINGER 5R AND STRINGER 6R. CUTOUT DENTED AREA DIM. 2.75" X 2" AT BS 380 STRINGER 5R-6R IAW SRM 51-40-3, FABRICATED REPAIR DOUBLER DIM 12" X 5" .050 AND FILLER 2.75" X 2" .050 PO 90010501 IAW SRM 51-40-3. HEAT TREATSDR CA110209031Frame · cracked(CAN) DURING 24 YEAR INSP, A CRACK IN THE TOP CTR MEMBER OF THE LOWER PRESSING WAS FOUND.SDR USAA2011021490717Doubler · corrodedCLT - MAJOR REPAIR - Q3 CHECK - LEVEL 2 EXFOLIATION CORROSION ON FRAME DOUBLER AT FR 794, S25R. INSTALLED NEW FRAME DOUBLER AT FR 794, S25R IAW B737 SRM 51-40-02.SDR REXA201100098Frame · corrodedFUSELAGE FRAME CORRODED AT FS 605.00 FROM STR 26L TO 26R. REMOVED AND REPLACED FUSELAGE FRAME AT FS 605.0 IAW CRJ SRM 51-42-06 & 51-42-21.SDR DALA1109489857Frame · crackedAFT ACCESSORY COMPARTMENT AFTER REMOVAL OF CANTED 1245 FRAME, CHANNEL CRACKED. STOP DRILLED CRACK, HFEC INSPECTED IAW NDT SPM 06-10-01. FOUND CRACK CONTAINED, FABRICATED REPAIR PARTS USING AND INSTALLED IAW IAW SRM 53-01, FIG 2. REQUIRED INSP COMPLETED.SDR AALA20110209TUL01Frame · damagedSTATION 1463 FRAME WEB NEAR LONGERON 3 LEFT DAMAGED. DOUBLER INSTALLED PER EA MD80-53-15174.SDR DALA1120106904Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1620 ABOVE STR 25L. REPAIRED AT SAA DURING HMV ON N/R CARD 173241.SDR ASOA201100330Frame · corrodedFRAME FS 349.00 HAS CORROSION FROM STR 25L TO STR 25R. INSTALLED 6 EA SAME NUTPLATES ON DRAIN MAST NUTPLATES. INSPECTED AND FOUND TO BE IN SERVICEABLE CONDITION IAW SRM 51-42-06 AND 51-45-00. REINSTALLED SAME SERVICEABLE INTERCOSTAL AT STR 25L IAW SRM 51-42SDR DALA1112589987Frame · damagedAFT ACCY COMP BETWEEN L9L ND L10L AT STA 1245 FRAME HAS MISDRILLED HOLE. REMOVED AND REPLACED SHEARTIE IAW DC9 SRM 53-03 FIG 3. REPAIRED DAMAGED FRAME IAW DC9 SRM 53-03 FIG 4. REPAIRED FRAME ANGLE IAW DC9 SRM 53-01 FIG2 SHT 4.SDR DALA1111699223Frame · corrodedAFT CARGO COMPARTMENT STA 1344 BETWEEN STR 29RT AND STR 29 LT CIRCUMFERENTIAL WITH CORROSION (KM 11-16). COMPLIED WITH AT AAR MIAMI ON W/O 2003107 ITEM 0106.SDR USAA2011021490722Frame · crackedCLT - MAJOR REPAIR - Q3 CHECK - CRACKED FRAME AT BS 827, S8R - S9R. REPAIRED FRAME AT BS 827, S8R - S9R IAW EA 102588.SDR SWAA110823Frame · crackedDURING SCHEDULED 2HC1 CHECK, FOUND FRAME CRACKED AT BS 380, 5, STR 19R. REPAIRED FRAME PER SRM.SDR ASOA201100245Frame · corrodedFUSELAGE FS 364.00 HAS CORROSION FROM STR 25L TO 25R. REMOVED LIGHT CORROSION IAW SRM 51-21-06, STEPS 3B1 THROUGH 5. FOUND TO BE WITHIN LIMITS IAW SRM 53-21-15 AND 53-00-00.SDR CALA2011020800072Frame · crackedFRAME IS CRACKED AT O/H BIN RAIL STA 360 S-8L. INSTALLED REPAIR DOUBLERS IN REF ECRA 5310-05351.SDR FOTR2022201989Frame · dentedSTA 1166, STR 16R FRAME DENTED. CUTOUT DAMAGED AREA AT STA 1166, STR 16R, DIM.1.6" X 1.75" IAW SRM 51-40-3, FIG 1. FABRICATED DOUBLER FROM 7075T6 .063" DIM 4" X 9" IAW SRM 51-40-3, FIG 1, PO 90010179. INSTALLED FRAME REPAIR AT BS 1166, STR 16R IAW SRM 51-40SDR DALA1120166904Frame · dentedAFT CARGO FRAME DENTED ON UPPER FLANGE STA 1400 BETWEEN STR 25 AND 26L. REPAIRED AT SAA DURING HMV ON N/R CARD 173141.SDR USAA2011021490750Frame · crackedCLT - MAJOR REPAIR - Q2 CHECK - CRACKED FRAME AT BS 727B, S8L-S9L. REPAIRED FRAME AT BS 727B, S8L-S9L IAW EA 102619.SDR EOPA020711407ALFrame · cracked1.5 INCH CRACK IN THE FRAME AT STATION 231.5.SDR DALA1117549223Frame · corrodedHMV2 RT WHEEL WELL FWD CUTOUT FRAME CORRODED. REPLACED FRAME PER SRM 51-30-02.SDR CALA2011020700066Frame · crackedFRAME IS CRACKED AT O/H BIN RAIL STA 400 S-8L. INSTALLED REPAIR DOUBLERS AT O/H BIN RAIL STA 400 STR 8L REF EA 5310-04498 REV A.SDR DALA1115199223Frame · corrodedRT WW FWD CUTOUT FRAME AND BRACKETS HAVE CORROSION AT INBD AREA. COMPLIED WITH ON NON-ROUTINE W/O 2003107, ZONE1000, ITEM 0159. R & R FRAME IAW 51-30-2.SDR FDEA201102050479Frame · gougedFRAME GOUGED AT STA 239 RBL 11 TO 20. REMOVED GOUGES IAW SRM 51-10-02. MEASURED OUT OF LIMITS. FRAME FOUND DENT, DENT NOT ALLOWED FIG 101 PG 101 IAW SRM 53-00-07. RECEIVED FRAME ON TRAVLER T11/867390. INSTALLED FOM PAST REMOVED FOR ACCESS IAW SRM 51-40-02SDR AALA20110205TUL03Frame · crackedTHE 1510 CANT FRAME CRACKED ABOVE LEFT LOWER TAIL CONE LATCH. INSTALLED DOUBLER PER EA MD80-53-015073 1/27/2011.SDR ASOA201100213Frame · corrodedFRAME FS 364.00 HAS CORROSION FROM STR 25L TO 25R. REPAIRED IAW SRM 51-42-06
SDR FDEA201102040475Frame · crackedCAC, FWD PRESSURE BULKHEAD RT SIDE MAIN FRAME CRACKED ALLTHE WAY THROUGH AT BS 1157 BETWEEN LONGERON 27R AND 28R. REMOVED DAMAGED PARTS, FABRICATED NEW PARTS AND TREATED PARTS IN ACCORDANCE WITH EA 8-5310-142572. INSTALLED PARTS AND SEALED AS REQUIRED PER SSDR ASOA201100216Frame · corrodedFUSELAGE FS 319.70 HAS CORROSION FROM STR 25L TO STR 25R. REMOVED CORROSION IAW SRM 51-21-06. FOUND TO BE OUT OF LIMITS IAW SRM 53-00-00. R & R FRAME 319.70 IAW SRM 51-42-06 & 51-42-21.SDR FDEA201102040471Frame · misrepairedREWORK OF NR N01483, REWORK REQUIRED ON FRAME, STA 1280 BETWEEN S11R AND S13R DUE TO REPAIR INSTALLED IAW INCORRECT SRM. R & R REPAIR AT STA 1280, BETWEEN S11R AND S13R IAW SRM 53-00-07, FIG 201, DETAIL 1 REPAIR 3. MAJOR REPAIR.SDR FDEA201102040470Frame · misrepairedREWORK OF NR N01479, REWORK REQUIRED ON FRAME STA 1280 AT STRINGER 11L DUE TO REPAIR INSTALLED IAW INCORRECT SRM. REMOVED EXISTING REPAIR AND INSTALLED NEW REPAIR SRM 53-00-07, FIG 201, DETAIL 1, REPAIR 3.SDR FOTR2022201865Frame · crackedSTATION 800, STRINGER 14R FRAME CRACKED. CUTOUT DAMAGED AREA DIM .8" X 1" IAW SRM 51-40-4 FIG 1, FABRICATED REPAIR ANGLE FROM 7075-0 .090" DIM. 9" X 1.9" IAW SRM 51-40-4 FIG 1 PO 9009880. HEAT TREATED REPAIR ANGLE 7075T6 IAW ENGINEERING REPORT 2-37153-801 RSDR FOTR2022201826Frame · damagedSTATION 400, FRAME AT STRINGER 16L INBD SIDE DOUBLER DRILLED. CUTOUT DAMAGED AREA DIM. 2.25" X 2" IAW SRM 51-40-3. FABRICATED REPAIR DOUBLER AND FILLER FROM 7075T6 .050 PO 90010944, DIM. DOUBLER 3.6" X 10" AND FILLER 2.25" X 2" IAW SRM 51-40-3. INSTALLED REPSDR FDEA201102030464Frame · misalignedSTA 540, INST. INBD AT THE STR CLIP AT STR 25 LT UNABLE TO LOCATE AND DRILL FASTENER HOLE FOR A YYT 8 FASTENER AND MAINTAIN PROPER E.D. ON THE DSS LOWER 540 FRAME, THIS CONDITION ALSO EXIST AT STA. 560, 520, 580 AND 600. STA 520, 540, 560, 580, 600. JUST INBDSDR IPXA1564953Frame · gougedINSPECTION TYPE:C1, SCREW STRIKE ON FRAME INNER FLANGE AT BS 660 BETWEEN 15R AND 16R. REPAIR IAW ATS ER NR 11-01428.SDR IPXA11564907Frame · damagedINSPECTION TYPE:C1, SCREW STRIKE ON FRAME INNER FLANGE AT BS 520 BETWEEN STRNGER 15R AND 16R REPAIRED IAW ER NR 11-01420, DATED 21FEB11.SDR USAA2011021890793Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 500B, S20L - S21L. REPAIRED FRAME AT BS 500B, S20L - S21L IAW EA 102621.SDR GLBA20110203FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, MX FOUND A CRACK IN THE FRAME AT FS 280.73 AT STRINGER 5R CUTOUT, .2" IN LENGTH. MAINTENANC PERFORMED ANOTHER INSPECTION ON THE AREA AND FOUND THE THE CRACK WAS A PEN MARK FROM ORIGINAL MANUFACTURE.SDR GLBA20110204FFrame · crackedMAJOR REPAIR - DURING A SCHEDULED ROUNTINE INSP, MX FOUND 2 CRACKS AT THE FRAME FS 456.0 RADIATING FROM STRINGER 9AR CUTOUT, UPPER CRACK .6" IN LENGTH, LOWER CRACK .35" IN LENGTH. MAINTENANCE REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIOSDR ZZDA2011118Fitting · crackedAFT ACCESSORY COMPARTMENT FRAME CLIP, STA 1152, LONG L2L, CRACKED. ACCOMPLISHED FRAME CLIP REPLACEMENT PER EA 17-53-03019IR.SDR SIMA201103803Frame · crackedDURING THE MAINTENANCE BASE VISIT FOUND FRAME 23 CRACKED UNDER RIGHT OUTBOARD FLOOR SUPPORT. THE AIRCRAFT WAS REMOVED FROM SERVICE. REPAIRED IAW EO EM-53-MR-1760. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR UALA2011020300584Frame · corrodedMAJOR REPAIR. AFT PIT CORROSION AT FRAME 52A STRINGER 38R AND 39R. REO L01295 AND A-B RAS-DAHAM-4033757-2011 THIS REPAIR IS CONSIDERED MINOR WITH NO SUPPLEMENTAL INSP REQUIRED. PERMANENT REPAIR. CORROSION REMOVED IAW SRM. NDT IAW NTM, NO RELEVANT INDICATIOSDR DALA1108229857Frame · crackedNOSE WHEEL WELL THROUGH ACCESS HOLE STA 51 BL0 OVER HEAD FRAME IS CRACKED APPROXIMATELY 3 INCHES. REMOVED DAMAGED SECTION OF FRAME NDT VERIFIED CRACK FREE CONDITION IAW SPM 06-10-01.001 FABRICATED REPAIR PARTS IAW SRM DC9 SRM 51-18-1FIG 1 SHT 2 INSTALLED ISDR EE4Y20110080Frame · crackedUPPER FUSELAGE, OVERWING FRAME WITH ANGLE CRACKED, AT STA 905 +X61 -Z6. REPLACED ANGLE.SDR EE4Y20110081Frame · crackedUPPER FUSELAGE, OVERWING FRAME WITH ANGLE CRACKED, AT STA 845 -X -Z6. REPLACED ANGLE.SDR USAA2011022190840Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACKED FRAME AT BS 500F, S19R. REPAIRED FRAME AT BS 500F, S19R IAW B737 SRM 53-00-07 REPAIR 13.SDR USAA2011020990667Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACK ON PREVIOUS FRAME REPAIR BETWEEN BS 288 TO BS 294, S17R. REPAIRED FRAME BETWEEN BS 288 TO BS 294, S17R IAW B737 SRM 51-70-11.SDR USAA2011020990666Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK - CRACK ON FRAME AT BS 500E, BETWEEN S20L TO S21L. REPAIRED FRAME AT BS 500E, BETWEEN S20L TO S21L IAW B737 SRM 53-00-07.SDR ASOA201100199Frame · corrodedCORROSION DAMAGED ON FS 319.00 FRAME BETWEEN S26L AND S26R. REMOVED CORROSION FROM FRAME IAW SRM 51-21-06.
Back to JASC 5311