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 2006UALA02273Structure · crackedMAIN ENTRY DOOR 2R IS CRACKED AT THE FWD 3RD FROM TOP STOP CUTOUT. REPLACED WITH A NEW MAIN ENTRY CABIN DOOR. REMOVED DOOR SENT TO SHOP FOR EVALUATION. ROOT CAUSE OF CRACK IS STILL UNDER INVESTIGATION.SDR MASA200060231Mechanism · dirtyASH 7136 UAL. PAX DOOR BINDING. MX CLEANED AND LUBED THE DOOR ASSY.SDR FDKA200609264Roller · lack of lubeFDM RDU. CAPTAIN REPORTED MAIN CABIN DOOR HARD TO OPEN & CLOSE. MX IS TROUBLESHOOTING. MX CLEANED AND LUBED ROLLERS.SDR MASA200602291Handle · defectiveASH 2987 PHX. PASS DOOR WILL NOT CLOSE. MX R2 THE HANDLE. OP'S CHECK GOOD.SDR MASA200602298Pin · shearedASH 7392 OKC - PILOT REPORTED THE PAX DOOR HANDLE WOULD NOT STOW. MX FOUND PIN SHEARED CAUSING MECHANISM TO DISCONNECT. MX REPLACED THE PIN.SDR TRAX200600749Door · stiffPAX DOOR HARD TO SECURE.SDR SWIA200617317Web · crackedPAX DOOR WEB CRACKED BEHIND AFT HANDRAIL SUPPORT, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS ON AFT SIDE OF PAX DOOR PER REO 601R-52-11-702.SDR SWIA200617316Web · crackedPAX DOOR UPPER WEB CRACKED (2) LOCATIONS, UNDER TOP FOLDING STEP, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED 2 REPAIR ANGLES AND 2 FILLERS IAW REO NR 601R-52-11-279.SDR SWIA200617314Web · crackedPAX DOOR AFT WEB CRACKED 4TH STEP FROM BOTTOM, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED DOUBLER, REPAIR ANGLE AND FILLERS AS PER REO 601R-52-11-1108.SDR C8GA20060015Door · jammedON CLIMB, AIRCRAFT WOULD NOT PRESSURIZE NORMALLY. CREW NOTED SQUEAL AT L1 DOOR. AIRCRAFT RETURNED TO MSP AND LANDED WITHOUT INCIDENT. FOUND L1 DOOR JAMMED. OPENED AND INSPECTED L1 DOOR. CYCLED DOOR SEVERAL TIMES. OPS CHECK GOOD. AIRCRAFT PRESSURIZES NORMALLY. SDR KCSA061296Structure · crackedR2 DOOR AFT LOWER OB CORNER CRACKED 3 INCH.SDR KCSA061295Structure · crackedR2 DOOR FWD LOWER OB CORNER CRACKED 2 INCH.SDR IXXA06SMN292SSkin · misrepairedDURING ROUTINE C CHECK INSPECTION, FOUND PASSENGER DOOR UPPER AFT CORNER. REPAIR FALLS INTO GROUP 2 PER SERVICE BULLETIN DC 8 53.075, AND AD 2000-20-08 GROUP 2. WITHIN 2,000 LANDINGS OR 3 YEARS AFTER THE EFFECTIVE DATE ACCOMPLISH THE PREVENTATIVE MODIFICATIONSDR FDKA200609257Door · lack of lubeFDM 6059 MCO. CREW REPORTED MAIN PAX DOOR HARD TO OPEN AND CLOSE. MX LUBED THE DOOR SEALS AND ROLLERS, OPS CHECK NORMAL.SDR ASAA0610962Hinge · looseL1 DOOR DOES NOT CLOSE NORMALLY. FOUND L1 DOOR TOP HINGE PLATE LOOSE. TIGHTENED BOLTS LUBED DOOR CHECKS OKAY.SDR AWXA200601640Skin · crackedMCN - L-1 DOOR INNER SKIN AFT SIDE CRACKED AT NR 6 (FROM TOP) STOP PIN CUTOUT, BS 312, S13L. REPAIRED L-1 DOOR INNER SKIN AFT SIDE AT NR 6 STOP PIN CUTOUT, BS 312, S13L IAW B737-300 SRM 51-70-13-06 FIG 1.SDR AWXA200601639Skin · crackedMCN - L-1 DOOR INNER SKIN AFT SIDE CRACKED AT NR 7 (FROM TOP) STOP PIN CUTOUT, BS 312, S14L. REPAIRED L-1 DOOR INNER SKIN AFT SIDE AT NR 7 STOP PIN CUTOUT, BS 312, S14L IAW B737-300 SRM 51-70-13-06 FIG 1.SDR QXEA200602557Support · damagedC4 YYC - MAIN CABIN DOOR AFT ARM SUPPORT HAS AREA OF CORROSION AROUND SCREW HOLE LOWER END. REPAIRED IAW RD8-52-857.SDR TRAX200600727Step · crackedBOTTM STEP OF PASSENGER DOOR IS CRACKED. FLT 4348 DEL 36 MINS.SDR SWIA200617336Angle · crackedPAX DOOR - ANGLE CRACKED UPPER OUTBOARD ANGLE, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW ANGLE PER CRJ 200 SRM 51-42-20 PG 23. OPERATIONAL CHECKS GOOD.SDR SWIA200617333Handle · crackedPAX DOOR OUTER HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED SERVICEABLE PAX DOOR OUTER HANDLE IAW CRJ200 AMM 52-11-03-400-802. OPERATIONAL CHECKS GOOD.SDR SWIA200617275Structure · crackedPAX DOOR INTERNAL STRUCTURE CRACKED AT 3 PLACES, DISCOVERED DURING C-CHECK INSPECTION. APPLIED DOUBLERS AT FORWARD AND AFT FRAMES BELOW STOPS IAW SRM 120 52-10-02 PGS 207 AND 208 AND RII 52-800-1000. REPLACED INTERNAL FRAME IAW SRM 120 51-10-02 PG 3 SEC 3 B SDR SWIA200617274Support · crackedPAX DOOR AFT STEP SUPPORT STRUCTURE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED PAX DOOR AFT STEP SUPPORT STRUCTURE IAW SRM 120 51-10-02 PG 3 SEC 3A AND RII 52-800-1000.SDR EIA2006246Structure · crackedMAIN DECK R4 MAIN ENTRY DOOR, UPPER CORNER FOUND CRACKED. CRACKED AREA REPAIRED IAW SRM 52-10-02.SDR QXEA200602556Skin · corrodedC4 YYC - PASSENGER DOOR SHELL HAS FRETTING DAMAGE ON INNER SHELL AROUND LOWER END SCREW HOLE. REPAIRED IAW RD8-52-647.SDR SWIA200617312Support Bracket · crackedPAX DOOR AFT SIDE HANDRAIL SUPPORT BRACKET CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS IAW REO 601R-52-11-1099.SDR SWIA200617310Vent · crackedPAX DOOR HANDLE FLAPPER VENT IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PAX DOOR HANDLE FLAP PER CRJ 200 SRM 51-42-06 PG 11-17 REV 26 DATED MAR 10 2006.SDR FDKA200609249Door · lack of lubeFDM 6086 CLT. CREW NOTED THAT THE MAIN CABIN DOOR WOULD NOT LOCK. MAINTENANCE LUBE THE DOOR, OPS CHECKED GOOD.SDR MWEA060181Skin · damagedDAMAGE TO LOWER PASSENGER DOOR SKIN. FABRICATED AND INSTALLED FILLER.SDR QXEA200602560Stop · corrodedC4 YYC - PASSENGER DOOR STOP STRUCTURE, FORWARD LOWER FITTING HAS FRETTING DAMAGE. REPAIRED IAW SRM 51-20-26, 51-20-36, AND SRM 51-20-51.SDR TRAX200600748Drag Angle · crackedRANRC NR 179 PAX DOOR AFT DRAG ANGLE CRACKED.SDR TRAX200600704Angle · crackedRANRC 244, PAX DOOR AFT DRAG ANGLE CRACKED.SDR FDKA200609247Roller · lack of lubeFDM 6085 MCO. CREW REPORTED THE MAIN PASSENGER DOOR WILL NOT CLOSE. MX CLEANED AND LUBED THE DOOR ROLLERS AND OPS CHECK NORMAL.SDR FASD0601Roller · out of adjustAFTER TAKE-OFF AIRCRAFT CABIN WOULD NOT PRESSURIZE. AIRCRAFT RETURNED TO AIRPORT WITHOUT INCIDENT. INVESTIGATION BY GROUND CREW FOUND REAR BAGGAGE DOOR MISALIGNED AND AFT ROLLER OUT OF GUIDE TRACK AND REAR LOCKING PIN NOT FULLY ENGAGED, ALL INDICATIONS IN THSDR FDKA200609240Handle · looseFDM RON MCO. MAIN PASSENGER DOOR HARD TO OPEN. MX TIGHTENED DOOR HANDLE.SDR MASA200602223Door · stiffASH 7317 IAD. PAX DOOR DIFFICULT TO OPEN. MX WAS UNABLE TO DUPLICATE THE DISCREPANCY.SDR TRAX200600697Handle · crackedPAX DOOR OUTER HANDLE CRACKED, MARKED.SDR 0601891240Bottle · dischargedDURING LINE CHECK FOUND DOOR 4L PNEUMATIC BOTTLE DISCHARGED. MAINTENANCE CHARGED BOTTLE IAW 52-12-06 AND PRESSURE INDICATES WITHIN LIMITS.SDR 0601881240Bottle · lowDURING LINE CHECK FOUND DOOR 4R PNEUMATIC BOTTLE PRESSURE AT ZERO. ICN MAINTENANCE ATTEMPTED TO RECHARGE BOTTLE BUT WERE UNSUCCESSFUL. DEFERRED IAW MEL 52-10 AND INSTALLED PLACARD NR 032612. HNL MAINTENANCE RESET PLUNGER ABOVE BOTTLE AND SERVICED IAW MM 52-12-SDR AWXA200601585Skin · crackedMCN - CRACK ON UPPER HINGE CUTOUT ON L1 DOOR. REPAIRED UPPER HINGE CUTOUT ON L1 DOOR IAW B737-300, SRM 52-10-01-IAI, FIG 101, DETAIL X PER EAR 160-32-06238-2781.SDR F3LA200600122Cover · corrodedDURING C-4 CHECK, INSPECTION REPORTED L2 DOOR FLOORBOARD ACCESS COVER PLATE CORRODED ON LWR SIDE. COVER PLATE WAS FOUND TO BE OUT OF LIMITS PER SRM 53-41-14. FABRICATED AND INSTALLED NEW COVER PLATE PER SRM 51-44-11, AIRBUS DRAWING 10D53670092, AND SRM 51-75SDR MASA200602209Attach Bracket · unsecureASH 7203 IAD. PAX DOOR UNLOCK/LOCK FLAG NOT IN VIEW. MX RE-SECURED THE ATTACHING MECHANISM. OPS CHECK GOOD.SDR MASA200602205Mechanism · malfunctionedASH 7174 IAD - PASSENGER DOOR DIFFICULT TO OPEN AND CLOSE. MX DEFERRED PASSENGER DOOR ASSIST.SDR SWAA063231Door Frame · crackedDURING SCHEDULED C4 CHECK, FOUND R1 DOOR FRAME CRACKED AT UPPER HINGE. REMOVED AND REPLACED R1 DOOR PER MM.SDR CA060918003Hook · cracked(CAN) PILOT NOTICED CANOPY LIGHT ON IN FLIGHT AND RETURNED FOR LANDING. INSPECTION REVEALED THAT THE CANOPY LATCH PLATE ( P/N 22-5613-61-00) ON THE LT SIDE WAS BROKEN ALLOWING THE CANOPY LIGHT TO BE ILLUMINATED. 2 MICRO SWITCHES ARE USED TO TURN THE WANING LIGSDR SWIA200617216Web · crackedPAX DOOR AFT WEB CRACKED UNDER HAND RAIL SUPPORT BRACKET, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AS PER REO 601R-52-11-702; 04/20/06 AND RII 52-900-1001.SDR SWIA200617215Web · crackedPAX DOOR FWD WEB CRACKED UNDER HAND RAIL SUPPORT BRACKET, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED PARTS PER CRJ 200 REO 601R-52-11-702 AND RII 52-900-1001SDR SWIA200617214Drag Angle · crackedPAX DOOR, AFT DRAG ANGLE IS CRACKED INBD OF THE DOOR ASSIST CABLE PULLEY, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR ANGLES -1; -2; & -3 ON PAX DOOR AFT DRAG ANGLE IAW REO 601R-52-11-513 REV-A AND RII52-900-1001.SDR SWIA200617213Handle · crackedPASSENGER DOOR, OUTER HANDLE IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW OUTER HANDLE P/N 601R31763-1 IAW CRJ200 AMM 52-11-03-020-007 FIG 402, 52-11-03-420-003 FIG 402 AND SRM 51-42-21 SCC 9 AND 11. OPERATIONAL CHECKS GOOD.SDR DL757060717Skin · crackedTHE FUSELAGE SKIN HAD A 2 IN CRACK AT THE UPPER FORWARD CORNER OF THE L1 DOOR OPENING. THE CRACKED SKIN WAS CUT OUT AND A REPAIR DOUBLER WAS INSTALLED. REF. 6-089732-12AD
Back to JASC 5210