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 QXEA2011031500232Handle · dislodgedFUSELAGE DOOR WARNING, FWD CARGO DOOR INDICATES UNSAFE. DIVERTED AND ACCOMPLISHED A UNEVENTFUL LANDING. FERRY FOR REPAIRS. FOUND FWD BAG DOOR HANDLE, DOOR LOCK SENSOR TARGET NOT FULLY ENGAGE IF THE DOOR HANDLE IS CLOSED SLOWLY. VERIFIED VENT DOOR RIGGING, NSDR MASA2011031702167Lanyard · brokenRT PAX DOOR HANDRAIL LANYARD BROKEN. MX R2 LANYARD.SDR REXA201100184Fitting · corrodedDISCOVERED CORROSION TO GUSSET CLIPS INSIDE PASSENGER DOOR AT HINGE AREA DURING PERFORMANCE OF AD2010-23-14. REMOVED AND REPLACED GUSSET CLIPS IAW SRM 51-42-06.SDR MASA2011031702159Cable · defectivePAX DOOR SUPPORT WHEEL INOP. RE-INSTALLED BOTTOM DOOR CABLE.SDR MASA2011031702158Tape · looseMAIN ENTRY TOP STEP ANTI-SKID MATERIAL LOOSE. MX REMOVED AND REPLACED MAIN ENTRY TOP STEP ANTI-SKID.SDR MALA110060Panel · crackedPAX DOOR AFT SIDE PANEL CRACKED IN ZONE 2. REPAIRED PAX DOOR AFT SIDE PANEL ZONE 2 IAW REO 670-52-11-104. CUT OUT DAMAGE AND INSTALLED EXTERNAL DOUBLER.SDR USAA2011032491208Fitting · crackedPIT - L-1 DOOR INSPECTION - CRACK ON CLIP AT BS 360, S14L. REPLACED CLIP AT BS 360, S14L IAW B737 SRM 53-10-15.SDR USAA2011032491207Fitting · crackedPIT - L-1 DOOR INSPECTION - CRACK ON CLIP AT BS 294.5, S11L. REPLACED CLIP AT BS 294.5, S11L IAW B737 SRM 51-40-02.SDR USAA2011032491206Bracket · crackedPIT - L-1 DOOR INSPECTION - CRACK ON BRACKET AT BS 294.5, S11L. REPLACED BRACKET AT BS 294.5, S11L IAW B737 SRM 51-40-02.SDR USAA2011032491205Intercostal · crackedPIT - L-1 DOOR INSPECTION - CRACK ON INTERCOSTAL WEB AT BS 294.5, S12L. REPLACED INTERCOSTAL WEB AT BS 294.5, S12L IAW B737 SRM 51-40-02.SDR SWIA201125815Cover · out of adjustMAIN CABIN DOOR DIFFICULT TO OPEN. (FLT 6351) FOUND MCD ASSIST COVER HOLDING MCD DOOR BUTTON IN, ADJUSTED COVER.SDR MASA2011031602151Step · defectiveTOP SEAT ON MAIN ENTRY DOOR SPONGY. MX REMOVED AND REPLACED TOP STEP OF MAIN ENTRY BOARDING LADDER, OPS CHECK GOOD NO FURTHER DEFECTS NOTED.SDR MASA2011031602148Lanyard · disconnectedPAX DOOR FWD PIN LANYARD DIS-CONNECTED. MX REMOVED AND REPLACED PIN/LANYARD ASSY.SDR USAA20110314EM014Bottle · low pressureBOS - THE RIGHT AFT PASSENGER DOOR ASSIST BOTTLE REQUIRES SERVICING. MAINTENANCE SERVICED THE RIGHT AFT PASSENGER DOOR IAW AMM 52-12-51.SDR UALA2011031401228Shaft · damagedR-1 DOOR EXTERIOR HANDLES DO NOT STOW WITH DOOR OPEN. DISASSEMBLED EXTERIOR HANDLE MECHANISM AND INSPECTED PARTS. REPLACED THE CENTER SHAFT ASSY, CENTER SHAFT O-RING, COLLAR CLUTCH ASSY, INNER SHAFT ASSY AND BUTTERFLY HANDLE BEARING. OPS CHECKED GOOD.SDR SWIA201125811Door · lack of lubeMCD HARD TO OPERATE. (FLT 6501) LUBED MCD.SDR ASOA201100469Drag Angle · crackedPAX DOOR, FWD DRAG ANGLE, CRACKED, MARKED. MAPPED OUT DAMAGE AND SUBMITTED TO CONTRACT, ENGINEER IAW SRM 51-13-01. COMPLIED WITH DISPOSITION 05-2011-107 FROM STS SECTION 1 INTERIM REPAIR ITEMS 1 THROUGH 4. PERFORMED NDT INSP IAW NDTM 51-20-06 PART 6, NO DEFSDR FDEA201103100928Skin · tornDOOR 4L INNER SKIN MID FWD LIGHTENING HOLE CUT-OUT IS TORN. COMPLIED WITH EA F-5210-146224, CAT. "A" MAJOR REPAIR AND FAA FORM 8100-9 DATED 12\23 \2010. (L4 DOOR INNER SKIN REPAIR, P/N: 146N6100-3, S/N: 226 FOR DOOR ASSY).SDR ASOA201100476Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. REMOVED & INSTALLED NEW DRAG ANGLE PN 600-31907-17 IAW SRM 51-42-06/-13.SDR ASAA1159240Door · bindingF/A REPORTS L1 DOOR STIFF TO OPEN. OPS CHECK L1 DOOR REF AMM 52 11 00 501. OPS NORMAL, NO DEFECTS NOTED.SDR ASOA201100456Drag Angle · crackedPAX DOOR FWD DRAG ANGLE CRACKED. R & R DRAG ANGLE IAW SRM 51-42-06.SDR MASA2011031202134Pin · unknownPAX HAND RAIL PIN LANYARD. MX INSTALLED PIN ASSY.SDR MASA2011031202132Rod · brokenPAX DOOR LOWER STEP ACT ROD BROKEN. R & R PASSENGER DOOR LOWER STEP ACTUATING ROD.SDR JR2R2011031000083Door Frame · crackedPASS DOOR INTERNAL AFT UPPER FRAME AT FS 310 IS CRACKED. REPAIRED DAMAGED PAX DOOR FRAME AT FS 310 STR 17L IAW CRJ 200 RO CRJ - 52- 1849.SDR A6WA201140255Panel · corrodedPAX DOOR PANEL 832ET CORROSION ON HINGE ABOVE TOP STEP. REMOVED UNSERVICEABLE HINGE AND REPLACED WITH SERVICEABLE HINGE IAW SRM 51-41-00.SDR SWIA201125794Door · lack of lubeMCD HARD TO OPERATE. (FLT 6354) LUBRICATED CABIN DOOR.SDR UALA2011031001163Handle · faultyL1 DOOR EXTERIOR BUTTERFLY HANDLE DOES NOT FULLY RETRACT INTO THE DOOR RECESS. SUPPLEMENTAL DATA UPDATE DISASSEMBLED EXTERIOR HANDLE AND BASKET CAM ASSY. REPLACED EXTERNAL HANDLE YOKE ASSY, P-N 140N2669-2, PER CMM. LUBED AND REINSTALLED DOOR EXTERIOR HANDLE ASSDR MASA2011031102127Motor · damagedPAX DOOR ASSIST TO MOTOR CABLE FRAYED. MX REPLACED PAX DOOR ASSIST MOTOR.SDR COEA2011030938805Skin · damagedHEAVY CK COE / MAJOR REPAIR: EXTERNAL SKIN ON LT AFT PAX DOOR AT RIVET 23 INCHES BELOW TOP FWD CORNERS 5 INCHES FROM EDGE GOUGED. CUT OUT DAMAGE FABRICATED AND INSTALLED NEW REPAIR FILLER AND DOUBLER IAW STRUCTURAL REPAIR MANUAL.SDR MASA2011031102124Plate · bentLOGO PLATE ON STOW STEP BENT. MX DEFERRED.SDR MASA2011031102123Pin · misinstalledPAX DOOR WILL NOT CLOSE. MX PROPERLY INSTALLED HAND RAIL PIN OP CHECK GOOD.SDR DALA1116279877Skin · gougedLT FWD PASSENGER DOOR EXTERNAL SKIN IS GOUGED AND DENTED AT HOLD OPEN LATCH AFT SIDE. BLENDED OUT DAMAGE, IAW SRM-52-12-0, FIG1, ITEM 12, MATERIAL LOSS MEASURED FOUND TO BE OUT OF LIMITS IAW DC9-52-01, FIG 1 FABBED REPAIR DOUBLER, IAW DC9-SRM-52-05, FIG20. SDR SWAA111483Plate · crackedDURING SCHEDULED 22Y CHECK, FOUND L2 DOOR INTERNAL CLOSE OUT PLATE BETWEEN HINGES CRACKED. REMOVED AND REPLACED PLATE PER BAC DWG.SDR USAA20110309BA018Bottle · low pressureLHR - DOORS R2, L3, AND R4 DOOR ASSIST BOTTLE PRESSURES ARE IN THE YELLOW BAND. MAINTENANCE SERVICED THE DOOR ASSIST BOTTLES.SDR RAIA2011030800001Mechanism · dirtyCREW REPORTED THAT THE PASSENGER DOOR WAS DIFFICULT TO OPEN AND CLOSE. MAINTENANCE INSPECTED, CLEANED AND LUBED THE PASSENGER DOOR MECHANISM AND PERFORMED AN OPERATIONAL CHECK OF THE DOOR. NO DEFECTS NOTED.SDR MASA2011031002105Lanyard · brokenPAX DOOR HAND RAIL PIN LANYARD BROKEN. MX REPLACED LANYARD.SDR RAIA201103070002Linkage · lack of lubeDURING POST FLIGHT INSPECTION THE FLIGHT CREW REPORTED THE PASSENGER DOOR WAS HARD TO OPEN. MAINTENANCE INSPECTED AND LUBED THE PASSENGER DOOR LINKAGES AND ROLLERS. DOOR OPS CHECKED GOOD.SDR FDEA201103070896Gate · corrodedCABIN L1 DOOR WITH CORROSION AT DOOR LOWER GATE ALONG THE LOWEST EDGES. CORRODED LOWER DOOR GATE ON L1 DOOR R & R IAW AMM 52-11-38, REV 97. REPAIR IS CLASSIFIED AS MINOR.SDR ASOA201100433Door · lack of lubeMAIN DOOR CATCHES WHEN TRYING TO OPEN FROM OUTSIDE. PERFORMED LUBRICATION OF PAX DOOR IAW AMM 12-20-52. OPS CHECK GOOD AT THIS TIME. (CLOSED)SDR ASOA201100432Handle · damagedMAIN DOOR WILL NOT OPEN. RESECURED PAX DOOR INSIDE HANDLE STRAP IAW AMM 52-11-02. OPS CHECK GOOD AT THIS TIME. (CLOSED)SDR MASA2011030702096Cable · brokenPAX DOOR ACTUATOR CABLE BROKEN. MX REPLACED ASSIST MOTOR, OP GOOD.SDR USAA20110307EM011Bottle · low pressureBOS - THE L1 DOOR REQUIRES SERVICING. MAINTENANCE SERVICED THE DOOR PER AMM 52-41-51-03.SDR SWIA201125775Roller · lack of lubeMAIN CABIN DOOR DIFFICULT TO OPEN. (FLT 6505) LUBED MAIN CABIN DOOR ROLLERS.SDR UALA2011030701078Chain · out of adjustDOOR 1L HARD TO OPEN AFTER ADJUSTING PROG CHAIN. ADJUSTED AS FOLLOWS SHORTENED SHORT CHAIN 2 FLATS LENGTHENED LONG CHAIN 2 FLATS. ADJUSTED PROGRAMMING BOLT AND TESTED CHAIN.SDR SWIA201125751Roller · wornMCD DIFFICULT TO OPEN. (FLT 6286) REPLACED PAX DOOR ROLLERS AND LUBED DOOR LOCKING MECHANISM.SDR N6WA20110307Cable · malfunctionedPAX DOOR SUPPORT WHEEL NOT RETRACTING. R & R BOTTOM CABLE ASSY IAW AMM 52-11-13. OPS CHECKED GOODSDR MASA2011030702087Bracket · brokenPAX DOOR HAS BROKEN BRACKET. MX R2 PAX DOOR & ACTUATOR.SDR V0XR413Y030511012Cable · wornPAX DOOR PRESSURE VENT FLAP CABLE WORN. REMOVED OLD CABLE AND INSTALLED NEW ICE BREAK CABLE IAW AMM 52-11-15-400-802.SDR N6WA20110305Panel · crackedPAX DOOR LOWER STOW PANEL CRACKED. R & R PAX DOOR BOTTOM STOW PANEL IAW AMM 52-11-04SDR MASA2011030702080Handle · malfunctionedPAX DOOR EXT HANDLE W/N STOW. MX OPS CHECKED 2 TIMES, NO FAULT NOTED.
Back to JASC 5210