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 UALA2010011900231Shim · missingMAIN CABIN R-4 DOOR EMERGENCY POWER BOTTLE LINK MISSING (SHIM) WASHERS BETWEEN LINK, PN 140N2823-1. INSTALLED SHIMS ON 4R DOOR EMERGENCY POWER BOTTLE LINK.SDR UALA2010011900230Washer · out of toleranceMAIN CABIN L4 DOOR EMERGENCY POWER BOTTLE LINK IS MISSING (SHIM) WASHERS ON EITHER SIDE OF THE PN 140N2823-1. INSTALLED SHIMS AT L4 DOOR EMERGENCY AIR BOTTLE LINK.SDR USAA2010011990122Cylinder · lowFLT NR 614 - L-1 DOOR ASSIST BOTTLE LOW. MAINTENANCE SERVICED L-1 DOOR ASSIST BOTTLE PER MM 52-10-00-614-001.SDR UALA2010011800201Bottle · reads lowDOOR 1L EMERGENCY ASSIST BOTTLE NO PRESSURE. R & R DOOR ASSIST BOTTLE. VERIFIED DOOR 1L SLIDE PACK DISCHARGE SAFETY PIN WAS REMOVED AND STOWED.SDR GUUA93352011710ADoor · obstructedPILOT REPORTED PLASTIC INTERIOR OF CABIN DOOR GETS STUCK ON DOOR JAMB WHEN OPENING. REPLACED WELL NUTS AND RESECURED AIRSTAIR DOOR FWD COVER, OPS CHECK GOOD.SDR USAA2010011990124Cylinder · lowFLT NR 416- 2R DOOR INDICATOR ON FLIGHT ATTENDANT PANEL SHOWS CHECK DOOR PRESSURE. MAINTENANCE SERVICED 2R DOORSDR FDKA2010011700008Track · dirtyMAIN CABIN DOOR HARD TO OPEN AND CLOSE. CLEAN AND LUBED DOOR TRACKS.SDR GTIA1000001Damper · damagedL4 DOOR ASSIST DAMPER MISSING INTERNAL SPRING / REMOVED AND REPLACED L4 DOOR ASSIST DAMPER.SDR USAA2010021190342Damper · low pressureSAL - S5 - EES - LOW PRESSURE ON FORWARD ENTRY DOOR DAMPER. PERFORMED CHARGING OF FORWARD ENTRY DOOR DAMPER CYLINDER IAW A320 AMM 52-10-00-614-001.SDR SWIA201023519Door · lack of lubeMAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE. (FLT 6840) LUBED MAIN CABIN DOOR.SDR QXEA2010012000048Door · stuckF/A REPORTS MAIN CABIN DOOR DIFFICULT TO OPEN. OPERATED MAIN CABIN DOOR. OPEN AND CLOSED SEVERAL TIMES. OPS CHECKS NORMAL. NO DEFECTS NOTED. COULD NOT DUPLICATE. RETURNED TO SERVICE. NO PARTS REPLACED.SDR USAA20100119BA002Cylinder · low pressurePHL - L3 DOOR LOW PRESSURE PER SERVICE REPORT. SERVICED L3 DOOR CYLINDER.SDR FDKA2010011600007Unknown · malfunctionedMAIN CABIN DOOR CANNOT BE OPENED FROM THE OUTSIDE. MOVED ACFT TO A FLATTER SURFACE, MAIN CABIN DOOR OPS NORMAL.SDR RAIA2009121600001Seal · wornCREW REPORTED THAT THE MAIN DOOR WAS JAMMED. MAINTENANCE RIGGED THE DOOR IAW AMM PROCEDURES AND REMOVED AND REPLACED THE DOOR SEAL. OPS CHECKED GOOD.SDR 2010FA0000057Structure · damagedR1 DOOR CREASED BS 385-410 BETWEEN STR 14R AND 16R.SDR ASOA20100059Drag Angle · crackedREPAIRED PAX DOOR AFT DRAG ANGLE IAW ASA EC/TC REO 601R-52-11-513. ASA RII C/W 5300007. (CLOSED)SDR GUUA93652011510ACable · brokenDURING SCHEDULED ROUTINE INSP DISCOVERED PAX DOOR TOP FWD CABLE BROKEN NEEDS TO BE REPLACED. REPLACED PAX DOOR TOP FWD CABLE.SDR SWIA201023487Handle · lack of lubeFLT 5942 - MAIN CABIN DOOR HARD TO OPEN. LUBED HANDLE MECHANISM.SDR ASOA201000059Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED AT PREVIOUS REPAIR NEAR DOOR ASSIST PULLEY BRACKET. CRACK MEASURES APPROX 1" LONG.SDR MASA2010011500047Latch · malfunctionedUNABLE TO LATCH PASSENGER DOOR. MX PUSHED AIRCRAFT BACK 3 FEET, DOOR LATCHED NORMAL.SDR SWIA201023509Roller · lack of lubeMAIN CABIN DOOR WILL NOT SHUT. (FLT 6175) LUBED ROLLERS AND ATTACH POINTS.SDR C77A227588Door · bindingAFTER TAKEOFF FROM MSP CREW RECEIVED A L1 DOOR VENT DOOR UNSAFE MESSAGE RETURNED TO FIELD. MX INSPECTED AND LUBRICATE VENT DOOR WITH NO FURTHER ISSUES.SDR A6WA201040196Bracket · corrodedCORROSION ON PAX DOOR C/O SILL, AFT HANDRAIL CLEAT AND BRACKET. REMOVED AND REPLACED PAX DOOR C/O AFT HANDRAIL CLEAT AND BRACKET WITH SERVICEABLE P/N 601R31527-217, PRACKET & PN 601R31527-137 CLEAT, IAW SRM 51-42-06 & 51-42-13.SDR A6WA201040112Skin · crackedPAX DOOR FWD SIDE SKIN CRACKED AT HANDRAIL. REMOVED DAMAGED AREA AND REPLACED WITH 2 EACH REPAIR ANGLES AND EXTERNAL DOUBLER IAW REO 601R-52-11-702.SDR SWIA201023491Bushing · lack of lubeFLT 6269 - MAIN CABIN DOOR HANDLE HARD TO OPERATE. LUBED DOOR HANDLE BUSHINGS.SDR SWIA201023464Hinge · dirtyFLT 6311 - MAIN CABIN DOOR HARD TO OPEN. REMOVED DEBRIS LOWER HINGE.SDR MASA2010011300041Pin · shearedFLT 7248 JFK-IAD. PAX DOOR PRESSURE FLAPPER VALVE WILL NOT CLOSE. CONTRACT MX CALLED AND FOUND SHEAR PIN AT FLAPPER DOOR LINKAGE SHEARED. REPLACED LINKAGE ROLL PIN, OP AND LEAK CHECK GOOD.SDR A6WA201040114Attach Angle · crackedPAX DOOR VENT FLAP AFT ATTACH ANGLE APPEARS TO BE CRACKED. REMOVED CRACKED ATTACH ANGLE AND DUPLICATED IAW SRM 51-24-24.SDR BSYA2010004Door · openAFTER TAKEOFF OUT OF LCK CABIN DOOR CAME OPEN IN FLIGHT, RETURNED TO LCK.SDR UALA2010011300163Skin · gougedR1 DOOR EXT SKIN INNER DOUBLER GOUGE JUST BELOW THE UPPER HINGE. GOUGES FOUND TO BE OUT OF LIMIT, REMOVED DAMAGE, FABRICATED AND INSTALLED DOUBLER IAW SRM 52-10-01, P201 AND SRM 51-40-02. WORK IS ACP NR 27976 A ND INSP BY QC 349.SDR UALA2010011300165Gate · corrodedL1 DOOR LOWER GATE CORRODED AND CRACK. REMOVED AND REPLACED DOOR 1L LOWER GATE. OPS CHECK WILL BE ACP ON C-CK ROUTINE JC.SDR SWIA201023488Mechanism · lack of lubeFLT 6030 - MAIN DOOR HARD TO CLOSE. LUBED DOOR MECHANISM.SDR ASAA1097256Mechanism · lack of lubeFWD ENTRY DOOR STIFF AND DIFFICULT TO OPEN AN CLOSE. UPON OPENING THIS LEG DOOR MADE A CRACKING / POPPING SOUND PERFORMED FIM TASK 52 10 00 810 807. LUBRICATED FWD ENTRY DOOR MECHANISM. FWD ENTRY DOOR OPERATES NORMALLY. OK FOR SERVICE.SDR RAIA2009121100001Handle · lack of lubeCREW REPORTED THAT THE MAIN CABIN DOOR WAS DIFFICULT TO OPEN. MAINTENANCE LUBED THE CABIN DOOR HANDLE AND LOCKS. OPS CHECKED GOOD AT THE TIME.SDR AALA20100110TUL02Gate · crackedLEFT NUMBER TWO DOOR UPPER GATE CRACKED. INSTALLED NEW GATE PER ESO 90282.SDR AALA20100110TUL01Beam · crackedFORWARD ENTRY DOOR AFT END OF NUMBER 1 BEAM CRACKED. INSTALLED REPAIR DOUBLER PER SRM 52-05-00 FIG 31.SDR GUUA93652011010ADoor · corrodedDURING SCHEDULED ROUTINE MX, DISCOVERED AIRSTAIR DOOR LOWER FWD SKIN EXFOLIATED AND CRACKED AND LOWER AFT AREA DEBONDED. REMOVED DAMAGED SKIN FABRICATED AND INSTALLED INNER SKIN FILLER AND EXTERNAL DOUBLER REPAIR. OPENSDR QXEA2010011400041Bushing · missingINBOUND FLIGHT CREW COULD NOT FULLY OPEN THE MAIN CABIN DOOR. INSPECTED AND FOUND MAIN CABIN DOOR HAND RAIL SUPPORT JOINT NUT TO BE MISSING. INSTALLED NEW THREADED NUT. IPC NR 52-11-21 FIG 1 ITEM NR 630 PN 85210276-101. OPS CHECK OF DOOR IS NORMAL. NO DEFECTSSDR UALA2010011100131Mechanism · out of adjust3R DOOR WON'T ARM. FOUND A STIFF BEARING ON UPPER TORQUE TUBE OF DOOR EMERGENCY MECHANISM. CLEANED AND LUBED BEARING. DOOR ARMS PROPERLY. ALSO ADJUSTED EMERGENCY MECHANISM.SDR UALA2010011100129Door · out of rigDOOR 1R DUE TO SLIDE JAMMING AGAINST DOOR FRAME WILL REQUIRE A RIG CHECK. DOOR ACTUALLY DROPPED APPX 2" UPON DEPLETION OF DOOR ASSIST RESERVOIR. ADJUSTED DOOR RIG. OP CHKS NORMAL.SDR C2XA10SH024Structure · corrodedSHV - DURING C-CHECK MAIN DOOR LOWER SECTION NUT PLATE HOLES CORRODED (LEVEL 2 LOCAL). MAINTENANCE REPAIRED MAIN DOOR LOWER SECTION NUT PLATE HOLES IAW EC5210-01154A. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR C2XA10SH017Structure · corrodedSHV - DURING C-CHECK MAIN DOOR HAS CORROSION (LEVEL 2 LOCAL) AROUND NUT PLATE HOLE AT BOTTOM SECTION OF DOOR. MAINTENANCE PERFORMED REPAIR AT MAIN DOOR LOWER NUT PLATE HOLES IAW EC5210-01154. THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR A6WA201040139Frame · crackedPAX DOOR FRAME UPPER FLANGE AT FS 338 CRACKED. REPAIRED IAW REO 601R-52-11-402.SDR AALA20100109TUL05Control Box · crackedLEFT NUMBER ONE DOOR HANDLE CONTROL BOX CRACKED. REMOVED OLD BOX AND INSTALLED FORWARD AND AFT CRANK ARMS WITH NEW BEARINGS PER ESO 90283.SDR AALA20100109TUL02Gate · corrodedLEFT NUMBER ONE DOOR, LOWER GATE CORRODED. INSTALLED NEW LOWER GATE PER ESO 90283.SDR ASOA201000026Door · stuckF/A HAD TROUBLE OPENING PAX DOOR FROME INSIDE ACFT, SAYS HANDLE ONLY MOVES ABOUT HALFWAY. OPS CHECK GOOD IAW AMM 52-10-01.SDR UALA2010011100124Gate · cracked1 RT MED UPPER GATE IS CRACKED OUT OF MOST FWD RIVET HOLE DOWN TO LWR EDGE. REPLACED NR 1 RT UPPER GATE.SDR AALA20100108TUL32Pan · damagedLEFT NUMBER ONE DOOR HANDLE PAN GOUGED. REMOVED AND REPLACED LEFT NUMBER ONE HANDLE PAN WITH NEW HANDLE PAN PER ESO 90283.SDR AALA20100107TUL22Gate · wornLEFT NUMBER TWO PASSENGER DOOR LOWER GATE WORN AND CORRODED AT LOWER EDGE. REMOVED LOWER GATE, TRANSFERRED HINGE ASSEMBLY AND EMERGENCY OPERATION ASSEMBLY FROM OLD GATE TO NEW GATE AND INSTALLED ON LEFT NUMBER TWO DOOR PER ESO 90282. ADJUSTMENT AND CHECK TO SDR AALA20100107TUL21Torque Box · crackedL2 PASSENGER DOOR HANDLE TORQUE BOX CRACKED AT 2 CAM BASKET HOLES. REMOVED AND REPLACED WITH NEW DOOR HANDLE TORQUE BOX AND RECONNECTED ALL ASSOCIATED LINKAGES PER ESO 90282.
Back to JASC 5210