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 USAA2014030700012Receptacle · contaminatedMX REPORTED THE L1 DOOR HOLD OPEN MECHANISM INOPERATIVE. REMOVED IMPACTED GREASE & DEBRIS FROM HOLD OPEN LOCK PLUNGER RECEPTACLE, OPERATIONS CHECKED GOOD.SDR A6WA201441257Drag Angle · crackedAFT DRAG ANGLE CRACKED ON PAX DOOR STAIR SUPPORT STRUCTURE. REPAIRED IAW REO 601R-52-11-513 REV A DATED 09 MAR 05.SDR USAA2014031000015Bushing · lack of lubeCATERING REPORTS THE AFT 4L DOOR WILL NOT CLOSE. REMOVED SUPPORT ARM LINING, LUBED GUIDE ROD & BUSHINGS. REINSTALLED LINING IAW 25-23-46-000-002A. DOOR OPERATIONS CHECKED NORMAL & OK FOR CONTINUED SERVICE.SDR USAA2014030700010Schrader Valve · leakingMX REPORTED THE L1 DOOR ASSIST BOTTLE READS LOW PRESS. REPLACED SHRADER VLV & O RING IAW AMM 52-10-00, PB601. SERVICED BOTTLE, LEAK CHECKS OK.SDR GTIA201403061202Accumulator · low pressureR1 DOOR ACCUMULATOR LOW. SERVICED R1 DOOR ASSIST BOTTLE AS REQUIRED IAW AMM.SDR SIMA20140306001Roller · lack of lubeFLIGHT ATTENDANT SAID MAIN CABIN DOOR STICKS & HARD TO OPEN. LUBRICATED ROLLERS IAW SMP, DOOR OPERATED NORMALLY.SDR UHLA2014030500199Bellcrank · out of adjustMAIN CABIN DOOR NOT ALIGNING CORRECTLY, DOOR SITTING ABOUT 1 INCH LOW. ADJUSTED L1 DOOR STOP BELLCRANK HOISTING MECHANISM IAW MM 52-11-00, OPS CHECK GOOD.SDR USAA2014030700009Bottle · low pressureMX REPORTED THE L1 DOOR ASSIST ACCUMULATOR LOW. SERVICED L1 DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001-A. OPERATIONS CHECKED GOOD AT THIS TIME.SDR SIMA20140305010Door · scratchedMAIN PAX DOOR HAS A SCRATCH THAT MEASURES 2 1/4 INCHES L X 1/8 INCH W X .005 INCHES DEEP, 5/8 INCH FROM AFT EDGE & 8 INCHES FROM THE BOTTOM. PERFORMED REPAIR OF SCRATCH ON MAIN PAX DOOR IAW ERS-EM-5200-095.SDR SWIA201436707Attach Angle · crackedPAX DOOR STEP AFT ATTACH ANGLE HAS POSSIBLE CRACK TOWARDS THE CENTER OF THE ANGLE. C-CHECK, REMOVED THE DAMAGED DRAG ANGLE SPLICE THAT WAS PREVIOUSLY FABRICATED. INSTALLED THE NEW FABRICATED DRAG ANGLE SPLICE IAW REO.SDR ASAA2014030407078Door · lack of lubeL1 DOOR HARD TO MOVE & STIFF. ACFT GROUNDED. PERFORMED GVI ON L1 DOOR, NO DEFECTS NOTED. LUBED L1 DOOR ASSY. OPEN AND CLOSING DOOR OP'S CHECKED NORMAL.SDR USAA2014030500003Cylinder · low pressureL2 DOOR ASSIST BOTTLE LOW. SERVICED L2 DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001.SDR V0XD201402240029Hinge · crackedPASSENGER DOOR LOWER STAIR PANEL HINGE ASSEMBLY CRACKED. R & R PAX DOOR LOWER STAIR PANEL HINGE ASSEMBLY PN 601R31980-65 IAW CRJ 700 AMM 52-11-04.SDR ASAA2014030307065Arm · bindingL1 DOOR DIFFICULT TO CLOSE. ACFT GROUNDED. R & R L1 DOOR GUIDE ARM IAW MM 52-11-21. RIG AND OPS CHECKED GOOD. L1 DOOR ENTRY TESTED GOOD IAW MM 52-11-00-700-804.SDR SWIA201436753Frame · crackedPAX DOOR HAS A CRACK ON FRAME. NEW FRAME INSTALLED ON PAX DOOR IAW SRM.SDR GTIA201403021195Bottle · low pressureL1 DOOR ASSIST BOTTLE REQUIRES SERVICING. L1 DOOR ASSIST BOTTLE SERVICED IAW AMM.SDR SWIA201436651Handle · lack of lubeMAIN CABIN DOOR HARD TO OPEN. FLT 5365 LUBED DOOR HANDLE & ROLLERS AS REQUIRED. OPERATIONS CHECKED GOOD ON MAIN CABIN DOOR.SDR SIMA20140301003Door · obstructedPASSENGER DOOR WOULDN’T OPEN. REMOVED DEBRIS FROM PAX DOOR MATING SURFACES. DOOR OPERATIONS CHECKED NORMAL AT THIS TIME IAW AMM.SDR C77A20140301008Fitting · gougedFWD PAX DOOR, FWD UPPER DOOR RAMP ROLLER FITTING ASSEMBLY GOUGED, D=1.79MM, L=5.19MM & W=1.5MM. BLENDED DAMAGED AREA IAW SRM 51-10-03 ON WORK ORDER 784497-818 IAW ETD 2014-170-015590 & EA E170-52-009 REV IR WORK ORDER 1409412.SDR ASOA2014032710200Arm · damagedPAX DOORS FOLLOW UP CAM ARM BASE HAS A GOUGE & WORN FROM DOOR FRAME CONTACT. COMPLIED WITH ECTC REO 670-52-11-138 AND REO 670-52-11-138, REV A. MAJOR REPAIR.SDR R61A201402280354Bolt · corrodedDURING HEAVY CHECK WAS REPORTED THAT L1 DOOR STOPS HARDWARE IS CORRODED. MX R & R L1 DOOR STOPS HARDWARE IAW AMM 52-11-23. PN PE20194-4010A, BOLT.SDR QXEA2014022800179Door · lack of lubeFA'S REPORTED MAIN CABIN DOOR IS VERY HEAVY AND DIFFICULT TO LOWER. CLEANED AND LUBED DOOR. OPS TESTED DOOR IAW AMM TASK 52-11-00-710-802, OPS GOOD WITH NOTE FOUND IN TASK PARA 3A BETWEEN STEPS (10-11). RETURNED TO SERVICE.SDR USAA2014030300018Mechanism · obstructedCANNOT ARM L1 DOOR. HANDLE SEEMS JAMMED. REMOVED DEBRIS FROM ARMING MECHANISM, OPERATIONS GOOD.SDR USAA2014030300023Damper · low pressure2L DOOR WHITE PRESS LIGHT ILLUMINATED. SERVICED DOOR DAMPER ASSIST BOTTLE IAW AMM 52-10-00-614-001-A. NO LEAKS DETECTED.SDR UHLA2014022700180Latch · contaminatedMAIN DOOR WOULD NOT OPEN PROPERLY FROM THE OUTSIDE, GATE AGENT UNABLE TO OPEN IT. CLEANED DEBRIS FROM DOOR SILL AND LATCHES. DOOR OPERATES NORMALLY FROM INSIDE AND OUTSIDE IAW AMM 52-11-00.SDR GTIA201402271190Accumulator · low pressureL2 EMERGENCY DOOR ACCUMULATOR PRESSURE LOW. SERVICED L2 DOOR EMERGENCY ACCUMULATOR TO PROPER PRESSURE IAW AMM 52-10-00.SDR USAA2014022800003Bottle · low pressureREPORTED THE AFT 4R SLIDE DOOR ASSIST PRESS LOW. SERVICED ASSIST DOOR BOTTLE FOR AFT 4R DOOR IAW 52-22-00-614-002A, OK FOR SERVICE.SDR A6WA201441214Drag Angle · crackedPASSENGER DOOR PRESS VENT AFT DRAG ANGLE CRACKED. REMOVED UNSERVICEABLE DRAG ANGLE & FABRICATED SERVICEABLE ANGLE IAW SRM 51-40-11, 51-24-21, 52-10-14 & 51-21-11.SDR SWIA201436609Angle · corrodedPAX DOOR MID CAP ANGLE CORRODED. C CHECK R & R PAX DOOR MID CAP ANGLE PN SH670-31825-7 IAW SRM.SDR QXEA2014030300167Support Angle · corrodedFWD PAX DOOR SUPPORT ANGLE AFT OF MACHINED WEB IS CORRODED. REMOVED ANGLE IAW SRM 51-42-05-02-01 AND 51-42-45-02-01. DRILLED UP NEW ANGLE IAW SRM 51-40-07-02-01. INSTALLED NEW ANGLE IAW SRM 51-42-05-02-01 AND 51-42-45-02-01. PRIMED RIVETS IAW SRM 51-42-05-0SDR DALA14013175530Structure · crackedL2 DOOR CRACKED AT FWD DOOR HINGE CUTOUTS. REMOVED L2 DOOR IAW AMDS CARD 5211-9001-2L. INSTALLED SERVICEABLE DOOR IAW AMDS CARD 5211-9001-2L. INSTALLED SLIDE IAW AMS CARD 2566-9001-2L. OK FOR SERVICE.SDR USAA2014022700003Bottle · low pressurePREPARING FOR PUSH BACK, FLIGHT ATTENDANT REPORTED AFTER ALL DOORS ARMED, CIDS PANEL INDICATED LOW DOOR PRESS ON 2L DOOR. SERVICED 2L DOOR ASSIST BOTTLE IAW AMM 25-02-49-040, OK FOR SERVICE.SDR A6WA201441255Mount Bracket · crackedPASSENGER DOOR ASSIST MOTOR LOWER MOUNT BRACKET CRACKED. R & R WITH SERVICEABLE PN 601R3117745-7 IAW CRJ200 SRM 51-40-11 & 51-42-06.SDR N6WA20140225001Cable · frayedPASSENGER DOOR POWER ASSIST CABLE FRAYED. R & R DOOR POWER ASSIST CABLE IAW CRJ700 AMM 52-11-08, OPERATIONS CHECKED GOOD AT THIS TIME.SDR DALA14012755530Cable · inadequateL2 DOOR EMERGENCY POWER ASSIST CABLE TRAVEL INSUFFICIENT. ADJUSTED L2 DOOR POWER ASSIST CABLE TRAVEL. OK FOR SERVICE.SDR USAA2014022600001Door · obstructedSLIDE BUSSEL AT DOOR 2L NEEDS ADJUSTING, DOOR DIFFICULT TO OPEN. REMOVED DEBRIS, DOOR OPERATIONS CHECKED GOOD.SDR SIMA20140225003Roller · lack of lubeMAIN CABIN DOOR HARD TO OPEN. CLEANED & LUBED MAIN CABIN DOOR ROLLER PINS IAW AMM 53-21-02, OPERATIONS CHECKED GOOD.SDR ASOA2014032810227Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACK MEASURING 8" LONG IN ZONE 3. REPAIRED PAX DOOR AFT DRAG ANGLE IAW EC/TC REO 670-52-11-072. MAJOR REPAIR.SDR QXEA2014022700178Screw · backed outAFT PASSENGER LOADING DOOR CENTER SWING ARM IS CATCHING ON THE PLASTIC TRIM PANEL UNDER IT. DOOR IS DIFFICULT AND AT TIMES IMPOSSIBLE TO OPEN. INSPECTED AND FOUND A TRIM SCREW BACKED OUT. SECURED TRIM SCREW AT BOTTOM OF DOOR HING TRIM. DOOR OPERATES NORMALSDR SWIA201436473Door Seal · dirtyMAIN CABIN DOOR IS HARD TO OPEN & CLOSE. FLT 4972 CLEANED & LUBRICATED MAIN CABIN DOOR SEAL. LUBRICATED PAX DOOR HANDLE, INNER SPRING, VERIFIED ICE DOOR CABLE, INSTALLED & SERVICEABLE. APPLIED GREASE TO SEVERAL INTERNAL PIVOT POINTS. DOOR NOW OPERATIONS CHSDR N6WA20140224002Door · noisyPASSENGER DOOR SQUEALING DURING CLIMB. PERFORMED PRESSURIZATION OF MAIN CABIN DOOR IAW CRJ700 AMM 21-31-00. NO DEFECTS NOTED, OPERATIONS & LEAK CHECKED GOOD AT THIS TIME.SDR SIMA20140224010Pin · dirtyMAIN CABIN DOOR PIN STUCK, HAD DIFFICULTY OPENING, RT PIN LOOKING FROM OUTSIDE, IN. CLEANED & LUBED AFT HANDRAIL PIN AS REQUIRED.SDR HALA2014022400028Door · out of adjustF/A UNABLE TO OPEN L1 DOOR. TRIED SEVERAL TIMES. DOOR HAD TO BE OPENED FROM OUTSIDE. PERFORMED VERTICAL ADJUSTMENT OF DOOR IAW 52-11-01. OPS & LEAK CHECKED OK. OK FOR SERVICE.SDR 2CCA2014F00082Angle · crackedFORWARD MAIN CABIN ENTRANCE DOOR UPPER FORWARD CORNER ANGLE CRACKED.SDR 2CCA2014F00081Angle · crackedFORWARD MAIN CABIN ENTRANCE DOOR UPPER FORWARD CORNER ANGLE CRACKED.SDR SWIA201436732Panel · corrodedPAX DOOR PANEL 832FL SURROUND HAS SIGNS OF CORROSION. BLENDED CORROSION IAW SRM.SDR SWIA201436545Former · corrodedFWD FORMER PN 601R318031 5 ON PAX DOOR CORRODED. C CHECK REPLACED IAW SRM & AMM.SDR N6WA20140223002Door Seal · dirtyMAIN CABIN DOOR SQUEALS AT A DIFFERENT PRESS OF 7.8 PSI, 7.8 PSI OR FL 230. CLEANED & LUBED MAIN DOOR SEAL IAW CRJ700 AMM 12-20-52. PERFORMED PRESSURIZATION CHECK IAW CRJ700 21-21-00, OPERATIONS CHECKED GOOD AT THIS TIME.SDR N6WA2014023001Cable · brokenMAIN CABIN DOOR SUPPORT WHEEL CABLE BROKEN. R & R MAIN CABLE DOOR SUPPORT WHEEL IAW CRJ700 AMM 52-11-13, OPERATIONS CHECK IAW CRJ700 AMM 52-11-00, OPERATIONS CHECKED GOOD AT THIS TIME.SDR SIMA20140223006Roller · dirtyFLIGHT ATTENDANT REPORTS MAIN CABIN DOOR IS HARD TO OPEN & IS GETTING JAMMED AT THE LT LOWER CORNER OF THE DOOR. EXERCISED & CLEANED ROLLERS & LUBED DOOR IAW AMM 52-18-00 & PERFORMED PULL TEST ON HANDLE IAW AMM 52-10-01. OPERATIONS CHECKED GOOD AT THIS TIME.
Back to JASC 5210