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 UALA2009021000473Connector · damagedSEAT 2E AFT EEL LIGHT INOP. CONNECTOR DAMAGED ON SEAT HARNESS.SDR UALA2009021000465Exciter · defectiveENG IGNITOR L1 LEFT ENGINE FAILED TO IGNITE USING IGNITER 1. STATUS MSG01- NOT ACTIVE ENGINE START MODE DEPENDENT; IGNITION SYSTEM NR 1 (L ENG) FAILED TO LIGHT ENGINE. DB- ELECTRONIC ENGINE CONTROL (L ENG, CH B) MSG-7461491 INACTIVE ES MODE. REPLACED EXCITSDR UALA2009021000440Exciter · malfunctionedENG IGNITER L1 LEFT ENGINE FAILED TO IGNITE USING IGNITER 1. STATUS MSG01- NOT ACTIVE ENGINE START MODE DEPENDENT; IGNITION SYSTEM NR 1 (L ENG) FAILED TO LIGHT ENGINE. DB- ELECTRONIC ENGINE CONTROL (L ENG, CH B) MSG-7461491 INACTV ES MODE. REPLACED EXCITERSDR UALA2009021000435Light · inoperativeDOOR 3 LEFT EXTERNAL EEL LIGHT INOP. RELAMPED, OP CHECKS GOOD.SDR UALA2009021000434Light · inoperativeSEAT 20G EEL LIGHT INOP. RELAMPED AND REPLACED MISSING LIGHT COVER, OP CHECKS GOOD.SDR UALA2009021000433Light · inoperativeSEAT 22C EEL LIGHT INOP. RELAMPED, OP CHECKS GOOD.SDR UALA2009021000432Connector · damagedSEAT 2E AFT EEL LIGHT INOP. CONNECTOR DAMAGED ON SEAT HARNESS.SDR UALA2009031000430Igniter Box · faultyAPU START SYS APUC DETECTED FAILURE IN THE ELECTRIC STARTER, FUEL SCHEDULING, IGNITION, OR LUBE DEPRIME SYSTEMS OR NO SIGNAL FROM ELMS TO THE APUC. REPLACED EXCITER CLUSTER APU IGNITION BOX (P/N 3876195-8), BOTH LEADS (P/N 3888283-2 & 3888283-4), AND BOTH PLUSDR UALA2009020900430Ignition Sys · malfunctionedAPU START SYS APUC DETECTED FAILURE IN THE ELECTRIC STARTER, FUEL SCHEDULING, IGNITION, OR LUBE DEPRIME SYSTEMS OR NO SIGNAL FROM ELMS TO THE APUC. REPLACED EXCITER CLUSTER (APU IGNITION BOX (P/N 3876195-8), BOTH LEADS (P/N 3888283-2 & 3888283-4), AND BOTH PSDR UALA2009020900429Pcu · faultyFLT CONTROL SYS CMC MSG AND LEFT OUTBOARD AILERON MSG -2710201. REPLACED THE LT OUTBOARD AILERON POWER CONTROL UNIT. INSPECTED FOR SAFETY, SECURITY AND CORRECT OPERATION.SDR UALA2009020900428Light · inoperativeSEAT 1F FWD EEL LIGHT INOP. REPLACED EEL LIGHT. LIGHT OP CHECKS OKAY.SDR UALA2009020900425Shutoff Valve · faultyCREW REPORTS RT PACK EICAS MSG & LIGHT ON, PACK FLOW READS FROM 300-1200. REPLACED RT UPPER FCSOV AND RT PACK OP CHECK NORMAL.SDR UALA2009020900420Floorbeam · damagedFLOORBEAM AT STA 972 HAS DAMAGE DUE TO BURNED C2 PUMP FEEDER CABLES. RECEIVED REPAIR METAL 2030 (TITANIUM & ALUMINUM PLATE). ROUTE TO SHOP FOR REPAIR ANGLE MFG. REMOVED DAMAGE AND INSTALLED REPAIR.SDR UALA2009020900419Idg · faultyRT IDG OIL FILTER SOWS BLOCKED. REPLACED RIGHT ENGINE IDG. ACCOMPLISHED OP TEST OF RT IDG. SERVICED RT IDG AFTER RT ENG IDLE RUN. LEAK CHECK RT ENG IDG AFTER ENG IDLE RUN, NO LEAKS NOTED.SDR UALA2009020500396Idg · faultyNR 2 IDG FILTER BLOCK MSG AND DELTA P INDICATOR POPPED. REPLACED NR 2 IDG, OPS OK ON ENG RUN, NO LEAKS NOTED.SDR UALA2009020500395B-Nut · leakingNR 1 ENGINE RIGHT HALF REVERSER HAS HYD LEAK. FOUND 2 HYD LINES LEAKING AT RIGHT SIDE OF ENG NR 1. TIGHTENED B-NUTS. B-NUTS JUST FWD OF CENTER REVERSER ACT NEED TO DEPLOY REVERSER, VERIFY NO LEAKS. RAN ENGINE, OPERATED REVERSER, NO LEAKS NOTED.SDR UALA2009020400386Feeder Cable · faultyCTR HYD SYSTEM ELECTRIC PUMP C2 INOP. NEW P200 PANEL IS INSTALLED. AWAITING CONNECTOR. FOUND BURNED POWER FEEDER CABLES IN FWD PIT CEILING AT STA 972. REPAIRED AS PER GNMM STANDARD ELEC PRACTICES. C2 ELEC PUMP CK'S NORMAL.SDR UALA2009020300373Engine · malfunctionedENGINE SYSTEM STATUS MSGS HPT & LPT. REPAIR NOT VIABLE, ESN 222061 REPLACED WITH ESN 222139 IN POS 02 PER TOD AMM 71-00-02 CONFIG 2 FIG 422. FIELD REPAIR ACCOMPLISHED TO REPAIR THE AFT ENGINE MOUNT, AND REPLACE THE TURBINE CASE COOLING ACTUATOR.SDR UALA2009020200363Structure · leakingLT WING DRY BAY FUEL LEAK. CONFIRMED LEAK IN LT DRYBAY. MARKED IN RED. UPPER OUTBOARD CORNER IN FIRST BAY ACCESSED THROUGH 532AB. SEALED UPPER OUTBOARD CORNER OF RIB 9 ACCESS THRU PLATE 533BB WITH A-HALF AND B-HALF AT 1100 HRS. NEEDS LEAK CHECK WITH FULL SDR UALA2009020200357Structure · bentRAMP DAMAGE AFT LARGE CARGO DOOR. CLOSING AND AFT LOWER CORNER CAUGHT THE LOADER RAILING BENT. REPAIRED PER SRM 52-30-01 4A AND 4B. HFEC INSP NO CRACKS FOUND.SDR UALA2009020200355Pump · failedHYDRAULIC PUMP FAILURE, RTFL. HYD PUMP REPLACED. PRESSURIZED AND SERVICED, NO LEAKS NOTED.SDR UALA2009020200351Light · inoperativeEXT EMERGENCY LIGHT AT DOOR 2L IS OUT. RELAMPED EMERGENCY LIGHT, LIGHT OP CHECKS OK.SDR UALA2009020200350Hydraulic Line · leakingLT MLG WHEEL WELL CENTER SYSTEM FLIGHT CONTROL HYDRAULIC PRESSURE TUBE ASSY 272W4591-129 UPPER B-NUT LEAKING FLUID. ATTEMPTED TO TIGHTEN, NO HELP. B-NUT IS JUST AFT OF LT INBOARD FLAP, INBOARD CARRIAGE ASSY AND JUST INBOARD OF PANEL 193HL. REPLACED HYD LINESDR UALA2009020200362Idg · leakingNR 2 ENGINE IDG LEAKING OIL FROM FEEDER CABLE BLOCK. REPLACED IDG. OPS AND LEAK CHECKS OKAY.SDR UALA2009020200346Starter · failedAPU WOULD NOT START. THREE ATTEMPTS. EXISTING FAULT MESSAGE 49-17004 AND 49-17002 CURRENTLY LATCHED. CHANGED APU BATTERY, CHANGED APU CHARGER CHANGED K49002 RELAY P310, NO HELP. PER TAXI CREW APU STARTED NORMAL WITH AIR STARTER. REPLACED APUC CONT, NO HELSDR UALA2009020200341Battery · dischargedNR 3 LT MED EPAS BATTERY DOESN'T FLASH. REPLACED BATTERIES.SDR UALA2009020200339Light · inoperativeSEAT 1E AFT EMERGENCY LIGHT INOP. REMOVED OLD LAMP, SLAVED IN OTHER LAMP SYSTEM OPERATIVE, NEED LAMP. REPLACED LAMP.SDR UALA2009013000337Light · inoperativeDOOR 4 LT EXT EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT, TESTED GOOD.SDR UALA2009013000336Light · inoperativeDOOR 3 LT EXT EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT, TESTED GOOD.SDR UALA2009013000335Light · inoperativeFWD GALLEY WALL ACROSS FROM FLT ATT SEAT LT SIDE AT FLOOR LEVEL EMERGENCY LIGHT IS OUT. RELAMPED EMERGENCY LIGHT. TESTED GOOD.SDR UALA2009020200360Anti-Ice Valve · failedEAI ON LEFT ENG FAILED TO OPEN. REPLACED EAI VALVE. OPERATION CHECKS OKAY.SDR UALA2009013000329Extinguisher · leakingDOOR 4R WATER EXTINGUISHER HAS EVIDENCE OF LEAKING. CLEANED DOGHOUSE STORAGE AND REPLACED EXT.SDR UALA2009012800308Controller · failedTHREE RIGHT PACK WENT INOP.SDR UALA2009012800306Bearing · migratedNR 2 ENGINE AFT MOUNT CENTER LINK ASSY, MIDDLE BEARING IS MIGRATING. NR 2 ENGINE REMOVED FOR REPLACEMENT OF AFT LOWER ENGINE MOUNT. ENGINE TO BE REINSTALLED AFTER MOUNT REPLACEMENT. FOUND INBOARD AFT FLANGE BUSHING SCORED AND PITTED ON ENG SIDE OF MOUNT, RESDR UALA2009012800304Tube · brokenFOUND NR 3 BEARING VENT TUBE BROKEN NR 1 ENG. REPLACED TUBE.SDR UALA2009012800307Duct · crackedRT ENG BLEED AIR SUPPLY DUCT CRACKED AT CONN TO RT PACK SUPPLY LINE. NEW DUCT IN HAND, INSTALLING NOW. CLOSE UP TO FOLLOW. OPS CHECKS GOOD AFTER REPLACEMENT OF RT ENG BLEED AIR SUPPLY DUCT DUE TO CRACKS.SDR UALA2009012700301Connector · unsecureEMERGENCY EXIT EEL LIGHT INOP AT SEAT 3F AFT LIGHT ASSY. SECURED CONNECTOR, OPS CHECKS NORMAL.SDR UALA2009012700300Connector · looseEMERGENCY EXIT EEL LIGHTS INOP AT SEAT 1E BOTH FWD AND AFT LIGHT ASSY'S. SECURED CONNECTOR. OPS CHECKS NORMAL.SDR UALA2009012700299Lamp · inoperativeEMERGENCY EXIT LIGHT INOP AT LAV 133 LOWER OUTBOARD LIGHT. RELAMPED EMERGENCY LIGHT, OPS NORMAL.SDR UALA2009012700298Light · inoperativeEMERGENCY EXIT LIGHT INOP AT SEAT 18G. RELAMPED EMERGENCY LIGHT, OPS NORMAL.SDR UALA2009012700297Light · inoperativeEMERGENCY EXIT EEL LIGHT INOP AT SEAT 3E AFT LIGHT ASSY. REPLACED LIGHT ASSY, OPS CHECKS NORMAL.SDR UALA2009012700294Battery Pack · dischargedDOOR 4 RT EPAS WILL NOT TEST. REPLACED EPAS BATTERY AND BACKUP BATTERIES PER MM 52-11-20. OPS CHECK GOOD.SDR UALA2009012600283Control Unit · faultyFLIGHT CONTROL SYS NR 4 AND 11 SPOILERS. REPLACED ACE L2. PERFORMED MAT GROUND TEST SPOILER 4 AND 11 SYSTEM. TEST PASSED. MSG CLEARED.SDR UALA2009012700288Light · inoperativeSEAT 3F ON ARMREST RT AFT EMERGENCY LIGHT INOP. REPLACED EEL LIGHT ASSY AND CHECKED OKAY.SDR UALA2009012600281Module · faultyRT AIMS IOM 8 INTERNAL FAULT. TRIED NEW CPM-BASIC,CPM-AC MF,CPMGG-M010 ANDM011, NO HELP. REINSTALLED ALL ORIGINAL MODULES. REPLACED ASG A15 CARD. STATUS MESSAGES GONE. ALSO NEW IOM008. BEGAN WIRE RINGOUTS OF LM8174. FOUND RED WIRE AT TB2302-UA65 SETS GRSDR UALA2009012600266Reservoir · faultyFOUND DOOR 3R EPAS RESERVOIR SQUIB PIN REMOVED RESERVOIR. INSTALLED SERVICEABLE 3R EPAS RESERVOIR.SDR UALA2009012300255Wire · brokenPRIOR TO DEPARTURE, CREW CALL, RIGHT FCV MSG DISPLAYED ON EICAS. ACCOMPLISHED MAT TEST 2X FAILED 2X. LOCKED OUT RIGHT LOWER FLOW CONTROL VALVE PER MEL. RIGHT LWR FLOW CONTROL VALVE LOCKED CLOSED. REPLACED LOWER FCV-RIGHT PACK. FOUND AND REPAIRED BROKEN GRSDR UALA2009012300258Skin · damagedRT FUSELAGE EXTERNAL SURFACE HAS A PROTRUSION AT BS 2252, 3 INCHES ABOVE STR-45R, S:1 X 1 INCH. CUT OUT DAMAGED AREA, HFEC INSP NO CRACK FOUND. REPAIRED AREA PER SRM 53-00-01, PART 2, AND 777EN-53-0400-02.SDR UALA2009012200237Cable · stiffDOOR 3R ARM-DISARM STIFF. ACP CABLE REPLACEMENT. INSP ACCOMPLISHED. ACTUATION FORCE NORMAL. WORKED WITH DOOR LINER REMOVE AND REPLACE.SDR UALA2009012200236Light · inoperativeSEAT 19C EEL LIGHT INOP. REPLACED EEL LIGHT ASSY.
Back to Boeing 777-222