N185UW
Service difficulty reports · 310
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 = 'N185UW' 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 = 'N185UW' 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 USAA2013091800005Seat Track · corroded2S CHECK, CORROSION ON SEAT TRACK BETWEEN FRAMES 64 TO 66+5", -Y1292. REPLACED SEAT TRACK IAW SRM 51-72-11 & DWG D53472816.SDR USAA2013091800004Seat Track · corroded2S CHECK, CORROSION ON SEAT TRACK BETWEEN FRAMES 64 TO 66+5", Y1292. REPLACED SEAT TRACK IAW SRM 51-72-11, DWG D53472815 & D53472090.SDR USAA2013091700025Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 64 & 66+5", -Y765. REPLACED FLOOR SUPPORT IAW SRM 51-72-11.SDR USAA2013091700024Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 64 & 66+5", Y765. REPLACED FLOOR SUPPORT IAW SRM 51-72-11 & DWG D53472831.SDR USAA2013091700023Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 64 & 67+10", -Y465. REPLACED FLOOR SUPPORT IAW SRM 51-72-11 & DWG D53472816.SDR USAA2013091700022Floor Support · corroded2S CHECK - CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 66+5" & 67+15", Y1225. REPLACED FLOOR SUPPORT IAW SRM 51-72-11 & DWG D53472780.SDR USAA2013091700021Floor Support · corroded2S CHECK, CORROSION ON FLOORBEAM BETWEEN FRAMES 66+5" & 67+15", -Y1225. REPLACED FLOOR SUPPORT IAW SRM 51-72-11, DWG D53474250 & D53472780.SDR USAA2013091700020Floorbeam · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 67+15" & 69, -Y1162. REPLACED FLOOR SUPPORT IAW SRM 51-72-11, DWG D53472089 & D53472780.SDR USAA2013091700019Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 66+5" & 70, -Y765. REPLACED FLOOR SUPPORT IAW SRM 51-72-11.SDR USAA2013091700018Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 67+15" & 69, Y1162. REPLACED FLOOR SUPPORT IAW SRM 51-72-11, DWG D53472088 & D53472780.SDR USAA2013091700017Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 66+5" & 70, Y765. REPLACED FLOOR SUPPORT IAW SRM 51-72-11 & DWG D53472780.SDR USAA2013091700016Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 68 & 70, S23R, -Y160. REPLACED FLOOR SUPPORT IAW SRM 51-72-11, DWG D53112812 & D53110989.SDR USAA2013091700015Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 16 & 20, Y765. REPLACED FLOOR SUPPORT IAW SRM 51-72-11, DWG D53112812 & D53110989.SDR USAA2013091700014Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 16 & 23, -Y1292. REPLACED FLOOR SUPPORT IAW SRM 51-72-11 & DWG D53115054.SDR USAA2013091700013Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 18 & 20, -Y254. REPLACED FLOOR SUPPORT IAW SRM 51-72-11, DWG D53111461 & D53111462.SDR USAA2013091200006Floor Support · corroded2S CHECK, CORROSION FOUND ON FLOOR SUPPORT BETWEEN FRAMES 67+10" - 70, S23R, -Y512. REPLACED FLOOR SUPOPRT IAW SRM 51-72-11 & DWG D53472780.SDR USAA2013091100012Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 65 TO 66, Y1732. REPLACED FLOOR SUPPORT IAW SRM 51-72-11 & DWG D53474250 & D53472750.SDR USAA2013091100011Dummy Rail · corroded2S CHECK, CORROSION ON DUMMY RAIL BETWEEN FRAMES 12 TO 16, -Y81. REPLACED DUMMY RAIL IAW SRM 51-72-11 & DWG D53112828 & D53110984.SDR USAA2013091100009Floor Support · corroded2S CHECK, CORROSION ON FLOOR SUPPORT BETWEEN FRAMES 12 TO 24, Y254. REPLACED FLOOR SUPPORT IAW SRM 51-72-11 & DWG D53112816 & D53110984.SDR USAA2013090900015Dummy Rail · corroded2S CHECK - LEVEL 2 GALVANIC CORROSION ON DUMMY RAIL BETWEEN FR12 TO FR16, Y503. REPLACED DUMMY RAIL BETWEEN FR12 TO FR16, Y503 IAW SRM 51-72-11 & DWG D53110984.SDR USAA2013090600007Seat Track · corroded2S CHECK, CORROSION ON SEAT TRACK BETWEEN FRAMES 20 TO 21, -Y189. REPLACED SEAT TRACK IAW SRM 51-72-11 & DWG D53111406.SDR USAA2013090500022Web · corroded2S CHECK, CORROSION ON WEB AT FRAME 20, Y1732. REPLACED WEB IAW SRM 51-72-11 AND DWG D53114392.SDR USAA2013090500021Web · corroded2S CHECK, CORROSION ON WEB BETWEEN FRAMES 20 TO 24, S23R, -Y1732. REPLACED WEB IAW SRM 51-72-11.SDR USAA2013091100025Floor Panel · delaminated2S CHECK, DELAMINATION ON FLOOR PANEL 151GF BETWEEN FRAMES 52 TO 56 & BETWEEN Y765 TO -Y765. REPLACED FLOOR PANEL IAW SRM 53-02-00 & IRM 9701, REV G.SDR USAA2013091100022Skin · contaminated2S CHECK, TRAPPED WATER INDICATION ON RT ELEVATOR UPPER SKIN SURFACE APPROX 70" INBD FROM RIB 10" & 4" FROM T/E. REPAIRED RT ELEVATOR UPPER SKIN SURFACE IAW SRM 55-21-11.SDR USAA2013091100021Elevator · saturated2S CHECK, TRAPPED WATER INDICATION ON RT ELEVATOR UPPER SKIN SURFACE APPROX 54" INBD FROM RIB 10" & 4" FROM T/E. REPAIRED RT ELEVATOR UPPER SKIN SURFACE IAW SRM 55-21-11, PAR 5E (2).SDR USAA2013091100020Skin · saturated2S CHECK, TRAPPED WATER INDICATION ON RT ELEVATOR UPPER SKIN SURFACE APPROX 7" INBD FROM RIB 10" & 4" FROM T/E. REPAIRED RT ELEVATOR UPPER SKIN SURFACE IAW SRM 55-21-11, PAR 5E(2).SDR USAA2013091100019Skin · saturated2S CHECK -TRAPPED WATER INDICATION ON RT ELEVATOR UPPER SKIN SURFACE APPROX 55" OTBD FROM RIB 5" & 4" FROM T/E. REPAIRED RT ELEVATOR UPPER SKIN SURFACE IAW SRM 55-21-11, PAR 5E(2).SDR USAA2013091100018Skin · saturated2S CHECK - TRAPPED WATER INDICATION ON RT ELEVATOR UPPER SKIN SURFACE APPROX 40" OTBD FROM RIB 5" & 4" FROM T/E. REPAIRED RT ELEVATOR UPPER SKIN SURFACE IAW SRM 55-21-11, PAR 5E.SDR USAA2013091100017Skin · contaminated2S CHECK - TRAPPED WATER INDICATION ON RT ELEVATOR UPPER SKIN SURFACE APPROX 26" OTBD FROM RIB 5" & 4" FROM T/E. REPAIRED RT ELEVATOR UPPER SKIN SURFACE IAW SRM 55-21-11, PAR 5E.SDR USAA2013091100016Skin · contaminated2S CHECK -TRAPPED WATER INDICATION ON RT ELEVATOR UPPER SKIN SURFACE APPROX 12" OTBD FROM RIB 5 & 4" FROM T/E. REPAIRED RT ELEVATOR UPPER SKIN SURFACE IAW SRM 55-21-11, PAR 5E (2).SDR USAA2013091100015Skin · contaminated2S CHECK -TRAPPED WATER INDICATION ON RT ELEVATOR UPPER SKIN SURFACE APPROX 1.0" OTBD FROM RIB 4 & 3" FROM T/E. REPAIRED RT ELEVATOR UPPER SKIN SURFACE IAW SRM 55-21-11, PAR 5E (2).SDR USAA2013020800036Pump · failedAFTER ENGINE START, ECAM SHOWED NUMBER 2 ENGINE FAIL, ENGINE THEN SHUT DOWN. REMOVED AND REPLACED NR 2 ENGINE FUEL PUMP/FILTER, BLEED VALVE PRESSURE REGULATOR AND HYDROMECHANICAL UNIT. ENGINE FUEL PUMP DETERMINED TO BE CAUSE OF FAILURE.SDR USAA2012081300024Valve · leakingINFLIGHT MSP-PHX, CREW RECEIVED 'HYD Y SYS LO LVL' ECAM MESSAGE. IT WAS DETERMINED THAT YELLOW HYDRAULIC SYSTEM WAS LOST. AN EMERGENCY WAS DECLARED AND AIRCRAFT LANDED WITHOUT INCIDENT IN PHX AND TAXIED TO GATE UNDER ITS OWN POWER. MAINTENANCE REMOVED AND RSDR USAA2012080200028Megaphone · inoperativeMEGAPHONE IN REAR CABIN INOPERATIVE. REMOVED AND REPLACED MEGAPHONE.SDR USAA2012060400018Chiller · defectiveFLIGHT ATTENDANT REPORTED BURNING SMELL IN AFT GALLEY WHICH DISSIPATED AFTER CHILLER WAS TURNED OFF. MAINTENANCE REMOVED AND REPLACED AFT CHILLER IAW AIRBUS MAINTENANCE MANUAL 25-31-51.SDR USAA2012042300036Lens · detachedTHE 4L EXIT DOOR LIGHT FELL OFF. REPLACED EMERGENCY EXIT LIGHT LENS COVER AT DOOR 4L.SDR USAA2011092200003Megaphone · inoperativeAFT LEFT MEGAPHONE INOPERATIVE. REMOVED AND REPLACED MEGAPHONE AND BATTERY. OPS CHECK NORMAL.SDR USAA2011081600046Proximity Sensor · faultyR3 DOOR OPEN LIGHT ILLUMINATED WITH DOOR CLOSED. MAINTENANCE REMOVED AND REPLACED PROXIMITY SENSOR IAW AIRBUS MAINTENANCE MANUAL 52-71-13-0401.SDR USAA2011070800010Lens · out of positionEMERGENCY LIGHT LENS COVER AT R2 DOOR FALLING OFF. RE-INSTALLED & SECURED EMERGENCY LIGHT COVER AT R2 DOOR. OPS CHECKED GOOD.SDR USAA2011062800031Bottle · low pressureCLT-MCO - EES - 2R DOOR EMERGENCY SLIDE BOTTLE LOW. REMOVED AND REPLACED R2 DOOR ESCAPE-SLIDE INFLATION RESERVOIR PER AMM 25-62-49-400-001.SDR USAA2010110192456Fitting · corrodedPIT - MAJOR REPAIR - C11 - CORROSION ON SKIN CLIP AT FORWARD CARGO FR 35.2, BETWEEN STR 40L TO 41L. REPLACED SKIN CLIP AT FORWARD CARGO FR 35.2, BETWEEN STR 40L TO 41L IAW TYPICAL REPAIR 53-21-01A.SDR USAA2010110192455Fitting · corrodedPIT - MAJOR REPAIR - C11 - CORROSION ON SKIN CLIP AT FORWARD CARGO FR 35.2, BETWEEN STR 42L TO 43L. REPLACED SKIN CLIP AT FORWARD CARGO FR 35.2, BETWEEN STR 42L TO 43L IAW TYPICAL REPAIR 53-21-01A.SDR USAA2010110192454Fitting · corrodedPIT - MAJOR REPAIR - C11 - CORROSION ON SKIN CLIP AT FORWARD CARGO FR 35.2, BETWEEN STR 41L TO 42L. REPLACED SKIN CLIP AT FORWARD CARGO FR 35.2, BETWEEN STR 41L TO 42L IAW TYPICAL REPAIR 53-21-01A.SDR USAA2010110192458Fitting · corrodedPIT - MAJOR REPAIR - C11 - CORROSION ON SKIN CLEAT AT FORWARD CARGO FR 35.2, BETWEEN STR 41L TO 42L. REPLACED SKIN CLEAT AT FORWARD CARGO FR 35.2, BETWEEN STR 41L TO 42L IAW TYPICAL REPAIR 53-21-12-001.SDR USAA2010110192457Fitting · corrodedPIT - MAJOR REPAIR - C11 - CORROSION ON SKIN CLEAT AT FORWARD CARGO FR 35.1, BETWEEN STR 42L TO 43L. REPLACED SKIN CLEAT AT FORWARD CARGO FR 35.1, BETWEEN STR 42L TO 43L IAW TYPICAL REPAIR 53-21-01A.SDR USAA2010092092029Lens · missingFLT 1086 - CLT - EEL - ROW 9 A/C LEFT EMERGENCY EXIT LIGHT MISSING RED LENS. MAINTENANCE REPLACED LENS AT 9 A/C LEFT.SDR USAA2010082491757Actuator · low pressureFLT 1085 - CLT - EES - CIDS RED LIGHT ON FOR LOW DOOR PRESSURE. MAINTENANCE FOUND PRESSURE LOW ON 3-L DOOR - SERVICED 3-L DOOR PER AIRBUS MAINTENANCE MANUAL 52-22-00-614-002.SDR USAA2010081891700Lens · missingFLT 1537 - SEA - EEL - EMERGENCY LIGHT LENS MISSING FROM ROW 9R. MAINTENANCE INSTALLED NEW EMERGENCY LIGHT LENS AT ROW 9R.SDR USAA2009122493423Iru · inoperativeFLT 797 - PHL-LAX - EMERGENCY LANDING - MULTIPLE WARNING DURING CLIMBOUT. LOST NR 2 AND NR 3 INERTIAL REFERENCES, ALL AUTOMATION, FLIGHT DIRECTOR, AND AUTO THRUST. REMOVED AND REPLACED NR 3 ADIRU PER AMM 34-12-34-000-001. PERFORMED SATISFACTORY LAND CAPABIL
Back to N185UW