JASC 5210
Service difficulty reports · 45,724
Reports filed under 5210 · Passenger/Crew Doors, 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 = '5210' 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 = '5210' 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 2006UALA01669Frame · crackedFWD ENTRY DOOR AFT FRAME 4TH STOP FITTING CUTOUT FROM BOTTOM CRACKED. MAJOR REPAIR: TRIMMED OUT CRACK. FABRICATED AND INSTALLED EXTERNAL DOUBLER REPAIR.SDR 2006UALA01668Frame · crackedFWD ENTRY DOOR AFT FRAME 5TH STOP FITTING CUTOUT FROM BOTTOM CRACKED AT FRAME & INNER SKIN. MAJOR REPAIR: TRIMMED OUT CRACK. FABRICATED AND INSTALLED EXTERNAL DOUBLER.SDR DL76G060681Spring · brokenL1 DOOR COUNTER BALANCE SPRING BROKEN. ITEM FORWARDED TO MCO. REMOVED L1 DOOR COUNTER BAL. INSTALLED L1 DOOR COUNTER BALANCE ASSY PER MM. REPLACED L1 DOOR ROTOR ACTUATOR PER MM. MCO/PLAC REMOVED.SDR AWXA200601537Reservoir · lowMCN - EE - L2 DOOR EMERGENCY POWER RESERVOIR IS DEPLETED. MAINTENANCE REMOVED AND REPLACED THE L-2 DOOR EMERGENCY POWER RESERVOIR IAW B757-200 AMM TASK 52-11-30-004-001 AND 52-11-30-404-013.SDR QXEA200602383Attach Fitting · gougedPDX- C3 CHECK- REFERENCE NRI 156461 FOR FORWARD LUG ON MCS SUPPORT WHEEL BRACKET HAS A GOUGE IN IT. BLENDED FORWARD LUG ON MCD SUPPORT WHEEL BRACKET IAW TASK 51-12-001-001-A01 STEP 7. FOUND WITHIN LIMITS. PRIMED AND PAINTED AREA.SDR QXEA200602375Skin · damagedPDX - C3 CHECK, BARE METAL AND IMPACT DAMAGE AT STRINGER 13.5 AND 15 FORWARD OF MAIN CABIN DOOR. BLENDED OUT DAMAGE AND REMOVED .005" MATERIAL, WITHIN LIMITS. TREATED AND PAINTED AREA IAW SRM 51-25-01-001-001-A01. NO PARTS REPLACED.SDR MASA200602157Door · malfunctionedASH 7129 ORD - CAPTAIN REPORTED PAX DOOR HARD TO OPEN. MX OPERATED DOOR FOUND NO DEFECTS. DOOR OPERATED NORMALLY.SDR 2006UALA01657Button · out of positionFOUND DOOR 1R GREEN DISARM BUTTON WILL NOT POP OUT WITH DOOR IN DISARM. TRIMED FORWARD SHROUD SO GREEN DISARM BUTTON ON 1R CAN OPERATE NORMALLY. CHECKS OK FOR SERVICE.SDR TRAX200600646Door · inoperativePAX DOOR WOULD NOT OPEN.SDR C2XA06IA133Door · out of rigIAH - FLIGHT 2287, THE CREW REPORTED THAT THE MAIN CABIN DOOR WAS GETTING JAMMED ON THE TOP AND BOTTOM. MAINTENANCE INSPECTED AND RIGGED THE DOOR, OPERATIONAL CHECKS WERE PERFORMED WITH NO DEFECTS, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR SWIA200617194Door Frame · crackedCRACK ON PAX DOOR AFT CENTER FRAME. NEW FRAME INSTALLED IAW SRM 120 51-10-02 PG 3 SEC 3A AND IAW RII CARD 52-800-1000, PN OFF: 120-21059-001.SDR SWIA200617193Door Frame · crackedCRACK ON PAX DOOR FORWARD CENTER FRAME, DISCOVERED DURING C-CHECK INSPECTION. REPLACED PAX DOOR FORWARD CENTER FRAME SECURED IAW EMB 120 SRM 51-40-02, PN OFF: 120-21058-003.SDR MALA060548Handle · out of adjustF/A REPORTED DOOR 1R DISARMED AFTER AIRCRAFT PRESSURIZED AND MADE A POPPING SOUND. ADJUSTED EXTERIOR HANDLE AND CONTROL SHAFT MECHANISM.SDR UPS06447966Fitting · brokenR1 DOOR FWD LOWER STOP FTG BROKEN. R1 DOOR FWD LOWER STOP FTG REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR COMA0660501Skin Panel · crackedPAX DOOR SECOND STEP DOWN FORWARD AND AFT SKINS CRACKED UNDER BRACKETS WHERE HAND RAILS STOW WHEN DOWN. AFT SKIN ALSO CRACKED THIRD STEP DOWN IN RADIUS OF TREAD/RISER. REMOVED DAMAGED AREAS OF PAX DOOR FORWARD AND AFT SKINS SECOND STEP, AND THIRD STEP AFT SKSDR UPS06448117Panel · crackedFOUND L3 DOOR FWD CUTOUT LOWER REVEAL PANEL CRACK, CRACK LENGTH 0.375". REVEAL PANEL REPAIRED ASP ER RS R53-42-35595 AND UPS ENGINEERING FILE NUMBER 747-53-20336.SDR MASA200602117Handle · brokenASH 7292 IAD - PAX DOOR INNER HANDLE BROKEN. MX REPLACED HARDWARE.SDR SWIA200617223Handle · crackedPAX DOOR OUTER HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PAX DOOR OUTER HANDLE ASSY IAW CRJ200 AMM SUBTASK 52-11-03-420-003 FIG 402 AND SRM 51-42-21 PG 589. OPERATION CHECKS GOOD.SDR TRAX200600624Door Frame · crackedPAX DOOR FRAME AT 338.9 CRACKED. CUT AWAY INNER SKIN IAW REO 601R-52-11-1085. CUT AWAY DAMAGED SECTION OF FRAME IAW REO 601R-52-11-1085. PERFORMED LPI ON THE PAX DOOR AFT SKIN AND FRAME REPAIR CUTLINES IAW NDTM 51-20-08. NO DEFECTS NOTED. NDT COMPLETE ON WC 3SDR TRAX200600625Door Frame · crackedPAX DOOR FRAME AT 320 CRACKED. CUT AWAY SECTION OF SKIN TO GAIN ACCESS TO FWD FRAME IAW REO 601R-52-11-402. (EMP 684 - INSP RA191) CUT AWAY DAMAGED SECTION OF PAX DOOR FWD FRAME IAW REO 601R-52-11-402. NDT REQUIREMENTS FOR WC 235 COMPLETED ON WC 384. NO DEFESDR TRAX200600626Drag Angle · crackedRANRC NR 236, PAX DOOR AFT DRAG ANGLE CRACKED. CUT OUT DAMAGED AREA AT OFF DRAG ANGLE IAW ASA E.O. CARD NO. REO 601R-52-11-513. JP929 08-19-06. NDT REQUIREMENTS FOR CUTLINES COMPLETED ON WC 375. NO DEFECTS NOTED. GS684 08-19-06 RA191 FABRICATED REPAIR SDR SWAA063017Skin · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR SKIN CRACKED AT UPPER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR USAA061045Skin · crackedL1 DOOR LOWER AFT CORNER CRACKED. DAMAGE CUT OUT, REPAIR DOUBLER INSTALLED PER SRM 52-10-00 & EA 57732A, DEFECT SIZE: 3 INCHES.SDR MASA200602103Handle · lack of lubeASH 7325 ATW - PAX DOOR HARD TO OPEN FROM EXT HANDLE. MX LUBED DOOR HANDLE AND A/C DEPARTED WITH NO FURTHER DEFECTS.SDR QXEA200602103Threshold · corrodedPDX C4 - MAIN CABIN DOOR THRESHOLD OUTBOARD FLANGE HAS CORROSION AROUND ACCESS HOLE FOR DOOR SEAL INFLATION TUBE, UNDERSIDE OF THRESHOLD. REPAIRED IAW DHC-8-200 SRM 51-20-11.SDR SWIA200617164Handle · crackedPAX DOOR HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PAX DOOR HANDLE 601R 31763-1 PO NR 66207-8 PER CRJ200 AMM 52-11-03-000-802/400-802. OPERATIONAL CHECKS GOOD.SDR SWIA200617160Web · crackedFWD PAX DOOR WEB CRACKED UNDER HANDRAIL SUPPORT FITTING, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FABRICATED PART 601R 52-11-702-2 AND -3 PER REO 601R-52-11-702.SDR SWIA200617159Web · crackedPAX DOOR AFT WEB CRACKED UNDER HANDRAIL SUPPORT BRACKET, DISCOVERED DURING C-CHECK INSPECTION. REPAIRED PAX DOOR AFT WEB UNDER HANDRAIL SUPPORT BRACKET PER REO 601R 52-11-702, P/N 52-11-702-2 AND -3.SDR A6WA200640315Handle · out of adjustPASSENGER DOOR WILL NOT OPEN FROM INSIDE, OPS OPENED FROM OUTSIDE. CLEANED AND ADJUSTED PASSENGER DOOR HANDLE IAW AMM 52, LUBED AS REQUIRED, OPS CHECK GOOD. (M)SDR SWIA200617149Web · crackedPASSENGER DOOR, AFT WEB CRACKED UNDERNEATH THE HANDRAIL HOLD DOWN BRACKET, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FABRICATED PARTS PER 601R-52-11-702 AND RII 53-900-1001.SDR SWIA200617148Anchor Fitting · crackedPASSENGER DOOR, AFT ANCHOR FITTING IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED A SERVICEABLE ANCHOR FITTING, P/N 601R38074-5/SB01 IAW CRJ200 AMM 52-11-17-400-804.SDR SWIA200617147Drag Angle · crackedPASSENGER DOOR, AFT DRAG ANGLE CRACKED INBD OF THE PAX DOOR ASSIST CABLE PULLEY, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED AFT DRAG ANGLE REPAIR INBD OF THE PAX DOOR ASSIST CABLE PULLEY IAW REO NR 601R-52-11-513 REV A.SDR 06FDEA2921Door · dentedN00870 DENT ON FWD ENTRY DOOR ON IB WEB LIGHTNING HOLE AT BS 335 STR 14L ** SD ** COMING. REPAIRED DENT ON FWD ENTRY DOOR ON IB WEB LIGHTING HOLE AT BS 335, STER 14L IAW, SRM 51-40-2.SDR 06FDEA2922Door · dentedDENT ON FWD ENTRY DOOR ON IB WEB AFT EDGE AT 346 STR 13L. REPAIRED DENT ON FWD ENTRY DOOR ON IB WEB AFT EDGE AT 346 STR 13L IAW SRM 51-40-2.SDR ASAA0680842Intercostal · crackedFOUND FORWARD ENTRY DOOR HAS CRACKED INTERCOSTAL BEHIND HANDLE MECHANISM. REPLACED INTERCOSTAL PER SRM 51 10 4 51 30 2 AND 51 30 5.SDR 0809200644ASSkin · bentCABIN DOOR SKIN LOWER EDGE IS BENT AND TORN IN SEVERAL AREAS ACROSS THE BOTTOM OF THE DOOR.SDR ASAA0640838Intercostal · crackedREF AD 2005 20 03 L1 DOOR S16 INTERCOSTAL WEB CRACKED. REPLACED S16L INTERCOSTAL WEB IAW PEMCO EA PD 37 53 552 AND ASA EA 5310 02650.SDR A6WA200640311Drag Angle · crackedFOUND PAX DOOR AFT DRAG ANGLE IS CRACKED. MAINTENANCE REPAIRED PAX DOOR AFT DRAG ANGLE BY CUTTING AWAY DAMAGED SECTION OF ANGLE AND INSTALLING REPAIR ANGLE AND SPLICES IAW REO 601R-53-11-513 REV A. (M)SDR RAIA00609007Roller · damagedPOST FLIGHT 3574 - STL - MAIN CABIN DOOR DOES NOT OPERATE PROPERLY. MAINTENANCE REMOVED AND REPLACED THE SUPPORT ROLLER.SDR TRAX200600588Intercostal · crackedPAX DOOR INTERCOSTAL CRACKED AT 338.9, DATUM 1. REMOVED INTERCOSTAL AT FS 338.9 DATUM 1 ON PAX DOOR IAW CRJ SRM 51-42-06. LOCATED AND DRILLED NEW INTERCOSTAL P/N 601R31902-318 IAW CRJ SRM 51-40-11. OK TO INSTALL. INSTALLED INTERCOSTAL IAW CRJ SRM 51-42-06 SDR TRAX200600586Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. CUT OUT CRACKED SECTION OF PAX DOOR AFT DRAG ANGLE IAW REO 601R-52-11-513. NDT REQUIRED FOR CUT LINE. NDT PERFORMED ON W/C 350 FABRICATED REPAIR DETAILS FROM NEW ANGLE, 601R31772-5S, OK TO INSTALL. INSTALLED DETAILS IAW RESDR TRAX200600608Structure · crackedPAX DOOR EDGE MEMBER CRACKED.SDR TRAX200600587Door Frame · crackedPAX DOOR FRAME CRACKED AT 338.9. REPAIRED IAW ALL SRMS.SDR SWAA062897Skin · crackedDURING SCHEDULED 20Y CHECK, FOUND FWD R1 DOOR SKIN CRACKED AT LOWER HINGE CUTOUT. REPAIRED SKIN PER SRM.SDR FFS2006F00006Door Frame · crackedDURING THE THIRD 200-HOUR INTERVAL DETAILED INSPECTION, A CRACK WAS DISCOVERED IN THE DOOR FRAME RUNNING HORIZONTALLY BETWEEN THE RIVET HOLES OF THE UPPER LINE OF RIVETS THAT HOLD THE AIRSTAIR DOOR HINGE HALF TO THE FUSELAGE. THE DOORFRAME PN 1144200341 WAS CSDR VNAA0608008Door Seal · dirtyTHE CREW REPORTED THE MAIN CABIN DOOR SQUEALS IN FLIGHT. MAINTENANCE CLEANED AND INSPECTED THE SEAL AND PRESSURE HOLES. NO DEFECTS NOTED. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR COMA0660476Web · crackedDURING CABIN DOOR INSPECTION FOUND STEP WEB CRACKED NEAR THE 3RD STEP. PERFORMED REPAIR IAW EA 10-50211-01331 A.SDR TRAX200600583Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED.SDR A6WA200640308Handle · lack of lubeFOUND PASSENGER DOOR HANDLE HARD TO OPEN FROM INSIDE. CLEANED AND LUBED INNER AND OUTER PASSENGER DOOR HANDLE IAW AMM 52-10-00, OPS CHECK GOOD. (M)SDR FDKA200608190Door · lack of lubeASH 6104 MCO - THE CREW NOTED THAT THE MAIN DOOR WAS HARD TO OPEN. MAINTENANCE LUBED THE DOOR.
Back to JASC 5210