JASC 5310
Service difficulty reports · 38,573
Reports filed under 5310 · Fuselage Main, Structure, 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 = '5310' 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 = '5310' 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 SAJF2012091701035Structure · corroded(B-18607) DURING THE MX CHECK, CORROSION WAS FOUND BETWEEN STRINGER S-21R AND S-22R AT BS 881 IN AFT CARGO COMPARTMENT. THE CORRODED AREA WAS REMOVED AND REPORTED TO MFG FOR REVIEW AND REPAIR INSTRUCTION. REPAIR IS IN PROCESS IAW MFG SERVICE REQUEST (SR 1-23SDR FDEA201209153331Link Assy · crackedMAIN DECK CARGO FRAME 48L BELOW SEAT TRACK 4L SUPPORT STRUCTURE ATTACHMENT LUG CRACKED ONE INCH LONG, STR 27-28. R & R DAMAGED LINK ASSY IAW SRM 51-40-21, PG 7, PARA 5.SDR SWAA2012110809168Door Frame · crackedFWD GALLEY DOOR STUB FRAME CRACKED AT BS 294.5, BETWEEN STR 6R TO STR 7R. REPAIRED STUB FRAME IAW EA.SDR DALA1248430932Door Frame · wornDURING HMV, WEAR WAS FOUND ON FWD SERVICE DOOR FRAME FWD LOWER SECTION BS 172. REPLACED LOWER SERVICE DOOR FRAME IAW ER/A 506610-14 REV ORIG AND SRM 53-05 FIG 55.SDR DALA1248390932Door Frame · corrodedDURING HMV, CORROSION WAS FOUND ON PREVIOUS REPAIR DOUBLER OF AFT CARGO COMPARTMENT LOWER DOOR JAMB FROM STA Y=1160-1212. REPLACED REPAIR DOUBLER IAW ER/A 489172-14 REV ORIG AND SRM 53-05, FIG 123.SDR DALA12007349237Door Frame · corrodedMID CARGO BAY DOOR LOWER FRAME HAS SEVERAL SPOTS OF CORROSION, BS 693-750. REMOVED DAMAGED AREA. DRILLED AND INSTALLED NEW FRAME IAW SRM 51-30-05, 51-10-05, 51-30-02 AND DWG 5930481. ACFT OK FOR SERVICE.SDR CWQR20120914049Drag Angle · crackedDURING A SCHEDULED INSPECTION, FOUND THE LT WING TO FUSELAGE FAIRING DRAG ANGLE THAT ATTACHES TO THE WING, WAS CRACKED A 3 FASTENER LOCATIONS.SDR FDEA201209123299Adapter · crackedCLEVIS ADAPTER AT FR21 BETWEEN SEAT TRACKS 3L AND 4L HAS .25 IN CRACK ON FWD FLANGE AND 1". CRACK ON AFT FLANGE. REMOVED CLEVIS ADAPTER IAW FSRM 51-72-10, PARA 5. LOCATED, DRILLED, AND INSTALLED NEW CLEVIS ADAPTER AT FR21 BETWEEN SEAT TRACKS 3L AND 4L IAWSDR FDEA201209123297Crease Beam · corrodedMAIN CARGO DECK LEFT INBD CREASE BEAM AND ANGLE BS 665-690 CORRODED. FOUND TO BE OUT OF LIMITS IAW SRM 53-30-15, DETAIL III. R & R LT INBD CREASEBEAM IAW SRM 51-40-02 AND DWG 143N8324. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR.SDR QXEA2012091101057Stanchion · crackedDURING FRAME FLANGE REPAIR FOUND CRACK IN STANCHION AT STA 176 STR 31S. FOUND STANCHION TO BE OUT OF LIMITS IAW SRM 53-20-43-00-01. REMOVED STANCHION IAW SRM 51-42-05-02-01. INSTALLED NEW STANCHION IAW SRM 51-42-05-02-0`1. ALODINED AND PRIMED FASTENERS ISDR UALA2012091405195Door Frame · crackedFWD CARGO DOOR CUTOUT IS CRACKED IN TWO PLACES. FIRST CRACK IS ON AFT SIDE OF FRAME IS CRACKED IN TWO PLACES. FIRST CRACK IS ON AFT SIDE OF FRAME IN RADIUS ADJACENT TO I/B UPPER CORNER OF LWR STOP FITTING, SECOND CRACK IS ON FWD SIDE OF FRAME JUST BELOW UPPESDR ASAA2012091092994Frame · corrodedL1 DOOR CUT OUT BOTTOM THRESHOLD SUPPORT FRAME HAS SURFACE CORROSION. LOCATED AND DRILLED IAW SRM 51-40-05.SDR HYIA20120910002Spar · crackedDURING REGULARLY SCHEDULED MX INSPECTION, DAMAGE WAS NOTED TO THE AFT CARRY THROUGH SPAR ASSY UPPER FORWARD AND AFT WEB FLANGES. FLANGES WERE FOUND TO BE CRACKED AT FLOOR SUPPORT MOUNT LOCATIONS. OPENSDR HYIA20120910001Spar · damagedDURING A REGULARLY SCHEDULED MX, DAMAGE WAS DISCOVERED TO THE AFT CARRY THROUGH SPAR, CENTER SECTION UPPER CAP AND CORRESPONDING WEB FLANGES. THIS DAMAGED APPEARED TO BE CAUSED BY PREVIOUS REPAIR ATTEMPTS INCLUDING MISDRILLS TO SPAR CAP AND CRACKS IN WEB FLANSDR SWAA2012100908353Door Frame · crackedR1 DOOR CUTOUT FWD FRAME CRACKED AT I/B FLANGE, BS 295, WL 208. REPAIRED FRAME PER EA AND ER.SDR SWAA2012092007809Door Frame · crackedR1 DOOR FWD FRAME CUTOUT CRACKED AT BS 294.5, WL 208. REPAIRED FRAME IAW SRM AND DWG.SDR DALA1252590924Door Frame · corrodedFWD CARGO COMPARTMENT LWR DOOR JAMBHAS CORROSION TO INCLUDE AROUND AND UNDER BOTH STOP MOUNT ASSY'S REPAIRED IAW SRM 53-05, FIG 44.SDR SWAA2012092507955Crease Beam · corrodedR1 DOOR CREASE BEAM CHORD CORRODED. REMOVED AND REPLACED BEAM IAW DWG AND SRM.SDR FDEA201209073252Crease Beam · corrodedRT INBD CREASE BEAM CORRODED, BS 774. FOUND TO BE OUT OF LIMITS AT BS 774 RBL 70 IAW SRM 53-30-13 DETAIL VIII FIG.101 PG.105. REMOVED AND REPLACED CREASE BEAM AT BS 760-900 RBL 70 IAW SRM 51-40-02 AND DRAWING 143N5520.SDR SWAA2012091707698Crease Beam · corrodedCREASE BEAM INBOARD CHORD CORRODED AT BS 325, STR 17L. REMOVED AND REPLACED CHORD IAW SRM AND DWG.SDR QXEA2012090700980Stop Fitting · damagedFWD PAX DOOR SURROUND STOP FITTING AFT NR 3 HAS WEAR ON CONTACT AREA. SMOOTHED DAMAGE IAW SRM 51-14-00-02-04. MECHANICALLY MEASURED MAX MATERIAL LOSS .015". VERIFIED STOP FITTING TO BE CRACK FREE REF NDTM PT 1 TASK 51-00-01-910-801. FOUND DAMAGE WITHIN LIMSDR SWAA2012091307580Crease Beam · corrodedLEFT CREASE BEAM WEB CORRODED BETWEEN BS 827 TO BS 847. REMOVED AND REPLACED WEB IAW SRM.SDR SWAA2012092007811Door Frame · crackedAFT CARGO DOOR CUTOUT AFT FRAME CRACKED. REMOVED AND REPLACED FRAME IAW BAC DWG.SDR USAA2012091300025Crease Beam · corrodedQ6 CHECK - LEVEL 2 EXFOLIATION CORROSION ON CREASE BEAM BETWEEN BS 616 TO BS 639, S17R. REPAIRED CREASE BEAM BETWEEN BS 616 TO BS 639, S17R IAW B737 SRM 51-70-13.SDR SWAA2012100108091Crease Beam · corrodedRIGHT MAIN CABIN CREASE BEAM CORRODED BETWEEN BS 767 TO BS 787. REMOVED AND REPLACED WEB IAW MM, DWG AND SRM.SDR ASOA2012092602293Door Frame · crackedPAX DOOR FRAME FS 327.76 CRACKED, FOUND DURING CMS REMOVAL. REMOVED DOOR FRAME IAW SRM 51-42-06-001-001-A01/51-42-21-001-001-A01. INSTALLED DOOR FRAME IAW SRM 51-42-06-001-001-A01, 51-42-21-001-001-A01.SDR SWAA2012092007786Crease Beam · corrodedLEFT CREASE BEAM CORRODED BETWEEN BS 480 TO BS 500. REMOVED AND REPLACED BEAM IAW BAC DWG AND AMM.SDR DXTA2012090605117Door Frame · corrodedCABIN DOOR FORWARD FRAME CORRODED AT SHEAR TIE FITTING. REMOVED SURFACE CORROSION IAW SRM 51-20-01. INSTALLED DOOR FRAME IAW SRM 51-40-03.SDR SWAA2012090507357Crease Beam · corrodedRIGHT MAIN CABIN CREASE BEAM CORRODED BETWEEN BS 440 TO BS 460. REMOVED AND REPLACED WEB ASSY IAW BAC DWG.SDR FDEA201209043225Crease Beam · crackedOTBD CREASE BEAM AT BS 1641 CRACKED. REPAIRED IAW EA F-5310-162550. MAJOR REPAIR.SDR SWIA201231926Door Frame · crackedFUSELAGE FRAME NR 13 CRACKED IN TWO PLACES BETWEEN 1ST AND 2ND DOOR FUSELAGE STOPS. (C-CHECK) REPAIRED IN REFERENCE TO EMB SRM.SDR IPXA12175618Adapter · gougedINSPECTION TYPE:10YR, MDCC CLEVIS ADAPTER GOUGED AT FR66, BETWEEN -Y1959 AND -Y2462. REPAIRED CLEVIS ADAPTER AT FR66, BETWEEN -Y1959 AND -Y2462 IAW SAT-SA EA 300-5310-01-A4262 AND EO A300-5310-48590-A.SDR IPXA12175628Adapter · corrodedINSPECTION TYPE: 10YR, MAIN CABIN CLEVIS ADAPTER IS CORRODED AT FR 66 BETWEEN STA Y1959 AND Y2462. ACCOMPLISHED REPAIR ON MAIN CABIN CLEVIS ADAPTER AT FR 66 BETWEEN STA Y1959 AND Y2462 PER IPXA EO A300-5310-48590-A.SDR IPXA12175614Adapter · corrodedINSPECTION TYPE: 10YR, MAIN CABIN CLEVIS ADAPTER IS CORRODED AT FR 71 -Y1456 AND -Y1959. ACCOMPLISHED REPAIR ON MAIN CABIN CLEVIS ADAPTER AT FR 71 -Y1456 TO -Y1959 IAW EO A300-5310-48590-A.SDR IPXA12M75175Web · crackedINSPECTION TYPE: 4C, R3 DOOR AFT JAMB LOWER WEB LIGHTNING HOLE CRACKED. REPAIRED R3 DOOR AFT JAMB LOWER WEB LIGHTNING HOLE REF SRM 53-40-15, REPAIR 3, FIG 201.SDR QXEA2012083100945Casting · crackedLOWER AFT CORNER CASTING ON FWD PAX DOOR CUTOUT CRACKED. CASTING FOUND TO BE OUT OF LIMITS IAW SRM 53-20-23-00-01. MATCH DRILLED TO EXISTING STRUCTURE IAW SRM 51-40-07-02-01. ALODINED NEW HOLES IAW SRM 51-21-10-02-01, PRIMED NEW HOLES IAW SRM 51-25-10-02-01SDR AALA20120830005Door Frame · damagedFORWARD CARGO DOOR FRAME DAMAGE AT STATION 370 ON FORWARD UPPER CORNER OF FRAME. INSTALLED DOUBLER REPAIR PER SRM 53-05-00 FIGURE 105.SDR DALA12006120857Door Frame · corrodedFWD CARGO COMPARTMENT DOOR CUT OUT LOWER FRAME HAS SURFACE CORROSION. REPAIRED FWD CARGO COMPARTMENT DOOR CUT OUT LOWER FRAME.SDR SWAA2012083007178Window Frame · crackedNR 1 RIGHT WINDOW FRAME POST CRACKED. REPAIRED FRAME PER EA.SDR SWAA2012083007177Window Frame · crackedNR 1 LEFT WINDOW FRAME POST CRACKED. REPAIRED FRAME PER EA.SDR FDEA201208273179Crease Beam · corrodedCABIN, DOOR 3L STA 1320 TO 1340, CREASE BEAM WEB HAS CORROSION ON LOWER SURFACE. REMOVED AND REPLACED WITH CREASE BEAM FABRICATED AS PER DWG 146N8326 SHT.1 REV.C AND INSTALLED IAW DWG 146N8322 SHT.3 REV.- AND SRM 51-40-02 REV.106. REPAIR IS MAJOR.SDR N6WA2012082602Door Frame · dirtyPAX DOOR LATCH CAUTION MESSAGE. CLEANED DEBRIS FROM LOWER DOOR JAM, PERFORMED OP'S CHECKED OF PAX DOOR IAW AMM 52-70-00.SDR FDEA201208253165Structure · corrodedAFT FUSELAGE LAV SERVICE PANEL. HOUSING (BOX) HAS CORROSION BET BS 1681- 1701. REMOVED CORRODED ON DOUBLER AND TWO CLIPS PER SRM-51-10-02, REMOVED .040 ON DOUBLER AND TWO CLIPS MAT AD 0.50 AREA ON DOUBLER IS 5" X 4" AND CLIPS 1" X 1" FOUND TO BE OUT OF LIMISDR FDEA201208243153Crease Beam · corrodedLEFT INBD CREASE BEAM CORRODED BS 1045 - 1080. REMOVED CORROSION ORIG .080 REMAINING .005 FOUND TO BE OUT OF LIMITS IAW SRM 53-40-13, DETAIL VIII. R & R CREASE BEAM IAW SRM 51-40-02, SRM 51-10-02 AND DWG REF 14N5200. MAJOR REPAIR.SDR VGCA201208240001Beam · crackedLEFT NOSE LANDING GEAR BEAM UPPER CHORD CRACKED.SDR FDEA201208243150Window Frame · chafedCOCKPIT LT SLIDING WINDOW FRAME FWD SECTION EDGE CHAFED COMPLY WITH EA:6-5610-149055.SDR DALA12006199237Channel · damagedRIGHT WHEEL WELL CUTOUT FORWARD FRAME CHANNEL INBOARD END HAS PIECE BROKEN OFF STA 1003 LBL 10. FABRICATED REPAIR ANGLES AND INSTALLED REPAIR AT RIGHT WHEEL WELL CUTOUT FRAME STA 1003 LBL 10 PER SRM 53-60-02 FIG 6 VOL 1, SRM 51-30-05 VOL 2 AND SRM 51-30-02 VOSDR DALA12006189237Channel · damagedLEFT WHEEL WELL CUTOUT, FORWARD FRAME CHANNEL INBOARD END HAS PREVIOUS STOP DRILL BUT AREA IS KNIFED EDGED STA 1003 RBL 10. REMOVED PREVIOUS REPAIR ANGLE (CRACKED), DEBURRED STOP DRILL, FABRICATED AND INSTALLED NEW REPAIR ANGLES PER SRM 53-60-02 FIG 6 VOL ANDSDR DXTA2012082905108Door Frame · corrodedMAIN ENTRY DOOR FRAME CORRODED. FOUND DURING INSPECTION.SDR FDEA201208223129Crease Beam · corrodedMAIN DECK CARGO LEFT INBD CREASE BEAM AT BS 1625-1370 HAS AREAS OF SCRATCHES AND CORROSION. CORROSION REMOVED IAW SRM 51-10-02. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13 DETAIL VIII, FIG.101 SH5. REMOVED AND REPLACED CREASE BEAM IAW SRM 51-40-0
Back to JASC 5310