N740UW
Service difficulty reports · 258
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 = 'N740UW' 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 = 'N740UW' 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 AALA201707209030Hinge · lack of lubeL1 DOOR DIFFICULT TO OPEN. LUBRICATED THE L1 DOOR HINGES, CHECKED NORMAL IAW AMM.SDR AALA201706029005Battery · dischargedFLASHLIGHT INOPERATIVE AT FOWARD FLIGHT ATTENDANT JUMPSEAT. REPLACED BATTERY.SDR AALA201701139012Lens · missingMISSING RED EMERGENCY EXIT LIGHT LENS. MAINTENANCE REPLACED THE LENS ASSEMBLY IAW AMM 33-51-11.SDR AALA201610039009Lens · looseEMERGENCY LIGHT AT BOTTOM OF VALET CLOSET LOOSE. ATTACHED EMERGENCY LIGHT AND ACCOMPLISHED SATIFACTORY OPERATIIONAL CHECK. AIRCRAFT WAS GROUNDED.SDR AALA201609199026Door · lack of lubeL1 DOOR HARD TO OPEN & SQUEAKS. MAINTENANCE LUBRICATED THE FORWARD ENTRY DOOR ATTACHMENT, CLEANED SLIDE GIRT BAR ENGAGEMENT POINTS ARMED DOOR AND CHECKED ECAM INDICATION WITH NO DEFECTS NOTED IAW AMM 12-22-52.SDR AALA201605199007Ptu · overtempDIVERTED, ACFT WAS GNDED. APPROX 2 MINS AFTER TAKEOFF THE ECAM SHOWED HYD GREEN RESERVOIR SYS OVERHEAT. THE FLIGHT CREW SHUTDOWN THE GREEN & BLUE HYD SYSTEMS. ACCOMPLISHED A MANUAL EXTENSION OF THE LG & DIVERTED WHERE THE ACFT LANDED SAFELY. REPLACED THE HSDR AALA201605059012Connector · not seatedAIRCRAFT IN BASE MX. EMER LIGHTS FAILS BITE TEST FOR FWD LT EMER POWER SUPPLY UNIT BATTERY. RESEATED CONNECTOR ON FWD LT EMER POWER SUPPLY UNIT BATTERY. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-38-400-001-A.SDR AALA201509139003Lens · brokenL2 LOWER EMER LENS BROKEN. REPLACED ASSEMBLY IAW AMM 33-51-13. ACFT OK FOR SERVICE.SDR AALA201509119004Floor Panel · delaminatedC8 CHECK, FLOOR PANEL 151VG, AFT CARGO COMPARTMENT DELAMINATED. R & R FLOOR PANEL 151VG, AFT CARGO COMPARTMENT IAW AMM CHAP 53-42-14.SDR AALA201508219002Slide · defectiveFORWARD LT DOOR SLIDE IS HITTING ACFT WHEN DOOR IS SWUNG OPEN. REPLACED SLIDE ASSEMBLY IAW JC 26C83152002.SDR AALA201508249001Splice Plate · crackedC11 CHECK, FRAME SPLICE PLATE CRACKED AT FRAME 20, BETWEEN STRINGER 30L & 32L. REPLACED SPLICE PLATE IAW SRM 51-42-11.SDR AALA201506059001Shear Web · crackedSHEAR WEB CRACKED AT FRAME 68, RBL 48. REPLACED SHEAR WEB IAW DWG D53480019 & SRM 51-42-00.SDR AALA201504109007Lens · missingEMERGENCY LIGHT COVER MISSING AT SEAT 3C. REPLACED 3C EMERGENCY LIGHT LENS.SDR USAA2014061800008Attach Fitting · wornGDAFR MLG ACT VISIT, RT MLG DOOR ACTUATOR FWD FITTING BUSHING IS LOOSE. REPLACED BUSHINGS ON RT MLG DOOR FWD FITTING IAW EA 106006.SDR USAA2014061800007Attach Fitting · wornGDAFR MLG ACT VISIT, RT MLG DOOR ACTUATOR KEEL BEAM FITTING BUSHING IS MIGRATING & IS LOOSE. REPLACED BUSHINGS IAW EA 106005.SDR USAA2014061800006Attach Fitting · wornGDAFR MLG ACT VISIT, LT MLG DOOR ACTUATOR UPPER ATTACH FITTING BUSHING LOOSE ON FWD & AFT SIDES. INSTALLED BUSHINGS IAW EA 106003.SDR USAA2014061800005Attach Fitting · wornGDAFR MLG ACT VISIT, LT MLG DOOR ACTUATOR UPPER ATTACH FITTING BUSHING LOOSE ON FWD & AFT SIDES. INSTALLED BUSHINGS IAW EA 106003.SDR USAA2014051600004Pump · malfunctionedON TAKEOFF ROLL ABOVE 80 KNOTS, CREW RECEIVED B SYS HYD LOW PRESS INDICATION. ONCE CREW GOT ACFT CONFIGURED AFTER TAKEOFF THEY NOTIFIED CLT OF INDICATION PROBLEM & ADVISED THEY WERE RETURNING TO FIELD. NO EMERGENCY WAS DECLARED & THE ACFT WAS ABLE TO TAXI TOSDR USAA2014050500034Coupler · faultyEN-ROUTE FROM PHL TO BDA. CREW REPORTED THEY WERE UNABLE TO ESTABLISH COMMUNICATIONS ON EITHER HF1 OR HF2. FLIGHT RETURNED TO FIELD AT PHL & LANDED WITHOUT INCIDENT. R & R HF COUPLER, 4RE1, USING AMM 23-11-36-001-A & 23-11-36-400-001-A. PERFORMED SUCCESSFULSDR USAA2014021700006Apu · leakingAUXILIARY POWER UNIT FAILURE, OIL LEAK & CABIN ODOR. R & R APU & ALL ISOLATOR MOUNTS IAW JOB CARD 26L31049003. REPLACED APU EXHAUST DUCT BLANKET FOR BEING WORN & CRACKED GOING TO TAILPIPE. REPLACED APU AIR INTAKE DIFFUSER, ELBOW & AIR INSULATION SCREEN FOR SDR USAA2014021700011Light · inoperativeMAINTENANCE REPORTED THE EMERGENCY LIGHT AT REAR GALLEY ABOVE LAVATORY'S HAS MANY LIGHTS OUT. R & R EMERGENCY LIGHT ABOVE REAR LAVATORY, OPERATIONS CHECKED NORMAL.SDR USAA2014021700010Cover · missingMAINTENANCE REPORTED THE EMERGENCY LIGHT COVER AT RT AFT DOOR MISSING. MX REPLACED MISSING COVER AT RT AFT DOOR.SDR USAA2014011400007Fitting · dirtyCREW REPORTED DOOR 2R IS DIFFICULT TO ARM SLIDE. REMOVED DEBRIS FROM GIRT BAR FITTINGS ON FLOOR, OPERATIONS CHECKED GOOD.SDR USAA2013120900003Lens · missingCREW REPORTED AT SEAT 3C, THE EMERGENCY LIGHT COVER MISSING. INSTALLED LENS IAW AMM 33-20-00.SDR USAA2013071500006Lens · missingCREW REPORTED MISSING A CLEAR LENS ON A SEAT MOUNTED EMERGENCY EXIT LIGHT NEAR FRONT OF ACFT. MX INSTALLED MISSING EXIT LIGHT LENS AT FRONT OF ACFT.SDR USAA2013031200007Power Supply · inoperativeMAINTENANCE REPORTED THE AIRCRAFT FAILED THE EMERGENCY LIGHT TEST. MAINTENANCE TROUBLESHOT TO THE AFT LEFT EPSU. REMOVED AND REPLACED PER AMM 33-51-38-400-002-A, INSTALLATION OF POWER SUPPLY BATTERY.SDR USAA2013030400027Cover · missingCREW REPORTED SEAT LIGHT 3C MISSING COVER. MAINTENANCE INSTALLED EMERGENCY LIGHT COVER AS REQUIRED.SDR USAA2013012300005Bracket · brokenCREW REPORTED THE EMERGENCY LIGHT COVER ON SEAT 4C FELL OFF. MAINTENANCE REPLACED LIGHT COVER BRACKET.SDR USAA2012082000018Lens · missingFLOOR PROXIMITY EMERGENCY ESCAPE PATH LIGHTS AT SEATS 8C AND 10C RIGHT MISSING. REPLACED 8C AND 10C LENS COVERS. OPS CHECKED GOOD.SDR USAA2012062600012Skin Panel · delaminated2S CHECK - DELAMINATION ON LEFT ELEVATOR SKIN PANEL BETWEEN THS STA 342 TO STA 404 & BETWEEN RIB 9 TO RIB 10, 7.61 INCHES FROM TRAILING EDGE. REPAIRED LEFT ELEVATOR SKIN PANEL IAW A319 SRM 55-21-11 PAR 5(E)(2) & EO 5511Y295 ITEM 11.SDR USAA2012062000010Hinge Fitting · corroded2S CHECK - CORROSION ON LEFT ELEVATOR HINGE FITTING BETWEEN STAB STA 5274 TO STAB STA 5894, RIB 12 TO RIB 13. REPLACED LEFT ELEVATOR HINGE FITTING BETWEEN STAB STA 5274 TO STAB STA 5894, RIB 12 TO RIB 13 IAW A319 AMM 55-16-42.SDR USAA2012062700003Fitting · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON INTERNAL STRUCTURE OF FITTING IN RIGHT OUTBOARD FLAP FRONT SPAR, RIB 15. REPLACED RIGHT OUTBOARD FLAP IAW A319 AMM 27-54-62-400-001-A & EA 104061A.SDR USAA2012062700002Fitting · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON INTERNAL STRUCTURE OF FITTING IN LEFT OUTBOARD FLAP FRONT SPAR, RIB 14. REPLACED LEFT OUTBOARD FLAP IAW A319 AMM 27-54-62-400-001-A & EA 104061A.SDR USAA2012062600028Fitting · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON INTERNAL STRUCTURE OF FITTING IN LEFT OUTBOARD FLAP FRONT SPAR, RIB 15. REPLACED LEFT OUTBOARD FLAP IAW A319 AMM 27-54-62-400-001-A.SDR USAA2012062600027Fitting · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON INTERNAL STRUCTURE OF FITTING IN RIGHT OUTBOARD FLAP FRONT SPAR, RIB 14. REPLACED RIGHT OUTBOARD FLAP IAW A319 AMM 27-54-62-400-001-A.SDR USAA2012062600024Plate · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SUPPORT PLATE BETWEEN FR58 TO FR59, S38L. REPLACED SUPPORT PLATE BETWEEN FR58 TO FR59, S38L IAW A319 SRM 51-42-11 & 51-72-11.SDR USAA2012062000007Hinge · excess play2S CHECK - EXCESSIVE PLAY ON LEFT MAIN LANDING GEAR DOOR HINGE ASSEMBLY BETWEEN FR34 TO FR44. REPLACED LEFT MAIN LANDING GEAR DOOR HINGE ASSEMBLY BETWEEN FR34 TO FR44 IAW A319 CMM 52-81-18.SDR USAA2012061800015Strut · corroded2S CHECK - CORROSION ON RIGHT WING INTERCONNECTING STRUT HOUSING INTERNAL AREA AT WS 4862, RIB 9. REPLACED RIGHT WING INTERCONNECTING STRUT IAW A319 AMM 27-51-44-400-001.SDR USAA2012061400025Strut · corroded2S CHECK - CORROSION ON LEFT WING INTERCONNECTING STRUT ASSEMBLY AT BS 4862, RIB 9. REPLACED LEFT WING INTERCONNECTING STRUT ASSEMBLY AT BS 4862, RIB 9 IAW A319 AMM 27-51-44-400-001.SDR USAA2012061400018Hinge Pin · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LEFT WING SPOILER HINGE PIN BETWEEN WS 3059 TO WS 3758, RIB 6 TO RIB 7. REPLACED LEFT WING SPOILER HINGE PIN BETWEEN WS 3059 TO WS 3758, RIB 6 TO RIB 7 IAWA319 AMM 57-64-41.SDR USAA2012061400017Hinge Pin · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LEFT WING SPOILER HINGE PIN BETWEEN WS 3059 TO WS 3758, RIB 6 TO RIB 7. REPLACED LEFT WING SPOILER HINGE PIN BETWEEN WS 3059 TO WS 3758, RIB 6 TO RIB 7 IAW A319 AMM 27-64-41.SDR USAA2012062800005Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK AT FR58, Y1292. REPAIRED SEAT TRACK AT FR58, Y1292 IAW A319 SRM 53-41-15 FIGURE 202, PAGES 215-216.SDR USAA2012062700005Seat Track · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON SEAT TRACK AT FR47/51 TO FR61+10 INCHES, -Y1292. REPLACED SEAT TRACK AT FR47/51 TO FR61+10 INCHES, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2012062700004Seat Track · corroded2S CHECK - CORROSION ON SEAT TRACK AT FR61+10 INCHES & FR64, -Y1292. REPAIRED SEAT TRACK AT FR61+10 INCHES & FR64, -Y1292 IAW A319 SRM 53-41-15.SDR USAA2012062600032Coupling · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON COUPLING AT FR66, -Y1732. REPLACED COUPLING AT FR66, -Y1732 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53474250.SDR USAA2012062600031Sill · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON LOWER SILL BETWEEN FR66 TO FR68, -Y1732. REPLACED LOWER SILL BETWEEN FR66 TO FR68, -Y1732 IAW A319 SRM 51-72-11; EA 500742 & AIRBUS DRAWING D53480505.SDR USAA2012062600019Skin · saturated2S CHECK - TRAPPED WATER ON RIGHT ELEVATOR UPPER SKIN BETWEEN THS STA 404 TO STA 466 & BETWEEN RIB 10 TO RIB 11, 5.5 INCHES FROM LEADING EDGE. REPAIRED RIGHT ELEVATOR UPPER SKIN IAW A319 SRM 55-21-11 PAR 5(E)(2) & EO 5511Y295 ITEM 11.SDR USAA2012062600018Skin · saturated2S CHECK - TRAPPED WATER ON RIGHT ELEVATOR UPPER SKIN BETWEEN THS STA 446 TO STA 527 & BETWEEN RIB 11 TO RIB 12, 5.5 INCHES FROM TRAILING EDGE. REPAIRED RIGHT ELEVATOR UPPER SKIN IAW A319 SRM 55-21-11 PAR 5(E)(2) & EO 5511Y295 ITEM 11.SDR USAA2012062600017Skin · corroded2S CHECK - TRAPPED WATER ON RIGHT ELEVATOR UPPER SKIN BETWEEN THS STA 404 TO STA 466 & BETWEEN RIB 10 TO RIB 11, 9.5 INCHES FROM LEADING EDGE. REPAIRED RIGHT ELEVATOR UPPER SKIN IAW A319 SRM 55-21-11 PAR 5(D)(2) & EO 5511Y295 ITEM 11.SDR USAA2012062600016Skin · saturated2S CHECK - TRAPPED WATER ON RIGHT ELEVATOR UPPER SKIN BETWEEN THS STA 181 TO STA 227 & BETWEEN RIB 5 TO RIB 6, 8.5 INCHES FROM LEADING EDGE. REPAIRED RIGHT ELEVATOR UPPER SKIN IAW A319 SRM 55-21-11 PAR 5(E)(2) & EO 5511Y295 ITEM 11.
Back to N740UW