N551UW
Service difficulty reports · 138
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 = 'N551UW' 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 = 'N551UW' 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 AALA201710239017Door Sill · corrodedAIRCRAFT IN BASE MAINTENANCE. CORROSION ON R4 DOOR SILL PLATE, AROUND NUTPLATE HOLE, INBOARD SIDE AT -Y1589, BETWEEN FR 67 AND FR 68. REPAIRED DOOR SILL PER SRM 53-41-14.SDR AALA201710239016Door Sill · corrodedCORROSION ON THE LEFT AFT PASSENGER DOOR SILL PLATE JUST INBOARD OF AFT GIRT BAR FITTING. REPAIRED THE DOOR SILL IAW SRM 53-41-14-300-001.SDR AALA201710239015Shear Plate · crackedCRACKED SHEAR PLATE AT Y1292, FRAME 69. REPLACED THE SHEAR PLATE IAW SRM 51-72-11SDR AALA201710239014Shear Plate · corrodedCORROSION ON RIGHT SHEAR PLATE AT -Y1292, BETWEEN FRAMES 69 AND 70. REPAIRED THE SHEAR PLATE IAW EO 5315Y015.SDR AALA201708229016Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 6C. REPLACED THE LENS.SDR AALA201708029003Floor Panel · delaminatedAIRCRAFT WAS GROUNDED. DELAMINATION ON AFT CARGO FLOOR BOARD (PANEL). REPLACED FLOOR PANEL 151PF PER MM 53-42-14.SDR AALA201708029013Panel · missingFORWARD GALLEY EXIT PANEL BY THE R1 DOOR IS MISSING. REPLACED EMERGENCY EXIT COVER AS REQUIRED.SDR AALA201704179041Light · inoperativeSEAT MOUNTED EMERGENCY LIGHTS AT 8R INOPERATIVE. REPLACED THE EMERGENCY LIGHTSDR AALA201704179040Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT AT 34L INOPERATIVE. REPLACED SEAT MOUNTED EMERGENCY LIGHT.SDR AALA201703219013Ballast · failedELECTRICAL SMOKE ODOR DURING CRUISE 350. FOUND A BAD BALLAST AT 2L DOOR CEILING LIGHT. REPLACED LIGHT ASSEMBLY. AIRCRAFT WAS GROUNDED.SDR AALA201702129004Battery · dischargedFLASHLIGHT INOPERATIVE AT 3L DOOR. REPLACED FLASHLIGHT BATTERY.SDR AALA201702059007Lens · missingR4 DOOR EXIT SIGN COVER MISSING. INSTALLED THE COVER IAW AMM 33-61-13.SDR AALA201612279009Lens · missingMISSING COVER ON EXIT LIGHT BY RIGHT AFT EMERGENCY SLIDE. REPLACED EXIT LIGHT LENS AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612099003Blower · malfunctionedAIRCRAFT WAS NOT GROUNDED. UNUSUALLY LOUD BLOWER MOTOR WITH UNUSUAL SOUND AND ELECTRICAL SMELL. NO STRANGE SOUND OR SMELLS WITH BLOWER OFF. REPLACED AVIONICS BLOWER FAN PER AMM 21-26-51.SDR AALA201612019033Engine · failedLOUD BANG AND VIBRATION FROM NR 2 ENGINE, FOLLOWED BY NR 2 ENGINE EGT OVER LIMIT AND NR 2 ENGINE STALL ECAM. SHUTDOWN THE ENGINE AND DIVERTED. REPLACED THE ENGINE.SDR AALA201611289020Engine · failedFLIGHT DIVERTED TO ABQ DUE TO NUMBER 2 ENGINE EGT OVER LIMIT, STALL, AND SHUTDOWN. AN EMERGENCY WAS DECLARED. THE FLIGHT LANDED WITHOUT FURTHER INCIDENT. THE AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED NR 2 ENGINE.SDR AALA201611199001Light · unsecureSEAT MOUNTED EMERGENCY LIGHT AT SEAT 3L HANGING OUT. REMOVED AND REPLACED SEAT MOUNTED EMERGENCY LIGHT AT SEAT 3L REF AMM 33-51-19. OPS NORMAL. THE AIRCRAFT WAS NOT GROUNDED.SDR AALA201610219001Light · damaged. DAMAGED EMERGENCY LIGHT ON AISLE AT SEAT 10L. REPLACED LIGHT ASSEMBLY IAW JOB CARD 26L00005005.SDR AALA201608159011Light · defectiveSEAT 3C EMERGENCY EXIT LIGHT DEFECTIVE. SEATED THE LIGHT.SDR AALA201603089045Floor Panel · damagedAIRCRAFT WAS GNDED. AFT GALLEY FLOOR PANEL 261DF IS SOFT. REPLACED FLOOR PANEL IAW AMM 53-42-12-400-001.SDR AALA201602109003Cover · missingEMERGENCY EXIT LIGHT COVER MISSING AT 8D. R & R 8D EMER EXIT LIGHT ASSEMBLY. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK.SDR AALA201512109001Light · inoperativeAIRCRAFT WAS NOT GNDED. SEAT 3C EMER LIGHT INOPERATIVE. RE-INSTALLED SEAT 3C EMER LIGHT. ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK IAW AMM 33-51-19-400-003-A.SDR AALA201509259006Mechanism · dirtyDOOR 3R WHITE SLIDE ARMED LIGHT ON. CLEARED DUST & DEBRIS FROM DOOR LATCH MECHANISM. OPERATIONAL TEST GOOD.SDR AALA201506089009Lens · missingL4 DOOR LOWER EMER EXIT LIGHT LENS MISSING. REPLACED THE L4 EMER LIGHT LENS.SDR USAA2015022400004Lens · brokenEMERGENCY EXIT LIGHT LENS AT SEAT 1L IS BROKEN. REPLACED EMER EXIT LIGHT LENS AT SEAT 1L IAW AMM 33-51-19.SDR USAA2014112500003Bottle · defectiveDOOR 2R SLIDE BOTTLE PRESS LOW ON FLIGHT ATTENDANT CID. PAX DOOR 2R SLIDE BOTTLE PRESS INDICATION WAS GOOD. CHANGED BOTTLE IAW AMM 25-62-49-0401.SDR USAA2014091100009Lens · missing4R DOOR SLIDE PACK EMER LIGHTS LENS COVER MISSING. INSTALLED NEW EMER LIGHT LENS COVER.SDR USAA2014063000019Floorboard · debondedFORWARD GALLEY FLOORBOARD 222EF HAS SOFT SPOT & DIS BONDED BETWEEN FRAME 16 TO 20, Y765. REPLACED FLOORBOARD 222EF IAW AMM 53-12-12-400-001-A.SDR USAA2014061200021Reservoir · low pressureCHECK PRESS WARNING FOR DOOR 2R. REPLACED 2R DOOR SLIDE INFLATION RESERVOIR IAW AMM 25-62-49-400-001-A.SDR USAA2013101400023Lens · brokenEMERGENCY LIGHT COVER AT R4 DOOR BROKEN. REPLACED EMERGENCY LIGHT LENS.SDR USAA2013080100002Lens · brokenEXIT SIGN LENS FROM LT DOOR 4 BROKEN. R & R L4 DOOR EXIT SIGN LENS.SDR USAA2013060300014Light · inoperative20L EMERGENCY LIGHT INOPERATIVE. EMERGENCY LIGHT COVER MISSING AT SEAT 27L. FOUND CONNECTOR UNDER SEAT DISCONNECTED AT SEAT 20L. RECONNECTED CONNECTOR AT SEAT 20L. REPLACED EMERGENCY LIGHT ASSY AT SEAT 27L.SDR USAA2013030400014Megaphone · damagedFORWARD MEGAPHONE MISSING VOLUME KNOB. REPLACED MEGAPHONE.SDR USAA2013020100014Reservoir · faultySLIDE BOTTLE INDICATION 2R ON POST FLIGHT REPORT AND CIDS. MAINTENANCE REPLACED INFLATION RESERVOIR IAW AIRBUS MAINTENANCE MANUAL 25-62-49-400-001A.SDR USAA2013013000018Reservoir · low pressureMESSAGE FOR DOOR 2L "CHECK SLIDE PRESSURE". REMOVED AND REPLACED INFLATION RESERVOIR ASSEMBLY IAW AIRBUS MAINTENANCE MANUAL 25-62-49.SDR USAA2013010200005Light · damagedTHE 31L SEAT MOUNTED EMERGENCY EXIT LIGHT DAMAGED. REPLACED 31L SEAT MOUNTED EXIT LIGHT.SDR USAA2012120700012Lens · missingDOOR 4R EXIT SIGN COVER IS MISSING. INSTALLED NEW EXIT SIGN LENS COVER.SDR USAA2012042500004Reservoir · defectiveNR 3 SLIDE BOTTLE SHOWS LOW ON FLIGHT ATTENDANT PANEL. REMOVED AND REPLACED L3 DOOR SLIDE INFLATION RESERVOIR IAW AIRBUS MAINTENANCE MANUAL 25-62-49-4-0.
Back to N551UW