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 DALA2014071404096Door · obstructedTHE AFT EXIT PATH WAS BLOCKED DUE TO THE DOOR BEING JAMMED BY THE AFT F/A SEAT HARNESS BUCKLES. MAINTENANCE SECURED THE HARNESS REEL CORRECTLY. OPS THEN CHECKED NORMALLY AND THE DOOR WAS ABLE TO BE OPERATED.SDR USAA2014071400010Bottle · lowR1 DOOR ASSIST BOTTLE PRESS LOW. SERVICED R1 DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001-A.SDR SWIA201438893Drag Angle · crackedPAX DOOR AFT DRAG ANGLE REPAIR SPLICE HAS CRACK AT RADIUS. C-CHECK, REPLACED PAX DOOR AFT DRAG ANGLE SECTION WITH NEW, PN 601R 52-11-513-1 IAW SRM AND REO.SDR UHLA2014071100502Indicator · out of positionL1 DOOR VERY DIFFICULT TO SEE RED ARM DISPLAY IN WINDOW WHEN DOOR IS ARMED. ADJUSTED ARM/DISARM INDICATION AS REQUIRED, OPS CHECK GOOD IAW AMM 52-11-00.SDR VNAA2014071100005Seal · dislodgedCREW REPORTED MAIN CABIN DOOR DEVELOPED A LEAK IN UPPER RT CORNER WHILE CLIMBING THROUGH FL270. CREW RETURNED TO FIELD AND LANDED WITHOUT INCIDENT. MAINTENANCE INSPECTED AND FOUND SEAL DISLODGED FROM CHANNEL. MAINTENANCE REINSTALLED, CLEANED AND LUBED SEAL SDR FDEA201407111714Handle · looseL1 DOOR HANDLE PLASTIC, TOP RT IS LOOSE. SECURED THE L1 DOOR ASSIST HANDLE PER B757 AMM.SDR SWAA2014071429946Skin · crackedL1 DOOR INNER SKIN CRACKED AT LOWER HINGE BOX. REPAIRED SKIN IAW EA.SDR FDEA201407111716Hook And Loop · unsecureTHE PLASTIC FRAME AROUND L1 ENTRY DOOR IS LOOSE & WILL NOT STAY ATTACHED. RE-GLUED HOOK & LOOP TO PLASTIC FRAME ASSEMBLY IAW SMP. ACFT OK FOR SERVICE.SDR SWIA201438770Cup · corrodedFWD HAND RAIL CUP ATTACHED TO PAX DOOR LOWER SILL ANGLE CORRODED. LOCATED AND DRILLED NEW FWD HAND RAIL CUP IAW SRM.SDR USAA2014071100004Bottle · low pressureCIDS WARNING CHECK DOOR 4L PRESS. SERVICED 4L DOOR ASSIST IAW AMM 52-10-00-614-001-A.SDR USAA2014071100003Bottle · low pressureDURING DAILY FOUND 4R DOOR ASSIST BOTTLE REQUIRING SERVICE. NO MSG ON THE FAP & CIDS. SERVICED 4R DOOR ASSIST BOTTLE.SDR GTIA2014071001380Bottle · low pressureL1 DOOR ASSIST ACCUMULATOR LOW. SERVICED L1 DOOR ASSIST ACCUMULATOR IAW AMM 52-10-00-614-001-A.SDR DALA2014071104041Plate · missingFOUND L1 DOOR STOP FITTING BEARING PLATE MISSING. INSTALLED BEARING PLATE.SDR ASOA201400710210VDoubler · crackedDURING C-CHECK THE SERVICE DOOR FORWARD LOWER STOP MOUNT DOUBLER WAS FOUND TO BE CRACKED AT FRAME 20, STRINGERS 13-14R. MAINTENANCE R & R THE DOUBLER IAW SRM 51-40-02. THE ACFT WAS APPROVED FOR RETURN TO SERVICE.SDR UHLA2014070900504Handle · brokenR1 DOOR ARMING HANDLE BROKEN. RESECURED R1 ARMING HANDLE DOOR WITH AERODYNAMIC SEAL IAW SRM 51-21-03. OPS CHECKED GOOD.SDR N6WA201409001Nut Plate · missingSCREW & NUTPLATE MISSING ON SECOND STEP OF PAX DOOR. INSTALLED NUTPLATE & SCREW IAW AMM 52-11-04.SDR GTIA2014070901378Bottle · low pressureL2 DOOR ASSIST BOTTLE HAS LOW PRESSURE. SERVICED L2 DOOR ASSIST CYLINDER AMM -52-10-00.SDR UHLA2014070900492Indicator · out of adjustL1 DOOR LOCK INDICATOR INTERMITTENT ON LIGHT. ADJUSTED L1 DOOR LOCK INDICATOR IAW MM 52-12-52. OPS CHECK GOOD.SDR SIMA20140708003Door · out of adjustFLIGHT ATTENDANT INFORMED CAPTAIN & MX THAT THE MAIN CABIN DOOR IS DIFFICULT TO OPERATE. PERFORM ADJUSTMENT OF PAX MAIN DOOR, IAW AMM 52-18-00.SDR CHQA20140708232Door Frame · corrodedDURING INSPECTION, CORROSION WAS FOUND ON THE PAX DOOR LOWER FRAME. THE DOOR FRAME SECTION WAS REPLACED IAW SRM 51-40-02.SDR C77A20140711002Diaphragm · damagedL2 DOOR ASSIST BOTTLE READING ZERO PSI. R & R ASSIST BOTTLE DIAPHRAGM IN L2 DOOR IAW AMM.SDR USAA2014070900011Bottle · low pressureDURING DAILY CHECK FOUND 2L DOOR ASSIST BOTTLE REQUIRING SERVICING. NO MSG ON THE CDIS. SERVICED 2L DOOR ASSIST BOTTLE.SDR USAA2014071000007Handle · loose2L DOOR SLIDE ARMING HANDLE REPORTED LOOSE. TIGHTENED 2L DOOR SLIDE ARMING HANDLE.SDR DALA2014070903985Skin · dentedDURING INSPECTION, FOUND DENT ON EXTERNAL SKIN OF LEFT AFT PASSENGER DOOR. REPAIRED IAW SRM 52-10-00 PARAGRAPH 5.C FIGURE 203.SDR DALA2014070903984Skin · dentedDURING INSPECTION, FOUND A DENT ON EXTERNAL SKIN AFT LOWER CORNER OF LEFT AFT PASSENGER DOOR. REPAIRED IAW SRM 52-10-00 PARAGRAPH 5.C FIGURE 203.SDR CALA2014071191454Skin · tornL4 DOOR ASSEMBLY INNER SKIN TORN AFT SIDE AT SECOND FROM BOTTOM LIGHTING HOLE. REMOVED & REPAIRED L4 DOOR ASSEMBLY INNER SKIN AFT SIDE FROM BOTTOM LIGHTING HOLE.SDR ASOA2014071110846Cable · damagedF/A REPORTED DURING LANDING, A LOUD POP OR BANG CAME FROM MAIN PAX DOOR. AT GATE DOOR WAS DIFFICULT TO OPEN, HANDLE GETTING STUCK AND HAD TO BE FORCED UPWARDS. REQUIRED THREE ATTEMPTS TO OPEN. R & R MAIN DOOR PRESSURE VALVE ICE BREAKER CABLE IAW AMM 52-11-SDR DALA2014070803948Control Rod · disconnectedR1 DOOR WON'T OPEN. FOUND CONTROL ROD DISCONNECTED. REPLACED CONTROL ROD IAW AMM 52-40.SDR USAA2014070800009Accumulator · low pressureFLIGHT ATTENDANT REPORTS 1L DOOR INDICATES CHECK DOOR PRESS IN AMBER. SERVICED 1L DOOR PRESS ACCUMULATOR IAW AMM 52-22-00-614-002-A.SDR SIMA20140707001Guide · lack of lubeMAIN CABIN DOOR HARD TO OPEN AFTER ARRIVAL, EXCESSIVE FORCE REQUIRED. LUBRICATED DOOR GUIDES & PERFORMED OPERATIONS CHECK IAW AMM 52-18-00. OPERATIONS CHECKED GOOD AT THIS TIME.SDR CALA2014070700883Rod End · damagedDOOR L1 OPENED IN FLIGHT 4 INCHES PRESSURIZATION. DID LOTS OF ABNORMAL THINGS TURN ON PACKS ON HIGH, HELPED PART-TIME. ALSO HEARD 2 LOUD THUMPS BELOW CAPTAINS FEET. 1L NOT CLOSING PROPERLY DUE TO VERY DETERIORATED & DAMAGED GUIDE ARM ROD END. R & R GUIDE ASDR SWAA2014080830700Beam · crackedL1 DOOR UPPER BEAM CRACKED IN RADIUS AFT END. R & R BEAM IAW SRM & DWG.SDR N6WA20140706002Hinge · unknownSTOW PANEL HINGE ON MAIN DOOR. R & R HINGE & REPLACED UPPER DOOR STEP IAW AMM 52-11-4.SDR DALA2014070703996Attach Angle · crackedCRACK FWD AND AFT UPPER LINING ATTACH ANGLES ON UPPER EDGE OF L1 PASSENGER ENTRY DOOR. ANGLES FABRICATED IAW DWG 5956563. TREATED AND PAINTED IAW SRM 51-10-3 PAR 14 AND 21, AND INSTALLED IAW SRM 51-30-2.SDR N6WA20140706001Fastener · missingPASSENGER DOOR STEP HAS MISSING HARDWARE. INSTALLED MISSING HARDWARE IAW AMM 20-21-00.SDR USAA2014070700006Bottle · low pressureCIDS CAUTION 4L SLIDE PRESS LOW. PERFORMED SERVICE OF PAX DOOR 4L DOOR BOTTLE IAW AMM 52-10-00.SDR FDEA201407041622Skin · scratchedCABIN L2 DOOR OUTER SKIN FOUND SCRATCHES. COMPLIED WITH EA F-5210-T0310189. REPAIR CLASSIFIED AS MAJOR.SDR FDEA201407041627Battery Pack · dischargedON POST FLIGHT CHECK FOUND L1 DOOR EMER ASSIST BATTERY PACK GREEN TEST LIGHT NOT FLASHING. R & R L1 DOOR ASSIST BATTERY PACK TEST LIGHT 9V BACK UP BATTERIES TWO EACH IAW AMM 52-11-20-4-2. OPERATIONS CHECKED NORMAL, ITEM OK FOR SERVICE.SDR USAA2014070700005Lever · looseFLIGHT ATTENDANT REPORTS DOOR 2L & 2R ARMING LEVERS LOOSE. TIGHTENED BOLTS ON ARMING LEVERS AT 2L & 2R.SDR SWIA201438656Vent · gougedVENT FLAP GOUGED AT AFT STIFFENER LOOKING FORWARD OF THE PAX DOOR FROM THE GROUND POSITION DUE TO ICE BREAKER CABLE. C-CHECK, VENT FLAP STIFFENER LOOKING FORWARD OF THE PAX DOOR FROM THE GROUND POSITION REPAIRED IAW REO.SDR SWAA2014071129897Angle · crackedFORWARD ENTRY DOOR SURROUND STRUCTURE ANGLE CRACKED AT BS 360, STRINGER 11L. R & R ANGLE IAW SRM.SDR UHLA2014070300491Lock · dirtyMAIN CABIN DOOR DOES NOT LOCK. CLEANED LOCKING DEVICE IAW AMM 12-22-01. OPS CHECKED GOOD IAW AMM 52-11-00.SDR UHLA2014070300490Indicator · out of adjustWHEN DEARMING MAIN CABIN L1 DOOR, GREEN INDICATOR NOT VISIBLE IN WINDOW. PERFORMED ADJUSTMENT ARM/DISARM INDICATOR ON L1 DOOR, OPS CHECK NORMAL REF CMM 52-11-20.SDR ASAA2014070308460Door · out of adjustF/E REPORTS L1 DOOR IS DIFFICULT TO CLOSE. ACFT GROUNDED. VERFIED L1 DOOR DIFFICULT TO CLOSE, TRIED ADJUSTING SNUBBER, NO HELP. RETURNED TO ORIGINAL POSITION. DOOR CLOSED FULLY AT APPROXIMATELY 950 IN/LBS REF MM 52-11-00-755-051. L1 DOOR APPEARS TO HAVE A SDR N6WA201403003Door · lack of lubeCREW REPORTS PAX DOOR HARD TO OPEN. INSPECTED & LUBRICATED IAW AMM 52-11-00. FUNCTIONAL CHECK NORMAL. OK FOR SERVICE AT THIS TIME.SDR N6WA20140703002Unknown · malfunctionedPASSENGER DOOR INNER HANDLE WILL NOT STOWE. REMOVED PAX DOOR ICE BREAKER CABLE & OPERATIONS CHECKED VENT FLAP IAW AMM 52-11-15. PLACED ICE BREAKER CABLE ON CARRY OVER CO 4218 IAW SL-52-014.SDR MASA2014070302209Latch · bentPAX ENTRY DOOR UNABLE TO OPEN FROM INSIDE. REPLACED LATCH MECHANISM FOUND BENT.SDR CA140710001Seal · failed(CAN) AFTER TAKEOFF, DURING THE CLIMB PHASE OF FLIGHT, THE MAIN CABIN DOOR BEGAN SQUEALING. THE FLIGHT CREW DECIDED TO RETURN TO THE POINT OF DEPARTURE. AFTER ARRIVING, MAINTENANCE ACTION FOUND THAT THE MCD SEAL WAS RIPPED AT THE LOWER, FORWARD CORNER OF THE DSDR SWAA2014081130754Angle · crackedL1 DOOR CLIP ANGLE CRACKED AT BS 292 STRINGER 9L. R & R ANGLE IAW SRM & DWG.SDR SIMA20140702003Skin · damagedTOOLING MARKS ON PAX DOOR UPPER FWD INNER SKIN. REPAIRED DAMAGE TO DOOR IAW ERS-CR-5200-178.
Back to JASC 5210