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 AALA20090313TUL06Beam · crackedFWD ENTRY DOOR SECOND FROM TOP HORIZONTAL BEAM CRACKED IN RADIUS AT FWD END. INSTALLED DOUBLER PER SRM 52-05-00 FIGURE 31.SDR QXEA2009030900171Seal · dirtySEA - PAX SERVICE DOOR IN THE BACK IS VERY DIFFICULT TO OPEN. CLEANED DEBRIS OFF AFT PAX DOOR SEAL. OPS CHECKED SEVERAL TIMES. DOOR OPENS WITH NO DIFFICULTY. NO OTHER DEFECTS NOTED. RETURNED TO SERVICE. NO PARTS REPLACED.SDR FDKA2009030300044Seal · looseFRL FLT 6229 IAD-CVG. MAIN CABIN DOOR SEAL SQUEAL. MX RE-SECURED SEAL AND OPS CHECKED IT GOOD.SDR USAA2009030490499Cylinder · low pressureFLT 753 - PHL - EMERGENCY EQUIPMENT - PILOT REPORTED CIDS CAUTION LIGHT ON. MAINTENANCE SERVICED MID LEFT DOOR ASSIST BOTTLE AND RESET CIDS SYSTEM.SDR CA090302003Seal · damaged(CAN) NUMEROUS ISSUES WITH WHISTLING DOOR SEAL ON THIS ACFT. ACFT INCURS HIGH CYCLES/UTILIZATION AND DOOR SEAL DAMAGE, HAS ALWAYS BEEN A PROBLEM, BUT TYPICALLY LAST 800+ HOURS. RECENTLY THE DOOR SEAL HAS BEEN COMING OUT OF THE TRACK THAT IT SITS IN. OCCASIONALSDR USAA2009031690604Housing · crackedSAL - C17 - MAJOR REPAIR - CRACK ON FORWARD ENTRY DOOR HOUSING AT BS 300, S13L. REPLACED FORWARD ENTRY DOOR HOUSING AT BS 300, S13L IAW B737 OHM 52-16-01.SDR QXEA2009030600167Seal · dirtyPDX - LEFT REAR PDX DOOR STICKS WHEN OPENING FROM THE INSIDE WHEN ONLY USING THE REAR HANDLE WHEN OPENING FROM OUTSIDE. CLEANED AND LUBED DOOR SEAL. OPS CHECK GOOD. RETURNED TO SERVICE. NO PARTS REPLACED.SDR USAA2009030390489Bottle · lowFLT 938-CLT - EMERGENCY EQUIPMENT - CIDS CAUTION LIGHT ON. MAINTENANCE SERVICED THE R3 DOOR ASSIST BOTTLE.SDR FDEA200903020787Gate · corrodedCORROSION LOCATED AT CORNER ON CABIN LEFT NUMBER FOUR PASSENGER DOOR TOP DOOR GATE. EVALUATE AND RECTIFY. LEFT NUMBER FOUR DOOR TOP DOOR GATE WAS REMOVED AND REPLACED IN ACCORDANCE WITH B757-200 AMM CHAPTER 52-11-38 REVISION 56. REPAIR CLASSIFIED AS MINORSDR SWIA200921912Handle · crackedPASSENGER DOOR HANDLE CRACKED. (C CHECK) REPLACED HANDLE PER SB AND AMM.SDR QXEA2009030500165Latch · crackedLAP - MAIN CABIN DOOR INOP. PERFORMED DVI OF INTERNAL PAX DOOR STRUCTURE AND COMPONENTS FOUND LATCH BOX ASSY TO BE CRACKED AT FWD ATTACH POINT OF UPPER ACTUATING LEVER FOR VENT DOOR. REMOVED AND REPLACED LATCH BOX ASSY IAW AMM 52-11-02-000-815, 52-11-02-400-SDR RAIA2009032600006Roller · lack of lubePOST FLT 8024 - IAD - MAIN CABIN DOOR DIFFICULT TO OPEN. MAINTENANCE CLEANED AND LUBED THE PAX DOOR ASSEMBLY. OPS CHECKED GOOD.SDR SWIA200921118Handle · dirtyFLT 6024 - UNABLE TO OPEN MAIN CABIN DOOR UPON ARRIVAL TO THE AIRCRAFT. CLEANED AND LUBRICATED PAX DOOR OUTER HANDLE.SDR QXEA2009030400162Gate · malfunctionedRNO - AFT REAR PASSENGER DOOR OUTSIDE FLAPPER PUSH DOOR IS NOT FLUSH WITH DOOR, OCCASIONALLY PREVENTING THE DOOR FROM OPENING FROM THE INSIDE. AIRCRAFT FERRIED TO PDX FOR REPAIRS. REMOVED AND REPLACED EXTERNAL AFT COVER FLAP AND SPRING ON L2 CABIN DOOR HANDLSDR ASOA200900259Handle · crackedASD HANDLE IS CRACKED.SDR ASOA200900257Door · malfunctionedPAX DOOR WON'T CLOSE.SDR USAA2009030290474Cylinder · lowFLT 350 - PHX-LAS - EE - L1 DOOR ASSIST LOW PRESSURE. SERVICED L1 DOOR ASSIST TO PROPER PRESSURE.SDR MASA2009022800081Seal · looseASH FLT 1154 HNL-LIH. CREW RETURNED TO THE FIELD DUE TO A LOUD SQUEAL FROM THE PASSENGER DOOR AND THE PRESSURIZATION WAS UNCONTROLLABLE. MX RE-SECURED SEAL AND PERFORMED PRESSURE CHECK, CHECK GOOD.SDR ASOA200900312Skin · crackedPAX DOOR AFT SKIN IS CRACKED AT HANDRAIL STOW RECEPTACLE.SDR SWAA091359Skin · crackedDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR SKIN CRACKED AT LOWER AFT CORNER OR DOOR HINGE CUTOUT. REMOVED AND REPLACED DOOR PER MM.SDR ASOA200900254Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED APPROX 1.5 INCH LONG AT PAX DOOR CABLE ASSIST PULLEY IN THE RADIUS OF THE ANGLE. COMPLIED WITH REPAIR TO PAX DOOR AFT DRAG ANGLE REF REO 601R-52-11-513, REV A FOR WORK PERFORMED.SDR USAA2009030290473Handle · brokenFLT 772 - PLS-CLT - EMERGENCY EQUIPMENT - 2R DOOR EMERGENCY ASSIST HANDLE BROKEN. MAINTENANCE REMOVED AND REPLACED HANDLE.SDR USAA2009030290471Cylinder · lowFLT 171 - MEX-PHX - EE - R-2 DOOR ASSIST BOTTLE LOW PRESSURE. SERVICED R-2 DOOR ASSIST BOTTLE TO 1850 PSI.SDR USAA2009030290470Cylinder · lowFLT 171 - MEX-PHX - EE - L-2 DOOR ASSIST BOTTLE LOW PRESSURE. SERVICED L-2 DOOR ASSIST BOTTLE TO 1800 PSI.SDR AALA20090317TUL18Beam · crackedFORWARD ENTRY DOOR NR 7 BEAM CRACKED IN RADIUS AT AFT END. STOP DRILLED END OF CRACK AND INSTALLED REPAIR DOUBLER PER ESO 80172 AND SRM 52-50-00, FIGURE 31.SDR SWIA200921131Handle · stuckFLT 4434 - PASSENGER DOOR OUTER HANDLE WILL NOT UNLOCK DOOR. CLEANED, LUBED, AND ADJUSTED ROLLER ASSY OF THE INNER HANDLE. RETENSIONED MECHANISM.SDR ASAA0954588Seal · dislodgedON DEPARTURE MZT - FLIGHT ATTENDANTS REPORT L1 DOOR WILL NOT SEAL AND NOISE WAS UNBEARABLE. ATTEMPTED TO SEAL DOOR MANUALLY, UNABLE. CLIMBED TO FL 260 DOOR WOULD NOT SEAL NOISE DID NOT ALLOW F/A'S TO HEAR INTERPHONE. PRESSURE APPEARED NORMAL AT ALL TIMES. SDR AALA2009022500230Web · scratchedSCRATCHES BELOW HANDLE ON INNER WEB OF FORWARD ENTRY DOOR. CUT OUT DAMAGE AREA OF ONE INCH BY ONE INCH AND INSTALLED DOUBLER PER SRM 51-70-13-2R.SDR A6WA200940150Mount · crackedPAX DOOR POWER ASSIST MOTOR STIFFENER MOUNT CRACKED. PAX DOOR POWER ASSIST MOTOR STIFFENER MOUNT REPLACED IAW SRM 51-42-06. (K)SDR UALA2009031000652Lanyard · out of positionDOOR 3L WILL NOT ARM. REPOSITIONED MOORING LANYARD & OPS CHECKED GIRT BAR OPERATION.SDR A6WA200940090Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED PAX DOOR AFT DRAG ANGLE REPAIRED IAW REO 601R-52-11-513, REV A. (K)SDR ASOA200900255Doubler · crackedASD DOUBLER ON AFT SIDE OF FRAME 5 AT PULL IN LEVER TORQUE TUBE IS CRACKED. REMOVED DOUBLER PER SRM 51-42-06. LOCATED, DRILLED AND INSTALLED NEW DOUBLER PER SRM 51-42-06. REINSTALLED AFT 1/2 OF PULL IN LEVER TORQUE TUBE PER AMM 52-11-00.SDR ASAA0944587Door · out of adjustFORWARD ENTRY DOOR (L1) WILL NOT CLOSE. ADJUSTED FWD ENTRY DOOR PER MM 52 11 00 705 007. NON ASA EMP 442702827.SDR QXEA2009030200156Shear Tie · crackedPDX - CRACK DAMAGE TO THE UPPER SKIN EDGE BRACKETS, ON THE AFT PAX ENTRY DOOR. C/W REPAIR FOR CRACK DAMAGE TO THE UPPER SKIN EDGE BRACKETS ON THE PAX ENTRY DOOR IAW RD8/4-53-2645. RETURNED TO SERVICE.SDR UALA2009022500652Lanyard · out of positionDOOR 3L WILL NOT ARM. REPOSITIONED MOORING LANYARD & OPS CK'D GIRT BAR OPERATION.SDR ASOA200900247Handle · crackedASD OUTER HANDLE CRACKED.SDR USAA2009022690441Cylinder · low pressureFLT 614 ATL - EMERGENCY EQUIPMENT - L-1 DOOR ASSIST BOTTLE LOW PRESSURE. MAINTENANCE SERVICED L-1 DOOR ASSIST BOTTLE PER AIRBUS MAINTENANCE MANUAL 52-10-00-614-051.SDR USAA2009022690440Cylinder · low pressureFLT 731 PHL-LAS - EMERGENCY EQUIPMENT - CIDS CAUTION LIGHT ON FORWARD FLIGHT ATTENDANT PANEL - RESET CIRCUIT BREAKERS WITH NO CHANGE. MAINTENANCE SERVICED R2 EMERGENCY DOOR ASSIST BOTTLE PER AIRBUS MAINTENANCE MANUAL 52-22-00-614-002.SDR ASAA0944657Doubler · crackedR1 DOOR AFT LOWER CORNER INNER DOUBLER CRACKED. REMOVED DOUBLER, FABRICATED AND INSTALLED NEW DOUBLER IAW B737 400 SRM 51 40 02.SDR SWIA200921090Door · stiffFLT 2711 - MAIN ENTRY DOOR DIFFICULT TO OPEN. OP CHECKS NORMAL.SDR SWIA200921078Door · stuckFLT 5995 - MAIN PASSENGER DOOR DIFFICULT TO OPEN BOTH FROM INSIDE AND OUTSIDE. OPERATED CABIN DOOR. OPS CHECK GOOD.SDR RAIA2009022600001Door · dirtyFLT 7987 - RIC - PASSENGER DOOR DIFFICULT TO OPEN FROM THE INSIDE. MAINTENANCE CLEANED AND LUBED THE PASSENGER DOOR. OPS CHECKED GOOD.SDR IPXA09M54834Track · gougedL1 DOOR ROLLER TRACKS GOUGED. REF EO MD11-5340-32465A L1 DOOR FWD & AFT TRACK REPAIRED. ACCOMPLISH REPETITIVE INSPECTIONS EVERY 450 HOURS. PERMANENT REPAIR BY OCT 2010.SDR ASOA200900239Step · crackedASD BOTTOM STEP CRACKED AND ROD END BENT.SDR USAA2009022490426Cylinder · low pressureFLT 1500 - PHL - EMERGENCY EQUIPMENT - LOW INDICATION ON R1 DOOR. MAINTENANCE SERVICED THE R1 DOOR ASSIST BOTTLE TO PROPER PRESSURE.SDR USAA2009022490425Cylinder · low pressureFLT 255 - LAS - EMERGENCY EQUIPMENT - R2 DOOR ASSIST BOTTLE LOW PRESSURE (700 PSI). MAINTENANCE SERVICED R2 DOOR ASSIST BOTTLE PER AIRBUS MAINTENANCE MANUAL.SDR USAA2009022390402Cylinder · low pressureFLT 752 - SEA - PHL - EMERGENCY EQUIPMENT - L1 DOOR EMERGENCY CYLINDER ACCUMULATOR PRESSURE LOW. MAINTENANCE SERVICED L1 DOOR EMERGENCY CYLINDER ACCUMULATOR TO PROPER PRESSURE PER AIRBUS MAINTENANCE MANUAL 52-10-00.SDR ASOA200900229Drag Angle · crackedASD AFT DRAG ANGLE CRACKED AT THE MOTOR PULLEY.SDR FDEA200902210622Gate · corrodedRT NR 4 PAX DOOR LOWER GATE HAS INTERGRANULAR CORROSION. RT NR 4 PAX DOOR LOWER GATE CORROSION FOUND EXCEEDED ALLOWABLE DAMAGE LIMITS IN SRM 52-10-02 REV 95. LOWER GATE REPLACED IAW AMM 52-11-38. REPAIR IS CLASSIFIED AS MINOR PER GMM 6-2-100 CRITERIA.SDR FDEA200902210621Gate · corrodedRT NR 4 PAX DOOR UPPER CORNER (INTERNAL) HAS CORROSION. RT NR 4 DOOR UPPER GATE CORROSION FOUND BEYOND ALLOWABLE DAMAGE LIMITS IN SRM 52-10-02 REV 95. DOOR TOP GATE REPLACED IAW AMM 52-11-38 REV 56. REPAIR IS CLASSIFIED AS MINOR PER GMM 6-2-100 CRITERIA.
Back to JASC 5210