N217UA
Service difficulty reports · 149
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 = 'N217UA' 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 = 'N217UA' 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 CALA2013092591453Cover · damagedNR 1 ENGINE, NR 1 GAP COVER STRIP DAMAGED IN PREVIOUS REPAIR. HEAT SHIELD NR 2 OTBD SIDE .4" SECTION PROTRUDING PAST GAP COVER. NR 1 CONT OF AMIS ITEM 6602008. DRESSED UP PREVIOUS BLEND REPAIR OF NR 1 ENGINE GAP COVER IAW SRM 54-50-70. REMEASURED AT 3.625XSDR CALA2013091091158Controller · failedLT EAI VALVE FAILURE TO THE CLOSED POSITION OR LT EAI CONTROL CARD FAILURE. ADVISORY MSG01- LATCHED DESCENT MODE DEPENDENT; EAI VALVE LT IS FAILED IN CLOSED POSITION. DB- ACIPS CONTROL CARD, LT EAI CARD MSG02- LATCHED DESCENT MODE DEPENDENT; EAI VALVE LT IS SDR CALA2013081990563Thermocouple · faultyTHERMOCOUPLE PROBE LT ENGINE CH "B" SIGNAL IS OUT OF RANGE, MESSAGE 75-50801. REPLACED NR 1 ENGINE TCA THERMOCOUPLE PROBE, TESTED GOOD.SDR CALA2013080790209Sensor · inoperativePREFLIGHT CHECK "PACK R " STATUS MESSAGE DISPLAYED. MAINT MESSAGE 21-22802 ACTIVE, TRIED TO CLEAN PRE HEAT EXCHANGER INLET TEMP SENSOR M21517, NO HELP, REPLACED PRIMARY HEAT EXCHANGER INLET TEMP SENSOR OK.SDR CALA2013080690175Sensor · faultyPRE-FLIGHT CHECK "PACK R " STATUS MESSAGE DISPLAY. REPLACED PRIMARY HEAT EXCHANGER INLET TEMP SENSOR , OK.SDR UALA2013072605262Controller · faulty"PACK R" MESSAGE SHOWS ON STATUS. REPLACED RT CABIN TEMP CONTROLLER IAW MM, OPS CHECKED NORMAL.SDR UALA2013071204880Module · faultyAPU SHUTOFF VALVE SWITCH ON P5 PANEL WAS FOUND TO FAULTY DURING JIC TESTS. WORKS INTERMITTENTLY. REPLACED APU BLEED SWITCH MODULE (PCN 566-1200), OPS CK NORMAL.SDR UALA2013071204879Wire · looseNR 1 IDG TERMINAL BLOCK HAS BLUE PHASE WIRE LOOSE AND HEAT SHRINK IS DIS-COLORED. REPLACED IDG TERMINAL BLOCK IAW MM AND REPLACED INSTALLATION ON FEEDER CABLE IAW SWP 20-00-10.SDR UALA2013062704514Outflow Valve · inoperativeAFT OUTFLOW VALVE INOPERATIVE. MAINT MESSAGE 21-39040. R & R AFT OUTFLOW VALVE IAW AMM, OPS CHECKED OK.SDR UALA2013062404352Switch · failedAFT AUTO CONTROL ON AFT OUTFLOW VALVE FAILED. REPLACED AFT OUTFLOW VALVE SWITCH ACOMPLISHED MAT AND MANUAL TEST, TEST PASSED.SDR UALA2013060703976Display · inoperativeFOUND CAPTAIN SIDE PFD INOPERATIVE, SWAPPED WITH LOWER EICAS DU. REPLACED LOWER EICAS DU IAW AMM.SDR UALA2013052903736Shutoff Valve · failedFAILURE OF AFT CARGO HEAT SHUTOFF VALVE OR TEMP CONTROL VALVE. STATUS MESSAGE 2112031, INACTIVE ER MODE MESSAGE 2112031, LATCHED ER MODE. R & R TEMP CONTROL SHUTOFF VALVE IAW MM, OPS CHECKED NORMAL.SDR UALA2013040302169Oxygen Mask · defectiveCAPT O2 MIC INOPERATIVE. REPLACED CAPTAIN O2 MASK, SYS OPS CHECKS NORMAL.SDR UALA2013022801208Anti-Ice Valve · faultyRT EAI VLV FAILURE, FLT DIVERTED. REPLACED BOTH ENGINE ANTI-ICE VALVE AND CONTROLLER, OPS CKS GOOD.SDR UALA2013011600267Module · faultyCABIN SYSTEMS CONTROL PANEL AT 1L UNABLE TO CONTROL TEMP OR LIGHTS. CSCP L1 GIVING INVALID DATA L2 CACP WORKING & CONTROLLING THE LIGHT NORMAL. REPLACED ZMU1, ALL LIGHTS CONTROLLABLE.SDR UALA2012121907306Pin · dirtyNOSE WHEELS MOVE TO RIGHT WHEN STEERING BY PASS PIN INSTALLED. REMOVED COVER FOR STEERING NOSE. CLEANED AREA, OPS OK.SDR UALA2012111906685Door · out of adjustUPON ARRIVAL AT GATE, FOUND EXTERNAL POWER DOOR FWD EDGE PROTUDING INTO AIRSTREAM. ADJUSTED EXT POWER DOOR. OPS CHECKED OK FOR SERVICE.SDR UALA2012101105784Generator · failedAPU GENERATOR FAILED AT GATE. REPLACED APU GENERATOR PER MM, OPS CHECKED GOOD.SDR UALA2012092705454Warning System · false activationEICAS MESSAGE DETECTOR FAN 1 CARGO FORWARD SHOWED AT DEP. MAINT MESSAGE 26-21041 MAT TEST FAIL PER FIM 26-16 TASK 803. MSG DET FAN 1 CGO FWD NOT DISPLAYED ON EICAS, NO EXISTING OR INBD FLIGHT FAULTS. ACCOMPLISHED GROUND TEST 26 CARGO SMOKE DET SYS TEST PER SDR UALA2012082004629Hinge · brokenDOOR FOR COMPARTMENT AT LOCATION 502 MISSING. REMOVED BROKEN HINGE. REPLACED THE BROKEN HINGE, OPS CHECKED OKAY.SDR UALA2012080804299Panel · damagedRIGHT ENGINE INBOARD AFT PYLON PANEL HAD HINGE PINS REMOVED SO WHEN IT WAS OPEN PANEL FELL TO FLOOR DAMAGING CORNERS OF PANEL. APPLIED REPAIR PLIES TO OUTER SIDE. WHEN CURE IS COMPLETE, WILL NEED FILLER PLIES AND LAY UP ON INNER SIDE, REF SRM 54-50-70 REPAIRSDR UALA2012040602140Window · binding1ST OFF EMERGENCY ESCAPE WINDOW DOES NOT OPERATE WITHOUT BINDING. REPLACED WINDOW.SDR UALA2012040202016Module · faultySEATS 9C AND 9D POWER TURNED OFF UNDER SEAT FROM ELEC ODOR AT BASE OF SEATS. ON ARRIVAL, NO ODOR FOUND. FOUND J2 CONX ON RD-KM6453-0808 BURNT AND P2 CONX ON RD-KM6480-2323 BURNT, REMOVED AND REPLACED BOTH PAC CABLES AND PAC SPM RD-FA3621-01 SN ON 34370 SN SDR UALA2012022901254Window · crazedWINDOW (FLIGHT DECK) - SHOWS SIGNS OF DAMAGE. CREW COMMENTS: R2 WINDOW VISION IMPAIRED BY CRAZING IN SUNLIGHT. REMOVED R2 WINDOW PER MM. ORDER NEW WINDOW WITH OSTF G6680. REPLACED FLT DECK WINDOW R2 PER MM. PRESSURIZED FOR OPS CHECK, PASSED.SDR UALA2012022001012Fuel Nozzle · malfunctionedNR 1 ENGINE FUEL NOZZLES MALFUNCTIONED.SDR UALA2012012700564Exciter · faultyLEFT ENGINE FIRST START ABORTED, SECOND START OKAY. MAINT MSG IS 74-61501 'IGNITION SYSTEM NR 2 (L ENG) FAILED TO LIGHT ENGINE' REF FIM 74- 11 TASK 816. ECM DATA SHOWS LIGHT OFF TIMES SLOWER SINCE IGN2 (LOWER) EXCITER AND CABLE WERE PREV RPL 08DEC. IF FIM FINSDR UALA2012012700563Relay · faultyL ENG VERY SLOW TO START. DEFERRED PER SAMC. RPLC'D THE ERU PER MM, SYSTEM TESTED GOOD. TWO STARTS NO PROBLEM. CHECKED WIRING TO ERU FOUND TO BE OK.SDR UALA2012011900413Sense Line · leakingREF EG6537-1 FOUND HOLE IN LINE. ACP'D MM. FOUND SENSE LINE LEAKING. REMOVED LINE AND LEAK CHECKED ALL OTHER LINES IN 4.95 EPR SYSTEM. ALL OTHER LINES LEAK CHECK OKAY. CLAMPS ON AOG FOR REPLACEMENT LINE. REPLACED SENSE LINE, LEAK CHK GOOD. RAN ENG PER JSDR UALA2012011100239Strip · damagedNR 1 ENGINE GAP STRIP DAMAGED. DAMAGE EXTENDED 1.7813 LONG BY .218 DEEP. TOTAL 4.843 DAMAGE LONG. ACCOMPLISHED HFEC INSPECTION PER MT54-UA2, NO CRACK NOTED. ACCOMPLISHED ECRA 5454-01 032.SDR UALA2011102405710Wire · chafedFIRE LOOP MESSAGE. NR 1 ENGINE FIRE DETECTOR HARNESS W656, WIRES CHAFED ON RT SIDE OF ENGINE ALONG FWD EDGE HYD HOSE SHIELD. INSTALLED HARNESS.SDR UALA2011101705610Control Panel · inoperativeCABIN CONTROL SCREEN HAS LAV SVC-WATER SAYS INVALID DATA. CACP L1 DOOR INOPERATIVE, CACP OK AT 2L. ADJUSTED L1 DOOR CSCP, OPS CHECKED NORMAL.SDR UALA2011090504766Oven · inoperativeCABIN CREW REPORTED OVEN 53 INOPERATIVE. REPLACED R53 OVEN ASSY.SDR UALA2011083004649Slide · brokenBROKEN PAN SLIDER ASSY. REPLACED 330 SLIDER ASSY IN ECONOMY CABIN, REF IPC. ALL SEATS OP CK GOOD.SDR UALA2011072203732Satcom · failed"SATCOM SYS" STATUS MSG. REPLACED SATCOM RADIO FREQUENCY MODEL UNIT. INSTALLATION TEST PASSED.SDR UALA2011072103698Cooling Fan · damagedCREW REPORTED FAINT SMELL OF BURNING CABIN WITH HIGH VIBRATION. RIGHT PACK SHOWED ABNORMAL HIGH TEMPERATURE INDICATION. CAPTAIN EXERCISED EMERGENCY AUTHORITY AND SHUTDOWN RIGHT PACK. VIBRATION STOPPED AFTER PACK SHUTDOWN. PATCH WITH SAMC CONDUCTED. NO RESSDR UALA2011071103453Plate · missingSTRIKE PLATE ON CREW REST AREA MISSING FROM HALL FLOOR LOCATION. REPLACED PLATE.SDR UALA2011062203060Pad · crackedNR 1 ENGINE LT REVERSER HALF UPPER FWD COMPRESSION PAD IS CRACKED. REPLACED NR 1 ENGINE LT REVERSER HALF UPPER COMPRESSION PAD.SDR UALA2011033001532Battery Pack · dischargedEMERGENCY PATH LIGHTING INOP AROUND LEFT SIDE MID-CABIN COACH LAVATORIES. REPLACED ASSOCIATED BATTERY PACK AND CHARGER. OPS GOOD.SDR UALA2011033001531Battery Pack · dischargedEMERGENCY LIGHTS INOP IN THE LEFT AISLE CEILING PANELS FROM ROW 17 TO ROW 33. REPLACED ASSOCIATED BATTERY PACK. OPS GOOD.SDR UALA2011033001530Battery Pack · dischargedINTERNAL EMERGENCY LIGHTS INOP AT DOOR 3L ON THE FWD AND AFT SIDES OF DOOR. REPLACED ASSOCIATED BATTERY PACK. OPS GOOD.SDR UALA2011033001529Battery Pack · dischargedEXTERNAL EMERGENCY LIGHTS INOP AT DOORS 1L, 3L AND 4L. REPLACED ASSOCIATED BATTERY PACK, OPS GOOD.SDR UALA2011033001528Connector · unsecureEMERGENCY PATH LIGHT INOP AT SEAT 3E, AFT LIGHT. SECURED CONNECTOR. OPS GOOD.SDR UALA2011033001527Light · inoperativeEMERGENCY PATH LIGHT INOP AT SEAT 42D. REPLACED LIGHT AT SEAT. OPS GOOD.SDR UALA2011033001526Battery Pack · dischargedINTERNAL EMERGENCY LIGHTS INOP AT DOOR 2L ON THE TOP AND FWD SIDE OF DOOR. REPLACED ASSOCIATED BATTERY PACK. OPS GOOD.SDR UALA2011022100884Valve · faultyPACK R2 AND TIME UNABLE TO RESET. RT PACK TEMP HIGH CAUSING PACK TRIP OFF. ACCOMPLISHED TROUBLESHOOTING IAW MAINT MSG, SWAPPED RT LOW LIMIT VALVE WITH RT TURBINE BYPASS VALVE IN ORDER TO DISPATCH USING MEL2152AE. REPLACED RT LOW LIMIT VALVE. SWAPPED TURBINESDR UALA2010123004775Unknown · odorBURNING PLASTIC ODOR IN FLIGHT DECK. ACCOMPLISHED CHECK OF CAPT AND F/O SHOULDER HEATERS. ACCOMPLISHED FLT DECK CHECK OF LIGHTS, SWITCHES, PANELS AND WINDOWS. ACCOMPLISHED INTERNAL VISUAL CHECK OF SHOULDER HEATER ELEMENTS. NO ABNORMALITIES DETECTED. ACCOMSDR UALA2010122704731Precooler · damagedDURING WALK AROUND CK AFTER ACFT ARRIVAL FOUND PRECOOLER OF RT ENG SQUEALING AND MAKING LOUD NOISE. OPENED R ENG FAN COWL AND THRUST REVERSER COWL FOUND PARTIAL OF THE PRECOOLER OUTLET SCREEN ON THE TOP POSITION WAS DAMAGED. THE LENGTH OF THE CRACK IS ABOUT SDR UALA2010122104665Controller · faultyTROUBLE SHOOTING RT PACK MSG 21-23004. AHM PROGRAM IS DETECTING REPEAT FAULT MSG 21-23004 FOR RT PACK DIFFERENTIAL PRESSURE MISCOMPARE FAULT. RT PACK UPPER FCV AND FLOW SENSOR MODULE PREVIOUSLY REPLACED. NEED TO REPLACE THE RT CABIN TEMP CONTROLLER CTC-R (M2SDR UALA2010122104664Control Valve · faultyRT PACK FLOW CONTROL VALVE ON STATUS PACK OFF. ON STATUS RESET TWICE, NO HELP. UPPER VALVE INOP. REPLACED RT PACK UPPER FLOW CONTROL VALVE NOT IN COMMANDED POSITION, LOWER FLOW CONT VALVE CYCLING. REPLACED UPPER FLOW CONTROL VALVE AND FLOW SENSE MODULE. PACSDR UALA2010092203519Actuator · leakingNR1 ENGINE VARIABLE STATOR VANE ACTUATOR IS LEAKING. 20-25 DROPS PER MINUTE STATISTICALLY. NR1 ENGINE SVA REF MM, NO LEAKS.
Back to N217UA