N193UW
Service difficulty reports · 262
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 = 'N193UW' 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 = 'N193UW' 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 AALA201812249005Bottle · low pressureR2 DOOR ASSIST PRESSURE WAS LOW DURING ARMING. SERVICED THE THE DOOR ASSIST BOTTLE IAW MM 52-22-14. SAFETY PINS INSTALLED AND REMOVED.SDR AALA201811269034Cylinder · low pressureL1 DOOR EMERGENCY CYLINDER PRESSURE WAS IN THE YELLOW ZONE. OUTSIDE TEMPERATURE 32DEG. CHARGED THE L1 DOOR EMERGENCY CYLINDER IAW AMM 52-10-00.SDR AALA201811269016Cylinder · low pressureR2 DOOR EMERGENCY CYLINDER PRESSURE WAS LOW. MAINTENANCE CHARGED THE CYLINDER IAW AMM 52-10-00, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811149005Bottle · low pressureR2 DOOR PRESSURE WAS LOW. THE AIRCRAFT WAS GROUNDED. REPLACED THE DOOR DAMPNER AND EMERGENCY OPERATION CYLINDER IAW AMM 52-22-14.SDR AALA201810089010Bottle · low pressureR2 DOOR SLIDE PRESSURE WARNING ON CIDS. SERVICE THE DOOR ASSIST BOTTLE IAW AMM 52-20-00. OK FOR SERVICE.SDR AALA201810049030Connector · brokenEMERGENCY EXIT ROW, SEAT MOUNTED LIGHT 22BC WAS INOPERATIVE. FOUND THE WIRE HARNESS CONNECTOR UNDER SEAT TO BE BROKEN. REPLACED THE CONNECTOR IAW ESPM 20-44-00. EMERGENCY LIGHT TEST PASSED IAW AMM 33-51-00.SDR AALA201809179027Sensor · dirtyOVERHEAD AISLE LIGHT AND OVERWING EXIT LIGHT AT R3 CAME ON DURING TURBULENCE AND STAYED ON. CLEANED THE SENSOR AND SWITCH. PERFORMED CIDS RESET. OPS CHECKED GOOD. AIRCRAFT OK FOR SERVICE.SDR AALA201806179002Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT 12WL BATTERY INOPERATIVE. REPLACED EMERGENCY POWER SUPPLY UNIT (12WL) BATTERY PER AMM 33-55-00. SYSTEM OPERATIONS CHECKS GOOD.SDR AALA201805249018Flashlight · inoperativeAIRCRAFT WAS NOT GROUNDED. DOOR 2R FLASHLIGHT NOT SHOWING CHARGING. REPLACED FLIGHT ATTENDANT FLASHLIGHT ASSEMBLY AT 2R DOOR PER CMM 25-60-02.SDR AALA201804309037Light · brokenEMERGENCY LIGHT AT SEAT 20C WAS FOUND BROKEN. MAINTENANCE REPLACED EMERGENCY LIGHT IAW AMM 33-51-19 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201804109010Warning System · false activationAIRCRAFT WAS NOT GROUNDED. DOOR 2L DOOR ASSIST PRESSURE MESSAGE ON CIDS PANEL. CHECKED DOOR ASSIST BOTTLE PER AMM 52-22-00. OPERATIONS CHECK NORMAL. NO FAULTS NOTED.SDR AALA201803269010Cable · failedSEAT 8 ABC EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EMERGENCY LIGHT CABLE IAW AMM 33-51-00.SDR AALA201803139025Apu · odorCABIN ODOR, FLIGHT ATTENDANT'S STATED PCP ODOR IN REAR, ROW 22 - 28 WAS THE STRONGEST. FLIGHT DECK VENT OUTLET HAD A DIRTY SOCK ODOR. REMOVED AND REPLACED APU GENERATOR IAW AMM 24-23-51 AND CLEANED APU COMPARTMENT AND INLET AS REQUIRED. OPS AND LEAK CHECKSDR AALA201802279018Cylinder · low pressureAIRCRAFT IN BASE MAINTENANCE: R2 DOOR PRESSURE LOW WITH DOOR ARMED. MAINTENANCE CHARGED DOOR DAMPER (CYLINDER) AT R2 TO PROPER PRESSURE PER AMM 52-22-00-614-002-A AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201801229025Connector · unsecureWHITE EMERGENCY LIGHT INOPERATIVE AT ROW 3. SECURED A LOOSE CONNECTOR IAW AMM 33-50-00. OPS CHECKED GOOD.SDR AALA201712129031Pin · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. PITTING CORROSION ON RIGHT MAIN LANDING GEAR REAR PINTLE PIN. REMOVED AND REPLACED PINTLE PIN PER JOB CARD 26T00032001 STEP 26.SDR AALA201711139032Cylinder · low pressureR2 DOOR CYLINDER IN YELLOW BAND, LOW PRESSURE. SERVICED DOOR CYLINDER TO CORRECT LIMIT IAW AMM 52-10-00.SDR AALA201711139025Cylinder · low pressureL1 DOOR DAMPER CYLINDER IN YELLOW BAND, LOW PRESSURE. SERVICED THE CYLINDER IAW AMM 52-10-00.SDR AALA201711099001Lens · missingEMERGENCY LIGHT ON SEAT 8C WAS MISSING THE LENS. REPLACED THE EMERGENCY LIGHT ASSEMBLY AT SEAT 8C. OPS CHECKED GOOD IAW AMM.SDR AALA201711089013Lens · missingEMERGENCY LIGHT LENS MISSING AT SEAT 9D. REPLACED THE LENS IAW AMM.SDR AALA201710169037Light · inoperativeFLOOR EMERGENCY LIGHT AT 27C INOPERATIVE. REPLACED THE LIGHT IAW AMM.SDR AALA201709229011Cylinder · low pressureCIDS PANEL INDICATES THE R2 SLIDE PRESSURE LOW.SDR AALA201708229018Control Valve · faultyAFTER GEAR EXTENSION, THE BRAKE ALTN BRAKE FAULT ILLUMINATED. REMOVED AND REPLACED RT ALTERNATE BRAKE DIRECT DRIVE VALVE.SDR AALA201708149008Hinge Arm · wornSEVERE NLG VIBRATION, RIGHT AFT NLG DOOR HAS EXCESS PLAY FORE TO AFT AND SIDE TO SIDE, LEFT NLG DOOR HAS EXCESS PLAY FORE TO AFT AND SIDE TO SIDE. REMOVED AND REPLACED LEFT AFT NOSE LANDING GEAR DOOR AND RIGHT AFT NOSE LANDING GEAR DOOR HINGE IAW AMM 32-22-1SDR AALA201708049022Door · looseSEVERE NLG VIBRATION, RIGHT AFT NLG DOOR HAS EXCESS PLAY FORE TO AFT AND SIDE TO SIDE, LEFT NLG DOOR HAS EXCESS PLAY FORE TO AFT AND SIDE TO SIDE. AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED LEFT AFT NOSE LANDING GEAR DOOR AND RIGHT AFT NOSE LANDING GEAR DSDR AALA201707269042Fairing · damagedAIRCRAFT WAS GROUNDED. LEFT MAIN LANDING GEAR DOOR SECONDARY HINGED FAIRING DOOR IS DAMAGED. REPORTED TO HAVE PARTIALLY LIBERATED IN FLIGHT. INSTALLED HINGED FAIRING PER AMM 32-12-13-401. OPERATIONAL CHECK GOOD.SDR AALA201707199020Floor Panel · delaminatedDELAMINATION ON AFT CARGO BAY FLOOR PANEL 151GF ON RIGHT OUTBOARD SIDE. REPLACED THE FLOOR PANEL IAW AMM 53-42-14-400.SDR AALA201707179041Lens · missingEMERGENCY EXIT LIGHT AT THE R4 DOOR FOUND INOPERATIVE AND THE COVER IS MISSING. INSTALLED THE LENS.SDR AALA201706199053Cylinder · low pressureR2 DOOR ASSIST BOTTLE PRESSURE LOW. SERVICED THE ASSIST BOTTLE IAW AMM 52-10-00-614-001A. OK FOR SERVICE.SDR AALA201705029030Lever · looseFLIGHT ATTENDANTS REPORTED THE DOOR ARMING LEVER ON THE R2 DOOR WAS LOOSE. ALMOST FALLING OFF. TIGHTENED NUT ON DOOR ARMING LEVER. CHECKED GOOD.SDR AALA201704119001Bushing · migratedL1 DOOR UPPER ATTACH FITTING BUSHING MIGRATED. REPLACED THE L1 DOOR UPPER AND LOWER ATTACH FITTING IAW 52-11-11. AIRCRAFT WAS GROUNDED.SDR AALA201704109012Floor Panel · damagedAIRCRAFT WAS NOT GROUNDED. SOFT SPOTS IN FLOOR BETWEEN ROWS 1-3, AISLE. REPLACED FLOOR PANEL 231AF PER AMM 53-12-12.SDR AALA201704109011Floor Panel · damagedAIRCRAFT WAS NOT GROUNDED. SOFT SPOTS IN FLOOR BETWEEN ROWS 1-3, AISLE. REPLACED FLOOR PANEL 231BF PER AMM 53-12-12.SDR AALA201702129001Handle · looseOVERWING R2 DOOR SLIDE ARMING HANDLE IS LOOSE. SECURED THE ARMING HANDLE.SDR AALA201612189002Battery · inoperativeFIRST CLASS FLIGHT ATTENDANT FLASHLIGHT INOPERATIVE. REPLACED FLASHLIGHT BATTERY AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA201612179005Lever · looseR2 DOOR DISARMING LEVER LOOSE. SECURED THE R2 DOOR ARM - DISARM LEVER IAW AMM 52-22-22.SDR AALA201610319017Lens · missingEMERGENCY LIGHT LENS AT SEAT 7D MISSING. REPLACED LIGHT LENS.SDR AALA201610319016Lens · missingEMERGENCY LIGHT LENS AT SEAT 5D MISSING. REPLACED LIGHT LENS.SDR AALA201610319015Lens · missingEMERGENCY LIGHT LENS AT SEAT 3C MISSING. REPLACED THE LENS.SDR AALA201610269026Cover · missingEMERGENCY LIGHT AT SEAT 1C MISSING. REPLACED THE COVER.SDR AALA201608109019Lever · looseAIRCRAFT WAS NOT GROUNDED, R2 DOOR DISARM LEVER IS LOOSE. SECURED R2 DOOR DISARM LEVER AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 52-22-22.SDR AALA201605269004Battery · dischargedAIRCRAFT WAS NOT GNDED. FLASHLIGHT AT AFT GALLEY FLIGHT ATTENDANT SEAT IS NOT BLINKING. R & R FLASHLIGHT BATTERY. OPERATIONAL CHECKED GOOD.SDR AALA201605099007Proximity Switch · faultyDIVERTED SHORTLY AFTER TAKEOFF. THE FLIGHT CREW NOTED AN ECAM MSG FOR ENG 2 REVERSER FAULT & FOR A FIRST OFFICERS PITOT FAULT. THE CREW DECLARED AN EMER & DIVERTED WHERE THE ACFT LANDED SAFELY. DETERMINED THAT THE MLG PROXIMITY SENSOR 22GA WAS FAULTY & REPLSDR AALA201601019003Wire Harness · damagedAIRCRAFT WAS NOT GNDED. RED SEAT MOUNTED EMER LIGHT AT ROW 22 RT INOPERATIVE. A/C TO SEAT CABLE DAMAGED. REMOVED HARNESS & REPLACED WITH NEW 29-3351-3-0008 ROUTED & CONNECTED IAW CMM 25-22-50. OPERATIONS CHECKED GOOD.SDR AALA201507099004Megaphone · damagedAFT MEGA PHONE VOLUME KNOB IS MISSING. R & R AFT MEGA PHONE IAW AMM 25-65-51. OPERATIONS CHECKED GOOD.SDR AALA201504179004Bottle · low pressureFWD CIDS PANEL HAS CHECK SLIDE PRESSURE INDICATION ON SHUTDOWN. SERVICED THE L3 DOOR EMERGENCY OPERATION CYLINDER.SDR USAA2015033100004Light · inoperativeCEILING EMER LIGHT 203WL INOPERATIVE ON TEST. REPLACED LIGHT ASSEMBLY. OPERATIONAL CHECKED GOOD.SDR USAA2015022000011Hydraulic Line · faultyWHILE ENROUTE, THE FLIGHT EXPERIENCED A GREEN HYD LOW PRESS PROBLEM. AN EMER WAS DECLARED PRIOR TO LANDING. R & R THE NR 1 ENG HYD CONTROL UNIT GREEN SYS PIPE IAW AMM 29-11-49-400-049-A.SDR USAA2015021300001Proximity Switch · faultyR3 DOOR SLIDE ARMED INDICATION CLICKING. REPLACED PROXIMITY SWITCH 6WN2 IAW AMM 52-73-11-401. OPERATIONAL CHECKED GOOD.SDR USAA2015020200004Bottle · low pressureCIDS INDICATED CHECK DOOR PRESS ON DOOR 3L. SERVICED 3L DOOR ASSIST BOTTLE IAW AMM 52-22-00.
Back to N193UW