N715UW
Service difficulty reports · 306
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 = 'N715UW' 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 = 'N715UW' 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 USAA2011040791361Floor Support · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOOR SUPPORT BEAM AT FR67, Y1292. REPLACED FLOOR SUPPORT BEAM AT FR67, Y1292 IAW A319 SRM 51-42-00 & 51-72-11.SDR USAA2011040791360Floor Support · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOOR SUPPORT BEAM AT FR68, Y292. REPLACED FLOOR SUPPORT BEAM AT FR68, Y292 IAW A319 SRM 51-42-00 & 51-72-11.SDR USAA2011040891376Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR66, -Y765. REPLACED FLOORBEAM AT FR66, -Y765 IAW A319 SRM 53-41-11.SDR USAA2011040891375Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR64 TO FR65, -Y1292. REPLACED FLOORBEAM BETWEEN FR64 TO FR65, -Y1292 IAW A319 SRM 53-41-11.SDR USAA2011040891374Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR68 TO FR69, -Y1292. REPLACED FLOORBEAM BETWEEN FR68 TO FR69, -Y1292 IAW A319 SRM 53-41-14.SDR USAA2011040891371Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR67 +12 INCHES, -Y1292. REPLACED FLOORBEAM AT FR67 +12 INCHES, -Y1292 IAW A319 SRM 53-41-14.SDR USAA2011040891388Floorbeam · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR66,-Y465. REPLACED FLOORBEAM AT FR66,-Y465 IAW A319 SRM 53-41-14.SDR USAA2011040791366Floorbeam · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM BETWEEN FR20 TO FR21, Y254. REPLACED FLOOR BEAM AT FR16, Y254 IAW A319 SRM 51-72-11.SDR USAA2011040791365Floorbeam · corrodedPIT - S4 - LEVEL 2 CORROSION ON FLOORBEAM AT FR16, Y254. REPLACED FLOORBEAM AT FR16, Y254 IAW A319 SRM 51-72-11.SDR USAA2011040791358Seat Track · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON CABIN SEAT TRACK BEAM AT FR24, Y765. REPLACED CABIN SEAT TRACK BEAM AT FR24, Y765 IAW A319 SRM 51-72-11.SDR USAA2011040791357Seat Track · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON CABIN SEAT TRACK BEAM AT FR23, Y765. REPLACED CABIN SEAT TRACK BEAM AT FR23, Y765 IAW A320 SRM 51-72-11.SDR USAA2011040791356Seat Track · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON CABIN SEAT TRACK BEAM AT FR23, -Y765. REPLACED CABIN SEAT TRACK BEAM AT FR23, -Y765 IAW A320 SRM 51-72-11.SDR USAA2011040791355Seat Track · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON CABIN SEAT TRACK BEAM AT FR20, Y765. REPLACED CABIN SEAT TRACK BEAM AT FR20, Y765 IAW A319 SRM 51-72-11.SDR USAA2011040791354Seat Track · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON CABIN SEAT TRACK BEAM AT FR21, -Y765. REPLACED CABIN SEAT TRACK BEAM AT FR21, -Y765 IAW A319 SRM 51-72-11.SDR USAA2011040791353Seat Track · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON CABIN SEAT TRACK BEAM AT FR16, FR18, FR18 & FR20, Y1292. REPLACED CABIN SEAT TRACK BEAM AT FR16, FR18, FR18 & FR20, Y1292 IAW A319 SRM 51-72-11.SDR USAA2011040791347Angle · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON R-1 DOOR THRESHOLD ANGLE BETWEEN FR16 TO FR20, -Y1497. REPLACED R-1 DOOR THRESHOLD ANGLE BETWEEN FR16 TO FR20, -Y1497 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53112109.SDR USAA2011040791359Seat Track · corrodedPIT - S4 - LEVEL 2 INTERGRANULAR CORROSION ON CABIN SEAT TRACK BEAM AT FR21, Y1292. REPLACED CABIN SEAT TRACK BEAM AT FR24, Y765 IAW A319 SRM 51-72-11.SDR USAA2011040791351Mount · corrodedPIT - S4 - LEVEL 2 INTERGRANULAR CORROSION AT R-2 DOOR AFT GIRT BAR MOUNT PLATE AT FR68, S23R. REPLACED R-2 DOOR AFT GIRT BAR MOUNT PLATE AT FR68, S23R IAW AIRBUS DRAWING D53480043.SDR USAA2011040791364Floorbeam · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON FLOORBEAM AT FR16, Y765. REPLACED FLOORBEAM AT FR16, Y765 IAW A319 SRM 51-72-11.SDR USAA2011040791367Floorbeam · corrodedPIT - S4 - LEVEL 2 INTERGRANULAR CORROSION ON FLOORBEAM AT FR20, -Y765. REPLACED FLOORBEAM AT FR20, -Y765 IAW A319 SRM 53-11-15.SDR USAA2011040791370Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR21, -Y1292. REPLACED FLOORBEAM AT FR21, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2011040791369Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR23, -Y1292. REPLACED FLOORBEAM AT FR20, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2011040791368Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR20, -Y1292. REPLACED FLOORBEAM AT FR20, -Y1292 IAW A319 SRM 51-72-11.SDR USAA2011040891372Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM AT FR66, -Y1292. REPLACED FLOORBEAM AT FR66, -Y1292 IAW A319 SRM 53-41-14.SDR USAA2011040791346Access Door · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON LOWER RIGHT FUEL ACCESS DOOR 640KB BETWEEN RIB 15 TO RIB 16. REPLACED LOWER RIGHT FUEL ACCESS DOOR 640KB BETWEEN RIB 15 TO RIB 16 IAW A319 SRM 57-27-11.SDR USAA2011040791345Access Door · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON LOWER RIGHT FUEL ACCESS DOOR 640JB BETWEEN RIB 14 TO RIB 15. REPLACED LOWER RIGHT FUEL ACCESS DOOR 640JB BETWEEN RIB 14 TO RIB 15 IAW A319 SRM 57-27-11.SDR USAA2011040791344Shear Tie · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON PASSENGER FLOOR SHEAR TIE AT FR20, Y1732. REPLACED FLOOR SHEAR TIE AT FR20, Y1732 IAW A319 SRM 51-42-11 & 51-75-12.SDR USAA2011040791343Shear Tie · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON PASSENGER FLOOR SHEAR TIE BETWEEN FR20 TO FR24, -Y1732. REPLACED FLOORBEAM IAW A319 SRM 51-40-00.SDR USAA2011040891391Sill · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON AFT SILL PLATE SHAPE AT FR68, Y1732. REPLACED AFT SILL PLATE SHAPE AT FR68, Y1732 IAW A319 SRM 51-72-11.SDR USAA2011040791349Fitting · corrodedPIT - S4 - LEVEL 2 INTERGRANULAR CORROSION ON LEFT AFT DOOR CUTOUT SHAPE FITTING BETWEEN FR66 TO FR68, Y1732. REPLACED LEFT AFT DOOR CUTOUT SHAPE FITTING BETWEEN FR66 TO FR68, Y1732 IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53480043.SDR USAA2011040891392Shear Plate · corrodedPIT - S4 - LEVEL 2 GALVANIC CORROSION ON SHEAR PLATE BETWEEN FR69 TO FR70, Y1292. REPLACED SHEAR PLATE BETWEEN FR69 TO FR70, Y1292 IAW AIRBUS DWG 18D53474180.SDR USAA2011040891379Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR68, -Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR68, -Y765 IAW A319 SRM 53-41-14.SDR USAA2011040891378Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR65 TO FR66, -Y464. REPLACED FLOORBEAM BETWEEN FR65 TO FR66, -Y464 IAW A319 SRM 52-41-11.SDR USAA2011040891377Floorbeam · corrodedPIT - S4 - LEVEL 2 EXFOLIATION CORROSION ON FLOORBEAM BETWEEN FR66 TO FR70, Y765. REPLACED FLOORBEAM BETWEEN FR66 TO FR70, Y765 IAW A319 SRM 53-00-14.SDR USAA2011040791352Sill · corrodedPIT - S4 - LEVEL 2 INTERGRANULAR CORROSION AT L-2 DOOR AFT GIRT BAR SILL PLATE BETWEEN FR66 TO FR68, S23L. REPLACED L-2 DOOR AFT GIRT BAR SILL PLATE BETWEEN FR66 TO FR68, S23L IAW A319 SRM 51-72-11 & AIRBUS DRAWING D53474250.SDR USAA2010082491754Bottle · low pressureFLT 1406 - PHL-BOS - EMERGENCY EGRESS SYSTEM - R2 DOOR ASSIST BOTTLE REQUIRES SERVICING. SERVICED R2 DOOR ASSIST BOTTLE PER AMM 52-12-00.SDR USAA2010070191318Line · missingFLT 1782 - CLT-YYZ - EMERGENCY EQUIPMENT - BOTH OVERWING SLIDE LIFE LINES MISSING FROM OVERHEAD BINS. MAINTENANCE REPLACED OVERWING LIFE LINES.SDR USAA2009030490500Garlock Seal · leakingFLT 1835 - PHL - FUMES - VERY STRONG FUMES IN COCKPIT AND CABIN DURING DESCENT FROM 15,000FT DOWN & LATER ON GROUND. MAINTENANCE REMOVED AND REPLACED NR 2 ENGINE STARTER GARLOCK SEAL AND BOTH RECIRCULATION FILTERS. NO FUMES OR ODOR PRESENT.SDR USAA2009012690184Lug · crackedPIT - GEAR CHANGE - MAJOR REPAIR - LEFT MAIN LANDING GEAR RIB 5 FORWARD LUG HAS A CRACK. REPAIRED LEFT MAIN LANDING GEAR RIB 5 FORWARD LUG IAW US AIRWAYS EA 112156 & EO 570Y085.SDR USAA920082021Gearbox · leakingLOGPAGE NR 8393492 FLT NR 2036 DCA-BOS OTHER CABIN ODOR IS MAKING PASSENGERS SICK. APU LEAKING OIL AT GEARBOX / COMPRESSOR FLANGE.SDR USAA920081066Seat Track · corrodedPIT - MAJOR REPAIR - C9 CHECK - CORROSION ON CABIN SEAT TRACK, BS 808 / FR 20, -Y765. REPAIRED CABIN SEAT TRACK, BS 605 / FR 12 - BS 1003 / FR 25, -Y765 IAW A319 SRM 53-00-45.SDR USAA920081065Seat Track · corrodedPIT - MAJOR REPAIR - C9 CHECK - CORROSION ON CABIN SEAT TRACK, BS 870 / FR 22, -Y1292. REPLACED CABIN SEAT TRACK, BS 870 / FR 22, -Y1292 IAW A319 SRM 51-72-11.SDR USAA920080555Pin · crackedDCA - MAJOR REPAIR - NOSE LANDING GEAR TORQUE LINK PIN CRACKED. REPLACED NOSE LANDING GEAR TORQUE LINK.SDR SA07019Packing · cutCLT - FLT 864 EN-ROUTE TPA TO PIT. DURING CRUISE, AND APPROXIMATELY 50 MILES SOUTH OF CLT, THE FLIGHT CREW REPORTED THAT THE LEFT ENGINE OIL QUANTITY WAS AT 2 QUARTS. OIL PRESSURE WAS FOUND NORMAL. THE FLIGHT DIVERTED TO CLT AND DECLARED AN EMERGENCY. THE SDR SA06068Girt Bar · faultyDCA - THE GIRT BAR ON THE FORWARD LEFT ENTRANCE DOOR ESCAPE SLIDE WAS FOUND TO FAIL INSPECTION DURING THE SLIDE REPLACEMENT. MAINTENANCE REPLACED THE GIRT BAR. OK FOR SERVICE.SDR SA05090Epsu · failedPIT - DURING THE EMERGENCY LIGHTS TEST, RECEIVED 'EPSU INT LOAD EMER R' FAULT. MAINTENANCE REPLACED THE RIGHT EMERGENCY POWER SUPPLY UNIT. SYSTEM OPERATIONALLY CHECKS OK.SDR USAA050654Floorbeam · corrodedPIT - FOUND FLOORBEAM CORRODED .5 INCH WIDE BY 6 INCHES LONG, TOP SURFACE FLOORBEAM, FRAME STATION 66, 30 INCHES RIGHT OF CENTER LINE. REPLACED PER AIRBUS DWG D54372815 AND SRM 51-72-11. (M)SDR USAA050661Floorbeam · corrodedFOUND FLOORBEAM CORRODED 1 INCH BY 2 INCHES AND 1 INCH BY 3 INCHES, LEFT FLOORBEAM BETWEEN FRAME 66-69 APPROX 50 INCHES FROM CENTER. DEFECTIVE PART REPLACED WITH IDENT PART. (M)SDR USAA050655Floorbeam · corrodedBFM - FOUND FLOORBEAM CORRODED 3 INCH BY 3 INCH AREA, TOP OF FLOORBEAM AT FRAME 66 AND 50 INCHES LEFT OF CENTER. PART REPLACED PER D53472780. (M)SDR USAASA04070Odor · detectedA STRONG ODOR WAS NOTED BY CREW AT CRUISE AND DESCENT. THE ODOR WAS NOTED TO BE STRONGER IN AFT GALLEY. FLIGHT CONTINUED TO CLT AND LANDED WITHOUT FURTHER INCIDENT. MAINTENANCE INSPECTED LEFT AND RIGHT ENGINES FOR OIL LEAKS AND OIL RESIDUE IN PLUMBING. NON
Back to N715UW