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 MASA200700126Door Actuator · inoperativeASH 7176 ORD - CREW REPORTED THE PAX DOOR POWER ASSIST WAS INOP. MX RESET POWER TO THE SYSTEM AND IT WORKED NORMALLY.SDR MASA200700123Door · stuckASH 7249 PIT - PAX DOOR WOULD NOT OPEN. MX TROUBLESHOOTING.SDR SWIA200717989Web · crackedPAX DOOR AFT WEB TOP STEP AND MIDSTEP RADIUS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. COMPLIED WITH REO 670-52-11-104.SDR SWIA200717988Web · crackedPAX DOORS FWD WEB 2ND & 3RD TOP STEP RADIUS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED DOUBLER PER 670-52-11-104 IN CONJUNCTION WITH DEVIATION REO 670-52-11-252.SDR TRAX200700296Door · unlockedPAX DOOR LOCK NOT LOCKING. FLT 4273 DEL 35 MINS.SDR ASAA0741502Fitting · out of adjustL1 DOOR HARD TO CLOSE AND LOCK. ADJUSTED L1 DOOR UPPER AFT CAM FITTING. OPS CHECK GOOD.SDR SWAA071137Skin · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR SKIN CRACKED AT BS 316, STR 10R. REPAIRED SKIN PER SRM.SDR MASA200700118Indicator · out of positionASH 7365 LGA - PAX DOOR CLOSED INDICATION IN STEP NOT VISIBLE WHEN DOOR CLOSED AND LOCKED. MX REPOSITIONED INDICATOR AND OP CK GOOD.SDR SWIA200718128Angle · crackedPAX DOOR AFT UPPER CORNER HAS CRACKED INTERIOR ANGLE, DISCOVERED AT C-CHECK. INSTALLED INTERIOR ANGLE P/N 601R31-8094-2 AT PAX DOOR UPPER CORNER PER CRJ200 SRM 51-42-06. RII 52-900-1001.SDR QXEA200700461Plate · wornC4 OKC - FOUND PASSENGER DOOR FORWARD UPPER GUIDE PLATE IS WORN. REPAIRED IAW SRM 52-00-16.SDR TRAX200700316Handle · crackedASD EXTERNAL HANDLE CRACKED.SDR 2007UALA00606Gate · corrodedL-2 DOOR LOWER GATE CORRODED ON OUTER LOWER FLANGE SURFACES. [SUP 05-08-07] REMOVED CORROSION AND FOUND TO BE WITHIN SRM LIMITS. ORIGINAL MATERIAL THICKNESS OF 0.140" IS NOW DOWN TO 0.136" AFTER CORROSION REMOVAL. NO COMPONENTS NEEDED TO BE REPLACED.SDR RAIA00702044Cable · out of adjustPRE FLT NR 7901 - ROA - PAX DOOR WILL NOT CLOSE. MAINTENANCE ADJUSTED DOOR CABLES FOR EXTERIOR AND INTERIOR HANDLE AND LUBED DOOR.SDR QXEA200700253Door · icedGEG FLIGHT NR 2351: FA REPORTS MCD HARD TO OPEN FROM THE INSIDE. MAINTENANCE INSPECTION FOUND ICE ACCUMULATION AROUND DOOR SEAL AND AT BASE OF MCD. THAWED AND REMOVED MOISTURE AS REQUIRED. MCD OPS CHECK GOOD INSIDE AND OUTSIDE. NO PARTS REPLACED. AIRCRAFTSDR SWIA200718051Doubler · crackedDOUBLER CRACKED INSIDE PNL832AR OF PAX DOOR, DISCOVERED DURING C-CHECK INSPECTION. INSTALL NEW PAX DOOR DOUBLER PER CRJ200 SRM 51-42-06 PG 11, 51-42-21 PG 17 AND 51-23-00 PG 21.SDR SWIA200718050Handle · crackedPAX DOOR EXTERNAL HANDLE IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. REPLACED PAX DOOR EXTERNAL HANDLE P/N 601R31763-1 IAW CRJ200 SRM 51-42-21 PG 1-21. OPERATIONAL CHECKS GOOD.SDR SWIA200718049Step · crackedFWD PAX DOOR STEPS 4/5 CRACKS FOUND IN CORNERS, DISCOVERED DURING C-CHECK INSPECTION. C/W CRJ200 REO 601R-52-11-702 REV A REPAIR FOR MULTI SITE DAMAGE ZONES 2 AND 3.SDR SWIA200718048Step · crackedAFT PAX DOOR STEPS CRACKED CORNERS 4/5, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS, PAX DOOR AFT WEB PER REO 601R-52-11-702 REV A.SDR QXEA200700254Seal · tornPDX FLIGHT NR 2352: FLIGHT WAS DIVERTED TO PDX. AIRCRAFT WOULD NOT PRESSURIZE IN AUTO OR MANUAL MODE. FA REPORTS LOUD NOISE COMING FROM MCD. MAINTENANCE FOUND MCD SEAL TORN. REPLACED MCD SEAL PER Q400 AMM 52-11-31-000-801 AND 52-11-31-400-801 AND GREEN SHESDR 070047Skin · ground damageFLIGHT 461 PIA/LAS - AFTER PASSENGER LOADING, BEFORE PUSHBACK, AN EFFORT WAS MADE TO CLOSE THE MAIN ENTRY DOOR BUT IT WAS RESTING ON THE JETWAY DECK. THE JETWAY OPERATOR RETRACTED THE JETWAY WITHOUT LOWERING IT. AS A RESULT, THE L1 DOOR SKIN SUSTAINED A .5 BSDR DA62007F00007Door · corrodedDURING ANNUAL INSP FOUND CORROSION IN THE CABIN ENTRY DOOR IN 3 LOCATIONS. FIRST LOCATION WAS AT THE MIDDLE LOCKING PIN GUIDE ANGLE PIECE. THE SECOND LOCATION IS AT THE LOWER LOCKING PIN GUIDE ANGLE PIECE AND THE THIRD LOCATION IS ON A FRAME AT THE LOWER FWDSDR SWAA071033Door Frame · crackedDURING SCHEDULED C1 CHECK, FOUND R1 DOOR FRAME CRACKED AT LOWER AFT CORNER. REMOVED AND REPLACED R1 DOOR PER MM.SDR QXEA200700212Handle · unsecureSEA FLIGHT NR 2379: FUSELAGE DOOR CAUTION LIGHT ILLUMINATED DURING CLIMB. REAR PAX DOOR WAS SHOWING OPEN/UNSECURE. AIRCRAFT RETURNED TO SEA. MAINTENANCE INSPECTED AND FOUND AFT PAX DOOR HANDLE NOT FULLY IN THE LOCKED POSITION. COMPLIED WITH OPERATIONAL TESSDR GLBA20060913Skin · delaminatedMAJOR REPAIR - UPON ROUTINE INSPECTION MAINTENANCE FOUND A DELAMINATION ON THE AIRSTAIR DOOR SKIN BELOW THE EXTERIOR DOOR HANDLE. MAINTENANCE REPAIRED AIRSTAIR DOOR SKIN IAW BEECH 1900D SRM 52-10. RII COMPLIED WITH PER TC 8.2.1.SDR TRAX200700314Drag Angle · crackedPAX DOOR AFT DRAG ANGLE, (SUSPECTED CRACK) AS PER DOUG.SDR 070044Skin · gougedFLIGHT 5184 IFP/SJC - DURING THE PRE-FLIGHT WALKAROUND A PILOT NOTICED WHAT APPEARED TO BE A GOUGE IN THE FUSELAGE ABOVE L1 MAIN PASSENGER DOOR. INVESTIGATION REVEALED SKIN DAMAGE BEGINNING APPROXIMATELY 24 INCHES ABOVE THE L1 DOOR AND CONTINUING LATERALLY ACSDR UPS07449443Skin · crackedINSPECTION TYPE:C M/D R3 DOOR SKIN FOUND CRACKED APPROX AT CTR LOWER PORTION. CRACK LENGTH .375 INCH. M/D R3 DOOR SKIN AT CTR LOWER PORTION AREA REPAIRED AS PER SRM 52-10-02 FIG 9.SDR UPS07449388Frame · crackedINSPECTION TYPE:C M/D R5 DOOR UPPER FRAME FOUND CRACKED AT SEVERAL FASTENER HOLE AREA. CRACK LENGTH .75 INCH. FRAME REPLACED AS PER SRM 51-10-01 PG 9 AND INSTALLED AS PER SRM 51-30-02.SDR UPS07449376Skin · crackedINSPECTION TYPE:C M/D L3 DOOR SKIN FOUND CRACKED APPROX AT CTR LOWER PORTION. CRACK LENGTH .75 INCH. L3 DOOR SKIN REPAIRED AS PER SRM 52-10-02 FIG 9.SDR ABXA070062Fitting · crackedAFT ENTRY DOOR CENTER BEAM RIGHT END FITTING WAS CRACKED. REMOVED AND REPLACED ANGLES IAW DC9 SRM 51-30-1.SDR UPS07449357Frame · crackedINSPECTION TYPE:C M/D R4 DOOR UPPER FWD FRAME FOUND CRACKED. CRACK LENGTH 1.25 INCH. FWD FRAME REPAIRED AS PER SRM 52-10-02 FIG 10.SDR TRAX200700233Handle · crackedPAX DOOR OUTER HANDLE APPEARS TO BE CRACKED AT INNER AFT RADIUS (MARKED) REF: 52-830-102 PG 7, FIG 52-11-02 ATTACHED. PERFORMED LPI ON PANEL DOOR OUTER HANDLE INNER RADIUS VERIFIED CRACK IS PRESENT. IAW CRJ 700 NDT MANUAL 51-20-00-08. REPAIRED PER APPLICABLESDR TRAX200700232Door · unknownPAX DOOR HARD TO OPEN.SDR DHL2007781002Skin · crackedFWD ENTRY DOOR UPPER AFT CORNER OF EXTERIOR SKIN, WORKING RIVETS, BS 314. REMOVED FASTENERS ON L1 DOOR, AFT UPPER CORNER PER B727 SRM 51-30-2, CRACK FOUND ON EXISTING DOUBLER. FABRICATED DOUBLER FROM 2024-T3, .050" X 4.5" X 3.5", PO 9004042, TREATED, PRIMED,SDR FDKA200702070Seal · tornFDM 6146 ATL (1912 PHX LCL). LOUD NOISE IN FLIGHT FROM GALLEY OR PAX DOOR. MX FOUND THE PAX DOOR SEAL WAS TORN. FERRIED TO CAE WHERE MX REPLACED THE DOOR SEAL.SDR QXEA200700377Door · lack of lubeDEN - ON FLIGHT 4340, MAIN CABIN DOOR HARD TO OPEN. MAINTENANCE INSPECTED AND FOUND INNER HANDLE DETENT ASSY DIRTY. CLEANED AND LUBED ASSY. OPERATIONAL CHECKED GOOD. NO DEFECTS OR FAULT NOTED. AIRCRAFT RETURNED TO SERVICE. NO PARTS REPLACED.SDR UPS07449402Doubler · crackedINSPECTION TYPE:C M/D - R1 DOOR SKIN ATT DOUBLER FOUND CRACKED AT LOWER LINK AREA. M/D - R1 DOOR SKIN DOUBLER REPLACED AND INSTALLED AS PER SRM 52-10-02 FIG 11.SDR AWXA200700343Skin · crackedMCN - FOUND CRACKED L1 DOOR SKIN AT THE 6TH AND 7TH STOP PIN CUT OUT FROM THE TOP, BEAM 12 AND BEAM 13. REPAIRED L1 DOOR SKIN AT THE 6TH AND 7TH STOP PIN CUT OUT FROM THE TOP, BEAM 12 AND BEAM 13 IAW ER 03-5200-07065-SS2.SDR 07FDEA00489Door · unlatchedCLIMBIMG THRU FL 220, ECAM WARN LEFT CABIN DOOR UNLATCHED. VISUAL INSPECTION SHOWED BOTH LATCH INDICATIONS FULL RED, RETURNED TO MEMPHIS. RELEASED FOR SERVICE PER MEL/CDL: 52-71-01. CATEGORY: C EXPIRATION: 24FEB07 "MEL 52-71-01: (IDENTIFY) L1 DOOR CLOSED ANSDR CA070802002Cable · frayed(CAN) ON INSPECTION IT WAS NOTICED THAT THE UPPER AND THE LOWER CABLES WERE FRAYED. THEY WERE REPLACED AND ADJUSTED. (TC NR 20070802002)SDR SWIA200717976Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS PER REO 670-52-11-072.SDR SWIA200717975Stiffener · crackedPAX DOOR AFT WEB EXTRUDED ANGLE STIFFENER CRACKED AT 2ND STEP. (DISCOVERED DURING C-CHECK INSPECTION) INSTALLED REPAIR DOUBLER AND FILLER PER CRJ700/900 SRM 51-71-59-001-001-A01.SDR SWIA200717974Handle · crackedPAX DOOR OUTER HANDLE CRACKED. (DISCOVERED DURING C-CHECK INSPECTION) INSTALLED NEW HANDLE ASSY PER CRJ700/900 AMM 52-11-03-400-801-A01.SDR SWIA200717973Step · crackedPAX DOOR FWD WEB 2ND STEP CRACKED. (DISCOVERED DURING C-CHECK INSPECTION)INSTALLED DOUBLER AND REPAIR ANGLES PER REO 670-52-11-104.SDR SWIA200717972Web · crackedPAX DOOR AFT WEB 2ND & 3RD CRACKED. (DISCOVERED DURING C-CHECK INSPECTION) INSTALLED REPAIR PARTS AS PER 670-52-11-104 REO REV B.SDR AWXA200700342Skin · crackedMCN - FOUND CRACKED L2 DOOR SKIN AT THE UPPER HINGE CUT OUT, BETWEEN BEAM 2 AND BEAM 4. REPAIRED L2 DOOR SKIN AT THE UPPER HINGE CUT OUT, BETWEEN BEAM 2 AND BEAM 4 IAW ER 03-5200-07066-ES1.SDR QXEA200700238Vent · chafedC2 OKC - FOUND PASSENGER DOOR VENT FLAP DOOR CHAFED ON INSIDE BY THE ICE BRAKE CABLE. REPAIRED IAW SRM 51-12-00, 52-35-06, 51-25-06.SDR 2007UALA00447Sill · dirtyDOOR 1R DIFFICULT TO DISARM. LEVER DOESN'T ALWAYS MOVE COMPLETELY TO DISARM POSITION. CLEANED DOOR SILL AND THE LEVER MOVEMENT WAS RESTORED. NO COMPONENT NEEDED TO BE REPLACED.SDR 2007UALA00439Door Frame · unknownR-2 DOOR FWD FRAME HINGE POINT REQUIRES PREVENTATIVE FRAME REPAIR. MAJOR REPAIR ACCOMPLISHED. FABRICATED AND INSTALLED REPAIR DOUBLER.SDR ASAA0741446Guide Arm · out of adjustFLIGHT ATTENDANT UNABLE TO CLOSE THE L1 DOOR. ADJUSTED L1 GUIDE ARM AND HORIZONTAL PUSHROD PER AMM 52-11-00 PG 501, 518.
Back to JASC 5210