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 GTIA20111006267Cylinder · low pressureDOOR ASSIST BOTTLE NEEDS SERVICING. SERVICE DOOR ASSIST BOTTLES IAW AMM 52-10-00-614-001. LEAK CHECKED OK.SDR GTIA20111006266Cylinder · low pressureR1 DOOR ASSIST BOTTLE PRESSURE LOW. SERVICED R1 DOOR ASSIST BOTTLE TO PROPER PRESSURE IAW 52-10-00-614-001.SDR AALA20111005TUL03Skin · damagedFORWARD ENTRY DOOR, SKIN DAMAGED AT HOLD OPEN HOOK CUTOUT. ACCOMPLISHED REPAIR PER SRM 52-05-00 FIGURE 20A.SDR AALA20111005TUL02Skin · bentFORWARD ENTRY DOOR, LOWER EXTERNAL SKIN BENT. ACCOMPLISHED REPAIR PER SRM 52-10-00-0 FIGURE 1.SDR USAA2011100600024Damper · inoperativeC11 CHECK - L-1 DOOR DAMPER INOP. REPLACED L-1 DOOR DAMPER.SDR UALA2011100505414Handle · unknownLEFT AFT DOOR HANDLE ISSUE, FLIGHT DIVERTED.SDR FDEA201110054304Handle · unsecureL1 DOOR MANUAL LIFTING HANDLE IS NOT SECURELY ATTACHED ON THE FORWARD SIDE ADJUSTED SPRING AT L1 DOOR FWD LIFTING HANDLE FWD SIDE IAW IN REF OF 52-11-00-0-0. SYS CK NML. FINAL CLOSED.SDR N6WA20111004Angle · corrodedPAX DOOR MID CAP ANGLE HAS CORROSION. INSTALLED NEW MID CAP ANGLE IAW SRM 51-42-06 AND 51-42-20.SDR N6WA20111003Screw · missingPAX DOOR AFT HANDRAIL SHOULDER SCREW MISSING. INSTALLED MISSING SCREW IAW AMM 52-11-05.SDR JR2R2011100500456Retainer · gougedPAX DOOR LOWER SEAL RETAINER GOUGED. RETAINER IAW CRJ 900 AMM 52-42-10.SDR JR2R2011100500455Anchor Fitting · gougedAFT PAX DOOR COUNTERBALANCE ANCHOR FITTING GOUGED. REPAIRED FITTING IAW RO CRJ9-51-0453.SDR UALA2011100505394Cylinder · out of adjustR2 DOOR EMERGENCY POWER SPRING CYLINDER IS OUT OF ADJUSTMENT. ADJUSTED EMERGENCY POWER SPRING CYLINDER PISTON RED BAND PER MM.SDR UALA2011100505385Cylinder · out of adjustR4 DOOR, EMERGENCY POWER SPRING CYLINDER IS OUT OF ADJUSTMENT, NO RED BAND. ADJUSTED POWER SPRING CYLINDER PISTON RED BAND PER MM.SDR UALA2011100505384Lock · wornR1 DOOR HOLD OPEN LOCK WORN. REMOVED AND REPLACED DOOR HOLD OPEN LOCK PER MM.SDR UALA2011100505383Shaft · wornR1 DOOR HOLD OPEN LOCK SPLINED SHAFT WORN AND DAMAGED. REMOVED & REPLACED HOLD OPEN LOCK SPLINE SHAFT PER MM AND OPS CHECKED GOOD.SDR UHLA2011100400318Unknown · malfunctionedL1 DOOR DIFFICULT TO OPEN. OUTER HANDLE DROPS UNLESS HELD UP. DOOR SEEMS TO BE HITTING LOW ON CAMS. OPERATED L1 DOOR WITH NO DEFECTS NOTED IAW EMB 170 MM 52-11-01.SDR N6WA20111001Lanyard · brokenFORWARD AIRSTAIR HANDRAIL QUICK RELEASE PIN LANYARD BROKEN. DEFFERED AIRSTAIR QUICK RELEASE PIN ON DMI 23250, MEL 52-11-05, CAT C.SDR GTIA20111004265Cylinder · low pressureL2 DOOR ASSIST LOW PRESSURE. SERVICED L2 DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001. NO LEAKS NOTED.SDR SWIA201128123Control Switch · failedMCD WOULD NOT OPEN. (FLT 5323) REPLACED MAIN CABIN DOOR CONTROL SWITCH AT F/A'S CONTROL PANEL.SDR RAIA201110030001Handle · brokenRAMP PERSONNEL MOVED AIRCRAFT TO A REMOTE PAD AND WHEN THEY WENT TO CLOSE THE PASSENGER DOOR THE HANDLE BROKE. MAINTENANCE INSPECTED THE DOOR AND REMOVED AND REPLACED THE PASSENGER DOOR HANDLE. SYSTEM OPS CHECKED GOOD.SDR USAA2011100400018Door · out of adjust2S CHECK - OUT OF ADJUSTMENT DIMENSION "B" BETWEEN STRIKER LEVER & FINGER DAMPER MECHANISM AT DOOR 831. PERFORMED ADJUSMENT DIM "B" (J1) BETWEEN STRIKER LEVER & FINGER DOOR DAMPER & EMERGENCY OPERATION CYLINDER AT DOOR 831, ADJUSTMENT IS OK IAW AMM 52-11-14-8SDR GTIA20111003264Cylinder · low pressureR1 DOOR PASSENGER DOOR ASSIST CYLINDER READS INADEQUATE PRESSURE ON GAUGE SERVICED R1 DOOR PASSENGER ASSIST CYLINDER W/ NITROGEN IAW AMM 52-10-00-614-001. NO LEAKS DETECTED AT THIS TIME.SDR GTIA20111003262Cylinder · low pressureL2 & L3 DOOR ASSIST ACCUMULATOR PRESSURE LOW. SERVICED L2 & L3 DOOR ASSIST ACCUMULATOR PRESSURE IAW AMM 52-10-00-614-001.SDR GTIA20111003261Cylinder · low pressureR1 DOOR PASSENGER DOOR ASSIST CYLINDER INADEQUATE PRESSURE ON GAUGE. SERVICED R1 DOOR PASSENGER ASSIST CYLINDER W/ NITROGEN IAW AMM 52-10-00-614-001. NO LEAKS DETECTED AT THIS TIME.SDR A6WA201140982Bracket · crackedPAX DOOR SUPPORT WHEEL PULLEY BRACKET ATTACHED TO LOWER STAIR IS CRACKED. R & R PAX DOOR SUPPORT WHEEL PULLEY BRACKET IAW SRM 51-42-06.SDR 2011FA0000707Latch · failedRIGHT CABIN DOOR CAME OPEN IN FLIGHT. DOOR WAS LATCHED ON THE GROUND PRIOR TO TAKEOFF. BOTH FRONT AND REAR DOOR LATCHES WERE CHECKED BEFORE TAKEOFF BY PUSHING ON CABIN DOOR, HARD AFTER LATCHING DOOR. FRONT LATCH FAILED IN FLIGHT. REAR LATCH HELD FOR A SHORSDR UALA2011100305322Gate · crackedMAIN ENTRY DOOR 2 LEFT LOWER GATE CRACKED AFT END LAST HINGE RIVET. REMOVED & REPLACED LOWER GATE PER MM. ACCOMPLISHED RIG CHECK PER MM.SDR SWIA201128122Roller · dirtyMCD IS DIFFICULT TO OPEN. (FLT 6442) CLEANED & LUBRICATED ROLLERS & ACTUATING LINKAGE.SDR UHLA2011100200317Indicator · out of adjustWHEN L1 DOOR DISARMED, GREEN DISARMED DOES NOT APPEAR IN WINDOW, IT IS BLANK. ADJUSTED INDICATOR IAW EMB 170 MM 52-11-00. OPS CHECK NORMAL.SDR UHLA2011100200316Handle · lack of lubeL1 GREEN DISARM INDICATION IS NOT VISIBLE IN SIGHT WINDOW. LUBED L1 DOOR HANDLE AND INDICATION IAW EMB 170 MM 51-11-020. OPS CHECK GOOD.SDR USAA2011100300039Door · out of adjust2S CHECK - OUT OF ADJUSTMENT DIMENSION "B" BETWEEN STRIKER LEVER AND FINGER DAMPER MECHANISM AT DOOR 841. PERFORMED ADJUSTMENT DIM "B" (J1) BETWEEN STRIKER LEVER & FINGER OF THE DOOR DAMPER & EMERGENCY OPERATION CYLINDER AT DOOR 841, ADJUSTMENT IS OK IAW AMM SDR USAA2011100300008Seal · damagedPHL - 1L DOOR LEAKS AIR IN FLIGHT AND DIFFICULT TO OPEN AND CLOSE ON GROUND - REPORTED BY F/A. REMOVED AND REPLACED DAMAGED LOWER DOOR LINING PANEL SEAL WHICH INTERFERED WITH PROPER DOOR CLOSING. OPS CHECK DOOR OK.SDR USAA2011100300007Latch · lack of lubeCLT - L1 DOOR DIFFICULT TO LATCH. CLEANED & LUBED L1 UPLATCH ASSY, OP CHECKS GOOD.SDR GTIA20111002263Cylinder · low pressureL3 DOOR ASSIST BOTTLE LOW PRESS CORRECTIVE ACTION: CHARGED L3 DOOR ASSIST BOTTLE IAW AMM 52-22-00-614-002.SDR A6WA201141042Skin · corrodedFWD CORNER OF PAX DOOR AT DRAINAGE RAMP AREA IN CORRODED AND HAS DOUBLE DRILLED HOLE. REMOVED UNSERVICEABLE FWD CORNER OF PAX DOOR AT DRAINAGE AREA AND INSTALLED SERVICEABLE CORNER AT PAX DOOR FWD CORNER IAW SRM 51-42-06.SDR A6WA201141043Attach Fitting · corrodedFIVE CLIPS EA CORRODED AT DRAINAGE RAMP AREA OF PAX DOOR. REMOVED 5 EA UNSERVICEABLE CLIPS FROM PAX DOOR DRAINAGE RAMP INSTALLED 5 SERVICEABLE CLIPS IAW SRM 51-42-06.SDR UALA2011100305331Cylinder · out of adjustL2 DOOR EMERGENCY POWER SPRING CYLINDER PISTON IS OUT OF ADJUSTMENT. ADJUSTED POWER SPRING CYLINDER PISTON RED BAND PER MM.SDR UALA2011100305330Cylinder · out of adjustL1 DOOR EMERGENCY POWER SPRING CYLINDER IS OUT OF ADJUSTMENT. ADJUSTED POWER SPRING CYLINDER RED BAND PER MM.SDR GLBA20111003GSeal · leakingPILOT REPORTED THAT THE DOOR SEAL IS LEAKING IN FLIGHT. MX SEAL, LEAK CHECKED GOOD IAW BMM 52-10-06.SDR UALA2011093005298Switch · out of positionLEFT NR ONE PASSENGER ENTRY DOOR EMERGENCY PASSENGER ASSIST SYSTEM (EPAS) BATTERY SWITCH TURNED TO THE DISARM POSITION.SDR GLBA20111003FSeal · wornPILOT REPORTED THAT THE CABIN DOOR SEAL MAKES EXCESSIVE NOISE WITH CABIN PRESSURIZED ABOVE 3.5 PSID. MX INSPECTED AND FOUND A BAD SEAL ON THE NR1 ADF ANTENNA, REPLACED SEAL, IAW TC 1900-3411.00-3, LEAK CHECKS GOOD.SDR SIMA201127602Roller · lack of lubeDURING MAINTENANCE INSPECTION FOUND THE MAIN DOOR HARD TO OPEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. LUBED FRAME ROLLERS IN REFERENCE TO EMB-145 AMM 52-18-00. NO PARTS REMOVED OR REPLACED. NO FURTHER DEFECTS NOTED. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR FDEA201109294209Gate · corrodedL-1 DOOR LOWER GATE HAS PITTED CORROSION AROUND THE SEAL RETAINER BRACKET. REMOVED AND REPLACED LOWER GATE ASSY, PER AMM 52-11-38. PERFORMED DOOR ADJUSTMENT CHECKED PER AMM 52-11-00-5 CHECKED GOOD, MAJOR REPAIR.SDR ASAA11410456Guide Arm · out of adjustF/A REPORTS THAT THE L1 DOOR IS TO CLOSE. ADJUSTED DOOR GUIDE ARM IAW AMM 52 11 00, OPS CHECK GOOD.SDR USAA2011093000001Track · lack of lubeCLT - 04 (L-FWD) PAX DOOR DIFFICULT TO OPEN. OPERATION STARTS THEN STOPS REPEATEDLY. MAINTENANCE LUBED TRACK, OPS NORMAL.SDR SIMA201127303Door · bindsON FLIGHT 3959 THE FLIGHT ATTENDANT REPORTED THE MAIN ENTRY DOOR WAS DIFFICULT TO OPERATE. THE AIRCRAFT WAS REMOVED FROM SERVICE. CONDUCTED AN OPERATIONAL CHECK OF THE MAIN PAX DOOR IAW EMB-145 AMM 52-18-00. THE PASSENGER DOOR CHECKED AS GOOD. NO PARTS REMSDR GTIA20110929260Cylinder · dischargedDOOR L1 ASSIST BOTTLE DISCHARGED - 1100 PSI. SERVICED L1 DOOR ASSIST BOTTLE TO LIMITS IAW AMM 52-10-00-614-001.SDR ASOA201101821Drag Angle · crackedPAX DOOR DRAG ANGLE CRACKED, AFT SIDE, MID- POINT. RECEIVED REO 690-52-11-168, COMPLIED WITH STEPS 1 THRU 4 IAW REO 690-52-11-168. CREATED MCO IAW REO 690-52-11-168. CRACK ON PAX DOOR DRAG ANGLE FOUND TO BE OUT OF LIMITS, SUBMITTED TO ENGINEERING FOR DISPOSDR ASOA201101819Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED, MID POINT. REPAIRED IAW REO 670-52-11-072 REV E.SDR N6WA20110935Cable · brokenPASSENGER DOOR VENT CABLE BROKE. R & R PASSENGER DOOR PRESSURE VENT FLAP CABLE IAW AMM 52-11-15.
Back to JASC 5210