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 FDEA201703210964Actuator · inoperative1L DOOR INOP. ELECTRIC DOOR ACTUATOR INOP. FOR EMERGENCY EGRESS, USE PNEUMATIC SYSTEM TO OPERATE DOOR. REPLACED L1 DOOR ACTUATOR ELECTRIC REF AMM 52-11-01-2. ADJUSTED CLUTCH CABLE REF AMM 52-11-00-5.SDR IPXA2017032115385Actuator · failedTHE R1 DOOR WILL NOT CLOSE. REPLACED THE R1 DOOR ACTUATOR ASSY IAW MM 52-11-01-401.SDR REXA2017032000409Step · crackedPAX DOOR AFT SIDE THIRED STEP FROM THE TOP, LOWER CORNER AREA IS CRACKED. REPAIRED THE PAX DOOR STEP IAW REO 670-52-11-104, REV H.SDR AALA201703239024Snubber · brokenLOUD NOISE FROM L1 DOOR WHEN DOOR WAS CLOSED. REPLACED L1 DOOR SNUBBER IAW AMM 52-11-51-400-801. THE AIRCRAFT WAS GROUNDED.SDR AALA201703229025Guide Arm · out of adjustDOOR 1L COULD NOT BE OPENED BY AGENT FROM OUTSIDE. FOUND GUIDE ARM OUT OF ADJUSTMENT. ADJUSTED GUIDE ARM PER AMM 52-11-00 OPS CKS GOOD. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201703229007Damper · low pressureL2 DOOR EMERGENCY EXIT DOOR DAMPER HAD LOW PRESSURE. SERVICED THE L2 DOOR DAMPER IAW AMM 52-10-00.SDR ASOA201703201350Stiffener · crackedPAX DOOR MOTOR SUPPORT STIFFENER (LOWER) CRACKED AT LOWER SECTION. REMOVED AND REPLACED LOWER STIFFENER ON PAX. DOOR MOTOR SUPPORT PER SRM 51-42-06-001-001-A01 AND DRAWING 601R31707 P/N 601R317745-7.SDR AALA201703219010Bottle · low pressureL2 DOOR BOTTLE HAD LOW PRESSURE. SERVICED THE DOOR BOTTLE.SDR A6WA201744869Skin · damagedPAX DOOR INNER SKIN DAMAGED AT SUPPORT WHEEL LOCATION.SDR DALA2017032402384Target · disengagedTHE L4 DOOR DISARM HANDLE DOES NOT MOVE TO THE FULL DISARM (GREEN) POSITION. TROUBLESHOT AND FOUND LH ( PROXIMITY SWITCH TARGET DISENGAGED FROM GIRT BAR. REINSTALLED TARGET ON GIRT BAR IAW AMDS WORKCARD AND LUBED GIRT BAR AND FLOOR FITTINGS. (8515281)SDR DALA2017032102322Structure · gougedFOUND ON ARRIVAL, GOUGE ON BOTTOM AFT CORNER OF L4 DOOR. FABRICATED AND INSTALLED PARTS IAW SRM 52-13-00, FIG213.SDR AALA20170320008Damper · low pressureL4 DOOR DAMPER PRESSURE BELOW LIMIT. SERVICED L4 DOOR DAMPER IAW AMM 52-13-14.SDR MASA2017031912677Mechanism · lack of lubePAX DOOR HANDLE HARD TO OPEN. LUBED DOOR MECHANISMSDR FDEA201703190960Reservoir · emptyFORWARD PASSENGER DOOR WAS PNEUMATICALLY OPENED BY THE EMERGENCY OVERRIDE LEVER. RESET THE L1 DOOR IAW MM 52-11-02-2, SPOTTED THE PRESSURE FOR THE RELATIVE PNEUMATIC RESERVOIR WAS ZERO. CHARGED THE L1 DOOR RESERVOIR IAW AMM 12-25-04-3, ACFT OK FOR SERVICE.SDR DALA2017032002200Doubler · damagedBENT AND NICKED EXTERNAL DOUBLER ON BOTTOM AREA OF THE L1 DOOR. DOUBLER THE WAS REPLACED IAW SRM 52-05 FIG. 37 (SHEET 1).SDR REXA2017031800466Drag Angle · crackedPAX DOOR AFT RISER DRAG ANGLE IS CRACKED BY ASSIST MOTOR PULLEY. REMOVED AND REPLACED ANGLE, AFT RISER DRAG ANGLE, BY MOTOR ASSIST PULLEY IAW REO# 601R-52-11-513.SDR REXA2017031800464Riser · crackedPAX DOOR FWD RISER IS CRACKED AT THIRD STEP. REPAIRED RISER IAW REO 601R-52-11-702 REV E 2016-08-14.SDR REXA2017031800463Riser · corrodedPAX DOOR FWD RISER HAS CORROSION BY UPPER STEP. REMOVED CORROSION. ORIG MATL IS .040, REM IS .029 LOSS IS .011 OUT OF LIMITS. REPAIRED IAW REO 601R-52-11-302 SRM 51-21-06, 52-00-00.SDR AALA201703209031Damper · low pressureL2 DOOR DAMPER LOW PSI. SERVICED DOOR DAMPER IAW AMM 52-10-00.SDR AALA201703209029Damper · low pressureL1 DOOR DAMPER LOW PSI. SERVICED DOOR DAMPER IAW AMM 52-10-00.SDR DALA2017031902212Intercostal · crackedCRACKED INTERCOSTAL ON AFT FRAME BETWEEN BEAMS 4 AND 5. REPLACED IAW SRM 51-30-02.SDR 9JLA2017040614162Bellcrank · crackedDURING FLIGHT, THE CREW REPORTED THAT THE MAIN CABIN DOOR ANNUNCIATOR ILLUMINATED. DIVERTED FOR FURTHER INVESTIGATION AND REPAIR. LANDING WAS UNEVENTFUL. TROUBLESHOT TO DETERMINE THE CAUSE. THE AIRCRAFT WAS GROUNDED. DISCOVERED THAT A BELLCRANK IN THE MAINSDR ASOA201703171385Intercostal · corrodedINTERCOSTAL CORRODED IN PAX DOOR BELOW AND FWD OF MID PIVOT. REMOVED AND REPLACED THE INTERCOSTAL IAW SRM 51-42-06-001-001-A01.SDR DALA2017032102278Skin · dentedSMALL DENT FOUND ON LOWER FORWARD EDGE OF L1 DOOR SKIN AFT OF LOWER FORWARD CORNER. REPAIRED IAW SRM 52-01-01.SDR QXEA2017032100158Bracket · crackedAFT ENTRY DOOR-BEAM BELOW TORQUE TUBE-HAS SIGNS OF CRACKS. R&R STOP BRKT PN85216839-105 FROM NR 2 BEAM PN85217412 AT AFT ENTRY DOOR REF SRM51-40-15,51-42-05 RMVD SPRING SUPPORTS BRKT PN85217732-101,85217732-102 FROM NR 2 BEAM PN86217412 AT AFT ENTRY DOOR REF SDR ASAA2017031720216Guide · out of adjustL1 DOOR INTERMITTENTLY HARD TO CLOSE. ACFT GROUNDED. ADJUSTED THE DOOR FWD GUIDE ARM IAW AMM 52-11-00. DOOR CLOSES & OPENS SMOOTHLY.SDR DALA2017031802196Beam · crackedL1 DOOR CRACKED BEYOND STOP DRILL ON PREVIOUS REPAIR BEAM 1. THE BEAM FWD EDGE WAS REPAIRED IAW SRM 52-05 FIG. 98 (SHEET 3).SDR SIMA20170317001Roller · lack of lubePASSENGER DOOR WOULD NOT OPEN INSIDE OR OUTSIDE. CLEAN AND LUBED MAIN DOOR ROLLERS IAW AMM 52-21-01. OPS CHECKED GOOD.SDR ASOA201703173043Door Frame · corrodedMAIN PAX DOOR LOWER FRAME CORRODED. REPAIRED THE LOWER DOOR FRAME IAW ETD2017-145-021201.SDR ASOA201703161364Doubler · crackedPAX DOOR INTERNAL PULL IN CAM DOUBLER CRACKED UPPER AFT SIDE. REMOVED AND REPLACED CAM DOUBLER IAW SRM 51-42-06-001-001-A01, AND 51-42-21-001-001-A01.SDR AALA201703209025Cylinder · low pressureL4 DOOR EMERGENCEY ACTIVATION CYLINDER PRESSURE IS BELOW LIMITS. SERVICED THE CYLINDER IAW AMM 52-00-00.SDR AALA201703209022Cylinder · low pressureL4 DOOR EMERGENCY OPERATION CYLINDER PRESSURE LOW. SERVICED THE CYLINDER IAW AMM 52-10-00.SDR AALA201703179015Cylinder · low pressureR1 DOOR EMERGENCY ACCUMULATOR CYLINDER PRESSURE IS LOW. SERVICED THE R1 DOOR CYLINDER IAW AMM 52-10-00.SDR AALA20170317002Cylinder · low pressureL4 DOOR EMERGENCY ACTUATOR CYLINDER PRESSURE IS LOW. SERVICED CYLINDER IAW AMM 52-00-00.SDR R61A201703160219Door · out of adjustL1 DOOR HARD TO CLOSE. ADJUSTED L1 DOOR IAW AMM 52-11-00. FUNCTIONAL CHECK GOOD.SDR AALA201703179003Bottle · low pressureLOW PRESSURE ON DAMPER FOR THE PASSENGER CREW DOOR AT AFT GALLEY AREA. CHARGED THE DOOR DAMPER IAW AMM 52-10-00-614-001-A.SDR YENA201703160194Beam · corrodedDURING HEAVY CHECK MAINTENANCE, IT WAS DISCOVERED THAT L2 DOOR BEAM HAD CORROSION. R & R THE BEAM IAW SRM 51-42-11.SDR YENA201703160193Beam · corrodedDURING HEAVY CHECK MAINTENANCE, DISCOVERED THAT AT R2 DOOR BEAM CORRODED FWD SIDE. Y-1292 BETWEEN FRAMES 65-66. R & R THE BEAM IAW SRM 51-42-11.SDR DALA2017031702120Beam · crackedL1 DOOR. CRACK ON BEAM 1 , AFT EDGE AT MAIN ENTRANCE DOOR. BEAM 1 , AFT EDGE WAS REPAIRED IAW SRM 52-05, FIG 81, SHEET 3.SDR MASA2017031612668Cable · brokenPAX DOOR WILL NOT OPEN FROM THE INSIDE. REPLACED ICE BRAKE CABLE.SDR ASOA201703151368Intercostal · corrodedINTERCOSTAL CORRODED IN PAX DOOR BELOW OUTER HANDLE HOUSING (FIG 52-11-06-991-801 ITEM 33). REMOVED AND REPLACED PER SRM 51-42-00-001-001-A01, 51-42-06-001-001-A01, 51-40-11-001-001-A01.SDR AALA201703179024Strap · looseAIRCRAFT WAS NOT GROUNDED. L4 DOOR EMERGENCY EVACUATION SLIDE BUSTLE IS LOOSE. SECURED LOWER STRAP ON LOWER LINING IAW AMM 52-11-02. OPERATIONAL CHECK GOOD.SDR AALA201703179014Damper · low pressureL1 DOOR, DAMPER PRESSURE LOW. SERVICED THE BOTTLE IAW AMM 52-10-00.SDR AALA201703179013Damper · low pressureEMERGENCY EXIT L3 DOOR DAMPER PRESSURE GAUGE READS IN RED AREA. SERVICED THE L3 DOOR DAMPER IAW AMM 52-22-00.SDR FDEA201703150919Control Rod · bentR1 DOOR SHOWS ARMED WHEN UNARMED. FOUND CONTROL ROD FOR THE SLIDE ARMING RETRACTABLE DOOR MECHANISM, BENT. REMOVED AND REPLACED THE CONTROL ROD. ADJUSTED THE CONTROL ROD AND PERFORMED A TEST OF THE SLIDE ARMING SYSTEM. COULD FIND NO OTHER DEFECTS. OK TO SDR AALA20170316001Cylinder · low pressureL3 DOOR EMERGENCY EXIT DAMPER PRESSURE GAUGE NEEDLE IN THE RED. CHARGED L3 DOOR CYLINDER IAW AMM 52-22-00.SDR GLBA2017031700643Cable · looseMAINTENANCE NOTED THAT THE UPPER FORWARD AIRSTAIR DOOR HANDRAIL CABLE HAS IMPROPER TENSION. ADJUSTED THE CABLE IAW MM 52-10-02.SDR ASOA201703141405Riser · corrodedPAX DOOR FORWARD RISER IS CORRODED IN MULTIPLE AREAS. BLENDED CORROSION ON FWD RISER AND FOUND TO BE OUT OF LIMITS IAW SRM 52-00-01-101-001-A01. REMOVED AND REPLACED FWD RISER PER SRM 51-42-12-001-001-A01 AND DWG 601R31707. THIS IS A MAJOR REPAIR.SDR ASOA201703141395Riser · crackedPAX DOOR AFT RISER IS CRACKED AT BOTTOM FWD STEP. PAX DOOR REPLACED AFT RISER AND STIFFENER IAW SRM 51-42-06-001-001 A01 AND 51-40-11-001-001 A01.SDR IPXA2017031415146Pin · damagedL1 DOOR STUCK HALF WAY UP. DOOR WILL NOT OPERATE ELECTRICALLY, L1 DOOR CLOSED MANUALLY. REPLACED THE L2 DOOR LOCK PIN IAW AMM 52-10-06.
Back to JASC 5210