N467UA
Service difficulty reports · 127
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 = 'N467UA' 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 = 'N467UA' 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 CALA2021070701039Screw · missingPDA 3 FOUND 1 SCREW MISSING RIGHT WING PANEL 674BB TOMC BROADSTONE NOTIFIED. PICTURE ADDED ADDED 2 MORE PICTURES, MISSING SCREW NUTPLATE STRIPPED BUT BEHIND WALL. REPLACED SCREW AS REQ REF IPC 57-51-05-34M OK TO CONTINUESDR CALA2021051700661Door Frame · crackedFOUND R/H FR68, DOOR STOP FITTING #1, LOWER I/B HOLE CRACKED IN AREA 2 DURING THE ACCOMPLISHMENT OF EA5340-01724 OPS 002, REV C. REF PEMCO NR.10814.0244 OVERSIZED THE #1 DOOR STOP FITTING LWR I/B HOLE D1 AT R/H FR68 CONCENTRICALLY TO .3890(AREA 2), OVERSIZED HSDR CALA20190821386Stringer · corrodedAFT CARGO STR 41R CORRODED FROM 61.5-58 REMOVED DAMAGED SECTION OF STR 41R FR 56-FR61 IAW A320 SRM 53-00 -13-300-002. FABRICATED AND INSTALLED REPAIR COMPONENTS/PARTS IA W A320 SRM 53-00-13-300-002 AND 51-72-11-911-002 ADD EMP:V890622SDR CALA20190821385Cleat · corrodedA3NB-05-3-6023, A27-052, AFT CARGO FR60 CLEAT CORRODED STR 44-41 L QTY 3 CLEATS CORRODED. REMOVED 3 CLEATS FR60 STR 44-41L. (2) CLEATS FR60 STR 44-42L WER E CORRODED. (1) CLEAT 42L-41L DAMAGE LIMITED TO SURFACE PROTECTI ON ONLY. IAW SRM A320 51-42-11-801, IAW SDR CALA20190821384Floorbeam · bentA3NB-05-3-6023, A27-048, FR61 FLOOR SUPPORT BEAM BENT FROM STR 3 8L TO 44 REMOVED FLOOR BEAM SUPPORT IAW A320 SRM 51-72-11-911-001, FABRIC ATED NEW SUPPORT PER MFG DRAWING NO. 17D53470382. HEAT TREATED I AW A320 SRM 51-25-00-801. HARNESS TESTED IAW A320 SRM 51SDR CALA20190821383Cleat · corrodedAFT CARGO FR61 CLEAT CORRODED STR 44-43 R REMOVED CORRODED CLEAT AND REPLACED CLEAT(NEW) AFT CARGO FR61 ST R 44-43R IAW SRM A320 51-42-11-80100. RESTORED SURFACE PROTECTIO N TO CLEAT AND RIVETS FR61 STR 44-43R IAW SRM A320 51-75-12-911- 001 AND IAW ER 5100R010SDR CALA20190821382Skin · damagedSEVERAL FUZZY FASTENER HEADS AT FR 67-69.5 STR 3L-3R. REPLACED DAMAGED FASTENERS AND REPAIRED CORROSION FOUND UNDER FA STENERS IAW ECRA 5341-01181 REV-A. CREATE DIP TO READ ACCOMPLISH THE PERMANENT REPAIR AT THE FUSELAGE SKIN FR66-70 STR 3L-3R.. ..AS PER PART SDR CALA20190821381Skin · corrodedSKIN HAS CORROSION UNDER BONDING STRAPS AT FR69.5 STR 2L-1L. REPAIRED CORROSION ON SKIN UNDER BONDING STRAPS AT FR69.5 STGR 1-2L IAW ECRA 5341-01181 REV A. CREATE A DTA DIP LOG PAGE TO REA D "ACCOMPLISH THE PERMANENT REPAIR AT FUSELAGE SKIN FR66-70... ..STR 3LSDR CALA2019081601371Skin · corrodedSKIN HAS CORROSION UNDER BONDING STRAPS AT FR 69.5 STGR 1R-2R. REPAIRED CORROSION ON SKIN UNDER BONDING STARPS AT FR 69.5 STGR 1-2R IAW ECRA 5341-01181 REV. A. CREATED A DTA DIP LOG PAGE TO R EAD "ACCOMPLISH THE PERMANENT REPAIR AT THE FUSELAGE SKIN FR66.. ..-SDR CALA2019081201354Stringer · corrodedAFT CARGO STR 40L C ORREDED FROM FR 59-56 REMOVED AND REPLACED STR 40L FR53 TO FR60 IAW A320 SRM 51-72-11 AND A320 SRM 51-42-11. RE-INSTALLED CLEATS AT STR 40L TO FR60 IA W SRM 51-72-11 AND A320 SRM 51-42-11. PRIMED AND TOPCOATED IAW A 320 SRM 51-75-12-911-001SDR CALA2019081201353Stringer · corrodedAFT CARGO STR 43L CORRODED FROM FR60-58 REMOVED AND REPLACED STR 43L FR 54 TO FR60 IAW A320 SRM 51-72-11 -911-001 AND A320 SRM 51-42-11-001. REINSTALLED CLEATS STR 43L-4 2L FR54-FR60 IAW A320 SRM 51-72-11-911-001 AND A320-SRM 51-42-11 -001. PRIMED AND TOP COATSDR CALA2019080501314Bulkhead · crackedCRACK INDICATIONS NOTED OUTSIDE THE CUTOUT AREA AT FR35 LT SIDE, HOLES 3, 4 & 20. REPAIRED THE PRESSURE PANEL HOLES IAW ECRA 5331-02417 REV. A,SDR CALA2018110502306Power Supply · inoperativeFOUND EPSU 11WL BAD. REPLACED EPSU IAW AMM 33-51-38-400-001A. ROTABLE PARTS CHANGE WAS INDICATED - TT # 1103608 SN OFF 2897 POWER SUPPLY, C OFF 31-3350-9-9001 2897 ON 31-3350-9-9001 5406 PART UPDATE ONLY ROTABLE PARTS CHANGE WAS INDICATED - TT # 1810908 SN SDR CALA2017112704238Container · damagedLT OFF WING SLIDE CONTAINER DELAM AND CRACKED. REMOVED AND REPLACED LT OFF WING SLIDE CONTAINER.SDR CALA2017112704237Container · damagedRT OFF WING SLIDE CONTAINER DELAM AND CRACKED. REMOVED AND REPLACED RT OFF WING SLIDE CONTAINER.SDR CALA2017112704236Case · crackedR1 DOOR EMERGENCY SLIDE CASE CRACKED. PROCURED NEW DOOR SLIDE RI DOOR TO BE INSTALLED ON CARD NR 18-2 562-1-2307/2067.SDR CALA2017112504209Door Sill · corrodedL2 DOOR SILL HAS CORROSION AROUND FASTENER HOLE AT FR68. REMOVED AND REPLACED L2 DOOR SILL IAW SRM 51-42-11-001.SDR CALA2017112504208Door Sill · corrodedR2 DOOR SILL HAS CORROSION AROUND FASTENERS HOLES 5 FWD OF FR68. REMOVED AND REPLACED R2 DOOR SILL IAW SRM 51-72-11-911-001.SDR CALA2017112104175Support · corrodedAFT CABIN SHEAR WEB SUPPORT CORRODED JUST FWD OF FRAME 70. REMOVED AND REPLACED THE SHEAR WEB SUPPORT IAW SRM 51-42-11-001, PAR F4, & F2.SDR CALA2017020300265Power Supply · faultyEMERGENCY LIGHT TEST FAILS. REPLACED BATTERY AND POWER SUPPLY IAW AMM 33-51-38, REF AMM 33-5 1-39. LIGHTS FUNCTIONED NORMAL.SDR CALA2016042695303Battery · dischargedEMERGENCY LIGHT TEST FAILURE. EPSU BATTERY EMER RT. ACCOMPLISHED TSM TASK 33- 51-00-810-801-A. REPLACED EPSU BATTERY 12WL IAW AMM TASK 33-51-3 8.SDR CALA2014092292272Epsu · failed2 SERVICE EMER LIGHT TEST FAILED. REPLACED 12WL EPSU & BATTERY IAW MM 33-51-38.SDR CALA2014082692019Structure · damagedDAMAGE TO ACFT, BELOW AFT LOWER CORNER OF DOOR 2L. DAMAGE IS APPROX 9 INCHES LONG & 2 INCHES WIDE BURNISH AREA IAW SRM 53-41 -11. WILL REQUIRE REPETITIVE INSPECTION IAW SR I53-41-11, TABLE 10 4, BLOCK SSI53-41-31. MUST BE ACCOMPLISHED WITHIN 23,800 FC OR 4SDR CALA2014022590476Unknown · malfunctionedINITIAL APU START WAS SLOW WITH LP FUEL VLV FAULT, FAULT CLEARED. DUCT PRESS RECOVERED, ENG STARTS NORMAL, SYS RECOVERED. OPERATIONS NORMAL, OK TO CONTINUE.SDR CALA2013121393674Regulator Valve · faultyAFT CARGO HEAT TEMP ONLY 58F WITH TEMP SEL ON FULL HOT. NO ECAM MSGS OR AMBER IND. REPLACED PRESS REG VLV & TRIM AIR VLV.SDR CALA2013112593214Tape · looseANTI EROSION TAPE IS COMING OFF IN 4 PLACES ON VERTICAL TAIL. TRIMMED LOOSE EROSION TAPE IAW MT 55-003.SDR CALA2013111892982Hydraulic Line · leakingG RESERVOIR LOW LEVEL DISPLAYED ON UPPER ECAM SCREEN, HYD. LOSS OF ALL GREEN FLUID. PTU & GREEN HYD PUMP COMMANDED OFF WITHIN 30 SECONDS OF ECAM INSTRUCTIONS. REPLACED LEAKING LINE.SDR CALA2013081290355Fastener · looseRAMP REPORTED LOOSE FASTENER ON LT VERTICAL STABILIZER. SECURED FASTENER.SDR CALA2013081290330Computer · faultyF-CTL ELAC 2 FAULT. ELAC 2 SHOWED AS WARNING ON AIRMAN-WEB WITH ELAC 2 FAILURE MESSAGE, RESET NO HELP. SWAPPED NR 1 AND NR 2 ELAC COMPUTERS AND FAULT FOLLOWED, NR 2 TEST OK. NR 1 ELAC NOW INOP AND COMPLIED WITH MEL 2793A.SDR UALA2013071705005Oxygen Mask · unsecureFWD F/A OXYGEN MASK COMPARTMENT DOOR OPENED ON TAXI OUT AND MASKS HANGING DOWN. ACCOMPLISHED SAT. MASK DROP TEST IAW MM 35-23-00-710-001-A. OPS CHECKED OK.SDR UALA2013071604987Oxygen Mask · unwanted deployOXYGEN MASKS DROPPED ROW 7DEF. REPACKED MASKS IAW AMM. PERFORMED OPS CHECK OF MANUAL MASK RELEASE IAW AMM, OPS CHECKED GOOD.SDR UALA2013070104581Proximity Sensor · failedMULTIPLE ECAM FAULTS AFTER A-C ARRIVAL. SWINGS REPORTED FAULTS OCCURED DURING POWER SWAP? ECAM FAULTS. LG CUI 2, REVERSER 2, MAIN GALLEY SHED, MAINT MESSAGE ENG 2 EIU, OVERHEAD PBSW FAULT LIGHTS ENG2 YELLOW HYD, BLUE HYD SYS, ENGINE INDICATIONS WITH FADAC OSDR UALA2013062604464Door · faultyLIFE JACKET DOOR ON CENTER OBSERVERS SEAT WILL NOT REMAIN CLOSED. R & R CREW LIFE VEST. DOOR STAYS CLOSED.SDR UALA2013061704158Latch · damagedONE FUEL PANEL LATCH INBD, DAMAGED. REPLACED LATCH.SDR UALA2013060303818Proximity Sensor · out of adjustLANDING GEAR STUCK, RETURNED TO FIELD. ADJUSTED PROXIMITY SENSORS 24GA AND 25GA ACCOMPLISHED GEAR SWING. OPS CHECKED NORMAL IAW AMM 32-31-00 AND AMM 32-31-73-820-006-A.SDR UALA2013041502536Manifold · leakingMLG LEFT BRAKE SERVO VALVE MANIFOLD LEAKING AT HOUSING CASTING WHEN PRESSURIZED AND BRAKES APPLIED. REMOVED AND REPLACED THE LEFT NORMAL BRAKE SERVO VALVE MANIFOLD ASSY. OPERATIONAL TESTS PERFORMED NO DEFECTS NOTED REF AMM 32-42-16-400-001-A.SDR UALA2013040402244Headset · inoperativeOMC HEADPHONES INOPERATIVE. REPLACED HEADSET.SDR UALA2013040102063Service Panel · dentedAFT WATER SERVICE PANEL HAS A DENT AND 1 INCH CRACK 3 INCHES FROM AFT EDGE. REPORTED BY WATER SERVICE. REINSTALLED DOOR IAW MM 52-42-13. SECURITY CHECKED GOOD.SDR UALA2013031401505Unknown · odorSTRONG BURNING ELEC SMELL IN AFT CABIN NOT ABLE TO IDENTIFY SOURCE. DISSIPATED IN FIVE MINUTES. ACCOMPLISHED ELECTRICAL SMELL INSPECTION PER MM 24-00-00-810-823-A. REMOVED VIDEO MONITORS AND INSPECTED WIRING UNDERNEATH SEATS. NO IRREGULARITIES NOTED. NO CISDR UALA2013030801387Oxygen Mask · dislodgedSEAT 30ABC PAX OXYGEN DOOR FELL OPEN, WITH MASKS DEPLOYED.SDR UALA2013030501307Tire · vibrationCREW REPORT: NOSE WHEEL VIBRATION ON TAKEOFF SEEMED EXCESSIVE. REPLACED BOTH NLG TIRES.SDR UALA2013021500898Fastener · missingRIVET MISSING IN EXHAUST AREA OF NR 1 ENGINE RT C-DUCT LOWER BIFI HAS ONE MISSING FASTENER ON VERTICAL WALL APPROXIMATELY THREE INCHES FROM TRAILING EDGE. REPLACED LOCK FASTENER PER CMM 78-30-00 FIG 31 SHEET 10 ITEM 150.SDR UALA2012122107357Lock · faultyCOCKPIT DOOR FAULT LIGHT DOOR CONTROLLER MID STRIKE LIGHT IS ON. REMOVED AND REPLACED MID STRIKE ELECTRIC LOCK IAW MM, OPS CHECKED GOOD.SDR UALA2012112806801Structure · delaminatedLEFT SIDE OF RUDDER IS DELAMINATED AT THE UPPER HOIST POINT AREA ALONG WITH MINOR IMPACT DAMAGE 26 INCHES ABOVE THE UPPER HOIST POINT. BOTH AREAS HAVE BEEN REPAIRED PER ECRA 5540-01330.SDR UALA2012112606757Sill · corrodedL2 DOOR SILL CORRODED AT FRAME 68. CORROSION OUT OF LIMITS. INSTALLED STRAP REPAIR IAW SRM 53-41-14 FIG 201. MAJOR REPAIR.SDR UALA2012111406556Structure · damagedG1 AND G4 GALLEYS HAVE HEAT DAMAGE BEHIND WORK LIGHTS. GALLEYS WERE REFURBISHED AT HMV2 VISIT PER JD-CE-40-25-30-02-JD1.SDR UALA2012100805706Acoustic Panel · damagedNR 2 ENGINE HAS MISSING ACOUSTIC MATERIAL IN ENGINE INLET. PERFORMED REPAIR PER MT71 -006 REF CF9044 FOR PERM REPAIR AT 7 O'CLOCK POSITION.SDR UALA2012090705048Ram Air Turb · faultyRAT FAILED FUNCTIONAL TEST. REPLACED RAM AIR TURBINE, OP CKS GOOD.SDR UALA2012041702321Wire · chafedCAPTAIN'S OXYGEN MASK MICROPHONE IS INOPERATIVE. SWAPPED CAPT'S AND SECOND OBS O2 STORAGE BOXES DUE TO A CHAFED WIRE. CAPT'S MASK NOW OPS CHECKS NORMAL FOR AUDIO AND O2.SDR UALA2012012300472Battery · faultySOME EMERGENCY EXIT LIGHTS ON WITH SWITCH IN OFF POSITION EPSU BATT AFT L MESSAGE ON PTP. REPLACED EPSU BATTERY PER MM. OPS CHECK GOOD.
Back to N467UA