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 AALA20100222TUL11Pan · gougedLEFT NUMBER 2 DOOR OUTER HANDLE PAN GOUGED. INSTALLED NEW PAN PER ESO 90282.SDR AALA20100222TUL08Pan · gougedLEFT NUMBER 1 EXTERIOR HANDLE PAN GOUGED. GOUGED PAN REMOVED AND NEW PAN INSTALLED AND SEALED PER ESO90283.SDR SWIA201023720Torque Tube · obstructedUNABLE TO OPEN MAIN CABIN DOOR. (FLT 6154) REMOVED EXCESS GREASE AT DOOR LATCH CAM TORQUE TUBE.SDR RAIA2010022200002Door · out of adjustTHE FLIGHT ATTENDANT REPORTED THAT THE MAIN CABIN DOOR AS BEING HARD TO OPEN. MAINTENANCE ADJUSTED AND TESTED THE MAIN CABIN DOOR IAW AMM PROCEDURES. OPS CHECKED GOOD.SDR MASA2010022200149Seal · icedPASSENGER DOOR DIFF TO OPEN/CLOSE. REMOVED ICE FROM DOOR SEAL, OPS CHECK GOOD.SDR RMXA022220107217Guide · wornDURING FLIGHT, A CREWMEMBER NOTICED A GAP ON THE LOWER EDGE OF THE RT SLIDING DOOR. AN UNSCHEDULED LANDING WAS PERFORMED & THE DOOR WAS SECURED. FLIGHT CONTINUED WITHOUT ANY FURTHER INCIDENT. MX REPLACED A WORN GUIDE PN 117-24273-2 & WORN CATCHER PN 117-242SDR AALA20100221TUL02Pan · gougedLEFT NUMBER 1 DOOR HANDLE PAN WORN. REMOVED AND REPLACED LEFT NUMBER 1 DOOR OUTER HANDLE PAN PER ESO90283.SDR USAA2010022290425Cylinder · low pressureFLT 430 - PHL-LAS - EMERGENCY EGRESS SYSTEM - L2 DOOR ASSIST BOTTLE NEEDS SERVICING. SERVICE L2 DOOR ASSIST BOTTLE PER AMM 52-10-00-614.SDR QXEA2010022200121Angle · corrodedPAX DOOR MID CAP ANGLE IS CORRODED. REMOVED CORRODED ANGLE, FOUND TO BE CORRODED THROUGHOUT AND BEYOND LIMITS IAW SRM 53-21-23-001-A01 PG 101, ALL WORK DONE IAW SRM 51-42-02-001-001-A01. LOCATED AND DRILLED NEW MID CAP ANGLE IAW SRM 51-40-11-001-001-A01. INSSDR SWIA201023735Door · lack of lubeMAIN DOOR IS DIFFICULT TO OPEN AND CLOSE. (FLT 6063) LUBRICATED MAIN DOOR.SDR SWIA201023734Arm · out of adjustMAIN CABIN DOOR WILL NOT OPEN FROM OUTSIDE. (FLT 1002) REPLACED BOTTOM AFT SHIMS AND ADJUSTED MAIN CABIN DOOR HINGE ARMS.SDR USAA2010022490442Cylinder · low pressureFLT 941 - MSP-PHX - EMERGENCY EGRESS SYSTEM - PASSENGER DOOR L4 CHECK DOOR LOW PRESSURE. SERVICED DOOR BOTTLE PER AMM 52-22-00.SDR SWIA201024045Web · crackedPASSENGER DOOR AFT WEB CRACKED AT ZONE 3. (C CHECK) REPAIRED PER REO.SDR SWIA201023699Motor · inoperativePASSENGER DOOR DIFFICULT TO OPEN. (FLT 4525) REPLACED DOOR ASSIST MOTOR.SDR ASOA201000277Anchor Fitting · crackedPAX DOOR FWD ANCHOR FITTING IS CRACKED AND HAS CORRODED HARDWARE. REMOVED AND REPLACED FWD PASSENGER DOOR COUNTERBALANCE ANCHOR FITTING IAW AMM 52-11-17-000-804 AND 52-11-17-400-804. ADJUSTED PASSENGER DOOR COUNTERBALANCE IAW AMM TASK 52-11-17-820-802. OPS CSDR USAA2010022290418Door Frame · crackedCLT - MAJOR REPAIR - Q1 CHECK, FORWARD SERVICE DOOR FRAME AT BEAM 1, BS 329 CRACKED. REPLACED THE FORWARD SERVICE DOOR.SDR GUUA94152021810APanel · out of limitsPILOT REPORTED CABIN DOOR HARD TO OPEN AFTER LANDING. TRIMMED CABIN DOOR INTERIOR PANEL AROUND PUSH BUTTON OPS CHECK GOOD.SDR IPXA10158542Lever · failedCREW ENTRY DOOR SLIDE DISARMING LEVER TOOK MULTIPLE TIMES TO DISARM. HANGS UP WITH ABOUT 2 INCHES OF TRAVEL LEFT TO GO. EMERGENCY CONTROL HANDLE CHECKS OK IAW MM 52-10-30-05 PAR. F. FUNCTION TEST DUB PAR 1 ITEMS 3 & 4. CLEARED M419603. REMOVED PLACARD.SDR ASOA201000275Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED IN PREVIOUSLY REPAIRED AREA. REPAIRED THE PAX DOOR AFT DRAG ANGLE IAW ASA EC/TC REO 601R-52-11-513 AND REO 601R-52-11-513 REV A.SDR R61A20100081Unknown · malfunctionedCREW REPORTED L-1 DOOR WAS STIFF WHEN OPENING FROM THE OUTSIDE, THE GATE WAS UNABLE TO HOLD THE DOOR OPERATOR UP WHILE PULLING DOOR OPEN. MAINTENANCE PERFORMED L-1 DOOR ADJ/TEST PER EMB AMM 52-12-52, OPS CHECK GOOD. A/C WAS RELEASED BACK INTO SERVICE.SDR ASOA201000266Handle · lack of lubeF/A REPORTS THAT MAIN PAX DOOR HARD TO OPEN AFTER FLIGHT ENDS, HANDLE DIFFICULT TO RAISE. C/W LUBRICATION AND OPERATIONAL CHECK TO PAX DOOR IAW AMM 52-11-00SDR QXEA2010022200130Strut · damagedUNABLE TO OPEN MAIN CABIN DOOR. SECURED LOOSE HARDWARE ON UPPER TO LOWER STRUT ASSY & COMPLIED WITH OPS TEST OF MAIN CABIN DOOR IAW AMM TASK 52-11-00-710 NO DEFECTS NOTED. RETURNED TO SERVICE. NO PARTS REPLACED.SDR ASOA201000262Handle · lack of lubeF/A REPORTS PAX DOOR DIFFICULT TO OPEN. LUBRICATED HANDLE, INSPECTED DOOR MECHINISM, AND OPERATIONAL TEST GOOD. AMM 52-11-01.SDR R61A20100079Pin · out of positionTHE CREW REPORTED, DISCOVERED THE BUSTLE IN OUT ON THE L-1 DOOR. MAINTENANCE RE-INSTALLED THE BUSTLE PIN ON THE MAIN CABIN DOOR PER EMB AMM, NO FURTHER DEFECTS WERE NOTED. THE A/C WAS THEN RELEASED BACK INTO SERVICE.SDR R61A20100078Pin · out of positionTHE CREW REPORTED, DIFFICULTY WITH CLOSING THE MAIN CABIN DOOR. MAINTENANCE DISCOVERED THE MAIN CABIN DOOR PIN WAS HANGING DOWN, AND RE-INSTALLED BUSTLE PIN FOR THE MAIN CABIN DOOR PER EMB AMM, NO FURTHER DEFECTS WERE NOTED. A/C WAS THEN RELEASED BACK INTO SSDR R61A20100077Pin · out of positionCREW REPORTED DIFFICULTY CLOSING THE MAIN CABIN DOOR. MAINTENANCE RE-INSTALLED THE BUSTLE PIN FOR PAX DOOR NOTED PER EMB AMM 25-65-01, OPS CHECK GOOD.SDR A6WA201040129Handle · crackedPAX DOOR OUTER HANDLE CRACKED. R & R WITH NEW SERVICEABLE PART.SDR SWIA201023701Mechanism · lack of lubeMAIN DOOR VERY HARD TO OPEN. (FLT 5947) CLEANED DOOR LOCKING MECHANISM LINKAGES AND FRAME ROLLERS LUBRICATED.SDR USAA2010021890402Mechanism · out of adjustSAL - EES - S2 CHECK - THE L2 DOOR ASSIST CYLINDER STRIKER MECHANISM WAS FOUND TO BE OUT OF ADJUSTMENT WHILE PERFORMING TASK CARD 26C83252006. ADJUSTED THE L2 DOOR ASSIST CYLINDER STRIKER MECHANISM IAW A320 AMM 52-13-14-820-002.SDR QXEA2010021700092Handle · contaminatedTHE AFT PAX DOOR IS DIFFICULT TO OPEN. FOUND DOOR OPERATING NORMAL. CLEANED DOOR HANDLE FOR RAIN WATER. PERFORMED OPS CHECK OF THE AFT ENTRY DOOR. REF AMM TASK 52-12-00-710-801. OPS CKS NORMAL. NO OTHER DEFECTS NOTED. CLEANED EXTERIOR OF AFT PAX DOOR AND SEALSDR SWIA201023670Torque Tube · wornMAIN CABIN DOOR HANDLE VERY HARD TO OPERATE. (FLT 6266) REPLACED INTERNAL HANDLE ACTUATING TORQUE TUBE AND BEARINGS.SDR SWIA201023672Door · dirtyCABIN DOOR IS DIFFICULT TO OPEN. (FLT 6741) CLEANED AND LUBED CABIN DOOR.SDR ASAA1047377Spring · defectiveFSA REPORTS L1 DOOR DIFFICULT TO OPEN AND CLOSE FOUND HOLD OPEN MECHANISM CAME APART ON UPPER HINGE. REPLACED PIN WASHERS AND RETAINING SPRING ON HOLD OPEN MECHANISM FOR FORWARD ENTRY DOOR. OPERATED DOOR. OPERATED NORMAL REF AMM 52 11 21 404 002 2.SDR R61A20100070Indication Sys · malfunctionedCREW REPORTED THE L-1 DOOR INDICATION WAS SHOWING ALL WHITE. MAINTENANCE WAS DISPATCHED TO THE A/C TO TROUBLESHOOT. MAINTENANCE PLACED THE L-1 DOOR ARM/DISARM INDICATION ON MEL 52-70-01-03.SDR DXTA2010021503988Check Valve · leaking"CABIN DOOR SEAL" EICAS MESSAGE FOLLOWED BY HIGH PITCH SQUEAL AND RUSHING AIR PRESSURE. FLAG OF +- 500 FPM. REMOVED CTR AND LT BLEED AIR CHECK VALVES DUE TO LEAKS. INSTALLED NEW CHECK VALVES IAW M/M CH 36-15-00. OPS CHECKED AND LEAK CHECKED GOOD.SDR FDEA201002120405Gate · corrodedL-1 DOOR LOWER EDGE SECTION HAS CORROSION. REMOVED AND REPLACED L-1 DOOR LOWER GATE IAW MM 52-11-38 AND SRM 51-40-02, ADJUSTED AND PRESSURE CHECK IAW MM 52-11-00, THIS IS A MAJOR REPAIR.SDR ASOA201000267Drag Angle · crackedJOB 8767911, OPS 183, PAX DOOR AFT DRAG ANGLE CRACKED. REPAIRED PAX DOOR AFT DRAG ANGLE IAW REO'S 601R-52-11-513 AND 601R-52-11-751 & ASA ECTC REO 601R-52-11-513.SDR FDEA201002110390Gate · corrodedNR 2 PAS RT DOOR LOWER GATE CORRODED AND PITTED ON OUTER SEAL RETAINER. R & R R2 DOOR LOWER GATE ASSY. FOUND OUT OF LIMITS IAW AMM 52-11-38 AND SRM 52-10-02 FIG 101 DETAIL III. ADJUSTED R2 DOOR IAW AMM 52-11-00-5. CLASSIFIED CATEGORY "A" MAJOR REPAIR.SDR ASOA201000359Cable · misroutedPAX DOOR HARD TO OPEN. FOUND CABLE FOR DOOR ASSIST CAUGHT ON BRACKET. REROUTED CABLE. DOOR OPERATION GOOD IAW AMM 52-11-00. ACFT OK FOR SERVICE.SDR A6WA201040103Panel · crackedREPAIR CRACK ON PAX DOOR TOP PANEL UNDER TOP STEP AFT SIDE AND REQUIRED. REMOVED DAMAGED PAX DOOR EDGE MEMBER UNDER TOP STEP AND INSTALL SERVICEABLE EDGE MEMBER IAW SRM 51-42-06.SDR MYWA100033Door · leakingETOPS SIGNIFICANT SYSTEM - L1 DOOR PRESSURE LEAK ON CLIMBOUT.SDR SWIA201023691Roller · lack of lubeMAIN CABIN DOOR HARD TO OPEN. (FLT 5970) LUBRICATED DOOR PIVOT POINTS AND DOOR FRAME ROLLERS.SDR SWIA201023673Rod End · out of adjustMAIN CABIN DOOR HARD TO OPEN. (FLT 6238) ADJUSTED INTERNAL DOOR HANDLE INTERCONNECT ROD END AND EXTERNAL DOOR HANDLE INTERCONNECT ROD END.SDR A6WA201040102Angle · corrodedPAX DOOR FWD INNER AND OUTER CORNER ANGLES AND DATUM 8 CORRODED. R & R FWD INNER AND OUTER CORNER ANGLES IAW SRM 51-42-06 AND 51-42-21.SDR A6WA201040101Angle · corrodedPAX DOOR AFT INNER AND OUTER CORNER ANGLES AT DATUM 8 CORRODED. R & R AFT INNER AND OUTER CORNER ANGLES IAW SRM 51-42-06 AND 51-42-21.SDR UALA2010021000515Cylinder · lowDOOR 2L EMERGENCY DAMPER CYLINDER BELOW 3 SVC TEMP, ADJUSTED PRESSURE. SERVICED IAW MM. NO LEAK FOUND DURING LEAK CHECK. PRESSURE WAS 800 PSI BEFORE SERVICING.SDR ASOA201000185Anchor Fitting · out of adjustPAX DOOR HARD TO OPEN THEN MADE POPPING SOUNDS WHEN FINALLY OPENED. ADJUSTED PAX DOOR AFT ANCHOR FITTING IAW AMM 52-11-00.SDR DLM88100319Pan · crackedCRACKED FWD UPPER INNER PAN ON L1 DOOR. REPAIRED IAW DWG NR AMR 0952147 REV 2.SDR SIMA201004104Panel · crackedDURING THE MAINTENANCE BASE VISIT INSPECTION FOUND THE PASSENGER DOOR AFT SIDE PANEL CRACKED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE AFT GAS SPRING IAW AMM 52-11-17. THE OPERATIONAL CHECK WAS GOOD. THE AIRCRAFT WAS RETURNED TO SERVSDR SIMA201004103Stiffener · crackedDURING THE MAINTENANCE BASE VISIT INSPECTION FOUND THE PASSENGER DOOR AFT SIDE PANEL STIFFENER CRACKED. THE AIRCRAFT WAS REMOVED FROM SERVICE. REMOVED AND REPLACED THE PASSENGER DOOR SIDE PANEL STIFFENER IAW CRJ 700 SRM 51-42-05. THE AIRCRAFT WAS RETURNED T
Back to JASC 5210