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 A6WA200740563Angle · corrodedFOUND RIGHT PRESSURE FLOOR SILL PLATE ANGLE AT FS 499, RBL 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 A6WA200740560Bracket · corrodedFOUND SERVICE DOOR LOWER SILL JOINT BRACKET P/N 601R38335-1 CORRODED AT FS 319.70 WL 73. MAINTENANCE REPLACED LOWER SILL JOINT ANGLE ON SERVICE DOOR IAW CRJ 200 SRM 51-42-06, 51-42-21 AND BSC EO 601R-53-13486. (M)SDR A6WA200740556Skin · dentedLEFT INBOARD FLAP UPPER SKIN DENTED 15 INCHES FROM INBOARD EDGE, 7 INCHES FROM TRAILING EDGE APPROX 1.25 INCH LONG BY 1 INCH WIDE BY .022 INCH DEEP. MAINTENANCE REPAIRED LT INBOARD FLAP UPPER SKIN USING NON-FLUSH REPAIR IAW CRJ 200 SRM 57-52-00 REPAIR NR 03. SDR A6WA200740562Panel · crackedPAX DOOR STAIR FORWARD SIDE PANEL IS CRACKED IN ZONE 2 AND 3 APPROX .250 INCH LONG IN RADIUS. MAINTENANCE REPAIRED ZONES 2 AND 3 ON PAX DOOR FORWARD SIDE PANEL IAW BOMBARDIER REO 601R-52-11-702 AND BSC EO 601R-52-13411A. (M)SDR A6WA200740561Panel · crackedPAX DOOR STAIR AFT SIDE PANEL IS CRACKED IN ZONES 2 AND 3 APPROX .250 INCH LONG IN RADIUS. MAINTENANCE REPAIRED ZONES 2 AND 3 ON PAX DOOR AFT SIDE PANEL IAW BOMBARDIER REO 601R-52-11-702 AND BSC EO 601R-52-13410. (M)SDR A6WA200740549Floor Support · crackedFS 280 FLOOR SUPPORT BEAM CLIP AT LBL 9, INBOARD, IS CRACKED IN RADIUS APPROX .50 INCH LONG. MAINTENANCE CRACKED CLIP AND INSTALLED NEW CLIP P/N 601R31113-57 IAW BSC SR 601R-53-0057A AND CRJ SRM 51-42-21. (M)SDR A6WA200740552Bulkhead · corrodedPILOTS BULKHEAD FS 280 HAS CORROSION APPROX .010 INCH DEEP BETWEEN LBL 9.0 AND RBL 9.0 AT WL 73.10. (M) MAINTENANCE INSTALLED NEW ANGLE IAW CRJ SRM 51-42-06 AND 51-42-13. (M)SDR A6WA200740551Floorbeam · crackedFOUND FS 280 FLOORBEAM CLIP AT RBL 9.0, OUTBOARD, IS CRACKED IN RADIUS APPROX .50 INCH LONG. (M) MAINTENANCE REMOVED CRACKED CLIP AND INSTALLED NEW CLIP P/N 601R31113-58 IAW BSC SR 601R-53-0057A AND CRJ SRM 51-42-13, 51-42-21. (M)SDR A6WA200740550Floorbeam · crackedFOUND FS 280 FLOORBEAM CLIP AT RBL 9.0, INBOARD, IS CRACKED IN RADIUS APPROX .50 INCH LONG. (M) MAINTENANCE REMOVED CRACKED SLIP AND INSTALLED NEW CLIP P/N 601R31113-58 IAW BSC SR 601R-53-0057A AND CRJ SRM 51-42-21. (M)SDR A6WA071024001Floorbeam · crackedFOUND FS 280 FLOOR SUPPORT BEAM CLIP AT LBL 9.0, INBOARD, IS CRACKED IN RADIUS APPROX .50 INCH LONG. (M)SDR A6WA200740548Floorbeam · crackedFOUND FS 280 FLOORBEAM CLIP AT LBL 9.0, OUTBOARD, IS CRACKED IN RADIUS APPROX .50 INCH LONG. MAINTENANCE REMOVED CRACKED CLIP AND INSTALLED NEW CLIP P/N 601R31113-57, IAW BSC SR 601R-53-0057A, CRJ SRM 51-42-13, AND 51-42-21. (M)SDR A6WA200740555Angle · crackedFOUND LEFT AND RIGHT FS 621 TO 625 OBLIQUE ANGLES ARE CRACKED. MAINTENANCE REMOVED CRACKED ANGLES AND INSTALLED NEW ANGLES P/N 601R-35012-51, 601-35012-52 IAW CRJ SRM 51-42-06. (M)SDR A6WA200740554Floorbeam · crackedFOUND LEFT SIDE UNDER FLOORBEAM HAS A CRACKED ATTACH ANGLE AT THE OUTBOARD SIDE OF LBL 27, FS 484, WL 70.73. (M) MAINTENANCE REMOVED CRACKED ANGLE, FABRICATED AND INSTALLED REPLACEMENT ANGLE IAW BSC SR 601R-53-0029B. (M)SDR A6WA200740553Floorbeam · crackedRIGHT SIDE UNDER FLOORBEAM HAS A CRACKED ATTACH ANGLE AT THE OUTBOARD SIDE OF RBL 27, FS 484, WL 70.73. (M) MAINTENANCE PERFORMED REPAIR TO RT SIDE FLOOR SUPPORT INTERCOSTAL ATTACH ANGLE OUTBOARD SIDE OF RBL 27 FS 484 IAW BSC SR 601R-53-0029B AND CRJ 200 SRMSDR A6WA200740541Unknown · unknownLONGITUDINAL OSCILLATIONS BEGAN CLIMBING THRU APPROX 26,000 FT FOR APPROX 30 SECONDS OSCILLATIONS RETURNED IN LEVEL CRUISE FLIGHT AT 33,000 WITH AUTOPILTO ON OR OFF. OSCILLATION STOPPED WHEN BEGAN DESCENT.SDR A6WA200640413Bolt · looseINTERMITTENT VIBRATION IN AIRCRAFT, FLIGHT CONTROL AND ENGINE INDICATIONS NORMAL. INSPECTED ALL DOOR AND SEALS, PRIMARY AND SECONDARY FLIGHT CONTROLS, MLG AND NLG DOORS, ALL FAIRINGS, WHEEL BINS, RAM AIR SOV, APU INLET DOOR, ACM`S, RADOM, WING TO FUSELAGE MOUSDR A6WA200640393Idg · failedDURING TAKEOFF IDG CAUTION MESSAGE FOLLOWED BY GEN NR 2 CAUTION MESSAGE, ABORTED TAKEOFF. REMOVED AND REPLACED IDG NR 2 IAW AMM. OPS CHECK GOOD. (K)SDR A6WA200640311Drag Angle · crackedFOUND PAX DOOR AFT DRAG ANGLE IS CRACKED. MAINTENANCE REPAIRED PAX DOOR AFT DRAG ANGLE BY CUTTING AWAY DAMAGED SECTION OF ANGLE AND INSTALLING REPAIR ANGLE AND SPLICES IAW REO 601R-53-11-513 REV A. (M)SDR A6WA200640269Idg · lack of lubeON TAKEOFF ROLL, IDG NR 2 CAS MESSAGE FOLLOWED BY `GEN NR 2 OFF` CAUTION MESSAGE. ABORTED TAKEOFF AT 60 KNOTS AND COMPLIED WITH QRH. GEN RN 2 RESET. FOUND IDG NR 2 OIL QUANTITY LOW. RESERVICED IAW AMM 12-13-24. ENGINE RUN OPS CHECK GOOD AT THIS TIME. ABOSDR A6WA200640131Cable · brokenINFLIGHT AT 10,000 FT F/A REPORTED LOUD POP BOARDING DOOR AND SAFE INDICATES SECOND STEP RED. NO ASSOCIATED PAX DOOR WARNING AND CAUTION MESSAGE. FOUND BROKEN CABLE REMOVED AND REPLACED ICE DOOR CABLE ON DOOR PRESS. VLV IAW AMM, INSPECTED DOOR OUTER HANDLE SDR A6WA200640083Sensor · out of adjustFOUND RED WARNING GEAR DISAGREE ON TAKEOFF RIGHT MLG DID NOT SHOW UP LOCKED COMPLIED WITH QRH, ALL THREE GEAR EXTENDED. TIGHTENED RIGHT MLG UPLOCK TARGET AND ADJUSTED SENSOR TO TARGET CLEARANCE TO .085 INCH REF AMM 22-32-05. PERFORMED GEAR SWING. OPS CHECK SDR A6WA200640003Handle · out of positionAFTER TAKEOFF, ROTATION GEAR DISAGREE RED WARNING MESSAGE CAME ON, WAITED 20-30 SECONDS, LOOKED AT GEAR HANDLE, IT SEEMED WAS NOT UP ALL THE WAY. RECYCLED LANDING GEAR HANDLE AND GEAR CAME UP. PULLED OUT QRH, C/W ALSO CHECK HYD PRESSURE WAS NORMAL. (K)SDR A6WA200540280Acm · malfunctionedRT PACK OVER PRESSURIZE ON BLEED SWITCH OVER, AND WOULD NOT RESET, AIR RETURN. REMOVED AND REPLACED RT AIR CYCLE MACHINE IAW AMM 21-51-10, OPS CHECK NORMAL. (M)SDR A6WA200540023Manifold · chafedSTRONG ODOR OF JET FUEL IS PRESENT WITH PACKS ON WHILE ON GROUND. FOUND APU PRIMARY MANIFOLD CHAFED THROUGH BY STARTER CONTROL VALVE. REPLACED MANIFOLD IAW AMM AND REPOSITIONED CONTROL VALVE. GROUND RAN AND LEAK AND OPS CHECK GOOD. (K)SDR A6WA200540012Plug · damagedMWC - 170 PANEL 131AL HAS DAMAGED FREEZE PLUG AT NR 2 IN CLOCKWISE POSITION, EXCEEDS DIAMETER OF .343 INCH PER BOMBARDIER REO 601R-53-11-162. (M)SDR A6WA200540011Angle · crackedFOUND LEFT FS 621 ANGLE IS CRACKED. REPAIRED LEFT FS 621 ANGLE IAW BOMBARDIER, INC REC 601R-53-61-117 REV B B4 INSTALLING REPAIR ANGLE. (M)SDR A6WA200540008Angle · crackedFOUND RIGHT FS 621 ANGLE IS CRACKED. REPAIRED RIGHT FS 621 ANGLE IAW BOMBARDIER REO 601R-53-61-117 REV B BY INSTALLING REPAIR ANGLE. (M)SDR A6WA200540004Access Door · corrodedLT WING LOWER PLANK FUEL TANK ACCESS DOOR CUTOUT AT WS 12.245 HAS MINOR FRETTING ON FAYING SURFACE LESS THAN .010 INCH DEEP. PERFORMED A MAJOR REPAIR BY REMOVING FRETTING IAW BOMBARDIER, INC REO 601R-57-21-030 REV D. (M)SDR A6WA200540005Skin · corrodedFOUND LEFT WING LOWER PLANK FUEL TANK ACCESS DOOR CUTOUT AT WS 163 HAS MINOR FRETTING ON FAYING SURFACE. LESS THAN .008 INCH DEEP. PERFORMED A MAJOR REPAIR BY REMOVING FRETTING IAW BOMBARDIER, INC REO 601R-57-21-030 REV D. (M)SDR A6WA200540015Angle · crackedLT SIDE 484 ANGLE IS CRACKED AT INTERCOSTAL FLANGE AT LBL 36. REPAIRED LT SIDE 484 ANGLE AT LBL 36 IAW REO. (K)SDR A6WA200540003Angle · crackedLEFT SIDE 484 ANGLE IS CRACKED AT INTERCOSTAL FLANGE AT LBL 36. (M)SDR A6WA200440079Sensor · malfunctionedFLAPS FAIL MASTER CAUTION DURING FLAP RETRACTION DURING TAKEOFF 17 DEGREE SETTING. REMOVED AND REPLACED LEFT BPSU REF AMM 27-51-10. OPS CHECK GOOD. (M)SDR A6WA200340062Striker · damagedPASSENGER DOOR SEAL STRIKER IS DAMAGED AT FS 310 AND FS 349 AT MIDDLE LATCH LOCATION. REPAIRED PASSENGER DOOR SEAL STRIKER AT FS 310 AND 349 IAW REO 601R-52-11-008 ISSUE B. (M)SDR A6WA200340045Adg · will not testMAINTENANCE CHECK FLIGHT REQUIRED FOR ADG DEPLOY INFLIGHT FUNCTION TEST. REMOVED AND REPLACED ADG (S/N OFF: 0598) (S/N ON:0736). PERFORMED ADG FLIGHT TEST, TEST OK. ADG COMPONENT REPAIR SHOP TEAR-DOWN FINDINGS, NO FAULT FOUND (NFF).
Back to N411ZW