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 A6WA201543165Stringer Clip · crackedSTRINGER 3L, INBD & OTBD CLIPS ARE CRACKED, JUST AFT OF THE 280 BULKHEAD. R & R CLIPS.SDR A6WA201543171Cargo Track · corrodedTIE DOWN TRACK FS 559.00+80 TO 559+96, LBL 27 IS CORRODED. R & R.SDR A6WA201543173Bracket · crackedCARGO BAY DOOR OPENING OVERHEAD BEAM, AFT INBD ANGLE BRACKET AT THE AFT PRESS BULKHEAD, IS CRACKED. R & R.SDR A6WA201543175Fitting · crackedBATHTUB FITTING IS CRACKED AT FS 461, OTBD SIDE OF RBL 9, IN CABIN. R & R.SDR A6WA201543176Seat Track · corrodedLEFT SIDEWALL SEAT TRACK, STICK 6 HAS CORROSION & IS CHAFED, IN CABIN. R & R.SDR A6WA201543172Cargo Track · corrodedTIE DOWN TRACK AT RBL 9 AT FS 559.00+90 HAS CORROSION. R & R.SDR A6WA201543168Fitting · crackedRIGHT WINDSHIELD SIDE POST, LOWER AFT ANGLE FITTING IS CRACKED AT WL 110, IN THE FLIGHT DECK. R & R.SDR A6WA201543169Fitting · crackedLEFT WINDSHIELD SIDE POST, LOWER AFT ANGLE FITTING IS CRACKED AT WL 110, IN THE FLIGHT DECK. R & R.SDR A6WA201543163Cargo Track · corrodedTIE DOWN TRACK AT RBL 9, FS 559.00+112 HAS CORROSION. R & R.SDR A6WA201543162Cargo Track · corrodedTIE DOWN TRACK AT RBL 27, FS 559.00+80 HAS CORROSION, R & R.SDR A6WA201543164Cargo Track · corrodedCARGO TIE DOWN TRACK AT FS 615.00, LBL 9 HAS CORROSION. R & R.SDR A6WA201543166Cargo Track · corrodedCARGO TIE DOWN TRACK AT FS 559.00+90, LBL 9 HAS CORROSION. R & R.SDR A6WA201543157Floorbeam · crackedFLOORBEAM FS 280, UPPER ANGLE IS CRACKED JUST OTBD OF RBL 9, IN CABIN.SDR A6WA201543160Fitting · crackedANGLE CLIP IS CRACKED AT THE OTBD SIDE OF RBL 9 & FLOORBEAM 280, IN CABIN.SDR A6WA201543167Door Sill · crackedCARGO DOOR SILL CRACKED AT FS 605.00. REPAIRED IAW REO 601R-53-61-433.SDR A6WA201543147Seat Track · corrodedLEFT AISLE SEAT TRACK STICK 1 HAS CORROSION, IN CABIN.SDR A6WA201543146Seat Track · corrodedLEFT AISLE SEAT TRACK STICK 5 HAS CORROSION, IN CABIN.SDR A6WA201543145Angle · crackedANGLE CLIP IS CRACKED AT THE OTBD SIDE OF LBL 27 AT FS 484, IN CABIN. R & R.SDR A6WA201543140Fitting · crackedANGLE CLIP IS CRACKED AT THE INBD SIDE OF LBL 36 AT FS 484, IN CABIN.SDR A6WA201543013Carbon Seal · defectiveRECEIVED LT ENG OIL PRESS WARNING ENROUTE. WARNING WAS INTERMITTENT. ENG LEFT AT IDLE FOR DURATION OF FLIGHT. COMPLIED WITH QRH. LOWEST KNOWN OIL PRESS WAS 29 PSI. LOW OIL PRESS WARNING LASTED NO LONGER THAN 10 SECONDS. PERFORMED CONSUMPTION RUN & FOUND SDR A6WA201542657Battery Pack · inoperativeFLIGHT NUMBER 3926. EMERGENCY LIGHTS WILL NOT ILLUMINATE. R & R FOUR EMERGENCY LIGHT BATTERY PACKS IAW AMM 33-51-04. OPS CHECKED GOOD.SDR A6WA201442220Door Frame · crackedREF LP 273644 1 PAX DOOR AFT CLOSING FRAME CRACKED.SDR A6WA201442209Unknown · malfunctionedAIRCRAFT YAWED LEFT AFTER BRAKE RELEASE ON TAKEOFF. UNABLE TO CORRECT WITH FULL RT RUDDER. ABORTED TAKEOFF APPROX 35 KNTS. BTMS = 2-1-2-3. NOSE TIRE PRESSURES ARE GOOD, NO DEFECTS NOTED ON TORQUE LINKS. RUDDER PEDAL RVDT DOTS LINE UP, NWS OPERATIONS CHECKSDR A6WA201442182Apu · malfunctionedON APPROACH, APU DID NOT LIGHT OFF, ABORTED START & RE-STARTED AFTER 2 MINUTES. COCKPIT & CABIN FILLED WITH EXCESSIVE FUEL ODOR, SHUTDOWN APU & FUEL ODOR CLEARED.SDR A6WA201310304335Retainer · dentedCARGO DOOR SEAL RETAINERS DENTED AT UPPER AFT, BOTTOM AFT, AND BOTTOM MID SECTIONS. REMOVED AND INSTALLED NEW RETAINERS, UPPER AFT, BOTTOM AFT AND BOTTOM CENTER.SDR A6WA201310304323Skin · dentedLEFT EXTERNAL SKIN HAS TWO PROTRUDING DENTS AT FS 672, STR 19L. COLD WORKED DENTS BACK TO ALLOWABLE LIMITS IAW EA- 15-2013-464, REV A.SDR A6WA201310284327Skin · gougedLEFT LOWER CORE COWL HAS GOUGE FROM BLOCKER DOOR ON OUTER SKIN JUST AFT OF FWD LATCHES. COMPLIED WITH EA 15-2013-463 BY BLEND OUT DAMAGE AND INSTALL DOUBLER.SDR A6WA201310284324Ground Stud · corrodedGROUND STUDS ON FRAME 589, BETWEEN 17R AND 19R HAVE CORROSION AROUND STUDS. BLENDED FRAME, FOUND TO BE WITHIN LIMITS AND R & R ANGLE AT STR 17 FWD AND AFT OF FRAME 589.SDR A6WA201310284317Skin · damagedSKIN DAMAGED AT FS 634, STR 24L. PERFORMED REPAIR ON LT AFT SKIN IAW REO 601R-53-61-5033, REV A.SDR A6WA201310284316Skin · dentedTWO PROTRUDING DENTS IN FUSELAGE SKIN AT FS 625.3 BETWEEN STR 26L & STR 25L. REPAIRED SKIN IAW REO 601R-53-61-5068, REV-.SDR A6WA201310274332Rib · crackedLEFT W/W BATT RIB CRACKED AT AFT CORNER. INSTALL DOUBLER REPAIR IAW REO 601R-57-51-046, REV B.SDR A6WA201310274314Cleat · damagedPAX DOOR AFT CLEAT BRACKET BLENDED OUT OF SERVICEABLE LIMITS. R & R AFT CLEAT BRACKET.SDR A6WA201310264314Mount Fitting · corrodedMOUNTING PLATES FOR CONNECTORS JIMB & J2MB ARE CORRODED. REMOVED UNSERVICEABLE BRACKET CONNECTOR & REPLACED WITH 2 EA 601R31771-1 IAW SRM 51-42-06.SDR A6WA201310254313Bracket · crackedHYD NR 3 BRAKE ACCUMULATOR FWD/OB MOUNT BRACKET CRACKED. R & R WITH NEW IAW SRM.SDR A6WA201310244333Skin · chafedRIGHT MLG DOOR INNER SKIN HAS GOUGE AND 2 CHAFED RIVETS. R & R INNER SKIN ON RT MLG DOOR.SDR A6WA201310244M330Rib · crackedRT W/W BATTERY RIB CRACKED. REPAIRED RT BATTERY RIB IAW REO 601R-57-51-046, REV B.SDR A6WA201310244329Fairing · damagedCENTER ATTACH FITTINGS FOR BELLY FAIRING 193AB HAVE ELONGATED HOLES. R & R IAW SRM 51-41-02.SDR A6WA201310244328Skin · damagedRT LOWER CORE COWL ALIGNMENT HOLES ELONGATED. FABRICATED AND INSTALL 2 EA DOUBLER FOR RT LOWER CORE COWL ALIGNMENT HOLES.SDR A6WA201310244M322Floor Support · corrodedLEFT OTBD FLOOR SUPPORT HAS CORROSION NEAR FS 450 - 559. BLENDED AND FOUND TO BE OUT OF LIMITS IAW SRM 51-21-06 , REPAIRED IAW SRM 51-42-06.SDR A6WA201310234321Seat Track · corrodedLT SIDE SEAT TRACK CORRODED AT FS 559+77. REPLACED SECTION OF SEAT TRACK FROM 546 TO 559+80 IAW SRM , AMM AND REO 601R-53-00-485.SDR A6WA201310234334Drag Angle · crackedRIGHT W/W DRAG ANGLE CRACKED AT FWD & AFT CORNERS. R & R DRAG ANGLE WITH SERVICEABLE IAW SRM 51-40-11 & SRM 51-42-21.SDR A6WA201310234331Drag Angle · crackedLEFT WW DRAG ANGLE COMMON TO BATTERY RIB CRACKED. R & R WITH SERVICEABLE PART IAW SRM 51-42-21.SDR A6WA201310234325Support Bracket · crackedNR 2 HYD RETURN MANIFOLD ASSY SUPPORT BRACKET CRACKED AT LOWER AFT CORNER. CUTOUT DAMAGED SECTION OF BRACKET AND INSTALLED FABRICATED ANGLE IAW REO 601R-53-62-031, REV A.SDR A6WA201310234320Bracket · brokenCARGO DOOR SILL FWD FOLDING STEP BRACKET BROKEN. R & R CARGO DOOR SILL FWD BRACKET IAW SRM 51-42-20.SDR A6WA201310234315Floorbeam · corrodedFLOORBEAM FS 589, RBL 36 TO RBL 18 HAS CORROSION. REMOVED CORROSION FROM FLOORBEAM AND R & R FLOORBEAM CAP.SDR A6WA201310214326Heat Shield · crackedRT JET PIPE HEAT SHIELD CRACKED BETWEEN SECOND AND THIRD STIFFENERS. REPAIRED IAW CMM 78-11-00.SDR A6WA201310214319Bulkhead · damagedFS 621, BULKHEAD HAS SCREW DAMAGE. BLENDED DAMAGE TO SMOOTH.SDR A6WA201310214318Structure · damagedSIX RIVET HEADS HAVE SCREW DAMAGE. REMOVED DAMAGED FASTENERS AND INSTALLED NEW FASTENERS IAW SRM 42-06.SDR A6WA201340218802Flap · dentedLEFT I/B FLAP DENTED AT TRAILING EDGE FO PANEL 583BB. REPAIRED IAW BOMBARDIER REO 601R-57-52-2011.SDR A6WA201340218800Trunnion · damagedDURING COLD WORKING OF THE FASTENER HOLES OF THE MLG TRUNNION LOWER FLANGE FOUND 1 EA OVER SIZED HOLES ON RT SIDE. REPAIRED OVERSIZED HOLES ON RIGHT LOWER MLG TRUNNION FLANGE IAW BOMBARDIER REO 601R-57-21-1864 REV -.
Back to N411ZW