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 USAA070193Pin · crackedL1 DOOR AT NR 5 STOP PIN CRACKED. INSTALLED DOUBLER PER TR 52-10-16, DEFECT SIZE: .5 INCH.SDR FDKA200703121Seal · unknownFDM 6116 PFN-MCO (1705 PHX LCL). MAIN CABIN DOOR HARD TO OPEN. MX PERFORMED RIG AND REMOVED AND REPLACED DOOR SEAL.SDR MZZA0700005Bearing · frozenTHE L-1 DOOR WAS DIFFICULT TO OPEN AND CLOSE. MAINTENANCE FOUND THE CAM FOLLOWER BEARING FROZEN. THE BEARING WAS REPLACED. OPERATIONAL CHECKS WERE GOOD IAW MM 52-11-00.SDR USAA070192Skin · crackedL1 DOOR AT NUMBER 6 STOP PIN CRACKED. INSTALLED DOUBLER PER TR 52-10-16, DEFECT SIZE: .5 INCH.SDR SWIA200718145Web · crackedPAX DOOR AFT WEB CRACKED AT TOP OF MIDDLE STEP, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND DOUBLER TO AFT PAX DOOR WEB PER CRJ200 REO 601R 52-11-702 REV 'A' STEP 8-12.SDR SWIA200718144Web · crackedPAX DOOR AFT WEB CRACKED AT HANDRAIL SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND DOUBLER ON AFT PAX DOOR WEB PER CRJ200 REO 601R-52-11-702 REV A STEP 5-12.SDR SWIA200718143Web · crackedPAX DOOR FORWARD WEB CRACKED AT TOP OF MIDDLE STEP, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLE AND DOUBLER ON FORWARD PAX DOOR WEB PER CRJ200 REO 601R 52-11-702 REV 'A' STEPS 8-12.SDR SWIA200718142Web · crackedPAX DOOR FORWARD WEB CRACKED AT HANDRAIL SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND DOUBLER ON FORWARD PAX DOOR WEB PER CRJ200 REO 601R-52-11-702 REV A STEP 8 THRU 12.SDR SWIA200718138Web · crackedPAX DOOR AFT WEB IS CRACKED IN THE RADIUS OF STEP NR 2 DISCOVERED AT C-CHECK. INSTALLED REPAIR DOUBLER ON PAX DOOR AFT SIDE PANEL STEP NR 2 PER CRJ200 REO 601R-52-11-1207.SDR SWIA200718136Web · crackedPAX DOOR FORWARD WEB IS CRACKED IN THE RADIUS OF STEP NR 2, DISCOVERED AT C-CHECK. INSTALLED REPAIR DOUBLER ON PAX DOOR FORWARD SIDE PANEL STEP NR 2 PER CRJ200 REO 601R-52-11-1207.SDR FDKA200703117Mechanism · lack of lubeFDM 6099 ATL-LEX (0642 PHX LCL). MAIN CABIN DOOR IS HARD TO OPEN AND CLOSE. MX LUBED AND ADJUSTED THE MAIN CABIN DOOR AND OPS CHECK NORMAL.SDR TRAX200700370Handle · crackedASD (PAX DOOR) OUTER HANDLE CRACKED. PAX DOOR OUTER HANDLE REMOVED AND REPLACED.SDR SWIA200718026Mechanism · contaminatedFOUND MAIN CABIN DOOR WILL NOT OPEN FROM INSIDE/OUTSIDE. REMOVED EXCESSIVE LUBRICATION FROM HANDLE MECHANISM. OPERATIONAL CHECKS GOOD.SDR SWAA071355Skin · crackedDURING SCHEDULED C2 CHECK, FOUND L1 DOOR SKIN CRACKED AT UPPER AFT CORNER. REPAIRED SKIN PER SRM.SDR 2007FA0313001Hinge · crackedDESCRIPTION AMENDED TO SAY THAT THE LOWER LUG WAS CRACKED INSTEAD OF THE UPPER LUG.SDR SWIA200718355Rib · crackedPAX DOOR RIB MIDWAY UP THE AFT SIDE OF DOOR IS CRACKED. REPLACED RIB IAW SRM 51-10-02 PG 3 SEC 3A.SDR AWXA200700489Door Frame · crackedMCN - R1 DOOR AFT FRAME CRACKED, BS 328, S15R AT THE 5TH STOP PIN CUT OUT. REPAIRED R1 DOOR AFT FRAME, BS 328, S15R AT THE 5TH STOP PIN CUT OUT IAW AWA ER 03-5200-07098-SS1.SDR AWXA200700481Door Frame · crackedMCN - CRACKED L1 DOOR AFT FRAME, BS 348, S13L - S14L, NEAR STOP PIN CUTOUTS NR 6 AND NR 7. REPAIRED L1 DOOR AFT FRAME, BS 348, S13L - S14L, NEAR STOP PIN CUTOUTS NR 6 AND NR 7 IAW ER 03-5200-07097-ES1.SDR AWXA200700480Skin · crackedMCN - CRACKED L1 DOOR INNER SKIN, BS 347.30, S12L - S14L, NEAR STOP PIN CUTOUTS NR 5, NR 6 AND NR 7. REPAIRED L1 DOOR INNER SKIN, BS 347.30, S12L - S14L, NEAR STOP PIN CUTOUTS NR 5, NR 6 AND NR 7 IAW ER 03-5200-07097-ES1.SDR SWIA200718065Web · crackedPAX DOOR FWD WEB CRACKED AT TWO LOCATIONS STEP NR 2 BASE AND NR 3 STEP, FROM, TOP DOOR OPEN, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AS PER REO 670-52-11-104 REV B. OPERATIONAL CHECKS GOOD.SDR SWIA200718064Web · crackedPAX DOOR AFT WEB, STEP NR 2 AND NR 3 CRACKED, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED REPAIR PARTS AS PER REO 670-52-11-104 REV B. OPERATIONAL CHECKS GOOD.SDR 2007UALA00725Liner · crackedFWD ENTRY DOOR LINER AFT LOWER CORNER CRACKED WITH A SHARP EDGE STICKING OUT. MAJOR REPAIR ACCOMPLISHED: FABRICATED AND INSTALLED A DOUBLER REPAIR.SDR 2007UALA00724Torque Tube · crackedFWD ENTRY DOOR BODY TORQUE TUBE SLEEVE ON LOWER SPIGOT CRACKED. MAJOR REPAIR ACCOMPLISHED: REMOVED AND REPLACED FUSELAGE TORQUE TUBE.SDR CALA0700126Pawl · brokenTHE L-2 DOOR WOULD NOT ARM PRIOR TO PUSHBACK. THE EXTERIOR PAWL WAS FOUND BROKEN. THE INTERLOCK PAWL WAS REPLACED IAW MM 52-11-26.SDR 07FDEA00738Skin · misrepairedPREVIOUS REPAIR FOUND LOCATED ON LOWER SECTION OF NR 2 RT DOOR. REPAIR REQUIRES EVALUATION FOR MAJOR/MINOR DETERMINATION AND IF THE REPAIR WAS ACCOMPLISHED USING FAA APROVED DATA. EXISTING REPAIR EVALUATED AND FOUND NOT TO CONFORM TO AN EXISTEING SRM REPAIR.SDR TRAX200700337Handle · crackedPAX DOOR OUTER HANDLE CRACKED. REMOVED PAX DOOR LATCH MECHANISM TO FOM. REMOVED PAX DOOR OUTER HANDLE JB422. INSTALLED SERVICEABLE FLAP HANDLE ONTO SERVICEABLE HANDLE MECHANISM PN 601R31763-1 IAW CRJ SRM 51-42-04. OK TO PRIME & PAINT PAX DOOR OUTER HANDLE. PASDR A6WA200740122Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED. REPAIRED IAW REO 601R-52-11-513, REV A. (K)SDR AWXA200700441Stop Fitting · crackedMCN - R1 DOOR CRACKED AT 4TH AFT STOP FITTING CUTOUT FROM TOP, BS 299, WL 246. REPAIRED R1 DOOR AT 4TH AFT STOP FITTING CUTOUT FROM TOP, BS 299, WL 246 IAW AWA ER 03-5211-07081-ES3.SDR FDKA200703102Roller · lack of lubeFDM 6038 ATL-CLT (1224 PHX LCL). MAIN CABIN DOOR WILL NOT CLOSE COMPLETELY. MX LUBED ROLLERS, OPS CHECK GOOD.SDR 2007UALA00711Bearing · wornAFT ENTRY DOOR FUSELAGE TORQUE TUBE UPPER AND LOWER SERPENTINE PLATE BEARINGS ARE WORN. MAJOR REPAIR ACCOMPLISHED: REMOVED & REPLACED UPPER & LOWER BEARINGS. INSTALLED PLATES.SDR 2007UALA00710Torque Tube · wornAFT ENTRY DOOR FUSELAGE TORQUE TUBE LOWER SPIGOT WORN. MAJOR REPAIR ACCOMPLISHED: REMOVED AND REPLACED FUSELAGE TORQUE TUBE.SDR 07FDEA00712Structure · damagedFOUND ON R1 PASS DOOR, AT THE LOWER LT CORNER, SEVERAL SPOTS WITH MISSING MATERIAL (SHEET METAL) REPAIRED PER SRM 52-11-00 FIG 206. REPAIR EVALUATED PER GMM 6-2-100 AND CLASSIFIED AS "MAJOR".SDR C2XA07IA056Lock · defectiveIAH - THE CREW REPORTED THAT THE MAIN CABIN DOOR WOULD NOT CLOSE NORMALLY. MAINTENANCE REMOVED AND REPLACED THE FORWARD PAX DOOR LOCK BOX ASSEMBLY, RIGGED AND OPERATIONALLY CHECKED WITH NO DEFECTS NOTED, AND THE AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR AWXA200700442Skin · crackedMCN - L-1 DOOR INNER SKIN CRACKED, AT THE 6TH AND 7TH STOP FROM TOP, BS 347.30, BEAM 12 - BEAM 13. REPAIRED L-1 DOOR INNER SKIN CRACKED, AT THE 6TH AND 7TH STOP FROM TOP, BS 347.30, BEAM 12 - BEAM 13 IAW AWA ER 03-5200-07084-SS1.SDR SWIA200718135Web · crackedPAX DOOR WEB CRACKED UNDER HANDRAIL SUPPORT BRACKET ON FORWARD SIDE, DISCOVERED ON C-CHECK. INSTALLED BRACKET REPAIR P/N 601R-52-11-702-1, -2, AND -3 PER REO 601R-52-11-702 PG 1-4.SDR SWIA200718129Web · crackedPAX DOOR WEB CRACKED UNDER HANDRAIL SUPPORT BRACKET ON AFT SIDE, DISCOVERED AT C-CHECK INSPECTION. INSTALLED FABRICATED PARTS 601R-52-11-702-7, -9,-17,-19,-15,-16 AND -21 PER REO 601R-52-11-702A.SDR SWIA200718000Web · crackedPAX DOOR AFT WEB CRACKED AT STEP 4 BASE END, ADJACENT TO STEP 3 FROM THE BOTTOM AND STEP 5 AT THE BASE STEP 4 CRACKED, DISCOVERED DURING C-CHECK INSPECTION. COMPLIED WITH REO 670-52-11-104 REV B.SDR SWIA200717999Web · crackedPAX DOOR FWD WEB CRACKED AT STEP 5 BASE END ADJACENT TO STEP 4 FROM THE BOTTOM, DISCOVERED DURING C-CHECK INSPECTION. INSTALLED DOUBLER AND REPAIR ANGLES PER REO 690-52-11-104 REV B REPAIR ZONE 2 REO 670-52-11-104 REV B COMPLETE.SDR TRAX200700325Door · unknownPAX DOOR W/N CLOSE, HAND RAIL PIN DIFFICULT TO REMOVE. FLT 4519 DEL 67 MINS.SDR SWAA071236Link · crackedL1 DOOR WILL NOT COMPLETELY OPEN. REMOVED AND REPLACED CRACKED LOWER GUIDE ARM LINK, REINSTALLED PIN PER MM.SDR KNNA200700020Skin · damagedMAIN ENTRY DOOR L-2 EXTERIOR SURFACE, UPPER AFT CORNER, SKIN BEND. PROVIDE INSTRUCTIONS ON REPAIR OF DOOR SKIN. CUT OUT BEND CORNER AND REPAIR PER SRM 52-00-3 FIGURE 5.SDR 2007UALA00658Bottle · reads lowDOOR BOTTLE AT 2L REPORTED LOW. [SUP 05-24-07] SERVICED BOTTLE TO PROPER PRESSURE.SDR TRAX200700317Handle · brokenPAX DOOR HANDLE BROKEN.SDR A6WA200740097Anchor Fitting · crackedPAX DOOR ANCHOR FITTING (FWD) PN 601R380742-3 IS CRACKED. MAINTENANCE REPLACED PAX DOOR ANCHOR FITTING (FWD) PN 601R3807423 IAW AMM 52-11-17-400-803. (K)SDR A6WA200740096Anchor Fitting · crackedPAX DOOR ANCHOR FITTING (AFT) PN 601R3807413 IS CRACKED. MAINTENANCE REPLACED PAX DOOR ANCHOR FITTING (AFT) PN 601R3807413 IAW AMM 52-11-17-400-803. (K)SDR CALA0700103Beam · crackedCRACKED L1 DOOR AFT SIDE OF THE THIRD FROM BOTTOM DOOR STOP CUTOUT. REPAIRED IAW ECRA 5210-01919.SDR 2007UALA00618Hinge · crackedDOOR 2R UPPER HINGE CUTOUT IS CRACKED. MAJOR REPAIR ACCOMPLISHED: TRIMMED OUT DAMAGE & ACCMP'D INSURANCE CUT. NO CRACKS FOUND. FABRICATED & INSTALLED REPAIR DOUBLER.SDR SWAA071153Skin · crackedDURING SCHEDULED SPV CHECK, FOUND R1 DOOR SKIN CRACKED AT BS 304, STR 15R. REPAIRED SKIN PER EA.SDR QXEA200700303Handle · damagedSEA FLIGHT NR 2378: FOUND MAIN CABIN DOOR EXTERIOR OPEN HANDLE RECESSES TOO DEEP, CANNOT OPEN DOOR FROM OUTSIDE. MAINTENANCE SHIMMED EXTERIOR DOOR HANDLE STOP BUMPER AS REQUIRED FOR FLUSH FIT OF HANDLE. DOOR OPERATES NORMALLY OPENING AND CLOSING. NO PARTS RSDR MASA200800176Web · crackedREPAIRED THE PAX DOOR AFT WEB CRACKS.
Back to JASC 5210