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 AALA201704079021Reservoir · low pressureL2 DOOR EMERGENCY POWER RESERVOIR PRESSURE IS LOW. REMOVED AND REPLACED RESERVOIR IAW AMM 52-11-30. OPERATIONAL CHECKED GOOD.SDR ASOA201704051438Riser · crackedFWD RISER ON PAX DOOR FOUND 2 EA. CRACKS. REPAIRED FWD RISER IAW SRM TR 52-0025, 52-11-04--201-004-A01.SDR FDEA201704051077Schrader Valve · looseCABIN DOOR L1 PRESSURE GAUGE READS O PSI. FOUND SCHRADER VALVE LOOSE, SERVICED L1 DOOR AIR RESERVOIR AS REQUIRED, REF AMM 52-11-07-2, NO LEAK'S NOTED, A/C OK FOR CONTINUE SERVICE.SDR FDEA201704051076Crank Assy · inoperativeSLIDE ARMED LIGHT ILLUMINATED FOR THE RIGHT ENTRY DOOR INOPERATIVE. REMOVED AND REPLACED LOWER ACTUATOR CRANK ASSEMBLY IAW CMM 52-11-05. ACCOMPLISHED OPS CHECK IAW 52-11-25-5. OPS CHECKED OK.SDR QXEA2017042100316Bracket · corrodedAFT ENTRY DOOR NR 2 BEAM FOUND CRACKED BETWEEN CENTER SUPPORT. LOCATED, & DRILLED NEW BEAM IAW SRM 51-40-07. APPLIED CORROSION INHIBITING COMPOUND TO INNER STRUCTURE IAW DRW 85217301NOTE 10 REV-J & AMM 51-25-01-390-801.SDR REXA2017040400498Riser · crackedL-1 DOOR AFT SIDE CRACKED AT HANDRAIL RISER 2ND STEP FROM TOP OF DOOR. REPAIRED PAX DOOR RISER 2ND AND 3RD STEP FROM TOP IAW REO 670-52-11-104.SDR R61A201704040267Gate · out of adjustL2 DOOR NOT CLOSING FROM OUTSIDE. CATERING ADVISED VENT FLAP WOULD NOT CLOSE COMPLETELY FROM OUTSIDE. FLIGHT ATTENDANTS HAD TO CYCLE HANDLE MULTIPLE TIMES ON DEPARTURE. ACCOMPLISHED ADJUSTMENT OF L2 DOOR VENT FLAP IAW 52-12-25. OPS CHECK GOOD.SDR ASOA201704041437Stiffener · crackedASD MOTOR LOWER STIFFENER CRACKED. REMOVED AND REPLACED PAX DOOR STIFFENER PER SRM 51-42-06-001-001-A01,51-40-06-001-001-A01 AND 51-40-11-001-001-A01.SDR AALA201704069005Damper · low pressureAIRCRAFT WAS GROUNDED. R2 DOOR ACCUMULATOR PRESSURE LOW. SERVICED R2 DOOR DAMPER PER AMM 52-10-00. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170405001Accumulator · low pressureAIRCRAFT WAS NOT GROUNDED. DOOR L-4 EMERGENCY CYLINDER/ACCUMULATOR, LOW PRESSURE. SERVICED L4 DOOR EMERGENCY CYLINDER/ACCUMULATOR PER AMM 52-10-00.SDR FDEA201704041075Beam · crackedR3 DOOR UPPER BEAM AFT SIDE STOP FITTING IS BROKEN. REMOVE AND REPLACE BEAM PER DWG ADA0006-1 & SRM 51-31-01 V II.SDR FDEA201704041074Beam · crackedR-3 DOOR UPPER BEAM AFT SIDE STOP FITTING IS BROKEN. REMOVE AND REPLACE BEAM PER DWG ADA0006-1 & SRM 51-31-01 V II.SDR FDEA201704041067Schrader Valve · looseCABIN DOOR L1 PRESSURE GAUGE READS O PSI. FOUND SCHRADER VALVE LOOSE, SERVICED L1 DOOR AIR RESERVOIR AS REQUIRED, REF AMM 52-11-07-2, NO LEAK'S NOTED, A/C OK FOR CONTINUE SERVICE.SDR AALA201704059025Damper · low pressureAIRCRAFT WAS NOT GROUNDED. DOOR 4L DAMPER / EMERGENCY OPERATION CYLINDER, PRESSURE LOW. SERVICED 4L DOOR DAMPER / EMERGENCY OPERATION CYLINDER PER AMM 52-10-00.SDR AALA20170404003Damper · low pressureAIRCRAFT WAS NOT GROUNDED. DOOR R1 DAMPER PRESSURE IS LOW. SERVICED R1 DOOR DAMPER PER AMM 52-11-14. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170404002Accumulator · low pressureAIRCRAFT IN BASE MAINTENANCE. R2 DOOR ACCUMULATOR PRESSURE IS LOW. SERVICED R2 DOOR ACCUMULATOR PER AMM 52-22-00.SDR AALA20170404001Actuator · low pressureAIRCRAFT WAS NOT GROUNDED. DOOR R4 DAMPER CYLINDER PRESSURE IS LOW. SERVICED R4 DOOR DAMPER CYLINDER PER AMM 52-11-14. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR IPXA2017040415802Guard · missingFWD ENTRY DOOR HANDLE SAFETY GUARD MISSING. R & R MAIN DOOR ARMING LEVER HINGED COVER PER AMM 20-11-00 AND 52-12-02-004-001.SDR N6WA2017040402Handle · unsecurePAX DOOR WARNING MESSAGE IN FLIGHT. ADJUSTED INNER HANDLE TO REMAIN IN DETENT IAW AMM 52-11-02. VERIFIED PAX DOOR CLOSED AND LATCHED.SDR N6WA2017040401Door · leakingEXTREMELY LOUD SQUEAL FROM MAIN CABIN DOOR. VERIFIED PAX DOOR CLOSED AND LATCHED.SDR DALA2017062304897Pan · crackedPAX DOOR UPPER PAN CRACK. PERFORMED CSVE INSPECTION, REPLACED UPPER PAN SECTION, REPAIRED EXTERNAL SKIN DAMAGE, REPLACED SEAL AND GUST LOCK FITTING, RESTORED PROTECTIVE FINISH, REFERENCE CMM 52-11-1 DAL REV 76.SDR DALA2017040502835Door Frame · dentedSMALL DENT IN L1 DOOR FRAME. STRAIGHTENED LOWER EDGE IAW SRM 52-01-01.SDR AALA201704059014Guide Arm · defectiveFORWARD ENTRY DOOR GUST LOCK DID NOT ENGAGE WHEN DOOR OPENED UPON ARRIVAL. REPLACED FORWARD ENTRY DOOR GUIDE ARM PIN AND BUSHING ASSY IAW AMM TASK 52-11-21. THE AIRCRAFT WAS GROUNDED.SDR ASOA201704035030Door · out of adjustPILOT REPORTED THE MAIN CABIN DOOR HARD TO OPEN. MX ADJUSTED THE DOOR TO FUSELAGE GAP AND OPS CHECKED GOOD. ACFT APPROVED FOR RETURN TO SERVICE.SDR AALA201704049005Stud · looseAIRCRAFT WAS NOT GROUNDED. LOOSE SLIDE BUSTLE AT DOOR 1L. REPLACED L1 DOOR ESCAPE SLIDE RAFT PACK ASSEMBLY AFT UPPER MOUNT STUD PER AMM 25-62-44.SDR N6WA2017040303Striker · leakingPAX DOOR SQUEALED. APPLIED SEALANT TO PASSENGER DOOR SEAL STRIKER PLATE IAW REO 670-53-22-011 AND PERFORMED LEAK CHECK IAW AMM 52-00-00, AND AMM 52-11-07. LEAK TEST PASSED. NO DEFECTS NOTED.SDR AALA201704069009Damper · low pressureL3 DOOR PRESSSURE INDICATION ON F/A CIDS PANEL SERVICED 3L DOOR DAMPER IAW AMM 52-22-00.SDR AALA201704049006Damper · low pressureAIRCRAFT WAS NOT GROUNDED. R3 EMERGENCY EXIT DAMPER PRESSURE LOW. SERVICED DOOR R3 DAMPER PER AMM 52-22-00.SDR AALA201704039021Spring · lack of lubeAIRCRAFT WAS NOT GROUNDED. L1 DOOR WILL NOT GIVE CLOSED INDICATION FROM INSIDE WITH AUTO OPERATION. IT WILL CLOSE OUTSIDE MANUALLY. LUBED DOOR HANDLE SPRING. L1 DOOR LOCKS AND UNLOCKS IAW AMM 52-00-00. ALL COCKPIT INDICATIONS ARE NORMAL.SDR SIMA20170402005Doubler · crackedPASSENGER DOOR FORWARD SIDE SKIN REPAIR DOUBLER CRACKED AT SECOND FROM BOTTOM RADIUS. COMPLETED REPAIR IAW SRM CH 52-11-04 TEMPORARY REVISION 52-0025.SDR SIMA20170402006Doubler · crackedPASSENGER DOOR STEPS AFT SIDE SKIN REPAIR DOUBLER CRACKED, SECOND FROM BOTTOM RADIUS. REPAIRED DAMAGED AREA IAW SRM 52-11-04 TEMP REVISION 52-005.SDR DALA2017041102900Structure · damagedLOWER AFT RIGHT CORNER OF THE L1 DOOR FOUND DEFORMED AND BENT. REPAIRED IAW ER/A 552727-14 PRI REV O.SDR FDEA201704011060Beam · brokenR-3 DOOR UPPER BEAM AFT SIDE STOP FITTING IS BROKEN. REMOVED & REPLACED BEAM PER DWG ADA0006-1 & SRM 51-31-01 V II.SDR DALA2017040202629Beam · crackedCRACKED AFT EDGE OF THE NR 1 BEAM AT THE MAIN ENTRANCE DOOR. THE BEAM WAS REPAIRED IAW SRM 52-10-02-2R, PROCEDURE 7, REPAIR 7 FIG 201.SDR DALA2017040202628Pan · crackedCRACKED PAN ON AFT EDGE NR 1 BEAM AT MAIN ENTRANCE DOOR. THE PAN WAS REPLACED IAW SRM 51-41-01, 51-41-02, 51-41-04, AND 51-41-05.SDR REXA2017033100432Drag Angle · crackedMAIN ENTRY DOOR AFT DRAG ANGLE IS CRACKED. REPAIRED ENTRY DOOR AFT DRAG BRACE ANGLE IAW REO 670-52-11-072.SDR R61A201703310261Gust Lock · lack of lubeMAIN CABIN DOOR GUST LOCK INOPERATIVE. REPOSITIONED TRIM AND LUBED DOOR GUST LOCK IAW AMM 25-23-04. OPS CHECKED GOOD.SDR AALA201704029005Damper · low pressureAIRCRAFT WAS NOT GROUNDED. DOOR L-3 EMERGENCY EXIT DOOR DAMPER PRESSURE LOW. SERVICED DOOR DAMPER PER AMM 52-10-00.SDR AALA201704039006Bottle · low pressureL4 DOOR ASSIST BOTTLE PRESSURE LOW. SERVICED DOOR ASSIST BOTTLE.SDR AALA201704039002Attach Bolt · looseL1 DOOR OUTSIDE DOOR HANDLE DIFFICULT TO OPERATE. FOUND UPPER DOOR SUPPORT ARM TO DOOR FRAME ATTACH FITTING MOUNT BOLT LOOSE ALLOWING DOOR TO SAG, TORQUED BOLT IAW AMM 52-11-12, DOOR OPS CHECKED NORMAL. AIRCRAFT WAS GROUNDED.SDR DALA2017040102637Housing · wornWEAR ON HOUSING AT THE L1 DOOR. THE HOUSING WAS REPLACED IAW SRM 51-30-2.SDR IPXA2017033115700Bracket · bentFWD ENTRY DOOR EICAS MESSAGE. FOUND THE BRACKET FOR FWD ENTRY DOOR PROXMITY SENSOR BENT. REPLACED THE BRACKET AND ADJUSTED THE PROXIMTIY SWITCH IAW AMM 52-71-00. PERFORMED DOOR WARNING SENSOR TEST IAW AMM 52-71-00-735-072.SDR N6WA2017033103Shaft · stickingPAX DOOR INNER HANDLE DETENT ROLLER SHAFT STICKS. R & R ROLLER SHAFT ASSY, AND SPRING IAW AMM 52-11-02. OPS CHECKED GOOD.SDR FDEA201703301266Skin · crackedEVIDENCE OF CRACK ON THE L2 DOOR UPPER HINGE CUTOUT. REPAIRED IAW SRM 52-10-02, REPAIR 1, REV 120.SDR ASAA2017033020320Guide Arm · failedL2 DOOR OPENS HARD WITH LOUD CLICKS. GROUNDED - YES. LUBED AFT PASSENGER DOOR IAW AMM TASK 12-25-17-640-801, NO HELP. REMOVED AND REPLACED THE L-2 DOOR GUIDE ARM PER AMM 52-13-21-000-802. OPS CHECK GOOD.SDR AALA201703319013Bottle · low pressureCHECK DOOR PRESSURE MESSAGE ON FA ANNUNCIATOR PANEL, L2 DOOR. SERVICED THE L2 DOOR ASSIST BOTTLE.SDR AALA201703319009Door · dirtyL1 DOOR DIFFICULT TO LATCH CLOSE. CLEANED THE L1 DOOR OF DEBRIS AND OPENED AND CLOSED DOOR IAW AMM 52-10-00, CHECKED GOOD.SDR AALA201703319007Handle · lack of lubeL1 DOOR OUTSIDE HANDLE DIFFICULT TO MOVE. CLEANED & LUBED DOOR HANDLE ASSY.SDR AALA201703319004Cylinder · low pressureL1 DOOR EMERGENCY CYLINDER PRESSURE IS BELOW LIMITS. SERVICED L1 DOOR CYLINDER IAW AMM 52-10-00.SDR AALA201703319032Bottle · low pressureAIRCRAFT WAS NOT GROUNDED. BOTTLE PRESSURE 2L DOOR INDICATION ON CIDS PANEL. SERVICED 2L DOOR ASSIST BOTTLE PRESSURE.
Back to JASC 5210