Boeing 777-323ER
Service difficulty reports · 1,557
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 = '777323ER' 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 = '777323ER' 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 AALA20131128005Light · missing4FRC FWD ESCAPE PATH LIGHT MISSING. REPLACED LIGHT ASSEMBLY FOR LAVATORY 4FRC ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMALSDR AALA20131128004Lens · missing4FLC FWD ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR 4FLC ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20131128003Lens · missingROW 16 CENTER DIVIDER RT HAND ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 16 CENTER DIVIDER RT HAND ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20131128002Lens · missingROW 16 CENTER DIVIDER LT HAND ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 16 CENTER DIVIDER LT HAND ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20131128001Lens · missingRT NR 1 DOOR RT HAND COMPARTMENT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR RT NR 1 DOOR RT HAND COMPARTMENT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20131120007Light · inoperativeLT NR 3 DOOR ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR LT NR 3 DOOR ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20131119013Lens · missingESCAPE PATH LIGHT AT 3FLC LAVATORY MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT 3FLC LAVATORY. OPERATIONS CHECKED NORMAL.SDR AALA20131113006Light · inoperativeLAVATORY 4FCL AFT EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LAVATORY 4FCL AFT EMERGENCY LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130924010Lens · missingEMERGENCY LIGHT AT LAVATORY 4F-LC FWD LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT LAVATORY 4F-LC. OPERATIONS CHECKED NORMAL.SDR AALA20130924009Lens · missingEMERGENCY LIGHT AT PARTY BAR DOOR 2 CENTER, LT HAND SIDE LOWER LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT PARTY BAR DOOR 2 CENTER, LT HAND SIDE LOWER LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130924008Lens · missingEMERGENCY LIGHT AT M2/M3 GALLEY DOOR 2 CENTER, AFT WALL SECOND TO LT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT M2/M3 GALLEY DOOR 2.SDR AALA20130924007Lens · missingEMERGENCY LIGHT AT M2/M3 GALLEY DOOR 2 CENTER, MID RT HAND MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT M2/M3 GALLEY DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20130924006Lens · missingEMERGENCY LIGHT AT M1/M2 GALLEY DOOR 2 CENTER, FWD RT HAND MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT M1/M2 GALLEY DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20130924005Lens · missingEMERGENCY LIGHT AT M1/M2 DOOR 2 CENTER, LT HAND CENTER MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT M1/M2.SDR AALA20130916009Light · inoperativeEMERGENCY LIGHT ASSEMBLY AT SEAT 39D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 39D. OPERATIONS CHECKED NORMAL.SDR AALA20130910012Lens · missingGALLEY RT HAND MIDDLE ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY RT HAND MIDDLE ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130910011Lens · missingGALLEY 4 RT AFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 4 RT AFT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130910010Lens · missingLAVATORY 4FRC FWD ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR LAVATORY 4FRC FWD ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130910009Lens · missingGALLEY 6 LT AFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY LT AFT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130910008Lens · missingGALLEY 6 RT AFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 6 RT AFT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130910007Lens · missingENTERTAINMENT GALLEY AFT RT LOWER MIDDLE ESCAPE PATH LIGHT MISSING LENS. REPLACE LENS FOR ENTERTAINMENT GALLEY AFT RT LOWER MIDDLE ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130910006Lens · missingENTERTAINMENT GALLEY FWD MIDDLE ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ENTERTAINMENT GALLEY FWD MIDDLE ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130910005Lens · missingGALLEY 5 RT AFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 5 RT AFT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130910004Lens · missingGALLEY 4 LT FWD ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 4 LT FWD ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904012Lens · missingGALLEY 5 RT WALL FWD ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 5 RT WALL FWD ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904011Lens · missingGALLEY 5 RT SIDE WALL MIDDLE ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 5 RT SIDE WALL MIDDLE ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904010Lens · missingGALLEY 5 RT SIDE AFT WALL MIDDLE ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 5 RT SIDE AFT WALL MIDDLE ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904008Lens · missingGALLEY 5 LT WALL FWD ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 5 LT WALL FORWARD ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904007Lens · missingGALLEY 5 LT WALL MIDDLE ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 5 LT WALL MIDDLE ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904006Lens · missingLAVATORY 3FLC FWD ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR LAVATORY 3FLC FWD ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904004Lens · missingGALLEY 6 RT WALL MIDDLE ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 6 RT WALL MIDDLE ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904003Lens · missingGALLEY 6 LT WALL AFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 6 LT WALL AFT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904002Lens · missingGALLEY 6 LT WALL MIDDLE ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 6 LT WALL MIDDLE ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904018Lens · missingLAVATORY 4FLC FWD ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR LAVATORY 4FLC FWD ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904017Lens · missingLAVATORY 4FLC AFT BULKHEAD WALL LOWER ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR LAVATORY 4FLC AFT BULKHEAD WALL LOWER ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904016Lens · missingLAVATORY 4FLC AFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR LAVATORY 4FLC AFT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904015Lens · missingLAVATORY 4FRC AFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR LAVATORY 4FRC AFT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904014Lens · missingGALLEY 4FRC FWD ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 4FRC ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130904013Lens · missingGALLEY 4 RT WALL FWD ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 4 RT WALL FWD ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130829013Lens · missingGALLEY 6 AFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 6 AFT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130829009Lens · missingMAIN DECK CREW REST LT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR MAIN DECK CREW REST LT ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130829008Lens · missing3FL BULKHEAD AFT WALL ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR 3FL BULKHEAD AFT WALL ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130829006Lens · missing4FRG FWD RT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR 4FRG ESCAPE PATH LIGHT. OPERATIONS CHECKED NORMAL.SDR AALA20130829020Lens · missing3FLC LAVATORY AFT CORNER ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR 3FLC LAVATORY AFT CORNER ESCAPE PATH LIGHT. OPERATION CHECKED NORMAL.SDR AALA20130829019Lens · missing3FRC LAVATORY AFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR 3FRC LAVATORY AFT ESCAPE PATH LIGHT. OPERATION CHECKED NORMAL.SDR AALA20130829018Lens · missingSNACK BAR LT SIDE LOWER ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SNACK BAR LT SIDE LOWER ESCAPE PATH LIGHT. OPERATION CHECKED NORMAL.SDR AALA20130829017Lens · missingSNACK BAR LT SIDE UPPER ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SNACK BAR LT SIDE UPPER ESCAPE PATH LIGHT. OPERATION CHECKED NORMAL.SDR AALA20130829016Lens · missingGALLEY 5 AFT WALL CENTER ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 5 AFT WALL CENTER ESCAPE PATH LIGHT. OPERATION CHECKED NORMAL.SDR AALA20130829015Lens · missingGALLEY 4 AFT RT SIDE ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 4 AFT RT SIDE ESCAPE PATH LIGHT. OPERATION CHECKED NORMAL.SDR AALA20130829014Lens · missingGALLEY 4 FWD LT SIDE ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR GALLEY 4 FWD LT SIDE ESCAPE PATH LIGHT. OPERATION CHECKED NORMAL.
Back to Boeing 777-323ER