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 MASA200602048Mechanism · lack of lubeASH 7127 CLT. PAX DOOR HARD TO OPEN. MX LUBED THE DOOR.SDR TRAX200600581Door · stuckPAX DOOR WILL NOT OPENSDR SWAA062854Skin · crackedDURING SCHEDULED C4 CHECK, FOUND L1 DOOR LOWER GATE SKIN CRACKED AT AFT LOWER CORNER. REPAIRED L1 DOOR PER MM.SDR MASA200602024Seal · fodASH 7339 IAD - PAX DOOR DIFFICULT TO OPEN AND CLOSE AND SQUEALED IN FLIGHT. MX REMOVED FOD FROM SEAL AND HINGE.SDR SWAA062828Door Frame · crackedDURING SCHEDULED C4 CHECK, FOUND R1 DOOR AFT FRAME CRACKED AT LOWER AFT DOOR STOP. REMOVED AND REPLACED R1 DOOR PER MM.SDR TRAX200600574Step · crackedTOP STEP CRACKED ON MAIN PAX DOORSDR QXEA200602016Handle · wornSEA FLIGHT 2460: AFT PAX DOOR HARD TO OPEN AND CLOSE. MAINTENANCE FOUND THE BUSHINGS AND BEARINGS AFT OF CRANK ASSY WORN. DOOR HANDLE WAS DISASSEMBLED, BUSHINGS AND BEARINGS WERE REPLACED WITH NEW. HANDLE WAS RE-ASSEMBLED. FUNCTIONAL TEST GOOD IAW TASK 52-SDR MASA200602010Mechanism · lack of lubeASH 7231 IAD - PAX DOOR WOULD NOT OPEN FROM THE INSIDE OR OUTSIDE. MX LUBED THE DOOR MECHANISMS.SDR SWAA062760Door Frame · crackedDURING SCHEDULED C2 CHECK, FOUND R1 DOOR LOWER FRAME WEB CRACKED AT AFT LOWER DOOR STOP. REMOVED AND REPLACED R1 DOOR PER MM.SDR ASAA0640829Guide Arm · out of adjustON DESCENT AFT ENTRY DOOR ILLUM'D LIGHTS EXTINGUISHED PRIOR TO LANDING. PRESSURIZATION NORMAL. DOOR LIGHT ILLUM AT CABIN DIFF PRESS OF 1.6 PSI AND WENT OUT AT .5 PSI. ADJUSTED GUIDE ROD PER AMM 52 13 00.SDR 06FDEA02745Skin · tool damageTOOL MARK AT EXTERIOR SKIN OF 4R DOOR UPPER AFT AREA. TOOL MARKS ON 4 RT DOOR UPPER AFT EXTERIOR SKIN REMOVED AND FOUND EXCEEDED LIMIT AS PER SRM 52-00-01 FIG 1A VOL I. DISCREPANT SKIN TRIMMED OUT AS PER SRM 52-10-00 FIG 10 VOL.I. REPAIR DOUBLER AND FILLSDR A6WA200640302Door · lack of lubePASSENGER DOOR WILL NOT OPEN FROM OUTSIDE. PLACARDED AND PLACED ON MEL. INSPECTED AND FOUND SEVERAL PUSH RODS SEIZED UP. APPLIED LUBRICANT TO AFFECTED AREAS IAW CRJ 12-20-52, OPS CHECK GOOD AT THIS TIME. REMOVED FROM MEL. (M)SDR TRAX200600565Door · malfunctionedFA REPORTS MAIN CABIN DOOR IS DIFFICULT TO OPEN.SDR TRAX200600564Stringer · brokenPAX DOOR STRINGER BROKE.SDR 06FDEA2745Skin · tool damageTOOL MARK AT EXTERIOR SKIN OF 4R DOOR UPPER AFT AREA.SDR TRAX200600555Handle · crackedPAX DOOR OUTER HANDLE CRACKED. C/W TEMP REPAIR PER REO:601R-52-11-1004 VALID FOR 1000 FLT HRS. VISUALLY INSPECT HANDLE FOR ADDITIONAL CRACK(S) AND DAMAGE PROPAGATION AND EVERY SUBSEQUENT ROUTINE CHECK. REMOVED AND REPLACED PAX DOOR OUTER DOOR HANDLE AS PER ASDR MASA200601982Door · malfunctionedASH 5096 PHX - CAPTAIN REPORTED PAX DOOR WILL NOT CLOSE. MX INSPECTED AND CYCLED DOOR, NO DEFECT NOTED.SDR A6WA200640298Spring · out of adjustREQUEST INSPECTION OF PASSENGERS DOOR OPERATION DUE TO DOOR INTERMITTENT OPERATION OPENING DOOR FROM OUTSIDE. LUBRICATED DOOR SHUT BOLTS AND CAMS, PERFORMED COUNTER BALANCE ADJUSTMENT OF REAR COUNTER SPRING, PERFORMED OPS CHECK OF PASSENGER DOOR, FORCE TEST OSDR SWIA200617186Rib · crackedCRACK IN RIB OF CABIN DOOR BELOW FORWARD LOWER DOOR STOP, FORWARD OF SECOND STEP DISCOVERED DURING C-CHECK INSPECTION. ACCOMPLISHED REPAIR TO RIB NEXT TO DOOR STOP FORWARD OF SECOND STEP IAW SRM 52-10-02 AND RII 52-800-1000.SDR IXXA06SMN264SSkin · misrepairedDURING ROUTINE C-CHECK INSPECTION FOUND EXTERNAL FUSELAGE FORWARD PASSENGER DOOR UPPER CORNER HAS NON STANDARD REPAIR. REMOVED EXISTING NON STANDARD REPAIR. PERFORMED NDT INSPECTION NO CRACKS OR CORROSION FOUND. FABRICATED REPAIR DOUBLER (AL 7075 T6 0.063), ASDR MASA200601975Ring · missingASH 7175 RDU - FLIGHT DECK DOOR EMERG RELEASE RING MISSING. MX REINSTALLED RING.SDR IXXA06SMN261SSkin · crackedDURING ROUTINE C-CHECK INSPECTION FOUND LEFT HAND PASSENGER DOOR LOWER AREA CRACKED AT STATION 35.000. REMOVED FASTENERS IAW DC-8 SRM 51-1-21, REMOVED DAMAGED AREA. FABRICATED REPAIR DOUBLER AND FILLER (AL 7075 T6 0.050”) IAW DC-8 SRM 52-2-0 FIG 4, (SHEET 3)SDR TRAX200600562Drag Angle · crackedFOUND AFT DRAG ANGLE ON PAX DOOR IS CRACKED. (MARKED)SDR ASAA0640827Guide Arm · out of adjustON TAKEOFF FLT CREW FOUND THE R 1 DOOR HANDLE (STRIGHT UP) AND WOULD NOT STAY IN THE DOWN POSITION. PRESSURIZATION NOT AFFECTED. SLIDE AND LINING WAS REMOVED. DOOR INSPECTED IAW AMM. NO DISCREPANCIES NOTED. HOWEVER THE GUIDE ARM WAS MISADJUSTED. AFTER RE ADJUSSDR TRAX200600550Door · malfunctionedTHE PAX DOOR WILL NOT CLOSE AND LOCK, FLTS 4280,4903 CX.SDR AMWA078634Cable · brokenON PREFLIGHT, THE CREW COULD NOT OPEN THE CABIN DOOR. MAINTENANCE WAS CALLED AND FOUND THE INNER FORWARD DOOR CABLE BROKEN. MAINTENANCE REMOVED AND REPLACED THE BROKEN CABLE AND CABLE GUIDE ASSY.SDR 2007FA0000198Bolt · corrodedDURING ACCOMPLISHMENT OF ANNUAL INSPECTION, EXCESSIVE PLAY WAS NOTED AT AFT HINGE POINT OF UPPER MAIN CABIN DOOR. INVESTIGATION REVEALED THAT HINGE BOLT WAS BROKEN, HEAD OF BOLT COULD BE TURNED, BUT END WITH NUT WOULD NOT FOLLOW. TRIED TO REMOVE BOLT BUT WASSDR MASA200601958Mechanism · lack of lubeASH 6528 BUR - PASSENGER DOOR HANDLE WILL NOT STOW. CONTRACT MX CLEANED AND LUBRICATED DOOR. NO FURTHER DEFECTS NOTED.SDR EIA2006174Skin · crackedNR 1 R MAIN ENTRY DOOR EXTERIOR SKIN FOUND CRACKED AT LWR COLUMN OF RIVETS AS MARKED. REPAIRED IAW B747 SRM 52-10-02 FIG 9 REPAIR DOUBLER USED 2024-T3 0.063 DIMENSIONS 11.5 X 9.25 INCHES.SDR TRAX200600529Drag Angle · crackedFOUND PAX DOOR AFT DRAG ANGLE CRACKED.SDR COMA0660457Skin · cracked4TH STEP UP ON PAX DOOR AFT SKIN IS CRACKED IN RADIUS OF RISER ANGLE.COMPLIED WITH E.A. 10-5211-01292 A.SDR QXEA200601908Handle · unsecureLAX FLIGHT NR 2442, FUSELAGE DOOR WARNING LIGHT ILLUMINATED. AFT CARGO DOOR SHOWED OPEN ON DOOR PAGE. AIRCRAFT DEPRESSURIZED ABOUT 1 MINUTE AFTER WARNING LIGHT ILLUMINATED. MAINTENANCE INSPECTED AND FOUND AFT CARGO DOOR HANDLE POPPED. CLEANED DOOR HANDLE ASDR SWAA062581Casting · brokenFWD ENTRY DOOR UPPER GATE CENTER ROD END CASTING BROKEN. REMOVED AND REPLACED UPPER GATE CASTING PER MM.SDR TRAX200600517Fitting · crackedFWD AIRSTAIR DOOR ANCHOR FITTING IS CRACKED.SDR TRAX200600514Angle · corrodedFOUND ASD CENTER DOOR ANGLE CORRODED.SDR TRAX200600508Structure · crackedASD CRACKED UNDER UPPER STEP AFT SIDESDR QXEA200601989Stop Fitting · corrodedPDX C3 FORWARD PASSENGER DOOR FORWARD STOP FITTINGS HAVE MILE SURFACE CORROSION AND WARE. REPAIRED IAW RD 8/4-53-1629.SDR TRAX200600509Door · obstructedPAX DOOR WILL NOT CLOSE STOPS ABOUT 2 INCHES. ACTS LIKE DOOR HITS SOMETHING.SDR QXEA200601990Stop Fitting · corrodedPDX C3 FORWARD PASSENGER DOOR AFT STOP FITTINGS HAVE MILE SURFACE CORROSION AND WARE. REPAIRED IAW RD 8/4-53-1629 AND HORIZON AIR EA 6-53-775.SDR AWXA200601341Skin · scratchedL2 DOOR HAS 2 MINOR SCRATCHES MID WAY UP DOOR. REPAIR ON L2 DOOR MID WAY UP DOOR IAW SRM A320 52-10-00 FIG 206, PROTECTIVE TREATMENT APPLIED IAW SRM A320 51-21-11, FASTENERS REMOVAL AND INSTALLATION IAW SRM A320 51 - 42 - 11. REPAIR LOCATED BTW BEAM 2 TO BEASDR MASA200601878Spring · damagedASH 7279 CLT - PAX DOOR WARNING MESSAGE. MX REMOVED AND REPLACED INNER HANDLE ROLLER AND SPRING. OP'S CHECK GOOD.SDR TRAX200600507Handle · stuckPASSENGER DOOR DIFFICULT TO OPEN OFTEN AFTER LANDING. HANDLE STUCK ABOUT HALFWAY THROUGH TRAVEL, FINALLY OPENED WHENEXTRA FORCE APPLIED.SDR TRAX200600506Handle · sticksPAX DOOR RED HANDLE STICKING WHEN CLOSING DOOR.SDR USAA060907Skin · crackedFOUND CRACK AFT FRAME SIDE, 35" BELOW TOP EDGE OF INNER DOOR SKIN. CUT OUT DAMAGE, FABRICATED, DOUBLER AND INSTALLED IAW SRM 51-70-11 PAGE 4, DEFECT SIZE: .25".SDR MASA200601866Handle · stickingASH 6146 PHX - PAX DOOR HANDLE STICKS FROM OUTSIDE. MX ADJUSTED ROLL PINS.SDR TRAX200600497Door · not closedPAX DOOR WILL NOT FULLY CLOSE WHEN PASSENGERS ARE ON BOARD...FLT 4681 CXSDR C2XACL065Seal · swollenCLE - FLIGHT 3248 CREW REPORTED MAIN CABIN DOOR HARD TO OPEN AND CLOSE. MAINTENANCE INSPECTED AND REPLACED CABIN DOOR SEAL. OPERATIONAL CHECKS WERE GOOD.SDR MASA200601853Pin · dirtyASH 6154 PHX - PAX DOOR HANDLE WOULD NOT OPEN. MX CLEANED THE DOOR PINS.SDR MASA200601858Door · out of adjustASH 7382 BNA - PAX DOOR WILL NOT OPEN. MX REPOSITIONED A/C AND DOOR OP'S NORMAL.SDR TRAX200600502Intercostal · crackedRANRC 425. PAX DOOR UPPER AFT INTERCOSTAL CRACKED.
Back to JASC 5210