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 FDKA200606135Door · lack of lubeFDM 9962 MCO - THE CREW FOUND THE CABIN DOOR HARD TO CLOSE. MAINTENANCE LUBED DOOR, OPS CHECKED GOOD.SDR BSYA200600018Hook · out of adjustTOP OF CABIN DOOR POPPED OPEN IN FLIGHT, RETURNED TO AGC AIRPORT. MAINTENANCE ADJUSTED TOP DOOR HOOK, OPS CHECKS GOOD.SDR NSVA200600089Latch · out of adjustCABIN DOOR ANNUNCIATOR ILLUMINATED IN FLIGHT. ADJUSTED AIRSTAIR DOOR LATCH HANDLE SWITCH PER AMM 52-70-02. RAN AND PRESSURIZED AIRCRAFT TO MAX DIFF. CHECKED SECURITY AND CONDITION OF DOOR LATCHING MECHANISM, OPS CHECK GOOD.SDR DHL2006743009Skin · crackedL1 DOOR HINGE UPPER CUTOUT BS306 HAS 1 INCH CRACK EXTENDING FWD FROM RADIUS. TRIM-OUT DAMAGE AREA DIM. 1X 1.250 IAW SB727-53-A0198 REV 2 VERIFIED CRACK REMOVAL WITH HFEC IAW B727 NDT M PT6 51-00-00 FIG 23. FABBED DOUBLER MAT USED 301 1/2 HD .063 PO 9001442 DSDR TRAX200600405Door · malfunctionedMAIN PAX/AIRSTAIR DOOR HARD TO OPEN.SDR SWIA200617080Structure · crackedPAX DOOR CRACKED BEHIND THE FWD HANDRAIL SUPPORT, DISCOVERED DURING C-CHECK INSPECTION. REPAIR PIECES INSTALLED AT FWD HANDRAIL SUPPORT STEP COMPLIED WITH CRJ200 REO 601E 52-11-702.SDR SWIA200617079Structure · crackedPAX DOOR CRACKED BEHIND AFT HANDRAIL SUPPORT, DISCOVERED DURING C-CHECK INSPECTION. REPAIR PIECES INSTALLED AT AFT HANDRAIL SUPPORT STEP C/W CRJ 200 REO 601R-52-11-702.SDR DJFA2006268Seal · detachedWHILE PASSING THROUGH FL 320 FOR FL 360 THE CREW HEARD A LOUD HISSING NOISE COMING FROM THE CABIN ENTRY DOOR. NO CHANGE IN PRESSURIZATION WAS NOTED. OXYGEN MASKS WERE DONNED AS A PRECAUTION, AND THE AIRCRAFT WAS DIVERTED TO KTEB WHILE DESCENDING TO A LOWER ASDR SWIA200617077Handle · crackedCRACKED OUTER HANDLE, PAX DOOR, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PAX DOOR HANDLE P/N NR 601R31763-1 PER CRJ 700 AMM 52-11-03-400-801-A01.SDR SWIA200617076Bracket · crackedPAX DOOR CRACK BY HANDRAIL SUPPORT BRACKET FWD SIDE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR ANGLES AND DOUBLER IAW REO 670-52-11-104.SDR SWIA200617075Bracket · crackedPAX DOOR CRACK BY HANDRAIL SUPPORT BRACKET AFT SIDE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED 670-52-11-104-1; -2; AND -3 REPAIR DOUBLER AND ANGLES PER CRJ REO 670-52-11-104.SDR MASA200601641Handle · inoperativeASH 7407 ORD - PAX DOOR OUTER HANDLE WILL NOT TURN. MX CND. OP'S CHECK GOOD.SDR MWEA060070Door Frame · crackedMAIN CABIN DOOR FORWARD UPPER CORNER JAMB, CRACK NOTED AT FASTENER HOLE, LOCATED 3 FASTENER UP FROM FORWARD, UPPER DOOR STOP AT FIRST ROW. FABRICATED AND INSTALLED ANGLE.SDR TRAX200600399Doubler · crackedRANRC 245 CRACK ON PAX DOOR SUPPORT DOUBLER AT FS 338.9 UNDER PANEL.SDR TRAX200600393Support · crackedCRACK ON PAX DOOR SUPPORT DOUBLER AT FS 338.9 UNDER PANEL. REMOVED PAX DOOR STEPS 832AT AND 832FT, FOR ACCESS TO DOUBLER AND AFT PULL IN LEVER, IAW CRJ AMM 52-11-04 AND 52-11-23. REMOVED DOUBLER AND FABRICATED WITH S1710-4 EXTRUSION IAW CRJ SRM 52-10-14, FIGSDR SWIA200617061Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS TO PASSENGER DOOR AFT DRAG ANGLE AS PER CRJ200 REO 601R-52-11-513 REV 'A'.SDR SWIA200616863Beam · crackedPASSENGER DOOR SECOND LATERAL BEAM FORWARD SIDE CRACK IN RADIUS, DISCOVERED DURING C-CHECK INSPECTION. FABRICATED AND INSTALLED REPAIR DOUBLER USING 2024T42 MATERIAL PER 52-10-02 IC 2006-120/5068. SEE RII 52-800-1000.SDR QXEA200601708Mechanism · corrodedPDX: C3 CHECK - APPEARS TO BE CORROSION ON THE WASHERS AND EYE BOLTS OF THE LIFT AND LATCH MECHANISM OAT THE TORQUE SHAFT CRANK ASSY OF THE AFT PAX DOOR. MAINTENANCE REPAIRED IAW Q400 AMM TASK 52-12-11-400-801.SDR TRAX200600382Angle · crackedRANRC 225. PAX DOOR AFT DRAG ANGLE CRACKED.SDR TRAX200600380Door · sticksMAIN PASSENGER DOOR STICKS WHEN TRYING TO OPEN IT.SDR MASA200601619Handle · defectiveASH 7182 IAD - PAX DOOR HARD TO OPEN. MAINTENANCE REMOVED AND REPLACED MAIN DOOR INNER HANDLE ASSY.SDR TRAX200600375Mechanism · malfunctionedPAX DOOR DIFFICULT TO OPEN.SDR SWIA200617055Web · crackedCRACK ON PASSENGER DOOR FORWARD WEB BETWEEN STEPS 5 AND 6 BEHIND HANDRAIL SUPPORT, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PER REO 670-52-11-104.SDR SWIA200617054Drag Angle · crackedCRACK ON AFT DRAG ANGLE NEXT TO DOOR ASSIST PULLEY, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW DRAG ANGLE AND SPLICE ANGLES IAW REO 670-52-11-072.SDR SWIA200617053Web · crackedCRACK ON PASSENGER DOOR AFT WEB BETWEEN STEPS 5 AND 6 BEHIND HAND RAIL SUPPORT, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FABRICATED PARTS AND COMPLETED REPAIR TO PAX DOOR AFT STEPS 5 AND 6 IAW CRJ REO NR 670-52-11-104.SDR CA060803001Seal · peeling(CAN) THE PILOT WAS LONG LINING WITH THE PILOT SIDE DOORS OFF, THE WEATHER STRIPPING PEELED OFF THE DOOR FRAME. THE LAST 3 INCHES CAUGHT ON THE POCKET DOOR STOP. THE PILOT SLOWED DOWN AND LANDED TO REMOVE THE REST OF THE DOOR SEAL. THE DOOR SEAL IS 4 METERS LOSDR YENA200657Cylinder · low pressureL1 DOOR DAMPER ASSIST BOTTLE LOW PRESSURE. REMOVED AND REPLACED DOOR DAMPER/EMERG OPERATION CYLINDER IAW AMM REF 52-11-14. ALL CHECKS NORMAL PERFORMED SATISFACTORY LEAK CHECK.SDR QXEA200602223Skin · scratchedPDX: FWD AIRSTAIR DOOR EXTERIOR SKIN HAS SCRATCH ON FWD MID SECTION. MAINTENANCE REPAIRED IAW RD 8/4-53-666 AND NDTM PART 6, 51-00-01.SDR MASA200601599Stop · out of positionASH 6017 PHX - CREW REPORTED THE DOOR WOULD NOT OPEN FROM THE INSIDE. MX REPOSITIONED THE DOOR RUBBER STOPS AND LUBED THE HANDLE MECHANISM. OP'S CHECK GOOD.SDR TRAX200600432Drag Angle · crackedPAX DOOR AFT SIDE PANEL DRAG BRACE ANGLE CRACKED NEAR MOTOR CABLE PULLEY. (MARKED)SDR 06FDEA2273Doubler · damagedFUSELAGE: R4 PASSENGER DOOR FOUND EXISTING DOUBLER REPAIR ON FWD TOP CORNER OF DOOR AND FOUND DOUBLER DAMAGED. R4 PASSENGER DOOR FWD TOP CORNER OF DOOR REPAIRED AS PER SRM 52-10-00 FIG 10 VOL I. CLASSIFIED AS MAJOR REPAIR PER GMM 6-2-100.SDR TRAX200600433Swivel Fitting · damagedPAX DOOR AFT CABLE ANCHOR SWIVEL ARM HOLE ELONGATED. (MARKED) REFER TO EO700-52-34 C/W ON RIMP W/O.SDR TRAX200600365Handle · crackedPAX DOOR OUTER HANDLE CRACKED (MARKED).SDR AWXA200601017Plate · corrodedSAL - DURING BC4 CHECK DISCOVERED CORROSION IN PLATE ASSY NUT OF GIRT BAR FITTING AT FS 16 LOWER SILL OF THE L1 DOOR. MAINTENANCE REMOVED AND REPLACED THE PLATE ASSY NUT OF GIRT BAR FITTING AT FS 16, LOWER SILL OF L1 DOOR IAW AIRBUS 319 SRM 51-72-11.SDR SWAA062000Skin · crackedDURING SCHEDULED A2 CHECK, FOUND L1 DOOR SKIN CRACKED AT UPPER HINGE CUTOUT. REPAIRED SKIN PER SWA EA.SDR 06FDEA2265Door · openLEFT AFT NR 4 ENTRY PASS/CREW DOOR CAME OPEN IN FLIGHT. FOUND THAT THE LEFT AFT NR 4 PASS/CREW SERVICE DOOR -RED- EMERGENCY HANDLE WAS PULLED PRIOR TO DEPARTURE. SUSPECT HUB PERSONNEL LIFTED HANDLE TO RAISE DOOR WITH NO RESULTS, THEN RELEASED HANDLE WITH NOSDR SWIA200617048Drag Angle · crackedPASSENGER DOOR DRAG ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED ANGLE SECTION PER REO 601R-52-11-513 REV 'A'.SDR SWIA200617047Handle · crackedPASSENGER DOOR OUTER HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PASSENGER DOOR OUTER HANDLE PN 601R 31763-1 PER CRJ200 AMM 52-11-03-400-802. OPERATIONAL CHECKS GOOD.SDR SIMA200616305Skin · dentedPAX DOOR HAS DENT 16.5 INCHES FROM BOTTOM OF DOOR. REPAIRED ENT BY CUTTING OUT DAMAGED AREA AND INSTALLING AN EXTERNAL DOUBLER IAW EO EM-52MR-089. AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR UPS06447091Crank Assy · brokenCLIMBING THRU 20,000 FT HEARD & FELT THUMP L ENTRY DOOR 1 LIGHT CAME ON. DUMPED FUEL. FOUND L1 DOOR UPPER & LOWER CRANKS BROKEN ON AT SIDE OF DOOR. R/R'D CRANK ASSY, RE-RIGGED PER MM 52-11-01. DOOR OPS NORMAL.SDR SWIA200616777Door · sticksAT GATE, MAIN CABIN DOOR WOULD NOT OPEN. PERFORMED VISUAL INSPECTION OF PASSENGER DOOR WITH NO DEFECTS NOTED. OPERATIONAL CHECKS GOOD.SDR USAA060798Angle · corrodedAFT ENTRY DOOR Z-ANGLE AND DRIP PAN STA 964, LBL 53 CORROSION. REMOVED CORROSION, AND FABRICATED FILLER IAW SRM 51-40-02 LEVEL 1 C53-107-01, DEFECT SIZE: 1.25 X.75 INCH.SDR SWIA200617041Handle · crackedPASSENGER DOOR HANDLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED OUTER PAX DOOR HANDLE IAW CRJ200 AMM 52-11-03-420-003 FIG 402.SDR MASA200601552Mechanism · out of rigASH 7257 IAD - PAX DOOR WILL NOT OPEN. MX RIGGED AND LUBED. OP'S CHECK GOOD.SDR MASA200601549Door · malfunctionedASH 7257 IAD - PAX DOOR WILL NOT OPEN. MX OPENED THE PAX DOOR. OP'S CHECK GOOD.SDR COMA0660383Pressure Valve · malfunctionedFLIGHT 5063 - DURING CLIMBOUT OF GSO RECEIVED A CABIN DOOR OUTER HANDLE CAUTION MESSAGE, FLIGHT RETURNED TO THE FIELD. RE-RIGGED THE CABIN DOOR PRESSURE VALVE VENT FLAP.SDR TRAX200600344Door · unknownPASSENGER DOOR DIFFICULT TO CLOSE FROM INSIDE AIRCRAFT AND VENT DOOR DOES NOT ALWAYS SEAT.SDR MASA200601542Pin · missingASH 7310 IAD - COCKPIT DOOR EMERGENCY RELEASE PIN WAS MISSING. MX INSTALLED NEW PIN.SDR MASA200601544Cable · out of positionASH 6711 PHX - PAX DOOR OPENS TOO RAPIDLY. MX REPOSITIONED CABLE. OP'S CHECK GOOD.SDR FDKA200606114Door · malfunctionedMAIN CABIN DOOR IS HARD TO OPEN AND CLOSE. MX OP'S CHECKED THE DOOR AND FOUND NO DEFECTS.
Back to JASC 5210