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 CA130409010Door Frame · cracked(CAN) PILOTS REPORTED LOUD NOISE COMING FROM EMERGENCY EXIT. WHEN ENGINEER REMOVED EMERGENCY EXIT, FOUND CRACK ACROSS MIDDLE 2 LIGHTNING HOLES WHICH SPAN THE CENTER STOP. FRAME WAS REPLACED.SDR SWAA2013040914551Window Frame · crackedLEFT NR 3 WINDOW FRAME CRACKED. REPAIRED WINDOW FRAME IAW ACO.SDR SWAA2013040914550Window Frame · crackedRIGHT NR 3 WINDOW FRAME CRACKED. REPAIRED WINDOW FRAME IAW ACO.SDR SWAA2013040914544Window Frame · crackedRIGHT NR 1 COCKPIT WINDOW FRAME CRACKED IN UPPER OUTBOARD CORNER. REPAIRED FRAME IAW AAR EA AND EA.SDR ASAA2013032994747Beam · corrodedUPON REMOVAL OF SEAT TRACK, FOUND LONGITUDINAL BEAM LBL 45.5 FS 727A CORRODED. ACFT GROUNDED. REPAIRED AREA IAW EA AD2008-0506-400-57-118, REV NEW.SDR FDEA201303290689Crease Beam · crackedAT STA 1140 LT SIDE CREASE BEAM HAS A CRACK THAT BROKEN IN TWO AT STATION 1140, LT SIDE, CREASEBEAM WAS CRACKED AT FASTENER HOLE, WHICH IS NOT ALLOWED IAW SRM 53-40-13, FIG. 101, NOTE "D", PAGE 102. R & R CREASEBEAM IAW SRM 51-40-02, DWG 144N5214, BS 1140, WLSDR AALA20130329023Door Frame · crackedBODY STATION 295 RIGHT AND WATERLINE 208, FORWARD GALLEY DOOR CUTOUT FORWARD FRAME INNER SURFACE IS CRACKED AT FASTENER. REMOVED AND REPLACED STUB FRAME PER AARD 51-00-05-1.SDR SWAA2014111734238Window Frame · crackedRIGHT FLIGHT DECK NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER INSIDE & OUT. REPAIRED FRAME IAW SRM.SDR SWAA2013040814508Crease Beam · corrodedRIGHT CREASE BEAM INNER L ANGLE CORRODED AT BS 706, RBL 64.0. REMOVED AND REPLACED L ANGLE IAW SRM.SDR FDEA201303280682Crease Beam · corrodedCABIN RT FLOOR CREASE BEAM HAS CORROSION AND CRACKS FROM STA 1560 -1640, RBL 64.SDR FDEA201303280681Crease Beam · corrodedCABIN RT FLOOR CREASE BEAM HAS CORROSION AND CRACKS FROM STA 1560 -1640, RBL 64.SDR ASAA2013032894284Window Frame · damagedR1 WINDOW UPPER FASTENER ATTACH ROW, MOST OTBD FASTENER IS ELONGATED AT MIDDLE LAYER. ORIGINAL HOLE DIAMETER IS .256 DAMAGE IS .280-.2835, STEP REMEAD UPPER OTBD R-1 WINDOW FASTENER HOLE TO REMOVE DAMAGE. FINAL HOLE DAMAGE .328. DAMAGED CONFIRMED REMOVED. ISDR QMLA2013032813045Door Frame · crackedDURING AIR WORTHINESS CHECK, MECHANIC FOUND A CRACK ABOUT 1.5 INCH LONG IN THE UPPER RT CORNER OF THE BATTERY COMPARTMENT ACCESS DOOR OPENING. THE CRACK WAS ORIGINALLY NOTICED IN THE DOUBLER AND UPON FURTHER INSPECTION FOUND A CRACK IN THE SKIN BENEATH THE DSDR FDEA201303280683Crease Beam · corrodedCABIN RT FLOOR CREASE BEAM HAS CORROSION AND CRACKS FROM BS 1580-1640, RBL64. FOUND OUT OF LIMITS IAW SRM 53-60-13, FIG 101, DETAIL VII. R & R CREASE BEAM WITH A NEW ONE, FABRICATED IAW SRM 51-40-02 & DWG 146N5590, BS 1580-1640, RBL64 CAT "A", MAJOR REPSDR ASAA2013032794570Crease Beam · corrodedRT CREASE BEAM INNER CHORD IS CORRODED FROM SPLICE AT STA 500B TO SPLICE AT STA 528 ALONG ENTIRE LENGTH. REPAIRED RT CREASE BEAM INNER CHORD IAW SRM 51-70-12-0G-0.SDR IPXA13M77812Door Frame · damagedINSPECTION TYPE:2C, TWO DAMAGED FASTENER HOLES IN MAIN CARGO DOOR AFT FRAME ADJACENT TO L14L AND L17L ALONG BS 767. REPAIRED MAIN CARGO DOOR FRAME IAW EA 011-5310-01-A4562 REV IR AND EO MD11-5310-50398-A.SDR IPXA13M77811Splice · crackedINSPECTION TYPE:4C SPLICE FITTING IS CRACKED IN CENTER CARGO COMPT AT STA 5-123 AND L-35R. FABRICATED AND REPLACED SPLICE FITTING IN CENTER CARGO COMPT AT STA 5-123 AND L-35R REF DWG A5A7114 AND SRM 51-33-01, PG 1 AND 31.SDR IPXA13M77810Splice · crackedINSPECTION TYPE:4C, SPLICE FITTING IS CRACKED IN CENTER CARGO AT STA 5-123 AND L-39R. FABRICATED AND REPLACED SPLICE FITTING AT STA 5-123 AND L39R REF DWG A5A7114 AND SRM 51-33-01 PG 1 AND 31.SDR IPXA13M77809Splice · crackedINSPECTION TYPE:4C, SPLICE FITTING IS CRACKED IN CENTER CARGO AT STA. 5-123 AND L-39R. FABRICATED AND REPLACED SPLICE FITTING IN CENTER CARGO AT STA 5-123 AND L-39R REF DWG A5A7114 AND SRM 51-33-01, PG 1.SDR ASOA20130326099Structure · corrodedDURING C-CHECK CARGO DOOR CUTOUT LWR MEMBER CORRODED. MX PERFORMED REPAIR ON CARGO DOOR CUT-OUT LWR MEMBER IAW SRM 51-20-01 AND CPM 51-21-06. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR EE4Y2013032700035Fitting · crackedLOWER FUSELAGE, AFT CARGO COMPARTMENT DOOR AT BEAM NR 5, AFT BEAM END CRACKED. REPLACED NR 5 DOOR BEAM END FITTING IAW S/B DC-9-52-189 ACOMPLISMENT INSTRUCTIONS, WORK INSTRUCTIONS CONDITION 3, REV 3, DATE FEB 21,2008 AND DWG 5934142, REV H, DATED 12-21-06.SDR EE4Y2013032700034Fitting · crackedLOWER FUSELAGE, AFT CARGO COMPARTMENT DOOR AT BEAM NR 3, FWD BEAM END CRACKED. REPLACED NR 3 DOOR BEAM END FITTING IAW S/B DC-9-52-189 ACOMPLISMENT INSTRUCTIONS, WORK INSTRUCTIONS CONDITION 3, REV 3, DATE FEB 21,2008 AND DWG 5934142, REV H, DATED 12-21-06.SDR EE4Y2013032700033Fitting · crackedLOWER FUSELAGE, AFT CARGO COMPARTMENT DOOR AT BEAM NR 1, FWD BEAM END CRACKED. REPLACED DOOR BEAM FITTING IAW S/B DC-9-52-189 ACOMPLISMENT INSTRUCTIONS, WORK INSTRUCTIONS CONDITION 3, REV 3 DATE FEB 21,2008 AND DWG 5934142, REV H, DATED 12-21-06.SDR EE4Y2013032700032Fitting · crackedLOWER FUSELAGE, AFT CARGO COMPARTMENT DOOR AT BEAM NR 2, AFT BEAM END CRACKED. REPLACED NR 2 DOOR BEAM IAW S/B DC-952-189 ACOMPLISMENT INSTRUCTIONS, WORK INSTRUCTIONS CONDITION 3 REV 3 DATE FEB 21, AND DWG 5934142, REV H, DATED12-21-062008.SDR SWAA2014093032456Window Frame · crackedNUMBER 1 RT WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2014093032455Window Frame · crackedNUMBER 1 RT WINDOW FRAME UPPER OTBD CORNER CRACKED. REPAIRED FRAME IAW ACO & EA.SDR FDEA201303260662Door Frame · crackedBS 1239 TO 1259 L3 DOOR FORWARD FRAME LOWER WEB CRACKED. REPAIRED IAW SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 116.SDR FDEA201303260660Door Frame · crackedBS 1301 TO 1321 L3 DOOR AFT FRAME LOWER WEB CRACKED. REPAIRED IAW SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 116.SDR FDEA201303260659Door Frame · crackedBS 1301 - 1321, R3 DOOR AFT FRAME LOWER WEB CRACKED. REPAIRED IAW SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 116.SDR FDEA201303260661Door Frame · crackedBS 1239 TO 1259 R3 DOOR FORWARD FRAME LOWER WEB CRACKED. REPAIRED IAW SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 52. REPAIR CLASSIFIED AS MAJOR IAW GMM 6-2-100 REVISION 116.SDR FDEA201303260666Crease Beam · corrodedCREASE BEAM ANGLE CORRODED AT STA 1180 RT SIDE MAIN DECK. BLENDED AREA IAW-SRM-51-10-02. CHECKED LIMITS FOUND TO BE OUT OF LIMITS IAW-SRM-53- 40-13 DETAIL II FIG. 101, REMOVED AND REPLACED CREASE BEAM IAW-SRM-51-40-02, CAT."A" MAJOR REPAIR.SDR DALA1307710616Structure · corrodedBS 1720 BREAKING FWD CHORD BL-0 BETWEEN STR. 25L AND 25R. CORROSION DAMAGE. REPAIR IAW ERA 512791-14 REV ORIG.SDR ASAA2013032512432Door Frame · corrodedR2 DOOR BS 958 SURROUND FRAME LOWER EDGE AT TOPSIDE OF FLOOR HAS A DEEP GOUGE AND CORRODED. REPAIRED IAW EA 400-53EA-10168.SDR ASOA2013041703402Strap · corrodedCIRCUMFRIENTAL STRAP CORRODED IN BELLY AT BS 280-285 S26R. REMOVED CORROSION FROM CIRCUMFRENTIAL STRAP AT FS 280-285 BETWEEN STGR 26L AND 26RT IAW SRM 51-21-06-001-001-A01. RECEIVED AND COMPLIED WITH EO CL600-2D24-53-I00121. MAJOR REPAIR.SDR R61A201303250361Stop Fitting · corrodedWHILE AIRCRAFT WAS IN HEAVY CHECK MAINTENANCE FOUND THE R2 DOOR STOP CORRODED. MAINTENANCE REMOVED AND REPLACED THE R2 DOOR STOP BOLT IAW EMB 170 AMM 53-20-00. THE AIRCRAFT IS OUT OF SERVICE IN HEAVY CHECK.SDR LR7A2013032500609Structure · crackedDURING SCHEDULED C-11 CHECK, FOUND RT MAIN WHEEL WELL FS 487 MANIFOLD HAD MULTIPLE CRACKS. WL 146, RBL 62. REPAIRED IAW 51-60 AND 51-70.SDR LR7A2013032500581Structure · corrodedDURING SCHEDULED C-11 CHECK, FOUND LT CABIN RING SEGMENT HAD EXFOLIATION CORROSION AT FS 702, 712, AND 732 WL 142, LBL 65. REPAIRED IAW SMP583 FIG 51-140-21.SDR LR7A2013032500546Beam · crackedDURING SCHEDULED C-11 CHECK, FOUND LT MLG WHEEL WELL FS 497 BEAM HAD MUTLIPLE CRACKS AT WL 285, LBL 65. REPAIRED IAW SMP583 51-60 AND 51-70.SDR LR7A2013032500545Splice · crackedDURING SCHEDULED C-11 CHECK, FOUND LT UPPER MAIN WHEEL WELL BULKHEAD SPLICE AT FS 477 TO 497, LBL 62, WL 285 CRACKED. REPAIRED IAW SMP583 51-60 AND 51-70.SDR LR7A2013032500514Splice · corrodedDURING SCHEDULED C-11 CHECK, FOUND RT MAIN WHEEL WELL UPPER SPLICE HAD CORROSION FS 589 TO 597, W L250, AND RBL 61. REPAIRED IAW SMP583, CHAPTER 51-60 AND 51-70.SDR LR7A2013032500512Beam · corrodedDURING SCHEDULED C-11 CHECK, FOUND LT MAIN WHEEL WELL BEAM HAD STRESS CORROSION FS 588, WL 168, LBL 62. REPAIRED IAW SMP583 51-60 AND 51-70.SDR LR7A2013032500511Beam · corrodedDURING SCHEDULED C-11 CHECK, FOUND LT MAIN WHEEL WELL BEAM HAD STRESS CORROSION FS 588, WL 168, LBL 62, REPAIRED IAW SMP583, 51-60 AND 51-70.SDR LR7A2013032500510Post · crackedDURING SCHEDULED C-11 CHECK, FOUND RT MAIN WHEEL WELL BULKHEAD WEB INSPECTION WINDOW POST CRACKED AT FS 586, WL 185, RBL 61.5. REPAIRED IAW SMP583, 51-60 AND 51-70.SDR LR7A2013032500501Rib · warpedDURING SCHEDULED C-11 CHECK,, FOUND NOSE WHEEL WELL RIB WARPED AT FS 97, WL 166. REPAIRED IAW SMP583, SRM 51-60 AND 51-70.SDR AALA20130325008Crease Beam · corrodedCORROSION ON CREASE BEAM INBOARD CHORD AT AFT SERVICE DOORWAY BODY STATION 984, RIGHT BUTTLINE 49 AND WATERLINE 208. REMOVED AND REPLACED CHORD FROM BODY STATIONS 895 TO 1007 PER AARD 51-00-05-1.SDR UALA2013032501872Structure · corrodedFOUND CORROSION FWD AND AFT SIDE STA 1400 BETWEEN 29L-30L.SDR ASAA2013032494638Door Frame · crackedFWD CARGO DOORWAY FWD FRAME CRACKED. ACFT GROUNDED. R & R FWD FWD DOOR FRAME IAW SRM 51-40-02-0G-0.SDR ASAA2013032494636Door Frame · crackedFWD CARGO DOORWAY AFT FRAME CRACKED. ACFT GROUNDED. R & R FWD CARGO DOORWAY AFT FRAME IAW SRM 51 40 02 0G 0.SDR A6WA201304024887Stop Fitting · chafedRIGHT EMERGENCY EXIT STOP FITTING CHAFED 6EA. BLENDED 6EA STOP FITTINGS ON RIGHT EMERGENCY EXIT.SDR ASOA2013032903279Support Bracket · crackedLOWER FWD CARGO DOOR SUPPORT BRACKET CRACKED. R & R SUPPORT BRACKET IAW SRM 51-42-06.
Back to JASC 5310