N772UA
Service difficulty reports · 240
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 = 'N772UA' 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 = 'N772UA' 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 CALA2018080981771Shear Tie · corrodedBULK CARGO, BS 1958, BETWEEN STRINGERS 42L AND 43L, THE SHEAR TIE WAS FOUND CORRODED. THE SHEAR TIE WAS REPLACED IAW SRM 51-10-02 AND INSTALLED IAW SRM 51-40-02.SDR CALA2018080981770Stringer · corrodedAFT CARGO BAY BILGE AREA BS 1874 - 1885, STRINGER 44L WAS FOUND CORRODED. THE STRINGER WAS REPAIRED IAW ECRA 5371-01002, REV.SDR CALA2018080981769Stringer · corrodedAFT CARGO BAY BILGE STRINGER 49R AT BS 1874 WAS FOUND CORRODED. THE STRINGER WAS REPAIRED AND REPLACED IAW ECRA 5371-01003, REV-.SDR CALA2018080981768Shear Tie · corrodedAFT CARGO BAY BILGE AREA BS 1874, STRINGER 47L - 48L SHEAR TIE WAS FOUND CORRODED. THE SHEAR TIE WAS REPLACED IAW SRM 51-10-02, AND INSTALLED IAW SRM 51-40-02.SDR CALA2018080601741Battery Pack · no testDURING A CHECK, THE R3 DOOR M33401 BATTERY PACK CAPACITY CHECK FAILED. THE BATTERY PACK REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018080601740Battery Pack · no testL3 DOOR M33406 BATTERY PACK CAPACITY CHECK FAILED., THE BATTERY PACK WAS REPLACED AND TESTED NORMAL IAW AMM 33-51-06.SDR CALA2018080601744Skin · crackedSKIN AT BS 2221.65, BETWEEN STRINGERS 9R AND 10R, WAS FOUND CRACKED. A REPAIR DOUBLER AND TRIPLER WAS INSTALLED IAW EA 5300-01986, REV A, OP 011.SDR CALA2018080601743Skin · crackedSKIN AT BS 2195.75, BETWEEN STRINGERS 6R AND 8R, TWO FASTENER HOLES FOUND CRACKED. A REPAIR DOUBLER AND TRIPLER WAS INSTALLED IAW EA 5300-01986, REV A, OP 010.SDR CALA2018080601742Skin · crackedBS 2195.75 BETWEEN STRINGERS 6L AND 8L, THE SKIN HAD TWO FASTENER HOLES THAT WERE FOUND CRACKED. A REPAIR DOUBLER AND TRIPLER INSTALLED IAW EA 5300-01986, REV A, OP 007.SDR CALA2018011200113Engine · odorAT IDLE DESCENT WITH HIGH PRESSURE VALVES OPEN, A NOXIOUS OILY ODOR. REPLACE THE NR 1 ENGINE IAW MM 71-00-02.SDR CALA2017010100002Engine · leakingCABIN COMPLAINS OF HYDRAULIC FUME SMELL SEVERAL PEOPLE NAUSEOUS. OIL FOUND IN HPC STAGES 6 AND 7. REQUIRES ENG CHANGE. REPLACED NR 1 ENGINE PER AMM 72-00-00.SDR CALA2016012595029Engine · oil consumptionDIRTY SOCK ODOR WHEN ACFT REACHED CRUISE, AFTER LEVEL OFF IN FLIGHT DECK & FIRST REAR CABIN, THEN IN FIRST CLASS, HAZE IN FLIGHT DECK WAS INCREASING. SHUT OFF THE UPPER RECIRC FAN & ODOR SEEMED TO INTENSIFY, THE UPPER WAS SELECTED BACK ON THEN THE LOWER WAS SSDR CALA2016012895062Engine · oil consumptionDIRTY SOCK ODOR WHEN ACFT REACHED CRUISE, AFTER LEVEL OFF, IN FLIGHT DECK & FIRST REAR CABIN, THEN IN FIRST CLASS. HAZE IN FLIGHT DECK WAS INCREASING. NR 1 ENG HAS OIL IN THE TAIL PIPE & 9 QTS OF OIL ADDED, HIGH OIL CONSUMPTION. REPLACED NR 1 ENG IAW AMM 71SDR CALA2015111794814Wire · brokenCOCKPIT EMER LIGHT SWITCH ARMING WIRE BROKEN OFF SWITCH GUARD. REPLACED SWITCH GUARD. ARMING FUNCTION OPERATIONS OK.SDR CALA2015102694694Lens · unsecureEXIT LIGHT LENS NOT SECURE, FALLS OFF, LOCATION DOOR 3L. REPLACED EMER LIGHT ASSEMBLY, OPERATIONS NORMAL.SDR CALA2015092194382Pin · backed outEMERGENCY LIGHT IN AFT CABIN ON, WITH OVERHEAD SWITCH IN OFF POSITION. FOUND RECESSED PIN AT P10 3 PANEL RECEPTACLE D1373J PIN 10 WDM 33-51-12. REINSERTED PIN INTO RECEPTACLE. ALSO FOUND EMER LIGHT CHARGER MODULE M33405 INOPERATIVE. REPLACED CHARGER & BATTESDR CALA2015090394266Light · unsecureSEAT 34G EEL INOPERATIVE. SECURED EEL SEAT LAMP. OPERATIONS CHECKED GOOD.SDR CALA2015083194260Connector · not seatedDOOR 4L & DOOR 4R EMER EXIT SIGNS REMAIN ILLUMINATED AFTER SELECTING EMER LIGHT SWITCH TO THE OFF POSITION. SEATED CONNECTOR TO EMER LIGHT POWER SUPPLY FOR DOOR 4L & 4R, RESET EMER LIGHT CB DOOR 4L & 4R ON P 11 PANEL. ACCOMPLISHED SUCCESSFUL TEST OF THE EMERSDR CALA2015070994072Light · malfunctionedEMERGENCY EXIT LIGHTS CAME ON AFTER LANDING & FAILED TO EXTINGUISH, ROW 44 LT & RT AISLES, BACK TO 4L & 4R. CEILING & DOOR AREA LIGHTS. ACCOMPLISHED EMER LIGHT TEST IAW MM 33-51-00. UNABLE TO DUPLICATE FAULT.SDR CALA2015051893799Stringer · corrodedSTRINGER CORROSION WAS FOUND AT STRINGER 44L BETWEEN STATION 1916 & 1958. REPAIRED IAW SRM 51-70-11 REV 67 & ECRA 5330-05162.SDR CALA2014123092872Fuse · blownON ARRIVAL, OVERHEAD EMER LIGHTS BY 4L & 4R STAY ON WITH SWITCH OFF. REPLACED DR 5L EMER POWER SUPPLY FUSE F2, RELAMP AISLE CEILING LIGHT ABOVE 50ABC & RELAMP DR 5L DROP CEILING EMER LIGHT.SDR CALA2014120992804Battery · dischargedON ARRIVAL EMER LIGHT AT DOOR 4L & 4R AREA ON. REPLACED EMER LIGHT BATTERY FWD ABOVE DOOR 4R. EMER LIGHT BACK TO NORMAL. CHECKED OK. BATTERY REPLACED & TESTED IAW AMM 33-51-06.SDR CALA2014112492727Feeder Cable · defectiveEMERGENCY EXIT LIGHTING AT SEAT ROWS 16 - 21 INOPERATIVE. INSTALLED CABLE ASSEMBLY FROM SEAT 16 -17 & 34 - 35 IAW AMM23-34-04. OPERATIONS CHECK TEST OF EMER LIGHTS FOR SEAT ROWS 16 - 21 IAW AMM33-51-00-710-801. OPERATIONS TESTED GOOD PN 286U0001-1005.SDR CALA2014082892044Battery · dischargedEEL FLOOR PROXIMITY LIGHTS BURN DIMLY BETWEEN ROWS 22 & 33. TRIED A NEW POWER SUPPLY, NO HELP. CHARGED BATTERY IN PLACE, LIGHTS ARE SERVICEABLE.SDR CALA2014071191437Pin · not seatedAFTER REPLACEMENT OF LT NR 1 WINDSHIELD & COMPLETING COA 209881, WINDOW HEAT WIRING INSTALLATION, MAT TEST FOR LT WINDOW HEAT FAILED WITH LATCHED MX MSG 30-24011. RESEATED PINS J15 & J13 IAW WD30-41-11. MSG CLEARED MAT TEST PASSED.SDR CALA2014071191408Anti-Ice System · failedAFTER REPLACEMENT OF LT NR 1 WINDSHIELD IAW LM1122 & COMPLETING COA 209881 WINDOW HEAT WIRING INSTALLATION, MAT TEST FOR LT WINDOW HEAT FAILED WITH LATCHED MX MSG 30-24011.SDR CALA2014063091361Oxygen Mask · unsecureOXYGEN MASKS DROPPED AT 1JH. INSPECTED & REPACKED O2 MASKS IAW AMM 35-21-13. OK FOR SERVICE.SDR CALA2014062491330Control Valve · out of positionONE, BUT NOT BOTH OF THE TWO RT PACK FLOW CONTROL VLVS, FCV, ARE NOT IN THE COMMANDED POSITION. STATUS MSG 2124002 LATCHED CL MODE.SDR CALA2014061391252Interlock · malfunctionedREVERSER INTERLOCK RT REVERSER THRUST LEVER INTERLOCK FAILURE. CYCLED RT REVERSER, OPERATIONS NORMAL, NO MSGS.SDR CALA2014060991242Unknown · odorFLIGHT ATTENDANT REPORTS CHEMICAL OR ELEC SMELL ROW 22 - 26 CDEF, NO SMOKE. INSPECTED 22 - 26 CDEF UNDERSEAT HARNESS & SEAT BOXES. CHECKED ALL READING LIGHT & CALL LIGHTS. BOTH LOWER RECIRCULATING FANS OPERATIONS NORMAL, NO DEFECTS NOTED. OK FOR SERVICE IAWSDR CALA2014060591208Oil Cooler · crackedOIL QTY WENT TO ZERO APPROXIMATELY AT 1529Z. TEMP PRESS OK. IT WAS ENG 2 WITH OIL LOSS. FOUND AIR & OIL COOLER B CRACKED. WILL REPLACE COOLER PARTS ON FLT 73 ETA 1825 HRS.SDR CALA2014060591207Skin · dentedFUSELAGE EXTERIOR SKIN DENT AT STATION 2100 RT STRINGER 29R - 30R. DENT OUT OF LIMITS IAW 53-00-01. THIS EXT DOUBLER REPAIR 7 IS A CAT B REPAIR IN ZONE B. SUBSEQUENT INSPECTIONS ARE NECESSARY FOR REPAIR 7 IAW PARA 6 REPAIR 7 PAGE 216, TABLE 204. INTERNAL HSDR CALA2014052791160Skin · dentedFUSELAGE EXTERIOR SKIN DENT AT STATION 2100 RT STRINGER 29R - 30R. DENT OUT OF LIMITS IAW SRM 53-00-01 FIG 102 DET E. THIS EXT DOUBLER REPAIR 7 IS A CAT B REPAIR IN ZONE B. SUBSEQUENT INSPECTIONS ARE NECESSARY FOR REPAIR 7 IAW PARA 6 REPAIR 7 PAGE 216. TABLSDR CALA2014022190403Unknown · odorMOMENTARY HOT METALLIC SMELL REPORTED BY DOOR 3R, SMELL DISSIPATED. VERIFIED NO SMOKE WAS PRESENT. UNABLE TO DETECT SMELL ON GND OR EVIDENCE OF POSSIBLE CAUSE OF MOMENTARY SMELL AS REPORTED.SDR CALA2014021090325Light · inoperative1F EMERGENCY PATH LIGHT INOPERATIVE & DETACHED. SEAT 1F AFT PATH ILLUMINATED LIGHT INOPERATIVE, SEAT MOUNTED WHITE PATH ILLUMINATED LIGHT. REPLACED EMERGENCY EXIT LIGHT STRIP, OPERATIONS C CHECKED OK.SDR CALA2014010290023Test Switch · defectiveINOPERATIVE ON FIRE TEST. NO TEST IN PROGRESS OR TEST PASS OR FAIL MESSAGE DURING TESTING. FOUND S3 FIRE TEST SWITCH BAD. REPLACED SWITCH, TESTED NORMAL.SDR CALA2013122793989Light · unsecure1F EMERGENCY LIGHT STRIP HANGING OFF. SECURED STRIP, OPERATIONS OKAY.SDR CALA2013122393862Valve · faultyLT WING FUELING VLVS WILL NOT OPEN. RESET CB'S NO HELP. MANUALLY OPENED FILL VLVS. AIRCRAFT WILL NOT ACCEPT FUEL, CHECKED FOR VOLTAGE AT LT WING FUELING VLV V28107 PIN 2. HAVE 28V AT CONNECTOR & GNDS AT PINS 1,3 & 4, BAD FUELING VLV. VLV ON ORDER PCN 646-00SDR CALA2013120993580Window · crazedCAPTAIN'S NR 2 & 3 WINDOWS BADLY SCRATCHED VISIBILITY IMPAIRED. ACCOMPLISHED INSPECTION OF WINDOWS & FOUND WINDOW CRAZING. POLISHED WINDOWS & IS ACCEPTABLE TO OUTBOUND CREW NO SCRATCHES. THE VISIBILITY THROUGH THE WINDOW IS ACCEPTABLE & THE SCRATCHES ARE WISDR CALA2013112593242Minitel · defective1ST OBSERVER WILL NOT RECEIVE AUDIO. REPLACED BAD MINITEL, OPERATIONS OKAY.SDR CALA2013112193152Duct · crackedRT PACK Y-DUCT AFT OF OZONE CONVERTER CRACKED. IAW IPC 21-73-01-001 ITEM.65 PN 213W2120-9 PCN 120-2209. REPLACED DUCT, NO LEAKS NOTED.SDR CALA2013103092504Pressure Switch · faultyFUEL PUMP LT FWD EICAS MESSAGE. REPLACED LT FWD BOOST PUMP PRESSURE SW, OPERATIONS CHECKED OKAY.SDR CALA2013102992488Wire · damagedRT LANDING LIGHT APPEARS TO BE VERY DIM. MAY BE INCORRECT BULB. SPLICED IN NEW WIRE APPROXIMATELY 10 INCHES FROM LAMP L33215 WIRE W8211-003-12 IAW SWP 20-10-13, & NEW RING TERMINAL IAW SWP 20-30-11. LIGHT OPERATIONS CHECKED NORMAL IAW WD 33-42-11.SDR CALA2013102892399Charger · defectiveMAIN BATTERY HAS BEEN CHARGING 10 AMP FOR 4.5 HRS. R & R MAIN BATTERY CHARGER IAW MM. ALL OPERATIONS NORMAL BORROWED PART SUB CAL ME 25-2431-9-0007 TT 1633772 MR NR OFF 24310 DASH 147.SDR CALA2013100991921Handle · stiffFLAP HANDLE STIFF, STICKS WHEN EXTENDING & RETRACTING FLAPS. LUBE FLAP HANDLE, OPERATIONS CHECKED OK.SDR CALA2013100891855Drain · blockedNR 1 ENG WEEP TUBE IS CLOGGED HAS NUT STUCK IN END OF TUBE. DURING ROUTINE INSPECTION IAW EC4141-1 FOUND TUBE BLOCKED. IAW MM 72-00-88 PG628 STEP 4 TUBE TO BE CLEARED WITHIN 100 CYCLES OR ENGINE REPLACED.SDR CALA2013100491725Circuit Card · defectiveLT ESC STATUS MESSAGE. REPLACED LT ESC CARD.SDR CALA2013100491724Sensor · dirtyCSCP-CACP ZONE TEMPERATURE DISPLAY FAULT MESSAGE SHOWS DR-1L ATTENDANT PANEL. ZONE C INVALID DATA DISPLAYED, DOOR 1 CSCP-CACP. FOUND ZONE 3 TEMPERATURE INVALID, CLEANED TEMPERATURE SENSOR & RAN TEMPERATURE CONTROL VALVE TEST. TEMPERATURE RETURNED.SDR CALA2013092691466Unknown · malfunctionedTROUBLESHOOTING SMC22, REPLACED BOTH OPIC AI & A2 CARDS BUT NO HELP. REINSTALLED BOTH INITIAL CARDS, REPLACED THE OPBC CONTROLLER, ALSO NO HELP. DASH NUMBERS NEED TO BE DOCUMENTED IN MRDATA AFTER REPAIR. MR23931 OFF-110 ON-63. PERFORMED MAT TEST AFTER OPBCSDR CALA2013092391339Charger · faultyMAIN BATTERY CHARGING AT 10 AMPS-28VDC INDICATED. MAIN BATTERY NOT CHARGING MORE ON GROUND. REPLACED BATTERY CHARGER IAW MM 24-31-02 AS PRECAUTIONARY.
Back to N772UA