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 ASOA200801421Door · bindingMAIN PAX DOOR HARD TO PULL CLOSE LAST 2 FEET.SDR MASA2008103000755Mechanism · obstructedASH FLT 7324 ORD-BHM. PASSENGER DOOR WILL NOT CLOSE. MX REMOVED FOD FROM DOOR INTERIOR, OPS CHECKED GOOD.SDR MASA2008103000754Rod · defectiveASH FLT 2733 TUS-PHX. PASSENGER DOOR FLAPPER DOOR WILL NOT CLOSE. MX REMOVED AND REPLACED FLAPPER DOOR ROD ASSY.SDR SWIA200820658Structure · crackedDURING C-CHECK, PASSENGER DOOR FORWARD FILLET CRACKED IN STEP RADIUS AT HANDRAIL SUPPORT AND MID STEP RADIUS. REPAIRED PER REO.SDR ASOA200801414Door · bindingPAX DOOR STILL DIFFICULT TO OPEN FROM INSIDE.SDR ASOA200801412Mechanism · faultyPASSENGER AIRSTAIR DOOR LATCHING MECHANISM IS EXTREMELY HARD TO ACTUATE.SDR ASOA200801409Door · bindingPAX DOOR WOULD NOT CLOSE.SDR ASAA0843685Release Mech · lack of lubeL1 DOOR SAFETY RELEASE STUCK IN OPEN POSITION. LUBRICATED LATCH RELEASE, OP'S NORMAL. OK FOR SERVICE.SDR ASOA200801408Door · bindingPAX DOOR DIFFICULT OPENING FROM INSIDE. FLT 5514 DEL 54 MINS.SDR QXEA2008103001150Door · dirtyBOI - F/A REPORTS AFT PAX DOOR HARD TO OPEN. CLEANED AND LUBED C/W OPS CHECK, OPS CHECK NORMAL. RETURNED TO SERVICE. NO PARTS REPLACED.SDR FDKA2008102900284Door · out of rigFDM FLT 8904 CVG-MEM. MAIN CABIN DOOR WILL NOT CLOSE. MX ADJUSTED RIGGING ON DOOR.SDR FDKA2008102800283Door · lack of lubeFRL FLT 6243 IAD-JFK. MAIN CABIN DOOR HARD TO OPEN. MX LUBED DOOR, OPS GOOD.SDR ASAA0843684Doubler · misrepairedGATE AGENT REPORTS UPPER L1 DOOR RUBBING INIT MIG 2C 212173 98040. L1 DOOR UPPER HINGE LWR CAM PLATE BOLTS REPLACED AND TORQUED TO REMOVE LOOSENESS. L1 DOOR GUIDE ARM LOCKPLATE ATTACH BOLT/NUT TORQUED TO REMOVE LOOSENESS. REF CLOSED MIG 2C 212173 FOR WORK ASDR ASAA0873669Latch · dirtyL1 DOOR HOLD OPEN LATCH WILL NOT UNLOCK. CLEANED AND LUBED L1 DOOR HOLD OPEN LATCH, OPS CHECK GOOD.SDR EIAA2008102800063Web · crackedL-2 DOOR LOWER HINGE FWD CUT OUT WEB FOUND CRACKED. L-2 DOOR LOWER HINGE FWD CUT OUT WEB REPAIRED PER EA 52-0061.SDR ASOA200801404Door · bindingPAX DOOR DIFFICULT TO CLOSE.SDR ASAA0843667Guide Arm · out of adjustL1 DOOR DOES NOT CLOSE. ADJUSTED GUIDE ARM ONE FLAT TO PARALLEL DOOR CLOSING. OPS CHECK NORMAL REF 52 11 21.SDR ASOA200801400Door · bindingFLIGHT ATTENDANT REPORTS DIFFICULTY CLOSING MAIN CABIN DOOR. FLT 4941 DEL 23 MINS.SDR ASOA200801396Door · bindingFLIGHT ATTENDANT REPORTS DIFFICULTY CLOSING MAIN CABIN DOOR. FLT 4941 DEL 23 MINS.SDR 08FDEA04527Web · crackedMED FWD LWR CORNER INTERIOR SURFACE OF THE LOWER DOOR WEB IS CRACKED. REMOVED LOWER PORTION OF INNER SKIN FOR ACCESS REF SRM51-30-2 PG 32. REMOVED LWR FWD STOP FITTING REF SRM 51-30-2 PG 8 HAD WEB NDT'ED, AND NO CRACK WAS FOUND, TOOL NR IN22-0043 WAS USED CASDR MASA2008102400749Seal · leakingASH FLT 2829 PHX-TUS - PILOT REPORTED THAT THE MAIN CABIN DOOR WAS SQUEALING IN FLIGHT. MX REPOSITIONED THE DOOR SEAL AND LEAK CHECKED IT.SDR ASOA200801389Door · stuckPAX DOOR WILL NOT OPEN.SDR ASOA200801388Door · bindingPAX DOOR DIFFICULT TO CLOSE. FLT 5624 DEL 312 MINS.SDR 2008UALA06244Structure · out of toleranceDOOR R2 REQUIRES DOUBLER AT UPPER HINGE CUTOUT. MAJOR REPAIR ACCOMPLISHED. INSTALLED DOUBLER REPAIR.SDR 2008UALA06236Plate · corrodedDOOR 2 RIGHT AFT SHEAR PLATE HAS CORROSION. MAJOR REPAIR ACCOMPLISHED REMOVED SHEAR PLATE. REPLACED SHEAR PLATE.SDR 2008UALA06235Plate · corrodedDOOR 2R AFT SHEAR PLATE SUPPORT HAS CORROSION. MAJOR REPAIR ACCOMPLISHED: REMOVED SHEAR PLATE SUPPORT. REPLACED SHEAR PLATE SUPPORT.
SDR 2008UALA06234Plate · corrodedDOOR 2 RIGHT SILL PLATE AT GIRT HOOK 4 EA ATTACH HOLES HAVE CORROSION. REMOVED SILL PLATE FOR REPLACEMENT.SDR 2008UALA06232Gate · corrodedDOOR 4R LWR GATE CORRODED AND MISSING PIECES. REPLACED LOWER GATE.SDR MASA2008102200744Handle · lack of lubeASH FLT 7134 ORD-CAK. PASSENGER DOOR OUTER HANDLE IS HARD TO STOW. MX LUBED DOOR.SDR FDKA2008102200280Roller · looseFRL FLT 8906 JFK-ORF. MAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. MX SECURED DOOR ROLLERS. OPS CHECKED GOOD.SDR WRLA2008090Cable · misriggedDURING MAINTENANCE L4 DOOR FAILED TO OPEN WITH DOOR ARMED, EMERGENCY MODE. REMOVED LININGS, RIGGED AIR RELEASE CABLE AND ARMING ROD IAW DC10 MM 52-12-00. OPS CHECK GOOD. SERVICED DOOR OPENING RESERVOIR IAW DC10 MM 52-12-00. REPLACED L4 DOOR AND SURROUND LISDR SWAA085725Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND L1 DOOR SKIN CRACKED AT LOWER AFT END. REMOVED AND REPLACED L1 DOOR PER MM.SDR RAIA2008102300006Door · malfunctionedDURING INSPECTION, THE PASSENGER DOOR WAS DIFFICULT TO OPERATE. MAINTENANCE PERFORMED AN OPERATIONAL TEST OF THE MAIN DOOR AND LOAD TEST OF THE INTERNAL HANDLE. ALL CHECKS WERE FOUND TO BE WITHIN LIMITS. DOOR OPS CHECKED GOOD.SDR UPS08853891Skin · tornINSPECTION TYPE:SV LT FORWARD DOOR MAIN ENTRY INTERIOR SKIN TORN IN FORWARD CORNER. REPAIRED 51-09-00-0 AND DRW 5615403SDR ASOA200801370Step · brokenCREW REPORTS, BOTTOM STEP ON PAX DOOR HAS BROKEN OFF FROM DOOR LINKAGE.SDR ASAA0843668Guide Arm · wornL1 DOOR GUIDE ARM BINDING AND POPPING UPPER HINGE LOWER CAM PLATE WORN. INITIATED MIG2C 227000. REPLACED UPPER HINGE LOWER GUIDE PLATE GUIDE ARM ASSY, OPS CHECK GOOD REF MM 52 11 41 AND MM 52 11 00.SDR 2008UALA06186Spring · weakL1 DOOR GAS SPRING WEAK. REMOVED AND REPLACED GAS SPRING. OPS CHECK GOOD.SDR USAA920081908Cylinder · blownEMERGENCY EQUIPMENT - MAINT FOUND DOOR ASSIST BOTTLE BLOWN ON FWD LEFT DOOR. REMOVED AND REPLACED DOOR DAMPER CYLINDER IAW MM 52-11-14. (K)SDR ASOA200801360Door · bindingCABIN ENTRY DOOR DIFFICULT TO OPEN FROM INSIDE.SDR FDKA2008101800276Door · dirtyFRL FLT 6174 CVG. MAIN CABIN DOOR HARD TO CLOSE. MX CLEANED AND LUBED DOOR, OPS GOOD.SDR UALA2008111306177Lock Nut · misalignedDOOR 2L EMERGENCY POWER ASSIST PRESSURE RESERVOIR RED BAND ON EMERGENCY POWER SPRING CYLINDER ALIGNED IMPROPERLY. ADJUSTED CABLE TERMINAL LOCK NUT TO ACHIEVE DIMENSION.SDR 2008UALA06165Battery Pack · failedDOOR 2R EPAS BATTERY TEST FAILED. BATTERY FAILED TEST. REPLACED BATTERY PACK. OPS CHECK GOOD.SDR 2008UALA06177Lock Nut · out of adjustDOOR 2L EMERGENCY POWER ASSIST PRESSURE RESERVOIR RED BAND ON EMERGENCY POWER SPRING CYLINDER ALIGNED PROPERLY. ADJUSTED CABLE TERMINAL LOCK NUT TO ACHIEVE DIMENSION PER FIG 401 A-A OF MM 52-11-33.SDR GUUA10170801Cam · out of adjustDURING SCHEDULED ROUTINE MAINTENANCE DISCOVERED AIRSTAIR DOOR DIFFICULT TO OPEN AND CLOSE. RE-ADJUSTED AIRSTAIR DOOR CAM. OPERATIONAL CHECK NORMAL.SDR FDKA2008101700275Door · malfunctionedFRL FLT 6215 CLT. MAIN CABIN DOOR HARD TO CLOSE. MX PERFORMED AN OPS CHECK OF DOOR CLOSING AND LOCKING SYSTEM. DOOR OPS NORMAL.SDR BSY2008F00007Door · unsecureACFT ENROUTE, HAD TO LAND AT BECAUSE CABIN DOOR POPPED OPEN SECURED DOOR AND CONTINUED TO DEPARTURE. (K)SDR ASOA200801515Panel · crackedPAX DOOR TOP STEP VERTICAL PANEL CRACKED AT FWD SIDE (MARKED).SDR ASOA200801357Handle · crackedPAX DOOR FWD INNER HANDLE CRACKED AT TORQUE TUBE ATTACH POINT. REMOVED ASD INNER HANDLE PER AMM 52-11-00. DRILLED AND REAMED HANDLE IAW MM 52-11-00. INSTALLED NEW ASD INNER HANDLE IAW SRM 52-11-02. INSTALLED, REMOVED AND REPLACED BETA LIGHT IAW AMM 52-11-0SDR ASOA200801344Handle · crackedPAX DOOR INNER HANDLE HAS CRACK.SDR FDKA2008101600274Door · dirtyFRL FLT 8916 JFK. MAIN PASSENGER DOOR HARD TO OPEN AND CLOSE. MX CLEANED AND LUBED DOOR, OPS CHECKED GOOD.
Back to JASC 5210