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 SWAA2015041338384Skin · crackedL1 DOOR CRACKED AT LOWER HINGE INTERIOR SKIN AT VERTICAL STIFFENER. R & R DOOR IAW MM.SDR UHLA2015040700243Gust Lock · damagedMLD GUST LOCK WILL NOT ENGAGE. REATTACHED HOOK AND LOOP TO GUST LOCK COVER, OPS CHECK L1 DOOR GOOD, IAW MM 52-11-00.SDR SWAA2015040938321Stop Fitting · crackedL1 DOOR UPPER AFT STOP FITTING CRACKED. R & R DOOR IAW MM.SDR AALA201504089005Gust Lock · lack of lubeL1 GUST LOCK WILL NOT HOLD DOOR OPEN. CLEANED & LUBED GUST LOCK MECHANISM. OPERATIONAL CHECKED GOOD.SDR CA150408028Shaft · failed(CAN) WHILE OPENING THE PASSENGER DOOR, THE AFT COUNTER BALANCE CABLE GUIDE SHAFT FAILED. INSPECTION OF THE DOOR IDENTIFIED NO FURTHER RELATED DEFECTS. NO DEFICIENCIES WERE IDENTIFIED WITH THE GUIDE SHAFT AT THE LAST INSPECTION. THE FAILED GUIDE SHAFT IS BEISDR V0XD20150416100Vent · gougedPASSENGER DOOR VENT DOOR HAS A GOUGE ON THE INSIDE. REPLACED PAX VENT DOOR IAW AMM 52-11-15.SDR MASA2015041312037Bottle · lowAFT PAX DOOR PNEUMATIC ASSEMBLY PRESSURE LOW SERVICED.SDR ASOA2015041012584Track · dirtyMAIN CABIN DOOR STICKING AND VERY HARD TO OPEN AND CLOSE. CLEANED TRASH OUT OF PASSENGER DOOR TRACK & CLEANED PASSENGER DOOR SEAL. OPS CHECK GOOD IAW AMM 52-11-00.SDR USAA2015040700005Cylinder · low pressureDURING WEEKLY CHECK, FOUND PRESS OF EMER CYLINDER & ACCUMULATOR BOTTLE OF R4 DOOR LOW, IN YELLOW ZONE AT 39F. SERVICED IAW AMM 52-10-00-614-001.SDR V0XD20150406086Pin · migratedPASSENGER DOOR HINGE AFT SAFETY PIN MIGRATED. R & R AFT SAFETY PIN IAW AMM 52-11-00.SDR FDEA201504041151Door · lack of lubeL1 DOOR WILL NOT OPEN ALL THE WAY FWD TO LOCKED OPEN POSITION. LUBED DOOR HINGE TORQUE TUBE. DOOR OPENS & CLOSES NORMALLY.SDR GTIA2015040401547Bottle · low pressureDOOR ASSIST BOTTLE HAS LOW PRESSURE. SERVICED THE BOTTLE WITH DRY NITROGEN IAW AMM 52-10-00-210-004.SDR A6WA201542588Mount Bracket · crackedPAX DOOR POWER ASSIST MOTOR MOUNT BRACKET IS CRACKED.SDR A6WA201542587Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED.SDR SWIA201541085Lever · chafedPASSENGER DOOR FWD PULL-IN LEVER CHAFED. C-CHECK, RO 4/21/15, REMOVED AND INSTALLED NEW PASSENGER DOOR FWD PULL-IN LEVER, PN 601R318968-4, REF, AMM & REO.SDR ASOA2015040712541Cable · wrong partPAX DOOR WILL NOT OPEN, ICE BREAKER GETTING STUCK. FOUND INCORRECT ICE BREAKER CABLE INSTALLED. INSTALLED CORRECT ICE BREAKR CABLE IAW AMM 52-11-15 & IPC 52-11-15. PAX DOOR OPS CHECKS GOOD. NO FURTHER DEFECTS NOTED AT THIS TIME.SDR USAA2015040400003Valve · looseCIDS CAUTION LIGHT ON FAP. THE L4 DOOR ASSIST BOTTLE FILL VLV SLIGHTLY AJAR. SECURED THE VLV IAW AMM 52-10-00. MSG CLEARED WITH NO ADDITIONAL FAULTS NOTED.SDR CALA2015040600240Bottle · malfunctionedREFERENCE LOG PAGE 8170488, L4 DOOR ASSIST BOTTLE NOT FIRING, THIS LOG PAGE FOR SDR REPORTING ONLY. R & R L4 EMER POWER RESERVOIR & DOOR ASSIST IAW AMM 52-11-30. SEE LOG PAGE 8170488 FOR ADJUSTMENT OF DOOR ASSIST FIRE. MECH ROTABLE PARTS CHANGE WAS INDICATESDR SWIA201541113Skin · scratchedPAX DOOR OUTER SKIN TOP FWD CORNER HAS SEVERAL DEEP SCRATCHES. BLENDED SCRATCHES ON EXTERNAL SURFACE OF PAX DOOR. AREA IS WITHIN LIMITS REF STS EA.SDR SWAA2015040738188Skin · crackedL1 DOOR CRACKED AT LOWER HINGE BOX INTERIOR SKIN & VERTICAL FRAME. REPAIRED SKIN IAW EA.SDR USAA2015040300004Door · dirtyECAM DOOR LT FWD CABIN WARNING, CABIN PRESS NORMAL, WARNING WENT AWAY AFTER 30 MINUTES, CANNOT RECALL WARNING. REMOVED DEBRIS & INSPECTED DOOR AREA. ACCOMPLISHED OPERATIONAL CHECK WITH NO FAULTS NOTED.SDR ASOA2015040312540Spring · failedFWD PAX DOOR W/NOT OPEN, DOORS AND OVERWING EMERGENCY EXITS. REPLACED SPRING ON PRSSURE VENT FLAP IAW AMM 52-11-75.SDR 2015F00055Actuator · malfunctionedSTATUS MESSAGE "FLIGHT LOCK 3L DOOR", MAINTENANCE CHECK FOUND 3L DOOR FLIGHT LOCK ACTUATOR FAILED IN LOCK POSITION AND CAUSED 3L DOOR CAN NOT OPEN. AFTER TROUBLE SHOOTING, PERFORMED THE FAILED ACTUATOR WAS TURNED TO UNLOCK POSITION MANUALLY, 3L DOOR OPEN FUNCTSDR IPXA2015040287647Seal · dislodgedMAIN DOOR SEAL "WHISTLED" OR LEAKED FROM LIFTOFF TO SHORT FINAL. FOUND CREW ENTRY DOOR SEAL OUT OF SEAL RETAINER. RE-INSTALLED SEAL IAW AMM 52-09-01-4, REV 114.02 03/05/15.SDR USAA2015040200008Diaphragm · faultyDOOR 2L DOOR ASSIST PRESS READS ZERO. REPLACED PERCUSSION MECHANISM DIAPHRAGM IAW AMM 52-10-00.SDR USAA2015040200004Cylinder · low pressureR2 DOOR DAMPER CYLINDER HAD ZERO PRESS INDICATION. R & R R2 DOOR DAMPER CYLINDER IAW AMM 52-13-14-400-001B WITH GOOD OPERATIONAL CHECK.SDR SIMA20150401003Mechanism · lack of lubeFLIGHT ATTENDANT REPORTS DOOR VERY HARD TO OPEN. PERFORMED LUBRICATION OF MAIN DOOR ACTUATING & LOCKING MECHANISM IAW AMM 52-18-00-600-801-A. OPERATIONS CHECKED GOOD.SDR N6WA2015033102Latch · lack of lubeMAIN PAX DOOR HARD TO CLOSE. LUBED DOOR LATCH SHIMS IAW AMM 12-20-52. INSPECTED LATCH MECHANISM & FOUND LOCKING FORCE TO BE WITHIN LIMITS IAW AMM 52-11-02. OPERATIONS CHECKED GOOD.SDR FDEA201503311127Bottle · low pressureL1 DOOR PRESS GAUGE 0 PSI. SERVICED L1 DOOR PRESS IAW MM 12-25-04-3.SDR SWIA201541017Skin · crackedSMALL CRACK IN PAX DOOR INNER SKIN UNDER PANEL 832AL. REPAIRED CRACK IN PAX DOOR INNER SKIN UNDER PANEL 832AL, REF STS EA.SDR 29GA2015040700001Spring · damagedAIRSTAIR DOOR JAMS WHEN OPENING AND CLOSING. REPLACED GAS SPRING ASSY AND AIRSTAIR ARM, OPS CHECKED GOOD.SDR SIMA20150330002Mechanism · lack of lubeMAIN CABIN DOOR EXCEPTIONALLY DIFFICULT TO OPEN & CLOSE. LUBRICATED ACTUATING & LOCKING MECHANISM ON MAIN CABIN DOOR IAW AMM 52-18-00. OPENING & CLOSING GOOD IAW AMM 52-18-00-820-801A.SDR UHLA2015032900216Door · failedSHORTLY AFTER TAKEOFF, L2 DOOR PAX AFT OPEN AT 5,000'. ACFT WOULD NOT PRESSURIZE PROPERLY, CABIN CONTINUED TO CLIMB. DECLARED EMERGENCY, RETURNED TO FIELD, LANDED WITHOUT INCIDENT. FOUND L2 DOOR VISUAL LOCK INDICATOR WAS JAMMING VENT FLAP. REPLACED L2 DOOR SDR AALA20150329003Skin · deformedR1 DOOR SKIN LOWER EDGE CTR AREA DEFORMED. REPAIRED DOOR SKIN IAW SRM 52-10-01-2R FIG 202 REPAIR 8 SECTION 12.SDR USAA2015033000002Bottle · low pressureR3 DOOR, DOOR ASSIST BOTTLE PRESS LOW. SERVICED R3 DOOR ASSIST BOTTLE.SDR ASOA2015040112524Door · out of adjustPAX DOOR WILL NOT OPEN FROM INSIDE OR OUTSIDE. ADJUSTMENT OF RT UPPER PAX DOOR TENSION BUTTON AND NUTPLATE REPLACEMENT.SDR USAA2015032900002Cylinder · low pressureDOOR 2L EMER SLIDE INDICATED LOW PRESS. SERVICED 2L DOOR ASSIST CYLINDER IAW AMM 52-10-00-614-001A.SDR A6WA201542569Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED.SDR ASOA2015033112505Door · unknownMAIN CABIN DOOR WILL NOT OPEN FROM INSIDE. OPS CHECK PASSENGER DOOR IAW AMM 52-11-00.SDR GTIA2015032701539Bottle · low pressureR2 DOOR ASSIST BOTTLE LOW PRESSURE. SERVICED R2 DOOR WITH NITROGEN IAW AMM 32-10-00-210-009. OPS CHECK GOODSDR GTIA2015032701538Bottle · low pressureL1 DOOR INBD EMERGENCY FLASHLIGHT INOPERATIVE. TRANSFERRED TO DMI LOG AS DMI 63416-2 IAW MEL 25-60-08-3, CAT "C" DUE: 04/6/2015. PLACARD INSTALLED AND MOC NOTIFIED.SDR SWIA201541004Cam · gougedPAX DOOR UPPER RT FITTING CAM GOUGED. REPAIRED PAX DOOR UPPER RT FITTING CAM REF STS EA.SDR SWIA201541003Cap · dentedPAX DOOR LOWER LT END CAP DENTED. REPAIRED DENT ON PAX DOOR LOWER LT END CAP REF REO.SDR N6WA2015032601Cable · brokenPASSENGER DOOR DIFFICULT TO OPEN & CLOSE. FOUND ICE BREAKER CABLE BROKEN. PLACED ON CARRYOVER. CO 4891 IAW SL-52-014 REV A.SDR A6WA201542590Handle · crackedPAX DOOR OUTER HANDLE CRACKED.SDR QXEA2015032500156Cam · damagedUNABLE TO CLOSE AFT PASSENGER DOOR FULLY, INTERMITTENT ISSUE, DUE TO DAMAGE TO THE INTERLOCK CAM. FERRIED FOR REPAIRS. R & R AFT PASSENGER DOOR INTERLOCK CAM ASSY REF AMM SUBTASK 52-12-11-420-043, PAR 4.Z STEP AF, OPS CHECK GOOD. NO DEFECTS NOTED.SDR ASAA2015032511126Arm · out of adjustF/A REPORTS L1 DOOR HARD TO OPEN/CLOSE. ACFT GROUNDED. ADJUSTED L1 DOOR GUIDE ARM IAW MM 52-11-00-820-801, STEP H. TESTED L1 DOOR IAW MM 52-11-00-700-804. OPS TEST GOOD.SDR UHLA2015032500206Liner · out of positionMAIN CABIN DOOR DOES NOT LATCH IN OPEN POSITION. ADJUSTED THE HOLD OPEN LATCH AND DOOR LINER AS REQUIRED, OPS CHECK GOOD IAW CMM 52-11-22.SDR AALA20150325006Skin · bentFORWARD ENTRY DOOR EXTERNAL SKIN BENT ALONG BOTTOM OF DOOR. PERFORMED DOUBLER REPAIR IAW SRM 52-05-00-001 FIG 37.SDR SWAA2015032637859Skin · crackedL1 DOOR EXTERNAL SKIN CRACKED AT UPPER AFT CORNER. REPAIRED SKIN IAW SRM.
Back to JASC 5210