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 SWIA201436090Profile · crackedMAIN CABIN DOOR PROFILE CRACKED AT PAX STEP ASSEMBLY RT SUPPORT FRAME UPPER END AROUND 2 LOCK FASTENERS. C-CHECK REPLACED CRACKED SUPPORT PROFILE ON PAX DOOR AT UPPER AFT CORNER OF DOOR UNDER STEP SUPPORT STRUCTURE IAW SRM PN 120-39383-001.SDR SWIA201436089Profile · crackedMAIN CABIN DOOR PROFILE CRACKED AT PAX STEP ASSEMBLY LT SUPPORT FRAME LOWER END MOST AFT LOCK FASTENER. C-CHECK REPLACED PAX DOOR STIFFENER PROFILE P8 BELOW BOTTOM FWD STEP STRUCTURE IAW SRM PN 120-21061-001.SDR SWIA201436088Profile · crackedMAIN CABIN DOOR PROFILE CRACKED AT PAX STEP ASSEMBLY RT LOWER VERTICAL SUPPORT AROUND BOTTOM AFT LOCK FASTENER. C-CHECK REPLACED PAX DOOR RT CTR PROFILE AT STEP ASSEMBLY RT LOWER VERTICAL SUPPORT IAW SRM.SDR SWIA201436087Profile · crackedMAIN CABIN DOOR PROFILE CRACKED AT PAX STEP ASSEMBLY INBD LOWER VERTICAL SUPPORT AROUND BOTTOM AFT LOCK FASTENER. C-CHECK REPLACED PAX DOOR LT CTR PROFILE AT STEP ASSEMBLY LOWER VERTICAL SUPPORT IAW SRM.SDR A6WA201401014498Anchor · corrodedPASSENGER DOOR AFT ANCHOR HAS CORROSION AROUND SCREW HEADS. REMOVED & REPLACED PAX DOOR AFT ANCHOR FITTING COVER PLATE IAW CRJ 200 SRM 51-41-02.SDR QXEA2014010100003Handle · lack of lubeF/A REPORTED THAT MAIN CABIN DOOR HANDLE IS HARD TO OPEN. CLEANED AND LUBED THE DOOR MECHANISM. OPS CHECKED GOOD. RETURNED TO SERVICE.SDR CALA2014010290005Controller · malfunctionedCOCKPIT DOOR KEYPAD INOPERATIVE. COMPLIED WITH MEL SEE MT 52-017, REPLACED DOOR CONTROLLER, CHECKED OKAY.SDR UHLA2014010100002Cover · brokenL1 DOOR HANDLE COVER IS BROKEN. R & R, OPS CHECKED GOOD.SDR SWIA201335958Support · crackedPAX DOOR SUPPORT PROFILE CRACKED AT BAY NR 2. C-CHECK NEW SUPPORT PROFILE INSTALLED ON PAX DOOR AT BAY NR 2 IAW SRM.SDR SWIA201335957Support · crackedPAX DOOR BAY NR 5 HAS A CRACKED UNDERNEATH WEBBING SUPPORT PROFILE. C-CHECK NEW SUPPORT PROFILE INSTALLED ON PAX DOOR AT BAY NR 5 IAW SRM.SDR IPXA2014010301204Bottle · emptyR1 DOOR EMERGENCY PNEUMATIC BOTTLE PRESSURE READS ZERO. R & R FWD PASSENGER DOOR PNEUMATIC BOTTLE IAW MM 52-11-04-000-801-802. OPS CHECKED GOOD IAW MM 52-11-04-700-801.SDR CALA2014010290011Door · obstructed2L WILL NOT ARM. REMOVED DEBRIS FROM DOOR SILLSDR CALA2014010290007Bushing · wornDOOR 1L DIFFICULT TO OPEN & CLOSE. REPLACED UPPER DOOR HINGE ASSEMBLY WITH BUSHING. SEE PTT SEQ 1132021, ACCOMPLISHED IAW AMM 52-11-11-400-001-A.SDR N6WA20131231001Cable · brokenMAIN PAX DOOR SUPPORT WHEEL CABLE BROKEN. INSPECTED DOOR & FOUND CABLE NOT TO BE BROKEN, FOUND FO RESTRICTING MOVEMENT, REMOVED FO & PERFORMED OPERATIONAL CHECK IAW CRJ700 AMM 52-11-00, OPERATIONS CHECKED GOOD AT THIS TIME.SDR ASOA2014011509759Intercostal · crackedINTERCOSTAL CRACKED INSIDE PAX DOOR ACCESS PANEL 832BR, UPPER FLANGE. REMOVED INTERCOSTAL IAW SRM 51-40-11 AND 51-42-06. INSTALLED INTERCOSTAL IAW SRM 51-40-11 & 51-42-06.SDR CALA2014010290013Door Frame · damagedDOOR LEAK AT 2L, FOUND DOOR FRAME VERY ROUGH AT SEAL INTERFACE. FOUND LARGE GAPS IN SEAL AT LOWER GATE AREA. SMOOTHED & CONTOURED FRAME AREA, FILLED GAPS IN SEAL AT LOWER GATE.SDR UHLA2013123000698Lens · brokenTHE PLEXIGLASS COVER OVER THE ARM-DISARM INDICATOR ON THE L2 DOOR IS BROKEN OFF. REATTACHED COVER IAW AMM 25-00-24.SDR ASAA2013123012283Arm · bindingFWD SERVICE DOOR HARD TO CLOSE. ACFT GROUNDED. OPENED DOOR OBSERVED A LOT OF MOVEMENT BETWEEN UPPER CAMPLATE AND FRAME, .250 PLAY. MOVEMENT BETWEEN LOWER CAMPLATE AND FRAME APROXIMATELY .125" PLAY. EVERY THIRD CLOSING DOOR FAILS TO SEQUENCE INTO HOLE. TOSDR UHLA2013123000696Door · fodR1 DOOR DOES NOT ARM. REMOVED FOREIGN DEBRIS FROM DOOR. PERFORMED OPS CHECK OF DOOR IAW AMM 52-11-00, OPS CHECK GOOD.SDR CA140103017Seal · failed(CAN) ON DEPARTURE, CABIN WOULD NOT PRESSURIZE IN AUTO OR MANUAL MODE. ACFT RETURNED TO DEPARTURE AIRPORT. INSPECTION REVEALED THAT MAIN AIRSTAIR DOOR INFLATABLE SEAL WAS SPLIT/TORN IN THE LOWER FWD AREA AND WOULD NOT INFLATE. INFLATABLE SEAL REPLACED AND ACSDR ASOA2014012309795Handle · out of adjustDURING FUNCTIONAL TEST OF THE PAX DOOR INNER HANDLE, HANDLE FAILED FOLLOW UP PULL TEST, 16 MAX. ACTUAL 25 LBS. CLEANED, LUBED AND ADJUSTED INNER HANDLE DETEAT AT 12 LBF IAW AMM 52-11-02-400-801. COMPLIED WITH FUNCTIONAL TEST OF PAX DOOR IAW AMM 52-11-00-720-SDR 29GA2013123130252Latch · lack of lubeCABIN DOOR IS HARD TO OPEN AND CLOSE. LUBRICATED DOOR LATCHING MECHANISM. OPS CHECKED GOOD.SDR CALA2013123094052Seal · leakingDOOR 2L SEAL LEAKS UP TO ABOUT 10,000 FEET. SMOOTHED OUT PREVIOUS REM APPLICATION, PRESSURIZED CABIN IAW AMM NO AIR LEAKAGE DETECTED AROUND DR 2L.SDR SIMA20131229008Cable · out of adjustMAIN CABIN DOOR WON’T OPEN FROM OUTSIDE. ADJUSTED REAR LOCK BOX CABLE IAW AMM 52-10-01.SDR SIMA20131229004Hinge · dirtyCABIN DOOR DIFFICULT TO CLOSE, HANDLE JAMS THE LAST FEW INCHES WHEN PUSHING DOWN HANDLE. CLEANED & LUBED CABIN DOOR ROLLER HINGE IAW AMM 53-21-02, OPERATIONS CHECKED GOOD.SDR SWAA2014021024940Structure · crackedFWD ENTRY DOOR STRUCTURE CRACKED AT BS 348.2, STRINGER 16L. REPAIRED STRUCTURE IAW EA.SDR FDEA201312283064Seal · out of positionFOUND ACOUSTIC SEAL OUT OF TRACK ON L1 DOOR. REINSTALLED ACOUSTIC SEAL IN TRACK IAW MM 25-21-06-4.SDR SWIA201335961Rod · corrodedPAX DOOR STEP RODS HAVE CORROSION. C-CHECK REPLACED PAX DOOR NR 2 & NR 3 STEP RODS IAW AMM.SDR SWIA201335960Door Frame · crackedPAX DOOR AFT FRAME UNDER MID STEP STRUCTURE CRACKED. C-CHECK NEW FRAME INSTALLED ON AFT PAX DOOR BELOW MID STEP IAW SRM.SDR SWIA201335959Door Frame · corrodedPAX DOOR LOWER FWD BAY 2 FRAME HAS SEVERE CORROSION. C-CHECK NEW FRAME INSTALLED ON PAX DOOR LOWER BAY 2 IAW SRM.SDR WX0A071805Skin · crackedL1 DOOR SKIN CRACKED AT HOLD OPEN CUTOUT. FABRICATED REPAIR DOUBLER & INSTALLED REPAIR DOUBLER IAW MD-80 SRM 52-05 FIG 20A.SDR GTIA201312281093Bottle · low pressureR1 DOOR ASSIST ACCUMULATOR REQUIRES SERVICING. SERVICED R1 DOOR ASSIST ACCUMULATOR IAW AMM.SDR SIMA20131227004Grip · defectiveMAIN CABIN DOOR DIFFICULT TO OPEN. REPLACED INTERIOR RUBBER HAND GRIP & PERFORMED ADJUSTMENT CHECK IAW EMB 140 AMM 52-10-01. ADJUSTMENT CHECKED GOOD.SDR SWIA201335990Lever · chafedPAX DOOR FWD PULL IN LEVER CHAFFED. C-CHECK REPAIRED PAX DOOR FWD PULL IN LEVER IAW REO.SDR ASOA2014011509754Handle · lack of lubeDURING FUNCTIONAL CHECK OF THE PAX DOOR, FOUND INNER HANDLE FORCE TO UNLATCH OUT OF LIMITS. CLEANED AND LUBRICATED PAX DOOR IAW AMM 12-20-52-640-810. PERFORMED FUNCTIONAL TEST OF PAX DOOR IAW AMM 52-11-00-720-802, FOUND WITHIN LIMITS. TESTED GOOD.SDR GTIA201312261090Bottle · low pressureL1 DOOR ASSIST ACCUMULATOR REQUIRES N2 SERVICE. SERVICED L1 DOOR ASSIST ACCUMULATOR AS REQUIRED IAW AMM.SDR GTIA201312261088Rub Strip · looseF/A ADVISE L1 DOOR HAS LOUD SQUEAL AND NOISE. IT DOES NOT LESSEN AT CRUISE ALTITUDE. SECURED LOOSE RUB STRIP AT TOP FWD CORNER OF L1 IAW AMM.SDR GTIA201312261087Bottle · low pressureL1 DOOR ASSIST REQUIRES SERVICE. SERVICED L1 DOOR ASSIST TO PROPER PRESSURE IAW AMM. LEAK CHECKED GOOD.SDR FDEA201312263044Door · obstructedL1 DOOR DIFFICULT TO OPEN & CLOSE. HAD TO ENTER FROM R1 DOOR, RESET & OPEN L1 DOOR FROM INSIDE. CLOSING L1 DOOR FROM OUTSIDE, DOOR AGAIN GETS OUT OF SYNC & UNABLE TO OPEN. FOUND EVIDENCE OF WATER & DEBRIS IN DOOR JAMB AREA AT ROLLER & CHANNELS. CLEANED & SSDR USAA2013122700010Handle · looseFLIGHT ATTENDANT REPORTS AFTER TAKEOFF, DOOR 3L HANDLE APPEARS TO BE LOOSE. TIGHTENED 3L DOOR SLIDE ARMING LEVER SCREW & NUT AS REQUIRED. NO OTHER DISCREPANCIES NOTED AT THIS TIME, OPERATIONS CHECKED OK.SDR MASA2013122620829Spring · weakPAX DOOR HANDLE FLAPPER INOPERATIVE. MX REPLACED THE FLAPPER SPRINGS.SDR CALA2013122793986Battery Pack · dischargedNR 3 RT DOOR EPAS BATTERY AMBER TEST INDICATOR NOT COME ON WHEN TEST EPAS FUNCTION CHECK. NR 3 RT DOOR EPAS BATTERY AMBER TEST CHECKED NORMAL IAW AMM 52-11-20 AFTER EPAS BATTERY PACK REPLACED IAW AMM 52-11-20. HX142076. WIRE W3060-0121-20 REPLACED & CHECKED SDR GTIA201312251084Bottle · low pressureL1 DOOR ASSIST BOTTLE PRESSURE LOW. CHARGED L1 DOOR ASSIST BOTTLE IAW AMM 52-10-00. NO LEAKS NOTED.SDR A6WA201312234472Support Angle · crackedCRACK IN THE 4TH STEP SUPPORT ANGLE AFT SIDE OF PAX DOOR. REMOVED CRACK & INSTALLED REPAIR ANGLE & DOUBLER IAW CRJ 200 REO 601R-852-11-702 REV C.SDR N6WA20131224002Support Fitting · damagedPASSENGER DOOR SUPPORT ARM DAMAGED ON DOOR OPENING. R & R NEW PAX DOOR SUPPORT FITTING IAW CRJ700 SRM 51-42-22. OPERATIONS CHECKED GOOD AT THIS TIME.SDR N6WA20131224001Wheel · lack of lubePASSENGER DOOR SUPPORT WHEEL DID NOT DEPLOY. FOUND DOOR WHEEL NOT TO BE LUBRICATED, LUBED DOOR WHEEL AS REQUIRED. PERFORMED OPERATIONS CHECK OF MAIN DOOR IAW CRJ700 AMM 52-11-00, OPERATIONS CHECKED GOOD AT THIS TIME.SDR FDEA201312243041Control Cable · failedL1 DOOR OFF TRACK WHEN OPENED. R & R ALL L1 FWD PAX DOOR SEQUENCE CONTROL CABLES IAW MD10-10MM 52-11-12-2. PERFORMED ADJUSTMENT TEST IAW MD10-10MM 52-11-00-5. SERVICED L1 PASSENGER DOOR AIR RESERVOIR IAW MD10-10MM 52-11-07-2. DOOR OPERATIONS CHECKED NORMALSDR A6WA201312234541Handle · crackedPASSENGER DOOR INNER HANDLE CRACKED. R & R PAX DOOR INNER HANDLE.SDR 9JLA2013123104828Strut · damagedCREW REPORTED THAT AFTER LOADING OF PASSENGERS DURING COLD WEATHER OPERATIONS, THE CREW WAS UNABLE TO CLOSE THE CABIN DOOR & DAMAGED THE AFT DOOR SUPPORT TELESCOPIC STRUT. IT WAS DETERMINED THAT THE AFT DOOR TELESCOPIC TIE ROD AS JAMMED DUE TO FROZEN WATER INSDR RAIA201312230001Profile · corrodedPASSENGER DOOR ENTRANCE AFT TEE PROFILE IS CORRODED. MAINTENANCE REPLACED AFT PASSENGER DOOR ENTRANCE "T" PROFILE.
Back to JASC 5210