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 SWIA200718759Switch · dirtyFLT 3681 - CABIN DOOR WOULD NOT OPEN FOR DEPLANEMENT. CLEANED THE DOOR "CLOSE" SWITCH. OPS CHECK GOOD.SDR 2007UALA04063Hinge · crackedFWD ENTRY DOOR CUTOUT LWR HINGE HAS 2 FASTENER HOLES CRACKED. AFT ROW 1 ABOVE AND 1 BELOW HINGE CUTOUT. FABRICATED AND INSTALLED EXTERNAL SKIN DOUBLER REPAIR.SDR A6WA200740562Panel · crackedPAX DOOR STAIR FORWARD SIDE PANEL IS CRACKED IN ZONE 2 AND 3 APPROX .250 INCH LONG IN RADIUS. MAINTENANCE REPAIRED ZONES 2 AND 3 ON PAX DOOR FORWARD SIDE PANEL IAW BOMBARDIER REO 601R-52-11-702 AND BSC EO 601R-52-13411A. (M)SDR A6WA200740561Panel · crackedPAX DOOR STAIR AFT SIDE PANEL IS CRACKED IN ZONES 2 AND 3 APPROX .250 INCH LONG IN RADIUS. MAINTENANCE REPAIRED ZONES 2 AND 3 ON PAX DOOR AFT SIDE PANEL IAW BOMBARDIER REO 601R-52-11-702 AND BSC EO 601R-52-13410. (M)SDR 2007UALA04055Reservoir · failedFOUND DOOR 4R POWER ASSIST RESERVOIR SQUIB FAILS TEST. REPLACED DOOR ASSIST RESERVOIR. BITE TEST OK FOR SERVICE.SDR TRAX200701469Step · crackedPAX DOOR BOTTOM STEP CRACKED AND LOOSE AT ROD END ATTACH POINT.SDR TRAX200701468Structure · crackedASD CRACKED UNDER TOP STEP AFT AREA.SDR TRAX200701467Drag Angle · crackedASD AFT DRAG ANGLE CRACKED.SDR TRAX200701464Intercostal · crackedAFT INTERCOSTAL OF ROLLER STOP, PAX DOOR CRACKED. 10-9-07 ROLLER STOP OF PAX DOOR RAI FOM IAW AMM 20-21-12. AFT INTERCOSTAL OF ROLLER STOP REPLACED AS PER SRM 51-25-01 REPAIR DETERMINED NOT TO BE A MAJOR REPAIR IAW S.P. 663 AND FAR 43, APPENDIX A. REPSDR 07FDEA04462Channel · dentedLT AFT CREW DOOR LOWER CHANNEL HAS A NOTCH OUT OF LIMIT REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR CA071004003Arm · cracked(CAN) DURING ROUTINE DAILY INSP, FOUND LOWER DOOR AFT LATCH ARM CRACKED ALL THE WAY THROUGH DUE TO CORROSION FATIGUE. (TC NR 20071004003)SDR FDKA200710514Roller · disconnectedFDM 6024 BHM (0333 PHX LCL) - MAIN CABIN DOOR WILL NOT OPEN. MX FOUND TOP FORWARD HOOK OVER ROLLER. DISCONNECTED, UNJAMMED DOOR AND RECONNECTED HOOK. OPS CK GOOD.SDR FDKA200710513Door · malfunctionedFDM 6153 MCO (0822 PHX LCL) - MAIN CABIN DOOR WILL NOT CLOSE/SEAL ENTIRE TOP. MX COULD NOT DUPLICATE, DOOR OPS CHECKED AND SEALED GOOD.SDR DLM88071461Angle · crackedCRACK ON RT FWD SERVICE DOOR R1 AT AFT UPPER CORNER OF BEAM NR 1 ANGLE. REPLACED ANGLE PER DWG 9919579.SDR TRAX200701458Door · stiffFLIGHT ATTENDANT REPORTS, PAX DOOR DIFFICULT OPEN FROM INSIDE.SDR TRAX200701457Door · stickingPAX DOOR DIFFICULT TO OPEN FROM INSIDE.SDR TRAX200701455Skin · crackedSUSPECTED CRACK ON VERTICAL SKIN OF PAX DOOR STEP 832 AT. 10-11-07 HFEC PERFORMED, CRACK CONFIRMED AND MARILED ON THE PART. CRACK ON VERTICAL SKIN OF PAX DOOR STEP 832 AT REPAIRED IAW SRM 51-12-00 FIG 7.SDR TRAX200701447Handle · stuckF/A REPORTS, CABIN DOOR HANDLE WOULD NOT GO ALL THE WAY UP. TOOK 4X TO GET DOOR OPEN.SDR UPS07850885Web · crackedINSPECTION TYPE:C2 L-1 DOOR LWR WEB IS CRACKED AT EDGE. STOP DRILLED CRACK IN WEB AT L-1 DOOR. FABRICATED, AND INSTALLED REPAIR DOUBLER AT L-1 DOOR LWR WEB IAW SRM 52-02-00, AND SRM 52-03-00.SDR TRAX200701442Drag Angle · crackedASD AFT DRAG ANGLE IS CRACKED (MTC).SDR TRAX200701444Handle · lack of lubeF/A REPORTS, DOOR MAIN CABIN NOT ALIGNED AND DIFFICULT TO CLOSE. LUBE UP PAX STOW HANDLE. OPS CHECK GOOD. NO DEFECTS NOTED IAW CRJ 200 700 52-12-00. ALL TOOLS AND EQUIP REMOVED.SDR FDKA200709510Door · unsecureFDM RON RDU - LOUD SQUEAL FROM MAIN PAX DOOR ON DESCEND. MX RESEATED DOOR SEAL IN TRACK.SDR TRAX200701439Handle · stuckCABIN DOOR HANDLE WILL NOT GO UP IN ORDER TO OPEN. FLT 4509 DEL 22 MINS.SDR TRAX200701435Handle · stiffMAIN AIRSTAIR DOOR HARD TO OPEN. WITH AP SHOWING 0.0 (AIRCRAFT DEPESSURIZED) THERE IS A PRESSURIZATION SPIKE & IT TAKES ABOUT 20 SECONDS FOR F/A TO OPEN THE DOOR. THE F/A STATED THAT THE HANDLE WON'T PULL FULLY UP.SDR KCSA071431Structure · crackedR1 DOOR FWD LOWER CORNER HAS 2 INCH CRACK IN HORIZONTAL CHORD.SDR FDKA200709508Door · lack of lubeFDM 6192 BOS (1621 PHX LCL) - MAIN PAX DOOR HARD TO OPEN. MX INSPECTED, CLEANED AND LUBED OPS CHECKED GOOD.SDR SWIA200718736Handle · out of adjustFLT 3693 - MAIN CABIN DOOR HANDLE DOES NOT OPEN OR CLOSE EASILY. ADJUSTED TOP/AFT STOP HARDWARE AS REQUIRED IAW 52-10-00.
SDR TRAX200701446Web · crackedPAX DOOR IN AREA OF ACCESS PANEL 832AL WEB FOUND CRACK. 10-16-07 REPAIRED CRACK FOUND IN PAX DOOR IN AREA OF ACCESS PANEL 832AL WEB AS PER 51-12-11 FIG 6.SDR DLM90071282Structure · bentL-1 DOOR LOWER LIP IS BENT IN 2 PLACES. REPAIRED LOWER LIP IAW MD-90 SRM VOL 2 51-30-01 AND 52-10-01 FIG 2 VOL 1 ON N/R 62422 AT HMV-2 IN OKC.SDR TRAX200701416Door · stuckPAX ENTRY DOOR WOULD NOT CLOSE.SDR SWAA074852Frame · crackedDURING SCHEDULED 8Y CHECK, FOUND R1 DOOR FWD LOWER STUB FRAME CRACKED AT STR 17R. REPAIRED FRAME PER SRM.SDR CALA0700542Pan · crackedINSPECTION FOUND A .75 INCH CRACK IN L-1 DOOR PAN ON AFT SIDE AT 5TH DOOR STOP FROM BOTTOM. THE DOOR PAN WAS REPAIRED IAW ECRA 5210-01954.SDR 07FDEA04335Beam · corrodedCORROSION FOUND ON LT FWD PAX DOOR, BEAM NR 1. REPAIR PERFORMED BY BLEND OUT CORROSION, NDT INSPECTION FOR CRACK FREE CONDITION IAW EA 6-5211-92172 AND RAS/AS/215/2005 ISSUE A.SDR FDKA200709506Door · lack of lubeFDM 6088 MCO (0810 PHX LCL) - PASSENGER DOOR HARD TO OPEN AND CLOSE. MX LUBED PASSENGER DOOR, OPS CK GOOD.SDR TRAX200701421Anchor Fitting · crackedAAR - THE PAX DOOR FWD ANCHOR FITTING IS CRACKED. 10-11-07 UPON FURTHER INVESTIGATION FOUND PAX DOOR FWD ANCHOR FITTING STOP PLATE COVER TO BE CRACKED AND FOUND PAX DOOR FWD ANCHOR FITTING TO BE SERVICEABLE. REMOVED UNSERVICEABLE STOP FITTING. INSTALLED SDR TRAX200701412Door · stuckPAX DOOR WILL NOT OPEN.SDR 1218341121907Skin · puncturedPASSENGER DOOR EXTERNAL SKIN PUNCTURED. EXTERNAL SKIN REPAIRED PER SRM 52-00-00.SDR SWIA200718754Cable · bindingFLT 6729 - MAIN CABIN DOOR WOULD NOT OPEN ON ARRIVAL. FOUND DOOR ASSIST CABLE BINDING ON PULLEYS. REPLACED PULLEYS AND DOOR MOTOR ASSEMBLY IAW AMM 52-11-08.SDR TRAX200701402Door · stuckFLT ATTENDANT REPORTS FORWARD PASSENGER DOOR REQUIRED EXCESSIVE FORCE TO OPEN. DOOR HUNG UP ABOUT HALF WAY DOWN.SDR TRAX200701398Handle · crackedPAX DOOR EXTERNAL HANDLE CRACKED. 10-11-07 REMOVED UNSERVICEABLE EXTERNAL PAX DOOR HANDLE AND INSTALLED SERVICEABLE EXTERNAL PAX DOOR HANDLE ASSY IAW CRJ 200 AMM 52-11-03.SDR KCSA071399Frame · crackedNR 5 RIGHT MAIN ENTRY DOOR LOWER FWD CORNER VERTICAL CHORD HAS A 1 INCH CRACK.SDR FDKA200709484Door · lack of lubeFDM 6061 MCO (0621 PHX LCL) - MAIN CABIN DOOR STICKING. MX LUBED DOOR OPS CK GOOD.SDR TRAX200701387Bracket · crackedBRACKET AFT OF ASD BOTTOM STEP IS CRACKED.SDR KCSA071393Attach Angle · corrodedR-5 DOOR HAS CORROSION ON ATTACH ANGLE BELOW LOWER HINGE CLOSE OUT WEB STA 2250.SDR 07FDEA04229Fitting · corrodedFOUND CORROSION SPOT ON LT FWD PAX DOOR FITTING AT XP715 BETWEEN BEAMS 3 AND 5. REPAIR PERFORMED BY CUTTING-OUT THE FITTING WEB IN ORDER TO REMOVE CORROSION AND PERFORMING HFEC INSPECTION OF THE REWORKED AREA, INSTALLING REPAIR DOUBLER WITH MONEL RIVETS IAW ESDR A6WA200740567Skin · crackedPAX DOOR AFT STAIRS SKIN IS CRACKED BETWEEN PANEL 832CT AND 832DT STEPS, CRACK IS .250 LONG. MAINTENANCE CUT AWAY DAMAGED SKIN AND INSTALLED REPAIR DOUBLER AND ANGLES IAW BOMBARDIER REO 601R-52-11-702 REV A. (M)SDR RAIA00709031Roller · lack of lubePOST FLT NR 5522 - STL - PAX DOOR DIFFICULT TO OPEN. MAINTENANCE LUBRICATED MAIN DOOR ROLLERS AND CLEANED ACTUATING CAMS. NO FURTHER FAULTS NOTED.SDR TRAX200701383Handle · brokenPAX DOOR HANDLE BROKEN. COULD NOT OPEN DOOR FROM INSIDE.SDR NWAA073273119Cylinder Damper · dischargedDURING LINE CHECK, FOUND RT AFT CABIN DOOR EMERGENCY OPERATION CYLINDER PRESSURE AT ZERO. MSP LINE MAINTENANCE REPLACED DOOR CYLINDER PER AMM 52-13-14.SDR USAA920070959Stop · corrodedSAL - MAJOR REPAIR - C-05 CHECK - CORROSION ON THE L2 DOOR STOP ASSEMBLY, BEAM 3. REPLACED THE L2 DOOR STOP ASSEMBLY, BEAM 3 IAW A320 AMM 52-11-00.
Back to JASC 5210