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 2007UALA00091Mechanism · misriggedDOOR 1R BOTTLE MECHANISM ASSEMBLED IMPROPERLY AND WILL NOT ACCEPT SAFETY PIN. FOUND LOWER CLAMP UP WASHER DISLODGED AND NOT CAPTURED BY LINK ATTACH BOLT, BLOCKING SAFETY PIN HOLE. DISASSEMBLED LINK ATTACH POINT AND REASSEMBLED.SDR C2XA07CL005Seal · faultyCLE FLIGHT 2451 THE CREW REPORTED UPON ARRIVAL IN MKE THE F/A WAS UNABLE TO OPEN THE MAIN CABIN DOOR. MAINTENANCE INSPECTED AND REPLACED THE MAIN CABIN DOOR SEAL. OPERATIONAL CHECKS WERE GOOD. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR COMA0760023Pushrod · brokenFLIGHT 4979 - CABIN WOULD NOT PRESSURIZE DURING CLIMB. STOPPED CLIMB AT 10,000 FT RECEIVED EXHAUST STATUS MESSAGE AND DISPLAY COOL CAUTION MESSAGE. FOLLOWED QRH, DIVERTED TO BUF AND LANDED WITHOUT INCIDENT. FERRIED TO JFK, REPLACED PAX DOOR FLAPPER DOOR RODSDR UPS07449008Beam · crackedINSPECTION TYPE:C LT MED NR 4 FWD VERTICAL BEAM INTERIOR LOWER CORNER FOUND CRACKED. LT MED NR 4 FWD VERTICAL BEAM LOWER CORNER AREA REPAIRED AS PER SRM 52-10-02 FIG 10.SDR TRAX200700064Handle · crackedPAX DOOR OUTER HANDLE CRACKED (MARKED) REMOVED RODS AND LOCKING DIVCE. REMOVED PAX DOOR OUTER HANDLE. DRILLED UP NEW PAX DOOR OUTER HANDLE AND INSTALLED IAW CRJ 700 AMM 52-11-03 PAGES 401-403. REINSTALLED LOCKING DIVICE , RODS, AND UPPER STEP IAW CRJ 700 ASDR ASAA0711380Arm · out of adjustL1 DOOR HARD TO CLOSE. ADJUSTED STOPS AND GUIDE ARM, OPS CHECK GOOD.SDR ASAA0781386Skin · damagedL1 DOOR SKIN AT UPPER CORNER PEELED BACK. REMOVED DAMAGED SECTION OF SKIN. INSTALLED REPAIR DOUBLER AND FILLER PER SRM 52 05. PERFORMED CLASS III REPAIR PER SRM 53 04.SDR TRAX200700063Door · stuckPAX DOOR WILL NOT CLOSE, FLT 4836 DEL 120 MINS.SDR DL757070026Intercostal · crackedINTERCOSTAL FOUND CRACKED DURING AD INSPECTION, LOCATED ON R2 PASSENGER DOOR. REPAIRED PER DELTA ERA 459424-14 REV A.SDR F3LA200700002Lever · bindingDURING C-3 CHECK, INSPECTION REPORTED THE R-1 DOOR ARMED LEVER WOULD NOT MOVE TO ARMED POSITION. REMOVED EXCESS LUBRICANT AND RETORQUED NUTS IAW AMM 52-11-22-820-001, STEP 4E(E). DOOR OPERATION NORMAL.SDR F3LA200600167Lever · bindingDURING C-3 CHECK, INSPECTION REPORTED THE R-1 DOOR ARMED LEVER WOULD NOT MOVE TO ARMED POSITION. REMOVED EXCESS LUBRICANT AND RETORQUED NUTS IAW AMM 52-11-22-820-001, STEP 4E(E). DOOR OPERATION NORMAL.SDR SWAA070086Frame · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR LOWER FRAME CRACKED BELOW LOWER CAM. REMOVED AND REPLACED R1 DOOR PER MM.SDR QXEA200700023Door · stiffPDX FLIGHT NR 2453: FLIGHT ATTENDANT REPORTS REAR PAX DOOR HARD TO OPEN AND CLOSE. MAINTENANCE REMOVED AND REPLACED AFT PAX DOOR IAW HORIZON EO 6-52-298. ALL TESTS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR SWIA200717752Step · crackedPAX DOOR FWD SIDE BENEATH TOP FOLDING STEP CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS ON PAX DOOR TOP STEP AREA AS PER CRJ200 REO 601R-52-11-279.SDR SWIA200717751Handle · crackedPAX DOOR HANDLE APPEARS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PAX DOOR OUTER HANDLE P/N 601R 317634 PER CRJ200 AMM 52-11-03-400-802.SDR SWIA200717750Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FABRICATED ANGLE SECTION AND SERVICEABLE SPLICE ANGLES PER CRJ200 REO 601R 52-11-513 REV 'A'.SDR SWIA200717749Web · crackedPAX DOOR FWD WEB CRACK AT HANDRAIL STOWAGE CASTING AND STEP JUST BELOW AT CORNER, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS ON FWD WEB OF PAX DOOR PER CRJ200 REO 52-11-702 REV 'A'.SDR SWIA200717748Web · crackedPAX DOOR AFT WEB CRACKED/LOWER CORNERS, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AS PER CRJ200 REO 601R-52-11-702.SDR 2007FA0000057Attach Fitting · bentAFT CABIN DOOR ASSY SEPARATED FROM AC DURING FLIGHT. CONTROL OF THE AC WAS MAINTAINED AND LANDED SAFELY AT DEPARTURE AIRPORT. DOOR WAS EVENTUALLY RECOVERED AND UPON VISUAL INSPECTION OF THE DOOR, THE AFT DOOR LATCH PIN WAS NOT ENGAGED. THE FRONT DOOR LATCH SDR ASAA0711358Guide Arm · out of adjustFWD ENTRY DOOR HANDLE IS RELUCTANT TO STAY COMPLETELY CLOSED. ADJUSTED L1 DOOR GUIDE ARM.SDR UPS07849053Skin · crackedINSPECTION TYPE:C3 - FOUND EXT FUSE SKIN HAS 1/4" CRACKED AT L1 DOOR HOLD OPEN RECPT. REMOVED EDGE DAMAGE. FABRICATED AND INSTALLED REPAIR DOUBLER IAW SRM 53-02-00 FIG 001R, 51-3-0 AND EO DC8-5330-19684.SDR SWIA200717736Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED AT PULL CABLE EXIT, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS PER REO 601R 52-11-513 REV 'A'.SDR SWIA200717735Step · crackedPAX DOOR STEP 832 DT AND 832 CT CRACKED AT FORWARD WEB, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS PER REO 601R-52-11-702 REV A.SDR SWIA200717734Step · crackedPAX DOOR STEP 832DT AND 832CR CRACKED AT AFT WEB, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS ON AFT WEB PER REO 601R-52-11-1172.SDR MASA200700010Gate · not closedASH 7156 GSP - EN ROUTE TO ORD, AIRCRAFT DIVERTED TO BNA FOR A PAX DOOR WARNING IN FLIGHT. MX FOUND DOOR FLAPPER VENT NOT CLOSING PROPERLY. MX ADJUSTED FLAPPER PUSHROD. OP CHECK NORMAL.SDR 2007UALA00026Skin · bentFORWARD ENTRY DOOR UPPER AFT CORNER BENT INTO AIRSTREAM. MAJOR REPAIR: COLD WORKED REF SRM 51-70-01. FOUND CRACK FROM FASTENER HOLD. FABRICATED AND INSTALLED EXTERNAL DOUBLER PER SRM 52-00-01 PAGE 201 ITEM 11.SDR SWIA200717836Structure · crackedPAX DOOR HAS A CRACK UNDER LOCK FASTENER FWD AND AFT STRINGER NEXT TO 3RD STEP, DISCOVERED DURING C-CHECK INSPECTION. REPLACED CRACKED BRACKETS ON PAX DOOR SECURED IAW EMB 120 SRM 51-40-02.SDR UPS07148857Handle · jammedCABIN MAIN ENTRY DOOR DIS-ARM HANDLE IS JAMMING WHEN DIS-ARMING SLIDE. MAIN ENTRY DOOR SLIDE RAIL LOCKS CLEANED, DRIED, AND LUBRICATED. TESTED SEVERAL TIMES SATISFACTORY.SDR MASA200700002Door · stuckASH 2704 PHX - PAX DOOR WILL NOT OPEN FORM THE OUTSIDE. MX INSPECTED THE DOOR BUT WERE UNABLE TO DUPLICATE THE PROBLEM.SDR 2007UALA00001Door Frame · corrodedR2 DOOR SILL HAS CORROSION OF AFT FRAME AT FR 68. [SUP 05-04-07] INITIAL BLEND OUT OF CORROSION RESULTED IN THE FRAME BECOMING OUT OF COMPLIANCE WITH THE ALLOWABLE DAMAGE LIMITS. THE DAMAGED AREA WAS CUT OUT AND REPAIRED IN ACCORDANCE WITH SRM 53-41-14-20SDR TRAX200700012Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED AT AFT MOTOR PULLEY BRACKET. REPAIRED IAW ALL SRMS.SDR MASA200602767Handle · out of adjustASH 2920 PHX - CREW REPORTED DIFFICULTY OPENING THE PAX DOOR. MX ADJUSTED THE PLUNGER TO THE PAD DOOR OUTER HANDLE.SDR UPS07848827Intercostal · crackedINSPECTION TYPE:C2 L1 DOOR INTERCOSTAL CRACKED .625 INCH UPPER FWD CORNER OF DOOR. FABRICATED AND INSTALLED REPAIR ANGLE DOUBLER AT L1 DOOR UPPER FWD CORNER STA 25 L11L IAW SRM 52-02-00-0 FIG 002 AND SRM 51-01-21D.SDR UPS07848826Intercostal · crackedINSPECTION TYPE:C2 L1 DOOR INTERCOSTAL CRACKED 1.75 INCH, UPPER AFT CORNER OF DOOR. FABRICATED AND INSTALLED REPAIR ANGLE DOUBLER AT STA 70 LBL 60 L1 DOOR AFT CORNER INTERCOSTAL IAW SRM 52-02-00-0, AND SRM 51-01-08.SDR COMA0660738Rod · defectiveFLIGHT 5442 - DURING CLIMBOUT OF CVG RECEIVED A CABIN ALTITUDE WARNING, CREW DECLARED AN EMERGENCY AND RETURNED TO THE FIELD. FLIGHT LANDED WITHOUT INCIDENT. REPLACED BROKEN CABIN DOOR PRESSURE FLAP ROD.SDR QXEA200603352Cam · corrodedPDX C3 AFT PASSENGER DOOR FORWARD UPPER CAM FOLLOWER IS RUSTY, LOOSE AND ROUGH. REPAIRED IAW DASH8 400 MM TASK 52-12-11-400-801 AND 52-00-00-830-802.SDR QXEA200603354Track · chafedPDX C3 - AFT PASSENGER DOOR AFT LOWER TRACK GUIDE ROLLER IS CHAFED IN TWO PLACED. REPAIRED IAW AMM TASK 52-00-830-802.SDR ABXA070009Skin · crackedLEFT MAIN ENTRY DOOR CORNER CRACKED ON INTERIOR WEB CUTOUT. REPAIRED MAIN ENTRY DOOR INNER SKIN/WEB IAW DC9 SRM 52-42-0 AND 52-01.SDR 2006UALA02433Skin · crackedA 7.5 INCH CRACK IN DOOR 2R FWD LOWER EDGE. REMOVED DAMAGE. FABRICATED AND INSTALLED REPAIR PARTS. REFERENCE SRM 53-00-01 REPAIR 32 DETAIL IV.SDR A6WA200640426Handle · malfunctionedHANDLE WILL NOT STOW ON PASSENGER DOOR. REMOVED AND REPLACED OUTER DOOR INNER COVER AND STOW HANDLE ROLL PIN IAW 52-11-03. OPS CHECK GOOD. (M)SDR SWIA200617880Handle · crackedFOUND PAX DOOR OUTERHANDLE IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW OUTER HANDLE DOOR ASSY PER CRJ200 AMM 52-11-03-400-802.SDR SWIA200617879Bracket · crackedFOUND PAX DOOR POWER ASSIST MOTOR MOUNT BRACKET (SIDE PANEL ANGLE) IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW STIFFENER PER CRJ200 SRM 51-42-06.SDR SWIA200617878Panel · crackedFOUND PAX DOOR AFT SIDE PANEL CRACKED 2 PLACES 2ND AND 3RD STEPS, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS PER REO 601R 52-11-702.SDR SWIA200617877Drag Angle · crackedFOUND PAX DOOR AFT DRAG ANGLE CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS PER REO 601R-52-11-513.SDR AMWA81587Latch · malfunctionedON PREFLIGHT, CREW COULD NOT GET CABIN DOOR TO LATCH. MECHANIC SECURED THE DOOR AND THE AIRCRAFT WAS FERRIED. MORE TO BE ADDED WHEN ADL IS RECEIVED.SDR DXTA200601815Cable · out of adjustDOOR LEAKS AIR AND WHISTLES AT FL410. FOUND SUPPLY TUBE TO LOWER ACOUSTIC DOOR SEAL PINCHED PREVENTING SEAL FROM INFLATING. REPOSITIONED TUBE IAW CE 750 M.M. 52-10-04 OPS CHECK GOOD. ALSO ADJUSTED PRE-CATCH IAW CE 750 M.M. 52-10-01. DOOR NO LONGER HARD TO CLOSDR SWIA200617731Anchor Fitting · crackedPAX DOOR FWD ANCHOR FITTING IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED NEW PAX DOOR ANCHOR FITTING (FWD) PER CRJ200 AMM 52-11-17-400-803 CA 90342.SDR SWIA200617730Step · crackedPAX DOOR THERE IS A CRACK UNDER TOP FOLDING STEP NEAR THE BONDING STUD, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR ANGLE AND REPAIR FILLER PER CRJ200 REO 601R52-11-279 (REV NC).SDR SWIA200617729Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED PAX DOOR HANDLE ASSY PART NR 601R-31763-1 PO 487747 IN ACCORDANCE WITH CRJ200 AMM SUBTASK 52-11-03-420-003.SDR SWIA200617728Web · crackedPAX DOOR/AFT WEB IS CRACKED IN RADIUS UNDER THE HANDRAIL STOW BRACKET AND RADIUS BETWEEN THE THIRD AND FOURTH FIXED STEPS, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED FABRICATED PARTS PER REO 601R-52-11-702 REV A.
Back to JASC 5210