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 QXEA2011082900774Bolt · malfunctionedF/A REPORTS THAT THE MAIN CABIN DOOR IS HARD TO OPEN. FERRIED FOR REPAIRS. R & R THE TOP AFT STOP AND STOP BOLT. ADJUSTED STOP BOLT IAW TASK NR 52-11-00-820-801. PREFORMED A FUNCTIONAL TEST IAW TASK 52-11-00-720-801. OPS CHECKED GOOD. RETURNED TO SERVICE.SDR FDEA201108253488Reservoir · emptyON ARRIVAL DURING L1 DOOR OPENING DOOR BOTTLE WAS DISCHARGED BUT SLIDE WAS NOT DEPLOYED. R & R L-1 DOOR EMERGENCY ASSIST POWER RESERVOIR IAW MM 52-11-30-4. OK FOR SERVICE.SDR GLBA20110826GSeal · out of positionPILOT REPORTED THAT AFTER CLOSING THE CABIN DOOR THERE WAS AN OPEN AREA AT THE UPPER LT CORNER. MX REPOSITIONED THE DOOR SEAL AND SEALED IAW MM 52-00-00, OPS CHECKED GOOD.SDR MASA2011082603577Strut · defectivePAX DOOR FALLS RAPIDLY. R2 AFT COUNTER BALANCE STRUT, OPS GOOD.SDR FDEA201108253486Gate · corrodedL-2 DOOR LOWER GATE HAS PITTED CORROSION AT SEAL RETAINER BRACKET. REMOVED CORROSION, CHECKED LIMITS ORIG .200 REMOVED .035 REMAINING .165 FOUND TO BE OUT OF LIMITS IAW SRM 52-10-02, FIG 101. REMOVED LOWER GATE ASSY IAW AMM 52-11-38. RECEIVED NEW GATE ASSDR SIMA201123803Roller · dirtyON FLIGHT 2821 THE CREW REPORTED THE MAIN CABIN DOOR UPPER FLAPPER MECHANISM IS DIFFICULT TO CYCLE SEAL CLOSED WHEN CLOSING DOOR HANDLE FULL DOWN. THE AIRCRAFT WAS REMOVED FROM SERVICE. CLEANED AND LUBED MAIN CABIN DOOR ROLLER IAW EMB 140 AMM 52-18-00. NO PSDR QXEA2011082500731Guide · damagedAFT PAX DOOR CUTOUT FWD AND AFT MIDDLE ROLLER GUIDES HAS GROOVES WORN INTO TOP SIDE OF FITTINGS. BLENDED TO REMOVE GROOVES IAW RD 8/4-52-145. COMPLIED WITH RD 8/4-52-145.SDR CA110825003Bolt · sheared(CAN) UPPER DOOR LATCH BOLT FOUND SHEARED DURING INSPECTION AT FIRST THREAD.SDR A6WA201140845Cleat · erodedPAX DOOR FWD AND AFT CLEATS CORRODED. REPAIRED PAX DOOR AFT CLEAT BY DUPLICATING AND INSTALLING REPAIRED PAX DOOR FWD CLEAT AND INSTALLED IAW SRM 53-00-00 & SRM 51-42-06.SDR FDEA201108243478Reservoir · emptyDURING SERVICE CHECK, FOUND CREW DOOR ENTRY L1 EMERGENCY POWER RESERVOIR PRESSURE GAGE AT ZERO PSI. L1 DOOR POWER ASSIST BOTTLE REPLACED IAW AMM52-11-30-4.SDR UHLA2011082400275Mechanism · lack of lubeL1 DOOR NOT OPENING PROPERLY, WILL NOT LOCK COMPLETELY FOR GATE AGENTS TO OPEN DOOR. LUBED L1 DOOR MECHANISM, OPS CHECK GOOD IAW MM 52-11-00-05.SDR ASOA201101597Door · bindingMAIN CABIN DOOR IS DIFFICULT TO OPEN AFTER PARKING. PERFORMED OPS TEST OF PAX DOOR IAW AMM 52-11-00, DOOR OPERATED NORMALLY.SDR USAA2011082600027Hub · loosePHX - THE L-4 DOOR INTERIOR OPEN/CLOSE HANDLE IS LOOSE. REMOVED AND REPLACED HANDLE HUB.SDR MASA2011082503568Door · malfunctionedPAX DOOR DIFFICULT TO OPEN FULLY. MX FOUND OPS NORMAL.SDR SIMA201123703Door · lack of lubeON FLIGHT 3214 THE FLIGHT ATTENDANT REPORTED THAT TO OPEN THE MAIN CABIN DOOR SHE HAD TO PUSH THE UPPER RIGHT CORNER OF THE DOOR TO OPEN AFTER THE HANDLE WAS UP. THE AIRCRAFT WAS REMOVED FROM SERVICE. CLEANED AND LUBED PASSENGER DOOR IAW AMM 52-18-00. NO PASDR GTIA20110824238Damper · low pressureR-1 DOOR ASSIST DAMPER PRESSURE LOW. SERVICED R-1 DOOR ASSIST DAMPER TO PROPER PRESSURE IAW AMM 52-10-00-614-001.SDR EIAA2011199Skin · crackedHFEC INSPECTION FOUND APPROX 1 INCH CRACK THROUGH STOP DRILLED HOLE ON L1 DOOR SKIN UPPER HINGE CUTOUT RADIUS. REPAIRED IN ACCORDANCE WITH EN 048-11 APPROVED BY BOEING ODAS.SDR GTIA20110824237Cylinder · low pressureL2 DOOR ASSIST BOTTLE LOW. SERVICED L2 DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001.SDR CA110829005Nut · backed out(CAN) DURING SLINGING OPERATIONS WITH THE PILOT REDUCED DOOR REMOVED AND RT SLIDING DOOR IN THE OPEN AND LOCKED POSITION. THE RETAINING NUT PN, ASN 52320BH060N BECAME LOOSE AND BACKED OFF OF RETAINMENT PIN 350A25-1348-21. THE SLIDING DOOR SWUNG DOWN AND TO TSDR UALA2011082404527Bottle · low pressureCREW COMMENTS: DOOR 2L PRESSURE GAUGE OUT OF GREEN BAND. REPLACED DOOR 2L ASSIST BOTTLE ASSY.SDR MASA2011082403557Handle · out of adjustPAX DOOR OUTER HANDLE CAUTION INTERMMITENT. MX WORKING. ADJUSTED OUTER HANDLE AND R2 PX 107SDR QXEA2011082900773Door · bindingF/A REPORTS THAT MAIN CABIN DOOR IS DIFFICULT TO OPEN. PERFORMED GVI OF MAIN CABIN DOOR & SEAL W/NO DEFECTS NOTED. OPERATED MAIN CABIN DOOR NUMEROUS TIMES & OBSERVED CREW MEMBER (F/A) OPERATE MAIN CABIN DOOR W/NO DIFFICULTY. OPS CHECKED GOOD, NO FURTHER DESDR ASOA201101595Frame · corrodedPAX DOOR HAS CORROSION ON LWR CENTER FRAME AND 4 CONNECTING CLIPS. REMOVED CLIPS IAW SRM 51-42-06. OK TO INSTALL CLIPS. INSTALLED CLIPS IAW SRM 52-104, FIG 2, SHT 4, ITEMS 10A & 11A.SDR UALA2011082404529Pan · gougedDOOR 1L HANDLE PAN GOUGED. REMOVED & REPLACED DOOR 1L HANDLE PAN.SDR USAA2011082500012Gust Lock · lack of lubePHX - GUST LOCK DOOR 2L WILL NOT ENGAGE. LUBED L2 GUST LOCK MECHANISM, OPS CHECK GOOD.SDR AALA20110823TUL02Skin · canningMAIN ENTRY DOOR OUTER SKIN HAS WAVINESS AND OIL CANNING AT BOTTOM. STRAIGHTENED LOWER EDGE OF DOOR SKIN IN AREAS OF WAVINESS. BLENDED TO REMOVE ROUGH EDGES OF SKIN. TREATED AND PRIMED AFFECTED AREA`S. FABRICATED AND INSTALLED REPAIR DOUBLER PER AARD 52-10-SDR UALA2011082304501Skin · crackedTHE 4L DOOR CRACKED ON INTERIOR SKIN INBOARD OF LOWER LATCH. MAJOR REPAIR ACCOMPLISHED. CRACKS FOUND ON THE LIGHTNING HOLE FLANGE OF THE P/N 146N6100-671 INNER SKIN AT BS 1671. TRIMMED OUT DAMAGE & PROVIDED AN INSURANCE CUT. ACP NDT OF CUT- OUT & OPEN HOLESDR ASOA201101584Drag Angle · crackedPAX DOOR DRAG ANGLE CRACKED AFT SIDE. INSTALLED DRAG ANGLE REPAIR IAW SRM 52-11-04-201-002-A01.SDR ASOA201101554Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE CRACKED. REPAIRE IAW REO 601R-52-11-513 AND REO NR 610R-52-11-513, REV A.SDR ASOA201101553Web · crackedPASSENGER DOOR FWD WEB CRACKED AT 4TH RISER. REPAIRED IAW REO 601R-52-11-702.SDR USAA2011082500004Slide · low pressureTHE 4L SLIDE SHOWS LOW PRESSURE ON CIDS PANEL. MAINTENANCE REMOVED AND REPLACED 4L ESCAPE SLIDE.SDR MASA2011082303549Handle · lack of lubePAX DOOR OUTER HANDLE WOULD NOT LATCH. RESECURED AND LUBED HANDLE ASSY.SDR MASA2011082303548Door · malfunctionedSTATION COULD NOT OPEN PAX DOOR. DOOR OPEN, NO DEFECTS WERE NOTED.SDR N6WA20110839Release Pin · missingSTAIRS PIN ON MAIN DOOR BROKE OFF CABLE (HANDRAIL). DEFERRED PASSENGER DOOR QUICK RELEASE PIN "MISSING" ON DMI 23157, IAW MEL 52-11-05, CAT C AUTHORIZED BY MX.SDR UALA2011082204465Hinge Fitting · faultyDOOR 1L PRESSURE LEAK. IN PREPARATION FOR MAINT FERRY, PRESSURIZE THE AIRCRAFT AND ENSURE NO PRESSURIZATION LEAKS FROM DOOR 1L. ACCOMPLISHED PRESSURIZATION OF AIRCRAFT PER MM. NO LEAKS NOTED AT DOOR 1L; RAN AIRCRAFT UP TO 4.5 DPI.
REMOVED L1 DOOR, ACP HIDSDR SWIA201127349Skin · crackedPAX DOOR LOWER INNER SKIN CRACKED. (C-CHECK) REPAIR PER REO.SDR SWIA201127348Intercostal · crackedPAX DOOR FORWARD AND AFT LOWER INTERCOSTAL CRACKED. (C-CHECK) REPAIR PER REO.SDR QXEA2011082500734Skin · crackedEXTERIOR SKIN HAS A CRACK IN IT, WITH THE DOOR CLOSED POSITION CRACK IS LOCATED APPROX 8.75" IN FROM AFT SIDE OF DOOR AND APPROX 0.25" ABOVE BEAM 5 CRACK IS 2" LONG. REPLACED SHELL IAW QAMM TASKS 52-11-06-000-801, & 52-11-06-400-801. FUNCTIONAL TESTS SATISFACSDR ASOA201101549Handle · bindingF/A REPORTS PAX DOOR IS HARD TO OPEN DUE TO LATCH STICKING. CYCLED PAX DOOR SEVERAL TIMES NO DEFECTS NOTED AT THIS TIME OPS CHECKED GOOD IAW AMM 52-11-01. OK FOR SERVICE.SDR ASAA11710266Latch · lack of lubeL1 DOOR HOLD OPEN LATCH WILL NOT RELEASE. LUBED L1 HOLD OPEN LATCH, OPS CHECKS GOOD.SDR JR2R2011082100347Web · crackedPAX DOOR AFT WEB IS CRACKED BEHIND STRUT. REPAIRED PAX DOOR WEB IAW RO CRJ9-52-0443.SDR UHLA2011082000274Bottle · low pressureFLIGHT CREW REPORT L1 DOOR DIFFICULT TO OPEN FROM OUTSIDE. INSPECTED AND FOUND DOOR ASSIST BOTTLE LOW, SERVICED AND LUBED ALL ROLLERS AND LINKAGE IAW EMB 170 MM 52-11-5.SDR ASOA201101544Handle · fodMAIN CABIN DOOR JAMS WHEN OPENING. REMOVED FOD FROM OUTER HANDLE. MAIN PASSENGER DOOR OPERATES CORRECTLY IAW AMM 52-11-00. (CLOSED)SDR MASA2011082203530Snubber · malfunctionedMAIN CABIN DOOR OPENS TOO QUICKLY. R2 FWD & AFT SNUBBERS.SDR MASA2011082203529Strut · unknownPAX DOOR GAS STRUTS REQ CHANGED. PER MX GAS STRUTS ARE SERVICEABLE.SDR GTIA20110820236Cylinder · low pressureR1 DOOR ASSIST BOTTLE PRESSURE LOW. R1 DOOR ASSIST BOTTLE SERVICED IAW AMM 52-10-00-614-001.SDR GTIA20110820235Cylinder · low pressureDOOR ASSIST BOTTLE LOW. SERVICED DOOR ASSIST BOTTLE TO PROPER PRESSURE IAW MM 52-10-00-614-001.SDR ASMF201108010Door · out of adjustACFT RETURNED TO DEPARTURE DURING CLIMB, THE ACFT DID NOT PRESSURIZE WITH DOOR TOTALLY CLOSED AND PRESSURE LIGHT REMAINING OFF. DURING MX REVISION, THE FORWARD ENTRY DOOR WAS DETECTED .5" MISADJUSTED, BEING NECESSARY TO PERFORM SEVERAL CYCLES UNTIL CLOSE, AS SDR ASOA201101540Door · bindingPAX DOOR FAILS STEP 2.8.2 OF ASA-2-838004 EXCESSIVE FORCE IS REQUIRED TO COMPLETE FULL DOOR OPEN CYCLE. (SHOULD BE 1016 IS APROX 30LBS) TROUBLESHOT PAX DOOR LATCH LOCK MECHANISM AND FOUND ROLLER ON LEVER ASSY WORN AND UPPER FWD PIN STOP FIRING, OUT OF ADJUSTMSDR ASOA201101536Door · unknownF/A REPORTS MAIN PAX DOOR WILL NOT FULLY EXTEND TO OPEN POSITION WITHOUT ASSISTANCE FROM GROUND. OPS CHECKED PAX DOOR UNABLE TO DUPLICATE PROBLEM IAW AMM 52-11-00.
Back to JASC 5210