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 2008FA0000344Door · departedWHILE TAXIING INTO TAKEOFF POSITION ON RUNWAY, AFT PASSENGER DOOR DEPARTED AIRFRAME. (K)SDR QXEA200701663Rod End · bentC2 PDX - MAIN CABIN DOOR AFT HANDLE RAIL ASSY UPPER STRUT ROD END BENT. ROD END WEARING ON LOWER STRUT AT ATTCH POINT. REPAIRED IAW AMM 52-11-00.SDR M7K2008F00126Handle · brokenUPON LANDING PILOT FOUND HANDLE TO BE LIMP AND FLOPPING IN THE SLIPSTREAM. DOOR HAD TO BE OPENED UTILIZING THE INSIDE HANDLE. BELLCRANK LEVER WHICH CONNECTED OUTSIDE HANDLE TO THE DOOR LATCHING MECHANISM HAD BROKEN. A NEW DOOR HANDLE ASSY WAS INSTALLED. (KSDR TRAX200701686Doubler · crackedDOUBLER INSIDE PAX DOOR AT FS 333 IS CRACKED. REMOVED CRACKED UN-SERVICEABLE DOUBLER FROM INSIDE PAX DOOR AT FS 333. LOCATED NEW SERVICEABLE DOUBLER P/N 601R318094-2 AT PAX DOOR FS 355 IAW CRJ 200 SRM 51-42-06, 51-42-10 AND 51-42-21. 14212
SDR DL738071410Door · out of rig1L DOOR NOT SEATED. UNABLE TO MAINTAIN CABIN PRESSURE. DEADHEADING CAPT INSPECTED DOOR, OBSERVED DOOR ROLLER OUT OF ENGAGEMENT WITH 1/2" TO 3/4" GAP AT TOP TO BOTTOM OF DOOR. RETURNED TO JFK. FOUND DOOR OUT OF RIG. ADJUSTED DOOR RIGGING, OPS NOW OK.SDR SWIA200718856Control Rod · bindingPAX DOOR OUTER HANDLE WILL NOT CLOSE FROM INSIDE AIRPLANE. (FLIGHT #3810) ADJUSTED PRESSURE VENT FLAP CONTROL ROD IAW 52-11-15. OPS CHECKS GOOD.
SDR SWIA200718833Handle · malfunctionedFLT 3945 - OUTER HANDLE ON PAX DOOR WILL NOT STOW. REPLACED DAMAGED BOLT IN HANDLE MECHANISM IAW CMM 52-43-03. OPS CHECK GOOD.SDR FDKA200711314Fairing · unknownFRL RON PWM (1913 PHX LCL) - MAIN CABIN DOOR WILL NOT OPEN OR CLOSE. MX REPLACED MAIN DOOR FAIRING.SDR FDKA200711313Door · lack of lubeFDM FLT 6025 ATL (1554 PHX LCL) - MAIN CABIN DOOR HARD TO OPEN AND CLOSE. MX LUBED DOOR SEAL. OPS GOOD.SDR USAA920071094Door Frame · crackedCLT - MAJOR REPAIR - C20 CHECK, CRACKED FORWARD ENTRY DOOR AFT FRAME, BS 344, WL 232. REPAIRED FORWARD ENTRY DOOR AFT FRAME, BS 344, WL 232 IAW USAIRWAYS EA 98952.SDR FDKA200711308Switch · out of adjustFRL RON MCO (1626 PHX LCL) - MAIN CABIN DOOR DIFFICULT TO OPERATE. ADJUSTED LOCK OPEN SWITCH.SDR MASA200700769Door · malfunctionedASH FLT 7483 ORD - MAIN DOOR CABIN WILL NOT OPEN FROM OUTSIDE. MX CND, OPS CHECK GOOD.SDR 2007UALA04536Fitting · gougedFWD ENTRY DOOR FWD LOWER ROLLER FITTING GOUGED. LIGHTLY BLENDED FITTING. INSTALLED HORSESHOE SHIM.SDR TRAX200701668Skin · crackedPAX DOOR SKIN STRUCTURE UNDER STEP (832DT) IS CRACKED IN THE FWD RADIUS. REPAIRED PAX DOOR SKIN STUCTURE UNDER STEP (832 DT) FWD RADIUS IAW REO 601R-52-11-702.SDR TRAX200701669Skin · crackedPAX DOOR SKIN STRUCTURE UNDER STEP (832DT) IS CRACKED IN THE AFT RADIUS. REPAIRED PAX DOOR SKIN STUCTURE UNDER STEP (832 DT) BY PERFORMING REO-601R-52-11-702.SDR TRAX200701664Handle · crackedPAX DOOR OUTER HANDLE CRACKED. REMOVED HARDWARE FROM OUTER HANDLE IAW CRJ 200 AMM 52-11-03. 14212. OK TO INSTALL NEW HANDLE. COMPLIED WITH PAX DOOR OUTER HANDLE INSTALLATION IAW CRJ AMM 52-11-03. OPS CHECK GOOD.SDR TRAX200701663Drag Angle · crackedPAX DOOR AFT DRAG ANGLE HAS A SUSPECTED CRACK (AS MARKED). PERFORMED LPI PER NDTM 51-20-08 OF SUSPECTED CRACKED AREA ON PAX DOOR AFT DRAG ANGLE (DEFECTS NOTED), FOUND REPAIRABLE PER REO 601R-52-11-513, REMOVED CRACKED SECTION IAW REO 601R-52-11-513. PERFORMEDSDR TRAX200701655Door · jammedPASSENGER DOOR HANDLE WILL NOT STOW FROM INSIDE. ALSO PASSENGER DOOR WILL NOT OPEN FROM INSIDE. DOOR IS JAMMED CLOSED. FLT 4705 DEL 38 MINS.SDR CA071102008Door · departed(CAN) UPPER DOOR ASSEMBLY DEPARTED THE AIRCRAFT WHILE IN FLIGHT, UPPER DOOR REPLACED AND DAMAGED STRUCTURE REPAIRED. THINK THE PROBLEM AROSE WITH THE FACTORY PIPER SLIDING LOCK. WE SUSPECT THAT IT WAS WORN THOUGH THERE WAS NO PRIOR INDICATION. (TC NR 200711020SDR 2007UALA04507Gate · crackedR-1 DOOR UPPER GATE CRACKED. REPLACED GATE.SDR 2007UALA04502Switch · faultyDOOR 3L EPAS POWER SUPPLY FAILS TEST. FOUND DOOR OPEN SWITCH BAD (S52125). WILL ALSO NEED SLIDE ASSY REPLACED. REPLACED DOOR OPEN SWITCH AT 3L. OP CHECKED GOOD, NO FAULTS. SLIDE ASSY REPLACED. A/C OK FOR SERVICE.SDR 2007UALA04492Door Frame · crackedNR 1 RIGHT MED UPPER FRAME CRACKED AT CENTER UPPER GATE HINGE ATTACH HOLE. REPAIRED CRACK PER IAW FRR UAL-744-0317.SDR 2007UALA04491Door Frame · crackedNR 1 LEFT MED UPPER FRAME CRACKED AT CENTER UPPER GATE HINGE ATTACH HOLE. REPAIRED CRACK PER IAW FRR UAL-744-0317.SDR 2007UALA04490Door Frame · crackedNR 5 LT MED UPPER FRAME CRACKED AT CENTER UPPER GATE HINGE ATTACH HOLE. REPAIRED CRACK PER IAW SRM 80-52-10-08-JD PG 15 & SRM 51-70-11.SDR FDKA200710300Roller · lack of lubeFDM 6005 MCO (0740 PHX LCL) - MAIN CABIN DOOR HARD TO OPEN AND CLOSE. MX ADJUSTED DOOR ROLLERS AND LUBED.SDR FDKA200710298Seal · lack of lubeFDM 6114 RDU (0451 PHX LCL) - MAIN CABIN DOOR HARD TO OPEN AND CLOSE. MX LUBED DOOR SEAL. OPS GOOD.SDR TRAX200701642Skin · corrodedON INNER SKIN OF PAX DOOR CORROSION FOUND AT MANY PLACES AROUND ANCHOR NUT. CORROSION FOUND ON PAX DOOR INNER SKIN HAS BEEN BLENDED AND FOUND WIHTIN LIMITS IAW SRM 51-21-42 AND SRM 52-11-00 FIG 301 MATERIAL THICKNESS: 0.050 MATERIAL REMOVED: 0.002. WITHIN LISDR TRAX200701643Skin · crackedON INNER SKIN OF PAX DOOR LWR FWD CRACK FOUND. REPAIRED AS PER SRM 52-11-00 FIG 414.SDR 2007UALA04493Structure · damagedL2 DOOR AT UPPER HINGE CUTOUT IS DAMAGED.SDR 2007UALA04475Door · damagedNR 1 LT & 1 RT PAX DOORS HAVE DAMAGE. REPAIRED.SDR SWIA200719184Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED, FOUND AT C-CHECK. REPLACED OUTER HANDLE ON PASSENGER DOOR PER CRJ700 AMM 52-11-03-400-801-A01.
SDR FDKA200710290Bushing · damagedFDM 6170 MCO (1000 PHX LCL) - MAIN CABIN DOOR BINDING. MX REMOVED AND REPLACED BUSHINGS ON HINGE ARM OF DOOR.SDR FDKA200710289Door · lack of lubeFDM 6075 MCO (0933 PHX LCL) - MAIN DOOR HARD TO CLOSE. MX LUBED DOOR OPS CK GOOD.SDR FDKA200710291Door · out of rigFDM 6001 MCO (1032 PHX LCL) - MAIN CABIN DOOR DIFFICULT TO CLOSE. MX RIGGED MAIN CABIN DOOR.SDR FDKA200710293Door · lack of lubeFDM 6016 JFK (1250 PHX LCL) - MAIN CABIN DOOR HARD TO OPEN. MX LUBED DOOR.SDR FDKA200710294Door · out of adjustFDM RON RDU (1832 PHX LCL) - MAIN DOOR REAL HARD TO OPEN. MX ADJUSTED DOOR, CLEANED AND LUBED LATCH POINTS AND OPS CHECKED.SDR TRAX200701636Step · corrodedON STAIR CASE OF PAX DOOR CORROSION FOUND ON STEP NR 5. REMOVED CORROSION ON STEP NR 5 ON STAIR CASE OF PAX DOOR AS PER SRM 51-21-42 REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH S.P. 663 AND FAR 43, APPENDIX A. REPAIR ACCOMPLISHED IN ACCOSDR TRAX200701634Step · corrodedON STAIR CASE OF PAX DOOR CORROSION FOUND ON STEP NR 2. REMOVED CORROSION ON STEP NR 2 ON STAIR CASE OF PAX DOOR AS PER SRM 51-21-42 REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH S.P. 663 AND FAR 43, APPENDIX A. REPAIR ACCOMPLISHED IN ACCOSDR 2007UALA04445Diaphragm · leakingDOOR ASSIST CYLINDER ON R2 DOOR HAS ZERO PRESSURE. FOUND LEAKING DOOR ASSIST CYLINDER. REPLACED DOOR ASSIST CYLINDER ON R2 DOOR.SDR FDKA200710286Door · out of rigFDM 6169 ATL (1209 PHX LCL) - MAIN CABIN DOOR WILL NOT CLOSE. MX RE-RIGGED DOOR.SDR SWAA075408Door Frame · crackedDURING SCHEDULED HC2 CHECK, FOUND R1 DOOR LOWER FRAME CRACKED AT AFT END. REMOVED AND REPLACED DOOR PER MM.SDR 2007UALA04432Structure · crackedDOOR R1 HANDLE BOX CRACKED AT CAM BASKET HOLES. INSTALLED SERVICEABLE HANDLE BOX.SDR FDKA200710282Gate · out of adjustFDM RON TPA (1533 PHX LCL) - PASSENGER DOOR FLAP WILL NOT CLOSE. MX ADJUSTED DOOR.SDR FDKA200710278Door · lack of lubeFDM 6075 MCO (0928 PHX LCL) - MAIN CABIN DOOR HARD TO OPEN AND CLOSE. MX LUBED MAIN CABIN DOOR.SDR TRAX200701604Door · faultyF/A UNABLE TO CLOSE AND LOCK MAIN ENTRY DOOR.SDR 2007UALA04436Reservoir · unreliableDOOR 4L EMERGENCY POWER RESERVOIR MISSING LIFT LIMIT AND MANUFACTURE DATE.
SDR TRAX200701597Door · out of adjustPAX DOOR HARD TO OPEN / CLOSE. PAX DOOR ADJUSTED AND FOUND SERVICEABLE IAW JIC 52-11-00.SDR 2007UALA04401Skin · crackedFWD ENTRY DOOR AFT SIDE, 6TH STOP PIN CUTOUT FROM TOP, INNER SKIN HAS CRACK. MAJOR REPAIR ACCOMPLISHED: REMOVED CRACK & ACCMP NDT FOR CRACK CONTAINMENT. FABRICATED & INSTALLED EXTERNAL DOUBLER REPAIR.SDR FDKA200710271Cam · lack of lubeFDM 6131 MCO (1254 PHX LCL) - MAIN CABIN DOOR HARD TO CLOSE. MX LUBED INTER-LIPPING CAM. OPS GOOD.SDR FDKA200710270Door · lack of lubeFDM 6125 MCO (0515 PHX LCL) - FA CAN NOT OPEN MAIN CABIN DOOR. MX LUBED DOOR OPS CK GOOD.
Back to JASC 5210