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 REXA2014050800431Bolt · dirtyMAIN CABIN DOOR HANDLE WOULD NOT MOVE MORE THAN APPROXIMATELY 1/4 OF THE WAY TO RELEASE DOOR. GND OPERATIONS AGENT HAD TO ASSIST FROM THE OUTSIDE TO OPEN DOOR.
PERFORMED VISUAL INSPECTION OF MAIN CABIN DOOR LINKAGES, ALL CHECKS GOOD. CLEANED & LUBED ALL DOORSDR USAA2014050900002Bottle · low pressure4L DOOR WOULD NOT ARM ON CIDS PANEL. SERVICED 4L DOOR ASSIST BOTTLE IAW AMM 52-00.SDR USAA2014050800016Bottle · low pressurePHL R1 & R2 DOOR ASSIST BOTTLES REQUIRES SERVICE. SERVICED DOOR ASSIST BOTTLES ON R1 & R2 DOORS.SDR SCNA20140527104Intercostal · crackedFOUND CRACKED INTERCOSTAL BETWEEN BS 328-344 INSIDE L1 DOOR. REMOVED DAMAGE. FABRICATED, LOCATE, DRILLED AND INSTALLED REPAIR.SDR SWIA201437665Support Fitting · corrodedSERRATED PLATE ON AFT PAX DOOR SUPPORT FITTING IS CORRODED. C-CHECK, R & R SERRATED PLATE ON PAX DOOR SUPPORT FITTING IAW AMM.SDR SWIA201437621Angle · corrodedPAX DOOR MID-CAP ANGLE HAS CORROSION. C-CHECK, REPLACED NEW PAX DOOR MID CAP ANGLE, PN SH670-31825-7 IAW SRM.SDR V0XD201405070104Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. REPAIRED DRAG ANGLE BY REMOVING DAMAGED SECTION. CUT & INSTALLED NEW ANGLE, PN 601R31772-5S, SECTION & SPLICES IAW REO 670-52-11-072, REV E.SDR MASA2014050731090Door · bindingPAX DOOR DIFFICULT TO OPEN FROM INSIDE. MX LUBED DOOR, PRESSURIZED OPS GOOD.SDR DALA14029009241Structure · bentL1 DOOR BENT AT BOTTOM EDGE IN A 6 INCH SECTION. STRAIGHTENED L1 DOOR FLANGE IAW SRM 52-00-01.SDR SWIA201437411Handle · brokenMAIN CABIN DOOR DIFFICULT TO OPEN FROM INSIDE. REPLACED THE PASSENGER DOOR OUTER HANDLE ASSY IAW AMM.SDR USAA2014050800019Bottle · low pressurePHL L2 DOOR ASSIST BOTTLE REQUIRES SERVICE. SERVICED L1 DOOR ASSIST BOTTLE.SDR USAA2014050800014Diaphragm · puncturedPHL FOUND L1 DOOR ACCUMULATOR DIAPHRAGM PUNCTURED DURING SERVICING OF DOOR ACCUMULATOR. REPLACED L1 DOOR PNEUMATIC ASSEMBLY.SDR SIMA20140506004Structure · damagedDAMAGE WAS FOUND ON THE PAX DOOR THAT HOLDS THE DOOR SEAL IN PLACE IN TWO AREAS. REPAIRED DAMAGED AREA IAW ERS-CR-5200-136 & AML 3373129 ITEM 3.SDR SIMA20140506001Door · lack of lubeFLIGHT ATTENDANT REPORTS MAIN CABIN DOOR IS VERY DIFFICULT TO OPEN. LUBRICATED MAIN CABIN DOOR IAW AMM 52-18-00. OPERATIONS CHECKED SATISFACTORY.SDR AALA20140505010Door Frame · crackedLEFT NR 2 DOOR UPPER HINGE CUT OUT IS CRACKED. INSTALLED REPAIR DOUBLER & STOP PIN FITTING IAW SRM 52-10-02-2R-1 & EA COMP-52-034741.SDR SIMA20140505004Structure · buckledTHERE IS EVIDENCE OF THE SIDE WALL BUCKLED JUST BELOW THE UPPER STEP ON THE LT & RT SIDE OF THE PAX DOOR. REPAIRED IAW ERS-CR-5200-137 IAW NRWC 9EA-MQT-01318 FOR BALANCING ENTRY.SDR DALA14028116804Heater · malfunctionedDURING CRUISE, F/A REPORTED BLUE HAZE FUMES IN FWD GALLEY. FOLLOWED QRH PROCEDURE CONDITIONS DISSIPATED DURING INSPECTION FOUND A4 CIRCUIT BREAKER TRIPPED. REMOVED NR 1 DOOR HEATER IAW AMM 21-45. NEW PARTS AOG FROM ATL AT 2355 PERFORMED SMOKE AND FUMES OF SDR M7FA2014F00099Door · detachedDOOR OPENED IN FLIGHT, AS IT WAS OPENING, THE DOOR SEPARATED FROM THE DOOR TRACK AND PIVOTED UP, CONTACTING THE ROTOR BLADES BEFORE LEAVING THE ACFT.SDR SIMA20140504017Structure · crackedAFT INNER PAX DOOR CORNER HAS A DENT & IS CRACKED. INSTALLED NEW AFT INNER PAX DOOR CORNER IAW SRM 51-42-06 & 51-42-10.SDR SIMA20140504012Support · crackedINTERNAL STRUCTURAL SUPPORT AT PAX DOOR ACCESS PANEL 832JL IS CRACKED APPROX 1/4 INCH. R & R INTERNAL STRUCTURAL SUPPORT AT PAX DOOR ACCESS PANEL 832JL IAW SRM 51-42-06.SDR SIMA20140504011Support · crackedINTERNAL STRUCTURAL SUPPORT AT PAX DOOR ACCESS PANEL 832JR IS CRACKED APPROX 1/4 INCH. R & R INTERNAL STRUCTURAL SUPPORT AT PAX DOOR ACCESS PANEL 832JR IAW SRM 51-42-06.SDR SIMA20140504007Support · crackedFORWARD SKIN STRUCTURAL SUPPORT FOR PAX DOOR MID STEP HAS 2 CRACKS. 1/2 INCH LENGTH TOTAL. COMPLETED REPAIR OF THE FWD SKIN STRUCTURAL SUPPORT FOR PAX DOOR MID STEP IAW SRM 52-11-04-201-004-A001.SDR SWAA2014051427990Cover · crackedR1 DOOR AFT CUT OUT COVER CRACKED. R & R COVER IAW AMM.SDR SIMA20140504006Handle · brokenMAIN DOOR HANDLE GRIP BROKEN. INSTALLED NEW MAIN DOOR ASSIST HANDLE IAW AMM 25-23-04.SDR SWIA201437410Seal · dirtyMAIN CABIN DOOR HANDLE STICKS AND WILL NOT OPEN. CLEANED MAIN CABIN DOOR SEAL AS REQUIRED. DOOR OPERATES NORMALLY. NO DEFECTS NOTED.SDR N6WA30140504002Cable · brokenICE BREAKER CABLE BROKEN. R & R ICE BREAKER CABLE IAW AMM 52-11-15. OPERATIONS CHECKED GOOD AT THIS TIME.SDR USAA2014050500024Nut · loose2L DOOR SLIDE ARMING LEVER NEEDS TO BE SECURED. TIGHTENED NUT ON ARMING SLIDE LEVER, CHECKED OK.SDR DALA14027933315Reservoir · low pressurePASSENGER DOOR, EMERGENCY RESERVOIR ACTUATOR PRESSURE BELOW GREEN ZONE. REPLACED ACTUATOR EMERGENCY RESERVOIRS.SDR QXEA2014050300373Airstair · separatedMAIN CABIN DOOR STAIRS SEPARATING FROM DOOR FRAME. REMOVED FWD PASSENGER AIRSTAIR DOOR ASSY. REPLACED STEP ASSY INSTALLED FWD PASSENGER AIRSTAIR DOOR ASSY. OPS CHECK AND LEAK CHECK GOOD. RETURNED TO SERVICE.SDR QXEA2014050300368Handle · damagedF/A REPORTED THAT THE AFT PASSENGER DOOR HANDLE WAS NOT SEATED AGAINST THE DOOR. AFTER LANDING, FOUND THAT YOU COULD CLOSE AND LATCH THE DOOR FROM THE OUTSIDE BUT THAT THE INSIDE DOOR HANDLE WOULD NOT OPEN OR CLOSE THE DE-PRESSURIZATION FLAP. INSPECTED AFTSDR DALA201806013757Plate · corrodedL4 DOOR, LOWER HINGE, LOWER CAM PLATE CORRODED. REMOVED AND REPLACED THE CAM PLATE IAW ERA 476391-14MA, SECTION III, REV B.SDR DALA201806013756Plate · corrodedL4 DOOR LOWER HINGE, UPPER HINGE PLATE CORRODED. REMOVED AND REPLACED THE L4 DOOR UPPER CAM HINGE PLATE IAW ERA 476391-14MA, REV B, SECTION III.SDR DALA2018060103754Plate · corrodedR4 DOOR, LOWER HINGE, UPPER CAM PLATE CORRODED. REMOVED AND REPLACED UPPER CAM PLATE IAW ERA 476391-14MA, REV B, SECTION III.SDR CA140502001Support Bracket · cracked(CAN) DURING ASSEMBLY OF THE PASSENGER AIRSTAIR DOOR, MAINTENANCE FOUND A CRACK IN THE CHASSIS SUPPORT BRACKET FOR THE SLIDE BLOCK ASSY OF THE PASSENGER DOOR BALANCE SYSTEM. A NEW BRACKET WAS INSTALLED.SDR SWIA201437634Lever · chafedPAX DOOR FWD PULL-IN LEVER CHAFED. C-CHECK, BLENDED CHAFED AREA, REQUESTED NDT FOR CRACK CHECK NO DEFECTS WERE NOTED. ORIGINAL MATERIAL THICKNESS WAS 1.700". AFTER RE-WORK MATERIAL THICKNESS IS 1.665". A TOTAL LOSS OF .035. TOTAL ALLOWABLE LOSS IS .050". SDR SWIA201437633Structure · corrodedPAX DOOR FWD LOWER CAM LATCH HAS CORROSION UNDERNEATH. C-CHECK, REMOVED CORROSION FROM UNDERNEATH FWD LOWER CAM LATCH OF PAX DOOR IAW SRM.SDR SWIA201437632Attach Bracket · crackedPAX DOOR AFT ANGLE BRACKET CRACKED NEXT TO PULL-IN CABLE ASSIST WHEEL BRACKET. C-CHECK, REPAIRED PAX DOOR AFT DRAG ANGLE IAW REO.SDR SWIA201437631Support · chafedPAX DOOR SUPPORT WHEEL CHAFED. C-CHECK, BLENDED CHAFE ON PAX DOOR SUPPORT WHEEL IAW STS EA.SDR SWIA201437630Support · chafedPAX DOOR AFT HAND RAIL OTBD SUPPORT ARM CHAFED FROM PAX DOOR SUPPORT WHEEL. C-CHECK, BLENDED CHAFE ON PAX DOOR AFT HANDRAIL OTBD SUPPORT ARM ORIGINAL MATERIAL THICKNESS .083" REMAINING MATERIAL THICKNESS .078" MATERIAL LOSS OF .005" IS WITHIN LIMITS IAW STS SDR ASOA2014050910482Frame · crackedPAX DOOR FRAME CRACKED AT BS 338 TOP OF DOOR. REPAIRED IAW REO 601R-52-11-402 .SDR ASOA2014050910481Door Frame · crackedPAX DOOR FRAME CRACKED AT BS 320.1, TOP OF DOOR. REPAIRED IAW 52-11-04-000-808 AND 52-11-04-000-810 AND SRM 51-42-13-00. COMPLIED WITH OPS TEST F/O ASD IAW AMM 52-11-00-710-801, OPS TESTED GOOD. MAJOR REPAIR.SDR AALA20140502010Skin · damagedFORWARD ENTRY DOOR HAS PULLED RIVETS & THE SKIN GOUGED AT HOLD OPEN HOOK CUT OUT. REMOVED DAMAGE & INSTALLED DOUBLER IAW SRM 52-05-00-001.SDR AALA20140502007Skin · damagedFORWARD ENTRY DOOR GOUGED IN EDGE OF DOOR SKIN NEAR FWD LOWER CORNER. ROUTED OUT DAMAGE THEN INSTALLED DOUBLER IAW AARD 52-10-00-2.SDR A6WA201441497Drag Angle · crackedPAX DOOR STAIR AFT DRAG ANGLE IS CRACKED AT PULLEY BRACKET. R & R EXISTING REPAIR ANGLE FROM PN 601R31907-301 IAW REO 601R-52-11-513 REV A DATED 09 MAR 05.SDR USAA2014050500033Door · lack of lubeTHE L1 CABIN DOOR HARD TO CLOSE. LUBED AS NEEDED. OK FOR SERVICE IAW AMM 52-10-00.SDR N6WA20140501004Handle · unknownPAX DOOR HANDLE CAUTION MSG. DEFERRED PAX DOOR HANDLE IAW MEL 52-70-01 CAT A.SDR V0XD201405010109Vent · gougedPAX DOOR ICE BRAKE CABLE BROKEN & VENT DOOR HAS A GOUGE. REPLACED PAX DOOR ICE BRAKE CABLE & PRESS VENT FLAP DOOR IAW AMM 52-11-15.SDR V0XD201405010108Cable Assy · brokenPAX DOOR ICE BRAKE CABLE BROKEN & VENT DOOR HAS A GOUGE. REPLACED PAX DOOR ICE BRAKE CABLE & PRESS VENT FLAP DOOR IAW AMM 52-11-15.SDR SWIA201437552Lever · chafedPAX DOOR FWD PULL IN LEVER HAS CHAFING ON OUTER RADIUS. C-CHECK, BLENDED CHAFE ON PAX DOOR FWD PULL IN LEVER IAW REO.SDR SWAA2014050227632Structure · crackedL1 DOOR UPPER HINGE CUT OUT CRACKED FROM LOWER EDGE. R & R CUT OUT IAW EA.
Back to JASC 5210