N664UA
Service difficulty reports · 398
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 = 'N664UA' 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 = 'N664UA' 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 CALA2018022500804Pump · leakingLOST QTY AND PRESSURE RIGHT HYD SYS. EMERGENCY DECLARED. MOTORED NR 2 ENG, LARGE LEAK FROM HYD EDP DRAIN LINE FROM DRIVE CAVITY. REPLACED RT ENGINE DRIVEN PUMP. AND CASE DRAIN AND EDP FILTERS. REF AMM 29-11-05-404 AND AMM 29-11-17-404. OPS CHECKED GOOD,SDR CALA2018022100723Light · inoperativeFLIGHT DECK EMERGENCY EXIT LIGHT, INOPERATIVE. INSTALLED AND TURNED ON EMERGENCY LIGHTS, LIGHT CHECKED GOOD IAW AMM 33-51-00.SDR CALA2018021100595Light · missing34F EMERGENCY PATH LIGHT MISSING. REPLACED 34F EMERGENCY PATH LIGHT OPS CHECKS GOOD.SDR CALA2018021100596Light · damagedEMER ESCAPE PATH MARKING LIGHT AT 33F AND 32F IS PUSHED IN. REPLACED EMER ESCAPE PATH MARKING LIGHT AT 33F AND 32F OPS CHECKS GOOD.SDR CALA2017122004552Switch · defectiveEMER EXIT LIGHTS WILL NOT ARM PROPERLY FOUND SWITCH ON P11 OVERHEAD PANEL AT FAULT. REMOVED AND REPLACED SWITCH PER AMM. ALL OPS CHKS GOOD.SDR CALA2017120104262Slide · damagedDURING FUNCTIONAL CHECK OF R2 CABIN DOOR FOUND SLIDE UPPER LEFT CORNER SEWED PORTION COMING APART. REMOVED AND REPLACED R-2 DOOR SLIDE RAFT IN REF, WITH B767-300 AMM 25-61-00 REF.SDR CALA2017100603514Bulb · inoperativeRIGHT SIDE EMERGENCY LIGHT BETWEEN OVERWING EXIT DOORS HAS A BULB INOPERATIVE. REPLACED THE BULB. OPS CHECKED NORMAL.SDR CALA2017100603511Lens · brokenEMERGENCY LIGHT LENS IS BROKEN AT SEAT 41D. REMOVED AND REPLACED THE LENS. OPS NORMALSDR CALA2017100603513Lamp · inoperativeEXTERIOR EMERGENCY LIGHT IS INOPERATIVE AT THE R2 DOOR. REPLACED THE LAMP. OPS CHECKED NORMAL.SDR CALA2017100603512Lens · brokenEMERGENCY LIGHT LENS IS BROKEN AT SEAT 40F. REMOVED AND REPLACED THE LENS. OPS CHECKED NORMAL.SDR CALA2017100603515Lens · missingEMERGENCY LIGHT LENS IS MISSING NEAR GALLEY CART 213. REPLACED THE LENS.SDR CALA2017091503191Slide · unwanted deployDURING REACTIVATION OF OVERWING ESCAPE SYSTEM IAW AMM 25-65-00, LEFT OVERWING DEPLOYED WHILE ARMING STEP (8)(A). LEFT OVERWING SLIDE ASSY REPLACED IAW AMM 25-65-01.SDR CALA2017082502878Lamp · inoperativeEXTERIOR LEFT EMERGENCY LIGHT AFT OF LEFT WING ROOT IS INOPERATIVE. REPLACED THE LAMPS, OPS CHECKED NORMALSDR CALA2017082502879Battery Pack · inoperativeLEFT CABIN BOTH LOWER OVERWING EXITS EMERGENCY LIGHT SIGNS INOPERATIVE. REPLACED THE BATTERY PACK M1559, BOTH LIGHTS OPS CHECKED OK.SDR CALA2017040400814Connector · looseESCAPE PATH INOP FIRST 2 ROWS T/SHOOTING TRACED TO EMERG LIGHTS POWER SUPPLY M1559 CONNECTOR D13208. RECONNECTED D13208 ALL ASSOCIATED EMERGENCY LIGHTS AND EXIT SIGNS WORK OK DURING TEST PER AMM 33-51-00-715-019-001.SDR CALA2016022995176Skin · damagedPREVIOUS BLEND ON EXTERNAL FUSELAGE SKIN AT BS 1502, STRINGER 25R, FOUND TO BE OUT OF LIMITS. REMOVED DAMAGED SKIN, FABRICATED & INSTALLED REPAIR DOUBLER & FILLERS.SDR CALA2016021995122Skin · dentedBS 1294, STRINGER 36L - 37L, EXTERIOR FUSELAGE SKIN DENT. REMOVED DAMAGE. HFEC, NO CRACKS NOTED. FABRICATED & INSTALLED REPAIR PARTS IAW 5330-05561.SDR CALA2016021795115Stringer · crackedCRACKED STRINGER IN AFT CARGO AT STATION 1582, STRINGER 36, RBL 19, MOST AFT END. R & R -5 STINGER & -3,-4,-6,-7 REPAIR PARTS AT AFT CARGO, BS 1582 - 1550, STRINGER 36R IAW SRM 53-00-03 FIG 201 REPAIR 2.SDR CALA2016012795032Support Channel · dentedBULK CARGO COMPARTMENT FLOOR U CHANNEL SUPPORT IS DENTED, STATION 1444, RBL 9. R & R U CHANNEL SUPPORT IAW SRM 51-40-02 & DWG 146T5006. WORK ACCOMPLISHED.SDR CALA2016012795031Floorbeam · corrodedCORROSION IN AFT CARGO COMPARTMENT ON UPPER SURFACE OF FLOORBEAM, AT STATION 1197, LBL 7. CAP IN AFT CARGO BS 1197 WAS FOUND OUT OF LIMITS IAW SRM 53-00-07. REPLACED T CAP IAW DWG 146T1206 & SRM 51-40-02.SDR CALA2016012595030Floorbeam · corrodedAFT PIT BS 1175, RBL 20 FLOORBEAM CORROSION ON UPPER SURFACE. R & R T CAP, PN 146T1060-1 IAW DWG & SRM 51-40-02.SDR CALA2016012595027Angle · corrodedCORROSION & GOUGES ON LT ANGLE FOR WEB BS 1351, RBL 80 IN AFT CARGO CUT OUT. REMOVED & FABRICATED NEW LT ANGLE & INSTALLED IAW SRM 51-40-02, AMM 20-60- 07 & DWG 140T2520.SDR CALA2016012595025Web · bentAFT CARGO DOOR CUT OUT UPPER WEB, BETWEEN STATION 1329 - 1351, RBL 80 BENT. R & R WEB IAW SRM 51-40-02 PAR 7 FIG 12 & DWG 146T5135.SDR CALA2016012595021Wire · damagedRIGHT AFT EMER LIGHTING WIRE W4786-74-22 DAMAGED AT BS 1400, RBL 73, WL 282. SPLICED WIRE 4786-74-22 AT BS 1400, RBL 73, WL 282 IAW WDM 33-51-21 & BSWPM 20-30-12.SDR CALA2016012595020Floorbeam · corrodedCORROSION IN AFT CARGO COMPARTMENT ON UPPER SURFACE OF FLOORBEAM AT STATION 1197+66 FROM LBL 22 - LBL 43. R & R FLOORBEAM IN AFT CARGO COMPARTMENT AT STATION 1197+66, RBL 45.5 - LBL 45.5 IAW SRM 51-40-02 & DWG 146T1060.SDR CALA2016012595019Floorbeam · corrodedCORROSION IN AFT CARGO COMPARTMENT ON FLOORBEAM UPPER SURFACE AT STATION 1153, LBL 20. REMOVED & INSTALLED NEW T CAP AT BS 1153, LBL 20 IAW SRM 51-40-02 & DWG 146T1204.SDR CALA2016012595018Frame · corrodedCORROSION ON FRAME 654+121, UPPER T CAP LBL 41, AROUND FASTENER HOLE UPPER SURFACE & SEPARATED METAL UNDER NUTPLATE LOWER SURFACE. R & R T CA P IN FWD CARGO BS 654+121 IAW SRM 51-40-02 & DWG 143T1229.SDR CALA2016012595017Shear Tie · corrodedCORROSION IN AFT CARGO COMPARTMENT ON FLOORBEAM FRAME SHEAR TIE AT STATION 1395, BL 0. REMOVED, FABRICATED & INSTALLED SHEAR TIE AT STATION 1395, BL 0 IAW SRM 51-40-02, SRM 51-40-05 & DWG 146T1225.SDR CALA2016012595016Shear Tie · corrodedCORROSION IN AFT CARGO FLOORBEAM FRAME TO SKIN SHEAR TIE AT STATION 1285, LBL 2. R & R AFT CARGO FLOORBEAM FRAME TO SKIN SHEAR TIE IAW SRM 51-40-02 & DWG 146T1210.SDR CALA2016012595015Floorbeam · crackedAFT CARGO COMPARTMENT FLOORBEAM WEB HAS CRACK IN WEB, BS 1197+65, LBL 26. REPAIRED DAMAGE IN WEB, FABRICATED REPAIR PARTS & INSTALLED IAW SRM 53-00-07 FIG 201.SDR CALA2016012595014Attach Angle · crackedMAIN CABIN FLOOR SUPPORT WEB, UPPER ATTACH ANGLE HAS A CRACK AROUND FASTENER HOLE, BS 752, LBL 49.5. R & R IAW SRM 51-40-02 & DWG 140T2540.SDR CALA2016011895004Stringer Clip · corrodedCORROSION IN AFT PIT, STATION 1087, STRINGER 39R, RBL 4. REMOVED STRINGER CLIP, FABRICATED NEW IAW DWG 140T0161-1, SRM 51-30-01, 51-40-05 PT 4 FIG 2 & INSTALLED IAW SRM 51-40-02.SDR CALA2015030493188Skin · damagedLOWER FUSELAGE SKIN AT BS 1562+1 HAS 1 ELONGATED HOLE JUST OTBD STRINGER 39L. COMPLIED WITH ECRA 5300-05082 PT 1 AREA 3 FOR ELONGATED HOLE JUST OTBD AT STRINGER 39L ON BS 1562+ 1.SDR CALA2015030493187Shear Tie · corrodedCORROSION FOUND INSIDE FUSELAGE BILGE AT FRAME STATION 1562, STRINGER 38L & 38R. REPAIRED SHEAR TIE INSIDE FUSELAGE BILGE IAW ECRA 5300-0 5082 PART 1 REPAIR AREA 2.SDR CALA2015030493186Skin · corrodedUPON EVALUATING ACFT BELLY DRAIN, LEAKS FOUND 1 EA LOWER FUSELAGE DRAIN VLV MISSING THE PLASTIC INTERNAL COMPONENTS. REPAIRED CORROSION ON SKIN AT BS 1540+4 BETWEEN STRINGER 39L & 39R AT WATER DRAIN VLV IAW ECRA 5300-05082 PART 1 AREA 1. NEED TO ACCOMPLISH ISDR CALA2014111092674Cooling Fan · failedELEC FUMES IN COCKPIT DIVERTED. ACFT INSPECTIONS HAVE BEEN ACCOMPLISHED IAW REQUIREMENTS OF AMM 05 51 56 FORM 46.6020. INFORMED ODOR LIMITED TO COCKPIT ONLY, THOROUGHLY INSPECTED COCKPIT CB & PANELS FRONT & BACK NO DISCREPANCIES NOTED. FOUND FWD EXHAUST EQUSDR CALA2014102492560Skin · dentedSMALL DENT AFT OF RT AFT CARGO DOOR, FWD OF LIGHT. DAMAGED AREA CUT OUT BETWEEN BS 1351 & 1373, STRINGER 28R TO 29R. FABRICATED A REPAIR DOUBLER & TRIPLER & INSTALLED IAW REO G15668, REV B & UA ECRA 5361-01030. IAW ECRA, THE SKIN REPAIR BETWEEN BS 1360-138SDR CALA2014082592018Skin · dentedSMALL DENT AFT OF RT AFT CARGO DOOR, FWD OF LIGHT. DAMAGED AREA CUT OUT BETWEEN BS 1351 & 1373, STRINGER 28R TO 29R. FABRICATED A REPAIR DOUBLER & TRIPLER, INSTALLED IAW REO G15668 REV B & ECRA 5361-01030. THE SKIN REPAIR RECEIVED FIRST STAGE APPROVAL. A NSDR CALA2014082192000Structure · corrodedHORIZONTAL STAB TOP STRUCTURE CONSTANT BOX CTR SECTION ON RT HAS TWO EACH AREAS OF EXFOLIATION CORROSION BS 1725.5 & RBL 31, BS 1746.125 & RBL 35. REPAIRED TWO EACH AREAS OF HORIZONTAL STAB CONSTANT BOX CTR SECTION RT IAW SRM 55-10-01 & REO G18140. THIS REPASDR CALA2014061391267Latch · crackedNUMBER 1 ENG LT BAND LATCH ASSEMBLY A CRACK BETWEEN THE FIRST 2 RIVETS. REMAINING 6 RIVETS INTACT WITH NO EVIDENCE OF DISTRESS. REPLACED NR 1 ENG LT BAND LATCH ASSEMBLY IAW AMM 78-31-02-401, PART ROBBED FROM ACFT 674 NR 1 ENG, INSPECTED PART FOR SERVICEABILSDR CALA2014030390526Ballast · inoperativeROWS 37KL & 38KL LOWER SIDEWALL LIGHT INOPERATIVE DUE TO BAD BALLAST. REPLACED BALLAST M764 ON CEILING ABOVE SEAT 38KL IAW WDM 33-21-35. SIDEWALL LIGHTS BY SEATS 37KL & 38KL OPERATIONS CHECKED NORMAL.SDR CALA2014022790491Ballast · defectiveROWS 37KL & 38KL LOWER SIDE WALL LIGHT INOPERATIVE DUE TO BAD BALLAST.SDR CALA2013121793762Controller · malfunctionedAIR RETURN DUE TO A PRESSURIZATION PROBLEM, CABIN ALTITUDE EICAS. FLIGHT WAS AT FL360, THEN DESCENDED TO FL100 AFTER THE CABIN PRESSURE CONTROLLER AUTO 1 FAILED. DECLARED AN EMERGENCY. DURING DESCENT, FLIGHT MAINTAINED FL100 CABIN ALTITUDE. IT WAS NOT A RASDR CALA2013120393423Shutoff Valve · faultyON TOUCHDOWN RT ENG HPSOV EICAS ILLUMINATED. R & R NR 2 ENG HPSOV, OPERATIONS CHECKED & LEAK CHECKED GOOD.SDR CALA2013112293197Oxygen Mask · not seatedFLIGHT OFFICERS O2 MASK MIC INOPERATIVE. RESEATED FLIGHT OFFICERS O2 MASK, OPERATIONS CHECKED GOOD.SDR CALA2013110592659Scuff Plate · crackedDENT & CRACK ON BULK CARGO DOOR AFT SCUFF PLATE. CRACK IS STOP DRILLED TO .200" LONG. PERFORMED INTERIM REPAIR IAW ECRA 5320-02187 PART 1 STEPS 1-3.SDR CALA2013100891843Connector · looseLT ENG GENERATOR DRIVE LIGHT NOT ON WITH ENGINE SHUTDOWN AT GATE. SECURED LOOSE IDG ELEC CONNECTOR, DRIVE LIGHT CHECKED OK.SDR CALA2013100491756Connector · dirtyLT GENERATOR DRIVE LIGHT IS NOT ILLUMINATED WITH LT GENERATOR DRIVE DISCONNECT SWITCH IN OUT POSITION. CLEANED & RESEATED LT IDG CONNECTOR. SYSTEM CHECKED GOOD.SDR CALA2013091091168Control Lever · malfunctionedGEAR LEVER WOULD NOT MOVE TO UP POSITION IN FLIGHT, WAS FREE TO MOVE TO UP POSITION WHEN LOCK OVERRIDE PUSHED. IAW MM-32-30-00- 0100 SERIES PAGES FIGURE 104. MRM 32321.SDR CALA2013091091167Seal · brokenFIRE EXTINGUISHER AT 2R METAL SEAL BROKEN. PORTABLE EXTINGUISHER SEAL BROKEN LOCATED AFT CABIN COMPARTMENT 619. REMOVED EXTINGUISHER, WRAPPED & STOWED IN FWD CABINET NBR338. INSTALLED INOPERATIVE PLACARD, SECURED NEW LEAD SEAL TO PORTABLE FIRE EXTINGUISHER
Back to N664UA