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 FDEA201207112537Failsafe · dentedLT LOWER LOBE INTERNAL FRAME AT STA 350 BETWEEN STR 20L TO STR 21L, FAILSAFE CHORD WITH A DENT. DENTED FAILSAFE CHORD ON FRAME AT STA 350, BETWEEN S-20L AND S-21L, R & R WITH FAILSAFE CHORD FABRICATED IAW DWG 141N1217, REV E AND INSTALLED IAW SRM 51-40-02 SDR UALA2012071103714Static Port · damagedSCRATCH IN EXTRA CRITICAL RVSM STATIC PORTS AREA L SIDE OF FUSELAGE. SCRATCH IS 2 1-2 INCHES LONG AND 1 INCH ABOVE FIRST OFFICER STATIC PORT, DEPTH OF SCRATCH IS 0.0005 WHICH IS OUT OF ALLOWABLE DAMAGE LIMITS PER MM. LIGHTLY BURNISHED DAMAGED AREA REF SRMSDR DALA1243599264Beam · corrodedCORROSION FOUND AT AFT CARGO DOOR CUTOUT UPPER BEAM AT BS 1212 L19R. REMOVED AND REPLACED BEAM PER SRM 51-30-05 VOL II.SDR SWAA2012072706227Window Frame · crackedL1 WINDOW FRAME CRACKED. REPAIRED FRAME IAW EA.SDR SWAA2012072706226Window Frame · crackedR1 WINDOW FRAME CRACKED. REPAIRED FRAME IAW EA.SDR IPXA2M74611Door Frame · crackedINSPECTION TYPE:4C, WEB CRACKED AT R3 DOOR JAMB LOWER FWD LIGHTNING HOLE. REPAIRED R3 DOOR TORQUE BOX WEB AT LOWER FWD LIGHTNING HOLE STA 1250- 1256 IAW SRM 53-40-15, REPAIR 3, FIG 201.SDR SWAA2012072706223Window Frame · crackedL1 WINDOW FRAME CRACKED. REMOVED AND REPLACED FRAME PER BOEING DWG AND SRM.SDR SWAA2012072606215Window Frame · crackedL1 WINDOW FRAME CRACKED. REMOVED AND REPLACED FRAME IAW SRM AND BOEING DWG.SDR SWAA2012072606214Window Frame · crackedR1 WINDOW FRAME CRACKED. REMOVED AND REPLACED FRAME IAW SRM AND BOEING DWG.SDR DALA12003203130Beam · damagedRIGHT AFT PASSENGER DOOR SILL BEAM AT FR 66 UPPER FLANGE AND AROUND NUT PLATE HOLES. ACCOMPLISHED PERMANENT REPAIR IAW SRM 53-41-14 FIG 201 (REF NON ROUTINE 21/260). FOLLOW UP INSPECTION REQUIRED PER SRI 53-41-14-2-001-00. FIRST INSPECTION REQUIRED AFTER RESDR FDEA201207062490Door Frame · crackedR3 DOOR BS 1252 FORWARD FRAME LOWER WEB BETWEEN L26 AND L27 CRACKED. REPAIRED AS PER SRM 53-40-15 FIGURE 201 REPAIR 3 REVISION 49. REPAIR CLASSIFIED MAJOR AS PER GMM 6-2-100 REVISION 115.SDR DALA1241379005Beam · corrodedAFT CARGO DOOR SILL BEAM CORROSION. CORROSION OUT OF LIMITS. REMOVED AND REPLACED DOOR BEAM.SDR U2RA201207120005Tension Tie · crackedUPPER DECK TENSION TIE LT STA 1140 CHORD FOUND CRACKED IN 4 PLACES. CRACK LENGTH .07" REF AD 2007-23-18, S/B 747-53A2507.SDR FDEA201207062489Crease Beam · corrodedCABIN CREASE BEAM INNER CHORD HAS CORROSION AT STA 1594, RBL 60. REPAIRED IAW EA F-5310-158085.SDR SWAA2012072706259Window Frame · crackedL1 WINDOW FRAME CRACKED. REMOVED AND REPLACED FRAME IAW BAC DWG & SRM.SDR DALA1240369213Door Frame · crackedRIGHT FORWARD GEAR DOOR FRAME HAS 2.5 INCH CRACK LOCATED JUST BELOW DOOR CLOSED PROXIMITY SENSOR. REMOVED AND REPLACED FRAME PER SRM 53-60-02 AND 51-00-00.SDR DALA1240260934Beam · corrodedDURING HMV, CORROSION WAS FOUND ON MID CARGO COMPARTMENT LOWER BEAM STA Y=636-693. BLENDED AREA AND INSTALLED DOUBLER IAW SRM 53-05 FIG 123.SDR DALA1240250934Beam · corrodedDURING HMV, CORROSION WAS FOUND ON MID CARGO COMPARTMENT LOWER DOOR FRAME BEAM, BS Y=655 AND Y=674, AROUND SETSCREW HOLES. DAMAGE AREA WAS CUT OUT AND PLUGS INSTALLED IAW ER/A 504344-14 REV ORIG.SDR SWAA2012082306894Crease Beam · corrodedCREASE BEAM WEB CORRODED AT STA 727C, STR 17R. REPAIRED WEB IAW BAC DWG & SRM.SDR U2RA201208030001Strap · crackedMAIN DECK RT NR 1 DOOR FWD EDGE FRAME ATTACH STRAP AT LOWER GUIDE ARM CUT OUT AREA FOUND CRACKED.SDR SWAA2012073106365Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 867, STR 17L. REMOVED AND REPLACED WEB IAW BAC DWG AND SRM.SDR SWAA2012073006353Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 400, STR 17L. REMOVED AND REPLACED WEB PER SRM & BAC DWG.SDR SWAA2012073006352Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 867, STR 17R. REMOVED AND REPLACED WEB IAW BAC DWG.SDR SWAA2012073006346Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 420, STR 17L. REPAIRED WEB IAW BAC DWG & SRM.SDR SWAA2012073006332Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 619, STR 17L. REMOVED AND REPLACED WEB IAW BAC DWG AND SRM.SDR SWAA2012073006296Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 787, STR 17R. REMOVED AND REPLACED WEB IAW BAC DWG & SRM.SDR SWAA2012071605850Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 887, STR 17L. REMOVED AND REPLACED WEB IAW SRM & BAC DWG.SDR DALA1241119264Beam · corrodedBEAM FOUND CORRODED. REMOVED AND REPLACED LOWER BEAM 28R BETWEEN BS 655 THRU 788 AS PER DRAWING NR 5930481 AND PER SRM 51-30-05.SDR SWAA2012071305799Crease Beam · corrodedCREASE BEAM WEB CORRODED AT BS 747, STR 17L. REMOVED AND REPLACED WEB IAW SRM.SDR U2RA201207120010Structure · crackedBS 2598 RT UPPER AFT INNER CHORD ONE FASTNER HOLE FOUND CRACKED AT AFT INNER CHORD. CRACK LENGTH .030". REF AD 2010-14-07, SB 747-53A2427.SDR LR7A2012070500383Structure · crackedDURING SCHEDULED POST FLIGHT INSPECTION, FOUND CRACK FORWARD OF LT RAMP ACTUATOR. REPAIR ACCOMPLISHED IAW SMP 583 51-10, PAGE 3G AND 51-70.SDR FDEA201207032458Crease Beam · corrodedAT BS 1440 INNER CREASE BEAM CORRODED ON RT SIDE.SDR WVER2012070292304Door Frame · crackedRIGHT FORWARD EMERGENCY EXIT DOOR IS CRACKED ON THE UPPER EDGE MEMBER JUST BELOW THE FORWARD ARM. CRACK MEASURES APPROXIMATELY 1.25 INCHES IN LENGTH.SDR CHQA20120702218Beam · corrodedDURING INSPECTION, CORROSION WAS FOUND AT THE DOOR SILL FRAME 65-68. MAINTENANCE REPLACED THE CARGO DOOR SILL THRESHOLD BEAM IN ACCORDANCE WITH SRM 51-40-02.SDR SIMA20120701012Gusset · corrodedDURING B INSPECTION, FOUND THE DIAMOND GUSSET ON THE RIGHT BEAM FRAME 20 CORRODED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED GUSSET IAW SRM 51-40-02 AND SRM 51-40-06. AIRCRAFT RETURNED TO SERVICE.SDR SIMA20120701011Gusset · corrodedDURING B INSPECTION, FOUND THE LAVATORY CENTER BEAM GUSSET CORRODED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED CORRODED BEAM GUSSET IAW SRM 51-40-02. AIRCRAFT RETURNED TO SERVICE.SDR SIMA20120701009Crossbeam · corrodedDURING B INSPECTION, FOUND CROSSBEAM AT FRAME 20 CORRODED. AIRCRAFT REMOVED FROM SERVICE. REMOVED AND REPLACED THE CROSSBEAM IAW AEA ETN-EM-53-139R2. AIRCRAFT RETURNED TO SERVICE.SDR IPXA12574532Crease Beam · corrodedINSPECTION TYPE:C-CK, FLIGHT COMPT UPPER LEVEL FLOOR STRUCTURE CREW ENTRY DOOR LOWER DOOR SILL INBD CREASE BEAM ANGLE FROM STA 294 TO 324 IS CORRODED OVER 100 PERCENT. FABRICATED NEW CREASE BEAM ANGLE IAW GMM 09-10 AND SAMPLE, INSTALLED IAW SRM 51-40-02.SDR U2RA201207120003Angle · crackedL1 MAIN ENTRY DOOR CUT OUT FWD UPPER CORNER BS 440, STR 16L, ONE ANGLE CRACKED, CRACK LENGTH .8".SDR FDEA201206292411Crease Beam · corrodedLT INBD CREASE BEAM CORRODED AT BS 1350. FOUND TO BE OUT OF LIMITS IAW SRM 53-60-13, PAGE 103, FIG. 101, DETAIL VII. REMOVED AND REPLACED CREASE BEAM AT BS 1280-1380, LT, I/B, IAW SRM 51-40-02 AND DRAWING 146N8326. MAJOR REPAIR.SDR DALA1239649253Beam · corrodedFOUND AFT PIT LOWER DOOR JAMB INBOARD HEADER BEAM FROM STA 1193-1290 HAS AREAS OF CORRSION L29R MRB 53-123-02. REMOVED AND EXISTING INBD HEADER BEAM AND INSTALLED NEW HEADER BEAM IAW DWG 5930483 REV AK.SDR KCSA201206281111Reveal · crackedR-4 DOOR CUTOUT REVEAL IS CRACKED 3/4 INCH AT STATION 1665 JUST ABOVE STRINGER 17R.SDR DALA1240109264Web · corrodedLOWER DOOR FRAME CORRODED. REMOVED AND INSTALLED NEW PANEL SECTION AT FWD CARGO BAY LOWER DOOR FRAME BETWEEN BS 370 AND 427 IAW SRM 53-60-02 VOL I FIGURE 11.SDR FDEA201206272368Crease Beam · corrodedMAIN DECK CREASE BEAM HAS CORROSION AT FS 680, RT SIDE. CORROSION BLENDED AREA ON I/B CHORD IAW SRM 51-10-02 ORIGINAL MATERIAL .100 AFTER REWORK .030 MATERIAL LOSS .070. CHORD IS OUT OF ALLOWABLE LIMITS IAW SRM 53-00-51 FIG 101. REMOVED CREASE BEAM SECTISDR UALA2012062903468Failsafe · corrodedAFT CARGO BAY BS 1562 FAILSAFE CORRODED BETWEEN STR 39L -39R AT FUSELAGE DRAIN HOLE. REMOVED CORROSION FROM FAILSAFE & FOUND MATL LOSS WITHIN LIMITS OF SRM 51-10-02.SDR UALA2012062903463Failsafe · corrodedSTRINGER CLIP AT FR 66 BETWEEN STR 40R AND 41R IS CORRODED. REPLACED STR CLIP IAW SRM.SDR DALA1239533604Structure · damagedSTRINGER 22L DAMAGED AT BS 970. REMOVED DAMAGED STRINGER FROM BS 942 TO 978 PER SRM 53-00-03. PERFORMED HFEC OF ADDITIONAL 5 FWD AND 1.25 AFT AND STRINGER CUT EDGES, NO FINDINGS. SKIN REPAIRED IAW ERA 504754-14.SDR GLBA2012062500002Door Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE UPPER CARGO DOOR FRAME ON THE FWD SIDE AT APPROX FS 459, 3" IN LENGTH. REPAIRED THE AFFECTED AREA AND PERFORMED ALL REQUIRED RII INSPECTIONS IAW EO 12-1900-53-033. MATERIALS UTILIZED ARE INCLUDED INSDR GLBA2012062500001Door Frame · crackedDURING A SCHEDULED ROUTINE INSPECTION, FOUND A CRACK IN THE UPPER CARGO DOOR FRAME ON THE FWD SIDE AT APPROX FS 459, 3" IN LENGTH.SDR ASOA2012062801835Stop Fitting · crackedFWD STOP BRACKET ON MAIN CABIN DOOR FRAME CRACKED. R & R FWD STOP BRACKET ON MAIN CABIN DOOR FRAME IAW SRM 53-21-23.
Back to JASC 5310