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 UALA2012102506106Mechanism · out of adjustMAIN CABIN L-4 DOOR FAILED MIDWAY CHECK - GIRT BAR BECAME DETACHED. ADJUSTED L4 PASSENGER DOOR EMERGENCY MECHANISM.SDR UALA2012102506104Door · out of adjustMAIN CABIN L-2 DOOR FAILED UNLATCH MINIMUM CHECK. ADJUSTED L2 DOOR UNLATCH TORQUE TO GREATER THAN 200 LBS.SDR UALA2012102506093Pan · gougedDOOR L-1 HAS GOUGED PAN FROM RUBBING DOOR HANDLE. REMOVED AND REPLACED DOOR PAN PER ECRA 5200-01155.SDR UHLA2012102300333Unknown · not seatedL1 DOOR INDICATION TURNED YELLOW WITH X IN CENTER. RESEATED L1 DOOR C/P IAW MM 20-52-00, OPS CHECK GOOD.SDR UALA2012102306062Skin · dentedL1 DOOR EXT SKIN HAS DENT LWR AFT SECTION. INSTALLED INTERIM REPAIR PER ECRA 5210-02322.SDR UALA2012102606146Skin · corrodedL1 DOOR EXT SKIN HAS DENT LOWER AFT SECTION.SDR REXA2012102201415Mechanism · defectiveMAIN CABIN DOOR WILL NOT OPEN. FOUND INNER HANDLE RETENTION MECHANISM BINDING. REMOVED AND REPLACED MCD INNER HANDLE RETENTION MECHANISM SHAFT BEARING AND SPRING IAW AMM 52-11-25.SDR ERAA20120080Link · corrodedPASSENGER DOOR AFT CAM LINK ASSEMBLY SHAFT HAS SURFACE CORROSION. REPLACED LINK.SDR REXA2012111101505Hand Rail · corrodedAFT PAX DOOR HANDRAIL RECEPTACLE HAS CORROSION. REMOVED CORROSION IAW SRM 53-00-00.SDR REXA2012111101504Hand Rail · corrodedFORWARD PAX DOOR HANDRAIL RECEPTACLE HAS CORROSION. REMOVED CORROSION IAW SRM 53-00-00.SDR DALA1252370924Skin · crackedL1 DOOR LOWER EDGE SKIN IS BENT AND PREVIOUS REPAIR IS CRACKED. REPAIRED IAW SRM 51-30-2.SDR USAA2012102200025Bottle · low pressureSLIDE BOTTLE PRESSURE INDICATION ON FLIGHT ATTENDANT PANEL FOR DOOR 4L. SERVICED DOOR 4L EMERGENCY ASSIST BOTTLE IAW AIRBUS MAINTENANCE MANUAL 52-10-00-614-001-A.SDR SIMA20121021001Cam · lack of lubeON FLIGHT 2845 THE CREW REPORTED THE MAIN CABIN DOOR WAS HARD TO OPEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. LUBED BOTH CAMS PERFORMED FUNCTIONAL CHECK OF ACTUATING HANDLE IAW EMB 145 52-18-00. THE OPERATIONAL CHECK WAS GOOD AT THIS TIME. THE AIRCRAFT WASSDR UALA2012102206011Light · inoperativeARM LIGHTS DOORS 1L AND 1R INOPERATIVE. RELAMPED 1L AND 1R ARM LIGHTS, CYCLED DOORS LIGHTS CHECK NORMALLY.SDR REXA201210200098Angle · cracked900-52-830-300, PASSENGER DOOR AFT SIDE LOWER ANGLE CRACKED. REPAIRED AFT DRAG ANGLE IAW CRJ 900 SRM 52-11-04.SDR ASOA2012103102413Drag Angle · crackedPAX DOOR AFT SIDE RISER PANEL DRAG ANGLE CRACKED AT CENTER. REMOVED DRAG ANGLE IAW SRM 51-42-06-001-001-A01. INSTALLED NEW REPAIR PARTS DRAG ANGLE IAW SRM 51-11-04-201-002-A01.SDR QXEA2012102001330Nut · corrodedAFT ENTRY DOOR OUTER EDGE FRAME HAS FIVE ANCHOR NUTS CORRODED. COMPLIED WITH RD 8/4-52-492.SDR SWAA2012111509456Intercostal · crackedFWD ENTRY DOOR - L1 DOOR INTERNAL STRUCTURE, INTERCOSTAL CRACKED, AFT SIDE OF DOOR HANDLE MECHANISM. REMOVED AND REPLACED INTERCOSTAL IAW SRM AND DWG.SDR USAA2012102200024Diaphragm · leakingMESSAGE ON CIDS PANEL TO CHECK DOOR 4L PRESSURE. SERVICED DOOR 4L ASSIST BOTTLE. DUE TO REPEATED SERVICINGS, COMPLETED ADDITIONAL TROUBLESHOOTING AND FOUND PERCUSSION DIAPHRAGM LEAKING. REMOVED AND REPLACED DIAPHRAGM-SEALING IAW 52-11-05.SDR SIMA20121019003Guide · roughFOR FLIGHT 3207 THE FLIGHT ATTENDANT REPORTED THE MAIN CABIN DOOR WAS VERY DIFFICULT TO OPEN AND CLOSE. THE AIRCRAFT WAS REMOVED FROM SERVICE. SMOOTHED OUT ROUGH EDGES ON FORWARD GUIDE BLOCKS AND LUBED FRAME ROLLERS IAW EMB-145 AMM 53-21-02. THE AIRCRAFT WASDR USAA2012102200007Indicator · inoperativeC2 CHECK - FORWARD ENTRY DOOR EMERGENCY ONLY FLAG DOES NOT FULLY RETRACT. REPLACED FORWARD ENTRY DOOR EMERGENCY ONLY FLAG IAW B767 AMM 20-11-00-422-003 AND ADJUSTED IAW B767 AMM 52-11-00-825-00 TW 11-021.SDR DXTA2012101905154Damper · malfunctionedMED DAMPER ARM IS CONTACTING WEB 330 LT SIDE AT FS 5728 WL 200. ENLARGED EXISTING CUTOUT IN RIB 330 LT SIDE, AT FS5728/WL 200 TO CLEAR MED DAMPER ARM IAW WO CS304901. NO CRACKS NOTED.SDR A6WA20121031574Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. REMOVED & REPLACED PAX DOOR AFT DRAG ANGLE PREVIOUS REPAIR ANGLE, UPPER SPLICE & LOWER SPLICE ANGLE IAW REO 601R-52-11-563 REV A.SDR N6WA2012101701Seal · tornPAX DOOR SEAL HAS A TEAR AT TOP LT CORNER. REPLACED SEAL IAW AMM 52-11-07.SDR ASOA20121017093RBolt · unsecureCREW REPORTED MAIN CABIN DOOR LEVER PRODUCES LOUD METAL POP SOUND WHEN OPENING AND FEELS UNUSUALLY HARD TO OPEN. MX INSPECTED AND FOUND HARDWARE LOOSE, RESECURED THE INTERNAL HANDLE BOX BOLTS WITH OPS CHECK SUCCESSFUL. ACFT WAS APPROVED FOR RETURN TO SERVICESDR USAA2012101800017Bottle · low pressureL-4 DOOR ASSIST BOTTLE ON CIDS. CHECKED FOR LEAKS WITH NONE NOTED. SERVICED L-4 DOOR ASSIST BOTTLE IAW AIRBUS MAINTENANCE MANUAL 52-10-00-614-001A.SDR GTIA20121017495Cylinder · low pressureL1 DOOR ASSIST LOW . SERVICED L1 DOOR ASSIST IAW AMM 52-10-00-614-001-A.SDR UALA2012101705942Trunnion · shearedTRUNNION ASSY FOUND SHEARED AT LOWER END ON R1 DOOR. COMPLETED INSTALLED SPRING ROD. OPS OF DOOR NORMAL.SDR FDEA201210173656Structure · crackedDAMAGE ON RIGHT HAND FWD ENTRY DOOR LOWER EDGE FWD CORNER HAS 1.0" CRACK AND 3.0" LONG BENT AREA. REF WC 52105108 REPAIRED R1 DOOR IAW FSRM 52-11-00, FIG 206.SDR SIMA20121016011Structure · corrodedAFT SCREW HOLE ON BOTTOM EDGE OF PAX DOOR IS CORRODED. REPAIRED AFT SCREW HOLE CORRODED AREA ON BOTTOM EDGE OF PAX DOOR IAW AEA EO-EM-52MR-331.SDR REXA2012111101495Angle · corrodedCORROSION AROUND PAX DOOR PROX SWITCH ANGLE. REMOVED AND REPLACED IAW SRM 51-24-16.SDR UHLA2012101600328Door · dirtyL2 DOOR INDICATION NOT SHOWING CLOSED, YELLOW CIRCLE WITH BLACK X. CLEANED AND LUBED L2 DOOR AND PERFORMED SYSTEMS CHECK IAW AMM 52-72-21. OPS CHECK GOOD.SDR UALA2012101605891Gate · corrodedL2 DOOR LOWER GATE IS CORRODED. REMOVED AND INSTALLED L2 LOWER GATE. ADJUSTMENT TO BE COMPLIED WITH ON NR 9987521.SDR SWIA201231980Spring · out of adjustPASSENGER DOOR HARD TO OPEN. (SERVICE) ADJUSTED PASSENGER DOOR GAS SPRINGS IN REFERENCE TO AMM.SDR ASOA2012101802379Door · lack of lubePAX DOOR STICKS AND IS REPORTED TO BE DIFFICULT TO OPEN AND CLOSE. LUBRICATED PAX DOOR IAW AMM 52-10-00. OPS CHECKED GOOD, REF 12-20-52.SDR ASOA2012101802375Drag Angle · crackedPAX DOOR AFT DRAG ANGLE, CRACKED. UPON FURTHER INVESTIGATION FOUND PREVIOUS REPAIR IAW REO 601R-52-11-513, REV A. R & R -1 REPAIR ANGLE REF REO 601R-52-11-513, REV A.SDR UALA2012101605907Plate · defectiveDOOR 1L HAS PLASTIC BLOCKING ARMED INDICATOR. REPLACED THE ARMED - DISARMED SIGHT GLASS PLATE.SDR SIMA20121015005Bar · out of adjustON FLIGHT 3392 THE FLIGHT ATTENDANTS REPORTED THE MAIN CABIN DOOR WAS HARD TO OPEN, IT APPEARED TO CATCH ON THE UPPER LEFT CORNER. THE AIRCRAFT WAS REMOVED FROM SERVICE. INSTALLED 1 ADDITIONAL WASHER BETWEEN DOOR ARM FITTING NR 1 AND NR 2 PER ETN #EM-52-013RSDR SIMA20121015004Guide · unserviceableON FLIGHT 2814 THE CREW REPORTED THE MAIN CABIN DOOR WAS VERY HARD TO OPEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE FORWARD LOWER MAIN DOOR GUIDE REF AMM 53-71-06. THE OPERATIONAL CHECK WAS GOOD REF AMM 52-18-00. NO FURTHER DEFECTS SDR USAA2012101600001Spring · defective1L DOOR ARMING LEVER STICKS AND GRINDS WHEN LOWERING TO ARMING POSITION. MAINTENANCE REPLACED ASSIST SPRING FROM FWD PAX DOOR VENT FLAP VISUAL LOCK INDICATOR. OPERATIONAL CHECK IS NORMAL.SDR UALA2012101505841Handle · faultyMAIN CABIN R1 DOOR EXTERNAL HANDLES DO NOT RETRACT CORRECTLY. REMOVED EXTERIOR HANDLES AND SHAFTS. REPLACED NEW OUTER SHAFT TO EXTERIOR HANDLE PER MM AND REINSTALLED HANDLE ASSY PER MM AND FUNCTIONAL CHECKED GOOD.SDR UALA2012101505844Light · inoperativeL2 DOOR CABIN PRESSURE RED WARNING LIGHT INOPERATIVE. ACCOMPLISHED MT 52-011, ALL LIGHTS OPS CHECKED NORMAL.SDR UALA2012101505843Light · inoperativeR2 DOOR CABIN PRESSURE RED WARNING LIGHT INOPERATIVE. ACCOMPLISHED MT 52-011 ALL LIGHTS, OPS CHECKED NORMAL.SDR USAA2012101500006Bottle · low pressureCHECK DOOR PRESSURE AT L4. SERVICED L4 DOOR ASSIST BOTTLE PRESSURE PER AMM 52-00-040-001A.SDR USAA2012101500005Bottle · low pressureCHECK FORWARD SLIDE PRESSURE ILLUMINATED WHEN FLIGHT ATTENDANT CLOSED L1 DOOR. SERVICED DOOR ASSIST BOTTLE AT L1 DOOR PER AMM 52-10-00-614-001.SDR SIMA20121014001Roller · dirtyON FLIGHT 3387 THE FLIGHT ATTENDANT REPORTED THE MAIN DOOR WAS HARD TO OPEN. THE AIRCRAFT WAS REMOVED FROM SERVICE. CLEANED AND LUBED MAIN DOOR ROLLERS PIN IAW AMM 53-21-02. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT WAS RETURNED TO SERVICE.SDR UALA2012101505862Mechanism · out of adjustR2 DOOR FAILED MIDWAY CHECK. ADJUSTED MODE SELECTOR LOCKOUT MECHANISM PER MM AND OPS TESTED GOOD.SDR UALA2012101505860Latch · out of adjustR2 DOOR UNLATCH TORQUE MINIMUM FAILED CHECK. ADJUSTED R2 DOOR UNLATCH TORQUE PER MM, UNLATCHING FORCE IS GREATER THAN 200 INCH-POUNDS WITH SLIDE AND LINERS REMOVED.SDR UALA2012101505861Handle · out of adjustL4 DOOR FAILED UNLATCH TORQUE CHECK. ADJUSTED L4 DOOR HANDLE UNLATCHING TORQUE PER MM 52-11-00 AND TORQUE CHECKED GOOD.SDR SIMA20121012001Handle · looseON FLIGHT 4176 THE CREW REPORTED THEY COULD NOT OPEN MAIN CABIN DOOR FROM INSIDE OF CABIN DOOR. THE DOOR WOULD ONLY OPEN USING LEVER FROM OUTSIDE OF THE AIRCRAFT. THE AIRCRAFT WAS REMOVED FROM SERVICE. RE-SECURED INTERNAL ACTUATING HANDLE ON PASSENGER DOOR
Back to JASC 5210