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 AWXA200701110Stop Fitting · crackedMCN - MAJOR REPAIR - C-11 CHECK - NR 5988104, CRACKED STOP FITTING, R2 DOOR, BS 726.50, RBL 78, WL 227. REPLACED STOP FITTING, R2 DOOR , BS 726.50, RBL 78, WL 227 IAW USAIRWAYS EA 120230.SDR DLM88071129Stiffener · crackedFOUND CRACKED STIFFENER AT L1 DOOR BEAM NR 8. REPLACED IAW DWG 4916056.SDR TRAX200701204Support Angle · crackedPAX DOOR IS CRACKED ON THE INNER AFT SUPPORT ANGLE 35.3 INCHES FROM LWR EDGE OF DOOR. CRACK IS APPROX 1.5 INCH LONG. REWORK DONE AS REFERENCED IN CRJ 200 SERIES SRM 51-21-11, 51-23-00, 51-42-13, & 51-42-22.SDR 2007UALA03210Torque Tube · faultyAFT ENTRY DOOR CUTOUT TORQUE TUBE HAS MOVEMENT BEYOND .003. REPLACED UPPER AND LOWER BEARING TORQUE TUBE.SDR 2007UALA03192Structure · crackedAFT ENTRY DOOR TORQUE TUBE HINGE CUTOUT UPPER FWD CORNER CRACKED. ROUTED OUT DAMAGE, WITHIN LIMITS. ACCOMPLISHED NDT INSPECTION, NO DEFECTS NOTED. ALODINE, PRIME & PAINTED.SDR SWIA200718607Handle · bindingMAIN CABIN DOOR IS DIFFICULT TO OPEN, FLIGHT NR 5469. CLEANED AND LUBED DOOR HANDLE MECHANISM AND LINKAGE IAW EMB 120 MM 52-11-00.SDR TRAX200701189Door · bindingMAIN PASSENGER DOOR IS VERY HARD TO OPEN. T-HANDLE FEELS LIKE IT POPS OUT BUT THE HANDLE CANNOT BE TURNED FROM OUTSIDE OR THE LEVER HANDLE RAISED INSIDE THE AIRCRAFT.SDR TRAX200701185Door · bindsUNABLE TO OPEN ASD. FLT 4306 CX.SDR TRAX200701182Anchor Fitting · crackedASD AFT ANCHOR FITTING CRACKED.SDR AWXA200701094Frame · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5983694, L1 DOOR AFT FRAME CRACKED, BEAM 12 - BEAM 13. REPAIRED L1 DOOR AFT FRAME, BEAM 12 - BEAM 13 IAW USAIRWAYS EA 120231.SDR AWXA200701093Skin · crackedMCN - MAJOR REPAIR - C-18 CHECK - NR 5983692, L1 DOOR INNER SKIN CRACKED, BEAM 12 - BEAM 13. REPAIRED L1 DOOR INNER SKIN, BEAM 12 - BEAM 13 IAW USAIRWAYS EA 120231.SDR ASAA0741949Snap Ring · missingL1 DOOR DIFFICULT TO OPEN. FOUND RETAINING RING FOR GUIDE ARM MISSING. REINSTALLED SNAP RING, OPS NORMAL.SDR HNAA0700193Bracket · corrodedSEVERE CORROSION FOUND ON LOWER AFT PAX DOOR BRACKET (INBOARD). LOWER AFT PAX DOOR BRACKET I/B REPLACED WITH NEW PART INSTALLED WITH BOLT IAW AMM 20-14-01.SDR SWIA200718608Roller · bindingMAIN CABIN DOOR IS VERY DIFFICULT TO OPEN, FLIGHT NR 5752. LUBED ROLLERS AS REQUIRED. OPS CHECK GOOD AT THIS TIME.SDR 2007UALA03139Power Cable · out of adjustNR 4R EMERGENCY POWER CABLE TRIGGER FAILED TEST.SDR TRAX200701160Door Frame · crackedPAX DOOR INNER FWD FRAME FS 320.10 IS CRACKED AT LOWER END. REMOVED REQUIRED FASTENERS FROM INNER SKIN & FS 338.00 FRAME IAW REO 601R-52-11-402 CUT AWAY DESIGNATED PORTION OF INNER SKIN IAW REO 601R-52-11-402. COMPLETED STEPS 1 & 2 OF RE0 601R-52-11-402. CUTLSDR TRAX200701163Beam · crackedPAX DOOR BEAM ENTRY NR 2 CRACKED. PAX DOOR ENTRY NR 2 REPLACED IAW SRM 51-25-01 AND 51-25-04. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IAW SP663 AND FAR 43 APPENDIX A. REPAIR ACCOMPLISHED IAW SRM 51-25-01 AND 51-25-04. SUPPLEMENTAL - SDR CLOSED 08/22/07.SDR TRAX200701162Intercostal · crackedPAX DOOR 2 INTERCOSTALS CRACKED FWD & AFT OF BOTTOM ROLLER. PAX DOOR 2 INTERCOSTALS REPLACED FWD AND AFT OF BOTTOM ROLLER IAW SRM 51-25-01 AND 51-25-04, FABRICATION OF 2 INTERCOSTALS COVER ON W/C 2000-158 REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IAW SP663 ASDR TRAX200701161Door Frame · crackedPAX DOOR INNER AFT FRAME FS 338.00 IS CRACKED AT LOWER END. REPAIRED IAW REO 601R-52-11-402.SDR QXEA200701281Door · out of rigSTS FLIGHT NR 2467: AFT PAX DOOR DIFFICULT TO OPEN OR CLOSE. MAINTENANCE RIGGED THE AFT PAX DOOR IAW Q400 AMM 52-12-01-400-801 AND 52-12-01-400-802. DOOR OPENS AND CLOSES NORMALLY. LEAK CHECKS GOOD. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR 2007UALA03147Lanyard · mislocatedDOOR 1R WAS HARD TO ARM. A CHORD WITH A HOOK IS ON THE GALLEY FLOOR.SDR FDKA200708379Door · lack of lubeFDM 6155 MCO (0636 PHX LCL) - PAX DOOR DIFFICULT TO CLOSE. MX LUBED DOOR, OPS CK GOOD.SDR TRAX200701155Skin · crackedTHREE CRACKS FOUND ON PAX DOOR INNER SKIN 2 UPPER AFT CORNER & 1 UPPER MIDDLE. THREE CRACKS ON PAX DOOR INNER SKIN. UPPER AFT CORNER AND UPPER MIDDLE REPAIRED IAW SRM 52-11-00 FIG 412. REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IN ACCORDANCE WITH SP 663 ANDSDR RAIA0708024Handle · out of adjustFLT 7878 - IAD - AIRSTAIR DOOR WILL NOT OPEN FROM THE INSIDE. MAINTENANCE FOUND THE MAIN DOOR INTERNAL HANDLE TO BE OUT OF ADJUSTMENT. INTERNAL HANDLE WAS ADJUSTED AND OPS CHECKED GOOD.SDR 2007UALA03127Skin · crackedFWD ENTRY DOOR CRACK ON INNER SKIN AND FRAME AFT SIDE AT SEVENTH STOP FITTING FROM TOP. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED DOUBLER/ANGLE REPAIR.SDR DXTA200702393Door · out of alignmentDURING T/O ROIL MAIN CABIN DOOR ANNUNCIATOR CAME ON, UPON INSPECTION PRIOR TO OPENING DOOR NOTICED ALLIGNMENT MARKS TO BE OUT OF ALIGNMENT APROX .1250 INCH.SDR TRAX200701145Door · bindingMAIN PASSENGER DIFFICULT TO OPEN AND TO LOCK CLOSE. INITIAL ATTEMPT TO OPEN FROM OUTSIDE WAS TOO HARD TO TURN OUTER HANDLE AND UNLOCK DOOR.SDR TRAX200701144Handle · bindingF/A REPORTS PAX DOOR DIFFICULT TO OPEN. HANDLE FEELS AS IF IT'S BINDING TOWARDS TOP OF TRAVEL LIMIT.SDR DU4R2007162Skin · gougedFOUND GOUGE IN EXT SKIN AT AFT LWR CORNER OF FWD PIT DOOR. REPAIRED BY FABRICATING AND INSTALLING REPAIR DOUBLER 12 BY 12 FROM 2024-T3 .071 IAW B757 SRM 52-30-01, 51-20-01 AND B757 AMM 51-41-00-352-013.SDR ASAA0741933Guide Arm · wornL2 DOOR HITTING LEFT TOP OF DOOR FRAME. REPLACED ENTRY DOOR GUIDE ARM.SDR USAA070615Door Frame · crackedCUTOUTS FOR THE 3RD & 4TH STOPS DOWN FROM TOP, AFT SIDE OF DOOR CRACKED. FAB'D & INSTALLED REPAIR DOUBLERS PER TR52-10-11, DEFECT SIZE: .025 INCH.SDR TRAX200701132Skin · crackedPAX DOOR FWD CORNER CRACK FOUND ON INNER SKIN. PAX DOOR BTM FWD CORNER CRACK ON INNER SKIN REPAIRED AS PER SRM 52-11-10 FIG 414SDR USAA920070800Door Frame · corrodedPIT - MAJOR REPAIR - C4 CHECK, CORROSION ON THE L1 DOOR AFT FRAME, BS 375, S11L - S12L. REPAIRED THE L1 DOOR AFT FRAME, BS 375, S11L - S12L IAW B757-200 SRM 51-70-13 AND 52-10-02.SDR FDKA200708374Roller · lack of lubeFDM 6157 MCO (0650 PHX LCL) - MAIN CABIN DOOR DIFFICULT TO CLOSE. MX LUBED THE DOOR ROLLERS. OPS GOOD.SDR TRAX200701124Drag Angle · crackedPAX DOOR AFT DRAG ANGLE AND PULLEY CRACKED.SDR QXEA200701241Seal · contaminatedBOI FLIGHT NR 2303: FA REPORTS DIFFICULTY IN OPERATING AFT PASSENGER DOOR. MAINTENANCE INSPECTED THE DOOR AND FOUND SEAL TO BE DIRTY. CLEANED SEAL OF DEBRIS. CYCLED AFT PAX DOOR SEVERAL TIMES. NO DEFECTS NOTED. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERSDR FDKA200708373Hinge · lack of lubeFDM 6003 JFK (0550 PHX LCL) - MAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. MX ADJUSTED TOP DOOR ROLLERS. LUBED DOOR HINGES. OPS GOOD.SDR FDKA200708371Roller · lack of lubeFDM 6157 MCO (1050 PHX LCL) - MAIN CABIN DOOR DIFFICULT TO CLOSE. MX RE-SECURED DOOR SEAL LOOSE AT RT CORNER AND CLEANED AND LUBED THE DOOR ROLLERS. OPS GOOD.SDR A6WA200740437Drag Angle · crackedFOUND PASSENGER DOOR AFT DRAG ANGLE IS CRACKED. (M)SDR FDKA200708369Door · lack of lubeFDM RON MCO (1730 PHX LCL) - PAX DOOR DIFFICULT TO CLOSE. MX CLEANED AND LUBED DOOR.SDR MASA200700475Roller · lack of lubeASH 2719 PHX. REPORTED HAVING TROUBLE OPENING THE PAX DOOR FROM THE GROUND. MX LUBED THE PINS AND ROLLERS.SDR USAA920070795Intercostal · crackedPIT - MAJOR REPAIR - C4 CHECK, R2 DOOR INTERCOSTAL CRACKED. REPLACED R2 DOOR INTERCOSTAL IAW B757-200 SRM 51-40-02.SDR 2007UALA03002Door · crackedFWD ENTRY DOOR HAS 2 EA HOLES WITH CRACK INDICATIONS ABOVE AND BELOW FWD END OF LOWER HINGE CUTOUT. REPAIRED.SDR 2007UALA03001Door · crackedFWD ENTRY DOOR HAS 2 EACH FASTENER HOLES WITH CRACK INDICATIONS ABOVE AND BELOW FWD END OF UPPER HINGE CUTOUT, MARKED. REPAIRED DAMAGED FASTENER HOLES ABOVE AND BELOW UPPER HINGE CUTOUT.SDR TRAX200701105Door Frame · crackedPAX DOOR FS 320.10 FRAME IS CRACKED.SDR TRAX200701104Handle · crackedPAX DOOR OUTER HANDLE CRACKED.SDR FDKA200708365Roller · lack of lubeFDM 5996 ATL (1010 PHX LCL) - MAIN CABIN DOOR WON'T SEAL CLOSED. MX LUBED DOOR ROLLERS, OPS CK GOOD.SDR SWIA200718872Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, FOUND AT C-CHECK. INSTALLED UPPER AND LOWER AFT ANGLE SPLICES PER CRJ200 SRM 51-42-06 PAGE 4.
SDR SWIA200718871Intercostal · crackedPAX DOOR INTERCOSTAL IS CRACKED, FOUND AT C-CHECK. INSTALLED NEW INTERCOSTAL IAW CRJ200 SRM 51-42-06.
SDR SWIA200718770Web · crackedPAX DOOR FORWARD AND AFT WEB IS CRACKED, FOUND AT C-CHECK. INSTALLED WEB REPAIR PARTS PER CRJ200 REO 601R-52-11-702 (REV A).
Back to JASC 5210