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 COEA0709821Door · crackedFOUND DURING HEAVY CHECK. FOUND CRACK ON BACKUP FITTING, AFT PASSENGER DOOR. FABRICATED AND INSTALLED REPLACEMENT BACKUP FITTING. (K)SDR SWIA200718662Latch · bindingPAX DOOR WILL NOT OPEN FROM INSIDE OR OUTSIDE. CLEANED PAX DOOR LATCH PINS AND CAMS. RELUBRICATED PAX DOOR IAW MM 12-20-52. OPS CHECK GOOD.SDR TRAX200701327Step · crackedPAX DOOR STAIR 832CT IS CRACKED. REPAIRED IAW CRJ 200 SRM 51-40-11, 51-42-06, 51-42-21,SDR MASA200700551Door · lack of lubePAX DOOR WILL NOT OPEN. MX LUBED AND CYCLED DOOR, OPS CHECK GOOD.SDR COMA0760557Handle · out of positionFLIGHT 5354 - PAC DOOR HANDLE CAUTION MESSAGE AT 8000 FT DURING CLIMB. QRH PROCEDURE COMPLETED. AIRCRAFT RETURNED BACK TO CHS AND LANDED SAFELY. UPON ARRIVAL FOUND THE PAX DOOR OUTER HANDLE OUT. PERFORMED OPS CHECK OF PAX DOOR OUTER HANDLE, WITH NO DEFECTSSDR 2007UALA03508Cylinder · low pressureNR 2 RIGHT PASSENGER DOOR EMERGENCY CYL-ACCUM PRESSURE LOW. SERVICE DOOR ASSIST CYLINDER TO PROPER PRESSURE,SDR TRAX200701309Door · bindingF/A REPORT PAX BOARDING DOOR DIFFICULT TO OPEN, APPEARS TO BE CAUGHT ON SOMETHING.SDR TRAX200701308Handle · sticksMAIN CABIN DOOR DIFFICULT TO OPEN AND CLOSE, MAIN DOOR HANDLE IS STICKING.SDR FDKA200708437Door · lack of lubeMAIN CABIN DOOR IS HARD TO OPEN. MX LUBED DOOR HATCH, OPS CHECK GOOD.SDR MASA200700539Track · dirtyMAIN DOOR WILL NOT OPEN. CLEANED TRACKS AND PINS.SDR A6WA200740491Skin · crackedPASSENGER DOOR FORWARD SKIN IS CRACKED AT STEP 832CT. SUP - MAINTENANCCE REPAIRED IAW BSC EO 601R-52-12944. (M)SDR A6WA200740492Step · crackedPASSENGER DOOR TOP STEP EDGE MEMBER CRACKED. SUP - MAINTENANCE REPAIRED IAW REO NR 601R-52-11-279. (M)SDR TRAX200701267Door · stuckMAIN ASD JAMMED SHUT.SDR 07FDEA03259Skin · misrepairedFOUND OLD DOUBLER REPAIR ON FWD RT PAX DOOR LOWER FWD CORNER NOT CONFORM TO SRM REPAIR RENEWED IAW SRM 52-10-00 FIG 204.SDR F3LA200700211Seal · corrodedDURING C4/S1 CHECK, INSPECTION REPORTED LT DOOR SEAL CORRODED AT NUT PLATE HOLE AT FR66. FABRICATED REPAIR ANGLE, FILLERS AND DOUBLER IAW SRM 53-41-14. INSTALLED SPLICE ANGLE, DOUBLERS AND FILLER IAW SRM 53-41-11.SDR ASAA0742010Bolt · looseR 1 DOOR WILL NOT OPEN. UPON INSPECTION, FOUND BOLT TO ROD END NOT ATTACHED, NUT MISSING. REATTACHED ROD END INSIDE DOOR, TESTED PER AMM 52 41 00.SDR TRAX200701262Handle · crackedPAX DOOR INNER HANDLE CRACKED. NEW PAX DOOR INNER HANDLE INSTALL IAW SRM 51-41-04.SDR TRAX200701252Step · brokenPAX DOOR BOTTOM STEP IS BROKEN.SDR QXEA200701361Door · stuckSEA FLIGHT NR 2393: FA WAS UNABLE TO OPEN REAR PAX DOOR. MAINTENANCE DISLODGED DOOR. CHECKED FOR DAMAGE WITH NO DAMAGE NOTED. CYCLED DOOR SEVERAL TIMES WITH NO DEFECTS NOTED. RESET DOOR PER SERVICE LETTER DH8-400-SL-52-003A. OPS CHECK GOOD. NO FURTHER DESDR FDKA200708427Rod · out of rigFDM 6184 JFK (0457 PHX LCL) - PAX DOOR HARD TO OPEN. MX REMOVED AND REPLACED ROD AND BOLT RIGGED DOOR.SDR A6WA200740489Skin · crackedPAX DOOR AFT STAIR SKIN CRACKED IN CORNER BETWEEN FIXED STEP AND MID STEP 832CT. SUP - MAINTENANCE REPAIRED AFT STAIR SKIN PANEL IAW REO 601R-52-11-702. (M)SDR USAA070669Door Frame · crackedFWD PAX DOOR FRAME CRACKED AT NR 6 STOP PIN CUTOUT. INSTALLED DOUBLER REPAIR PER EA 98819, DEFECT SIZE: .125 INCH.SDR USAA070668Door Frame · crackedFWD PAX DOOR FRAME CRACKED AT NR 5 STOP PIN CUTOUT. INSTALLED DOUBLER REPAIR PER EA 98819, DEFECT SIZE: .125 INCH.SDR USAA070667Door Frame · crackedFWD PAX DOOR FRAME CRACKED AT NR 7 STOP PIN CUTOUT. INSTALLED DOUBLER REPAIR PER EA 98819, DEFECT SIZE: .125 INCH.SDR A6WA200740487Web · crackedFOUND AFT WEB CRACKED IN RADIUS .300 INCH LONG AT STEP 832CT ON PAX DOOR. 10-04-07 MAINTENANCE REPAIRED WEB IAW BOMBARDIER REO 601R-52-11-702. (M)SDR A6WA200740488Web · crackedFOUND FORWARD WEB CRACKED IN RADIUS .400 INCH LONG AT STEP 832CT ON PAX DOOR. S/D - MAINTENANCE REPLACED IAW BOMBARDIER REO 601R-52-11-702. (M)SDR TRAX200701244Door · bindingMAIN CABIN DOOR WILL NOT OPEN. FLT 4728 DEL 70 MINS.SDR TRAX200701242Bracket · crackedASD AFT CABLE COUNTER BALANCE ANCHOR BRACKET CRACKED.SDR COEA0744821Structure · corrodedFOUND DURING HEAVY CHECK. LEVEL 2 CORROSION SEVERAL PLACES ON AFT PASSENGER DOOR. REPLACED THE FOLLOWING PARTS. BEAM S52176205212, INNER SKIN PANEL S52176301200. WO 72242 NR 800025,33. (K)SDR COEA0724821Intercostal · corrodedFOUND DURING HEAVY CHECK. FOUND LEVEL 2 CORROSION, PASSENGER DOOR BEAM NR 5. REMOVED AND REPLACED NEW INTERCOSTAL. (K)SDR MASA200700520Mechanism · lack of lubeASH 2525 PHX. MAIN CABIN DOOR HARD TO OPEN. MX CLEANED & LUBED INNER MECHANISMS.SDR MALA070111Skin · dentedDURING N4K CHECK IN CWA FOUND, MAIN ENTRANCE DOOR OUTER SKIN DENT. REPAIRED IAW EO NR S52082 AND SRM 52-10-10.SDR USAA070665Door Frame · crackedFWD PASSENGER DOOR FRAME CRACKED AT 37 STOP PIN CUTOUT, L1 DOOR, FWD ENTRY DOOR. INSTALLED DOUBLER REPAIR PER EA 98819, DEFECT SIZE: .125 INCH.SDR MASA200700519Door · lack of lubeASH 2944 PHX. CREW REPORTED THE PAX DOOR STUCK CLOSED. MAINTENANCE ARRIVED AND THE DOOR OPENED NORMALLY. MX LUBED THE DOOR. PAX DOOR OPERATES NORMALLY.SDR UPS07850711Skin · chafedINSPECTION TYPE:C2 L1 DOOR OUTSIDE DOOR HANDLE IS CHAFING ON DOOR EXTERNAL SKIN. REPAIRED L1 DOOR SKIN HANDLE CUTOUT IAW UPS EO DC8-5210-8162.SDR TRAX200701235Door · bindingF/A REPORTED MAIN CABIN DOOR HARD TO CLOSE AND OPEN.SDR TRAX200701234Anchor Fitting · corrodedFWD ASD ANCHOR FITTING CORRODED.SDR 07FDEA03069Beam · crackedMAIN DECK 1L ENTRY DOOR SN 24, BOTTOM CROSS BEAM WEB IS CRACKED AT AFT STOP FITTING. REMOVED STOP FITTING, REMOVED DAMAGE, REPAIRED WEB. INSTALLED DOUBLER AND REINSTALLED STOP FITTING REF SRM 51-40-2 AND FED EX DWG SR27-52-015, THIS IS CLASSIFIED AS A MAJOR SDR 07FDEA03060Skin · misrepairedOLD REPAIR DOUBLER ON AFT PAX DOOR RT (ZONE 843) THIS ONES MATERIAL DOES NOT CONFORM TO SRM 52-10-00/FIG 204. REPAIR PERFORMED BY RENEWING SKIN REPAIR IN ACCORDING SRM 52-10-00/FIG 204.SDR 07FDEA03059Plate · corrodedCORROSION BETWEEN PLATE SHEET METAL AND SLIDING PROTECTION AT FWD CREW DOOR 831 LT. REPAIR PERFORMED BY REPLACEMENT OF PART IAW SRM 51-72-10.SDR MASA200700516Seal · obstructedASH 7001 ORD-IAD - AIRCRAFT REJECTED TAKEOFF DUE TO PAX DOOR WARNING MESSAGE. MX CLEANED DEBRIS FROM PAX DOOR SEAL, OPS GOOD.SDR 2007UALA03360Door Frame · crackedNR 1 LEFT MAIN ENTRY DOOR FRAME CRACKED AT GATE HINGE ATTACH HOLES. MAJOR REPAIR ACCOMPLISHED: INSTALLED REPAIR ANGLE.SDR 2007UALA03311Door Frame · crackedFWD ENTRY DOOR AFT FRAME CRACKED AT NR 6 & 7 STOPS. MAJOR REPAIR ACCOMPLISHED: INSTALLED REPAIR ANGLES AT 6 & 7 STOP FITTINGS ON THE AFT FRAME.SDR 2007UALA03310Skin · crackedDOOR 1L SKIN CRACKED: LT FWD ENTRY DOOR INNER SKIN AFT EDGE CRACKED AT STOP PIN CUTOUTS 6 & 7. MAJOR REPAIR ACCOMPLISHED: INSTALLED DOUBLER ON INNER SKIN AT THE 6 & 7 CUTOUTS ON THE AFT SIDE.SDR TRAX200701227Door · bindingMAIN CABIN DOOR IS HARD TO CLOSE.SDR FDKA200708401Sill · lack of lubeFDM 6131 MCO (1515 PHX LCL) - MAIN CABIN DOOR HARD TO CLOSE. MX LUBED DOOR SILLS.SDR A6WA200740461Door · lack of lubeUNABLE TO OPEN MAIN PASSENGER DOOR. AFTER MULTIPLE ATTEMPTS, DOOR OPENED. OPERATED DOOR SEVERAL TIMES. DOOR APPEARS TO OPERATE NORMALLY. PLACED ON MEL. REF LOG 177995/2 CLEANED AND LUBED PASSENGER DOOR. PERFORMED OPS CHECK OF PASSENGER DOOR SEVERAL TIMESSDR TRAX200701225Handle · jammedMAIN CABIN DOOR HANDLE JAMMED AND WILL NOT CLOSE.SDR TRAX200701217Door · bindsPAX DOOR HARD TO CLOSE.SDR HALA0700348Skin · crackedMAIN DOOR LATCH ON, FUSELAGE, SKIN DAMAGE DURING OPENING OF MAIN DOOR. JETTWAY CAUGHT THE DOOR. FERRY FLIGHT REQUIRED, THIS AIRCRAFT HAS BEEN INSPECTED THIS DATE AND IS SAFE FOR THE INTENDED FLIGHT. BLEND SKIN DAMAGE L 1.5" D .3" MIN 2D E.D. TO NEAREST FAST
Back to JASC 5210