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 CA020515010Hinge · frozen(CAN) WHEN DEPARTING IN HEAVY SNOWFALL AND DURING LANDING ROLL RECEIVED DOOR WARNING ON FORWARD PAX DOOR. TAXIED TO PLATFORM, DOOR WARNING DISAPPEARED. WHEN CA 1 OPENED THE PAX DOOR, WAS NOT ABLE TO OPEN IT FROM INSIDE. THE GROUND STAFF WAS ABLE TO OPEN THE DOSDR SWAA013405Skin · crackedDURING SCHEDULED 1/4D CHECK, FOUND FWD ENTRY DOOR EXTERNAL SKIN CRACKED ON AFT EDGE, 8 INCHES FROM TOP. REPAIRED SKIN PER SWA RA.SDR SWIA200110474Link · out of adjON DEPARTURE OUT OF SLC GOT A PASSENGER DOOR STOW MESSAGE. FLIGHT ATTENDANT CHECKED ALIGNMENT MARKS AND REPORTED MARKS WERE NOT MATCHED. RETURNED TO SLC. TOP MARKS WERE NOT MATCHED. FOUND MICROSWITCH ON OUTER HANDLE TO BE OUT OF LIMITS. REPOSITIONED THE MSDR USAASA01068Cam · brokenBOS - L1 DOOR ARMING CAM BROKE. MAINTENANCE REPLACED THE CAM. SMELL PIECE FELL FROM MAIN ENTRY DOOR. REPLACED DOOR HOOK. OPS OK. (M)SDR COMA0160988Door FrameFLIGHT 6294 DOOR WARNING MESSAGE SHORTLY AFTER T/O.CLEANED DEBRIS FROM DOOR SILL AREA - DORO OPERATION CHECKED NORMAL.SDR PCAA0112171Strut · weakLGA- CREW REPORTED MAIN CABIN DOOR IS JAMMED AND WILL NOT OPEN. MAINTENANCE REPLACED FORWARD AND AFT DOOR (HANDRAIL) STRUTS. OPERATIONAL CHECK GOOD IN ACCORDANCE WITH DASH 8 MAINTENANCE MANUAL 52-10-00. AIRCRAFT RETURNED TO SERVICE.SDR 01FDEA01090Roller · out of positionCLIMBOUT UNABLE TO PRESSURIZE - TRIED MANUALLY TO PRESSURIZE, NO HELP. ALL DOOR LIGHT INDICATIONS NORMAL. UPON ARRIVAL IN RST MAIN ENTRY DOOR UPPER AFT GUIDE ROLLER OUT OF GUIDE, CAUSING DOOR TO NOT PROPERLY SEAT. OPENED/CLOSED DOOR FROM INSIDE/OUTSIDE SEVESDR SWIA200110452Switch · intermittentCABIN DOOR STAYS HYDRAULICALLY PRESSURIZED INTERMITTENTLY AND WILL NOT OPEN. FLIGHT ATTENDANT CABIN DOOR BUTTON NEEDED TO BE TOGGLED TO RELEASE PRESSURE. REMOVED AND REPLACED CABIN PASSENGER DOOR CONTROL SWITCH AT F/A STATION. OPS CHECKS GOOD IAW MM 52-10-0SDR QXEA0102034Switch · dirtyPDX- FLIGHT ATTENDANT REPORTS DIFFICULTY RAISING AND LOWERING MAIN CABIN DOOR. CLEANED MAIN CABIN DOOR HANDLE MICROSWITCH. NO PARTS REPLACED. OPERATIONAL CHECKS GOOD. AIRCRAFT RETURNED TO SERVICE.SDR SWIA200110574Structure · crackedC-CHECK, PAX DOOR LOWER AFT TRACK, CRACK ON DOOR STRUCTURE. PERFORMED REPAIR ON PASSENGER DOOR UNDER LOWER AFT TRACK PER SB 120-052-0034.SDR CALA0101026Web · crackedINSPECTION FOUND A 2" CRACK IN L-1 DOOR LOWER FORWARD WEB AT LOWER FORWARD STOP FITTING. THE CRACK WAS STOP DRILLED. A DOUBLER AND RADIUS BLOCK REPAIR WAS INSTALLED IAW ECRA 5265-01005 REV D AND ECRA 5210-01461.SDR 2002FA0000088Handle · strippedWHILE INVESTIGATING A COMPLAINT OF A DEFECTIVE DOOR LATCH IT WAS DISCOVERED THAT THE INTERNAL SPLINES OF THE DOOR HANDLE WERE STRIPPED.SDR QXEA0102105Hinge Fitting · scoredPDX - MAIN CABIN DOOR HINGE LUGS ARE DEEPLY SCORED. REPAIRED IAW FOKKER SRM 52-02-02, PAGE 7, FIGURE 4 AND HORIZON AIR EA 4-52-463.SDR GLBA2001239Seal · out of adjCABIN DEPRESSURIZED ON CLIMB. RE-INSTALLED DOOR SEAL IN TRACK, OPS CHECKED SYSTEM SATISFACTORY.SDR QXEA0102073Fastener · improperPDX - MAIN CABIN DOOR FASTENER IS TOO SHORT, INSIDE SKIN, FORWARD SIDE, 19INCHES UP FROM HINGE END THROUGH CHANNEL UNDER HAND RAIL SUPPORT TOWER. REPAIRED IAW FOKKER SRM 51-31-05.SDR QXEA0102078Skin · deformedPDX - DEFORMATION TO EDGE OF LIGHTING HOLE ON MAIN CABIN DOOR INNER SKIN LOWER AFT CORNER. REPAIRED IAW FOKKER SRM 51-11-4, PAGE 2.SDR QXEA0102077Angle · corrodedPDX - MAIN CABIN DOOR HAS FRETTING CORROSION ON REINFORCEMENT ANGLE. REPAIRED IAW FOKKER SRM 52-01-01, PAGE 7, PARAGRAPH A 4C.SDR QXEA0102074Rivet · pulledPDX - MAIN CABIN DOOR RIVETS ARE PULLED THROUGH INNER DOOR STRUCTURE, AFT END, UNDER HAND RAIL SUPPORT. REPAIRED IAW FOKKER SRM 51-31-05.SDR QXEA0102072Rivet · improperPDX - RIVETS ARE TOO SHORT ON MAIN CABIN DOOR INNER SKIN, AFT/UPPER AREA ADJACENT TO FRAME PLATE. REPAIRED IAW FOKKER SRM 52-10-00 AND SRM 51-31-05.SDR QXEA0102071Rivet · out of positionPDX - RIVET IS PULLED AWAY FROM STRUCTURE ON THE MAIN CABIN DOOR INNER SKIN, ADJACENT TO CHANNEL AND DIAPHRAGM. REPAIRED IAW SRM 52-10-00 AND SRM 51-31-05.SDR ZW0A0112104Skin · gougedDURING CHECK-C MAINT THE FWD LT PASSENGER DOOR, OUTER SKIN AND INTERNAL STRUCTURE WAS GOUGED AND WORN BELOW THE GUST LOCK RECESS. INSTALLED NEW GUST LOCK HOUSING AND REPAIRED DOOR SKIN PER SRM 52-05, FIG 20A.SDR QXEA0102031Hinge · damagedPDX - THE FORWARD PASSENGER DOOR HINGE IS DAMAGED. REPAIRED IAW EA 12-53-09.SDR C2XA01CL239Bolt · looseCLE FLIGHT#3242 THE CREW REPORTED THE MAIN CABIN DOOR WAS HARD TO OPEN AND CLOSE.MAINTENANCE INSPECTED AND RESECURED BOLT ON THE INNER HANDLE OF MAIN CABIN DOOR.OPERATIONAL CHECKS WERE GOOD.THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR 2002F00292Structure · crackedFOUND DOOR CRACKED BEYOND SERVICEABLE LIMITS. REPLACED WITH NEW UNIT CORRECTED PROBLEM. (M)SDR 2001FA0000660Snubber · failedRECEIVED 2 DIFFERENT SNUBBERS AND INSTALLED. NEITHER HAD ANY SNUBBING ACTION. NEW PARTS FROM THE FACTORY.SDR CALA0101020Skin · crackedINSPECTION FOUND L-1 DOOR SKIN AT AFT INTERIOR EDGE CRACKED AT 4TH AND 5TH STOP FROM BOTTOM. THE CRACKS WERE 1" LONG. THE CRACKED AREAS WERE REMOVED AND A DOUBLER WAS INSTALLED AT EACH LOCATION IAW SRM 51-70-11, FIGURE 1.SDR MWEA011470Skin · dentedFORWARD PASSENGER DOOR HAS A DENT ON EXTERNAL SKIN JUST AFT OF FORWARD VERTICAL FRAME BETWEEN #1 AND #2 HORIZONTAL BEAM -- REMOVED DAMAGED AREA, FABRICATED FAIRING, DOUBLER AND TAPERED SHIM. LOCATED, DRILLED AND INSTALLED REPAIR.SDR UPS01437358Handle · brokenINSPECTION TYPE:N/A L1 DOOR INNER HANDLE BROKEN. REMOVED AND REPLACED HANDLE IAW 52-11-13. HANDLE OPS CHECKS OK.SDR CA011130009Handle · failed(CAN) AIR TURNBACK DUE TO PASSENGER DOOR WARNING AND PAX DOOR STOW CAUTION MSG POSTED. AT 1,500 FT AGL PASSENGER DOOR UNSAFE CAUTION MESSAGE CAME ON. AT 10,000 FT RED PASSENGER DOOR WARNING MESSAGE WAS POSTED. RETURNED TO AIRPORT. INSPECTED PASSENGER DOOR FORSDR 2002F00218Strut · defectiveFLT NR 6253 - ON ARRIVAL IN DRO, THE CREW COULD ONLY GET THE PASSENGER DOOR TO OPEN ONE-THIRD OF THE WAY. MAINTENANCE REPLACED BOTH STRUTS. OPS CHECKS GOOD. (M)SDR SWAA013209Doubler · unsecureFWD ENTRY DOOR SCAB PATCH ON FWD LOWER CORNER COMING OFF. MX FERRY TO DAL. REMOVED OLD REPAIR AND INSTALLED REPAIR PER SRM.SDR PNSA011110Valve · contaminatedON CLIMBOUT AIRCRAFT WOULD NOT FULLY PRESSURIZE. AIRCRAFT MAINT CONTACTED AND AIRCRAFT RETURNED TO ANC. MAINTENANCE FOUND PAX DOOR SEAL NOT INFLATING. THAWED AND PURGED DOOR SEAL VALVE.SDR 2001UALA02330Door · crackedDOOR 1R LOWER FRAME OUTBOARD STOP FITTING CRACKED. MAJOR REPAIR ACCOMPLISHED.INSTALLED SPLICE REPAIR ON FRAME.SDR MWEA011456Beam · crackedMAIN CABIN DOOR BEAM NUMBER 7 HAS A CRACK ON AFT END -- STOP DRILLED CRACK. DRILLED UP NEW -53 DOUBLER. INSTALLED DOUBLER, FITTING AND DOOR STOP.SDR QXEA0101964Door · malfunctionedSEA- FLIGHT ATTENDANT UNABLE TO OPEN MAIN CABIN DOOR. INSPECTED MAIN CABIN DOOR AND ACTUATOR. NO DEFECTS NOTED. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR 2002F00027Bearing · damagedDURING CLIMB, L1 DOOR HAD LOUD NOISE WHILE PRESSURIZING A/C RETURNED TO CCS MTX REMOVED AND REPLACED BEARING AT L1 DOOR LOWER RAIL PER MM 52-10. AIRCRAFT PRESSURIZED AND CHECK NORMAL. AIRCRAFT RETURNED TO SERVICE. (M)SDR C2XA01CL231Pin · brokenCLE FLIGHT#3062 THE CREW REPORTED THE MAIN CABIN DOOR CATCHES WHEN BEING OPENED AND THE INTERIOR HANDLE APPEARED TO BE BROKEN.MAINTENANCE INSPECTED AND FOUND THE ROLL PIN FOR THE INTERIOR LOCKING HANDLE TO BE BROKEN. THEY REPLACED THE PIN AND FUNCTIONALY CHECKSDR HEEA077261Door · corrodedCORRODED AROUND BOTH LATCHES.SDR MWEA011454Former · elongatedPASSENGER DOOR INTERCOSTAL (FORMER) HAS ELONGATED ON END NEAR HOOK ACTUATOR CRANK -- LOCATED AND DRILLED HOLES IN NEW FORMER. INSTALLED INTERCOSTAL.SDR MWEA011451Beam · crackedMAIN CABIN DOOR BEAM NUMBER 5 IS CRACKED ON FORWARD END -- LOCATED, DRILLED AND INSTALLED NEW DOOR BEAM.SDR MWEA011449Beam · crackedMAIN CABIN DOOR BEAM NUMBER 8 HAS A CRACK ON FORWARD END -- REMOVED, DRILLED AND INSTALLED NEW BEAM.SDR QXEA0101960Door · leakingPDX-MAIN CABIN DOOR HAS SQUEAL AT ALL ALTITUDES. REPAIRED IAW HORIZON AIR EA R-53-08.SDR UPS01837316Door Frame · crackedINSPECTION TYPE:IN COCKPIT DOOR DAMAGED - CREW FWD ENTRY DOOR HAS A CRACK IN THE AFT DOOR FRAME NEAR LATCH. REMOVED 2 DOOR STOP FITTINGS AND FASTENERS 6 INCHES ABOVE AND BELOW DAMAGE. DYE PEN INSPECTED DAMAGED AREA. STOP DRILLED 1.125 INCH CRACK. VERIFIED SDR QXEA0101959Striker · damagedPDX-MAIN CABIN DOOR STRIKER DAMAGED MIDWAY ALONG FORWARD LENGTH OF DOOR APERTURE. REPAIRED IAW HORIZON AIR EA R-53-06.SDR USAA011387Skin · crackedTPA - FOUND SKIN .250 INCH, UPPER HINGE CUTOUT ON MAIN ENTRY DOOR. INSTALLED DOUBLER PER SB 737-52-1096 ALSO EA NR 94248. (M)SDR COMA0160911Door LatchFLIGH 6594 CABIN DOOR LATCH MESSAGE AFTER T/O.ADJUSTED DOOR LATCH LINKAGE. ACFT RETURNED TO SERVICE.SDR SWIA200110360Handle · defectiveAT 1500 FT AGL PASSENGER DOOR UNSAFE CAUTION AT 11,000 FT. RED PASSENGER DOOR UNSAFE MESSAGE. RETURNED TO AIRPORT. INSPECTED PASSENGER DOOR FOR LOOSE OR DAMAGED PARTS. REPLACED OUTER HANDLE AND INNER HANDLE DETENT ROLLER (CLEANED). PRESSURIZED TO APPROXIMSDR AWXA200100624Skin · dentedMCN - C12 CK - C - LOWER AFT CORNER OF L2 DOOR HAS 4.1 X .5 INCH DENT IN SKIN .031 INCH DEEP AT BS 986.5. MAINTENANCE REMOVED LOWER DOOR GATE AND CUT OUT DAMAGED PORTION OF EXTERNAL SKIN AND REMOVED BRACKET FROM INNER SKIN OF LOWER AFT CORNER L2 DOOR BS 986.5SDR GTIA012219Skin · damagedFTW - PREVIOUS REPAIR AT UPPER EDGE OF L1 DOOR NEEDS REPLACED, INADEQUATE REPAIR DOUBLER MATERIAL. REMOVED OLD REPAIR AND DAMAGED SKIN. INSTALLED FLUSH PATCH REPAIR ON L1 DOOR IAW DC9 SRM 53-05. (M)SDR 2002FA0000042Hook · malfunctionedNO FLAW FOUND ON LOCK HOOK. CANOPY SEPARATED FROM FUSELAGE IN STRAIGHT AND LEVEL FLIGHT.
Back to JASC 5210