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 MASA2010073100824Handle · brokenPAX DOOR OUTER HANDLE BROKEN. MX FERRIED TO PHX AND R2 PAX DOOR OUTER HANDLE.SDR MASA2010073000822Mechanism · lack of lubePAX DOOR HANDLE HARD TO STOW FROM INSIDE. MX LUBED STOW HANDLE MECHANISM, OPS CHECK GOOD.SDR FDEA201007302736Gate · corrodedNR 4L DOOR UPPER GATE INNER SIDE FOUND CORRODED AND MISSING LEVELING COMPOUND. R & R L4 DOOR UPPER GATE IAW AMM 52-11-28. ADJUSTMENT CHECK PERFORMED ON N/R N01545. MAJOR REPAIR.SDR SWIA201024783Structure · corrodedPAX DOOR LOWER AFT CORNER (HINGE END) CORRODED. (C-CHECK) REMOVED AND REPLACED PAX DOOR LOWER AFT CORNER PER SRM.SDR SWIA201024782Channel · corrodedPAX DOOR LOWER CHANNEL HAS CORROSION ON INSIDE UNDER DRAIN RAMP. (C-CHECK) REMOVED AND REPLACED CHANNEL PER SRM.SDR ASOA201001058Web · crackedFOUND PAX DOOR AFT WEB CRACKED APPROX .300" L STARTING AT EDGE OF WEB AND FOUND 3 DRILL STARTS ON DOOR STRUCTURE WHILE PERFORMING REO 601R-52-11-1842. REPAIRED PAX DOOR AFT WEB IAW REO 601R-52-11-1844 STEPS 1-3, 5-24. COMPLIED WITH STEP 4 OF REO 601R-52-11-1SDR ASOA201001062Drag Angle · crackedTHE PAX DOOR AFT DRAG ANGLE IS CRACKED IN AN EXISTING REPAIR BY THE DOOR ASSIST PULLEY BRACKET. REMOVED DAMAGED SECTION OF ANGLE AND PREVIOUSLY INSTALLED SPLICE ANGLES IAW SRM 51-42-06 & SRM 51-42-13. COMPIED WITH EC/TC REO 601R-52-11-53 & VERIFIED THAT ALL SDR ASAA1048111Fitting · lack of lubeF/A'S REPORTS L1 ENTRY DOOR HARD TO CLOSE AND MAKE CREAKING SOUNDS. LUBED L1 DOOR FITTINGS AND PERFORM OPS CHECK REF AMM 52 11 00 705 060, OPS CHECK GOOD.SDR MASA2010072900821Handle · out of positionPAX DOOR OUTER HANDLE WN STOW. RE-SECURED & LUBED STOW HANDLE COLLAR.SDR CALA2010073000353Beam · crackedL1 DOOR, LOWER FWD GATE BEAM, IS CRACKED ABOVE THREE HI-LOK FASTENERS OF LOWER STOP PIN FITTING. REPAIRED PER ECRA 5210-02165.SDR SWIA201024622Structure · corrodedMAIN DOOR LOWER AFT CORNER CORRODED UNDER STEP NR 1. (C CHECK) REPAIRED PER SRM.SDR 2010FA0000771Cylinder · reads lowR -1 DOOR ASSIST CYLINDER GUAGE READS ZERO. SERVICED AND LEAK CHECKED R-1 DOOR ASSIST CYLINDER IAW AMM 52-10-00, NO LEAKAGE NOTED OVER 40 HOUR PERIOD.SDR USAA2010081691676Gate · corrodedBFM - Q5 CHECK - MAJOR REPAIR - CORROSION ON L1 DOOR LOWER GATE INTERNAL SURFACE. REPLACED L1 DOOR LOWER GATE IAW B737 AMM 52-41-61.SDR UALA2010072802721Bellcrank · brokenNR 1 RT PAX ENTRY DOOR - ACTUATING LEVER FOR THE EMERGENCY POWER ASSIST BOTTLE DIAPHRAGM PLUNGER BROKE OFF AT THE ACTUATING LEVER CASTING SUPPORT. REPLACED BELLCRANK ON DOOR.SDR FDKA2010072700186Door · misalignedMAIN PAX DOOR MISALIGNED. MX C/W EMB ETD 2010-145/06432 IAD MX.SDR SWIA201024784Skin · corrodedPAX DOOR INNER SKIN REQUIRES REPLACEMENT DUE TO CORROSION. (C-CHECK) REMOVED AND REPLACED PAX DOOR INNER SKIN PER SRM.SDR ASOA201001042Door · bindingMAIN CABIN DOOR DIFFICULT TO OPEN. OPS CHECKED PAX DOOR IAW AMM 52-11-00. COULD NOT DUPLICATE, OPS CHECKED GOOD IAW AMM. OK FOR SERVICE.SDR SIMA20102901Door · out of adjustON FLIGHT 4348 FLIGHT ATTENDANT REPORTS MAIN CABIN DOOR IS HARD TO OPEN. AIRCRAFT REMOVED FROM SERVICE. PASSENGER DOOR ENTERED INTO TDMI 6175208DF PER ETN EM-52-029. PERFORM THE ADJUSTMENT OF THE PASSENGER MAIN DOOR IN ACCORDANCE WITH AMM 52-18-00 TO REDUCESDR MASA2010072600815Door · lack of lubeUNABLE TO CLOSE PAX DOOR FROM INSIDE. MX LUBED DOOR.SDR USAA20100727BA037Bottle · low pressurePHL - THE DOOR R4 BOTTLE/DOOR ASSIST PRESSURE IS LOW. SERVICED R4 DOOR ASSIST/BOTTLE.SDR SWIA201024956Skin · corrodedPAX DOOR INNER SKIN REQUIRES REPLACEMENT DUE TO SEVERE CORROSION DAMAGE AT ACCESS PANEL CUTOUTS. (C-CHECK) REPAIRED PER SRM.SDR SWIA201024954Intercostal · crackedPAX DOOR INTERCOSTAL CRACKED AT STA 344 STR 16. (C-CHECK) REPAIRED PER SRM.SDR A6WA201040542Door · bindingF/A REPORTS PAX DOOR DIFFICULT TO OPEN. DOOR HANDLE MOTION FROM STOWED TO OPEN POSITION IS DIFFICULT AND NOT SMOOTH. C/W OPS TEST OF PAX DOOR IAW AMM 52-11-00710-801. NO DEFECT NOTED.SDR R61A20100363Door · bindingCREW REPORTED L-1 DOOR DIFFICULT TO OPEN FROM THE OUTSIDE. MAINTENANCE PERFORMED PASSENGER DOOR OPS CHECK PER EMB AMM, AND REPORTED NO DEFECTS WERE FOUND. ENGINEERING ISSUED RI521033 TO HAVE MAINTENANCE PERFORM FURTHER TROUBLESHOOTING FOR THIS ISSUE.SDR QXEA2010072800445Latch · out of adjustMSO- AFT PASSENGER DOOR DIFFICULT TO OPEN. FERRIED FOR REPAIRS. INSPECTED AND FOUND UPPER FWD GUIDE ROLLER OF AFT PASSENGER DOOR NOT FULLY LIFTING OUT OF FITTING WHEN OPENING. ADJUSTED AFT PASSENGER DOOR LIFT AND LATCH MECHANISM IAW MM TASKNR 52-00-00-830-803 SDR MASA2010072300801Handle · lack of lubePAX DOOR HANDLE WILL NOT STOW. MX LUBED DOOR, OPS CHECK IS GOOD.SDR USAA2010072691488Bottle · low pressureFLT 150 - PHL - EES - DOOR 3L ASSIST PRESSURE LOW. MAINTENANCE SERVICED 3L DOOR ASSIST BOTTLE PRESSURE TO PROPER LEVEL.SDR CA100809017Bellcrank · failed(CAN) DURING A PHASE INSPECTION THE DOOR LATCHES WERE OBSERVED NOT TO BE WORKING CORRECTLY. FURTHER INSPECTION REVEALED THE BELLCRANK HAD FAILED RESULTING IN IMPROPER TRAVEL OF THE UPPER DOOR HOOKS. THE BELLCRANK WAS REPLACED WITH NEW.SDR R61A20100357Unknown · malfunctionedCREW REPORTED L-1 DOOR WAS DIFFICULT TO OPERATE. MAINTENANCE PERFORMED OPS CHECK OF L-1 DOOR PER EMB AMM AND REPORTED NO DEFECTS WERE FOUND.SDR MASA2010072100794Flap · out of adjustPAX DOOR OUTER HANDLE FLAP W/N CLOSE. MX ADJUSTED FLAP, OPS NORM.SDR UALA2010072002605Reservoir · looseDOOR 1L EPAS RESERVOIR PRESS GAUGE IS LOOSE. INSTALLED NEW EPAS RESERVOIR.SDR USAA20100723BA034Damper · low pressureFCO - SERVICING REPORT SHOWS "L3 DOOR BOTTLE LOW PRESSURE". DOOR L3 CYLINDER DOOR DAMPER SERVICED.SDR FDKA2010071900179Seal · damagedMAIN DOOR SQUEAL IN FLIGHT. MX REPAIRED SEAL, PRESS CHECK GOOD, NO SQUEAL.SDR SIMA201020004Seal · lack of lubeON FLIGHT 4307 THE CREW REPORTED THAT THE MAIN CABIN DOOR WAS DIFFICULT TO OPEN AND CLOSE. THE FIRST OFFICER HAD TO ASSIST THE FLIGHT ATTENDANT TO OPEN AND CLOSE THE DOOR. THE AIRCRAFT WAS REMOVED FROM SERVICE. RE-ADJUSTED THE MAIN DOOR STOPS IAW EMB 140 AMSDR RAIA201007180001Door · bindingDURING POST-FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR DIFFICULT TO OPEN. INSPECTED AND SERVICED THE PASSENGER DOOR. DOOR OPS CHECKED GOOD.SDR MASA2010071800773Linkage · out of adjustPAX DOOR PRESS RELIEF DOOR W/N CLOSE. MX ADJUSTED DOOR LINKAGE, OP AND PRESS CHECK GOOD.SDR AALA20100717TUL02Beam · crackedFORWARD ENTRY PASSENGER DOOR NUMBER 2 BEAM CRACKED AT FORWARD END. FORWARD ENTRY PASSENGER DOOR INSTALLED DOUBLER ON NUMBER 2 BEAM FORWARD END PER ESO 80172.SDR ASOA201001017Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE IS CRACKED IN PREVIOUS REPAIR. MWC JOB 8769131 OP 423 FOR REPAIR OF PAX DOOR AFT DRAG ANGLE.SDR USAA2010071991459Bottle · lowFLT 1455 - CIDS CAUTION LIGHT ILLUMINATED ON FORWARD FLIGHT ATTENDANT PANEL. MAINTENANCE SERVICED FORWARD MID CABIN DOOR ASSIST BOTTLE. MAINTENANCE SERVICED THE R-2 MID CABIN DOOR ASSIST BOTTLE.SDR SWIA201024561Door · dirtyMAIN CABIN DOOR DIFFICULT TO OPEN. (FLT 6937) CLEANED & LUBRICATED MAIN CABIN DOOR.SDR MASA2010071700769Handle · lack of lubePAX DOOR W/N OPEN FROM INSIDE. MX LUBED DOOR HANDLE.SDR R61A20100349Gust Lock · out of adjustCREW REPORTED L-1 DOOR WAS HARD TO CLOSE. MAINTENANCE ADJUSTED THE GUS LOCK PER EMB AMM, AND PERFORMED OPS CHECKS. THE A/C WAS THEN RETURNED TO SERVICE.SDR RAIA201007160001Bolt · looseDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR HARD TO OPEN AND CLOSE. MAINTENANCE INSPECTED AND TIGHTENED PASSENGER DOOR INNER HANDLE BOX BOLTS. PERFORMED PUSH TEST AND FOUND IT TO BE WITHIN LIMITS AT 48 LBS. DOOR OPS CHECKED GOOSDR SIMA201020003Seal · lack of lubeON FLIGHT 4122 THE FLIGHT ATTENDANT REPORTED THAT THE MAIN CABIN DOOR HANDLE WAS DIFFICULT TO ROTATE IN BOTH DIRECTIONS. THE AIRCRAFT WAS REMOVED FROM SERVICE. LUBED MAIN DOOR RUBBER TRIM AND FRAME RUBBER SEAL IAW EMB AMM 52-18-00. NO PARTS REMOVED OR REPLASDR FXGA1105GSkin · dentedDENT ON ENTRY DOOR SKIN NEAR OPERATING LEVER WAS REPAIRED IAW SRM 52-10-01.SDR A6WA201040692Drag Angle · crackedAFT DRAG ANGLE CRACKED ON PAX DOOR INCORPORATED REO 601R-52-11-082, REV A.SDR AALA20100715TUL03Pan · gougedLEFT NUMBER 4 PASSENGER DOOR HANDLE PAN GOUGED. REPLACED HANDLE PAN AS PER ESO 90108.SDR R61A20100337Door · lack of lubeCREW REPORTED L-1 DOOR WAS DIFFICULT TO CLOSE. MAINTENANCE LUBED THE L-1 DOOR PER EMB AMM, AND OPS CHECK WAS GOOD. A/C WAS THEN RETURNED TO SERVICE.SDR IPXA10M61117Bottle · dischargedL1 DOOR INOP. ENTRANCE DOOR BOTTLE IS ZERO. NO OVERWATER DEFERRED PER MEL 52-10-3-2. PLACARD INSTALLED. M429547 ASSIGNED. REPLACED L1 DOOR ROLLER CHAIN SPROCKET REF CMM 52-11-09. DOOR OPS OK. REF MM 52-11-02-5. DEFERRAL CLOSED.SDR SWIA201024576Roller · lack of lubeF/A REPORTS MAIN CABIN DOOR IS DIFFICULT TO OPEN. (FLT 6687) LUBED DOOR ROLLERS AND ATTACH POINTS.
Back to JASC 5210