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 A6WA2017112045432Intercostal · crackedAFT ACCESSORY BAY INTERCOSTAL AT BS 621 - 625, STRINGER 16L IS CRACKED.SDR A6WA201745428Angle · crackedAPU SKID ASSY PLATFORM LT SIDE BRACE AT ABOUT LBL18 UPPER O/B ANGLE BRACKET IS CRACKED IN THE AFT EQUIPMENT BAY.SDR A6WA201745424Door Sill · crackedLT FLOOR SILL IS CRACKED AT FS589 IN THE CARGO BAY.SDR A6WA201745427Panel · crackedPAX DOOR UPPER PANEL AFT CORNER HAS A POSSIBLE CRACK.SDR A6WA201745423Attach Bracket · crackedRIGHT SIDE OVER WING ACCESS PNL ATTACH BRACKET AT FS468 IS CRACKED.SDR A6WA201745420Attach Bracket · crackedLEFT SIDE OVER WING ACCESS PNL ATTACH BRACKET AT FS461 IS CRACKED.SDR A6WA201745421Attach Bracket · crackedLEFT SIDE OVER WING ACCESS PNL ATTACH BRACKET AT FS449 IS CRACKED.SDR A6WA201745422Attach Bracket · crackedLEFT SIDE OVER WING ACCESS PNL ATTACH BRACKET AT FS468 IS CRACKED.SDR A6WA201745425Fitting · crackedANGLE CLIP IS CRACKED AT THE O/B SIDE OF RBL27 AT FS484 IN CABIN BELOW THE FLOOR.SDR A6WA201745426Angle · crackedANGLE CLIP IS CRACKED AT THE I/B SIDE OF RBL36 AT FS 484 IN THE CABIN BELOW THE FLOOR.SDR A6WA201745417Fitting · crackedFLIGHT DECK WINDSHIELD CENTER POST LOWER LEFT FITTING IS CRACKED (NDT HAS VERIFIED)SDR A6WA2017102745373Pdu · failedDURING TAKEOFF ROLL, ABOVE 80 KNOTS, RECEIVED A RIGHT THRUST REVERSER MESSAGE, FOLLOWED BY AN UNLOCK MESSAGE, FOLLOWED BY AN EMERERGENCY STOW LIGHT. ABORTED TAKEOFF. R & R THE RT THRUST REVERSER PDU, FOUND BAD FLEX LOCK SWITCH.SDR A6WA201745292None · none
4921 EMERGENCY FLOOR LIGHTS AT TOW 7 AND 8 NOT ILLUMINATING OPS CHECK GOOD IAW AMM 33-51-00
SDR A6WA2016122844702Autopilot Sys · inoperativeAIRCRAFT EXPERIENCED SUBSTANTIAL UNCOMMANDED YAW AT 10,000 FEET IN SMOOTH AIR. AUTOPILOT DID NOT DISENGAGE AFTER 2 EPISODES. C/W QRH, DISCONNECTED AND AUTOPILOT AND YD NO FURTHER UNCOMMANDED YAW.SDR A6WA201643601Light · missingLAST 4 FT OF EMER LIGHT STRIPS MISSING. ALSO MISSING ORANGE ARROWS AT LAST STRIP THAT IS THERE.SDR A6WA201643550Shutoff Valve · sticksON CLIMB OUT AT FL 6000', RECEIVED LT WING ANTI-ICE CAUTION, FOLLOWED QRH, SELECTED STANDBY. MSG WENT OUT & RETURNED WITHIN A MINUTE. SELECTED 14TH STAGE ISO VLV OPEN, MSG WENT AWAY, LEFT ICING LANDED, DECLARED AN EMER. COMPLIED WITH FIM 30-10-00. FOUND LTSDR A6WA201543236Panel · damagedDURING INSTALLATION OF PANEL 131AL, THE FREEZE PLUG AT HOLE 22 PULLED OUT, REPAIRED.SDR A6WA201543235Panel · damagedDURING INSTALLATION OF PANEL 131AL, THE FREEZE PLUG AT HOLE 28 PULLED OUT, REPAIRED.SDR A6WA201543237Panel · damagedDURING INSTALLATION OF PANEL 131AL, THE FREEZE PLUG AT HOLE 12 PULLED OUT, REPAIRED.SDR A6WA201543238Panel · damagedDURING INSTALLATION OF PANEL 131AL, THE FREEZE PLUG AT HOLE 17 PULLED OUT, REPAIRED.SDR A6WA201543239Panel · damagedDURING INSTALLATION OF PANEL 131AL, THE FREEZE PLUG AT HOLE 32 PULLED OUT, REPAIRED.SDR A6WA201543240Panel · damagedDURING INSTALLATION OF PANEL 131AL, THE FREEZE PLUG AT HOLE 15 PULLED OUT, REPAIRED.SDR A6WA201543228Web · crackedRIGHT MLG WW UPPER WEB DAMAGED DURING GEAR SWING, REPAIRED.SDR A6WA201543232Seal Depressor · gougedSERVICE DOOR CUT OUT SEAL DEPRESSOR IS GOUGED ON AFT SIDE, APPROX 12" FROM UPPER AFT CORNER.SDR A6WA201543231Seal Depressor · gougedGALLEY SERVICE DOOR, UPPER PRESS SEAL DEPRESSOR IS GOUGED IN SEVERAL AREAS.SDR A6WA201543224Gusset · corrodedLEFT GUSSET ON TOP OF FRAME 364 AT STRINGER 26L HAS CORROSION, REPAIRED.SDR A6WA201543222Intercostal · corrodedINTERCOSTAL JUST TO THE RT OF STRINGER 27 HAS CORROSION, BETWEEN FRAMES 364 & 349, REPAIRED.SDR A6WA201543226Frame · corrodedFRAME 319.70 HAS CORROSION ON THE FWD SIDE, BETWEEN STRINGER 22R & 23R, REPAIRED.SDR A6WA201543227Beam · crackedFS 409.00+128 VERTICAL BEAM, RBL 27 INBD LOWER CORNER IS CRACKED, REPAIRED.SDR A6WA201543221Intercostal · corrodedINTERCOSTAL JUST TO THE LT OF STRINGER 27 HAS CORROSION, BETWEEN FRAMES 349 & 364, REPAIRED.SDR A6WA201543223Longeron · corrodedLONGERON ON STRINGER 25L HAS CORROSION ON THE OTBD SIDE, BETWEEN FRAMES 349 & 364, REPAIRED.SDR A6WA201543220Intercostal · corrodedINTERCOSTAL ON TOP OF STRINGER 26L HAS CORROSION, BETWEEN FRAMES 349 & 364, REPAIRED.SDR A6WA201543218Angle · corrodedSERVICE DOOR LOWER SILL ANGLE IS CORRODED, REPLACED.SDR A6WA201543219Doubler · corrodedINTERNAL SKIN DOUBLER AROUND POTABLE WATER DRAIN LINE HAS CORROSION, BETWEEN FRAMES 349 & 333, REPLACED.SDR A6WA201543216Fitting · crackedNOSE LANDING GEAR WELL RT TOP AT FS 193.00, CLIP CRACKED, REPAIRED.SDR A6WA201543214Intercostal · corrodedINTERCOSTAL ON TOP OF STRINGER 25R, CORROSION ON BOTH THE INBD & OTBD SIDES, BETWEEN FRAME 364 & 349, REPAIRED.SDR A6WA201543215Doubler · crackedGROUND ACFT SERVICE PANEL, LOWER MOUNT, HINGE DOUBLER CRACKED, REPLACED.SDR A6WA201543217Frame · corrodedFORWARD SIDE OF FRAME 364 HAS CORROSION, BETWEEN STRINGER 25L & 22R. REPLACED FRAME SECTOR.SDR A6WA201543211Intercostal · corrodedINTERCOSTAL JUST TO THE RT OF STRINGER 27 HAS CORROSION, BETWEEN FRAMES 394 & 409, REPAIRED.SDR A6WA201543212Floorbeam · corrodedFLOORBEAM END & TAB HAS CORROSION ON THE TOP & BOTTOM SIDES, JUST INBD OF THE SERVICE DOOR OPENING, REPAIRED.SDR A6WA201543210Frame · corrodedFRAME 349 HAS NUMEROUS CORROSION SPOTS ON THE FWD & AFT SIDES, BETWEEN STRINGER 25L - 20R, REPAIRED.SDR A6WA201543205Rib · crackedRIGHT HORIZONTAL LE RIB AT INBD STATION BL 6.0 HAS SMALL CRACK, .250 IN LENGTH, REPAIRED.SDR A6WA201543206Track · corrodedLBL 9 TIE DOWN TRACK AT FS 559.00+112 HAS CORROSION, REPLACED.SDR A6WA201543204Drag Angle · crackedPASSENGER DOOR AFT DRAG ANGLE CRACKED ADJACENT TO ASSIST CABLE PULLEY BRACKET, REPLACED.SDR A6WA201543203Stiffener · crackedLEFT JET PIPE FAIRING, CRACKED AT FWD INNER SUPPORT RING. REPAIRED LT EXHAUST NOZZLE FAIRING FWD STIFFENER IAW CMM 78-11-00-300-810-A01 REPAIR SRS 042.SDR A6WA201543202Skin · chafedRIGHT AILERON, UPPER FIXED LE SKIN CHAFED. R & R RT AILERON, FIXED UPPER SKIN IAW SRM 51-42-06 & SUPPLEMENT 13-055B.SDR A6WA201543198Skin · chafedLEFT OTBD FLAP, UPPER SKIN INBD END HAS SMALL CHAFE, REPAIRED.SDR A6WA201543196Skin · damagedEXTERIOR LOWER SKIN IS CREASED AT APPROX FS 598, BETWEEN STRINGERS 23L & 24L, REPAIRED.SDR A6WA201543197Fitting · corrodedRIGHT WINDSCREEN, INBD SHOOT BOLT FITTING HAS CORROSION COMING OUT OF SHOOT BOLT HOLE ON FLOORBEAM 349, BETWEEN RBL 9 & RBL 27, REPLACED.SDR A6WA201543174Seat Track · corrodedLEFT SIDEWALL SEAT TRACK, STICK 2 HAS CORROSION, IN CABIN. R & R.
Back to N411ZW