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 MASA200700269Door · noneASH 2721 PHX - REPORTED HAVING TROUBLE OPENING THEIR PAX DOOR. MX OPENED THE DOOR NORMAL AND COULD NOT DUPLICATE THE DISCREPANCY.SDR QXEA200700841Handle · damagedC4 PDX - MAIN CABIN DOOR EXTERIOR HANDLE RUBBER BUMPER STOP MOUNT BOLT HOLE IN FUSELAGE IS OVERSIZED AND OVALED. REPAIRED IAW RD8/4-52-342.SDR TRAX200700676Doubler · crackedPAX DOOR CRACKED INSIDE ACCESS PANEL 832AR (UPPER FWD FRAME SUPPORT DOUBLER P/N:601R318094-2). OK FOR 600 FLIGHT HRS WITH A RE-INSPECTION AT EVERY 200 FLT HRS TO ENSURE CRACK LENGTH DOES NOT INCREASE. REFERENCE REO: 601R-52-11-1247. 10-18-07 REMOVEDSDR TRAX200700671Bracket · crackedDURING CRJ101 INSP INSIDE ASD ACCESS PANEL 832AR, FOUND UPPER FWD ASD FRAME BRACKET CRACKED.SDR ASAA0741642Bearing · erodedCATERING REPORTED THE L1 DOOR INOPERABLE. FERRIED TO SEA, REMOVED AND REPLACED R1 DOOR PER AMM.SDR SWIA200718243Seal · damagedCABIN DOOR AFT STRIKER SEAL HAS DAMAGE THAT IS OUT OF LIMITS. REPAIRED AFT STRIKER SEAL PER REO 601R53-22-033 TYPE 3 REPAIR, M-337, COMPLETED.SDR DXTA200702196Seal · unknownCABIN DOOR SEAL MESSAGE ILLUMINATED 1 HOUR AND 20 MINUTES INTO FLIGHT AT FL430, SHORTLY THERE AFTER IT COMMENCED TO SQUEALING VERY LOUD. SQUEALING QUIT AROUND FL180 DURING DESCENT. EMERGENCY DECLARED. COULD NOT DUPLICATE "CABIN DOOR SEAL" CAS MESSAGE. PERFSDR MASA200700267Cam Roller · crackedASH 2748 PHX - MAIN PAX DOOR WILL NOT OPEN OR CLOSE. MX FOUND CAM ROLLER CRACKED AND CHANGED OUT.SDR MASA200700268Roller · lack of lubeASH 7144 IAD - MAIN DOOR HANDLE DIFFICULT TO OPERATE. MX LUBED DOOR ROLLERS AND OPS CHECKED.SDR 2007UALA01510Bottle · low pressureDOOR 3L OPEN ASSIST PRESSURE IS IN RED ZONE. [SUP 06-06-07] REPLACED BOTTLE.SDR TRAX200700668Door · stiffF/A REPORTS PAX DOOR HARD TO OPEN FROM THE INSIDE.SDR TRAX200700664Door · stuckPAX DOOR WOULD NOT OPEN WITH OUTER HANDLE.SDR SWIA200718357Web · crackedPASSENGER DOOR FORWARD WEB IS CRACKED, DISCOVERED AT C-CHECK. INSTALLED DOUBLER REPAIR ANGLE IAW CRJ700 SRM 51-42-21.SDR SWIA200718356Web · crackedPASSENGER DOOR AFT WEB IS CRACKED UNDER THE HANDRAIL STOW BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS AND DOUBLER IAW CRJ700 REO 670-52-11-104 REV B.SDR MASA200700257Door · noneASH 2750 PHX - CREW UNABLE TO OPEN MAIN CABIN DOOR FROM INSIDE. MX OPENED DOOR AND FOUND NO FAULTS. OPS CHECKED NORMAL.SDR MASA200700256Counterbalance · out of adjustASH 2627 CLT - PAX DOOR HARD TO OPEN. ADJUSTED COUNTER BALANCE.SDR CPCP20070041Support · corrodedTHREAD SUPPORT NR 1 (BOTTOM) OF PASSENGER DOOR STAIRCASE IS CORRODED UNDER NUT PLATES. THREAD SUPPORT NR 1 FROM BOTTOM REPLACED AS PER SRM 51-25-01.SDR A6WA200740242Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED. (K) [07-17-07] MAINTENANCE REMOVED DAMAGED SECTION OF DRAG ANGLE AND INSTALLED SERVICEABLE SECTION IAW BOMBARDIER REO 601R-52-11-513. (M)SDR TRAX200700657Handle · crackedPAX DOOR OUTER HANDLE CRACKED. [SUP 05-24-07] REMOVED CRACKED OUTER PAX DOOR HANDLE, IAW CRJ 700 AMM 52-11-03. REMOVED SERVICEABLE PAX DOOR HANDLE FLAP, P/N 601R317045-1 FROM UNSERVICEABLE OUTER PAX DOOR HANDLE, IAW CRJ 700 SRM 51-42-06. OKAY TO INSTALL HANDSDR MASA200700255Strut · brokenASH 2897 DRO - PASSENGER DOOR AFT STRUT BROKEN. REMOVED & REPLACED AFT UPPER STRUT.SDR USAA070368Skin · crackedFWD & AFT OK NR 5 STOP PIN ACCESS HOLE ON AFT SIDE OF TORQUE BOX HAS CRACK. INSTALLED EXTERNAL DOUBLER PER TYP REP 52-10-16, DEFECT SIZE: .5 INCH.SDR MASA200700290Skin · crackedPAX DOOR OUTER SKIN HAS A TEMPORARY REPAIR PERFORMED TO THE LOWER AFT CORNER OUTER SKIN. PERFORMED A PERMANENT REPAIR BY REMOVING DAMAGE AND INSTALLING A FLUSH REPAIR.SDR MASA200700251Cover · misalignedASH 7227 ORD - PAX DOOR WOULD NOT OPEN. CREW REPORTED THE DOOR WOULD OPEN ABOUT 8 INCHES AND STOP. MX FOUND THE DOOR ASSIST SWITCH COVER WAS MISALIGNED AND APPLYING PRESSURE TO THE SWITCH. MX REALIGNED THE COVER TO THE PROPER POSITION AND THE DOOR ASSIST SYSDR DLM88070519Skin · gougedFOUND ON ARRIVAL DAMAGE 2 FT AFT 1L DOOR AT FLOOR LEVEL A 5 INCH BY 1 INCH GOUGE. REPAIRED PER SRM 53-04D PAGE 33 ITEM B CLASS 1 REPAIR. WHILE DOWN FOR REPAIR ALSO WORKED MSU C/N C05037125 ACTL 3102 FOR PREVIOUS DAMAGE INCORP, ORATING A FOUR CORNER DOUBLER RSDR TRAX200700639Drag Angle · crackedPAX DOOR AFT DRAG ANGLE CRACKED (MARKED). [SUP 05-17-07] CUTOUT DAMAGED SECTION OF PAX DOOR AFT DRAG ANGLE IAW REO 670-52-11-072. DC699 5-14-07.SDR WRLA2007067Skin · deformedDURING PERFORMING 4C CHECK OF DATUM A/C, EGAT FOUND A DEFORMATION ON RIGHT FORWARD PASSENGER DOOR SKIN AFT UPPER CORNER. TRIM OUT DAMAGED AREA AND INSTALL FILLER AND EXTERNAL DOUBLER PER SRM 52-10-00 FIGURE 10.SDR TRAX200700618Handle · crackedASD OUTER HANDLE CRACKED. [SUP 05-14-07] REMOVED AND REPLACED HANDLE IAW CRJ 700 AMM 52-11-03. OPS CK GOOD IAW CRJ 700 MM 52-11-03 MS 23531.SDR QXEA200700716Ditching Dam · malfunctionedPDX FLIGHT NR 2262: MAIN CABIN DOOR DITCHING DAM FELL OFF. AIRCRAFT RETURNED TO GATE. MAINTENANCE RESET THE DITCHING DAM WITH NO OTHER DEFECTS NOTED. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR CA070511011Handle · cracked(CAN) DURING ROUTINE MAIN CABIN DOOR INSPECTION FOUND MAIN CABIN PHASE IV DOOR HANDLE WITH (2) CRACKS. DOOR HANDLE REPLACED. AIRCRAFT RETURNED TO SERVICE (TC NR 20070511011)SDR 2007UALA01387Lever · stiffDOOR 1L DOES NOT ARM, LEVER IS STIFF. [SUP 06-06-07] GIRT BAR LIFT SPRING WAS JAMMED REPLACED LEFT DOOR GIRT BAR AND BAR LOCK AND REPLACED LEFT DOOR ASSIST BOTTLE.SDR 050207Rod End · brokenCABIN DOOR DEPARTED AIRCRAFT IN FLIGHT DUE TO THE ROD END HINGE FAILURE. IT APEARS THE ROD END FAILED DUE TO FATIGUE. THE ROD END SHOULD BE MADE OF A STRONGER MATERIAL.SDR SWIA200718275Step · crackedPAX DOOR UPPER MID STEP IS CRACKED ON AFT SIDE, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND DOUBLER PER CRJ700 REO 670-52-11-104 AND SRM 51-12-06.SDR SWIA200718274Step · crackedPAX DOOR UPPER MID STEP IS CRACKED ON FORWARD SIDE, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND DOUBLER PER CRJ700 REO 670-52-11-104 AND SRM 51-42-06.SDR NOCA10007Gust Lock · brokenL2 DOOR GUST LOCK ASSY BROKEN. INSTALLED GUST LOCK ASSY PER MM 52-11-08. RE-ACCORD ON 5-13-07 L2 DOOR GUST LOCK ASSY BROKEN. SDR REMAINS OPEN.SDR 2007UALA01376Structure · crackedCABIN DOOR 2 RIGHT CUTOUT FOR UPPER HINGE HAS 0.25 INCH CRACK. [SUP 06-06-07] INSTALLED A DOUBLER REPAIR ON THE AFFECTED AREA WITH BOEING APPROVED UA ENGINEERING SPECIFICATION.SDR CALA0700223Stop Fitting · crackedINSPECTION FOUND A 1" CRACK IN L-1 DOOR TOP AFT STOP FITTING. THE STOP FITTING WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR QXEA200700691Cam Roller · lack of lubeSEA FLIGHT: FLIGHT ATTENDANT REPORTS LEFT REAR PAX DOOR DIFFICULT TO OPEN. MAINTENANCE LUBRICATED LEFT REAR PAX DOOR CAM ROLLERS. OPERATED SEVERAL TIMES. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED. NO PARTS REPLACED. AIRCRAFT RETURNED TO SERVICE.SDR GUUA04300702Retainer · looseCABIN DOOR HANDLE BROKEN. RESECURED CABIN DOOR OUTER HANDLE.SDR 2007UALA01367Door Frame · crackedNR 2 LEFT DOOR FWD FRAME CUTOUT FOR UPPER HINGE CRACKED. [SUP 06-06-07] INSTALLED A DOUBLER REPAIR ON THE AFFECTED AREA WITH BOEING APPROVED UA ENGINEERING SPECIFICATION.SDR A6WA200740231Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE CRACKED APPROX .5 INCHES LONG AT DOOR ASSIST CABLE PULLEY BRACKET. (K) [07-17-07] MAINTENANCE CUT AWAY CRACKED ANGLE AND INSTALLED REPAIR ANGLE IAW BOMBARDIER REO 601R52-11-513 REV A. (M)SDR SWIA200718307Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT HANDRAIL SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS PER REO 670-52-11-104 (B) NOTES 1-10,15.SDR SWIA200718306Web · crackedPAX DOOR AFT WEB IS CRACKED AT HANDRAIL SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS AT PAX DOOR AFT WEB PER REO 670-52-11-104.SDR 2007UALA01348Door Frame · crackedR-2 DOOR FRAME IS CRACKED AT UPPER HINGE CUTOUT, .25 INCH LONG, FOUND AT THE 7 O'CLOCK POSITION. MAJOR REPAIR ACCOMPLISHED: CUT OUT DAMAGED AREA. FABRICATED & INSTALLED A CRES DOUBLER.SDR AALA20070768Accumulator · low pressureMIA - LEFT NUMBER ONE DOOR EMERGENCY NITROGEN BOTTLE DAMPER ACCUMULATOR POUNDS PER SQUARE INCH IS BELOW LIMIT. SERVICED LEFT NUMBER ONE DOOR EMERGENCY NITROGEN BOTTLE DAMPER ACCUMULATOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR QXEA200700755Door · corrodedC4 PDX - LOWER SURFACE OF MAIN CABIN DOOR HAS CORROSION IN SEVRAL PLACES. REPAIRED IAW SRM 51-21-00, 51-42-05 AND RD8/4-53-1892.SDR 2007UALA01342Indicator · sticksCREW REPORTS DOOR 4L WILL NOT ARM AT DEPARTURE. [SUP 06-06-07] DOOR FOUND TO ARM AND DISARM NORMAL. LUBE INDICATOR ARM POP OUT WAS STICKING AND APPEARED TO HAVE CAUSED THE PROBLEM WITH ARMING.SDR 2007UALA01361Handle · out of positionDOOR 2L OUTSIDE DOOR HANDLE CAME OUT OF STOWED POSITION DURING FLIGHT. [SUP 05-16-07] CAUSE UNKNOWN. ALL CHECKS WERE NORMAL.SDR 2007UALA01343Structure · crackedDOOR 2L HAS HALF INCH CRACK AT UPPER HINGE CUTOUT. MAJOR REPAIR ACCOMPLISHED: REMOVED DAMAGED AREA. INSTALLED CRES DOUBLER REPAIR.SDR GTIA200700016Hook · dirtyL1 DOOR WILL NOT LOCK OPEN. REMOVED DOOR STAY MECHANISM , CLEANED DEBRIS FROM MECHANISM, REINSTALLED STAY MECHANISM.SDR 2007F00036Door · crackedDURING SCHEDULED A, B, & C INSPECTION FOUND CABIN ENTRANCE DOOR CASE ASSEMBLY P/N: 45A30096 CRACKED AT DOOR BUSHING HOLES. CASE ASSEMBLY IS NONE REPAIRABLE AND REQUIRED REMOVAL AND REPLACEMENT WITH NEW. THE NEW CASE ASSEMBLY CAUSE A INTERFERENCE FIT WITH THE D
Back to JASC 5210