N411ZW
Service difficulty reports · 234
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 n_number = 'N411ZW' AND registry_match = 'registration' 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 n_number = 'N411ZW' AND registry_match = 'registration' 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 A6WA201340218801Support Angle · crackedCARGO BAY DOOR SUPPORT BRACKET HAS CRACKED SUPPORT ANGLE ON 621 BULKHEAD. REMOVED UNSERVICEABLE ANGLE AND REPLACED WITH SERVICEABLE ANGLE, FABRICATED FROM MATERIAL 2024 T3 .040 IAW CRJ 200 SRM 51-24-21, 51-42-21.SDR A6WA201240649Control Handle · inoperativeAFTER TAKE OFF, SELECTED GEAR UP. RECEIVED ANTI-SKID INBD CAUTION, AND PARK BRAKE SOV CAUTION MESSAGES. GEAR DID NOT MOVE. NO GEAR DISAGREE MESSAGE DISPLAYED. R & R LANDING GEAR CONTROL HANDLE IAW AMM 32-31-01. OPS CHECKED GOOD. GEAR RETRACTION/EXTENSIONSDR A6WA201141150Check Valve · failedAFTER LANDING, STRONG SMOKE ODOR IN COCKPIT FOLLOWED BY LT PACK HIGH TEMP CAUTION MESSAGE, FOLLOWED BY SMOKE TOILET CAUTION MESSAGE. COMPLIED WITH QRH. ACTUAL SMOKE AND TEMP MESSAGE REMOVED. FOUND LT PACK FAN BYPASS CHECK VALVE, RAM AIR CHECK VALVE MISSING BSDR A6WA201141053Switch · failedMACH TRIM & STAB TRIM CAUTION MESSAGES CLIMBING THROUGH 12,000 FT. RAN QRH, WOULD NOT RESET. LANDED AT 45,000 LBS, SPEED 150 KTS, TOUCHDOWN APPROXIMATELY 200 FPM. R & R PITCH TRIM DISCONNECT SWITCH.SDR A6WA201140962Floorbeam · crackedFLOORBEAM CRACKED AT THE 280 BULKHEAD, RBL 9. REPAIRED FLOORBEAM IAW REO 601R-53-11-136, 601R-53-11-2225 AND 601R-53-11-171.SDR A6WA201141058Floorbeam · crackedFLOORBEAM IS CRACKED AT BS 280 BULKHEAD. LT SIDE IS JUST OTBD OF LBL9. R & R DAMAGED IAW REO 601R-53-11-171 & 601R-53-11-138.SDR A6WA201141067Handle · crackedPAX DOOR HANDLE IS CRACKED. R & R PAX DOOR HANDLE, PN 601R-31763-1.SDR A6WA201141061Lug · gougedHORIZONTAL STAB LT OTBD LUG GOUGED. BLENDED DAMAGED AREA NDT INSPECTED FLAP PEENED, ALODINED, PRIMED IAW REO 601R-55-11-391.SDR A6WA201141073Bracket · crackedLOWER U-BRACKET AT FS 574 CRACKED. REMOVED DAMAGED U-BRACKET AND INSTALLED NEW CHANNEL PN 601R-35050-25 IAW SRM 51-42-06, 51-40-11, 51-25-16.SDR A6WA201141056Beam · corrodedSEVERAL SCREW HOLES ON THE RBL 27 BEAM HAVE LIGHT CORROSION FROM FS 605 TO 621. REMOVED OUT OF LIMITS PORTION OF BEAM AND SPLICED IN NEW BEAM IAW SRM 53-00-43.SDR A6WA201141057Floorbeam · corrodedBS 559.0+112 LBL 27 FLOORBEAM CAP CORRODED. R & R LBL 27 FLOORBEAM CAP IAW FORM 412 AND SRM.SDR A6WA201141065Vane · chafedRT INBD FLAP VANE CHAFED 2 EA PLACES. BLENDED OTBD CHAFED AREA, ALODINED, PRIMED AND TOP COATED AND APPLIED TEFLON COATING IAW REO 601R-57-52-004. REMOVED INBD L/E SKIN, INSTALLED NEW SKIN PN 601R14303-54 AND TOP COATED IAW SRM 51-42-13, 51-23-00, 51-25-16.SDR A6WA201141070Stiffener · crackedCRACKED FWD STIFFENER ON PANEL 446L, REPAIRED CRACKED STIFFENER IAW CMM 78-11-00-997-022-A07.SDR A6WA201141063Access Panel · chafedFLAP ACCESS PANEL 584AB CHAFED PN 601R14003-23. REPAIR IAW REO 601R-31-52-1799.SDR A6WA201141071Access Panel · corrodedFUEL PANEL 510AB CUT OUT HAS FRETTING CORROSION. BLENDED AREAS OF FRETTING .003 MAX REMOVED CPX-7, REF 326, CAL DUE 6/14/12 NDT INSPECTED, ROTO PENNED, SANDED, ALODINED AND PRIMED IAW REO 601R-57-21-030.SDR A6WA201141068Door · chafedLT MLG DOOR IS CHAFED. BLENDED CHAFING IAW REO`S.SDR A6WA201141072Skin · gougedRT LOWER CORE COWL INNER SKIN GOUGED 3EA SEATS 85-3. REPAIRED 3 EA LOCATION ON RT LWR INNER CORE COWL SKIN IAW CMM 71-12-01. REPAIR NR SRS046.SDR A6WA201141062Vane · chafedLT INBD FLAP VANE L/E CAPS CHAFED INBD 601R14303-53 CENTER 601R14303-39, OTBD 601R14303-43. REPLACED INBD IAW SRM 51-42-13. REPAIR OTBD AND CENTER IAW REO 601R-57-52-004.SDR A6WA201140943Seat Track · corrodedSEAT TRACK ON RT SIDE CORRODED. REMOVED AND INSTALLED NEW SERVICEABLE SECTION OF SEAT TRACK AMM 53-01-11.SDR A6WA201140944Seat Track · corrodedSEAT TRACK ON LT SIDE CORRODED. REMOVED AND INSTALLED NEW SERVICEABLE SECTION OF SEAT TRACK IAW AMM 53-01-11.SDR A6WA201141069Access Panel · chafedAILERON LOWER ACCESS PANEL 559AB HAS CHAFE DAMAGE. BLENDED CHAFED AREA ON AILERON LOWER ACCESS PANEL IAW SRM 51-12-00. REMOVED .009 OF MAT, MAT THICKNESS .081 REMAINS ORIGINAL THICKNESS .090 REMAINING MAT IS WHAT INSERVICEABLE LIMITS IAW REO 601R-57-60-020.SDR A6WA201141059Angle · crackedRT OBLIQUE ANGLE AT FS 625.00 CRACKED. R & R IAW REO 601R-53-61-422 AND SRM 51-40-11, 51-42-21, 51-42-06.SDR A6WA201141055Sill · corrodedRT FLOOR SILL BETWEEN FS 473.15 AND FS 529.00 HAS CORROSION REMOVED. CORROSION & RESTORED FINISH IAW REO 601R-53-41-666.SDR A6WA201140087Skin · dentedFUSELAGE SKIN DENTED AT FS 605 AND STR 25L. REPAIRED IAW REO 601R-53-61-3984.SDR AA6WA201040481Warning Light · false activationRT FLIGHT SPOILER CAUTION MESSAGE ASSOCIATED WITH ACFT ROLLED LT. C/W QRH SPOILER DID NOT DEPLOY. C/A IN PROGRESS.SDR A6WA201040503Control Unit · malfunctionedRT FLIGHT SPOILER CAUTION MESSAGE ASSOCIATED WITH ACFT ROLLED LT. C/W QRH SPOILER DID NOT DEPLOY. FOUND RT SECU`S SYS TEST AND BYTE TEST GOOD. BOTH RT FLT SPOILER PCU`S ELECT AND OPS TEST GOOD. RT OTBD SPOILERONS PCU HAD HIGH RESISTANCE, REQ PCU IAW AMM 27-SDR A6WA200940739Fitting · crackedLEFT TAILPIPE FAIRING VENT FITTING ASSY CRACKED. LT TAIL PIPE FAIRING VENT FITTING ASSY REPLACED IAW SRM 51-42-06. (K)SDR A6WA200940751Intercostal · crackedAFT COMP DOOR RT UPPER INTERCOSTAL IS CRACKED. AFT COMPT DOOR UPPER INTERCOSTAL REPLACED IAW SRM 51-42-06. (K)SDR A6WA200940749Angle · crackedLOWER RT CAP ANGLE OF THE PRESSURE BULKHEAD IS CRACKED FS 669. LOWER RT CAP ANGLE AND PRESSURE BLKHD STRUCTURE AT FS 559 REPAIRED IAW REO 601R-53-41-260 REV D AND REO 601R-53-41-609 REV A DEVIATION D. (K)SDR A6WA200940743Cam · wornLT WING OTBD FLAP, OTBD FLAP BUTTE DOOR CAM WORN. LT WING OTBD FLAP, OTBD BUTTE DOOR CAM REPLACED IAW REO 601R-57-53-016, REV NC. (K)SDR A6WA200940747Bulkhead · crackedAFT PRESSURE BULKHEAD WEB ABOVE CARGO DOOR TRACK IS CRACKED AT FS 621, LBL 27.5, WL 130. CUT OUT ON DAMAGE PORTION OF WEB ABOVE CARGO DOOR TRACK AT FS 621, LBL 27.5, WL 130. NDT PERFORMED ON CUT OUT WET INSTALLATION OF PIECES IAW REO 601R-53-61-1541, REV B. SDR A6WA200940748Hinge · corrodedPAX DOOR TOP FOLDING STEP UPPER HINGE AND SCREWS FOUND CORRODED. PAX DOOR TOP FOLDING STEP UPPER HINGE AND SCREWS REPLACED IAW AMM TASK 52-11-00-430-004. (K)SDR A6WA200940740Intercostal · crackedCRACK FOUND ON INTERCOSTAL FS 484, RBL 36. INTERCOSTAL AT FS 484, RBL 36 REPAIRED IAW REO 601R-53-41-059, REV B. (K)SDR A6WA200940786Longeron · corrodedPAX DOOR LOWER LONGERON IS CORRODED PAX DOOR ENTRANCE LOWER LONGERON, CORROSION REMOVED IAW SRM 51-21-06. (K)SDR A6WA200940746Pressure Blkhd · crackedREAR PRESSURE BULKHEAD WEB IS CRACKED AT THE LINTEL LOCATION FS 621, LBL 46, WL 110. CUT OUT ON WEB AT FS 621, LBL 46, WL 110 NDT PERMORMED ON CUTO OUT, WET INSTALLATION OF ALL PIECES FABRICATED IAW REO 601R-53-61-1230, REV D. (K)SDR A6WA200940745Drag Angle · crackedPASSENGER DOOR AFT DRAG STAIR ANGLE CRACK. PASSENGER DOOR AFT DRAG ANGLE, REPAIRED IAW REO 601R-52-11-513, REV A. (K)SDR A6WA200940784Bracket · crackedLT MLG BAY HYD SUPPORT BRACKET AT FS 528.56 BTW LBL 18 AND LBL 27 CRACKED. LT MLG BAY HYD SUPPORT BRACKET REPLACED IAW SRM 51-42-06.SDR A6WA200940785Bracket · crackedRT MLG BAY HYD SUPPORT BRACKET AT F/S 528.56 BTW RBL 18.0 AND RBL 27.0 CRACKED. REPLACED IAW SRM 51-42-06. (K)SDR A6WA200940744Attach Fitting · crackedINTERCOSTAL CLIP AT FS 484, RBL 27, WL 71 IS CRACKED .300" LONG. INTERCOSTAL CLIP AT FS 484, RBL 27, WL 71 REPLACED IAW SRM 51-42-21. (K)SDR A6WA200940750Angle · crackedLOWER CAP ANGLE OF THE PRESSURE BLKHD IS CRACKED .400" L, LT SIDE. LOWER CAP ANGLE OF THE PRESSURE BLKHD AND PRESSURE BLKHD STRUCTURE AT FS 559 LT SIDE REPAIRED REO 601R-53-41-260, REV D AND REO 601R-53-41-609 REV A DEVIATION D. (K)SDR A6WA200940741Bracket · crackedLT ENG AT 6 O`CLOCK POSITION BRACKET CRACKED FOR T/R ORANGE HARNESS. LT ENG AT 6 O`CLOCK BRACKET FOR T/R ORANGE HARNESS REPLACED IAW SRM 51-42-06. (K)SDR A6WA200940777Skin · damagedFASTENER HOLES IN FWD FUSELAGE ACCESS DOOR SURROUND DOUBLER F/S 228.00, STR 19-20 DAMAGED FASTENER HOLES IN FWD FUSELAGE ACCESS DOOR SURROUND DOUBLER AT FS 228, STR 19-20 LT SIDE REPAIRED IAW REO 601R-53-11-162, REV B.SDR A6WA200940737Handle · crackedMAIN AVIONIC DOOR HANDLE HSG FOUND CRACK. MAIN AVIONIC DOOR HANDLE HSG REPLACED. (K)SDR A6WA200940738Handle · crackedCARGO DOOR HANDLE HSG FOUND CRACK CARGO DOOR HANDLE HSG REPLACED IAW SRM 51-42-21 AND DWG NR PL601R35027, REV AY. (K)SDR A6WA200840654Oxygen Mask · unwanted deployLOG 192917/4 WHEN BATTERY MASTER SELECTED ON OXYGEN MASK FELL PASS OXY PBA INDICATES OFF.SDR A6WA200840364Rudder Pedal · inoperativeNO DIRECTIONAL CONTROL ON TAKEOFF WITH RUDDER PEDALS. ABORTED TAKEOFF. AIRSPEED NOT REGISTERED. BRAKE TEMPS 4,3,2,4. PERFORMED TAXI TEST WITH CREW ASSISTANCE IAW 09-20-00 AT 60 KNOTS. NO DEFECTS NOTED. A/C GOOD FOR SERVICE. (K)SDR A6WA200740596Seal · missingDURING CRUISE INTERMITTENT VIBRATION AT 280 KNOT FOR APPROX 5 SECONDS. ALL ENGINE PARAMETERS WERE NORMAL. APPLIED SEALANT TO WING TO FUSELAGE FAIRING AS REQUIRED IAW CRJ AMM 51-23-00 AS REQUIRED. (M)SDR A6WA200740566Angle · corrodedLEFT PRESSURE FLOOR SILL PLATE ANGLE AT FS 544, LBL 43 CORRODED APPROX .750 INCH DIAMETER. MAINTENANCE FOUND CORROSION TO BE LIGHT. REMOVED APPROX .002 INCH MATERIAL IAW CRJ SRM 51-21-06 3B 1-5. (M)SDR A6WA200740565Angle · corrodedLT PRESSURE FLOOR SILL PLATE ANGLE AT FS 499.0, LBL 43 CORRODED APPROX .750 INCH DIAMETER. MAINTENANCE FOUND CORROSION TO BE LIGHT. REMOVED APPROX .022 INCH MATERIAL IAW CRJ SRM 51-21-06 3B 1-5. (M)SDR A6WA200740564Angle · corrodedRIGHT PRESSURE FLOOR SILL PLATE ANGLE AT FS 461, RBL 43 CORRODED APPROX .750 INCH DIAMETER. MAINTENANCE FOUND CORROSION TO BE LIGHT. REMOVED APPROX .002 INCH MATERIAL IAW CRJ 200 SRM 51-21-06 3B 1-5. (M)
Back to N411ZW