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 SWIA200718459Door Frame · crackedPAX DOOR FORWARD SIDE OF INTERNAL FRAME IS CRACKED, DISCOVERED AT C-CHECK. REPAIRED PAX DOOR INTERNAL FRAME IAW SRM 52-10-02 FIG 203 PG 208.SDR A6WA200740312Push-Pull Rod · out of positionPASSENGER DOOR WILL NOT OPEN/CLOSE FROM OUTSIDE. OPCV NORMAL FROM INSIDE. PLACARDED AND PLACED ON MEL. REPOSITIONED OUTER DOOR HANDLE PUSHPULL TUBES IAW CMM. OPS CHECK GOOD. REMOVED FROM MEL. (K)SDR 2007UALA02067Torque Tube · wornFWD ENTRY DOOR FUSELAGE TORQUE TUBE HAS WEAR ON UPPER SPIGOT. INSTALLED SERVICEABLE TORQUE TUBE. OP CHECKS GOOD.SDR MASA200700331Handle · out of positionASH 2764 PHX. OUTER HANDLE WILL NOT STOW WHEN F/A CLOSES DOOR. OPS CHECK GOOD.SDR QXEA200701102Skin · damagedC3 OKC - PASSENGER DOOR EXTERNAL SKIN FORWARD UPPER CORNER HAS SEVERAL DEEP SCRATCHES. REPAIRED IAW SRM 51-12-00, 51-21-11.SDR SWIA200718507Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED FILLER AND SPLICE ANGLES PER REO 670-52-11-072.SDR FDKA200706280Handle · lack of lubeFDM 6183 SYR-JFK (1932 PHX LCL). OUTSIDE PAX DOOR HANDLE STUCK OPEN WHEN INSIDE SHOWS SECURED. MX LUBRICATED HANDLE, OPS CHECKED GOOD.SDR TRAX200700880Skin · crackedPAX DOOR INTERNAL SKIN IS CRACKED AT AFT CORNER OF LOWER STEP. REMOVED LOWER PAX DOOR STEP SUPPORT ANGLE LOWER SECTION OF PAX DOOR AFT DRAG ANGLE TO GAIN ACCESS FOR MEASUREMENT OF DAMAGE AND REPAIR. DH752 MADE ALL DETAILS, DEBURRED ALL, TOUCH UP ALODINE, PRISDR TRAX200700856Handle · crackedPAX DOOR EXTERNAL HANDLE FLAPPER IS CRACKED. [06-26-07] REPAIRED IAW CRJ SRM 51-42-06, 51-25-06, 51-25-16, AND CRJ MM 11-20-00.SDR UPS07149972Roller · malfunctionedINSPECTION TYPE:N/A MAIN ENTRY DOOR HARD TO CLOSE. REMOVED UPPER AFT ROLLER ASSY. REINSTALLED ROLLER ASSY. REMOVED AND REPLACED DOOR LOWERING LEVER STOP AND PERFORMED FUNCTIONAL TEST. ALL CHECKS NORMAL. REF MM 52-10-11-05 & 52-10-31.SDR QXEA200701101Structure · crackedC3 OKC - PASSENGER DOOR LOWER EDGE MEMBER CRACKED ON FORWARD AND AFT EDGE. REPAIRED IAW REO 601R-52-11-279.SDR TRAX200700851Handle · crackedCRACK FOUND ON PAX DOOR HANDLE. OUTER HANDLE ASSEMBLY REMOVED IAW MM 52-11-03 / TASK 52 11 03 020 07. LATCH LOCK BOX REMOVED FOR ACCESS AND INSTALLED IAW 52-11-21. LATCH LOCK BOX AND OUTER HANDLE INSTALLED IAW 32-11-03 AND 52-11-25. FUNCTIONAL TEST OF PASSSDR 2007UALA02013Gate · corrodedR-1 DOOR UPPER GATE CORRODED. [08-07-07] REMOVED GATE ASSY FROM DOOR AND REMOVED HINGE FROM OLD GATE. REASSEMBLED HINGE ONTO NEW GATE, AND INSTALLED NEW GATE ON DOOR.SDR TRAX200700845Skin · crackedPAX DOOR STAIRS AFT SKIN CRACKED IN RADIUS UNDER UPPER MID STEP.SDR TRAX200700844Skin · crackedPAX DOOR STAIRS FWD SKIN CRACKED IN RADIUS UNDER UPPER MID STEP.SDR TRAX200700843Handle · crackedPAX DOOR OUTER HANDLE FLAP IS CRACKED. [06-26-07] REPAIRED IAW SRM 51-42-06, 51-25-01, AMM 11-20-00, & AMM 52-11-00.SDR SWAA072995Skin · crackedDURING SCHEDULED C1 CHECK, FOUND R1 DOOR SKIN CRACKED AT LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR SWAA072996Skin · crackedDURING SCHEDULED C1 CHECK, FOUND R1 DOOR SKIN CRACKED AT UPPER FWD CORNER. REPAIRED SKIN PER SRM.SDR RAIA00706019Door · stuckPOST FLT NR 7976 - STL - PAX DOOR HARD TO OPEN. MAINTENANCE INSPECTED DOOR, OPENED AND CLOSED SEVERAL TIMES BY MAINTENANCE AND FLIGHT ATTENDANT, NO DEFECTS NOTED.SDR TRAX200700832Unknown · bindingF/A REPORTS, PAX DOOR IS HARD TO OPEN.SDR TRAX200700824Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED (MARKED). [06-21-07] REPAIRED PAX DOOR AFT DRAG ANGLE IAW BOMBARDIER REO 670-52-11-072.SDR 2007UALA01997Lever · out of adjustR-1 MED MODE SELECTOR NEEDS ADJUSTMENT.SDR QXEA200700944Door · unknownSEA FLIGHT NR 2318: FA UNABLE TO OPEN REAR PASSENGER DOOR. MAINTENANCE FOUND PREVIOUS OPENED AND OUT OF SEQUENCE. RESEQUENCED DOOR AND PERFORMED OPS CHECK. OPS CHECK IS GOOD IAW Q400 AMM TASK 52-12-00-710-801. OK FOR CONTINUED SERVICE. NO FURTHER DEFECTS SDR CNMA20070011Motor · bypassingL-2 DOOR AIR MOTOR IS BYPASSING AIR INTERNALLY DURING OPS CHECK.SDR SWIA200718333Roller · bindingCOULD NOT OPEN THE CABIN DOOR FROM THE OUTSIDE. ADJUSTED THE FORWARD AND AFT PAX DOOR UPPER ROLLERS ON FUSELAGE CUT OUT. OPS CHECK GOOD.SDR DL757070725Skin · gougedMAJOR REPAIR LOCATED STA 1384 AT STOP BEAM 3 OF CARGO DOOR.SDR 2007UALA01977Structure · underservicedDOOR L2 UPPER HINGE CUTOUT IS UNDERSERVICED. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED DOUBLER REPAIR.SDR TRAX200700818Unknown · bindingF/A REPORTS MAIN DOOR HARD TO CLOSE AND LOCK PROPERLY.SDR 2007UALA01962Torque Tube · looseAFT ENTRY DOOR CUTOUT TORQUE TUBE HAS PLAY OVER .0030 BEYOND LIMITS. REPLACED DOOR BODY TORQUE TUBE & UPPER AND LOWER BEARINGS.SDR 2007UALA01927Skin · dentedDOOR 1L HAS DENT ON LOWER SKIN. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED AREA. INSTALLED DOUBLER REPAIR.SDR SIMA200720421Bracket · crackedMAIN ENTRANCE DOOR INNER HANDLE BRACKET CRACKED. STOPPED DRILLED CRACK, FABRICATED AND INSTALLED DOUBLER IAW EMB IC 2007-145/30894, PARAGRAPH ONE AND IC2007-145/6600A. RETURNED AIRCRAFT TO SERVICE.SDR YENA2007061Bottle · crackedL-1 ENTRY DOOR ASSIST BOTTLE LEAKING (CRACKED). REPLACED L-1 ENTRY DOOR ASSIST BOTTLE PER AMM 52-11-14, LEAK CHECK OK.SDR TRAX200700812Strap · out of positionUNABLE TO OPEN ASD, LCL FOUND DOOR HANDLE STRAP CLOSED IN DOOR.SDR TRAX200700805Door · stiffFA REPORTS CABIN ENTRANCE DOOR DIFFICULT TO OPEN.SDR MASA200700316Unknown · malfunctionedASH 2878 PHX. PAX DOOR WILL NOT OPEN. MX CYCLED DOOR MULTIPLE TIMES WITH NO DEFECTS NOTED.SDR TRAX200700809Gate · stuckMAIN PASSENGER DOOR STUCK IN CLOSED POSSITION. PRESSURE FLAP WILL OPEN BUT DOOR WILL NOT OPEN FROM INSIDE CABIN OR OUTSIDE CABIN.SDR MASA200700311Latch · obstructedASH 2887 BUR - UNABLE TO LATCH MAIN PAX DOOR. MX PUSHED ACFT PACK APPROX 2 FEET AND WAS ABLE TO CLOSE AND LATCH DOOR.SDR AWXA200700736Damper · brokenSAL - EES - BROKEN ASSIST DAMPER ASSEMBLY ON R1 DOOR, FR 16 - FR 20. REPLACED ASSIST DAMPER ASSEMBLY ON R1 DOOR, FR 16 - FR 20 IAW A319 AMM 52-11-14. [06-19-07] REMOVED INFORMATION FROM STRUCTURE CAUSING DIFFICULTY SECTION SINCE DEFECTIVE ITEM IS NOT A STRUSDR UPS07849946Skin · crackedINSPECTION TYPE:C3 L2 DOOR INNER SKIN BROKEN AT LWR HINGE ARM CUTOUT. REMOVED BROKEN STRAP AT L2 DOOR ARM CUTOUT IAW SRM 51-3-0. FABRICATED AND INSTALLED REPAIR STRAP AT L2 DOOR ARM CUTOUT IAW DWG 5750988, AND SRM 51-3-0.SDR MASA200700309Door · lack of lubeASH 2887 BUR, MAIN PAX DOOR WOULD NOT CLOSE. MAINTENANCE LUBE THE DOOR.SDR FDKA200706265Window · out of adjustFDM 6019 ATL (1655 PHX LCL). CAPTAIN'S SIDE WINDOW WON'T STAY LOCKED. MX ADJUSTED WINDOW.SDR TRAX200700808Handle · crackedEXTERIOR PAX DOOR HANDLE IS CRACKED. REPAIRED IAW SRM 52-11-03.SDR CALA0700295Beam · crackedINSPECTION FOUND A .5 INCH CRACK IN L-1 DOOR AFT EDGE BEAM AT NR 7 FORWARD STOP. A REPAIR DOUBLER WAS INSTALLED IAW ECRA 5210-01938 AND SRM 51-40-02.SDR CPCP20070072Step · corrodedCORROSION FOUND ON ALL PAX DOOR STEPS UNDER NUTPLATES. CORROSION REMOVED ON ALL PAX DOOR STEPS UNDER NUTPLATE BY SRM 51-10-10.SDR QXEA200700901Handle · dirtySEA FLIGHT: FA REPORTS THAT THE LEFT REAR PAX DOOR IS DIFFICULT (TL-2) TO OPEN. MAINTENANCE CLEANED DIRT AND DEBRIS FROM HANDLE MECHANISM AND APERATURE. LUBED LOCKING MECHANISM. OPS CHECK GOOD. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR DXTA200702246Door · stuckMAIN CABIN DOOR WOULD NOT OPEN PRIOR TO DEPLANING AFTER A 1.2 HOUR FLIGHT. PASSENGERS AND CREW DEPLANED THROUGH THE EMERGENCY EXIT ESCAPE HATCH. [06-15-07] INSPECTED CABIN DOOR & FOUND STEP CABLE UPPER BRACKET BENT & ROD END JAMMED BETWEEN CABIN & DOORSDR TRAX200700798Bolt · missingPAX DOOR WILL NOT CLOSE AND LOCK PROPERLY, DOOR APPEARS TO BE OUT OF RIG AFT ASSY HAS CROSS OVER TUBE BOLT MISSING.SDR SWIA200718518Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND SPLICES PER REO:670-52-11-072.SDR SWIA200718517Web · crackedPAX DOOR AFT WEB IS CRACKED AT UPPER STEP, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES, DOUBLERS, AND SHIMS PER REO52-11-104.SDR 2007UALA01851Spring · corrodedFWD ENTRY DOOR TORQUE TUBE SPRING CORRODED.
Back to JASC 5210