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 A6WA201040623Doubler · crackedPAX DOOR AFT PULL IN CAM DOUBLER IS CRACKED. R & R PAX DOOR AFT PULL IN CAM DOUBLER AND INSTALLED DUPLICATED DOUBLER IAW SRM 51-24-16, 51-25-16, 51-40-11, 51-42-21, AAR FORM 412 FOR PART DETAILS.SDR A6WA201040618Support · crackedPAX DOOR STEP G (2ND FROM TOP) STEP SUPPORT IS CRACKED AT LOWER CORNER ON STEP FACE REPAIRED STEP SUPPORT IAW 601R-52-11-702, REV C, DATED 2010-03-09.SDR SWIA201024707Counterbalance · out of rigMAIN CABIN DOOR DIFFICULT TO OPEN. (FLT 6683) RIG PASSENGER DOOR COUNTERBALANCE.SDR SWIA201024691Door · bindingMAIN CABIN DOOR WAS DIFFICULT TO OPEN. (FLT 4761) REPOSITIONED AIRCRAFT TO LEVEL GROUND.SDR MASA2010081200872Flap · defectiveMAIN CABIN DOOR HANDLE TAB NOT FLUSH. MX R2 DOOR HANDLE FLAP.SDR USAA20100813EM036Bottle · low pressureBOS - PASSENGER DOOR 2R ASSIST BOTTLE PRESSURE IS BELOW MINIMUM PRESSURE. MAINTENANCE SERVICED THE 2R DOOR ASSIST BOTTLE TO PROPER PRESSURE PER AMM 52-11-51-03 AND 52-12-51-03.SDR USAA20100813EM035Bottle · low pressureBOS - PASSENGER DOOR 1R ASSIST BOTTLE PRESSURE IS BELOW MINIMUM PRESSURE. MAINTENANCE SERVICED THE 1R DOOR ASSIST BOTTLE TO PROPER PRESSURE PER AMM 52-11-51-03 AND 52-12-51-03.SDR CA100819006Hinge Bracket · crackedDURING INSP, IT WAS NOTICED THAT THERE WERE LOOSE/SMOKING RIVETS ON THE AFT PART OF THE CABIN DOOR AT THE HINGE LOCATION. THE HINGE WAS REMOVED AND THE DOOR WAS FOUND TO BE CRACKED ACROSS THE RIVET HOLES OF THE HINGE SUPPORT. THE CRACK STARTED AT THE AFT ENDSDR A6WA201040745Handle · crackedPAX DOOR OUTER HANDLE CRACKED. R & R WITH NEW SERVICEABLE OUTER HANDLE IAW AMM 52-11-03.SDR A6WA201040729Intercostal · crackedPAX DOOR INTERCOSTAL 601R31902-9 FWD SIDE UNDER TOP STEP IS CRACKED AND BUCKLED. R & R INTERCOSTAL IAW SRM 51-42-06 AND 51-42-21.SDR A6WA201040619Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED 601R-52-11-513 REV A DATED 09 MAR 05. REPAIRED AFTER DRAG ANGLE IAW REO.SDR SWIA201024692Motor · brokenCABIN DOOR HARD TO OPEN. (FLT 4447). REPLACED DOOR ASSIST MOTOR.SDR AALA20100811MIA01Guide Arm · wornMIA - CREW REPORTED EXTREMELY LOUD AIR LEAK AT DOOR LEFT NUMBER 1 AND AIRCRAFT WOULD NOT PRESSURIZE. EMERGENCY DECLARED, RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT NUMBER 1 DOOR GUIDE ARM. SYSTEM GROUND CHECKED NORMASDR RAIA201008110001Seal · dirtyFLIGHT CREW REPORTED THE PASSENGER DOOR AS DIFFICULT TO OPEN. MAINTENANCE INSPECTED AND CLEANED THE PASSENGER DOOR SEAL. OPS CHECKED GOOD.SDR ASOA201001094Motor · malfunctionedPAX DOOR JAMMED WILL NOT OPEN ( PASSENGER DOOR POWER ASSIST SYS ) R & R PAX DOOR ASSIST MOTOR IAW AMM 52-11-08. DEFER CLEARED. PLACARD REMOVED.SDR R61A20100395Door · damagedCREW REPORTED L-1 DOOR WAS SNAGGING WHEN OPENED. MX RESECURED L-1 DOOR IAW AMM, NO FURTHER ISSUES WERE NOTED AFTER THAT.SDR USAA20100812BB048Line · low pressureFLL - THE L1 DOOR EMERGENCY POWER RESERVOIR PRESSURE WAS FOUND BELOW LIMITS. REMOVED AND REPLACED THE EMERGENCY POWER RESERVOIR AT L1 DOOR. FOUND BOURDON TUBE IN PRESSURE GAUGE LEAKING. REPLACED PRESSURE GAUGE AND SERVICED THE UNIT.SDR USAA20100812EM033Bottle · low pressureBOS - THE L1 ENTRY DOOR ASSIST BOTTLE IS BELOW WEEKLY CHECK PRESSURE LIMITS. MAINTENANCE SERVICED THE L1 ENTRY DOOR ASSIST BOTTLE PER WEEKLY CHECK CARD AND AMM 52-11-51-03.SDR BSYA2010036Hinge Pin · out of positionON TAKEOFF OUT OF ADS THE LOWER COCKPIT DOOR HINGE PIN WORKED IT'S WAY UP AND THE DOOR CAME LOOSE FROM THE FUSELAGE, RETURNED TO ADS. MAINTENANCE REINSTALLED PIN AND SAFETY WIRED PIN, OK FOR SERVICE.SDR MASA2010081000867Handle · lack of lubePAX DOOR HANDLE STICKING. MX CLEANED AND LUBED DOOR. OPS CHECK GOOD.SDR USAA2010081191644Bottle · low pressureFLT 863 - PHL-MCO - EMERGENCY EGRESS SYSTEM - CIDS TEST INDICATE LOW BOTTLE PRESSURE LEFT SIDE FORWARD MID CABIN (DOOR L2). ADDED PRESSURE TO 1783 PSI PER AMM 52-22-00-03.SDR USAA2010081191641Cylinder · low pressureFLT 77 - PHX-SEA - EMERGENCY EGRESS SYSTEM - L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER HAS LOW PRESSURE (900 PSI & 17 DEG C). SERVICED L2 DOOR DAMPER AND EMERGENCY OPERATION CYLINDER PER AMM 52-10-11-614-001.SDR SWIA201024685Handle · lack of lubeMAIN CABIN DOOR HARD TO OPEN. (FLT 6450) LUBRICATED DOOR HANDLE.SDR MASA2010080700850Seal · missingPAX DOOR WEATHER SEAL MISSING. REMOVED AND REPLACED SEAL.SDR FDEA201008062862Crossmember · corrodedFWD DOOR NR1 RT - CROSSMEMBER NR 6 WITH CORROSION. REPAIRED IN ACCORDANCE WITH EA 6-5210-141554.SDR UALA2010080602863Cam · out of adjustDOOR 3R HANDLE MOVED OUT OF THE LOCKED POSITION ON LANDING UNCOMMANDED. EICAS R AFT DOOR. ADJUSTED UPPER AND LOWER LATCH CAMS IAW MM. INSPECTED LATCH ROLLER CRANK AND COCKING ROLLER CRANK LINKAGE. ALSO INSPECTED DOOR HANDLE MECHANISM. OPS CHECKS NORMAL.SDR VGQY2010080600062Structure · crackedMAIN DECK CARGO, MAIN ENTRANCE DOOR 1L, UPPER HINGE CUTOUT FOUND CRACK. STOP DRILL CARRIED OUT AS PER SRM 52-10-02 AND SRM 51-10-01 REVISION 117. FABRICATED REPAIR DOUBLER USING MATERIAL AMS 5518-0.050 INCH AS PER SRM 52-10-02 FIGURE 12 REVISION 117. CADMIUMSDR VGQY2010080600061Stringer · corrodedMAIN DECK CARGO, MAIN ENTRANCE DOOR 1L, UPPER HINGE CUTOUT FOUND CRACK. CORRODED STRINGER 29L TRIMMED-OFF PER SRM 53-10-03 REV 117, FIGURE 1. NEW REPAIR STRINGER AND SPLICE FABRICATED AS PER SRM 53-10-03 REV 117, FIGURE 1. NEW REPAIR STRINGER AND SPLICE INSDR SWIA201024678Unknown · malfunctionedMAIN CABIN DOOR HARD TO OPEN. (FLT 6614) OPERATIONAL CHECK OF DOOR NORMAL.SDR RAIA201008040001Seal · lack of lubeDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR DIFFICULT TO OPEN. MAINTENANCE INSPECTED AND LUBRICATED THE PASSENGER DOOR SEAL. DOOR OPS CHECKED GOOD.SDR MASA2010080400836Stop Fitting · out of adjustPAX DOOR WILL LATCH INTERMITTENT. MX ADJUSTED STOP WASHERS, OP GOOD.SDR USAA2010072091464Cylinder · low pressureFLT 1790 - CLT-TPA - EMERGENCY EGRESS SYSTEM - DOOR L1 EMERGENCY ASSIST BOTTLE PRESSURE LOW. REMOVED AND REPLACED DOOR DAMPER CYLINDER ASSEMBLY AS PER AMM 52-11-14-400-001-0. INSPECTED PER AMM 52-11-14-400-001. OPERATIONAL CHECK WAS GOOD.SDR A6WA201040597Angle · crackedPAX DOOR INNER HANDLE TORQUE TUBE MOUNT LOWER AFT ANGLE IS CRACKED. R & R ANGLE.SDR AALA20100803TUL02Beam · crackedFORWARD ENTRY DOOR NUMBER 7 BEAM AFT SIDE CRACKED. STOP DRILLED BEAM CRACK AND INSTALLED DOUBLER PER SRM 52-05-00.SDR CALA2010080700376Gate · corrodedCABIN L2 DOOR LOWER GATE BOTTOM FACE FOUND CORRODED. L2 DOOR LOWER GATE BOTTOM FACE CORROSION REMOVED OUT OF SRM 52-10-02 ALLOWABLE DAMAGE 1 FIG 101 LIMIT AND CORROSION GATE REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER AMM 52-11-38.SDR MASA2010080300830Cable · defectivePAX DOOR DIFFICULT TO UNLOCK. MX REMOVED AND REPLACED ICE CABLE, OPS CHECK GOOD.SDR R61A20100369Flap · out of adjustCREW REPORTED L-1 DOOR WAS DIFFICULT TO OPERATE. MAINTENANCE ADJUSTED THE L-1 DOOR VENT FLAP PER EMB AMM, AND NO FURTHER FAULTS WERE REPORTED. A/C THEN RETURNED TO SERVICE.SDR SWIA201024822Skin · corrodedCORROSION ON PAX DOOR INNER SKIN. (C-CHECK) REPAIRED PER SRM.SDR WRLA20100802435Doubler · crackedEXISTING REPAIR DOUBLER CRACK ON L1 DOOR UPPER FWD CORNER.SDR WRLA20100802429Doubler · crackedEXISTING REPAIR DOUBLER CRACK ON L1 DOOR UPPER FWD CORNER.SDR RAIA201008020001Bellcrank · dirtyDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR DIFFICULT TO OPEN. MAINTENANCE INSPECTED AND CLEANED AND LUBED THE DOOR BELL CRANKS. DOOR OPS CHECKED GOOD.SDR TRBA20100094Door · inoperativeMAIN DOOR WOULD NOT OPEN, (OPEN)SDR MASA2010080200826Door · dirtyPAX DOOR W/N CLOSE PAX DOOR W/N CLOSE. MX CLEANED AND LUBED.SDR RAIA201008010001Cam · out of adjustDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR HARD TO OPEN. MAINTENANCE INSPECTED AND ADJUSTED THE ECCENTRIC CAMS. DOOR OPS CHECKED GOOD.SDR CALA2010080300370Gate · corrodedCABIN R1 DOOR LOWER GATE BOTTOM FACE FOUND CORRODED. CABIN R1 DOOR LOWER GATE REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER AMM 52-11-38.SDR CALA2010080300369Gate · corrodedCABIN L1 DOOR LOWER GATE BOTTOM FACE FOUND CORRODED. L1 DOOR LOWER GATE REPLACED AS PER SRM 51-10-02 AND INSTALLED AS PER AMM 52-11-38.SDR R61A20100368Mechanism · lack of lubeCREW REPORTED L-1 DOOR VENT FLAP INOP. MAINTENANCE INSPECTED RIG OF L-1 DOOR VENT FLAP AND LUBED ALL MECHANICAL PARTS PER EMB AMM, AND REPORTED THE DOOR WAS OPERATING NORMALLY. A/C WAS THEN RETURNED TO SERVICE.SDR SWIA201024911Door Frame · crackedPAX DOOR FRAME AT FS 335.0 IS CRACKED UNDER RISER FOR NR 1 STAIR TREAD (DOOR OPEN). (C-CHECK) REPAIRED PER REO.SDR 2010FA0000904Hook · cracked(SPUY) AFT PAX DOOR- HOLD OPEN HOOKS (02EA) CRACKED 1", APPROX AT STA FS 1440.000L TO L-15L.SDR SWIA201024631Door · bindsMAIN CABIN DOOR DIFFICULT TO OPEN FROM OUTSIDE. (FLT 6029) OPERATIONAL CHECKS NORMAL.
Back to JASC 5210