N903UA, cancelled Jul 31, 2008
Service difficulty reports · 26
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 = 'N903UA' AND deregistration_id = 'N903UA-2008-07-31' 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 = 'N903UA' AND deregistration_id = 'N903UA-2008-07-31' 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 2008UALA02968Slide · deployedPARTIAL SLIDE DEPLOYMENT 1L. SUSPECT IMPROPERLY INSTALLED SLIDE ASSEMBLY. REPLACED 1L SLIDE PER MM 25-61-35. AC OK FOR SERVICE.SDR 2008UALA02902Light · inoperativeEMERGENCY EXIT LIGHTS INOP ON FLOOR FROM ROW 15 TO AFT GALLEY. REPLACED RIBBON CABLE IN EEL TRACK & AFT GALLEY FLOOR LIGHT.SDR 2008UALA00098Light · inoperativeAFT 3 EEL STRIPS INOPERATIVE IN CABIN. REPLACED POWER STRIPSDR 2007UALA04788Skin · gougedLEFT FUSELAGE SKIN GOUGED JUST AFT OF NR 2 AFT MED. GENERAL FUSELAGE SKIN REPAIR ACCOMPLISHED.SDR 2007UALA03972Transmitter · malfunctionedDURING TROUBLESHOOTING FOR FLAP PROBLEMS, FLAPS CONSISTENTLY STOPPED BETWEEN 1 & 2 DETENTS FOR LENGTHY PERIODS OF TIME & THEN WOULD START AGAIN WITH NO FURTHER INPUTS (BOTH EXTENDING & RETRACTING). REPLACED RT FLAP POSITION TRANSMITTER AND ADJUSTED.SDR 2007UALA03749Slide · faultyDOOR 2L SKIRT IS TOO LONG. F/A'S REPORTED, SKIRT MAKES IT HARD TO ARM-DISARM DOOR. REPLACED SLIDE.SDR 2007UALA02890Light · inoperativeEEL LIGHTS ON FLOOR IN AFT GALLEY IS INOPERATIVE. DRIED WATER OUT OF EEL TRACK.SDR 2007UALA02340Cover · missingDOOR 2L MANUAL INFLATION HANDLE EXPOSED (MISSING VELCRO COVER). [07-24-07] REPOSITIONED SLIDE PACK.SDR 2007UALA01331Slide · unsecureTHE 2L SLIDE OFF MOUNTING. [SUP 05-16-07] REINSTALLED SLIDE.SDR 2007UALA00467Hose · kinkedFIREX HOSE GOING FROM BOTTLE TO NR 2 ENG DISCHARGE TUBE HAS A KINK THAT IS APPROX 20 PERCENT OF THE DIAMETER OF THE HOSE. -SD04-17-07- REPLACED HOSE.SDR 2007UALA00322Battery Pack · inoperativeFOUND EMERGENCY LIGHTS INOP IN FOLLOWING LOCATIONS: ROWS 1-2 EEL LTS, EXIT SIGN ABOVE DOOR 1R, SLIDE LT FOR DOOR 1L, AND EXIT SIGN ABOVE ENTRANCE TO FLT DECK. REPLACED BATTERY PACK.SDR 2006UALA01475Sensor · malfunctionedAIR GROUND SENSOR PROBLEMS, HEAVY ELECTRICAL ODOR FROM PANELS BEHIND FIRST OFFICERS SEAT. CAUSE UNDETERMINABLE. NO FURTHER INSTANCES OF ELECTRICAL SMELL HAVE OCCURED. NO EVIDENCE OF ELECTRICAL PROBLEMS FOUND.SDR 2004UALA01124Frame · damagedSTA 986 FRAME I/B FLANGE HAS AN ELONGATED FASTENER HOLE AT WL 206. INSTALLED ANGLE DOUBLER REPAIR.SDR 2004UALA01111Floorbeam · corrodedSTA 986 FLOOR BEAM UPR CAP HAS CORROSION AT RBL 16 . SUPPLEMENTAL DATA UPDATE MAJOR REPAIR ACCOMPLISHED. SPLICED UPR T-CAP SECTION AT STA 986 FROM RBL 24 TO LBL 65.SDR 2004UALA01123Beam · corrodedAFT CARGO DOOR LWR SILL BEAM UPPER WEB HAS CORROSION. *S/D* MAJOR REPAIR ACCOMPLISHED. REPLACED WEB.SDR 2004UALA01044Oxygen Gen · activatedPSU LT NR 10 OXYGEN GENERATOR HEAT SENSITIVE BAND IS BLACK. RELEASE PIN INADVERTENTLY PULLED. REPLACED AND INSTALLED NEW OXYGEN GENERATOR.SDR 2004UALA01036Shear Web · crackedSTA 194 SHEAR WEB IS CRACKED AT WL 208 LBL 16. MAJOR REPAIR ACCOMPLISHED. REPLACED SHEAR WEB.SDR 2004UALA01035Shear Web · crackedSTA 194 SHEAR WEB IS CRACKED AT WL 208 RBL 16. REPLACED SHEAR WEB.SDR 2004UALA00270Thrust Reverser · crackedCRACKED HEAT SHIELD. INNER CORE SKIN DELAMINATED & CRACKED FROM FASTENER. CAUSED BY HEAT & VIBRATION. REPLACED INNER SKIN. OVERHAULED & RIGGED.SDR 2002UALA01260Indicator · failedLANDED UNDER AMBER ALERT AFTER FLAPS WOULD NOT DEPLOY. SUPPLEMENTAL DATA UPDATE REMOVED AND REPLACED THE FLAP POSITION INDICATORSDR 2001UALA00771Computer · malfunctionedSTICK SHAKER ACTIVATION ON TAKE-OFF. SUPPLEMENTAL DATA UPDATE REPLACED NR 1 AND NR 2 STALL MANAGEMENT COMPUTERSDR 2000UALA00746Bulkhead · crackedCRACK FOUND ON THE BODY STATION 178 BULKHEAD WEB. SUPPLEMENTAL DATA UPDATE CRACKS REPAIRED PER BOEING SRM 53-10-08.SDR 99UAL900497Light · inopTHE EMERGENCY EGRESS LIGHTS FROM ROW 15 BACK ARE INOPERATIVE. REPLACED THE EMERGENCY EGRESS LIGHTS. OPERATIONS CHECK NORMAL.SDR 98UAL900584Wire · failedFLOOR EEL INOP. REPLACED STRIP AND OPS CHECKED OK.SDR 97UAL900160Compressor Blade · failedAFTER TAKEOFF, NR 1 ENGINE SURGED AND PASSENGERS REPORTED FLAMES COMING FROM TAILPIPE. EGT WAS 900 DEGREES. ENGINE SHUT DOWN AND AIRCRAFT RETURNED TO FIELD. SHUTDOWN CAUSED BY COMPRESSOR STALL DUE TO COMPRESSOR BLADE FAILURE. BLADE FAILURE WAS CAUSED BY ASDR 95UAL900076Eel Cable · failedFIRST CLASS EEL LIGHTING INOP. REPLACED POWER LEADER CABLE FROM INVERTER TO EEL LIGHTING.
Back to N903UA, cancelled Jul 31, 2008