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 TRAX200601085Beam · crackedRIGHT BOX BEAM CRACKED AT FWD INBOARD SIDE. WORK COMPLETED IN ACCORDANCE WITH CRJ 200 NDTM 51-20-06, REO 601R-53-61-366, REO 601R-53-61-366 PER CRJ 200 NDTM 51-20-06, REO 601R-53-61-366 REV. F CM20420, REO 601R-53-61-366 CM20420, AND REO 601R-53-61-366.SDR DHL2006751003Rib · crackedLT SIDE FUSELAGE AT BS 233.8, AND STR 25L, SUPPORT RIB CRACKED. REMOVED AND FABRICATED SUPPORT RIB FROM 7075-T6, .050" BY 14" BY 5", PO NR 9003817, AND ANGLE FROM 7075-T6, .032" BY 1" BY 1" BY 14", PO NR 9004042, PER B727 SRM 53-10-2 FIG 1 AND 51-20-1 FIG 8. SDR K11A2008122272308Door Frame · crackedFRAME CRACKED AT AFT HINGE AATACJ POINT, C-3 DOOR.SDR SWIA200618267Door Frame · corrodedFS 280 COCKPIT ENTRY HAS CORROSION ON UPPER FLANGE, DISCOVERED AT C-CHECK. INSTALLED REPAIR FILLERS IAW BOMBARDIER REO 670-53-11-181.SDR 2006UALA02317Door Frame · crackedFWD CARGO DOOR CUT-OUT FWD FRAME IS CRACKED AT LOWER DOOR STOP, BS 440 STRINGER S-24R. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED TWO NESTED ANGLE REPAIR DOUBLERS AND FILLER. REFERENCE AAR EA I060537 AND UAL EVA 60739.SDR SWAA064791Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND AFT CARGO DOOR FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR SWAA064790Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR USAA061393Attach Angle · crackedSTA 360 S11L CRACKED. FABRICATED NEW ATTACH ANGLE AND INSTALLED IAW SRM 51-10-02, DEFECT SIZE: .500 INCH.SDR USAA061395Channel · crackedSTA 312 STR 2L CRACKED. REMOVED DAMAGE AND INSTALLED FABRICATED REPAIR PARTS IAW DWG 65-54487, DEFECT SIZE: 1 INCH.SDR 06FDEA04169Tank · corrodedCABIN, UNDER FLOOR AREA, OVERWING TANK TOP SURFACE STA 1360 X=-75.0 (RT) FOUND WITH CORROSION. CORROSION REMOVED AS PER SRM 57-00-01 FIG.1A VOL.I. ORIGINAL THK 0.076" REMOVED 0.007" REMAINING THK 0.069" AND FOUND WITHIN LIMIT AS PER SRM 57-20-00 FIG.12 VOSDR SWAA064723Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND RT OVERWING DOOR CUTOUT FWD FRAME CRACKED AT BS 616, WL 202. REPAIRED FRAME SECTION PER ER.SDR SWAA064722Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND LT OVERWING DOOR CUTOUT FWD FRAME CRACKED AT BS 616, WL 202. REPAIRED FRAME SECTION PER ER.SDR SWAA064721Door Frame · crackedDURING SCHEDULED 10Y CHECK, FOUND FWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER ACO.SDR SWAA064720Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 508A, LBL 70. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA064719Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 691, LBL 70. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA064718Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 730B, LBL 71. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA064717Crease Beam · corrodedDURING SCHEDULED 10Y CHECK, FOUND CREASE BEAM WEB CORRODED AT BS 842, LBL 71. REMOVED AND REPLACED WEB SECTION PER SRM.SDR SWAA064692Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND AFT CARGO DOOR CUTOUT AFT FRAME WEB CRACKED AT BS 846, STR 18R. REPAIRED WEB SECTION PER SRM.SDR DHL2006780130Door Frame · corrodedE/E DOOR SURROUND AFT FRAME CORRODED, BS 450, BL 0. CORROSION AT AFT FRAME OUT OF LIMITS PER B727 SRM 51-10-6 AND 53-30-1 FIG 1. REMOVED AND FABRICATED NEW FRAME SECTION (FROM SAMPLE) FROM 7075-TO, .040", PO NR 9003849, PER B727 SRM 53-10-2. HEAT TREATED TOSDR USAA061385Angle · corrodedSTATION 294 TO 328 RBL 54.5 HAS CORROSION. REPLACED ZEE ANGLE IAW SRM 51-10-02, DEFECT SIZE: .750 INCH.SDR UPS07M48884Beam · corrodedINSPECTION TYPE:C CTR CARGO, UPPER DOOR JAMB AREA, STA 1601 FOUND WITH CORROSION UPON OPENING OF TOP BOX. CTR CARGO, UPPER DOOR JAMB AREA STA 1601 CORROSION REMOVED PER SRM 51-31-01 VOL II REV 38. MATERIAL ORIGINAL THK 0.085" STA 1601, REMOVED 0.039" REMAIN SDR UPS07M48883Beam · corrodedINSPECTION TYPE:C CTR CARGO, DOOR JAMB AREA, UPPER AREA STA 1721 - 1745 UPON REMOVAL OF TOP BOX, FOUND CORROSION INSIDE AS MARKED. CORROSION REMOVED PER SRM 51-21-01VOL II REV38. MATL ORIG THK 0.125" STA 1721-173 0 REMOVED 0.026" REMAINING 0.099", STA 1730-1SDR KNNA200700001Door Frame · damagedINSTALLED INTERIM REPAIR AT R1 DOOR CUTOUT AT THE AFT LOWER CORNER. REMOVED INTERIM REPAIR AND INSTALLED PERMANENT REPAIR.SDR DHL2006807530Doubler · corrodedFUS AFT ACCY COMPT INTERNAL DOUBLER CORRODED, STA 1655.000 L-28L AND PLATING CORRODED (MAJOR REPAIR). PERFORMED MAJOR REPAIR IAW FAA FORM 8110-3 DATED 11-27-06, DWG AC24-53-R07 REV IR DATED 11-14-06. REMOVED FASTENERS IAW SRM 51-1-20D, SRM 51-1-21. REMOVED SDR 2006UALA02259Door Frame · crackedFWD PIT DOOR CUTOUT AFT FRAME CRACKED JUST ABOVE LWR DOOR STOP FITTING. MAJOR REPAIR ACCOMPLISHED: TRIMMED OUT DAMAGE. FABRICATED & INSTALLED 2 EA EXTERNAL NESTED ANGLE REPAIR DOUBLERS & STRUCTURAL FILLER.SDR DU4R2006705Crease Beam · corrodedCORROSION MAIN CABIN LT CREASE BEAM BS 1020. REMOVED CORRODED ANGLE. FABRICATED AND INSTALLED L ANGLE REPAIR 3-3/4" BY 3-1/2" BY 1-1/4" FROM 7075-T6 .090" IAW B757 SRM 51-70-11, 51-20-01 AND 51-40-02.SDR ASAA0671275Door Frame · gougedE/E COMP DOOR CUTOUT LT GOUGED FRAME REPAIRED IAW SRM 51 40 02 51 30 01.SDR AWXA200601986Door Frame · crackedMCN - R-2 DOOR CUTOUT FWD FRAME, UPPER STUB BEAM CRACKED (HFEC VERIFIED). REPLACED R-2 DOOR CUTOUT FWD FRAME, UPPER STUB BEAM IAW B737-300 SRM 51-40-02.SDR USAA061356Angle · crackedSTATION 328L AFT SIDE 11 INCHES INBOARD OF DOOR Z-ANGLE CRACKED. REMOVED DAMAGE AND INSTALLED, FABRICATED REPAIR PARTS IAW BOEING DRAWING 65-45812, DEFECT SIZE: 1 INCH.SDR UPS06M48717Support · crackedINSPECTION TYPE:PS2 SUPPORT STRUCTURE FOR AFT VENT GRILL IN CEILING OF CENTER CARGO CRACKED AND SECTION MISSING FOR RETAINING NUT PLATE. OPENED UP CEILING, REMOVED PSI RELIEF DUCT ROUTED TO S/M. REMOVED DAMAGED AREA & ATTACH ANGLE FROM DAMAGED WEB. REPAIREDSDR SWAA064539Door Frame · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR CUTOUT FWD FRAME CRACKED AT BS 294.5. STR 10R. REPAIRED FRAME SECTION PER ER.SDR DALA1154309258Door Frame · corrodedMID CARGO DOOR JAMB CORROSION REPAIR NRC 48 SRM 53-05.SDR DLM88070439Door Frame · corrodedAFT CARGO COMPARTMENT DOOR LOWER JAMB REPAIR - SEVERAL POINTS OF CORROSION AT AFT CARGO DOOR LOWER JAMB BETWEEN STA 1155 AND 1180. A PERMANENT REPAIR WAS PERFORMED IAW SRM 53-05, FIG 63.SDR AWXA200602027Door Frame · crackedMCN - FORWARD CARGO COMPARTMENT DOOR CUT OUT FRAME CRACKED, BS 440, S24R. REPAIRED FORWARD CARGO COMPARTMENT DOOR CUT OUT FRAME, BS 440, S24R IAW AWA ER 03-5331-06344-SS3.SDR DALA1154319258Door Frame · corrodedMID CARGO DOOR JAMB CORROSION NRC 25.SDR AWXA200602026Door Frame · crackedMCN - L1 DOOR AFT FRAME CRACKED, BS 347, S12L. REPAIRED L1 DOOR AFT FRAME, BS 347, S12L IAW AWA ER 03-5200-06344-SS4.SDR AWXA200602023Door Frame · crackedMCN - L1 DOOR AFT FRAME CRACKED, BS 347, S11L, AT THE CUT OUT FOR THE 6TH STOP FROM THE TOP. REPAIRED L1 DOOR AFT FRAME, BS 347, S11L, AT THE CUT OUT FOR THE 6TH STOP FROM THE TOP IAW AWA ER 03-5200-06344-SS4.SDR 06FDEA04059Door Frame · crackedMAIN CABIN COMPT ON UPPER FAUND WEB JAMB NR 3 LT DOOR AT 1256 1 CRACK .50" LONG. REPAIRED DOOR JAMB WEB IAW SRM 53-50-00 FIG 19 SHT 11 VOL 1. FABRICATED PARTS IAW DETAIL PARTS TRAVELLER N00285 AND IAW SRM 53-50-00 FIG 19 SHT 1.4 VOL 1.SDR 2006UALA02231Door Frame · crackedFWD PIT DOOR CUTOUT FWD FRAME CRACKED AT BS 440 NEAR STR S24R. MAJOR REPAIR: REMOVED CRACK AND ACCOMPLISHED NDT. FABRICATED AND INSTALLED TWO NESTED ANGLE EXTERNAL REPAIRS TO FRAME. REFERENCE AAR EA I060515 AND UA-EVA 60714.SDR 2006UALA02230Door Frame · crackedFWD CARGO DOOR CUTOUT FWD FRAME CRACKED AT BS 400 NEAR STRINGER S24R. MAJOR REPAIR: REMOVED DAMAGE. FABRICATED AND INSTALLED TWO NESTED ANGLE REPAIR DOUBLERS. REFERENCE AAR EA I060515 AND UA-EVA-60714.SDR AWXA200602022Door Frame · crackedMCN - R1 DOOR, AFT FRAME CRACKED, BS 328, S9R, AT THE CUT OUT FOR THE 4TH STOP FORM THE TOP. REPAIRED AFT FRAME, BS 328, S9R, AT THE CUT OUT FOR THE 4TH STOP FORM THE TOP IAW AWA ER 03-5200-06344-SS5.SDR TRAX200601044Door Frame · corrodedSERVICE DOOR CUTOUT FWD FRAME HAS FITTING SEVERELY CORRODED AT FLOOR LEVEL. REPAIRED CORROSION AND REPLACED FITTING IAW SRM 51-42-06 AND 51-42-21.SDR QXEA200603473Door Frame · gougedC2 PDX - LEFT MAIN LANDING GEAR DOORS OPERATING MECHANISM HOUSING FORWARD FRAME IS GOUGED ON AFT SIDE CENTER CAUSED BY COTTER PIN. REPAIRED IAW SRM 51-14-00 AND RD8/4-54-390.SDR SWAA064494Crease Beam · corrodedDURING SCHEDULED BRDG CHECK, FOUND RT CREASE BEAM WEB CORRODED AT BS 847 TO BS 867. REPAIRED BEAM PER SRM & SWA EA.SDR IXXA06SMN393SBeam · corrodedDURING ROUTINE C CHECK INSPECTION, FOUND WHEEL WELL PRESSURE PANEL BEAM LOWER FLANGE CORRODED AT STATION 902.000, LBL62” TO LBL69. REMOVED CORROSION. FOUND OUT OF LIMITS. REMOVED 02 EACH EXISTING SPLICE ANGLES AND REMOVED DAMAGED AREA. PERFORMED NDT INSPECTSDR IXXA06SMN392SBeam · crackedDURING ROUTINE C CHECK INSPECTION, FOUND WHEEL WELL PRESSURE PANEL BEAM LOWER FLANGE CORRODED AT STATION 902.000 FROM RBL62” TO RBL69”. REMOVED CORROSION. FOUND OUT OF LIMITS. REMOVED 02 EACH EXISTING SPLICE ANGLES AND REMOVED DAMAGE. PERFORMED NDT INSPECTSDR QXEA200603096Door Frame · corrodedC3 YYC - CENTER FUSELAGE LEFT PASSENGER DOOR OPENING FS 310.00 WL 80.00 INSIDE OF DOOR FRAME HAS SMALL PATCHES OF SURFACE CORROSION. REPAIRED IAW SRM 51-21-06.SDR COMA0670211Crossbeam · corrodedCROSSBEAM SUPPORT FLANGE CORRODED. REPAIRED IAW COMAIR EA 70-5311-01447.SDR SWAA064457Door Frame · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD CARGO DOOR CUTOUT AFT FRAME CRACKED AT NR 5 DOOR STOP. REMOVED AND REPLACED FRAME SECTION PER SRM.SDR QXEA200603378Beam · corrodedC4 PDX - LONGITUDINAL BEAM AT BASE OF AVIONICS RACK SUPPORT STRUCTURE IS CORRODED AT MULTIPLE LOCATIONS ALONG LOWER FLANGE X182 TO X202, YL2.25L. REPAIRED IAW SRM 51-20-11 AND RD 8-53-9355.
Back to JASC 5310