N667UA
Service difficulty reports · 372
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 = 'N667UA' 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 = 'N667UA' 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 CALA2017071402230Socket · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE EXTERIOR EMERGENCY LIGHT SOCKET ASSY. OPS CHECKED NORMAL.SDR CALA2017071402229Lamp · inoperativeLEFT AFT FUSELAGE OFF WING ESCAPE EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51-06-903-082. OPS NORMAL.SDR CALA2017052601587Light · looseEMERGENCY LIGHT CENTER FLOOR STRIP AT ROW 21 HAS COME LOOSE. SECURED THE LIGHT.SDR CALA2017052401553Fan · failedLEFT RECIRCULATION FAN EICAS C THE LEFT RECIRCULATION/ELECTRICAL EQUIPMENT EXHAUST FAN HAS A FA ILURE. ACCOMPANIED WITH BRIEF ELECTRICAL ODOR FOR TWO MINUTES THEN DISSIPATED. FLT ATTENDANTS BOTH CONFIRMED ODOR DISSIPATED AFTER LEFT RECIRCULATION FAN TRIP.SDR CALA2017041000953Lens · brokenEMERGENCY LIGHT LENS BROKEN AT SEATS 23D AND 31F. REPLACED LENS OK, REF AMM33-51-00.SDR CALA2017021300343Pdu · faultyTE FLAP DISAGREE LIGHT CAME BACK ON AFTER SELECTING TE ALT FLAPS LANDED WITH FLAPS 1 EMERGENCY DECLARED. FSEU INSPECTED FOUND FAULT 27-51104, PERFORMED FIM 27-51 TREE 8 10 NO FAULT FOUND SYSTEM OK ON GROUND , FLAPS OPERATIONAL TEST PERFORMED , OK NO FAULT FOUNSDR CALA2017020600279Module · faultyCREW DEBRIEF DURING APPROACH WITH FLAPS SELECTED FROM 5 TO 20 FLAPS STOPPED MID WAY.TE FLAP LIGHT ILLUM AND EICAS MSG FLAP DISAGREE. QRH ACCOMPLISHED. EMERGENCY DECLARED. C/O FIM 27-51 FAULT TREE 808 AND 810 ACCOMPLISHED NO FAULTS FOUND ADP AUTO FUNCTION DEFERSDR CALA2017013000196Flap System · malfunctionedTE FLAP DISAGREE EICAS MESSAGE DISPLAYED WHEN FLAP WAS SELECTED TO 5 DEGREES. ACCOMPLISHED QRH 90.20 USING ALTERNATE FLAP PROCDURES FLAP WENT TO 20 DEGREES. DURING FLAP ALTERNATE PROCEDURES, EICAS MESSAGE FLAP DISAGREE EXTINGUISHED. EMERGENCY DECLARED. FSEU BSDR CALA2016121201065Motor · faultyTE FLAP DISAGREE EICAS MESSAGE DURING CONFIGURATION FOR LANDING, FLAPS 5. T/E ASSY DISAGREE CHECK LIST ACCOMPLISHED, NORMAL LANDING. FSEU BITE,FIM 27-51 FT 809 SHOWS NO EXISTING FAULTS, LAST FLT LEG SHOWS MAINT MESSAGE 27-51104. TROUBLESHOT IAW FIM 27-51 FT 8SDR CALA2016111800929Fseu · failedTRAILING EDGE FLAP DISAGREE, QRH C/W, EMERGENCY DECLARED. PERFORMED T/S IAW AMM 27-51 TASK 810, NO FAULTS FOUND. REPLACED FSEU IAW AMM 27-51-01, ALL CHECKS GOOD.SDR CALA2016050495334Skin · corrodedAFT PIT BILGE BS 1153, LBL 13, EXTERNAL FUSELAGE SKIN CORROSION. REMOVED DAMAGE, FABRICATED & INSTALLED REPAIR PARTS, DOUBLER & TRIPLER, IAW ECRA 5330-05683.SDR CALA2016050495333Skin · corrodedCORROSION ON UPPER SURFACE OF CTR TANK, STATION 955.1, RLB 86. REPAIRED UPPER SURFACE OF CTR TANK, BS 955.1, RBL 86 IAW ECRA 5710-02530.SDR CALA2016050495332Skin · crackedRIGHT WING LOWER SKIN AT WS 990.20, BETWEEN STRINGER L9 & L10, CRACK IN THE AREA OF MODIFICATION AT 6 EACH FASTENER LOCATIONS. REPAIRED DAMAGED HOLES IAW ECRA 5731-01509.SDR CALA2016050495330Shear Tie · corrodedAFT PIT BILGE BS 1153, LBL 13, SHEAR TIE CORROSION. REMOVED DAMAGE, FABRICATED & INSTALLED REPAIR PARTS, DOUBLER & TRIPLER, IAW ECRA 5330-05683.SDR CALA2016042895316Failsafe · corrodedAFT PIT BS 1562, STRINGER 39L - 39R, FAIL SAFE CHORD CORRODED. REMOVED DAMAGE. FABRICATED & INSTALLED REPAIR PARTS IAW ECRA 5310-06807.SDR CALA2016042895320Failsafe · crackedEA 5340-01478, RT FAIL-SAFE CHORD CRACKED. ACCOMPLISHED EA 5340- 01478 OP 04, RT SIDE STATION 955, REAR SPAR BULKHEAD FAIL-SAFE STRAP REPAIR ON TASK CARD 691845004.SDR CALA2016042895319Skin · corrodedCORROSION ON LT APU DOOR SKIN AT 3RD RIB FWD LOWER END CORROSION, FOUND TO 100% MAT LOSS. INSTALLED SKIN REPAIR IAW SRM 52-40-01 RPR 2.SDR CALA2016042695299Door Frame · damagedON WALK AROUND FOUND BULK PIT LOWER LT CORNER EDGE OF DOOR FRAME DAMAGED. REPAIRED BULK CARGO DOOR LOWER FWD CORNER IAW SRM 52-30-01 FIG 201 REPAIR 6.SDR CALA2016042295280Shear Tie · corrodedCORROSION ON SHEAR TIE IN AREA OF BULK CARGO AT 1562 BL 0. R & R SHEAR TIE AT BS 1562, BL 0 IAW SRM 51-40-02 PARA 4 & 7 FIG 6 8 & 12.SDR CALA2016041895278Shear Tie · damagedBULK CARGO SHEAR TIE BS 1562, BETWEEN STRINGER 32R & 33R HAS ELONGATED HOLES. R & R SHEAR TIE BS 1562 IAW SRM 51-40-02 PARA 4 FIG 6 & DWG 146T1523.SDR CALA2016041595270Shear Tie · corrodedAFT CARGO BS 1197, BL 0 SHEAR TIE CORRODED AT STRINGER 39L. REMOVED CORROSION FROM SHEAR TIE, 100% MATERIAL LOSS. INSTALLED NEW SHEAR TIE IAW DWG 140T2102 & SRM 51-40-05, FIG 2 & 51-40-02 PARA 4 FIG 3.SDR CALA2016040795254Shear Tie · corrodedCORROSION ON SHEAR TIE AT STATION 1175, STRINGER 39R, RBL 7 AFT CARGO. FABRICATED & INSTALLED SHEAR TIE IAW DWGS 146T1205, 140T2102, AMM 51-20-99, 51-21-10, SRM 51-20-02, 53-60-07, 51-20-01, 51-40-02, 53-00-07, 51-30-01, 51-40-05, 51-20-05 & 53-60-01.SDR CALA2016040695253Intercostal · crackedMAIN CABIN FLOOR SUPPORT STRUCTURE INTERCOSTAL HAS CRACKS AROUND FASTENER HOLES, BETWEEN BS 1395 & BS 1417, LBL 34.5. R & R FLOOR SUPPORT STRUCTURE INTERCOSTAL IAW SRM 51-40-02 & DWG 452T3274.SDR CALA2016040695252Intercostal · crackedMAIN CABIN FLOOR SUPPORT STRUCTURE INTERCOSTAL HAS CRACKS AROUND FASTENER HOLES, BETWEEN BS 1395 - 1417, LBL 43.5. R & R MAIN CABIN FLOOR SUPPORT STRUCTURE INTERCOSTAL AT BS 1395 - 1417, LBL 43.5 IAW SRM 51-40-02 PAR 4 FIG 8 & DWG 452T3207.SDR CALA2016040695251Shear Tie · corrodedAFT PIT BS 1197+132 SHEAR TIE & STRINGER 39L CORRODED. REMOVED DAMAGE. FABRICATED & INSTALLED REPAIR PART IAW DWG & SRM 51-40-02.SDR CALA2016020395064Socket · defectiveEXTERIOR EMER LIGHT IS INOPERATIVE AT L1 DOOR. R & R SOCKET ASSEMBLY. OPERATIONS CHECKED NORMAL.SDR CALA2015061593917Latch · out of adjustREF EA 2560 02662 OP 1 LT OFF WING ESCAPE SLIDE DOOR LATCH CHECK FAILED, EXCEEDS 175 INCH POUNDS STEP 5 IAW EA OP3 MUST NOW BE COMPLIED WITH. COMPLIED WITH OP 001 EA 2560-02662. LT OFF WING ESCAPE SLIDE DOOR LATCH & DISCONNECT HOUSING INSPECTION.SDR CALA2015042393631Spar · crackedNUMBER 1 PYLON UPPER SPAR WEB HAS TWO CRACKS, ONE EACH AT INBD & OTBD DRAIN HOLES AS SEEN THROUGH ACCESS PANEL K416AR. CONTAINED CRACKS, MACHINED STEPPED DOUBLERS & FABRICATED FILLERS & INSTALLED REPAIR IAW ECRA 5453-01087, TIMCO REO-G17581, REV IR & SRM 54-5SDR CALA2015033093491Sign · inoperativeFLIGHT DECK EMER EXIT LIGHT BATTERY DEAD, NO GO FLIGHT. R & R FLIGHT DECK EMER EXIT SIGN ASSEMBLY IAW AMM 33-51-07-201. VERIFIED PACK CHARGING.SDR CALA2014071191457Skin · dentedEXTERNAL FUSELAGE AT STATION 358 STRINGER 31L HAS SURFACE DENT. MEASURED DENT DEPTH 0.012 & WIDTH 0.5 & LENGTH 1.0 IN A=0.5 & Y=0.012 A-Y=41.6 DIMENSIONS WITHIN SRM 53-00-01 ALLOWABLE DAMAGE FIG 101 DETAIL 3 LIMIT. PERFORMED HFEC NO CRACKS NOTED. EVALUATED SDR CALA2014071191458Skin · dentedBS 358 DENT AT STRINGER 31L HAS A SMALL GOUGE IN THE CTR OF DENT, FOUND DURING RE-EVALUATION AT C11 VISIT. BLENDED GOUGE & MATERIAL REMAINING EXCEEDS SRM 53-00 -01 LIMITS. CUT OUT DAMAGED SKIN, FABRICATED & INSTALLED A REPAIR DOUBLER & FILLER IAW SRM 53-00-01SDR CALA2014071191434Spar · crackedNUMBER 1 PYLON UPPER SPAR WEB HAS TWO CRACKS, ONE EACH AT INBD & OTBD DRAIN HOLES AS SEEN THROUGH ACCESS PANEL 416AR. CONTAINED CRACKS, MACHINED STEPPED DOUBLERS & FABRICATED FILLERS & INSTALLED REPAIR IAW ECRA 5453-01087, REO-G17581 REV IR & SRM 54-53-01 REPSDR CALA2014071191433Structure · crackedNUMBER 1 PYLON AS SEEN THROUGH ACCESS PANEL 432BL, WIRE BUNDLE CUT OUT CRACKED. STOP DRILLED CRACK ENDS & FABRICATED THE -12 DOUBLER & -13, -14 & -15 FILLERS & INSTALLED IAW SRM 54-53-02 REPAIR 2. IAW SRM THIS IS A CAT A & SUPPLEMENTAL INSPECTIONS ARE COVERESDR CALA2014063091381Cylinder · defectiveLEFT OVERWING ESCAPE SYS INFLATION CYLINDER, INFLATION TRIGGER CABLE BALL IS NOT BEHIND RETAINER SPRING. R & R LT OVERWING INFLATION CYLINDER IAW AMM 25-65-02 & UAL WORK CARD 614304010.SDR CALA2014063091380Connector · missingSEAT 21DEF EMER LIGHT Y CONNECTOR MISSING. REPAIRED SEAT 21DEF EMER LIGHT Y CONNECTOR BY REPINNING IAW BSWPM 20-64-17. EMER LIGHTS OPERATIONS CHECKED GOOD.SDR CALA2014063091379Socket · burnedSEAT 21DEF LT EMER LIGHT SOCKET BURNED. R & R LT AFT EMER LIGHT RED ASSEMBLY AT SEAT 21DEF, OPERATIONS CHECKED GOOD IAW AMM 33-51-10.SDR CALA2014062791358Cable · frayedLEFT AFT OVERWING EMER EXIT HATCH STEP, AFT CABLE FRAYED. R & R LT AFT OVERWING EMER EXIT HATCH AFT CABLE IAW SRM 51-40-2 ON NON-ROUTINE.SDR CALA2014061391270Warning System · activatedAPU DOOR EICAS STATUS MSG. TRIED CYCLING DOOR & MSG REAPPEARED ALTHOUGH DOOR OPERATED NORMAL. HAS HISTORY, DOOR LOCKED IN OPEN POSITION.SDR CALA2014052791168Warning System · activatedRIGHT ENGINE HPSOV EICAS.SDR CALA2014022590483Valve · malfunctionedLT ENG PRV EICAS MESSAGE AFTER ENG START. REPLACED PRV IAW MM 36-11 -18 & TESTED NORMAL, STATUS MESSAGE CLEARED.SDR CALA2014010290039Idg · faultyRT ENG GEN INOPERATIVE. IDG WAS DISCONNECTED & RESIDUAL VOLTS VERIFIED TO BE ZERO. PLACED RT ENG GENERATOR INOPERATIVE IAW MEL 2400F, DDP COMPLIED WITH. R & R NR 2 ENG IDG IAW AMM. OPERATIONS & LEAK CHECKED GOOD, NO FAULTS NOTED.SDR CALA2013120993544Fseu · faultyTE FLAP DISAGREE TROUBLESHOOT DUE TO RECENT REPORTS OF TE FLAP DISAGREE EICAS MESSAGE. REPLACED FSEU WITH A 285T0049-63 IAW AMM 27-51-01.SDR CALA2013111292842Oxygen Mask · leakingSELF INFLATING HARNESS ON FIRST OFFICER'S OXYGEN MASK HAS A LEAK. WILL NOT INFLATE PROPERLY. REPLACED FIRST OFFICER'S OXYGEN MASK IAW AMM, OPERATIONS CHECKED FUNCTION NORMAL.SDR CALA2013111292841Fitting · leakingFUEL LEAKING OUT OF LOWER PF FITTING ON FMU ON NR 2 ENG, WET MOTORED ENG. WHEN SHUT OFF FUEL, FUEL WAS FOUND ON PARTING SURFACE BETWEEN FMU & FUEL PUMP, RUNNING LEAK.SDR CALA2013110592680Pump · malfunctionedDUE TO RECENT FUEL IMBALANCE & ASSOCIATED CONFIG LIGHT. REMOVED RT CENTER OVER RIDE PUMP, INSTALL NEW OVERRIDE PUMP IAW TASK 28-22 -05-404-078-022 PAGE 419. OPERATIONS CHECKED & LEAK CHECKED GOOD.SDR CALA2013110192562Apu · faultyAFTER PUSHBACK, APU AUTO SHUTDOWN TWICE. REPLACED APU IAW MM, OPERATIONS CHECKED GOOD.SDR CALA2013100991909Counter · malfunctionedREPLACED APU START COUNTER & NOW IT DOUBLE CLICKS EVERY TIME YOU START THE APU.SDR CALA2013100891839Connector · dirtyON DESCENT TO FL280 LT ENG PREVIOUS EICAS MESSAGE. ACCOMPLISHED VISUAL INSPECTION IAW FIM 36-10-00 PAGE 162 & AMM 36-11-18-401 INSTALLATION TEST CHECKED ALL SENSITIVE LINES. CLEANED CONNECTOR ON PRVC. OPERATIONS CHECKED OK TO CONTINUESDR CALA2013092491412Actuator · malfunctionedLT PACK TEMPERATURE EICAS ON FINAL WON'T CANCEL. LT PACK INOPERATIVE IN AUTO, WORKS OK IN STAND BY. LT PACK TEMPERATURE CONTROLLER M126 BITE PROCEDURE CARRIED OUT IAW FIM 21-51-00,101. BIT SHOWS RAM OUTLET ACTR FAULT, VERIFY SHOWS ALSO RAM OUTLET ACTR FAULTSDR CALA2013092391353Control Switch · faultyLT WING FLT CONTROL SHUTOFF SWITCH ON AUX PANEL WAS FOUND IN OUT OFF POSITION. LT WING FLT CONTROL SHUTOFF VALVE DEFERRED INOPERATIVE IAW MEL. CONTROL SWITCH REQUIRED REPLACEMENT. MEL DEACTIVATION PROCEDURE & TEST ACCOMPLISHED.
Back to N667UA