Boeing 777-222
Service difficulty reports · 9,718
Newest first. General aviation reporting is voluntary.
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 aircraft_model_key = '777222' 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 aircraft_model_key = '777222' 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 UALA2009061801734Apu · leakingAPU HAS EXCESSIVE OIL LEAK. APU REMOVED FOR EXCESSIVE OIL LEAK. FOUND DURING C-CHECK. APU REMOVED AND REPLACED. ACCOMPLISHED AN ALTITUDE VERIFICATION START.SDR UALA2009061801731Light · inoperativeDOOR 1L EXTERIOR EMERGENCY EXIT SLIDE LIGHT IS INOP. RELAMPED, OPS CHECK OKAY.SDR UALA2009061801730Light · inoperativeAFT EEL LIGHT INOP ON SEATS 1E, 2F. REPLACED EEL LIGHT ASSY. LIGHTS OP CHECK OKAY.SDR UALA2009061701724Wire Harness · faultySPOILERS FAILURE OF ONE OR MORE SPOILER PAIRS. ADVISORY MSG01-LATCHED CRUISE MODE DEPENDENT; SPOILER POWER CONTROL UNIT (1) DOES NOT FOLLOW COMMAND. DB- PRIMARY FLIGHT COMPUTER (RIGHT) MSG-2710500 LATCHD ER MODE. REPLACED HARNESS. ALL OPERATIONAL CHECKS ANSDR UALA2009061601714Light · missingSEAT 3E 1 EACH EEL MISSING. REPLACED LAMP, OP NORMAL.SDR UALA2009061601713Lamp · brokenSEAT 1E 1 EACH EEL BROKEN. INSTALLED NEW LAMP, OP NORMAL.SDR UALA2009061501712Door · faultyAPU DOOR STATUS MSG ON EICAS. APU INLET DOOR INOP IN FULL CLOSED POSITION. APU NOT USEABLE. REPLACED APU ACTUATOR INLET DOOR.SDR UALA2009061601720Idg · underservicedRIGHT GENERATOR DRIVE LIGHT ILLUMINATED, RT GEN DISCONNECTED. SERVICED RT IDG. RAN RIGHT ENGINE, TESTED RIGHT GENERATOR, TESTS NORMAL.SDR UALA2009061501705Lamp · inoperativeSEAT 2E EMERGENCY LIGHT FWD INOP. REPLACED LAMP ASSY, OPS CHECK NORMAL.SDR UALA2009061501704Lamp · inoperativeSEAT 1E EMERGENCY LIGHT OUT AFT. REPLACED LAMP ASSY, OPS CHECK NORMAL.SDR UALA2009061501703Post · defectiveCREW REPORTS ON TAXI IN, CHARTS PLACED ON GLARESHIELD AND STRONG ELECTRICAL BURNING SMELL FROM WINDOW AND CAPTAIN’S WINDOW HEAT LUG MELTED. SPLICED IN NEW TERMINAL POST ON CAPTAIN'S NR 1 WINDSHIELD & ACP WINDOW HEAT CONTROL SYSTEM OP TEST. NO FURTHER DISCRESDR UALA2009061501701Mask · defectiveAFTER PUSHBACK CREW O2 LOW. REPLACED 1ST OBSERVER'S CREW MASK STOWAGE.SDR UALA2009061201675Line · damagedBLEED LOSS BODY RIGHT EICAS. FOUND 2 BLOWN PNEUMATIC DUCTS AND 2 HYD LINES DENTED. REPLACED BOTH DAMAGE HYD LINES WITH NEW LINES. LT WHEEL WELL AT STA 1266 ADP PNEUMATIC DUCT SUPPORT CLAMP DAMAGED. REPLACED SUPPORT CLAMP. LT WHEEL WELL ADP AIR SUPPLY DUCTSDR UALA2009061201665Idg · leakingRIGHT IDG LEAKING 25 DROPS PER MIN RUNNING. ON SHUTDOWN THERE IS A STEADY STREAM OF OIL UNTIL SHAFT CAVITY EMPTIES. REMOVED RT IDG. CIRCUIT BREAKER 'R IDG DISC' PULLED AT LOCATION 'J2' ON P210 PANEL. REPLACED THE NR 2 ENGINE IDG. ALSO REPLACED THE IDG DRISDR UALA2009061101658Sensor · failedAPU OIL QTY APU OIL QUANTITY LOW LEVEL SENSOR DETECTS LESS THAN 3.5 QUARTS OR SENSOR FAILURE. REPLACED APU OIL QUANTITY SENSOR. LEAK CHECKS AND OPS CHECKS OKAY.SDR UALA2009061001646Oxygen Mask · faultyOXYGEN MASK PROBLEM. CREW COMMENTS: INFLATABLE HARNESS BLEW OUT WHEN F/O TRIED TO PUT IT ON. REPLACED CREW OXYGEN MASK FROM SECOND OBSERVER SEAT. OPS CHECK OKAY.SDR UALA2009061001648Battery · faultyAPU DID NOT START, APU STATUS MSG, APU CHARGER MSG ALSO. RESET APU BATTERY CHARGER CB ON P320. APU BATT NOT CHARGING. SUSPECT CHARGER AT FAULT. REPLACED BATTERY AND CHARGER, ALL TESTED OKAY.SDR UALA2009061001644Light · inoperativeOUTSIDE DOOR 2R HAS EMERGENCY LIGHT INOP. RELAMPED EMERGENCY LIGHT.SDR UALA2009060901639Pressure Switch · malfunctionedLT ENG FUEL PUMP FILTER MSG. RTFL. REPLACED FUEL PUMP FILTER PRECAUTIONARY AND REPLACED FUEL PUMP DIFFERENTIAL PRESSURE SWITCH. RAN ENGINE AND VERIFIED NO MESSAGE OR LEAKS. OLD FUEL FILTER NO CONTAMINATION, REPLACED PRECAUTIONARY.SDR UALA2009060901634Duct · unknownBLEED LOSS ON FINAL. FOUND APU BLEED DUCT BLOWN IN AFT CARGO AREA, DUCT REPLACED. LEAK AND AFOLDS CHECK OKAY. PERMANENT REPAIR ACCOMPLISHED. AIRCRAFT OK FOR SERVICE.SDR UALA2009060801620Oven · dirtyWARMING OVEN - SMOKING, NEEDS CLEANING DR-1 LT GAL 410. CLEANED WARMING OVEN GAL 410 DR-1. CHECK OK NOW, NO SMOKING FOUND.SDR UALA2009060801625Filter · dirtyEQUIPMENT COOLING AIR FILTER NEEDS REPLACEMENT. REPLACED FILTER.SDR UALA2009060501617Gcu · inoperativeELEC GEN SYS L STATUS MESSAGE. FOLLOWED BY GALLEY LOAD SHED INDICATIONS. BUS TIE SWITCH DID NOT INDICATE ISOLATED HOWEVER NO CONNECTION ON SYNOPTIC PAGE TO BUS TIE. APU GEN & BUG ALSO DID NOT INDICATE IT WAS POWERING THE L BUS. CREW CYCLED L GEN SWITCH TO SDR UALA2009060401601Generator · failedELEC BACKUP GEN R RIGHT BACKUP GENERATOR OFF DUE TO A PROTECTIVE TRIP. REPLACED RT BACK-UP GENERATOR. ACCOMPLISHED ENGINE RUN AND FOUND NO MESSAGES PER TEST 3 AND 6.SDR UALA2009060401600Casting · brokenFORWARD GIRT BAR ATTACH CASTING ON DOOR 2R IS BROKEN. REMOVED BROKEN SUPPORT CASTING.SDR UALA2009060301596Casting · brokenFORWARD GIRT BAR ATTACH CASTING ON DOOR 2R IS BROKEN. REMOVED BROKEN SUPPORT CASTING. REPLACED CASTING ASSY.SDR UALA2009060301594Light · inoperativeSEAT 3E EMERGENCY LIGHT FWD INOP. RELAMPED, OP CHECK NORMAL.SDR UALA2009060201586Valve · damagedBLEED ENG L EICAS MSG. RTFL. FOUND SHAFT SHEARED. REPLACED HP VALVE, OPS CHECK OKAY.SDR UALA2009060101576Pcu · faultySPOILER MSG DISPLAYED-CMC MSG1&2. SUSPECT NR 3 SPOILER ACT OR CABLE. FOUND CABLE ASSY CONNECTOR SHORTING INTERNALLY AT THE RECEPTACLE. NEW RECEPTACLE ON HAND. INSTALLING PART. REPLACED NR 3 OUTBOARD SPOILER PCU. ACP INSP OF SPOILER PCU INST. NO DEFECTS SDR UALA2009060101573Controller · failedDURING NR 2 ENG RUN, RIGHT ANTI-ICE VALVE FAILED CLOSED. STATUS MESSAGE, RAN TEST UNABLE TO CLEAR. REPLACED NR 2 ENG EAI CONTROLLER, GRD TEST PASSED & MSG CLEARED.SDR UALA2009060101547Battery · failedMAIN BATTERY FAILURE. REPLACED MAIN BATTERY. ALL OPS NORMAL.SDR UALA2009060101566Battery · failedAPU BATTERY FAILURE. REPLACED APU BATTERY, CONDITION NORMAL.SDR UALA2009060101560O-Ring · brokenFUEL LEAK FROM NR 1 ENGINE. REPLACED FUEL PUMP FILTER ELEMENT SEAL ASSY. PERFORMED LEAK CHECK ALL OK.SDR UALA2009060101571Valve · failedPACK FCV L ONE (BUT NOT BOTH) OF THE TWO LEFT PACK FLOW CONTROL VALVES (FCV) ARE NOT IN THE COMMANDED POSITION. STATUS MSG01- LATCHED DESCENT MODE DEPENDENT; LOWER FLOW CONTROL AND SOV (L PACK) TORQUE MOTOR IS NOT IN COMMANDED POSITION. DB- CABIN TEMPERATURSDR UALA2009060101551Light · inoperativeSEAT 2E FWD EEL LIGHT INOP DURING EMERGENCY LIGHT TEST. REPLACED LAMP ASSY, OPS CHECK NORMAL.SDR UALA2009052901545Generator · leakingELEC BACKUP GEN L LEFT BACKUP GENERATOR IS OFF OR HAS FAILED. ADVISORY MSG-2446080 LATCHD ER MODE. FOUND BACKUP GENERATOR LEAKING 5 DROPS A SECOND. REPLACED NR 1 ENGINE BACK-UP GENERATOR.SDR UALA2009052801537Charger · faultySTATUS MESSAGE BATTERY CHARGER APU, APU BATTERY. REPLACED APU BATTERY CHARGER & APU BATTERY, OPS CHECK OK.SDR UALA2009052701522Light · inoperativeONE (1) EMERGENCY LIGHT ON SIDE OF 2F INOP. REPLACED EMERGENCY LIGHT STRIP. OP'S CHECKED GOOD.SDR UALA2009052701521Idg · failedELEC GEN SYS L IDG HAS DISCONNECTED OR A PROTECTIVE TRIP OF THE GENERATOR CONTROL BREAKER HAS OCCURRED OR A PROTECTIVE TRIP OF THE BTB HAS OCCURRED. GCU ALSO SHOWS INTERNAL FAULT. REPLACED AND TESTED L-GCU (PRECAUTIONARY). IDG REPLACED AND ENGINE RUN CHECKSSDR UALA2009052701516Light · missingONE EEL LIGHT AT SEAT 1F MISSING. REPLACED LIGHT. EEL LIGHT OP CHECKS OKAY.SDR UALA2009052601488Light · inoperativeSEAT 2F AFT EMERGENCY LIGHT INOP. REPLACED EMERGENCY LIGHT. OP CK NORMAL.SDR UALA2009052601487Light · inoperativeSEAT 3E AFT EMERGENCY LIGHT INOP. REPLACED EMERGENCY LIGHT. OP CK NORMAL.SDR UALA2009052601486Light · inoperativeSEAT 2E AFT EMERGENCY LIGHT INOP. REPLACED EMERGENCY LIGHT. OP CK NORMAL.SDR UALA2009052701526Anti-Ice Valve · failedANTI-ICE ENG R RIGHT ENGINE ANTI-ICE (EAI) VALVE FAILURE TO THE CLOSED POSITION OR EAI CONTROL CARD FAILURE. ADVISORY MSG01- LATCHED CRUISE MODE DEPENDENT; ENGINE ANTI-ICE VALVE (RIGHT) IS FAILED IN CLOSED POSITION. DB- ACIPS CONTROL CARD, RIGHT (R EAI CARD) SDR UALA2009052701525Smoke Detector · failedRECEIVED "DETECTOR FAN NR 2 CARGO FWD" STATUS MESSAGE. REPLACED FWD CARGO SMOKE DETECTOR.SDR UALA2009052701524Bolt · out of adjustDOOR 1L WILL NOT DISARM. DOOR DOES NOT APPEAR TO BE FROZEN. WHEN TRYING TO DISARM, GIRT BAR RELEASE MECHANISM WOULD NOT MOVE AND DISARM HANDLE WOULD ONLY MOVE THROUGH 25 PERCENT OF TRAVEL. SEATS AFFECTED ARE ROWS 1-3 A THRU J. FOUND INTERLOK STOP BOLTS OUTSDR UALA2009052601514Fuel/Oil Cooler · oil consumptionNR 1 ENG HIGH OIL CONSUMPTION. FUEL OIL COOLER FAILS INTERNAL LEAKAGE TEST. FOUND EVIDENCE OF OIL LEAK-COKING AT NR 3 BEARING BREATHER ELBOW TUBE CONNECTION INTO ENGINE, 1:00 O'CLOCK POS. REMOVED AND REPLACED FUEL OIL COOLER. REPLACED NR 1 ENGINE.SDR UALA2009052601513Module · failedLT & RT ICE DETECTOR MSG. REPLACED LEFT AIMS IOM- M008. OPS NORMAL. ICE DETECTOR LT & RT MSG CLEARED.SDR UALA2009052101467Slide · failedAFTER THE SLIDE HAD BEEN FIRED THE TECHNICIAN WENT TO REMOVE THE RESERVOIR FROM THE SLING UNDERNEATH SLIDE AND THE BOTTOM TUBE OF THE SLIDE BLEW FROM THE SEAM. REPLACED SLIDE, 3R SLIDE PERFORMED RII INSP OF 3R SLIDE INSTALLATION ASSY. NO DEFECTS FOUND.SDR UALA2009051901419Unknown · odorOIL SMELL IN CABIN. FLT DIVERTED.
Back to Boeing 777-222