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 COMA0760610Switch · lack of lubeFLIGHT 4956 - OVERBOARD COOL CAUTION ON CLIMBOUT. AIRCRAFT RETURNED TO CVG AND LANDED SAFELY. CLEANED AND LUBRICATED PAX DOOR OUTER HANDLE MICRO SWITCH DI 13. OPS CHECK GOOD.SDR QXEA200701622Door · stiffLAX FLIGHT NR 2469: LEFT REAR PAX DOOR DIFFICULT TO OPEN AND CLOSE. MAINTENANCE PERFORMED VISUAL INSPECTION OF THE AFT PAX DOOR AND SURROUND INSIDE AND OUTSIDE. NO DEFECTS WERE NOTED. PERFORMED OPS CHECK OF AFT ENTRY DOOR IAW Q400 AMM TASK 52-12-00-710-801.SDR 2007UALA04392Line · disconnectedEMERGENCY POWER RESERVOIR LINE WAS NOT CONNECTED TO DOOR ASSIST PRESSURE BOTTLE DOOR 2R.SDR MASA200700730Handle · lockedASH 7264 - ORD - HAVING TROUBLE CLOSING THE PAX DOOR OUTER HANDLE. MX CLEARED THE HYDRO LOCK AND THE DOOR OPERATED NORMALLY.SDR MALA070170Skin · dentedMAIN ENTRY DOOR OUTER SKIN DENT AT 27.5" ABOVE DOOR SKIN LOWER EDGE AND 5.50" AFT OF DOOR FWD EDGE. REPAIR PER IAW EO NR S52089 AND SAAB REPAIR STATEMENT 340SDS012743.SDR SWAA075252Skin · crackedDURING SCHEDULED 24Y CHECK, FOUND L1 DOOR CENTER SKIN CRACKED AT LOWER END. REPAIRED SKIN PER SRM.SDR FDKA200710564Latch · unsecureFDM 6157 MCO (0630 PHX LCL) - MAIN CABIN DOOR DIFFICULT TO LATCH CLOSE. MX RESECURED LUBED AND ADJUSTED. OPS GOOD.SDR USAA920071009Stop Fitting · crackedCLT - MAJOR REPAIR - C20 CHECK, FORWARD ENTRY DOOR STOP FITTING CRACKED, BS 328, 4TH ONE FROM THE BOTTOM. REPAIRED FORWARD ENTRY DOOR STOP FITTING, BS 328, 4TH ONE FROM THE BOTTOM IAW B737-300 SRM 51-70-11.SDR TRAX200701571Skin · crackedPAX DOOR INNER SKIN CRACKED TWO LOCATIONS AROUND NUT PLATE HOLES FWD TOP AREA.SDR FDKA200710562Door · lack of lubeFDM 6008 JFK (0426 PHX LCL) - MAIN CABIN DOOR HARD TO CLOSE. MX LUBED DOOR, OPS CK GOOD.SDR MASA200700721Door · malfunctionedASH FLT 7126 IAD PAX DOOR WILL NOT LOCK. MX COULD NOT DUPLICATESDR RAIA00710022Door · lack of lubePRE FLT NR 7908 - ORD - PAX DOOR WILL NOT OPEN ALL THE WAY. MAINTENANCE LUBED PAX DOOR AND OPS CHECKED SEVERAL TIMES. OPS CHECKS GOOD.SDR TRAX200701538Skin · crackedPAX DOOR STAIRS FWD SKIN IS CRACKED IN RADIUS UNDER STEP 832DT. 10-30-07 REMOVED DAMAGE SECTION OF PAX DOOR STAIRS SKIN UNDER FWD STEP 832 DT IAW REO 601R-52-11-702. CUTOUT REQUIRES LPI OF THE EDGES. PERFORMED LPI OF THE PAX DOOR STAIRS FWD SKIN UNDER STSDR TRAX200701537Skin · crackedPAX DOOR STAIRS AFT SKIN IS CRACKED IN RADIUS UNDER STEP 832DT. 10-30-07 REMOVED DAMAGE SECTION OF AFT PAX DOOR STAIRS SKIN UNDER STEP 832DT IAW REO 601R-52-11-702. CUTOUT REQUIRES LPI OF THE EDGES. PERFORMED LPI ON THE PAX DOOR STAIRS AFT SKIN UNDER STESDR TRAX200701536Handle · crackedPAX DOOR OUTER HANDLE IS CRACKED. 11-01-07 REMOVED UNSREVICEABLE PAX DOOR OUTER HANDLE ASSY IAW CRJ 200 AMM 52-11-03-020-007. INSTALLED NEW SERVICEABLE SLEX HANDLE ON NEW SERVICEABLE HANDLE IAW CRJ 200 SRM 51-42-06. INSTALLED THE REMAINDER OF HARDWARE ONSDR RAIA00710020Stop · out of positionPOST FLT NR 5461 - STL - PAX DOOR DIFFICULT TO OPEN. MAINTENANCE ADJUSTED PHENOLIC STOP ON UPPER FWD SIDE OF FUSELAGE ENTRY AREA. OPS CHECK GOOD.SDR FDKA200710556Door · lack of lubeFDM 6016 JFK (1229 PHX LCL) MAIN CABIN DOOR STICKS AND IS HARD TO OPEN, MX LUBED DOOR OPS CHECKED GOOD.SDR F3LA200700297Blanking Plate · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED CORROSION ON R1 DOOR GIRT BAR FITTING AFT BLANKING PLATE. REPLACED R1 DOOR AFT GIRT BAR FITTING BLANKING PLATE IAW AMM 53-11-31-PB401.SDR SWIA200718801Hinge · bindingFLT 5440 - MAIN CABIN DOOR IS HARD TO OPEN AND CLOSE. REPLACED BOTH PAX DOOR HINGES IAW EMB 120 MM 52-10-00. OPS CHECK GOOD.SDR SWAA075146Door Frame · crackedDURING SCHEDULED BRDG CHECK, FOUND L1 DOOR FWD FRAME CRACKED AT SNUBBER CUTOUT. REMOVED AND REPLACED DOOR PER MM.SDR TRAX200701513Drag Angle · crackedAAR - PAX DWR AFT DRAG ANGLE CRACKED. 10-30-07 CUT AWAY DAMAGED SECTION OF AFT DRAG ANGLE AND REMOVED BURRS AND SHARP EDGES IAW BOMBARDIER REO 601R-52-11-513, PERFORMED LPI PER NDTM 51-20-08 ON REORKED AREAS AND CUTOUT EDGES OF PAX DOOR AFT DRAG ANGLE IASDR TRAX200701512Anchor Fitting · crackedPAX DOOR FWD ANCHOR FITTING IS CRACKED. 11-01-07 REMOVED UNSERVICEABLE PAX DOOR FWD ANCHOR FITTING IAW CRJ 200 AMM 52-11-17-400-803. OK TO INSTALL. INSTALLED FWD ANCHOR FITTING P/N 601R38074-6 PO 95-1202 IN SERVICEABLE CONDITION IAW CRJ 200 AMM STILL REQSDR KCSA071475Web · corrodedL-1 DOOR INNER WEB CORRODED INSIDE DOOR AT STA 445 WL 251.SDR TRAX200701509Door · malfunctionedCABIN DOOR WON'T OPEN FROM OUTSIDE.SDR TRAX200701504Handle · crackedASD EXTERNAL HANDLE CRACKED. 10-26-07 REMOVED AND REPLACED ASD EXTERNAL HANDLE IAW CRJ SRM 51-40-11, 51-25-06,51-25-16 AND CRJ 700 MM 25-11-03.SDR FDKA200710547Seal · lack of lubeFDM 6073 JFK - MAIN CABIN DOOR HAVE LOUD SQUEAL. MX CLEANED AND LUBED DOOR SEAL.SDR FDKA200710549Seal · leakingFDM 6014 PWM - MAIN CABIN DOOR SQUEALING IN FLIGHT. MX REPAIRED DOOR SEAL LEAK CHECK GOOD.SDR FDKA200710548Door · lack of lubeFDM 6073 JFK - MAIN CABIN DOOR HAVE LOUD SQUEAL. MX CLEANED AND LUBED, OPS CHECKED GOOD.SDR MASA200700700Panel · crackedPAX DOOR FWD AND AFT SIDE PANEL CRACKED AT 2ND STEP.SDR MASA200700694Cam · lack of lubeASH 7319 - IAD - REPORTED HAVING TROUBLE CLOSING THE PAX DOOR. MX LUBED THE CAMS AND ROLLERS, AND WERE ABLE TO CLOSE THE DOOR NORMALLY.SDR SWIA200718775Stop · out of adjustFLT 5774 - MAIN CABIN DOOR IS DIFFICULT TO OPEN. ADJUSTED MAIN CABIN DOOR BACKSTOPS IAW MM 52-11-00.
SDR MASA200700686Handle · out of adjustASH FLT 2894, PHX - OUTER DOOR HANDLE WILL NOT CLOSE. MX ADJUSTED INNER DOOR STOW HANDLE.SDR 2007UALA04204Cylinder · reads lowDOOR 2R EMERGENCY CYLINDER ACCUMULATOR PRESSURE IS LOW. 10-26-07 SERVICED CYLINDER- NO REPEATS.SDR 2007UALA04171Door · out of rigDOOR 2L HANDLE LIFTS IN FLIGHT CAUSING AFT SERVICE DOOR WARNING LIGHT TO ILLUMINATE. SUSPECT DOOR OUT OF RIG. ACCOMPLISHED SERVICE TIP 52-00-96-101. ADJUSTED DOOR STOPS. AC OK FOR SERVICE.SDR SWAA075036Skin · crackedDURING SCHEDULED HC1 CHECK, FOUND L2 DOOR SKIN CRACKED AT LOWER AFT CORNER. REPAIRED SKIN PER SRM.SDR KCSA071461Structure · corrodedR-4 DOOR LOWER FWD CORNER HORIZONTAL CHORD HAS CORROSION STA 1680 WL 206.SDR QXEA200701565Angle · crackedPDX - C4 CHECK,FORWARD PASSENGER DOOR INNER DOOR SKIN TO STEP ASSEMBLY ANGLE IS CRACKED, AFT MID DOOR. REPAIRED THE CRACKED ANGLE BY INSTALLING SPLICE ANGLE IAW REO 670-52-11-072.SDR ABXA070352Fitting · crackedMAIN ENTRY DOOR UPPER SEAL DEPRESSOR HINGE DRIVE FITTING WAS CRACKED. REMOVED AND REPLACED UPPER SEAL DEPRESSOR HINGE DRIVE FITTING IAW DC9 SRM 51-30-04.SDR TRAX200701488Handle · malfunctionedMAIN DOOR HANDLE WOULD NOT TURN FROM OUTSIDE.SDR TRAX200701487Door · bindingF/A REPORTS MAIN CABIN DOOR HARD TO OPEN.SDR FDKA200710532Bearing · stickingFDM 6085 MCO (0815 PHX LCL) - MAIN CABIN DOOR HANDLE STICKS. MX INSTALLED BEARING ON DOOR. OPS GOOD.SDR SWIA200719010Control Rod · corrodedFOUND C-CHECK, PAX DOOR LOWER LOCK MECHANISM CONTROL ROD IS CORRODED. REMOVED CORROSION FROM LOWER LOCK MECHANISM IN CONTROL ROD PER CRJ700 SRM 51-21-11-001-001-A01.
SDR ABXA070356Repair · crackedMAIN ENTRY DOOR FORWARD LOWER CORNER REPAIR CRACKED. REMOVED AND REPLACED REPAIR IAW DC9 SRM 52-01 FIG 4.SDR ABXA070357Angle · crackedMAIN ENTRY DOOR UPPER AFT CORNER, ANGLE CRACKED INSIDE LIGHTENING HOLE. REPAIRED MAIN ENTRY DOOR UPPER AFT ANGLE IAW DC9 SRM.SDR 2007UALA04116Battery Pack · faultyFOUND DOOR 2R EPAS BITE LIGHT IS NOT BLINKING GREEN. REPLACED EPAS BATTERY PACK. OP CHECK OK FOR SERVICESDR SWIA200719130Handle · crackedPAX DOOR EXTERIOR HANDLE IS CRACKED, FOUND AT C-CHECK. REPLACED PAX DOOR OUTSIDE HANDLE PER CRJ200 AMM 52-11-03-020-007.
SDR DXTA200702529Handle · out of adjustTHE CABIN DOOR ANNUNCIATOR ILLUMINATED WHILE PASSING FL190. 10-29-07 ADJUSTED DOOR HANDLE SWITCH AND LUBED DOOR PINS. IAW CE-560XL M.M. 52-10-01. OP'S CHECK NUMEROUS TIMES. OP'S CK GOOD.SDR FDKA200710523Door · malfunctionedFDM 6000 ATL (0653 PHX LCL) - MAIN CABIN DOOR WILL NOT CLOSE. MX COULD NOT DUPLICATE, OPS CK GOOD.SDR TRAX200701474Unknown · bindingF/A REPORTS MAIN CABIN DOOR HARD TO OPEN AND CLOSE.SDR SWIA200718763Switch · dirtyFLT 6515 - COULD NOT OPEN PAX DOOR AT THE GATE. CLEANED DOOR POWER ASSIST BUTTON. OPS CHECKS GOOD.
Back to JASC 5210