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 SWIA201438881Bushing · damagedF/A REPORTS MAIN CABIN DOOR VERY DIFFICULT TO OPEN. R & R PAX DOOR FWD ANCHOR SWIVEL LEVER ASSY BUSHINGS AND AFT ANCHOR SWIVEL LEVER ASSY.SDR SWIA201438882Seal · dirtyMAIN CABIN DOOR HANDLE GETS JAMMED. CLEANED PAX DOOR SEAL. OPS CHECKED GOOD IAW AMM.SDR DBCA2014072300002Rod · shearedDURING PREFLIGHT INSPECTION CREW FOUND THE MAIN ENTRANCE DOOR SUPPORT ROD SHEARED. CREW CONTACTED MX. MX CONTACTED ILG FOR SUPPORT. ILG REPLACED SUPPORT ROD WITH NEW.SDR MASA2014072302265Diaphragm · leakingAFT PAX DOOR EMERGENCY PNUEMATIC BOTTLE LEAKING. MAINTENANCE REPLACED DIAPHRAM.SDR CALA2014072400997Door · out of sequenceL2 DOOR OUT OF SEQUENCE CAUSED INADVERTENT SLIDE DEPLOYMENT. REPLACED SLIDE ON L2 DOOR IAW MM 25-66-01-400-801. OPERATIONS CHECKED GOOD, OK TO CONTINUE. ROTABLE PARTS CHANGE WAS INDICATED TT 1620563, SN OFF 00390 SLIDE, OFF 25-2560-9-0003 0390 ON 25-2560-9-SDR ASAA2014072208650Guide · out of adjustL1 DOOR DIFFICULT TO CLOSE LAST SIX INCHES. ACFT GROUNDED. ADJUSTED CENTERING GUIDE, LATCHING FORCE WAS GOOD IAW MM 52-11-00.SDR N6WA20140722001Handle · out of adjustPAX DOOR OUTER HANDLE CAUTION MSG. ADJUSTED DOOR HANDLE IAW AMM 52-70-04. OPERATIONS CHECKED GOOD, OK FOR SERVICE.SDR GTIA2014072101386Bottle · low pressureL1 DOOR ASSIST LOW PRESSURE. RECHARGE L-1 DOOR ASSIST WITH NITROGEN IAW AMM 52-10-00-614-001-A.SDR SWIA201439025Frame · crackedPAX DOOR INTERNAL FRAME AT BAY 15 IS CRACKED. C-CHECK, R & R PAX DOOR INTERNAL FRAME ASSY IAW SRM.SDR ASOA2014080611019Skin · corrodedCORROSION AROUND NUTPLATES IN ASD INNER SKIN UNDER ACCESS PANEL 832AB. REMOVED CORROSION AROUND NUTPLATES ON ASD INNER SKIN IAW SRM 51-21-06-001-001. REMOVED CORROSION IAW SRM 51-21-06-001-001-A01.SDR MASA2014072002254Handle · stickingPAX DOOR HANDLE STICKS. MAINTENANCE LUBED DOOR & HANDLE.SDR SWIA201438828Skin · dentedFOUND A DENT AND CREASE ON PAX DOOR AFT SIDE PANEL INSIDE OF TOP STAIR TREAD. REPAIRED AFT SIDE PANEL ON PAX DOOR IAW REO.SDR N6WA20140719001Cable · brokenICE BREAKER CABLES BROKEN. R & R ICE BREAKER CABLES IAW AMM 52-11-15.SDR USAA2014072100013Bottle · low pressureDURING TAXI OUT CABIN REPORTED 2L DOOR PRESS LOW, RETURN TO GATE. SERVICED 2L DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001-A.SDR MASA2014071902249Cable · brokenPAX DOOR ICE BREAK CABLE BROKEN. DOOR WILL NOT OPEN FROM INSIDE.SDR MASA2014071902248Cable · brokenPAX DOOR ICE BREAK CABLE BROKEN. DOOR WILL NOT OPEN FROM INSIDE.SDR SWAA2014081930968Skin · crackedAFT ENTRY DOOR SKIN CRACKED AT BS 950 STRINGER 17L. REPAIRED SKIN IAW SRM.SDR SWIA201438984Striker · dentedPAX DOOR CUTOUT AFT LOWER STRIKER DENTED ON OTBD ANGLE. C-CHECK, REPAIRED STRIKER IAW REO.SDR UHLA2014071800505Rod · bentDIFFICULTY OPENING THE L1 DOOR ON ARRIVAL. TROUBLESHOT L1 DOOR. R & R BENT L1 DOOR HOIST ROD IAW AMM 52-11-20, OPS CHECK GOOD.SDR N6WA20140718001Motor · faultyPAX DOOR ASSIST MOTOR NOT OPERATING PROPERLY. DEFERRED PAX DOOR ASSIST MOTOR IAW MEL 52-11-01A CAT C.SDR UHLA2014071800503Roller · lack of lubeL1 DOOR IS HARD TO PULL OPEN. LUBED DOOR ROLLERS, PERFORMED OPS CHECK OF L1 DOOR IAW AMM 52-10-00. OPS CHECKED GOOD.SDR GTIA2014071801383Cylinder · low pressureL1 DOOR EMERGENCY CYLINDER NITROGEN LOW. CHARGED EMERGENCY CYLINDER WITH NITROGEN TO 1800 PSI IAW AMM 52-10-00.SDR SWIA201438871Angle · crackedREPAIR ANGLE ON AFT WEB OF PAX DOOR IS CRACKED. C-CHECK, FABRICATED NEW REPAIR ANGLE IAW SRM.SDR ASOA2014080611012Doubler · crackedASD PULL IN LEVER DOUBLER CRACKED INSIDE ACCESS PANEL, 832AR. R & R ASD PULL IN LEVER DOUBLER IAW SRM 51-42-06-001-001-A01 AND SRM 51-42-13-001-001-A01 AND AMM 51-42-21-001-001-A01 IAW DWG 601R318097. THIS REPAIR IS CLASSIFIED AS A MAJOR REPAIR.SDR ASOA2014080410994Intercostal · crackedASD INTERCOSTAL CRACKED INSIDE ACCESS PANEL 832BR. R & R ASD INTERCOSTAL IAW SRM 51-42-06-001-001-A01, SRM 51-42-06-13-001-001-A01 AND 51-42-21-001-001-A01 IAW DWG 601R31902. RESTORED FINISH IAW SRM 51-21-16-001-001-A01. THIS REPAIR IS CLASSIFIED AS A MAJORSDR QXEA2014072900623Angle · corrodedFWD PAX DOOR AFT ANGLE AT STA 26.7 SHOWS EVIDENCE OF CORROSION. REMOVED AND REPLACED ANGLE IAW SRM 51-42-05, SRM 51-42-05-02-01, STEP 4D (3-10), SRM 51-40-07, & SRM 51-40-15.SDR QXEA2014072900622Angle · corrodedFWD PAX DOOR FWD ANGLE AT STA X6.7 STR 25 SHOWS EVIDENCE OF CORROSION. REMOVED AND REPLACED ANGLE IAW SRM 51-42-05, SRM 51-42-05-02-01, STEP 4D (3-10), SRM 51-40-07 AND SRM 51-40-15, STEP 6 H2.SDR N6WA20170716001Motor · intermittentMAIN PAX DOOR MOTOR INTERMITTENT. PERFORMED OPERATIONS CHECK OF PAX DOOR FOR TROUBLESHOOTING IAW AMM 52-11-00, OPERATIONS CHECKED GOOD AT THIS TIME.SDR DALA2014071704141Plate · wornDURING INSPECTION, FOUND WEAR ON PLATE IN AFT PAX DOOR. REPLACED PLATE IN AFT PAX DOOR IAW SRM 51-72-11 AND DWG D52111475.SDR QXEA2014072900625Angle · corrodedFWD PAX DOOR FWD ANGLE AT STA 6.7 STRINGERS 23-25 SHOW EVIDENCE OF CORROSION. REMOVED AND REPLACED ANGLE IAW SRM 51-42-05, SRM 51-42-05-02-01, STEP 4.D(3-10) AND SRM 51-40-07.SDR QXEA2014072900624Angle · corrodedFWD PAX DOOR AFT ANGLE AT STA 26.7 STRINGERS 23-25 SHOWS EVIDENCE OF CORROSION. REMOVED AND REPLACED ANGLE IAW SRM 51-42-05, SRM 51-42-05-02-01, STEP 4.D(3-10), AND SRM 51-40-07.SDR R61A201407150926Screw · corrodedDURING HEAVY CHECK, FOUND SET SCREWS ON AFT PAX DOOR FWD AND AFT LOWER GUIDE RAMPS ARE CORRODED. MAINTENANCE R & R SET SCREWS ON AFT PAX DOOR FWD AND AFT LOWER GUIDE RAMPS IAW AMM 53-23-21, PN NAS509-5 NUT.SDR REXA2014071500718Drag Angle · crackedTASK CARD 900-52-830-300 PAX DOOR AFT DRAG ANGLE POSSIBLE CRACK. REPAIRED PAX DOOR AFT DRAG ANGLE IAW SRM 52-11-04-201-002-A01, SECTION 4 & 51-42-10-001-001-A01.SDR USAA2014071600001Control Handle · lack of lubeON ARRIVAL AGENT SAID 1L DOOR DIFFICULT TO OPEN. LUBRICATED 1L DOOR EXTERNAL CONTROL HANDLE & INTERIOR IAW AMM TASK 12-22-52-640-006-A. OPERATIONS CHECKED GOOD.SDR R61A201407140915Dampener · corrodedDURING HEAVY CHECK, L1 DOOR DAMPENER IS CORRODED. MX R & R L1 DOOR DAMPENER IAW AMM 52-11-27.SDR QXEA2014071400604Seal · detachedDITCHING DAM RUBBER SEAL IS DETATCHING. REPLACED AIRSTAIR DOOR DITCHING DAM IAW AMM TASKS 25-62-01-000-801 AND 25-62-01-400-801. OPS CHECK OF DOOR GOOD. RETURNED TO SERVICE.SDR REXA2014071800503Skin · damagedMULTIPLE NICKS & GOUGES TO THE PAX DOOR OUTER SKIN. REPAIRED IAW EA CRJ952-02748.SDR FDEA201407141772Spring · brokenL1 ENTRY DOOR SPRING FOR BUTTERFLY LATCH BROKEN. REPLACED L1 DOOR HANDLE LATCH SPRING IAW AMM 52-11-1 3-2 FOR NORMAL OPERATION.SDR MASA2014071402239Lever · unknownPAX DOOR LEVER WILL NOT OPEN DOOR EASILY. OPS CHECKED GOOD.SDR SWAA2014091732064Bracket · crackedFORWARD ENTRY DOOR SWITCH DEPRESSOR BRACKET AFT OF UPPER DOOR FRAME CRACKED. R & R BRACKET IAW SRM.SDR SWIA201438872Web · crackedPASSENGER DOOR AFT STAIRWELL WEB CRACKED UNDER MOTOR MOUNT. REPAIRED PASSENGER DOOR AFT STAIRWELL WEB IAW REO.SDR RAIA201407130001Seal · fodPASSENGER DOOR DIFFICULT TO OPEN DURING POST FLIGHT. MAINTENANCE INSPECTED AND REMOVED DEBRIS FROM MAIN CABIN DOOR SEAL AND THEN LUBRICATED SEAL, OPS CHECK GOOD.SDR ASOA2014071710891Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED NEXT TO PULLEY BRACKET. COMPLIED WITH REO 670-52-11-287, REV. C.SDR CALA2014071591472Skin · puncturedL4 DOOR INNER SKIN HAS PUNCTURE AT UPPER HINGE. CUT OUT DAMAGE MADE FILLER & DOUBLER & INSTALLED IAW ECRA 5210-02509 & REO M18051. NDT INSPECTED IAW NTM 51-00-19 PART 6 NO CRACKS FOUND, ALSO ACCOMPLISHED INSURANCE CUT OF .040.SDR N6WA20140713003Step · damagedBOTTOM STEP NOSING MISSING. DEFERRED STEP NOSING UNDER NEF 25-999-1.SDR R61A201407030869Door · out of rigCREW REPORTED THAT THE R2 DOOR SLIDE WOULD NOT DISARM. MAINTENANCE INSPECTED AND FOUND THE AFT BOTTOM CUP WAS OUT OF ADJUSTMENT. MAINTENANCE ADJUSTED AND RIGGED THE DOOR IAW AMM AND OPS CHECKED GOOD. ACFT IS GOOD FOR SERVICE.SDR SWAA2014072130112Frame · crackedL1 DOOR AFT SIDE FRAME IN INNER CHORD CRACKED. R & R CHORD IAW EA.SDR REXA2014071200714Skin · dentedTASK CARD 900-52-830-300 PAX DOOR HAS A DENT ON THE RT SIDE INNER SKIN BY THE TOP STEP. REPAIRED DENT ON PAX DOOR RT SIDE AFT IAW EACRJ952-02735 REV 1R.SDR REXA2014071200713Skin · dentedTASK CARD 900-52-830-300 PAX DOOR HAS A DENT ON THE LT SIDE INNER SKIN BY THE TOP STEP. REPAIRED DENT ON PAX DOOR LT FWD SIDE IAW EA CRJ 952-02734 REV 1R.SDR ASOA2014071610881Panel · damagedPAX DOOR AFT SIDE PANEL DAMAGED. CUT OUT DAMAGED AREA IAW EA 05-2014-002. INSTALLED REPAIR IAW EA 05-2014-002 REV F. MAJOR REPAIR IAW GMM 5-3.
Back to JASC 5210