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 GTIA2014082501415Bottle · low pressureL2 DOOR ASSIST BOTTLE HAS LOW PRESSURE. SERVICED THE BOTTLE IAW AMM 52-10-00.SDR QXEA2014082700721Channel · corrodedOUTER EDGE CHANNEL AFT PAX DOOR CORRODED. LOCATED AND DRILLED NEW OUTER EDGE CHANNEL IAW SRM 51-40-07. INSTALLED CHANNEL IAW SRM 51-41-05.SDR UHLA2014082400563Track · dirtyMAIN CABIN DOOR HARD TO CLOSE. CLEANED AND REMOVED DEBRIS FROM FWD PASSENGER DOOR TRACKS IAW AMM 52-11-23.SDR V0XD20140824163Hinge · crackedTOP PAX FOLDING STEP HINGE BROKEN. R & R TOP PAX FOLDING STEP HINGE IAW SRM 51-40-11 & 51-41-02. SEE WORK ORDER 80242 WC 8050.SDR MASA2014082402340Cable · misroutedPAX DOOR HARD TO OPEN. MX REROUTED RETRACT CABLE.SDR V0XD20140824162Step · crackedPAX DOOR TOP STEP CORNER IS CRACKED ON AFT SIDE. REPAIRED CRACK ON PAX DOOR TOP STEP AFT CORNER IAW SRM 52-11-04. SEE WORK ORDER 80242 WC 8052.SDR DALA2014082404819Pan · crackedCRACK ON FWD EDGE OF PAN BETWEEN BEAMS 5 & 6, AT L1 DOOR. CRACKED DOUBLER REMOVED AND REPLACED IAW SRM 51-30-1, 51-30-2, 51-30-2, SRM 51-30-1 AND 51-10-3, PAR 14.SDR DALA2014082704779Flange · bentL1 DOOR BOTTOM FLANGE BENT. STRAIGHTENED DOOR FLANGE IAW SRM 52-01-01. DOOR OPERATES NORMAL AT THIS TIME.SDR USAA2014082500025Bottle · low pressureA 08 CHECK LOW PRESS ON R2 DOOR ASSIST BOTTLE. SERVICED R2 DOOR ASSIST BOTTLE IAW JOB CARD 33C80052002.SDR RAIA201408230001Roller · lack of lubeMAIN DOOR HARD TO OPEN DURING PREFLIGHT. MAINTENANCE INSPECTED AND LUBRICATED ROLLERS, OPS CHECKED GOOD.SDR USAA2014082500019Bottle · low pressureTHE A FLIGHT ATTENDANT REPORTED LOW PRESS CAUTION LIGHT ON CIDS PANEL. FOUND 4L DOOR ASSIST BOTTLE TO BE LOW. SERVICED DOOR ASSIST BOTTLE IAW AMM 52-10-00-614-001-A.SDR A6WA201441910Drag Angle · crackedPAX DOOR STAIR AFT DRAG ANGLE CRACKED.SDR 29GA2014082600001Door · bindingCABIN AIRSTAIR DOOR HARD TO CLOSE. PERFORMED SEVERAL OPS CHECKED, NO DEFECTS NOTED.SDR USAA2014082500022Bottle · low pressureDURING DAILY CHECK FOUND 2R DOOR ASSIST BOTTLE PRESS LOW. REQUIRES SERVICING. NO MSG ON FAP OR CIDS. SERVICED 2R DOOR TO NOMINAL PRESS.SDR USAA2014082500021Bottle · low pressure2R DOOR ASSIST BOTTLE SHOWS LOW PRESS. SERVICED 2R DOOR ASSIST BOTTLE TO PROPER CHARGE.SDR USAA2014082500003Cylinder · low pressureR2 DOOR EMER OPERATION CYLINDER PRESS LOW. R2 DOOR CYLINDER SERVICED IAW AMM 52-10-00-614-001A TO 1850 PSI. LEAK CHECKED GOOD.SDR SIMA20140822002Door · lack of lubeMAIN DOOR HANDLE DIFFICULT TO OPEN & LATCH CLOSE. LUBRICATED MAIN DOOR. OPERATIONS CHECKED GOOD IAW AMM 20-00-00.SDR USAA2014082200019Bottle · low pressureA5 CHECK R4 DOOR ASSIST BOTTLE HAS LOW PRESS. SERVICED R4 DOOR ASSIST BOTTLE IAW WITH JOB CARD 33C80052002.SDR USAA2014082200018Bottle · low pressureA5 CHECK L1 DOOR ASSIST BOTTLE HAS LOW PRESS. SERVICED L1 DOOR ASSIST BOTTLE IAW WITH JOB CARD 33C80052002.SDR USAA2014082200017Bottle · low pressureA5 CHECK L2 DOOR ASSIST BOTTLE HAS LOW PRESS. SERVICED L2 DOOR ASSIST BOTTLE IAW WITH JOB CARD 33C80052002.SDR USAA2014082200016Bottle · low pressureA5 CHECK R1 DOOR ASSIST BOTTLE HAS LOW PRESS. SERVICED R1 DOOR ASSIST BOTTLE IAW WITH JOB CARD 33C80052002.SDR USAA2014082200005Bottle · low pressureL2 DOOR ASSIST BOTTLE PRESS LOW. SERVICED L2 DOOR ASSIST BOTTLE.SDR USAA2014082200004Bottle · low pressureL1 DOOR ASSIST BOTTLE PRESS LOW. SERVICED L1 DOOR ASSIST BOTTLE.SDR DALA2014082204785Beam · crackedCRACKED BEAM AFT EDGE AT MAIN ENTRANCE L1 DOOR. CRACK REMOVED IAW SRM 51-30-1, DOUBLER FABRICATED IAW SRM 52-05D, FIG 81, AND WAS INSTALLED IAW SRM 51-30-1.SDR USAA2014082200002Bottle · low pressureL2 DOOR ASSIST BOTTLE PRESS LOW. SERVICED L2 DOOR ASSIST BOTTLE.SDR V0XD20140821160Rivet · chafedPAX DOOR FWD & AFT OF LOWER STEP HAS 1 RIVET CHAFFED EACH SIDE. R & R 1 EACH RIVET FWD & AFT OF LOWER STEP IAW SRM 51-42-13. SEE WO 80242 WC 8041.SDR K11A2014092291506Structure · crackedFWD SIDE OF AIRSTAIR DOOR SURROUND CRACK.SDR DALA2014082204796Skin · crackedCRACKED OUTER SKIN AT CUTOUT OF MAIN PAX DOOR HANDLE. REPAIRED IAW ER/A NR 501106-14MA, REV ORIGINAL.SDR UHLA2014082000558Door · unknownL1 DOOR WON'T CLOSE. RESET DOOR IAW FIM 52-11-00-810-805-A. OPS CHECKED GOOD.SDR USAA2014082100007Bottle · low pressureA CHECK 2R DOOR ASSIST BOTTLE PRESS IS LOW. SERVICED 2R DOOR ASSIST BOTTLE IAW JOB CARD 33C80052002.SDR USAA2014082100006Bottle · low pressureA CHECK 2L DOOR ASSIST BOTTLE PRESS IS LOW. SERVICED 2L DOOR ASSIST BOTTLE IAW JOB CARD 33C80052002.SDR USAA2014082100005Bottle · low pressureA CHECK 4L DOOR ASSIST BOTTLE PRESS IS LOW. SERVICED 4L DOOR ASSIST BOTTLE IAW JOB CARD 33C80052002.SDR USAA2014082100004Bottle · low pressureA CHECK 2R DOOR ASSIST BOTTLE PRESS IS LOW. SERVICED 2R DOOR ASSIST BOTTLE IAW JOB CARD 33C80052002.SDR USAA2014082100003Bottle · low pressureA CHECK 2L DOOR ASSIST BOTTLE PRESS IS LOW. SERVICED 2L DOOR ASSIST BOTTLE IAW JOB CARD 33C80052002.SDR USAA2014082100002Bottle · low pressureA CHECK 1R DOOR ASSIST BOTTLE PRESS IS LOW. SERVICED 1R DOOR ASSIST BOTTLE IAW JOB CARD 33C80052002.SDR MASA2014082002335Door · dirtyPAX DOOR HARD TO OPEN FROM INSIDE. CLEANED LUBED AND REMOVED DEBRIS.SDR SWAA2014082031038Skin · crackedL1 DOOR INNER SKIN CRACKED AT LOWER HINGE BOX. REPAIRED SKIN IAW EA 1-352-1548.SDR USAA2014082000003Bottle · low pressureL1 DOOR ASSIST BOTTLE PRESS IS LOW. SERVICED L1 DOOR ASSIST BOTTLE IAW AMM 52-10-00.SDR SIMA20140818010Step · crackedPASSENGER DOOR FWD SIDE OF MID STEP CRACKED ON THE RADIUS AT RETAINING BRACKET. REPAIRED PAX DOOR IAW SRM 52-11-04.SDR SIMA20140818009Step · crackedPASSENGER DOOR AFT SIDE OF MID STEP CRACKED ON THE RADIUS AT RETAINING BRACKET. REPAIRED PAX DOOR IAW SRM 52-11-04.SDR GTIA2014081801411Bottle · low pressureL2 DOOR ASSIST CYLINDER HAS LOW PRESSURE SERVICED L2 DOOR ASSIST CYLINDER AMM-52-10-00.SDR UHLA2014081800555Door · unknownL1 DOOR STICKING WHEN OPENING FROM OUTSIDE, HAD TO BE OPENED FROM INSIDE. PERFORMED OPS CHECK ON L1 DOOR, OPS CHECK GOOD AT THIS TIME IAW AMM 52-12-52.SDR UHLA2014081800554Door · leakingF/A'S AND PAX COMPLAIN OF LOUD SQUEAL COMING FROM L1 DOOR, ALL PHASES OF FLIGHT. PERFORMED CABIN PRESSURIZATION LEAK TEST IAW AMM 21-31-00. OPS CHECKED GOOD.SDR GTIA2014081801410Bottle · low pressureL2 DOOR ASSIST CYLINDER HAS LOW PRESSURE. SERVICED L2 DOOR ASSIST CYLINDER AMM 52-10-00.SDR FDEA201408172192Liner · out of positionR1 DOOR SLIDE PACK HITS AFT SIDE OF DOOR CUT OUT WHILE BEING CLOSED. REF SNRDS 00005 & 00012 OF HANGAR WORK ORDER 61879. R & R R1 DOOR ESCAPE SLIDE IAW AMM 25-66-01-4. ORIGINAL DISCREPANCY STILL EXISTS. DOOR SLIDE HAS BEEN REPLACED & DOOR WILL BE CHECKED SDR USAA2014081800006Gust Lock · dirtyDOOR 1L GUST LOCK INOPERATIVE. CLEANED DOOR 1L GUST LOCK CONTROL MECHANISM IAW AMM 52-10-00-100-801A.SDR QXEA2014082200701Angle · corrodedFOUND FWD PAX DOOR ANGLE CORRODED, ANGLE REPLACED IAW SRM 51-42-05-02-01.SDR QXEA2014082200700Angle · corrodedFOUND CORRODED ANGLE ON FWD PAX DOOR, COMMON TO WEB AND INTERCOSTAL AT STA 6.70. REMOVED AND REPLACED ANGLE IAW SRM 51-42-05-02-01.SDR GTIA2014081601408Bottle · low pressureAFT R2 DOOR HAS LOW PRESSURE. SERVICED R2 DOOR IAW AMM 52-12-14. LEAK CHECKED GOOD.SDR USAA2014081800001Damper · low pressureDOOR 2R SLIDE PRESS LOW. SERVICED DOOR DAMPER & EMER OPERATION CYLINDER AT DOOR 2R TO NORMAL PRESS.
Back to JASC 5210