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 MASA2011111464010Lanyard · brokenPAX DOOR FWD HNDRL PIN LANYARD BROKEN. REPLACED LANYARD.SDR MASA2011111464009Cable · brokenMAIN CABIN DOOR SUPPORT CABLE BROKEN. MX R2 SUPPORT WHEEL SPRING, OPS GOOD.SDR USAA2011111400005Reservoir · low pressurePHX - L-4 DOOR EMERGENCY POWER RESERVOIR PRESSURE LOW. REMOVED AND REPLACED L-4 DOOR EMERGENCY POWER RESERVOIR.SDR USAA2011111400007Cylinder · low pressureDOOR EMERGENCY CYCLINDER /ACCUMULATOR PRESSURES LOW L1 DOOR, APPROX 1640 PSI. CHARGED TO PROPER LEVEL IAW AMM 52-10-00.SDR JR2R2011111200591Handle · crackedMESA EO CRJ7/9-52-0030 PASSENGER- REPLACEMENT OF THE OUTER HANDLE DUE TO CRACKED HANDLE USING BOMBARDIER SERVICE BULLETIN 670BA-52-030.SDR ASOA201102163Pressure Valve · out of adjustUNABLE TO OPEN MAIN DOOR FROM INSIDE BECAUSE OUTER DOOR HANDLE WILL NOT RELEASE. ADJUSTED PAX DOOR PRESSURE VALVE IAW AMM 52-11-15. OPS CHECKED GOOD.SDR ASOA201102161Pushrod · out of rigUNABLE TO OPEN MAIN DOOR FROM INSIDE. FOUND PAX DOOR OUT OF RIG. ADJUSTED PAX DOOR OUTER HANDLE PUSHROD ASSY IAW AMM 52-11-03.SDR N6WA20111109Door · nonePAX DOOR FALLS AND IS HARD TO CLOSE. INSPECTED PASSENGER DOOR IAW AMM 52-11-00. PERFORMED OPS AND FUNCTIONAL TEST OF PAX DOOR IAW AMM 52-11-00. OPS CHECKED GOOD AT THIS TIME.SDR CA111115012Cam Follower · broken(CAN) THE FLIGHT CREW WAS UNABLE TO OPEN THE MAIN PASSENGER DOOR AFTER LANDING. THE FLIGHT CREW HAD TO EXIT THROUGH THE BAGGAGE DOOR. MAINTENANCE FOUND THAT THE LOWER AFT DOOR CAM FOLLOWER WAS BROKEN OFF.SDR UHLA2011111000415Seal Depressor · gougedMAJOR REPAIR - L1 DOOR SEAL GOUGED IN SEVERAL PACES. DAMAGE IS WITHIN LIMITS IAW IC 2008-170-04854J. PERFORMED HFEC TO FWD PROFILE IAW NDTM, NO CRACK LIKE INDICATIONS NOTED. CUT OUT DAMAGED SECTION, MATCH DRILLED NEW L1 DOOR SEAL DEPRESSOR SPLICE, AND INSTASDR ASAA11410655Plate · lack of lubeTHE L1 ENTRANCE DOOR IS HARD TO OPEN. FOUND UPPER CAM PLATE WITH NO GREASE. LUBED CAM PLATE REF AMM 12 25 21 643 007. PERFORMED FWD ENTRY DOOR TEST WITHIN LIMITS REF AMM 52 11 00 755 051. OK FOR SERVICE.SDR UALA2011111006139Door Frame · crackedLEFT NR 4 ENTRY DOOR FRAME CRACKED AT FWD LOWER CORNER. STOP DRILL. MFG & INSTALL REPAIR IAW SRM 52-10-02. PER SRM, PG 206 (EFS PG 33), INSP REQ AT 3000 DOOR FLIGHT CYCLES AFTER REPAIR.SDR UALA2011111006135Door Frame · crackedLEFT NR 4 ENTRY DOOR FRAME CRACKED AT AFT UPPER CORNER. STOP DRILL. HFEC MFG AND INSTALL REPAIR IAW SRM. INSP REQ AT 3000 DOOR FLIGHT CYCLES AFTER REPAIR. RII INSP ACP ON NON ROUTINE 0259942.SDR GLBA20111111FCable · frayedPILOT REPORTED THAT THE TOP AFT AIRSTAIR DOOR CABLE IS FRAYED. MX REPLACED THE TOP AFT DOOR CABLE, OPS CHECKED GOOD.SDR N6WA20111108Anti-Skid Tape · wornTOP STAIR ANTI-SKID WORN. DEFERRED ON NEF 25-700-8 CONTROL NR 10779, CAT 5.SDR AALA20111110TUL13Skin · dentedDENT IN DOOR SKIN DOOR LEFT NUMBER 4 BOTTOM RIGHT CORNER. INSTALLED DOUBLER REPAIR PER SRM 52-10-01-2R REPAIR 7.SDR HNAA2011111000380Skin · crackedPAX DOOR SKIN NR5 BEAM CRACKED AT FORWARD INBD MOUNT AREA. R & R PAX DOOR SKIN.SDR USAA2011111000013Striker · out of adjust2S CHECK - DOOR 831 IS OUT ADJUSTMENT AT DIMENSION B BETWEEN FINGER AND STRIKER LEVER AT DOOR 831. PERFORMED ADJUSTMENT AT DIMENSION B BETWEEN FINGER AND STRIKER LEVER AT DOOR 831 IAW AMM 52-11-14-820-002 PAR 4 ITEM A, STEP (1),. ADJUSTMENT GOOD.SDR USAA2011110900008Stop Fitting · out of adjustPHL - THE L2 ENTRY DOOR ASSIST CYLINDER FAILED TO DEPLOY DURING OPERATIONAL CHECK PER JC 33L20025001 (ESCAPE SLIDE/RAFT OPERATIONAL CHECK). MAINTENANCE TROUBLESHOT AND FOUND ADJUSTMENT OF DOOR L2 DAMPER AND EMERGENCY OPERATION CYLINDER RELEASE LEVER STOP OUT SDR ASOA201102131Door · bindingMAIN PAX DOOR WILL NOT OPEN FROM THE INSIDE. COMPLIED WITH RIGGING, FUNCTIONAL AND SYS TEST IAW AMM 52-11-00. OPS CHECKED GOOD.SDR ASOA201102130Door · no testPAX DOOR FAILED PULL TEST. REQUIRED 20 LBS TO UNLOCK. COMPLIED WITH ADJUSTMENT CHECK AND FUNCTIONAL CHECK NO DEFECT NOTED FUNCTIONAL AND OP'S CHECKED GOOD IAW AMM 52-11-00-820-801 AND 52-11-00-720-802.SDR FDEA201111084810Bearing · corrodedL1 DOOR EMERGENCY POWER TRIGGER MECHANISM CABLE ACTUATION BELLCRANK SEIZED DOOR TRIGGER QUADRANT BEARINGS FOUND SEIZED RERIG OF DOOR CARRIED OUT POST BEARING CHANGE IAW 52-1136.SDR MASA2011110963994Handle · lack of lubePAX DOOR W/N OPEN FROM INSIDE. LUBED DOOR HANDLE.SDR CA111108004Channel · cracked(CAN) UPON SERVICING ACFT FOR NEXT FLIGHT, MAIN CABIN DOOR LAST AFT 6" OF HINGE AREA FOUND MOVING DOWN WHEN STEPPING ON LOWER STEP. FURTHER INSPECTION FOUND LOWER (WHEN CLOSED) DOOR CHANNEL CRACKED 6" LONG FROM AFT END FORWARD AND DOOR SIDE HALF HINGE BROKEN SDR RAIA201111070010Structure · corrodedDURING LEASE RETURN INSPECTION MAINTENANCE FOUND THE MAIN PASSENGER DOOR U-SHAPES HAS LEVEL 2 CORROSION. MAINTENANCE REMOVED AND REPLACED THE MAIN PASSENGER DOOR U-SHAPES.SDR ASOA201102126Door · bindingPASSENGER DOOR WILL NOT OPEN FROM INSIDE. PERFORMED OPS CHECK OF PAX DOOR IAW AMM 52-11-00, OPS CHECKED GOOD.SDR ASOA201102125Drag Angle · crackedPAX DOOR CRACK AT DRAG ANGLE AFT SIDE CENTER. REPAIRED IAW REO 670-52-11-619.SDR ASOA201102124Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. PAX DOOR REPLACED IAW REO 670-52-11-619.SDR AALA20111107TUL02Pan · gougedLEFT NUMBER 2 DOOR HANDLE PAN GOUGED. REMOVED AND REPLACED HANDLE PAN PER ESO 90282.SDR R61A20110366Damper · corrodedWHILE A/C WAS IN FOR HEAVY CHECK FOUND CORROSION ON L1 DOOR FWD CUTOUT DOOR DAMPNER. MX REMOVED AND REPLACED L1 DOOR FWD CUTOUT DAMPER IAW EMB 175 AMM 52-11-27. P/N SP-21619A. A/C REMAINS IN CMH FOR HEAVY CHECK COMPLETION.SDR GTIA20111107289Cylinder · low pressureR1 DOOR ASSIST PRESSURE LOW. SERVICED R1 DOOR ASSIST IAW AMM 52-10-00-614-001. LEAK CHECKED GOOD.SDR R61A20110353Door · lack of lubeCREW REPORTED L-2 DOOR DIFFICULT TO ARM/DISARM. MAINTENANCE LUBED AND PERFORMED OPS CHECK OF L-2 DOOR PER EMB AMM, OPS CHECK GOOD.SDR JR2R2011110700575Mount · crackedWHILE WORKING PAX DOOR MOD, FOUND CRACK ON AFT LOWER MOTOR SUPPORT. R & R AFT LOWER MOTOR SUPPORT IAW SRM 51-42-06 AS ON WO 1007307-8000-0034 AND WO 711009503.SDR GTIA20111107288Cylinder · low pressureNR1 - L DOOR ASSIST BOTTLE PRESSURE LOW. SERVICED NR 1-L DOOR ASSIST BOTTLE PRESSURE LOW.SDR C2XA11SH165Profile · corrodedSHV - DURING C-CHECK CORROSION AROUND MAIN DOOR LOWER FRAME AFT SCREW HOLE. MAINTENANCE REMOVED CORROSION AND PERFORMED REPAIR FROM AROUND MAIN DOOR LOWER FRAME AFT SCREW HOLE IAW EC5210-01154 REV A AND IAW EMB-145XR CPM 51-21-06. THE AIRCRAFT WAS APPROVED FSDR USAA2011110800001Damper · failedS2 CHECK - DURING OPERATIONAL TEST OF DAMPING FUNCTION & EMERGENCY OPERATION, HARD IMPACT WAS FOUND BETWEEN THE DOOR SLIDERS & PASSENGER/CREW DOOR 841. REPLACED DOOR DAMPER & EMERGENCY OPERATION CYLINDER AT PASSENGER/CREW DOOR 841 IAW A320 AMM 52-11-14-0401.SDR QXEA2011110701097Door · frozenMAIN CABIN DOOR WILL NOT OPEN FROM INSIDE OR OUTSIDE. WAITED 30 MINUTES, ALLOWED DOOR MECHANISM TO THAW. OPENED DRAIN PLUGS ALLOWING MOISTURE TO DRAIN. PERFORMED OPS TEST OF THE FORWARD PASSENGER DOOR IAW AMM TASK 52-11-00-710-802. OPS TEST GOOD. NO FURTHER SDR MASA2011110763969Cable · out of adjustMAIN CABIN DOOR CABLE LOOSE. ADJUSTED SUPPORT WHEEL CABLE.SDR COMA2011110750090Door Frame · corrodedFOUND BOTTOM FWD PAX DOOR CORNER PART NUMBER 600-31998-10 TO HAVE EXFOLIATION CORROSION WHILE PERFORMING COMAIR TASK. REMOVED AND REPLACED FWD CORNER P/N 600-31998-10 IAW CRJ SRM 51-42-06 AND SRM 51-42-21.SDR UIEA2011110600639Bottle · lowDURING DAILY CHECK, MX FOUND THE RT UPPER DECK DOOR ASSIST BOTTLE LOW (DEFERRED UPPER DECK RT DOOR).SDR UALA2011110706062Strap · unsecureDOOR 4R DOES NOT ARM. RE-SECURED LOOSE D-RING STRAP BLOCKING GIRT BAR, OPS CHECKS GOOD.SDR UALA2011110706004Lens · missingDOOR 2L SLIDE ARMED LIGHT LENS AT DOOR WINDOW MISSING FOUND AT PRE-DEPARTURE. REPLACED LENS AND ACCOMPLISHED OPERATIONAL TEST OF SLIDE ARMED LIGHT REF AMM AT DOOR 2L. OPS CHECKS OK.SDR QXEA2011110701140Mount · corrodedACFT DOWN FOR C-CHECK. CORRODED MOUNTING ANGLE UNDER AIR STAIRS. BLENDED CORROSION, ORIGINAL THICKNESS IS .090", REMOVED .010", IAW SRM 51-21-00-00-02. PERFORMED LPI ON ANGLE, NO CRACKS FOUND IAW CH 8 TOC. ALODINED AND APPLIED EPOXY PRIMER IAW RD 8/4-52-SDR UALA2011110405982Door Frame · crackedNR 4 LT MED CRACK ON FRAME AT UPPER AFT CORNER. STOP DRILLED. HFEC MFG AND INSTALL REPAIR IAW SRM 52-10-02 REPAIR 2. PER SRM, INSPECTIONS REQUIRED EVERY 3000 CYCLES. (PG 206 - EFS PG 28 & 33). ON NON ROUTINE 0259942. ** MF8290 CREATED TO MONITOR **SDR UALA2011110405981Door Frame · crackedNR 4 LT MED CRACK ON FRAME AT LOWER FWD CORNER. STOP DRILLED. HFEC MFG AND INSTALL REPAIR IAW SRM 52-10-02 REPAIR 2. PER SRM, INSPECTIONS REQUIRED EVERY 3000 CYCLES (PG 206 - EFS PG 28 & 33). ** MF8289 CREATED TO MONITOR **SDR QXEA2011110701096Door · bindingMAIN CABIN DOOR DIFFICULT TO OPEN UP. COMPLIED WITH GVI OF DOOR HANDLE AND EXTERNAL LATCHING LUGS, NO DEFECTS FOUND. COMPLIED WITH FUNCTIONAL CHECK OF AIRSTAIR DOOR HANDLE IAW MM TASK 52-11-00-720-802. FUNCTIONAL CHECKED GOOD. RETURNED TO SERVICE. NO PARTSSDR QXEA2011110701095Handle · lack of lubeMAIN CABIN DOOR IS DIFFICULT TO OPEN AND CLOSE. LUBED DOOR HANDLE LINKAGE, DOOR OPS CHECKED GOOD. RETURNED TO SERVICE. NO PARTS REPLACED.SDR 29GA94752110411ACable · defectiveFLIGHT: 4069 CLE/DUJ PILOT REPORTED AFT CABIN DOOR LATCHES INOPERATIVE. REPLACED CABIN DOOR AFT LOWER CABLE OPERATIONAL CHECK GOOD.SDR JR2R201111410557AStriker · corrodedPAX DOOR AFT DOOR SEAL STRIKER ATTACHED TO FS 349.00 HAS MULTIPLE AREAS OF DAMAGE ALONG MID SECTION OF SEAL STRIKER. REPAIRED AND APPLIED TOP COAT TO PAX DOOR AFT SEAL STRIKER IAW RO CRJ9-53-0842 AS ON WO 1007307-2000-0025 AND WO 711014235.SDR A6WA201141110Step · crackedPAX DOOR STAIR STRUCTURE IS CARACKED 3RD STEP FWD CORNER. REPAIRED PAX DOOR STAIRS 3RD STEP ON FWD SIDE IAW SRM 52-00-00.
Back to JASC 5210