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 QXEA200701450Door · dirtySEA FLIGHT: FA REPORTS AFT PASSENGER DOOR HARD TO OPEN AND CLOSE. MAINTENANCE CLEANED AND LUBRICATED AFT PAX DOOR. OPS CHECK GOOD. NO DEFECTS NOTED. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR 07FDEA04180Fitting · corrodedCORROSION ON FITTING AT FWD PAX DOOR LT. REPLACEMENT OF FITTING IAW SRM 51-72-10.SDR 07FDEA04179Fitting · corrodedCORROSION ON FITTING AT FWD PAX DOOR LT. REPLACEMENT OF FITTING IAW SRM 51-72-10.SDR 07FDEA04153Strut · corrodedCORROSION ON U-STRUT AT UPPER EDGE OF AFT PAX DOOR LT, BETWEEN FRAME 73A-75A. REPLACEMENT OF STRUT IAW SRM 51-72-10.SDR MASA200700612Actuator · malfunctionedASH FLT 2824 MRY TO PHX - PASSENGER DOOR DIFFICULT TO OPEN. CONTRACT MX FOUND PASSENGER DOOR ASSIST PULLEY OBSTRUCTING DOOR. REMOVED AND REPLACED ASSIST MOTOR.SDR SWIA200719012Handle · crackedFOUND AT C-CHECK, PAX DOOR INTERNAL HANDLE IS CRACKED. REPLACED INNER PAX DOOR HANDLE PER CRJ700 AMM 52-11-02-400-809-A04.
SDR A6WA200740573Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED APPROX 1 INCH AT DOOR ASSIST CABLE PULLEY IN RADIUS OF ANGLE. MAINTENANCE REPAIRED ANGLE IAW BOMBARDIER AERO SPACE REO 601R-52-11-513. (M)SDR A6WA200740574Skin · crackedPAX DOOR AFT STAIR SIDE SKIN CRACKED APPROX .70 INCH BETWEEN MID UPPER STEP AND MID STEP. MAINTENANCE CUT AWAY DAMAGED SKIN AND INSTALLED REPAIR DOUBLER AND ANGLES IAW BOMBARDIER REO 601R-52-11-702 REV A. (M)SDR KCSA071384Door · crackedR-2 DOOR FWD LOWER VERTICAL CHORD HAS A 3 INCH CRACK NEAR RADIUS AREA.SDR 07FDEA04050Skin Panel · damagedFOUND GROOVES ON OUTER SKIN PANEL, AFT LOWER CORNER AT AFT PAX DOOR LT, ZONE 833 AND ON SKIN PANEL, LOWER EDGE AREA AT AFT PAX DOOR RT, ZONE 843. REPAIR PERFORMED BY INSTALLING EXTERNAL DOUBLER AS PER SRM 52-11-00/PB 235/PAR 5F/FIG 206 ON LT PAX DOOR AND IAW SDR UPS07850895Web · damagedINSPECTION TYPE:C1 2 HOLES DRILLED THRU LOWER AFT WEB ON L-1 DOOR INTERIOR SKIN. FABRICATED AND INSTALLED REPAIR DOUBLER ON LWR AFT WEB ON L-1 DOOR INTERIOR SKIN IAW SRM 53-3-0 FIG 1 AND SRM 52-2-0 FIG 2.SDR MASA200700607Door · lack of lubeASH FLT 7275 CAE-OVERNIGHT. FLIGHT DECK DOOR STICKING DURING OPENING AND CLOSING. MX LUBED AND ADJUSTED THE DOOR, OP CHECK GOOD.SDR ABXA070338Bracket · crackedAFT ENTRY DOOR LOWER LEFT LOCK MECHANISM BRACKET CRACKED. REMOVED AND REPLACED BRACKET IAW DC9 SRM.SDR TRAX200701372Handle · crackedASD EXTERIOR HANDLE CRACKED IN TWO PLACES.SDR 07FDEA03931Beam · corrodedFOUND CORROSION ON LONGITUDINAL WEB OF BEAM 3 OF PAX DOOR NR 1 RT, BETWEEN XP=590 AND XP=715MM. REMAINING THICKNESS IS 0,5MM, AS THE NOMINAL THICKNESS IS 2,0MM. AFFECTED AREA IS ABOUT 1600MM X MM. REPAIR PERFORMED BY CUTTING CORRODED AREA. INSTALLING A MASDR FDKA200709475Seal · unsecureFDM RON RDU - LOUD SQUEAL IN FLIGHT FROM PAX DOOR. MX RESECURED THE DOOR SEAL, PRESSURIZED THE CABIN AND FOUND NO FURTHER LEAK.SDR TRAX200701366Handle · crackedMAIN PAX DOOR OUTER HANDLE CRACKED.SDR SWIA200719111Handle · crackedPAX DOOR HANDLE IS CRACKED, FOUND AT C-CHECK. REPLACED PAX DOOR HANDLE IAW CRJ200 SRM 51-41-02.
SDR 2007UALA03715Accumulator · reads lowDOOR 2R EMERGENCY CYLINDER ACCUMULATOR PRESSURE LOW.SDR QXEA200701439Skin · corrodedC5 PDX - MAIN CABIN DOOR SHELL HAS CORROSION BY FORWARD NR 1 STOP/STEP ASSEMBLY ATTACH POINT. REPAIRED IAW SRM 51-20-11, 51-20-16, 51-20-26.SDR FDKA200709470Seal · looseFDM 6155 MCO - PAX DOOR DIFFICULT TO CLOSE. MX RE-SECURED DOOR FRAME SEAL STICKING OUT. OPS GOOD.SDR F3LA200700235Blanking Plate · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION ON FWD BLANKING PLATE AT R2 DOOR. REPLACED R2 DOOR FWD GIRT BAR FITTING BLANKING PLATE IAW AMM 52-13-31-400-003.SDR F3LA200700233Blanking Plate · corrodedDURING C-3 CHECK, INSPECTION REPORTED CORROSION ON AFT BLANKING PLATE AT R2 DOOR. REPLACED R2 DOOR AFT GIRT BAR FITTING BLANKING PLATE IAW AMM 52-13-31-400-003.SDR SWIA200718687Drag Angle · crackedCRACK IN PAX DOOR AFT DRAG ANGLE. REPAIRED CRACK IN PAX DOOR AFT DRAG ANGLE IAW REO 670-52-11-0054.SDR 07FDEA03662Door Frame · damagedTOOLING IMPACTS FOUND ON DOOR FRAME 14 UNDER DOOR STOP 8 LH, PAX DOOR 1. REPAIR PERFORMED BY SMOOTH BLEND OUT, DVI INSPECTING OF FASTENER HOLES AND HFEC INSPECTION OF BLENDED AREAS FOR CRACK FREE CONDITION IAW EA 6-5312-95486 AND RAS 041687/013/2005 ISSUE A.SDR FDKA200709465Seal · inoperativeFDM 6155 MCO - PAX DOOR UPPER SEAL NOT SEALING. MX COULD NOT DUPLICATE, DOOR, OPS CHECKED AND SEALED GOOD.SDR AWXA200701130Damper · malfunctionedSAL - EES - C-04 CHECK - NR 5975045, THE L1 DOOR ASSIST DAMPER CYLINDER DOES NOT FUNCTION PROPERLY. REPLACED AND OPERATIONAL CHECKED THE L1 DOOR ASSIST DAMPER CYLINDER IAW A320 AMM 52-11-14.SDR RAIA00707013Roller · out of adjustPRE FLT NR 3574 - STL - MAIN DOOR WILL NOT OPEN. MAINTENANCE ADJUSTED DOOR ROLLER STOP. OPERATIONAL CHECK GOOD.SDR FDKA200709464Handle · looseFDM RON DAY - PAX DOOR WAS DIFFICULT TO OPEN FROM INSIDE. MX FOUND THE DOOR HANDLE WAS LOOSE AND RE-INSTALLED IT AND OPS CHECKED THE DOOR.SDR 2007F00054Spring · disconnectedTENSION SPRING ON UPPER CABIN DOOR LATCH BECAME DISCONNECTED. CAUSED THE UPPER DOOR LATCH NOT TO LATCH/SEAL, ALLOWED RAIN TO ENTER.SDR GLBA20060997Door Frame · crackedAIRSTAIR DOOR FRAME ANGLE CRACKED AT FS 150.6.AND APPROXIMATELY 3 INCHES ABOVE STRINGER 10L. CRACK APPROXIMATELY 1.3 INCHES. MAINTENANCE INSTALLED REPAIR INSERT AND REINFORCED ANGLE IAW SRM 53-90-28. ANGLE PART NR 129-420034-3. INSERT 2 INCHES, ANGLE 10 INCSDR 2007UALA03674Gate · corrodedLWR GATE CORRODED ALL THE WAY THROUGH FROM INSIDE TO OUTSIDE SURFACE. 10-05-07 REPLACED LOWER GATESDR 2007UALA03673Structure · crackedR-1 DOOR HANDLE BOX CRACKED. 10-05-07 REPLACED DOOR 1R HANDLE BOX.SDR 2007UALA03672Structure · corrodedR-2 DOOR HANDLE BOX CORRODED. 10-05-07 REPLACED DOOR 2R HANDLE BOX.SDR 07FDEA03515Beam · corrodedCORROSION ON FWD PAX DOOR 31 LT AT BEAM NR 1 OUT OF LIMIT REPAIR PERFORMED IAW SRM 52-11-00 FIG 213, APPROVED BY EA 6-5210-79568.SDR 2008FA0000342Door · departedON TAKEOFF ROLL AT VR, AFT PASSENGER DOOR DEPARTED AIRFRAME. (K)SDR SWIA200719056Intercostal · crackedPAX DOOR INTERCOSTAL IS CRACKED, FOUND AT C-CHECK. INSTALLED INTERCOSTAL PER SRM 51-42-06 AND 51-42-21.SDR 2007UALA03658Structure · crackedL1 DOOR HANDLE BOX CRACKED. 10-11-07 REMOVED AND REPLACED HANDLE BOX ASSEMBLY FOR DOOR 1L.SDR TRAX200701338Anchor Fitting · crackedPAX DOOR FWD ANCHOR FITTING IS CRACKED. REPAIRED IAW AMM 52-11-17, SRM 51-40-11, MM 52-11-17, AND MM 52-11-17. NO DEFECTS NOTED.SDR TRAX200701337Anchor Fitting · crackedPAX DOOR FORWARD COUNTER BALANCE ANCHOR FITTING IS CRACKED. 10-18-07 REMOVED FORWARD COUNTER BALANCE ANCHOR FITTING IAW CRJ 200 AMM 52-11-17. OK TO INSTALL NEW SERVICEABLE FORWARD COUNTER BALANCE ON COTTER FITTING INSTALLED NEW SERVICEABLE FORWARD COUNTESDR 07FDEA03503Frame · crackedFOUND CRACKED FRAME SEGMENT ON RT AND LT AFT PAX DOOR (ZONE 843 / 833 ). FRAME SEGMENT REPLACED IAW SRM 52-13-00 AND SRM 51-72-10.SDR 07FDEA03495Gusset · crackedFOUND CRACKED GUSSET ON FWD PAX DOOR LT (DOOR ZONE 831) AT FWD LOWER CORNER. REPAIR PERFORMED BY REPLACEMENT OF GUSSET IAW SRM 52-11-00-C1.SDR FDKA200709458Handle · damagedFDM FLT RON MCO - PAX DOOR HANDLE GRIP MISSING. MX INSTALLED GRIP HANDLE.SDR TRAX200701334Step · brokenASD LOWER STEP BROKEN.SDR QXEA200701409Skin · crackedPDX - MAIN CABIN DOOR INNER SKIN CRACKED AT FUSELAGE STATION 335 NEXT TO INTERCOSTAL DD6. MAINTENANCE REPAIRED IN ACCORDANCE WITH REO 670-52-11-277. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR 2007UALA03635Arm · misinstalledDOOR 4R EMERGENCY POWER ASSIST BOTTLE HAS TRIGGER ARM IMPROPERLY INSTALLED. 10-11-07 THIS ASSIST BOTTLE PREVIOUSLY DISCHARGED. INSTALLED NEW EMERGENCY POWER RESERVOIR FOR DOOR 4L FOUND CABLE INSTALLED PROPERLY; THE BOTTLE HAVING BEEN DISCHARGED HAD THE ASDR QXEA200701408Handle · crackedDEN - MAIN CABIN DOOR OUTER HANDLE HAS A 1/2 INCH CRACK IN THE CIRCULAR BOSS (KEYHOLE REINFORCEMENT AREA). MAINTENANCE REPLACED THE MAIN CABIN DOOR OUTER HANDLE IAW AMM 52-11-03-400-801-A01. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR RAIA00709004Cable · wornDURING SCHEDULED MAINTENANCE - RIC - MAINTENANCE FOUND THAT THE PASSENGER DOOR WOULD NOT OPEN AND CLOSE PROPERLY. MAINTENANCE FOUND THE INTERNAL CABLE FOR THE HANDLE WORN. THE CABLE WAS REMOVED AND REPLACED AND THE PASSENGER DOOR FOLDING FLAP WAS ADJUSTED. SDR C2XA07SH060Nut Plate · corrodedSHV - DURING C-CHECK MAINTENANCE FOUND 4 NUT PLATES LOCATED AT BOTTOM OF MAIN DOOR CORRODED. MAINTENANCE REPAIRED NUT PLATES AT THE BOTTOM OF THE MAIN DOOR IAW EC 5210-01152 ORIG. AIRCRAFT WAS APPROVED TO RETURN TO SERVICE.SDR 07FDEA03413Skin · misrepairedFOUND OLD EXTERNAL DOUBLER REPAIR ON RT AFT PAX DOOR LOWER AFT CORNER WITHOUT ANY DOCUMENTATION. THE REPAIR WAS NOT CONFORM TO SRM 52-10-00/FIG 203 (RIVET ROW MISSING). REPAIR PERFORMED BY INSTALLING THE MISSING FASTENER ROW (MS20426-DD5) TO THE EXISTING R
Back to JASC 5210