N711UW
Service difficulty reports · 260
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 = 'N711UW' 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 = 'N711UW' 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 AALA201704259051Floor Support · corrodedCORROSION ON CABIN FLOOR SUPPORT AT NUT PLATE HOLE, Y503.2 AND FRAME 16. REPLACED THE FLOOR SUPPORT IAW SRM 51-72-11-911, DRAWING D53112827, AND D53112826.SDR AALA201704259050Seat Track · corrodedCORROSION ON SEAT TRACK , AFT INBD MOUNT FOR LAVATORY A, Y765 AND FRAME 16. REPLACED THE SEAT TRACK IAW SRM 53-11-14-283-004, 51-72-00, AND 51-42-11.SDR AALA201704259049Seat Track · corrodedCORROSION ON AFT OTBD LAVATORY A CABIN SEAT TRACK AT Y1292 AND FRAME 12. REPLACED THE SEAT TRACK IAW SRM 51-42-11.SDR AALA201704259048Floor Support · corrodedCORROSION ON LEFT AFT GALLEY MOUNT CABIN FLOOR SUPPORT AT STRINGER 23L AND FRAME 70. REPLACED FLOOR SUPPORT IAW SRM 51-75-12.SDR AALA201704259047Threshold · corrodedCORROSION ON L2 DOOR THRESHOLD AT AFT GIRT BAR MOUNT AT Y1732 AND FRAME 68. REPLACED THE THRESHOLD IAW SRM 51-42-11.SDR AALA201704259046Threshold · corrodedCORROSION ON L2 DOOR THRESHOLD JUST FORWARD OF FRAME 68. REPLACED THRESHOLD IAW SRM 51-42-11.SDR AALA201704259045Threshold · corrodedCORROSION ON L2 DOOR THRESHOLD AT FORWARD GIRT BAR MOUNT. REPLACED DOOR THRESHOLD IAW SRM 51-42-11.SDR AALA201704259041Floorbeam · corrodedCORROSION ON THE FLOORBEAM UPPER SURFACE AT LAVATORY E MOUNT HOLE, FRAME 66, RBL 52. REPLACED THE FLOORBEAM IAW SRM 51-42-11 AND DRAWING D5347219021.SDR AALA201702219014Fixture · detachedSEAT 21C EMERGENCY LIGHT FIXTURE DETACHED FROM SEAT. SECURED THE FIXTURE.SDR AALA201701299003Selector Valve · leakingCABIN ODOR REPORTED FROM ALL FLIGHT ATTENDANT'S, DURING CLIMB BRIEFLY AND FROM TOP OF DESCENT UNTIL TOUCHDOWN. DIRTY SOCK ODOR IN ENTIRE CABIN, PASSENGERS SMELLED ODOR ALSO. COCKPIT CREW WAS NOTIFIED IN DESCENT (ONLY) BY CREW. VERIFIED SAME ODOR, CONTINUATION SDR AALA201701289012Filter · obstructedFLIGHT ATTENDANT REPORTED A MUSTY ODOR IN AFT PORTION OF CABIN. ON LANDING, FLIGHT ATTENDANT REPORTED WORSE CONDITIONS, MUSTY ODOR AND PASSENGER COMPLAINTS. FORWARD FLIGHT ATTENDANT REPORTED SLIGHT ODOR IN AIRCRAFT ON LANDING. MAINTENANCE ACCOMPLISHED JOB CARSDR AALA201612299007Girt Bar · obstructedAIRCRAFT WAS NOT GROUNDED. 1L DOOR SLIDE DIFFICULT TO ARM. REMOVED DEBRIS IN LOWER DOOR FRAME (GIRT BAR AREA) AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612089001Battery · faultyDURING PERIODIC SERVICE CHECK, EMERGENCY EXIT LIGHT TEST, RIGHT EMERGENCY POWER SUPPLY UNIT FAULTED, RESULT WAS BATTERY FAULT. REPLACED BATTERY IAW AMM 33-51-38. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201606119005Wire · brokenAIRCRAFT WAS NOT GROUNDED: ROW 21 LT SIDE SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. MAINTENANCE FOUND BROKEN WIRE AT SEAT 21 LT. REPLACED THE WIRE HARNESS IAW CMM 25-22-52. A SATISFACTORY OPS CHECK WAS ACCOMPLISHED.SDR AALA201605139006Flap · crackedAIRCRAFT WAS GNDED. RT WING INBD TE FLAP, TE HAS A 4 INCH CRACK 78" FROM THE INBD EDGE & EVIDENCE OF DELAMINATION. REPAIRED FLAP IAW SRM 57-52-00-201.SDR AALA201603309004Wire Harness · defectiveAIRCRAFT IN BASE MX. EMER LIGHT OPERATIONAL TEST FAILED DURING 26L00025011. R & R SEAT 4ABC, SEAT WIRE HARNESS IAW AMM 33-51-19. ACCOMPLISHED WIRE SPLICE REPAIR TO WIRES 3351-3030 & 3031 NEAR 90WL1 IAW ESPM 20-53-21 & 20-53-31 & AWM 33-51-06. ACCOMPLISHED SDR AALA201603309003Fitting · out of adjustAIRCRAFT IN BASE MX. DURING R1 SLIDE REPLACEMENT & ACCOMPLISHING TASK CARD PAGE 12 STEP C, THE DOOR WENT INTO GIRT BAR PAW & THE GIRT BAR WON`T LINE UP AGAIN. DETERMINED THAT THE R1 DOOR GIRT BAR FLOOR FITTINGS REQUIRED ADJUSTMENT & ADJUSTED THE FWD & AFT GSDR AALA201603229016Slide · unserviceableAIRCRAFT WAS NOT GNDED. DURING A SCHEDULED TIME CHANGE OF THE L1 DOOR ESCAPE SLIDE, THE SLIDE WAS FOUND UNRAVELED IN THE SHIPPING CONTAINER WITH THE SHIPPING BOARDS NOT SECURED. THE SLIDE WAS MARKED AS UNSERVICEABLE & RETURNED TO STORES & A SERVICEABLE UNIT SDR AALA201602199011Fitting · crackedAIRCRAFT IN BASE MX. RT MLG DOOR ACTUATOR FWD FITTING NEAR ATTACH LUG HAS CRACK INDICATION AT FRAME 43 & Y-400 AT THE KEEL BEAM. REPLACED FITTING IAW DWG D53370600 & SRM 51-42-11.SDR AALA201602229036Box Beam · crackedAIRCRAFT IN BASE MX. RT SIDE BOX BEAM, UPPER FLANGE FIRST HOLE FROM THE REAR, HAS CRACK INDICATION AT FRAME 43 & -Y1622. REPAIRED IAW EO 5315Y066.SDR AALA201602229035Box Beam · crackedAIRCRAFT IN BASE MX. LT SIDE BOX BEAM, UPPER FLANGE SECOND HOLE FROM THE REAR, HAS CRACK INDICATION AT FRAME 43 & Y1622. REPAIRED IAW EO 5315Y066.SDR AALA201509169001Stop Fitting · out of adjustL1 DOOR INTERMITTENTLY HANGS WHEN OPENING. WHEN HANG OCCURS, DOOR MUST BE CLOSED & RE-OPENED WITH FORCE. FOUND KINEMATIC STOP ON REDUCER SHAFT OUT OF ADJUSTMENT. ADJUSTED STOP IAW CMM 52-11-15. DOOR OPERATES NORMAL IAW AMM 52-11-00.SDR AALA201508139001Unknown · odorFLIGHT ATTENDANT REPORTED STRONG ODOR IN AFT GALLEY. ODOR REPORTED TO HAVE A SLIGHT ELEC SMELL. AFT COFFEEMAKER CB'S WERE PULLED & ODOR DISSIPATED. REMOVED AND REPLACED THE COFFEEMAKERS.SDR USAA2015012600014Battery · dischargedEMERGENCY FLASHLIGHT FWD INOPERATIVE. REPLACED FLASHLIGHT BATTERY AS REQUIRED. OK FOR SERVICE.SDR USAA2014101300014Actuator · lowFORWARD FLIGHT ATTENDANT PANEL MESSAGE, CHECK SLIDE PRESS R2 DOOR. REPLACED THE ACTUATOR & OPS CHECKED GOOD IAW AMM 52-22-14.SDR USAA2014092400003Clamp · missingTHE LT OVERWING SLIDE BOTTLE DISCHARGE HOSE IS MISSING CLAMP, SPACER WASHER & SCREW. ACCOMPLISHED TEMPORARY REPAIR IAW EA 208591. MX ACTION PENDING.SDR USAA2014092300002Lens · missingTHE R2 DOOR SLIDE ARMED LENS MISSING. PERFORMED TEMPORARY REPAIR IAW EA 208576. REPLACED R2 DOOR SLIDE ARMED LENS IAW EA 208576.SDR USAA2014072800016Cover · missingTHE EXIT LIGHT COVER NEAR 2R DOOR MISSING, BROKEN. REPLACED EXIT LIGHT COVER AT 2R DOOR.SDR USAA2014072100012Lens · missingTHE LENS OFF THE EMER AISLE LIGHT AT 3C WHITE LIGHT. REPLACED MISSING LENS ON EMER AISLE LIGHT AT SEAT 3C.SDR USAA2014071600001Control Handle · lack of lubeON ARRIVAL AGENT SAID 1L DOOR DIFFICULT TO OPEN. LUBRICATED 1L DOOR EXTERNAL CONTROL HANDLE & INTERIOR IAW AMM TASK 12-22-52-640-006-A. OPERATIONS CHECKED GOOD.SDR USAA2014060900018Slide Raft · defectiveMAINTENANCE REPORTED THE R2 DOOR SLIDE COVER TOUCHES FUSELAGE SKIN WHEN OPENED. REPLACED DOOR ESCAPE SLIDE & RAFT IAW JOB CARD 26L00025011.SDR USAA2014060900006Slide · faultyTHE L2 SLIDE PACK LOOSE & COVER HITTING FUSELAGE. REPLACED L2 SLIDE IAW JOB CARD 26L0025011.SDR USAA2014051200009Battery · dischargedCREW REPORTED ALL CABIN FLASHLIGHT RETAINER SEALS BROKEN. FWD PAIR INOPERATIVE. REPLACED BATTERIES IN FWD TWO EMERGENCY FLASHLIGHTS & INSTALLED NEW SEALS ON ALL OTHER EMERGENCY FLASHLIGHTS IAW AMM 20-25-70.SDR USAA2014031000011Latch · dirtyFLIGHT ATTENDANT REPORTS DOOR 1L IS HARD TO ARM & DISARM. CLEANED DEBRIS FROM GIRT BAR LATCHES. OPERATIONS CHECKED GOOD, OK FOR SERVICE.SDR USAA2013122600004Battery · dischargedFORWARD FLIGHT ATTENDANT JUMP SEAT FLASHLIGHT INOPERATIVE. INSTALLED NEW BATTERY AS REQUIRED, OPERATIONS CHECKED GOOD.SDR USAA2013080800007Lens · missingCREW REPORTED THE AISLE LIGHT ON SEAT 1C IS MISSING LENS COVER. MX REPLACED EMERGENCY LIGHT LENS AT SEAT 1C. OPS CHECKED GOOD.SDR USAA2013080200028Lens · missingCREW REPORTED THE EMERGENCY EXIT LIGHT LENS CAP IS MISSING AT 1B. MX REPLACED MISSING LENS AT 1B. ACFT OK FOR SERVICE.SDR USAA2013080200027Lens · missingCREW REPORTED THE EMERGENCY LIGHT LENS CAP AT 3C IS MISSING. MX REPLACED MISSING LENS AT 3C. ACFT OK FOR SERVICE.SDR USAA2013073000003Lever · unknownAGENTS HAD A HARD TIME OPENING THE MAIN ENTRY DOOR. THE LEVER STUCK AND COULD NOT BE RAISED. MX PERFORMED DOOR OPS CHECK. CHECKED NORMAL.SDR USAA2013070200004Light · inoperativeMAINTENANCE REPORTED THE R2 DOOR EMERGENCY EXIT LIGHT INOP. MX REPLACED R2 DOOR EMERGENCY LIGHT IAW AMM 33-51-11. OPS NORMAL.SDR USAA2013062400025Cover · missingCREW REPORTED SEAT 1C EXIT LIGHTS COVER PLATE MISSING. MX INSTALLED NEW EXIT EMERGENCY LIGHT COVER.SDR USAA2013060700003Hinge Fitting · crackedGEAR DOOR ACTUATOR FITTING INSP. CRACKED OUT LUG ON THE LT GEAR DOOR ACTUATOR DOOR FITTING, AFT FITTING LOBE & A GOUGED BUSHING BORE ON THE FWD FITTING LOBE AT FR43, -Z2010, Y485. REPLACED LT MLG DOOR FORWARD & AFT FITTINGS IAW SRM 51-72-11 & EA 205012.SDR USAA2013051500018Lens · missingCREW REPORTED THE WHITE/CLEAR FLOOR EMERGENCY LIGHT LENS COVER MISSING AT ROW 1C. MAINTENANCE REPLACED FLOOR PROX LIGHT LENS ON SEAT 1C.SDR USAA2013050200017Lens · unsecureCREW REPORTED THE LENS COVER FOR EXIT PATH LIGHTING AT SEAT 3C NEEDS TO BE RE-INSTALLED. MAINTENANCE SECURED LENS COVER AT SEAT 3C. EMERGENCY LIGHTING OPS CHECKS GOOD.SDR USAA2013041700009Lens · missingMAINTENANCE REPORTED THE SEAT MOUNTED EMERGENCY LIGHT LENS MISSING AT ROWS 1L AND 3L. MAINTENANCE INSTALLED SEAT MOUNTED EMERGENCY LIGHT LENS AT ROWS 1L AND 3L.SDR USAA2013032900008Cover · missingMAINTENANCE REPORTED THE FIRST CLASS 1C EMERGENCY LIGHT COVER MISSING. MAINTENANCE REPLACED FIRST CLASS 1C EMERGENCY LIGHT COVER PER AMM 33-20-00.SDR USAA2013022700008Lens · unsecureCREW REPORTED THE EMERGENCY EXIT LENS COVER OFF AT SEAT 1AC. MAINTENANCE REPLACED LENS AT SEAT 1AC.SDR USAA2013012200019Lens · missingMAINTENANCE REPORTED THE R1 DOOR LOWER EMERGENCY LIGHT COVER MISSING. MAINTENANCE INSTALLED LENS COVER.SDR USAA2012121000014Lens · missingMAINTENANCE REPORTED THE SEAT MOUNTED EMERGENCY EXIT LIGHT LENS MISSING AT SEAT 20C. MAINTENANCE INSTALLED NEW LENS AT SEAT 20C PER AMM 33-51-19, PAGE BLOCK 401.SDR USAA2012013000020Battery · dischargedEMERGENCY FLASHLIGHT UNDER AFT RIGHT AFT JUMPSEAT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT BATTERY.
Back to N711UW