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 SIMA20141220007Drag Angle · crackedPASSENGER DOOR AFT ATTACHMENT ANGLE HAS A 1 INCH CRACK. R & R BAD SECTION OF PAX DOOR AFT DRAG ANGLE IAW SRM 52-11-04.SDR SIMA20141220006Skin · crackedPASSENGER DOOR AFT SIDE SKIN HAS 1/4 INCH CRACK AT THE MIDDLE STEP AREA. REPAIRED PAX DOOR AFT SIDE SKIN IAW ETN-CR-52-039 & REINSTALLED GAS SPRING BEAM IAW SRM 51-42-06.SDR SIMA20141220005Cover · crackedPASSENGER DOOR AFT UPPER CORNER IS CRACKED APPROX 1 1/4 INCHES BY THE RIVET. R & R PAX DOOR INNER UPPER AFT CORNER COVER IAW SRM 51-42-06 & 51-42-13.SDR UHLA2014122000857Hook · obstructedMAIN CABIN DOOR DOES NOT LOCK OPEN. L1 DOOR HINGE TRIM WAS TOUCHING LATCHING HOOK MECHANISM. ADJUSTED IAW AMM 25-23-08.SDR ASAA2014122010024Handle · lack of lubeR1 DOOR WILL NOT OPEN FROM OUTSIDE. ACFT GROUNDED. INSPECTED DOOR HANDLE MECHANISM NO DEFECTS AT THIS TIME. CLEANED AND LUBED DOOR HANDLE MECHANISM IAW AMM 12-25-13. DOOR HANDLE MECHANISM, OPS GOOD AT THIS TIME IAW AMM 52-41-00.SDR SIMA20141220002Door · malfunctionedMAIN CABIN DOOR HARD TO CLOSE.SDR V0XD201412200271Angle · corrodedPASSENGER DOOR SURROUND STRUCTURE KICK ANGLE CORRODED. R & R PAX DOOR KICK ANGLE IAW SRM 51-42-06.SDR SWAA2014122335231Skin · crackedL1 DOOR INNER SKIN CRACKED AT LOWER HINGE AREA. REPAIRED SKIN IAW EA.SDR ASAA2014121910028Arm · out of rigFORWARD L-1 DOOR VERY DIFFICULT TO CLOSE FROM INSIDE. NOT CLOSING PROPERLY NEED TO PUSH UP ON HIGH RT CORNER SAME TIME AS FINAL LATCH. ACFT GROUNDED. INSP FWD L1 DOOR FOUND DOOR TO BE OUT OF RIG AT GUIDE ARMS AND VARIOUS PORTS AROUND THE DOOR. RECOMMEND DOORSDR SIMA20141219001Door · obstructedMAIN DOOR WILL NOT CLOSE. REMOVED DISCARDED HARDWARE & DEBRIS ON DOOR THRESHOLD. OPERATIONS CHECKED GOOD IAW SMP.SDR USAA2014122200010Support Fitting · looseDOOR 2L WILL NOT OPEN APPEARS TO BE HANGING LOW ON THRESHOLD. REPLACED UPPER SUPPORT ARM ON DOOR 2L.SDR USAA2014122200001Bottle · dischargedAT GATE AFTER DOORS DISARMED, UPON OPENING L1 DOOR, ASSIST BOTTLE FIRED SLAMMING L1 DOOR OPEN. NO CHUTE DEPLOYMENT. CHARGED ASSIST BOTTLE, LEAK CHECK IS GOOD.SDR ASOA2014122211893Rod · brokenPAX DOOR WILL NOT OPEN. FOUND PRESSURE RELIEF VENT FLAP ROD BROKEN. REPLACED PAX DOOR VENT FLAP ROD IAW AMM 52-11-15. OPS CHECK GOOD. ACFT OK FOR SERVICE.SDR USAA2014121900006Pin · missingDOOR 3L DISARM LEVER IS LOOSE. REPLACED MISSING ALIGNMENT PIN.SDR USAA2014121900005Buffer · out of adjustDOOR 4L GUST LOCK WILL NOT HOLD 4L DOOR IN OPENED POSITION. ADJUSTED DOOR 4L BUFFER. OPERATION CHECKED GOOD IAW AMM 52-13-00-820.SDR USAA2014121800005Bottle · low pressureR2 DOOR ASSIST BOTTLE LOW. SERVICED R2 DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR USAA2014121700006Bottle · low pressureC1 CHECK FOUND 2R DOOR ASSIST BOTTLE PRESS BELOW 1783 PSI DURING VISUAL INSPECTION IAW JOB CARD 33C80052003. PRESS GAUGE NEEDLE AT BOTTOM OF YELLOW BAND. CHARGED 2R DOOR BOTTLE IAW JOB CARD 33C80052003 & AMM 52-10-00-600-802. ACCOMPLISHED TROUBLESHOOTING PRSDR QXEA2014121601102Gas Cylinder · failedF/A REPORTS THAT THE MAIN CABIN DOOR IS VERY HARD TO OPEN. REPLACED DOOR STRUTS. RETURNED TO SERVICE.SDR GTIA2014121601468Latch · lack of lubeL1 DOOR HAS ISSUES OPENING FROM THE OUTSIDE. CLEANED AND LUBRICATED THE L1 DOOR HANDLE LATCH ASSY , OPS NORMAL IAW AMM 52-00-00.SDR N6WA2014121602Handle · icedPAX DOOR SHOWS RED ON EICAS. REMOVED ICE FROM PAX DOOR HANDLE ASSEMBLY & PERFORMED OPERATIONS CHECK IAW AMM 52-70-04. OPERATIONS CHECKED GOOD AT THIS TIME.SDR N6WA2014121601Cable · frayedMAIN PAX DOOR SUPPORT WHEEL CABLE FRAYED. R & R FWD OAX DOOR SUPPORT WHEEL BOTTOM CABLE ASSEMBLY IAW AMM 52-11-13. OPERATIONS CHECKED GOOD AT THIS TIME.SDR USAA2014121700003Cylinder · low pressureR1 DOOR EMER CYLINDER LOW. SERVICED R1 DOOR EMER CYLINDER IAW AMM 52-10-00.SDR AALA20141216001Bottle · low pressureDURING A CHECK INSPECTION FOUND R1 DOOR ASSIST BOTTLE PRESS LOW. SERVICED R1 DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR RAIA201412160001Stop Fitting · bentMAIN DOOR AIRSTAIRS NOT FULLY DEPLOYING DURING POST FLIGHT. MAINTENANCE INSPECTED AND FOUND STEP FOLDOUT BACKSTOP BENT, REPLACED BACKSTOP, OPS CHECK GOOD.SDR SWIA201440540Hand Rail · damagedPAX DOOR FWD HAND RAIL, DENTED FWD UPPER CORNER COVER AND DAMAGED ATTACH FASTENER. REPAIRED AND RESTORED FINISH IAW SRM AND REO.SDR SWIA201440539Hand Rail · damagedPAX DOOR AFT HANDRAIL, DENTED AFT UPPER CORNER COVER AND DAMAGED ATTACH FASTENER. REPAIRED AND RESTORED FINISH IAW SRM AND REO.SDR SWIA201440492Leg Assy · chafedPASSENGER DOOR SUPPORT WHEEL LEG CHAFED ON AFT STAIR RAIL. BLENDED CHAFE ON PASSENGER DOOR SUPPORT WHEEL IAW EA.SDR SWIA201440485Striker · chafedPASSENGER DOOR AFT UPPER STRIKER PLATE CHAFED ON FASTENER HEAD. BLENDED CHAFE ON PASSENGER DOOR AFT UPPER STRIKER PLATE FASTENER HEAD, IAW REO.SDR SWIA201440481Striker · chafedPASSENGER DOOR FORWARD UPPER STRIKER PLATE CHAFED ON FASTENER HEAD. BLENDED PASSENGER DOOR FWD UPPER STRIKER PLATE FASTENER, IAW REO.SDR SWIA201440480Lever · chafedPASSENGER DOOR FORWARD PULL-IN LEVER CHAFED. C-CHECK, REPAIRED FWD PULL IN LEVER IAW REO.SDR ASOA2014122211889Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED JUST ABOVE MOTOR ASSIST PULLEY BRACKET. FABRICATED A NEW ANGLE SECTION. SEALED AND WET INSTALLED THE DRAG ANGLE IAW SRM 52-11-04, REPAIR 002-A01. MAJOR REPAIR IAW GMM 5-3.SDR DALA2014121706580Structure · damagedL1 DOOR, LOWER FORWARD CORNER ROLLED UNDER ALONG RIVET LINE. WORKED LOWER FORWARD CORNER OF L1 DOOR IAW SRM 52-01-01, PARA 8C.SDR SWAA2014121635081Stop Fitting · crackedL2 DOOR UPPER FWD STOP PIN FITTING CRACKED. R & R DOOR IAW AMM.SDR REXA2014121401194Switch · defectivePASSENGER DOOR WAS FULLY OPEN & JET BRIDGE ATTACHED. PAX DOOR THEN BEGAN TO CLOSE WITHOUT POWER DOOR ASSIST SWITCH MANIPULATION. PULLED CBS P1 F1+ F2 IAW MOC TO STOP DOOR FROM CLOSING. R & R PAX DOOR ASSIST SWITCH IAW ESPM 20-24-00. OPERATIONS CHECKED GOODSDR N6WA20141404Door Seal · dirtyMAIN CABIN DOOR SEAL MAKING NOISE. CLEANED DEBRIS FROM SEAL & DOOR FRAME, LUBED SEAL IAW AMM 52-00-00.SDR GTIA2014121401465Bottle · low pressureL1 DOOR ASSIST BOTTLE LOW PRESSURE. SERVICED ASSIST BOTTLE TO NORMAL PRESSURE IAW AMM 52-10-00, OPS OK.SDR UHLA2014121400849Indicator · out of adjustR1 DOOR LATCH VISUAL INDICATOR INOPERATIVE. ADJUSTED R1 DOOR VISUAL INDICATOR FLAG IAW AMM 52-42-22. OPS CHECK GOOD.SDR A6WA201442236Bracket · crackedPASSENGER DOOR POWER ASSIST MOTOR MOUNT BRACKET IS CRACKED.SDR USAA2014121500011Handle · dirtyAFT DOOR 2L DIFFICULT TO ARM, GETS STUCK HALFWAY. REMOVED DEBRIS. OPERATIONS CHECKED GOOD.SDR SWIA201440472Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. REPAIRED IAW REO.SDR SWIA201440471Cap · dentedPAX DOOR UPPER AFT END CAP DENTED. REPAIRED IAW REO.SDR SWIA201440470Cap · dentedPAX DOOR UPPER FWD END CAP DENTED. REPAIRED IAW REO.SDR SWIA201440469Lever · chafedPAX DOOR FWD PULL-IN LEVER CHAFED. COMPLIED WITH REPAIR IAW REO.SDR A6WA201442249Handle · crackedPASSENGER DOOR OUTER HANDLE CRACKED.SDR REXA2014121101200Drag Angle · crackedTASK CARD 900-52-830-300 PASSENGER DOOR AFT DRAG ANGLE CRACKED. REPAIRED PAX DOOR AFT ANGLE IAW SRM 52-11-04-201-002-A01.SDR QXEA2014121701085Angle · corrodedAFT ENTRY DOOR ANGLE CORRODED. REMOVED AND REPLACED THE ANGLE IAW SRM 51-42-05, 51-42-45, 51-40-07, 51-40-15 REPAIR 01 AND DWG 85339511, REV B.SDR GTIA2014121001463Seal · dirtyL1 DOOR SEAL SQUEALED IN FLIGHT. PERFORMED DETAILED INSPECTION OF L1 DOOR SEAL IAW AMM 52-10-00, NO DEFECTS FOUND. ACFT OK FOR CONTINUED SERVICE.SDR AALA20141210006Bottle · low pressureL4 DOOR ASSIST ACTUATOR BOTTLE PRESS IS LOW. SERVICED BOTTLE IAW AMM 52-10-00. SYS CHECKED NORMAL.SDR A6WA201442234Step · crackedPASSENGER DOOR LOWER STEP FWD SKIN CRACKED.SDR CA141215001Bolt · sheared(CAN) DURING THE ACCOMPLISHMENT OF TASK RJ9-52-830-500 - DETAILED INSPECTION OF THE PASSENGER DOOR INTERNAL STRUCTURE - IT WAS REPORTED THAT ON THE UPPER LATCH AFT FITTING, THE ATTACHMENT BOLT HEAD WAS FOUND SHEARED FROM CORROSION.
Back to JASC 5210