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 2007UALA01795Strap · out of adjustDOOR 2L HARD TO ARM.SDR SWIA200718436Frame · crackedPAX DOOR CENTER FORWARD FRAME IS CRACKED, DISCOVERED AT C-CHECK. REPLACED CENTER FORWARD FRAME IAW SRM 51-40-02, PN 120-21058-003.SDR SWIA200718435Frame · corrodedPAX DOOR FORWARD UPPER CORNER FRAME IS CORRODED, DISCOVERED AT C-CHECK. REPLACED FORWARD CORNER FRAME WITH NEW PART IAW EMB 120 SRM 51-40-02, P/N 120-26550-001.SDR TRAX200700778Longeron · corrodedFOUND CORROSION ON PASSENGER DOOR LOWER LONGERON.SDR SWIA200718493Web · crackedPAX DOOR AFT WEB IS CRACKED BETWEEN 2ND AND 3RD STEP, DISCOVERED AT C-CHECK. COMPLIED WITH STEPS 1-17 OF REO 670-52-11-104 FOR DOOR REPAIR.SDR SWIA200718492Drag Angle · crackedPAX DOOR AFT DRAG ANGLE IS CRACKED, DISCOVERED AT C-CHECK. COMPLIED WITH STEPS 1-13 ON REO 670-52-11-072 FOR REPAIR ON PAX DOOR DRAG ANGLE ON AFT SIDE.SDR SWIA200718491Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT 2ND STEP, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS PER REO 670-52-11-104.SDR A6WA200740305Drag Angle · crackedAFT PAX DOOR DRAG ANGLE IS CRACKED APPROX 1 INCH LONG. (M) [07-31-07] MAINTENANCE FOUND DAMAGE TO BE LOCATED ON PREVIOUS REPAIR. REMOVED PREVIOUS REPAIR ANGLE FABRICATED NEW ANGLE INSTALLED AND SEALED PAINTED IAW REO 601R52-11513. (K)SDR 2007UALA01769Cylinder · unreliableFOUND DOOR 4R EPAS DOOR CYLINDER SQUIB TO HAVE NO EXPIRATION DATE. [07-06-07] REPLACED EPAS DOOR ASSIST CYCLINDER SQUIB WITH ONE THAT HAS AN EXPIRATION DATE & AIRPLANE OK FOR SERVICE.SDR SWIA200718300Lever · out of adjustCABIN DOOR IS HARD TO OPEN FROM THE GROUND. ADJUSTED SWIVEL LEVERS, ADJUSTMENT BOLTS AND STOPS IAW 52-11-17. OPS CHECK GOOD.SDR FDKA200705257Roller · dirtyFDM 6000 BNA-MCO (0623 PHX LCL). MAIN CABIN DOOR IS HARD TO OPEN AND CLOSE. MX CLEANED AND LUBED THE DOOR ROLLERS, OPS CHECK NORMAL.SDR FDKA200705256Handle · unsecureFDM 6049 VPS-MCO (0514 PHX LCL). MAIN CABIN DOOR IS HARD TO OPEN AND CLOSE. MX SECURED THE INNER DOOR HANDLE, OPS CHECK NORMAL.SDR 2007UALA01767Web · crackedFWD ENTERY DOOR CUTOUT HINGE BOX WEB CRACKED AT STR 10L AT BODY STA 294. FABRICATED AND INSTALLED ATTACHED ANGLE REPAIR.SDR SWAA072761Fitting · damagedR1 DOOR STUCK CLOSED. FOUND LOWER AFT CAM FITTING DAMAGED. REMOVED AND REPLACED CAM ROLLER FITTING PER SWA EA.SDR TRAX200700766Handle · crackedASD OUTER HANDLE CRACKED. [06-08-07] REMOVED AND REPLACED ASD OUTER HANDLE IAW CRJ 700 MM 52-11-03.SDR 2007UALA01740Light · inoperativeDOOR 2R ARMING LIGHT INOPERATIVE. [06-20-07] REPLACED DOOR 2R PROX SENSOR.SDR 2007UALA01731Structure · crackedNR 2R MED CABIN DOOR UPPER HINGE CUTOUT CRACKED. [06-20-07] MAJOR REPAIR ACCOMPLISHED. REPAIRED 2R MAIN ENTRY CABIN DOOR UPPER HINGE CUT OUT PER UA ENGINEERING SPECIFICATIONS.SDR SWIA200718363Web · crackedPAX DOOR AFT WEB IS CRACKED AT SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND EXTERNAL DOUBLER IAW REO 670-52-11-104 P 2-6.SDR SWIA200718362Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT SUPPORT BRACKET, DISCOVERED AT C-CHECK. INSTALLED REPAIR ANGLES AND DOUBLER AS PER REO 670-52-11-104.SDR TRAX200700772Drag Angle · crackedAFT DRAG ANGLE ON PAX DOOR IS CRACKED.SDR TRAX200700743Handle · crackedOUTER PAX DOOR HANDLE IS CRACKED. [07-24-07] REPAIRED IAW AMM 52-11-03, AMM 52-11-02, AND AMM 52-11-03. NO DEFECTS NOTED AT THIS TIME.SDR COMA0760402Handle · unsecureFLIGHT 5078 - PAX DOOR OUTER HANDLE CAUTION AFTER TAKEOFF. AIRCRAFT RETURNED BACK TO JAX AND LANDED SAFELY. PAX DOOR OUTER HANDLE VERIFIED NOT STOWED BY GROUND CREW. INSPECTED PAX DOOR OUTER HANDLE AND PERFORMED OPS CHECKS, NO DEFECTS NOTED.SDR DL764070609Seal · looseRTB - DOOR SEAL LOOSE 4L DOOR. CKD PRESS SEAL DOOR 4L OK, REPOSITIONED COVER DOOR SEAL 4L.SDR 2007UALA01673Door Frame · crackedR-2 DOOR, FORWARD FRAME AT UPPER HINGE CUTOUT IS CRACKED. MAJOR REPAIR ACCOMPLISHED: FABRICATED & INSTALLED A CRES DOUBLER.SDR FDKA200705225Roller · lack of lubeFDM 6129 RDU (1038 PHX LCL). MAIN CABIN DOOR HARD TO CLOSE. MX LUBED DOOR ROLLER, OPS CHECK GOOD.SDR SWIA200718361Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT SECOND STEP, DISCOVERED AT C-CHECK. REPAIRED FORWARD PAX DOOR WEB PER CRJ7/9 REO 670 52-11-104.SDR SWIA200718360Web · crackedPAX DOOR AFT WEB IS CRACKED IN 2 PLACES BETWEEN SECOND AND THIRD STEPS, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS PER BOMBARDIER REO 670-52-11-104 REV B.SDR MASA200700282Door · out of rigASH 7256 ORD - PAX DOOR W/NOT CLOSE. MX IS IN THE PROCESS OF RIGGING THE DOOR.SDR FDKA200705222Mechanism · lack of lubeFDM FLT 6159 RDU-FLL (1036 PHX LCL). PASSENGER DOOR IS HARD TO OPEN AND CLOSE. MX LUBED THE PASSENGER DOOR, OPS CHECK NORMAL.SDR SWIA200718359Structure · crackedPAX DOOR CRACKED ON FORWARD SIDE OF STEP NR 2. INSTALLED EXTERNAL DOUBLER AND REPAIR ANGLES PER CRJ700/900 SRM 51-42-06.SDR SWIA200718358Web · crackedPAX DOOR WEB CRACKED AT AFT SIDE OF NR 2 STEP, DISCOVERED AT C-CHECK. INSTALLED EXTERNAL DOUBLER AND REPAIR ANGLES IAW CRJ 700 SRM 51-42-06.SDR TRAX200700718Bracket · crackedPAX DOOR AFT CABLE COUNTER BALANCE ANCHOR BRACKET CRACKED.SDR TRAX200700717Anchor Fitting · crackedPAX DOOR AFT ANCHOR FITTING CRACKED. [07-23-07] REPAIRED IAW; AMM 52-11-17, AMM 25-21-01, AND AMM 25-26-02,SDR TRAX200700716Anchor Fitting · crackedPAX DOOR FWD ANCHOR FITTING CRACKED. [07-23-07] REPAIRED IAW; AMM 52-11-17, AND AMM 52-11-17.SDR SWIA200718388Web · crackedPAX DOOR FORWARD WEB IS CRACKED AT THE CORNER OF STEP 1 AND STEP 2, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS ON FORWARD WEB PER CRJ200 REO 601R 52-11-702 REV A STEPS 8-17.SDR SWIA200718387Web · crackedPAX DOOR AFT WEB STEPS 1 AND 2 ARE CRACKED, DISCOVERED AT C-CHECK. INSTALLED REPAIR PARTS ON AFT SIDE OF PAX DOOR PER REO 601R 52-11-702 REV A.SDR DHL2007740507Skin · brokenL-2 DOOR LOWER HINGE ARM SKIN IS BROKEN AT FWD END. REMOVED SKIN SECTION IAW B727 SRM 51-30-2. FABBED NEW SKIN FROM 2024-T3 0.050" PO NR 9005049, DIM 9" BY 1 1/2 " IAW B727 SRM 52-40-1 FIG 4 AND 51-20-1. TREATED AN PRIMED NEW PART IAW B727 SRM 51-10-2 AN INSDR AWXA200700677Fitting · wornSAL - R1 DOOR UPPER SUPPORT ARM FITTING WORN CAUSING BEARING TO MIGRATE OUT OF THE FITTING. REPLACED R1 DOOR UPPER SUPPORT ARM FITTING IAW A319 SRM 51-72-11.SDR SWIA200718439Frame · crackedPAX DOOR HAS A CRACK NEAR FRAME 5 ON FORWARD SIDE, DISCOVERED AT C-CHECK. NEW FRAME INSTALLED IAW SRM 120 51-10-02 PG 3 SEC 3A.SDR SWIA200718438Frame · crackedPAX DOOR HAS CRACK ON FORWARD SIDE AT FRAME 3, DISCOVERED AT C-CHECK. REPAIRED CRACKED BRACKET IAW EMB SRM 52-10-02 FIG 203.SDR SWIA200718437Bracket · crackedPAX DOOR HAS A CRACK AT THE AFT LOWER RADIUS AREA, DISCOVERED AT C-CHECK. REPLACED CRACKED BRACKET IAW EMB SRM 51-40-02.SDR 2007UALA01585Seal · out of adjustDOOR 2L WON'T ARM. *S/D* ADJUSTED LOWER DOOR SEAL ON DOOR 2L. OP CHECKS NORMALLY.SDR MASA200700276Handle · stuckASH 2611 CLT - PASSENGER DOOR OUTER HANDLE IS NOT FULLY CLOSING. MX UNSTUCK THE HANDLE.SDR FDKA200705213Handle · out of adjustFDM 5998 ATL-GPT (1131 PHX LCL). MAIN CABIN DOOR HARD TO OPEN. MX ADJUSTED INNER HANDLE, OPS GOOD.SDR UPS07149829Fitting · dirtyINSPECTION TYPE:N/A ESCAPE SLIDE WILL NOT ARM. REMOVED DEBRIS FROM FWD FLOOR FITTING CONSISTING OF SAFETY WIRE SCRAPS AND SHOP RAG STRINGS. OPS CHECK PER 52-10-30-05F. OK FOR SERVICE.SDR MASA200700272Door · out of rigASH 2832 LAS - PAX DOOR WOULD NOT OPEN. REPEAT PROBLEM. AIRCRAFT FERRIED TO PHX WHERE MX RIGGED AND LUBED THE DOOR.SDR MASA200700271Door · lack of lubeASH 2721 PHX - CREW REPORTED TROUBLE HAVING PROBLEM OPENING PAX DOOR. MX CLEANED AND LUBED DOOR.SDR MASA200700270Latch · lack of lubeASH 2864 PHX - PAX DOOR WOULD NOT OPEN. MX REMOVED DRIED LUBE FROM THE MECHANISM AND CLEANED THE LATCHES AND RELUBED.SDR FDKA200705208Door · damagedFDM 6116 PFN-MCO (1552 PHX LCL). MAIN CABIN DOOR DAMAGED BY TUG. A/C FERRIED TO BNA FOR REPAIRS.SDR QXEA200700817Pin · bindingPDX FLIGHT NR 2454: FA ADVISES THAT LEFT REAR DOOR HARD TO OPEN AND CLOSE. MAINTENANCE REMOVED AND REPLACED EXTERNAL MECHANISM GUIDE PINS WHICH WERE BINDING. OPS CHECK GOOD. AIRCRAFT RETURNED TO SERVICE.
Back to JASC 5210