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 FDEA201411293969Fitting · abnormalLEFT FWD ENTRY DOOR GUST LOCK BRASS FITTING CRACKED. LT FWD ENTRY DOOR GUST LOCK BRASS FITTING.SDR GTIA2014112901460Bottle · low pressureDOOR ASSIST BOTTLE HAS LOW PRESSURE. DOOR ASSIST BOTTLE SERVICED IAW AMM 52-10-00.SDR GTIA2014112901459Bottle · low pressureL2 DOOR ASSIST BOTTLES HAS LOW PRESSURE. BOTTLE SERVICED IAW AMM 52-10-00.SDR SIMA20141129005Roller · lack of lubeFLIGHT ATTENDANT REPORTS MAIN CABIN DOOR HARD TO OPEN & CLOSE. LUBRICATED MAIN DOOR ROLLERS IAW AMM 52-21-02 & ETN EM-52-061. OPERATIONS CHECKED GOOD IAW AMM 51-18-00.SDR USAA2014120100002Handle · lack of lube1L & 1R DOOR HARD TO MOVE HANDLE TO ARM DISARM. LUBRICATED 1L & 1R DOORS. OPERATIONS CHECKED NORMAL.SDR AALA20141202002Switch · defectiveDURING PAX ENTRY DOOR EMER POWER ASSIST SYS CIRCUITRY FUNCTIONAL CHECK, R1 DOOR AMBER SQUIB CONTINUITY TEST LIGHT WOULD NOT ILLUMINATE. R & R R1 DOOR OPEN SWITCH S52125 IAW 52-11-28-000-802. SYS CHECKED NORMAL.SDR DALA2014112906354Angle · corrodedMAIN CABIN L4 DOOR AFT CABLE SUPPORT, SCUFF PLATE SUPPORT IS CORRODED. REMOVED CORRODED ANGLE. FABRICATED REPAIR AND INSTALLED REF SRM.SDR USAA2014120100001Bottle · low pressureBOTTLE DISCHARGE. CHARGED DOOR BOTTLE, ALSO REPLACED DIAPHRAGM IN THE PERCUSSION MECHANISM OF THE DOOR DAMPER.SDR N6WA2014112702Door Seal · dirtyMAIN PAX DOOR SQUEAL. REMOVED DEBRIS FROM PAX DOOR SEAL IAW AMM 52-11-00.SDR GTIA2014112701458Bottle · low pressureL2 DOOR ASSIST BOTTLE HAS LOW PRESSURE. DOOR ASSIST BOTTLE SERVICED IAW AMM 52-10-00.SDR QXEA2014120801000Rib · corrodedAFT PAX DOOR RIB, SHOWS EVIDENCE OF CORROSION REQUIRES REPLACEMENT. REMOVED RIB, PN 85339514-101, REF SRM 51-42-05. INSTALLED NEW RIB PN 85339514-101, REF SRM 51-42-05 & DWG NR 85339511. LOCATED FIT AND DRILLED RIB, PN 85339514-101 IAW SRM 51-40-07. RESTOREDSDR QXEA2014120800998Rib · corrodedAFT PAX DOOR RIB SHOWS EVIDENCE OF CORROSION REQUIRES REPLACEMENT. REMOVED RIB, PN 85339515-101, REF SRM 51-42-05. INSTALLED NEW RIB, PN 85339515-101, REF SRM 51-42-05 & DWG 853395411. LOCATED FIT AND DRILLED RIB, PN 85339515-101 IAW SRM 51-40-07. RESTORED FISDR QXEA2014120200982Rib · corrodedAFT PAX DOOR, RIB, PN 85339516-101 SHOWS EVIDENCE OF CORROSION REQUIRES REMOVAL AND REPLACEMENT. REMOVED RIB, PN 85339516-101 REF SRM 51-42-05. INSTALLED RIB PN 85339516-101 REF SRM 51-42-05, REF DWG 85339511. REMOVED LIGHT SURFACE CORROSION IAW SRM 51-21-00SDR QXEA2014120200981Rib · corrodedAFT PAX DOOR RIB, PN 85339517-101 SHOWS EVIDENCE OF CORROSION REQUIRES REMOVAL AND REPLACEMENT. REMOVED RIB, PN 85339517-101 REF SRM 51-42-05. INSTALLED RIB PN 85339517-101 REF SRM 51-42-05, REF DWG 85339511, ISS B 5/23/08. REMOVED LIGHT SURFACE CORROSION IASDR AALA20141202004Skin · deformedR1 DOOR AFT LOWER CORNER SKIN FOUND DEFORMED. REPAIRED LOWER CORNER SKIN IAW SRM 52-10-01-2R-8 PROCEDURE REPAIR 8.SDR USAA2014112600002Cylinder · low pressureL2 DOOR ASSIST BOTTLE REQUIRES SERVICE. SERVICED L2 DOOR ASSIST BOTTLE IAW AMM 52-22-00-301.SDR SIMA20141125002Mechanism · lack of lubeFLIGHT ATTENDANT HAD VERY DIFFICULT TIME OPENING MAIN CABIN DOOR, WAS COMING PARTIALLY OPEN & WAS CATCHING ON SOMETHING, FINALLY CAME FREE. LUBED MAIN DOOR EXTERNAL HANDLE MECHANISM & FUSELAGE ROLLERS. OPERATIONS CHECKED OK IAW AMM 52 18 00.SDR ASOA2014122211911Angle · corrodedPAX DOOR BOTTOM ANGLE HAS CORROSION. REPAIRED IAW EA 25-2014-358, REV 0I.SDR ASOA2014122211898Gate · gougedPAX DOOR PRESSURE VENT FLAP GOUGED BY ICE BREAKER CABLE. REPAIRED IAW REO 670-52-11-238, REV DATED 11/9/2006. MAJOR REPAIR.SDR SWIA201440380Lever · wornPAX DOOR PULL IN LEVER IS WORN. REPAIRED THE PASSENGER DOOR PULL IN LEVER IAW REO.SDR RAIA201411240002Structure · corrodedAFT PASSENGER DOOR DIGITAL FR17-18 IS CORRODED. MAINTENANCE REPLACED AFT PASSENGER DOOR DIGITAL.SDR QXEA2014120901017Channel · corrodedAFT PAX DOOR EDGE CHANNEL IS CORRODED AND REQUIRES REPLACEMENT. REMOVED EDGE CHANNEL INSTALLED NEW EDGE CHANNEL, PN 85339542-101, REF SRM 51-42-05. LOCATED FIT AND DRILLED EDGE CHANNEL, PN 85339542-101 IAW SRM 51-40-07. COMPLIED WITH M-184 FORM.SDR QXEA2014120800997Channel · corrodedAFT PAX DOOR EDGE CHANNEL IS CORRODED AND REQUIRES REPLACEMENT. REMOVED EDGE CHANNEL INSTALLED NEW EDGE CHANNEL, PN 85339542-101, REF SRM 51-42-05. LOCATED FIT AND DRILLED EDGE CHANNEL, PN 85339542-101 IAW SRM 51-40-07. COMPLIED WITH M-184 FORM.SDR RAIA201411240001Torque Tube · looseMAIN CABIN DOOR WILL NOT OPEN FROM INSIDE DURING PREFLIGHT. MAINTENANCE INSPECTED AND SECURED TORQUE TUBE BELLCRANK, OPS CHECK GOOD.SDR R61A201411241206Unknown · unknownCREW REPORTED THAT THE L2 DOOR WAS DIFFICULT TO ARM. MAINTENANCE INSPECTED AND FOUND THE FLEX BALL CABLE IN GOOD SHAPE. MAINTENANCE REPORTS THAT THE ESCAPE SLIDE ARM/DISARM INDICATOR IS NOT COMING INTO VIEW.SDR USAA2014112500004Latch · out of adjustDURING FLIGHT THE 4R DOOR HANDLE MOVED APPROXIMATELY 3 TO 4 INCHES OUT OF THE CLOSED POSITION. ADJUSTED THE DOOR LATCH FITTINGS, THE DOOR SLIDE WAS NOT DISTURBED.SDR SIMA20141124001Latch · lack of lubeCOCKPIT DOOR SLIDING LATCH HARD TO MOVE. LUBRICATED COCKPIT DOOR SLIDING LATCH IAW AMM SMP.SDR RAIA201411230004Structure · corrodedAFT U SHAPE AT PASSENGER DOOR HAS CORROSION. MAINTENANCE REPLACED AFT U SHAPE AT PASSENGER DOOR.SDR RAIA201411230003Structure · corrodedFORWARD U SHAPE AT PASSENGER DOOR HAS CORROSION. MAINTENANCE REPLACED FORWARD U SHAPE AT PASSENGER DOOR.SDR SWIA201440316Step · corrodedPAX DOOR TOP STEP HAS SURFACE CORROSION ON UPPER FASTNER SURROUNDS, MARKED, C-CHECK, RO 12/6/14. REPAIRED PAX DOORTOP PANEL, PN 601R317075-3, REF STS EA.SDR SWIA201440315Structure · dentedPAX DOOR LOWER FWD CORNER CAP DENTED. C-CHECK, RO 12/6/14. DRESSED BACK DAMAGED COVER PLATE TO ORGINAL CONTOUR REF REO.SDR SWIA201440314Structure · dentedPAX DOOR LOWER AFT CORNER CAP DENTED. C-CHECK, RO 12/6/14, DRESSED BACK DAMAGED COVER PLATE TO ORGINAL CONTOUR REF REO.SDR SWIA201440313Lever · gougedPAX DOOR FWD PULL-IN LEVER GOUGED. BLENDED OUT DAMAGED AREA WITHIN LIMITS IAW REO.SDR SWIA201440303Skin · corrodedCORROSION ON THE PAX DOOR INNER SKIN UNDER THE BOTTOM STEP. REPAIRED PAX DOOR INNER SKIN UNDER BOTTOM STEP, REF STS EA.SDR MASA2014112812758Bottle · low pressureFOUND L2 DOOR ASSIST BOTTLE PRESSURE AT 1500PSI ON LC-1 CHECK, SERVICED TO 2350 PSI.SDR ASOA2014112611793Panel · crackedDAMAGE FOUND BETWEEN STOW PANEL AND TOP STEP FWD AND AFT. C/W NDT INSPECTION IAW EA 25-2014-347 IAW NDTM 51-20-006 AND FOUND A CRACK INDICATION ON AFT SIDE PANEL RUNNING FROM EDGE OF PANEL INBD APPROXIMATELY .1250". SUBMITTED DAMAGE REPORT TO STS ENGINEERINGSDR QXEA2014112300921Seal · dirtyMAIN CABIN DOOR WILL NOT OPEN FROM INSIDE OR OUTSIDE USING NORMAL PROCEDURES. INSPECTED PAX DOOR SEAL. CLEANED AND LUBED SEAL. PRESSURIZED SEAL. F/A OPEN & CLOSE DOOR, CHECKED GOOD. OK FOR CONTINUED SERVICE.SDR GTIA2014112301454Bottle · low pressureL1 DOOR ASSIST BOTTLE HAS LOW PRESSURE. BOTTLE SERVICED IAW AMM 52-10-00.SDR USAA2014112400001Cylinder · low pressureC1 CHECK R2 DOOR ASSIST BOTTLE PRESS LOW. REPLACED R2 DOOR DAMPER & EMER CYLINDER IAW AMM 52-12-14-801-A. PERFORMED ADJUSTMENT & TEST IAW AMM 52-12-14-820-801-A. TESTED GOOD DOOR DAMPER SERVICED IAW AMM 52-10-00-600-802.SDR C77A20141123005Bracket · gougedAFT PAX DOOR SLIDE ARM & DISARM LOWER INDICATOR BRACKET HAS GOUGE. R & R AFT PAX DOOR SLIDE ARM & DISARM BRACKET PN 170-68685-407 IAW SRM 51-41-01.SDR ASOA2014112611792Skin · crackedPAX DOOR AFT SKIN CRACKED UNDER SIDE STIFFENER, AND FWD SIDE UNDER HAND RAIL CLIP BRACKET.SDR ASAA2014112209729Door · out of adjustFLEET SERVICE REPORTS UNABLE TO CLOSE THE L1 DOOR. ACFT GROUNDED. PERFORMED L1 DOOR FORCE CHECK, EXCEEDED LIMITS TO CLOSE THE DOOR. REF 52-11-00-755-051 STEP ED 5, E). ADJUSTED L1 DOOR IAW MM 52-11-00-705-007. ENTRY DOOR TEST GOOD IAW MM 52-11-00-755-051. SDR SWIA201440083Tube · brokenPAX DOOR WIRE HARNESS UNDER TOP STEP HAS BROKEN TUBING, REPAIRED THE TUBING IAW GREO.SDR UHLA2014112200796Bellcrank · out of adjustL1 DOOR WILL NOT CLOSE. ADJUSTED STOP BELLCRANK, OPS CHECKED GOOD IAW AMM 52-11-20.SDR SWIA201440344Support · chafedPAX DOOR SUPPORT WHEEL ARM CHAFFING AFT HAND RAIL LOWER SUPPORT ARM. BLENDED ARM. NDT REPORTED NO DEFECTS AND FOUND WITHIN LIMITS IAW EA. RESTORED FINISH IAW SRM AND EA.SDR SWIA201440343Arm · chafedPAX DOOR SUPPORT WHEEL ARM CHAFED IN TWO LOCATIONS. REPAIRED IAW EA.SDR SWIA201440342Structure · dentedPAX DOOR LOWER FWD END CAP DENTED. PAX DOOR LOWER FORWARD END CAP REPAIRED IAW REO.SDR SWIA201440341Structure · dentedPAX DOOR LOWER AFT END CAP DENTED. REMOVED DENTED PAX DOOR AFT END CAP, DRESSED BACK DAMAGED AREA, NDT FOUND NO DEFECTS, ENSURED NO DAMAGE TO UNDERLYING STRUCTURE, REINSTALLED END CAP, RESTORED FINISH. ALL STEPS COMPLIED WITH IAW REO.SDR SWIA201440285Step · crackedCRACK ON PAX DOOR FWD SIDE PANEL BOTTOM STEP. REPAIRED PAX DOOR BOTTOM STEP, PERFORMED NDT, NO DEFECTS NOTED. FABRICATED AND INSTALLED REPAIR AND RESTORED FINISH IAW EA.SDR USAA2014112400013Handle · detachedDOOR 1R HANDLE ASSEMBLY LOOSE, CAME OFF. REPLACED R1 DOOR ASSIST HANDLE COVER.
Back to JASC 5210