N818UA
Service difficulty reports · 112
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 = 'N818UA' 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 = 'N818UA' 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 UALA2013040902381Unknown · missing2L MISSING PLASTIC FROM ARMING WINDOW. CANNOT FIND IT. REPLACED MISSING WINDOW.SDR UALA2013032501845Latch · faultyCOCKPIT DOOR DOES NOT LOCK WITH SWITCH SET TO 'NORM'. TOP LATCH IS NOT LOCKED. CAN MANUALLY PULL IT BACK. NO STRIKE OR FAULT LIGHTS ILLUMINATE. ADJUSTED UPPER COCKPIT DOOR LATCH, OPS GOOD.SDR UALA2013020100607Bracket · missingCOCKPIT CRASH AX IS MISSING ONE SADDLE BRACKET. REPLACED MISSING BRACKET.SDR UALA2012071803876Blade · damagedNR 2 ENGINE BLADE DAMAGE DUE TO BIRD STRIKE. BEGAN REMOVAL OF FAN BLADE IAW REF AMM. CONTINUE INSTALLATION OF OF FAN BLADES I,A,W REF AMM. NEED TO CON, FROM ITEM-7 THRU END. INSTALLED ENTIRE SET OF BLADES REF, V2500 FAN BLADE DISTRIBUTION PROGRAM FOR WINDOSDR UALA2012062903460Light · inoperativeDURING EMERGENCY LIGHTS TEST EPSU INT LOAD EMERGENCY LIGHT MSG. AISLE LIGHTS AT SEATS 22A BC & 23ABC INOP. EPSU TEST GIVES UNIT FAULT.SDR UALA2012062903458Unknown · malfunctionedDURING EMERGENCY LIGHT TEST EPSU EXT LOAD EMERGENCY LIGHT MSG. WHEN TESTING 11WL EPSU BOTH INT AND EXT LIGHT FAULT FLASH. TRIED NEW EPSU NO HELP ORIGINAL EPSU IS INSTALLED.SDR UALA2012051602773Control Unit · malfunctionedLGCIU NR 1 FAULT ON UPPER ECAM. RESET LGCIU SYSTEM 1 GND SUPPLY AND SYSTEM 1 CB. BITE TEST SHOWS NO FAULTS. OK TO CONTINUE.SDR UALA2012043002533Slide · faultyDURING EMERGENCY LIGHT TEST RECEIVED MESSAGES EPSU INT LOAD EMERGENCY L AND EPSU EXT LOAD EMERGENCY. REPLACED DOOR 1 RIGHT SLIDE PER MM 2562-44 PG 401. OPS OK REMOVED ALL LOCK OUTS AND SAFETY AND SOLD INSTALLATION TO INSPECTION.SDR UALA2012042402461Solenoid · malfunctionedNR 2 ENG SURGE, RTFL. FOUND 7TH STAGE BLEED VALVE SOLENOID FAILED TEST. REPLACED 7B SOLENOID REF AMM. RAN NR 2 ENG TO 80% N1 MULTIPLE TIMES WITH NO SURGING OR SHIFTING OF PARAMETERS REF JRH. REPLACED FCU PER MM, CHECKED GOOD.SDR UALA2011110205942Seat Belt · damagedFWD LEFT F/A JUMPSEAT SHOULDER HARNESS MISSING ADJUSTMENT TAB. REPLACED INOPERATIVE FWD SEAT BELT HARNESS. CHECKED GOOD.SDR UALA2011102705815Galley Mat · damagedAFT GALLEY FLOOR MAT DAMAGED. COMPLETED MOISTURE BARRIER AND MAT INSTALLATION. PER AMM.SDR UALA2011101905672Oxygen Mask · inoperativeCAPTAIN'S O2 MASK MIC INOPERATIVE. REPLACED MASK ASSY.SDR UALA2011090904881Slide · unserviceableON WALK AROUND FOUND LEFT OVER WING SLIDE STICKING OUT (NOT FAIRED) APPROX 1-2 INCH. 2 OF THE 3 LOCKING-STOW PINS APPEAR TO BE UNDONE-PULLED THRU. REPLACED SLIDE ASSY.SDR UALA2011081104210Wire · damagedEEL LIGHT AT SEATS 12C AND 32C INOP. REPAIRED WIRING AT BOTH LIGHT ASSEMBLIES.SDR UALA2011080804161Sliding Window · faulty2R WINDOW HEAT ISSUE. FO'S SLIDING WINDOW REMOVED FROM ACFT AND SLIDING WINDOW PANEL REMOVED FROM FRAME. REPLACED FO'S SLIDING WINDOW PANEL AND INSTALLED SLIDING WINDOW PER MM. COMPLETED INSTALLATION PER MM STEP 5A TO COMPLETION.SDR UALA2011070503332Oxygen Mask · faulty1ST O/B'S OXYGEN MASK MICROPHONE IS INOPERATIVE. REPLACED O2 MASK AND BOX STOWAGE AT FIRST OFFICER SIDE, TESTS OKAY. O2 MASK REPLACED PER AMM. TEST OKAY.SDR UALA2010110304071Converter · false activationCAPT'S WINDSHIELD WIPER FAILED AGAIN. ACFT REMOVED FROM CAT II AND CAT III SERVICE. NEEDS WIPER MOTOR. REPLACED WIPER MOTOR. MOTOR WORKED ONCE THEN STOPPED. REPLACED WIPER MOTOR SWITCH, SAME CONDITION. MOTOR WORKED ONCE THEN STOPPED. POSSIBLE WIRING OR SDR UALA2010080902872Controller · faultyCAPTAIN'S SLIDING WINDOW HEATING INOPERATIVE. CHECKED WINDOW RESISTANCE GOOD. REPLACED WHC1 (2DG1) IAW MM. MESSAGE CLEARED AND BITE TEST GOOD.SDR UALA2010072002599Static Inverter · overheatedCREW REPORTED THAT WHEN THEY GOT TO THE ACFT TO DO THEIR PREFLIGHT THE COCKPIT WAS FULL OF SMOKE. STATIC INVERTER APPEARS OVERHEATED, NOISY. REPLACED STATIC INVERTER. TESTED NORMALLY, NO EVIDENCE OF HEAT DAMAGE IN AREA.SDR UALA2010062402237Sleeve · crackedNR1 PYLON FWD ATTACHMENT INBD UPR SLEEVE CRACKED. INSTALLED NEW NR1 PYLON FWD INBD UPR SLEEVE.SDR UALA2010062402236Bearing · corrodedNR 1 PYLON SPIGOT BEARING CORRODED. INSTALLED NEW NR1 PYLON SPIGOT BEARING.SDR UALA2010062302218Sleeve · crackedNUMBER 1 PYLON AFT ATTACHMENT CENTER FITTING HAS CRACKED SLEEVE. RMV'D CRACK SLEEVE. INSTALLED NEW NR 1 ENG PYLON AFT SHACKLE CENTER PIN ASSY.SDR UALA2010062302223Sleeve · crackedRIGHT PYLON OUTBOARD UPPER SLEEVE CRACKED. REMOVED CRACK SLEEVE. INSTALLED NEW NR 2 PYLON FWD OUTBOARD UPPER SLEEVE.SDR UALA2010062302222Bearing · corrodedNR2 PYLON SPIGOT BALL JOINT SPHERICAL BEARING HAS PITTING CORROSION. INSTALLED NEW NR 2 PYLON SPIGOT BALL JOINT BEARING.SDR UALA2010062302221Sleeve · crackedNR 2 ENG PYLON AFT MOUNT LWR INBD SLEEVE CRACKED. REMOVED CRACKED SLEEVE PIN. INSTALLED NEW NR 2 PYLON AFT SHACKLE LWR INBD SLEEVE PIN.SDR UALA2010062302220Sleeve · crackedNR 1 PYLON AFT ATTACHMENT INBD FITTING SLEEVE CRACKED. REMOVED CRACKED SLEEVE. INSTALLED NEW NR 1 ENG PYLON AFT SHACKLE INBD PIN ASSY.SDR UALA2010062302219Sleeve · crackedNR 1 PYLON AFT ATTACHMENT OTBD FITTING SLEEVE CRACKED. REMOVED CRACKED SLEEVE. INSTALLED NEW NR 1 ENG PYLON AFT SHACKLE OTBD PIN ASSY.SDR UALA2010062302217Sleeve · crackedNR 2 PYLON FWD MOUNT LWR INBD SHACKLE SLEEVE HAS A CRACK AROUND SHANK HEAD AREA. INSTALLED NEW FWD LWR INBD SLEEVE.SDR UALA2010062302215Sleeve · crackedNR 2 PYLON FWD MOUNT UPPER INBD SHACKLE SLEEVE HAS A CRACK AROUND THE SHANK HEAD AREA. INSTALLED NEW SHACKLE SLEEVE.SDR UALA2010051701655Oxygen Mask · weakF/O O2 MASK VERY WEAK OXYGEN FLOW. REPLACED F/O O2 MASK. OXYGEN BOX CHECKS OK.SDR UALA2010010400051Fan · failedCONTINUED LOUD HUMMING NOISE IN COCKPIT WITH SUBSEQUENT ELECTRICAL ODOR. AVIONICS EXTRACT FAN FAULT DISPLAYED, NOISE STOPPED. REPLACED AVIONICS EXTRACT FAN. AEVC OPS CHECK NORMAL. NO FAULTS NOTED, ALL ECAM CLEAR. SMOKE ODOR HAS DISSIPATED.SDR UALA2009092102980Wire Harness · damagedEMERGENCY LIGHTS OUT AT SEATS 15 & 16. FOUND SIDE WALL CONNECTOR APART AND WIRE PULLED OUT. REPLACED WALL TO SEAT HARNESS, OPS CHECK NORMAL. NO DEFECTS NOTED.SDR UALA2009082802692Bottle · low pressureMED 1R, DOOR ASSIST BOTTLE PRESSURE BELOW LIMITS. SERVICED AS REQUIRED.SDR UALA2009072402205Slide · unserviceableREPLACE NR 1 RT DOOR SLIDE ACCT CONNECTOR LACING CORD IS UNSERVICEABLE. REMOVED & REPLACED NR 1 RT DOOR SLIDE.SDR UALA2009071602102Shutoff Valve · failedPACK 1 AND 2 FAULTS, RTFL. REPLACED HPV DUE TO LEAK AND REPAIRED LEAK OF CLOSURE SOLENOID LINE. NEW NR 2 ENG HPSOV WILL NOT CLOSE COMPLETELY. BUTTERFLY VALVE BINDS SO ECAM BLEED SHOWS OPEN POSITION ALL THE TIME. REPLACED VALVE AND FLEXIBLE HOSE. ENG 2 RUNSDR UALA2008111306202Wire · damagedCABIN EMERGENCY LIGHTS AT SEAT 10 ABC NOT ILLUMINATING. REPAIRED WIRE, TESTS OKAY.SDR 2008UALA06225Girt Bar · out of rigPRESSURE CHECK DOOR 2R FOR LEAKS AND MIGRATION OF SLIDE ARMED HANDLE, ACCOUNT OF SCUFF PLATES REPLACED AND GIRT BAR RIGGED. PRESSURE CHECKED DOOR AT 4 LBS, DOOR ARMED HANDLE GOOD, NO DOOR LEAKS.SDR 2008UALA06202Wire · damagedCABIN EMERGENCY LIGHTS AT SEAT 10 ABC NOT ILLUMINATING. REPAIRED WIRE, TESTS OKAY.SDR 2008UALA06221Floorbeam · corrodedBEAM 140 CORRODED. REMOVED FLOORBEAM 140. TRANSFERRING FASTENER HOLES TO NEW BEAM. INSTALLING FASTENERS IN NEW BEAM. INSTALLED BEAM 140.SDR UALA2008111306217Floorbeam · corrodedBEAM 95 CORRODED. REMOVED FLOORBEAM 95. REMOVED BRACKETS AND DRILLED NEW BEAM. ALL BRACKETS AND ATTACH FITTINGS INSTALLED. BEAM INSTALLED, ATTACHMENT COMPLETE AT FRAME 64, NEEDS BOLTS AT FRAME 66 AND 65. COMPLETED INSTALLATION OF BEAM.SDR 2008UALA06217Floorbeam · corrodedBEAM 95 CORRODED. REMOVED FLOORBEAM 95. REMOVED BRACKETS AND DRILLED NEW BEAM. ALL BRACKETS AND ATTACH FITTINGS INSTALLED. BEAM INSTALLED, ATTACHMENT COMPLETE AT FRAME 64, NEEDS BOLTS AT FRAME 66 AND 65. COMPLETED INSTALLATION OF BEAM.SDR 2008UALA05991Attach Fitting · corrodedEVIDENCE OF CORROSION AROUND FWD GIRT BAR ATTACH FITTING DOOR 2R. INSTALLED CORNER FITTINGS AND GIRT BAR HOOK MOUNT PLATES ON NEW DOOR SILL.SDR 2008UALA05978Beam · corrodedCORROSION IN AREA OF PREVIOUS REPAIR BEAM 190. REMOVED CORROSION. INSPECTED REPAIR PER MT53- 025, FOUND SERVICEABLE.
SDR 2008UALA05977Structure · corrodedCORROSION AROUND NUT PLATE HOLES INBOARD OF AFT GIRT BAR FITTING DOOR 2L. REMOVED CORROSION PER MT 53-025. INSPECTED REPAIR PER MT53- 025. FOUND SERVICEABLE.
SDR 2008UALA05963Floorbeam · corrodedBEAM 150 CORRODED. REMOVED FLOORBEAM 150. REMOVED BRACKETS AND DRILLED NEW BEAM AND READY FOR BRACKET INSTALL ON NEW BEAM. INSTALLED BEAM, NEEDS 2 BOLTS AT STA 70, 8 BOLTS AT STA 68. COMPLETED INSTALLATION OF BEAM. INSPECTED FINAL INSTALLATION OF BEAM 150SDR 2008UALA05962Shear Plate · corrodedSHEAR PLATE AFT OF DOOR 2R BETWEEN FRAME 69 AND FRAME 70 CORRODED. REMOVED SHEAR PLATE AFT OF DOOR 2R. REPLACED WITH NEW SHEAR PLATE AFT OF DOOR 2R. INSPECTED THE INSTALLATION OF THE SHEAR PLATE AND FOUND SECURE.
SDR 2008UALA05961Floorbeam · corrodedBEAM 95 CORRODED. REMOVED FLOORBEAM 95. REMOVED BRACKETS AND DRILLED NEW BEAM AND READY FOR BRACKET INSTALL. ALL BRACKETS AND ATTACH FITTINGS INSTALLED AND READY FOR INSTALLATION INTO AC. BEAM INSTALLED, ATTACHMENT COMPLETE AT FRAME 64, NEEDS BOLTS AT FRAMSDR 2008UALA05960Floorbeam · corrodedBEAM 80 CORRODED. REMOVED FLOORBEAM 80. TRANSFERRING FASTENER HOLES TO NEW BEAM. INSTALLED BEAM.SDR 2008UALA05959Floorbeam · corrodedBEAM 140 CORRODED. REMOVED FLOORBEAM 140. TRANSFERRING FASTENER HOLES TO NEW BEAM. INSTALLING FASTENERS IN NEW BEAM. INSTALLED BEAM.SDR 2008UALA05958Floorbeam · corrodedBEAM 145 CORRODED. REMOVED FLOORBEAM 145. TRANSFERRING FASTENER HOLES TO NEW BEAM. INSTALLING FASTENERS IN NEW BEAM. INSTALLED NEW BEAM.
Back to N818UA