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 SWAA2013042515198Window Frame · crackedFLIGHT DECK NR 3 WINDOW FRAME RIGHT SIDE CRACKED AT SECOND LOWER FWD CORNER FASTENER HOLE COMMON TO THE E-F POST. REPAIRED FRAME PER EA.SDR SWAA2013042515200Window Frame · crackedLEFT NR 1 WINDOW FRAME CRACKED AT THE UPPER AFT CORNER. REPAIRED FRAME IAW EA.SDR SWAA2013042515199Window Frame · crackedFLIGHT DECK NR 3 WINDOW FRAME LEFT SIDE CRACKED AT THE SECOND LOWER FWD CORNER FASTENER HOLE COMMON TO THE E-F POST. REPAIRED FRAME PER EA.SDR DALA1310471401Failsafe · crackedFOUND CRACK ON RT SIDE BS 955 FAIL SAFE STRAP DURING HFEC OPEN HOLE INSPECTION. REPAIRED IAW ERA 512807-14.SDR DALA1310441401Failsafe · crackedDURING HFEC FOUND CRACK AT BS 955 FAILSAFE STRAP. REPAIR CARRIED OUT IAW ERA 512806-14AD.SDR CHQA20130416126Support Angle · corrodedDURING INSPECTION, THE BAGGAGE DOOR CUTOUT FORWARD UPPER CORNER "Z" ANGLE SUPPORT WAS FOUND TO BE CORRODED ON THE INBOARD SIDE. THE BEAM WAS REPAIRED IN ACCORDANCE WITH ETD 2013-145-007013.SDR AALA20130416010Door Frame · crackedDOOR FRAME WEB CRACKED AT SCREW GOUGE, STATION 634, LONGERON 27 RIGHT. INSTALLED DOUBLER PER AARD 53-10-00-24 FIGURE 1 (SHEET 3).SDR UALA2013041502598Crease Beam · corrodedMAIN CABIN CREASE BEAM WEB UPPER SURFACE CORRODED AT BS 1130, LBL 68. REMOVED DAMAGED WEB, HFEC BOLT HOLES, NO CRACKS NOTED. FABRICATED & INSTALLED WEB REPAIR DOUBLER PER ECRA5340-01 504. MAJOR REPAIR.SDR SWAA2013043015369Window Frame · crackedLEFT NR 1 WINDOW FRAME CRACKED AT UPPER OUTBOARD CORNER. REPAIRED FRAME IAW EA.SDR QXEA2013041400786Door Frame · chafedCHAFE DAMAGE ON AFT SERVICE DOOR SURROUND STRUCTURE AT THE 12:00 POSITION. CHEMICALLY REMOVED PAINT FROM CHAFE AREA FOR FURTHER EVALUATION IAW SRM 51-26-10-02-01. BLENDED AREA TO CONTOUR USING SCOTCHBRITE PAD. FOUND CHAFE TO BE .40" L .30" W AND MAX DEPTH OFSDR SWAA2013050715704Window Frame · crackedCAPTAINS WINDOW FRAME POST CRACKED AT UPPER OUTBOARD CORNER. REMOVED AND REPLACED FRAME PER ACO.SDR SWAA2013050715771Window Frame · crackedRIGHT NR 3 COCKPIT WINDOW, E-F POST 2ND HOLE FROM BOTTOM CRACKED. REMOVED AND REPLACED FRAME IAW SRM AND DWG.SDR SWAA2013050615634Door Frame · corrodedSPOT AFT WEB JAMB CORRODED AT STA 1002, LONGERON 26R. REPAIRED JAMB IAW SRM.SDR SWAA2013050615633Door Frame · corrodedBOTTOM THRESHOLD WEB JAMB CORRODED AT STA 974, LONGERON 28R. REMOVED AND REPLACED JAMB IAW SRM.SDR FDEA201304120773Crease Beam · corrodedRT INBD CREASE BEAM UPPER SURFACE HAS CORROSION AT BS 540. REMOVED CORROSION IAW-SRM-51-10-02, FOUND TO BE OUT OF LIMITS IAW-SRM-53-30-13 FIG.101 DETAIL VIII. REMOVED AND REPLACED INBRD CREASE BEAM IAW SRM-51-40-02 AND DRAWING 143N5520. CAT."A" MAJOR REPSDR HYIA20130416003Spar · damagedDURING A SCHEDULED MX EVENT, DAMAGE WAS NOTED TO THE AFT CARRY THROUGH SPAR ASSY CENTER SECTION. DAMAGE INCLUDES WEB FLANGE CRACKS. OPENSDR HYIA20130416002Spar · damagedDURING A SCHEDULED MX EVENT, DAMAGE WAS NOTED TO THE FORWARD CARRY THROUGH SPAR ASSY IN THE CENTER SECTION. DAMAGE INCLUDES DRILL STARTS TO UPPER CAP AND CORRESPONDING WEB FLANGE CRACKS. THESE DAMAGE POINTS WERE MAPPED AND SUBMITTED FOR ENGINEERING ASSISTANCSDR UIEA2013041200192Door Frame · crackedCRACK ON L5 MAIN ENTRY DOOR FWD FRAME. REPAIRED IAW EI NR T2013A53B-671, REV O. CONDITION CHECKED NORMAL.SDR ASOA20130411124VBeam · corrodedDURING C-CHECK CARGO LOWER BEAM FRAME 65-68 AT CUTOUT IS CORRODED (LOCAL LEVEL 2). MX PERFORMED REPAIR OF CARGO DOOR LOWER BEAM FRAME 65-68 AT CUTOUT IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR DALA13015871805Failsafe · crackedRT BS 955 REAR SPAR BULKHEAD FITTING AREA CRACK FOUND AT FAIL SAFE STRAP DETAIL REFER ATTACHED FIG. REPAIRED AMM 51-31-01, SRM 51-40-02, SWPM 20-10-00, AMM 32-35-10, AMM20-11-00, SRM 51-40-05, SRM51-20-01, AMM 51-21-10, AMM 51-31-06, AMM 27-11-00, AMM 05-51-2SDR SWAA2013072518576Window Frame · crackedCAPTAIN`S COCKPIT WINDOW POST FRAME CRACKED IN THE UPPER OTBD CORNER APPROX .5" DOWN FROM TOP EDGE. R&R FRAME IAW ACO.SDR SWAA2013072318461Window Frame · crackedLT NR 3 WINDOW FRAME CRACKED AT SECOND LOWER FASTENER HOLE. R&R FRAME IAW EA.SDR SWAA2013050215463Window Frame · crackedRIGHT NR 3 WINDOW FRAME CRACKED AT SECOND LOWER FASTENER HOLE. REPAIRED FRAME IAW EA.SDR UALA2013041102452Door Frame · damagedR4 DOOR AFT FRAME WEB HAS DAMAGE BS 1681.8, WL 208, RBL 55-66 BS 1681.8, RBL 55-RBL 60, WL 208. REPAIRED DOOR FRAME IAW ECRA5362-01023. MAJOR REPAIR.SDR DALA1310920671Door Frame · damagedDAMAGE WAS FOUND ON THE UPPER HINGE CUTOUT OF THE FORWARD FRAME ON THE SUBJECT R2 DOOR. REF ERA 06-498709-14, REV A.SDR SWAA2013041614893Crease Beam · crackedCREASE BEAM WEB CRACKED BETWEEN BS 559 AND BS 578, LBL 66. REMOVED AND REPLACED WEB PER DWG & SRM.SDR SWAA2014092232139Window Frame · crackedLEFT NR 1 WINDOW FRAME CRACKED AT UPPER OTBD CORNER. REPAIRED FRAME IAW SRM.SDR UALA2013040802343Window Frame · looseEMERGENCY EXIT WINDOW FRAME LOOSE. SECURED WINDOW FRAME.SDR SWAA2013042615258Window Frame · crackedCAPTAINS NR 1 WINDOW POST CD FRAME CRACKED AT UPPER O/B CORNER. REMOVED AND REPLACED WINDOW FRAME PER ACO.SDR DALA1308426802Gate · corrodedL-2 LOWER GATE HAS PITTING CORROSION. REPLACED GATE IAW B757 52-11-38-004-001.SDR HNAA2013040800213Door Frame · corrodedLAVATORY SERVICE DOOR FRAME IS CORRODED AT LOWER SECTION. REMOVED LAV BOX CUT OUT DAMAGE IAW RD8-53-2103. R & R LAV SERVICE DOOR FRAME MACHINED DOUBLER IAW DWG 85320983 AND EA09-2013-011 AND EO8-53-13-0176.SDR SWAA2013042415094Window Frame · crackedCO-PILOT'S NR 1 WINDOW INNER SURFACE CRACKED AT UPPER CORNER OF OUTBOARD WINDOW POST. REPAIRED FRAME IAW ACO.SDR FDEA201304070737Crease Beam · corrodedCORROSION FOUND ON THE SURFACE OF RT CREASE BEAM INNER ANGLE BS 1325. REMOVED AND REPLACED CREASE BEAM ANGLE FROM BS 1290 - 1385 IAW DWG 146N8322 SHT 1, REV F, MAJOR REPAIR.SDR DALA1312740681Crease Beam · corrodedCORROSION ON MAIN CABIN LT CREASE BEAM FROM BS 780-879. R & R IAW SRM 51-40-05.SDR SWAA2013042615255Window Frame · crackedFLIGHT DECK RIGHT NR 1 WINDOW FRAME CRACKED IN UPPER OUTBOARD CORNER INTERNAL SURFACE. REPAIRED FRAME CRACK IAW ER & EA.SDR SWAA2013050715756Crease Beam · crackedCREASE BEAM CRACKED AT BS 520, LBL 63.5. REPAIRED CHORD IAW EA.SDR DALA13014890946Door Frame · crackedDURING SCHEDULED INSPECTION, A CRACK WAS FOUND ON THE INNER PAN AFT SECTION AT BEAM NR 1 AND BEAM NR 5 C-3 DOOR. INNER PAN AFT SECTION AT BEAM NR 1 WAS REPAIRED IAW ER/A 461218-14. INNER PAN AFT SECTION AT BEAM NR 5 WAS REPAIRED IAW SRM 52-03D, FIG 8.SDR DALA1308180130Structure · corrodedCABIN - STA 852, RBL 77-88 FOUND CORRODED ON CENTER WING SECTION UPPER SURFACE AND REPAIR CARRIED OUT IAW ER/A 511834-14, REV O.SDR ASAA2013040394962Web · corrodedFWD CARGO BAY AFT CUTOUT FRAME AT BS 492 AT STR 23R UPPER STRAP ON REVEAL WEB IS CORRODED. ACFT GROUNDED. REMOVED, FABRICATED AND INSTALLED STRAP IAW DWG NR 65-20723.SDR DALA13015310944Door Frame · corrodedCORROSION ON JAMB LOWER BEAM STA Y=636-693 PROJECTION LONG 28 RT AT MID CARGO COMPARTMENT. REF 411, ZONE 51 (T0 274860). CORROSION WAS REMOVED IAW SRM 51-10-3, PAR 26, WAS MEASURED, DUE TO EXCESIVE CORROSION, WAS REPAIRED. REPAIR DOUBLER WAS INSTALLED. SPASDR ASOA20130402123VBeam · corrodedDURING C-CHECK, BAGGAGE DOOR LOWER CUTOUT MAIN BEAM CORRODED. FRAMES 65-68. BEAM R & R IAW SRM 51-40-02. ACFT APPROVED FOR RETURN TO SERVICE.SDR ASOA20130402116Door Frame · corrodedDURING C-CHECK, FRAME 65 CORRODED AT NUT PLATES AT STRINGER 14-15L. R & R FRAME 65 DOUBLER IAW SRM 51-40-02 AND EC5310-01505, REV A. ACFT APPROVED FOR RETURN TO SERVICE.SDR SWAA2013041714938Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 807 TO BS 827, WL 208. REMOVED AND REPLACED WEB IAW SRM.SDR ASOA20130402112Door Frame · corrodedDURING C-CHECK, SERVICE DOOR LOWER AFT CUTOUT CORRODED FRAME 22. MX INSTALLED AND FABRICATED DOUBLER IAW EC5310-01373. ACFT APPROVED FOR RETURN TO SERVICE.SDR ASOA2013042303420Crossbeam · corrodedFS 280, RT CROSSBEAM CORRODED. INSTALL NEW CROSSBEAM IAW SRM 51-42-06-001-001 AND DWG CC670-34010.SDR 2A6R201304023171Panel · crackedFOUND CRACKS IN THE FORWARD BOX BEAM OF THE FUSELAGE BODY STRUCTURES' RT SIDE PANEL ASSY. THERE ARE 2 CRACKS IN THE AFT WEB, ONE IN THE INBD WEB AND ONE IN THE ANGLE CONNECTING THE WEBS. CRACKS ARE IN THE AREA THAT MEDICAL SEAT MOUNTS ARE ATTACHED TO THE BOX SDR FDEA201304010700Crease Beam · corrodedFLOORBEAM AT BS 1661, UPPER SIDE OF "I" STRUCTURE, UNDERSIDE ESPECIALLY ON THE SCREW HOLE AREA FOUND CORRODED. REPAIRED IAW EA 757-5365-08-E2154.SDR ASOA20130331111Door Frame · corrodedDURING C-CHECK THE PAX DOOR LOWER FRAME WAS FOUND TO BE CORRODED AROUND NUT PLATE HOLES. MX REMOVED THE CORROSION AND PERFORMED A DOUBLER REPAIR IAW EC5210-01154, REV A. ACFT APPROVED FOR RETURN TO SERVICE.SDR SWAA2013041114750Crease Beam · corrodedCREASE BEAM WEB CORRODED BETWEEN BS 907 TO BS 927, STR 17L. REMOVED AND REPLACED WEB IAW DWG & SRM.SDR UALA2013040102095Crease Beam · damagedDURING EXT FUSELAGE REPAIR FROM BS 550- 630 FROM STR 13-20L. CREASE BEAM OTBD ANGEL AFT OF BS 560,STR 17L FOUND DAMAGED. ACCOMPLISHED SPLICE REPAIR ON CREASE BEAM PER ECRA 5330-04490 REV A. MAJOR REPAIR.
Back to JASC 5310