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 2007UALA02342Torque Tube · excess playFWD ENTERY DOOR UPPER AND LOWER LATCH TORQUE TUBES HAVE EXCESSIVE LATERAL PLAY. INSTALLED SHIMS ON UPPER AND LOWER LATCH TORQUE TUBES.SDR FDKA200706306Door · obstructedFDM 6000 JFK (0800 PHX LCL) - MAIN CABIN DOOR WILL NOT STAY LOCKED IN OPEN POSITION. MX FOUND OBSTRUCTION IN DOOR, REMOVED BOOK OPS CK GOOD.SDR MASA200700373Roller · out of alignmentASH 7195 IAD - CAPTAIN REPORTED COULD NOT OPEN MAIN PAX DOOR UPON ARRIVAL IN PIT. CLEANED AND LUBRICATED PAX DOOR ALIGNMENT ROLLERS, OPS CKD GOOD.SDR SWIA200718593Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, FOUND AT C-CHECK. INSTALLED NEW PAX DOOR AFT DRAG ANGLE PER CRJ200 SRM 51-42-10 AND 51-42-22 PG 17.SDR CA070717004Rod · failed(CAN) PASSENGER DOOR AFT SUPPORT STRUT BROKE MAKING IT DIFFICULT TO OPEN THE MAIN CABIN DOOR. EXPLANATION CODES: 7(A) SPECIAL OPS- AIRCRAFT HAD ALREADY LANDED AND PASSENGERS WERE ABOUT TO DISEMBARK. 7(B) DOOR WAS DIFFICULT TO OPEN. 7(C) DOOR WAS OPENED BY (2SDR DLM90070863Shear Tie · crackedL1 DOOR SHEAR TIE BEHIND DOOR INNER HANDLE IS CRACKED. REMOVED AND REPLACED INTERCOSTAL IAW MD-90 SRM 51-30-02, 51-10-05 AND 51-30-05.SDR CA070704006Frame · cracked(CAN) DURING VISUAL INPECTION TO COMPLY WITH AWD 2005-16-05 RT DOOR ASSY WAS FOUND CRACKED. FUTHER INPECTION OF THE TECH-TOOL DOOR AND FRAME ASSY REVEALED ADDITIONAL CRACKS. DOOR FOUND TO BE UNSERVICEABLE AND REMOVED FROM A/C. (TC NR 20070704006)SDR MASA200700371Door · jammedASH 7222 ORD. PAX DOOR WILL NOT OPEN. UNJAMMED DOOR.SDR MASA200700368Door · malfunctionedASH 2864 PHX. PAX DOOR WAS DIFFICULT TO OPEN FROM INSIDE. MX PERFORMED OPERATIONAL CHECKS OF THE DOOR AND FOUND NO FAULTS.SDR MASA200700365Handle · malfunctionedASH 7491 IAD. REPORTED HAVING TROUBLE OPENING THE PAX DOOR FROM THE CABIN AND THE GROUND. MAX LUBBEL HANDLE.SDR CA070704005Door Frame · cracked(CAN) DURING VISUAL INSPECTION TO COMPLY WITH AWD 2005-16-05 LT DOOR ASSY WAS FOUND CRACKED. FUTHER INSPECTION OF THE TECH-TOOL DOOR AND FRAME REVEALED ADDITIONAL CRACKS. DOOR FOUND TO BE U/S AND REMOVED FROM A/C. (TC NR 20070704005)SDR COMA0760455Seal · unknownFLIGHT 5638 - AIRCRAFT LOST PRESSURE, AND PAX DOOR HAS LOUD SQUEALING NOISE. DECLARED EMERGENCY, LANDED JAX WITHOUT INCIDENT. INSPECTED MAIN CABIN DOOR, NO DEFECTS. PRESSURIZED 2 AND CHECKED WITH BUBBLE SOLUTION, NO FURTHER DEFECTS.SDR MASA200700362Door · malfunctionedASH 2781 PHX. CAPT REPORTS THE MAIN CABIN DOOR IS DIFFICULT TO OPEN. MAINTENANCE INSPECTED AND FOUND NO FAULTS, DOOR OPERATED NORMALLY.SDR TRAX200700897Bracket · crackedASD FWD ANCHOR BRACKET CRACKED.SDR FDKA200706312Bushing · wornBRASS BUSHING WAS WORN 1/16" ON TRACK, CAUSING HARD TO OPEN AND CLOSE MAIN DOOR. REPLACED BUSHING.SDR FDKA200706311Rod · damagedCRANK ROD ASSY WAS FOUND TO HAVE ELONGATED HOLES AND BUSHINGS NOT PROPERLY SEALED CAUSING HARD TO OPEN AND CLOSE MAIN DOOR. REPLACED CRANK ROD ASSY.SDR A6WA200740344Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED JUST ABOVE ASSIST MOTOR PULLEY BRACKET. MAINTENANCE CUT OUT DAMAGED AREA AND INSTALLED REPAIR ANGLE IAW REO 601R-52-11-513. (K)SDR A6WA200740322Unknown · unknownPASSENGER DOOR WILL NOT OPEN. (DISCOVERED AT GATE, WHEN TRYING TO DEPLANE PASSENGERS). PERFORMED OPERATIONAL CHECK OF PASSENGER DOOR, COULD NOT DUPLICATE MALFUNCTION IAW AMM 52-11-00. (K)SDR A6WA200740352Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED APROX .7 INCH LONG IN AREA OF PULLEY BRACKET. MAINTENANCE CUT AWAY CRACKED SECTION OF DRAG ANGLE AND INSTALLED REPAIR ANGLE IAW REO 601R52-11-513, REV A. (K)SDR ASAA0741821Liner · looseL1 FWD ENTRY DOOR JAMMED ON ARRIVAL AT YVR. UNJAMMED DOOR LINING AND REMOVED FOR INSPECTION OF CONTROL RODS DOOR CAM AND DOOR JAMB LATCHING ROLLERS PER AMM 52-11-00. DOOR OPERATION CHECKED NUMEROUS TIMES AND UNABLE TO DUPLICATE. AIRCRAFT PRESSURIZATION CARRSDR 2007UALA02208Door Frame · crackedMED 2R FWD FRAME CRACKED, 3-8 INCH LONG, AT UPPER HINGE CUTOUT LWR RADIUS. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER REPAIR.SDR 2007UALA02197Door · stiffF-A REPORTS DOOR 2R IS VERY DIFFICULT TO ARM (STIFF). [07-17-07] FOUND SLIDE OUT OF PLACE IN PACK. ADJUSTED SLIDE POSITION IN PACK AND REINSTALLED SLIDE.SDR MASA200700351Support · faultyASH 7304 IAD. PAX DOOR NOT SUPPORTED BY DOOR WHEEL. REMOVED AND REPLACED SUPPORTABLE.SDR FDKA200706293Seal · unknownFDM RON RDU (0634 PHX LCL). PAX DOOR SEAL REQUIRES REPLACEMENT. MX REPLACED THE DOOR SEAL.SDR 2007UALA02172Cylinder · unreliableFOUND DOOR 1R EMERGENCY CYLINDER IN THE UNARMED POSITION AND NOT SAFETIED. ARMED EMERGENCY CYLINDER AND SAFETIED.SDR TRAX200700889Handle · brokenSTATION REPORTING THE PAX DOOR OUTER HANDLE BROKEN OFF WHILE CLOSING DOOR.SDR TRAX200700887Web · crackedPAX DOOR UPPER STEP AFT WEB IS CRACKED IN THE RADIUS OF THE CORNER UNDER THE HANDRAIL SUPPORT FITTING.SDR TRAX200700886Web · crackedPAX DOOR UPPER STEP FWD WEB IS CRACKED IN THE RADIUS OF THE CORNER, UNDER THE HANDRAIL SUPPORT FITTING.SDR TRAX200700885Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED. [07-26-07] REPAIRED IAW AMM 52-11-03, MM 52-11-25, MM 52-11-03, SRM 51-25-16, AND AMM 52-11-03SDR FDKA200706292Handle · out of adjustFDM 6061 RIC-MCO (0409 PHX LCL). MAIN CABIN DOOR DIFFICULT TO CLOSE. MX ADJUSTED DOOR HANDLE.SDR 2007UALA02170Bottle · lowDOOR 1R DOOR PRESSURE LOW. SERVICED DOOR ASSIST SYSTEM. NO REPEATS SINCE ORIGINAL..SDR 2007UALA02162Bottle · lowFOUND DOOR 1L BOTTLE AT 1500 PSI READS LOW. SERVICED DOOR ASSIST SYSTEM TO PROPER PRESSURE.SDR TRAX200700883Unknown · malfunctionedPAX DOOR WILL NOT UNLOCK.SDR TRAX200700882Door · bindingMAIN CABIN DOOR HARD TO OPEN AND CLOSE. FLTS 4094, 4467, 4801 CX AND ON 6/22/07 FLT 4813 CX. (PASSENGER DOOR POWER ASSIST SYSTEM)SDR FDKA200706289Seal · noisyFDM RON MCO (0135 PHX LCL). MAIN CABIN DOOR SQUEALING. MX REMOVED AND REPLACED MAIN CABIN DOOR SEAL.SDR 2007UALA02178Button · missingDOOR 4 RIGHT IS MISSING EPIS BUTTON. [07-20-07] NEW TYPE OF EPAS BATTERY PACK INSTALLED PER AMM 52-11-20 CONFIG 2 PG401 & TEST OK PER AMM. PUSH BUTTON SECURED. OK FOR SERVICE.SDR RAIA00706033Door · stuckPOST FLT NR 8048 - ORD - PAX DOOR WILL NOT OPEN. MAINTENANCE RIGGED PAX DOOR. OPS CHECK GOOD.SDR TRAX200700878Door · stiffPAX DOOR DIFFICULT TO OPEN, HANDLE DIFFICULT TO STOW.SDR MASA200700342Spring · faultyASH RON ORD. PAX DOOR WILL NOT CLOSE. MAINTENANCE CHANGED OUT PAX DOOR SPRINGS.SDR MASA200700340Door · bindingASH 7487 CAE. F/A REPORTS THE MAIN CABIN DOOR IS HARD TO OPEN. MAINTENANCE IS TROUBLESHOOTING.SDR SWIA200718530Drag Angle · crackedAFT DRAG ANGLE OF PAX DOOR IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS PER REO:670-52-11-072.SDR SWIA200718529Web · crackedFORWARD WEB OF PAX DOOR IS CRACKED BETWEEN 2ND AND 3RD STEPS, DISCOVERED AT C-CHECK. REPAIRED AND ASSEMBLED PARTS FOR PAX DOOR PER REO 670-52-11-104.SDR A6WA200740327Skin · crackedAFTER REMOVING PAX DOOR TOP STEP 832DT FOR ACCESS FWD PAX DOOR FWD SIDE SKIN CRACKED APPROX .750 INCH L LOWER CORNER OF NR 2 STEP IN RADIUS. MAINTENANCE CUT AWAY DAMAGE FABBED REPAIR PARTS AND INSTALLED IAW REO 601R52-11-702, STEPS 1 THRU 12. (K)SDR A6WA200740326Drag Angle · crackedPAX DOOR AFT DRAG ANGLE HAS A CRACK APPROX .5 INCH LONG AT LOWER CORNER OF NR 2 STEP. MAINT REPAIRED IAW REO 601R-52-11-702. REV A STEPS 1 THRU 12. (K)SDR A6WA200740325Drag Angle · crackedPAX DOOR AFT DRAG ANGLE HAS A CRACK APPROX 1 INCH LONG AT UPPER EDGE OF CABLE PULLEY BRACKET. [07-31-07] MAINTENANCE REPAIRED IAW REO 601R-52-11-513, STEPS 1-10. (K)SDR SWIA200718398Handle · lack of lubeFLIGHT ATTENDANT REPORTS THAT MAIN CABIN DOOR IS DIFFICULT TO OPEN. LUBRICATED INNER HANDLE SPRING ROLLER AND OVER CENTER GROOVE. OPS CHECK GOOD.SDR 2007UALA02142Hinge · crackedTHE 2R MED PASS DOOR CRACKED AT UPPER HINGE. [08-07-07] MAJOR REPAIR ACCOMPLISHED. REPAIRED 2R MED UPPER HINGE.SDR CA070619002Step · cracked(CAN) DURING AN INSP IT WAS NOTICED THAT THE STEP ON THE AIRSTAIR DOOR WAS CRACKED AT THE PIVOT STUD. THE STEP WAS REMOVED AND A SERVICEABLE STEP WAS INSTALLED. (TC NR 20070619002)SDR SWIA200718465Structure · crackedPAX DOOR INTERNAL STRUCTURE CRACKED AT FORWARD NR 4 STOP, DISCOVERED AT C-CHECK. REPAIRED INTERNAL PAX DOOR STRUCTURED STOP IAW SRM 52-10-02 FIG 203 PG 208.SDR SWIA200718460Torque Tube · corrodedPAX DOOR INTERCONNECT TORQUE TUBE INBOARD BEARING BOSS IS CORRODED, DISCOVERED AT C-CHECK. REPLACED PAX DOOR INTERCONNECT TORQUE TUBE BEARING BOSS IAW EMB 120 MM 52-11-00.
Back to JASC 5210