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 AALA200802544Failsafe · corrodedCORROSION FOUND ON LOWER CARGO DOOR LOWER SILL FAIL SAFE STRAP IN 2 PLACES. REPLACED STRAPS AND REPAIRED FASTENER HOLES IN ACCORDANCE WITH MRB 767 3302.SDR SWAA085081Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 324 TO BS 340, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR ASAA0843583Threshold · corrodedAFT CABIN FLOOR R2 DOOR THRESHOLD INNER CHORD CORRODED STA 946 TO STA 992 AREA. REMOVED DAMAGED INNER CHORD, LOCATED DRILLED AND INSTALLED REPLACEMENT INNER CHORD IAW B737 400 SRM 51 40 02 51 40 05.SDR UIE2008F00039Beam · corrodedRT NR 5 MAIN ENTRY DOOR FWD EDGE BEAM AND LOWER HINGE CUTOUT AREA CORROSION. REPAIRED IAW SERVICE REQUEST 1-954744333 APPROVED BY FORM 8100-9 DATED 5 SEPT, 2008, DETAILS OF WORK KEPT AT EO-4752A154. (K)SDR UIE2008F00038Door Frame · crackedLT NR 1 MAIN ENTRY DOOR FWD FRAME UPPER HINGE CUTOUT AREA CRACKED. REPAIRED IAW MFG SERVICE REQUEST 1-948230971 APPROVED BY FORM 8100-9 DATED 4 SEP, 2008, DETAILS OF WORK KEPT AT EO-4752A153. (K)SDR HNAA2009010900382Door Frame · corrodedDURING C-CHECK INSP, THE LAVATORY SERVICE DOOR FRAME WAS FOUND TO HAVE CORROSION ON IT. THE DOOR FRAME WAS REPLACED IAW SRM PROCEDURES. ADDITIONALLY, THE PAX DOOR THRESHOLD WAS FOUND TO BE CORRODED. THAT ITEM, P/N 85320686-101, WAS ALSO REPLACED.SDR QML2008F00012Panel · leakingON SHORT FINAL ABORT, SMOKE, SPARKS, BRIGHTER THAN NORMAL OVERHEAD LIGHTING AND A STRONG ODOR CAME FROM THE OVERHEAD PANEL. ON TOUCHDOWN THE INSTRUMENT PANEL LIGHTS RHEOSTAT SWITCH ADJUSTED TO OFF POSITION - SMOKE, SPARKS, AND BRIGHTER THAN NORMAL LIGHTING STOSDR C2XA08SH117Door Frame · corrodedDURING C-CHECK MAIN DOOR STRUCTURE HAS CORROSION AROUND LOWER NUTPLATE HOLE. MX REPAIRED MAIN DOOR LOWER NUT PLATE HOLES IAW EC 5210-01154. THE ACFT WAS APPROVED TO RETURN FOR SERVICE. (K)SDR C2XA08SH120Door Frame · corrodedDURING C-CHECK, BAGGAGE DOOR CUTOUT LOWER BEAM CORRODED IN VARIOUS AREAS MARKED. MX REMOVED AND REPLACED BAGGAGE DOOR LOWER FLOORBEAM IAW SRM 51-40-02. THE ACFT WAS APPROVED TO RETURN FOR SERVICE. (K)SDR SWAA084980Door Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO DOOR AFT FRAME CRACKED AT UPPER END. REMOVED AND REPLACED FRAME PER BOEING DRAWING AND SRM.SDR SWAA084979Door Frame · crackedDURING SCHEDULED 24Y CHECK, FOUND AFT CARGO DOOR AFT FRAME CRACKED AT LOWER END. REMOVED AND REPLACED FRAME PER BOEING DRAWING AND SRM.SDR 08FDEA03783Door Frame · crackedTHE DOOR FRAME FITTING IS CRACKED, AFT CARGO LOWER FWD CORNER. COMPLIED WITH FEDEX E.A. 6-5310-123645.SDR TRAX200801130Beam · crackedFS 280 BEAM IS CRACKED OTBD OF RBL 9 BLEOW BOTTOM (2) FASTENERS THAT CONNECT FS 280 BEAM TO RBL 11 VERTICAL BEAM. (K)SDR DHLA2008745539Beam · crackedLOWER FUSELAGE AFT CARGO COMPARTMENT 1183 BULKHEAD WL 190 BETWEEN RBL19 AND RBL47 HORIZONTAL BEAM CRACKED.SDR USAA920081747Door Frame · crackedCLT - MAJOR REPAIR, CRACK AT L1 DOOR CUTOUT AT AFT LOWER CORNER OF FRAME. REPLACED L1 DOOR CUTOUT LOWER FRAME IAW BOEING DRAWING NR 5007945.SDR 2008UALA05615Structure · corrodedAFT PIT, UPPER CHORD FOR WEB AT STR 33L CORRODED ON THE LOWER SURFACE. *S/D* MAJOR REPAIR ACCOMPLISHED. INSTALLED NEW ANGLE.SDR DHLA2008745627Door Frame · corrodedUPPER FUSELAGE MAIN CABIN FWD RT DOOR CUTOUT FWD FRAME LOWER SECTION WITH CORROSION. REPAIRED FRAME AT BS 377 BETWEEN S-16R AND S-17R IAW B727 SRM 51-40-3 FIG 1.SDR KCS2008F00016Door Frame · crackedSTA 281, RBL-50, W/L-312 CARGO DOOR FRAME CRACKED. (K)SDR SWAA084877Crease Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 637, RBL 70. REMOVED AND REPLACED WEB PER MM.SDR SWAA084876Crease Beam · crackedDURING SCHEDULED 20Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 637, LBL 70. REMOVED AND REPLACED WEB PER MM.SDR CALA0800848Door Frame · crackedFORWARD CARGO DOOR FRAME CRACKED. REMOVED CRACKED DOOR FRAME AND REPLACED SAME WITH NEW DOOR FRAME IAW SRM 51-40-02.SDR DHLA2008745603Window Frame · corrodedUPPER FUSELAGE EXTERIOR FUSELAGE CARGO CABIN WINDOW CUT-OUT NR 36 RIGHT SIDE WINDOW FRAME WITH CORROSION. REPLACED FUSELAGE WINDOW FRAME FROM BS 970 TO BS 990 BETWEEN S-10R AND S-14R IAW B727SRM 51-10-1 PARA 7A.SDR DHLA2008745587Door Frame · crackedUPPER FUSELAGE MAIN CABIN FWD GALLEY DOOR AFT SECTION BEAM AREA STOP FITTING CUT OUT WITH CRACK. REPAIRED FUSELAGE FWD GALLEY DOOR LOWER AFT FRAME SECTION BETWEEN DOOR BEAM NR 4 AND DOOR BEAM NR 6 IAW SB 727-52-114 DTD 2/24/78 SECT 3 PART 3 PARA D.SDR SWAA084848Crease Beam · corrodedDURING SCHEDULED SPV CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 817, LBL 67. REMOVED AND REPLACED WEB PER SRM.SDR 08FDEA03710Fitting · crackedTHE DOOR FRAME FITTING IS CRACKED AT THE AFT CARGO DOOR LOWER AFT CORNER. COMPLIED WITH EA 6-5310-123646.SDR 08FDEA03675Door Frame · chafedFOUND SCRUB MARKS AT EMERGENCY EXIT C 55, P14-15 RT. REPAIR PERFORMED BY BLEND OUT , NDT FOR CRACK FREE CONDITION IAW RAS/EFW/9000086/2008 ISS.A, APPROVED BY EA 6-5316-123092.SDR 08FDEA03674Door Frame · chafedFOUND SCRUB MARKS AT EMERGENCY EXIT C 57.2, P14-15 LT REPAIR PERFORMED BY BLEND OUT , NDT FOR CRACK FREE CONDITION IAW. RAS/EFW/9000080/2008 ISS.A, APPROVED BY EA 6-5316-123071.SDR 08FDEA03673Door Frame · chafedFOUND SCRUB MARKS AT EMERGENCY EXIT C 55 AND C 57.2, P14-15 LT AND C 55, P 14-15 RT. REPAIR PERFORMED BY BLEND OUT , NDT FOR CRACK FREE CONDITION IAW RAS/EFW/9000079/2008 ISS.A, APPROVED BY EA 6-5316-123070,SDR SWAA084795Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 440 TO BS 500A, LBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWIA200820444Isolator · crackedC-CHECK, THREE ISOLATORS FORWARD SIDE OF AFT PRESSURE BULKHEAD CRACKED. REPLACED PER SRM.SDR KCSA081432Door Frame · corrodedSTA-1315 STR-22R TO STR-25R DOOR FRAME CORRODED.SDR SWAA084764Door Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND FWD SERVICE DOOR FRAME CRACKED AT LOWER FRAME AFT LOWER STOP. REMOVED AND REPLACED DOOR PER MM.SDR SWAA084761Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED FROM BS 887 TO BS 907, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA084729Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 847 AND BS 867, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA084728Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 807 AND BS 827, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR DALA1315349207Door Frame · corrodedFUSELAGE FORWARD CARGO DOOR LOWER FRAME, REPAIRED IAW ERA 470229-14, ERA 470229-14.SDR 2008UALA05470Structure · dentedFUSELAGE DENT AT STR 10R FRAME 34. *S/D* MAJOR REPAIR. INSTALLED DOUBLER REPAIR.SDR SWAA084718Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 400 AND BS 420, STR 17L. REPAIRED WEB PER SRM.SDR SWAA084700Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND CREASE BEAM WEB CORRODED BETWEEN BS 867 AND BS 887, RBL 70. REMOVED AND REPLACED WEB PER SRM.SDR SWAA084679Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT LOWER CORNER. REPAIRED FRAME PER ACO.SDR C8GA20080043Structure · damagedWHILE IN HEAVY MAINTENANCE EXISTING REPAIR AT BS 1133 BETWEEN STR. 21R - 22R REQUIRES REPLACEMENT. REMOVED EXISTING REPAIR, CUT OUT DAMAGE, FABRICATED FILLER, FABRICATED DOUBLER. INSTALLED REPAIR IAW SRM 53-30-2, 53-30-8. NO OTHER DEFECTS NOTED. AIRCRAFT WAS RSDR 2008UALA05449Structure · dentedFUSELAGE DENT AFT OF FRAME 23 JUST BELOW STR 22L. *S/D* MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR SWAA084630Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 3 STOP FITTING. REPAIRED FRAME PER ACO.SDR CALA0800827Door Frame · corrodedR2 DOOR AFT FRAME CORRODED AT STR 17R BETWEEN ATTACH CLIP AND FRAME. REPAIRED R2 DOOR AFT FRAME AT STR 17R BETWEEN ATTACH CLIP AND FRAME PER BOEING DWG 65-46566, B737 SRM 51-70-11 AND B737 SRM 51-40-02.SDR CALA0800826Door Frame · corrodedR-2 DOOR AFT FRAME WEB CORRODED OUT OF LIMITS PER SRM 51-10-02. FABRICATED PARTS PER BAC DRWG65C33583, REMOVED AND REPLACED FRAME SECTION IAW 51-10-02.SDR WRLA2008069ADoubler · crackedDURING INSPECTION FOUND CRACK ON CLG WHEEL WELL LT AND RT DOUBLER AT Y=1381, X=31.5 AND -31.5. REPAIRED CRACK AREA IAW EI W2008A53B-761 REV.00. JOB COMPLETED AND CONDITION CHECK NORMAL. (S)SDR WRLA2008068ADoubler · crackedDURING A CHECK INSPECTION SR TECHNICS, CRACKS FOUND ON CENTER LANDING GEAR WHEEL WELL FORWARD BULKHEAD LT SIDE AROUND LATERAL CONTROL MIXER DOUBLERS. REPAIRED PER WORLD AIRWAYS ENGINEERING REPAIR AUTHORIZTION DOCUMENT 08-53-73. (S)SDR SWAA084599Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 188, STR 17L. REPAIRED WEB PER SRM.SDR SWAA084598Crease Beam · crackedDURING SCHEDULED 24Y CHECK, FOUND CREASE BEAM WEB CRACKED AT BS 188, STR 17R. REPAIRED WEB PER SRM.SDR 08FDEA03493Stanchion · corrodedFWD CARGO: AFT BULKHEAD APPROXIMATE STA 6-73.5, LBL 8, STANCHION CORRODED. FORWARD CARGO AFT BULKHEAD APPROXIMATELY STA 6-73.5, LBL 8 STANCHION CORRODED AREA. CARRIED OUT REPAIRED AS PER SRM 53-00-01 FIGURE 8 VOLUME I. THIS REPAIR CLASSIFIED AS MAJOR PER G
Back to JASC 5310