N197UW
Service difficulty reports · 214
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 = 'N197UW' 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 = 'N197UW' 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 USAA2012031500003Computer · faultyPILOT REPORTED A SLIGHT UNCOMMANDED YAW OCCURRED IN CRUISE FLIGHT. AT GATE, AUTO FLT YAW DAMPER - RUDDER SERVO FAULT APPEARED ON ECAM FOR APPOXIMATELY 5 MINUTES AND THEN WENT OUT. NO FAULTS NOTED ON POST FLIGHT REPORT. MAINTENANCE REMOVED AND REPLACED THE NSDR USAA2012022000024Fire Bottle · lowLAVATORY C TRASH CAN FIRE BOTTLE LOW. REMOVED AND REPLACED LAV C TRASH CAN FIRE BOTTLE IAW AIRBUS MAINTENANCE MANUAL 26-25-41.SDR USAA2012012700008Oxygen Mask · missingFORWARD SMOKE MASK MISSING. REPLACED MISSING SMOKE MASK.SDR USAA2011063000006Proximity Switch · faultyCLT - EES - RIGHT SIDE WING SLIDE INDICATES ARMED WHEN IT IS DISARMED. REMOVED AND REPLACED PROXIMITY SWITCH HANDLE 5WN2 PER AIRBUS MAINTENANCE MANUAL 52-73-11.SDR USAA2011060100002Handle · brokenPHL - EES - 3R DOOR ARMING HANDLE IS BROKEN. REMOVED AND REPLACED 3R DOOR ARM / DISARM MECHANISM IAW AIRBUS MAINTENANCE MANUAL 52-22-22-400.SDR USAA2010111292591Actuator · low pressureFLT 1419 - LAX - EES - CIDS CAUTION LIGHT ILLUMINATED. MAINTENANCE SERIVCED 2-R DOOR IAW AIRBUS MAINTENANCE MANUAL 52-22-00-614-002.SDR USAA2010102092326Bottle · low pressureFLT 907 - LAS - EES - 2-R DOOR INDICATION TO CHECK SLIDE PRESSURE. MAINTENANCE SERVICED 2-R DOOR ASSIST BOTTLE IAW AIRBUS MAINTENANCE MANUAL 52-22-00.SDR USAA2010090791919Actuator · low pressureFLT 1520 CLT - EES - CIDS "CHECK DOOR PRESSURE" AT 2R DOOR. MAINTENANCE SERVICED 2R DOOR IAW AIRBUS MAINTENANCE MANUAL 52-22-00-03-614-002.SDR USAA2010071291402Bottle · low pressureFLT 1538 - CLT - EES - FLIGHT ATTENDANT REPORTED CIDS PANEL INDICATION 'CHECK LOW PRESSURE 2R DOOR'. MAINTENANCE SERVICED DOOR ASSIST BOTTLE.SDR USAA2010012590172Cylinder · low pressureFLT 1547 - SEA - EES - CIDS CAUTION DOOR BOTTLE 1L/DEU B (300RH1). MAINTENANCE SERVICED 1L DAMPER CYLINDER PER AIRBUS MAINTENANCE MANUAL 52-10-00-614-001.SDR USAA2009120393290Cylinder · low pressureFLT 1515 - LAS - EMERGENCY EGRESS SYSTEM - L-1 DOOR ASSIST BOTTLE LOW. MAINTENANCE SERVICED L-1 DOOR ASSIST BOTTLE IAW AIRBUS MAINTENANCE MANUAL 52-10-00-614-001.SDR USAA2009112093178Cylinder · low pressureFLT 1709 - CLT - EMERGENCY EGRESS SYSTEM - L-1 DOOR SLIDE PRESSURE LOW. MAINTENANCE SERVICED L1 DOOR ASSIST PRESSURE.SDR USAA2009110693050Cylinder · low pressureFLT 965 - SFO - EMERGENCY EGRESS SYSTEM - FORWARD ENTRY DOOR ASSIST BOTTLE PRESSURE LOW. MAINTENANCE SERVICED FORWARD ENTRY DOOR ASSIST BOTTLE.SDR USAA2009101692782Cylinder · low pressureFLT 706 - PHL - EMERGENCY EGRESS SYSTEM - FLIGHT ATTENDANT REPORTS CIDS PANEL INDICATES CHECK DOOR PRESSURE ON L1. MAINTENANCE SERVICED DOOR BOTTLE AT L1 IAW AIRBUS MAINTENANCE MANUAL 52-10-00.
Back to N197UW