JASC 3350
Service difficulty reports · 225,886
Reports filed under 3350 · Emergency Lighting, 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 jasc_code = '3350' 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 jasc_code = '3350' 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 AALA202202014716None · noneAIRCRAFT WAS NOT GROUNDED: SEAT 19C EMERGENCY AISLE LIGHT DETACHED. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR AALA202202010335Support · looseAIRCRAFT WAS NOT GROUNDED: ESCAPE PATH LIGHT AT SEAT 14C IS LOOSE. SECURED SEAT 14C LIGHT SUPPORT PER AMM 20-50-11. AIRCRAFT OK FOR SERVICE.SDR SIMA20220131002None · noneAFT CABIN EMERGENCY FLASHLIGHT MISSING ORG LOG PAGE 4799117 ITEM #1 REF MEL 25-32 AUTH # 010400M-C/A-INSTALLEED EMERGENCY FLASHLIGHT IAW AML 33-50-16 OPS CHECK GOOD MEL RESTOREDSDR SIMA20220131001None · noneFA EMERGENCY FLASHLIGHT HOLDER BRACKET CRACKED-C/A-RAR FA FLASHLIGHT HOLDER BRACKET IAW EMB 145 CMM 25-60-14.SDR 2022FA0000068None · noneRW13 LWR EXIT SIGN LT BULBS INOP. RELAMPED, OPS CHECK GOOD.SDR WX0A2022013173949Connector · dirtyCIDS1 EPSU SYS TEST 13 WL / REMOVED AND CLEANED CONNECTOR AT 13WL AND MESSAGE CLEARED FROM CIDS1; TEST OK REF TC 05-000-002 AND AMM 33-51-00. ALSO REF ESPM 20-55-40."SDR HALA2022013100032None · noneSHIP 391 EXIT SIGN ABOVE 3L DOOR FELL OFF. CORRECTIVE ACTION: RESECURED SIGN. (8456199)SDR CALA2022013100278Light · missingCAB SEAT 39D EMERGENCY LIGHT MISSING REF TO HAECO NON-ROUTINE NO .9475552, ORIGINATED BY EMP V903194, SPEC NO.B787-33-3-0002. PERFORMED BY EMP V903194 AND IDT BY EMP V903667 - REPLACED THE E MERGENCY LT AND CONDITIONAL CHK ''NORMAL'' AND FUNCTION TEST ''NORM ASDR CALA2022013100277Light · faultyCAB SEAT 5F FWD EMERGENCY LIGHT MALFUCNTION REF TO HAECO NON-ROU TINE NO.9475553, ORIGINATED BY EMP V903194, SPEC NO.B787-33-3-00 02. PERFORMED BY EMP V903194 AND IDT BY EMP V903667 - REPLACED THE S EAT 5F FWD EMERGENCY LT AND CONDITIONAL CHK ''NORMAL'' AND FUSDR CALA2022013100275Light · crackedCAB DR3 FWD GALLEY G9B LH AFT EMERGENCY LIGHT CRACK REF TO HAECO NON-ROUTINE NO.9475558, ORIGINATED BY EMP V903194, SPEC NO.B787- 33-3-0002. PERFORMED BY EMP V903194 AND IDT BY EMP V903667 - REPLACED THE E MERGENCY LT AND CONDITIONAL CHK ''NORMAL'' AND FUNCTIOSDR CALA2022013100274Light · crackedCAB DR3 FWD GALLEY G9B LH FWD EMERGENCY LIGHT AND BASE CRACK REF TO HAECO NON-ROUTINE NO.9475563, ORIGINATED BY EMP V903194, SPE C NO. B787-33-3-0002. PERFORMED BY EMP V903194 AND IDT BY EMP V903667 - REPLACED DR3 F WD GALLEY G9B LH FWD EMERGENCY LT AND CONDITSDR CALA2022013100273Light · crackedCAB DR3 FWD GALLEY G9B RH AFT EMERGENCY LIGHT CRACK REF TO HAECO NON-ROUTINE NO.9475568? ORIG CAB DR3 FWD GALLEY G9B RH AFT EMERGENCY LIGHT CRACK REF TO HAECO NON-ROUTINE NO.9475568, ORIGINATED BY EMP V903194, SPEC NO.B787 -33-3-0002. PERFORMED BY EMP V903194 SDR SWAA2022020365603Light · inoperativeAFT SERVICE DOOR EMERGENCY LIGHT STRIP HAS 1 LAMP INOP. ; / [01] RELAMPED AFT SERVICE DOOR EMERGENCY LIGHT STRIP LAMP PER AMM 33-51-01. OPS CHECK GOOD AT THIS TIME.SDR SWAA2022020365644Light · inoperativeRT EXTERIOR EMERGENCY LIGHT JUST FWD OF AFT CARGO DOOR INOP ; / [01] RELAMPED RT EXTERIOR EMERGENCY LIGHT NEAR AFT CARGO DOOR IAW AMM 33-51-04SDR SWAA2022020365797Light · missingFWD EMERGENCY LIGHT COVER MISSING ; / [01] REPLACED FWD EMERGENCY LIGHT COVER PER AMM 33-51-03SDR DALA2022020100655None · noneSHIP 6705 EMERGENCY EXIT COVER NEEDS RE INSTALLED IN AFT GALLEY. CORRECTIVE ACTION: EMERGENCY LIGHT COVER IN AFT GALLEY IAW B757 AMM 33-51. (8234764)SDR DALA2022020100654None · noneSHIP 689 EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:604. CORRECTIVE ACTION: REATTACHED EMERGENCY LENS COVER. (2104195)SDR AALA202202015584Battery · failedAIRCRAFT WAS NOT GROUNDED: BATTERY OF THE EMERGENCY POWER SUPPLY UNIT 13WL FAILED BUILT IN TEST EQUIPMENT TEST. REMOVED AND REPLACED TC330097 BATTERY OF THE EMERGENCY POWER SUPPLY UNIT 13WL PER AMM 33-51-38.SDR DXTA2022013156000Switch · defectiveEMERG LIGHT SWITCH: ON THE OVERHEAD PANEL, THE EMERGENCY LIGHTS ON SWITCH CAPSULE HAS NO INDICATION OF "LIGHTS" DURING THE SYSTEM TEST OR WHEN THE CAPSULE IS PRESSED. THERE IS NO OTHER INDICATION OF THIS SYSTEM IN THE COCKPIT PER MEL 33-22.// SIGNOFF// REMOVEDSDR AALA202201312846Housing · detachedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT PANEL UNDER SEAT 8C IS OFF AND ON THE FLOOR. RE-INSTALLED EMERGENCY LIGHT HOUSING ASSEMBLY AND ACCOMPLISHED A SATISFACTORY OPERATIONAL CHECK PER AMM 33-50-00 AND AMM 25-21-00.SDR WX0A2022013173948Epsu · failed inspBATTERY FAILED TEST / REMOVED AND REPLACED BATTERY IAW 33-51-38-400-002A. NO DEFECTS NOTED"SDR WX0A2022013173947Epsu · failed inspBATTERY FAILED TEST / REMOVED AND REPLACED BATTERY IAW 33-51-38-400-002A. NO DEFECTS NOTED"SDR WX0A2022013173946Epsu · failed inspBATTERY FAILED TEST / REMOVED AND REPLACED EPSU IAW 33-51-38-400-002A. NO DEFECTS NOTED"SDR WX0A2022013173945Epsu · failed inspBATTERY TEST FAIL / REMOVED AND REPLACED EPSU IAW 33-51-38-400-002A. NO DEFECTS NOTED"SDR DALA2022013100583None · noneTHE EMERGENCY EXIT EVACUATION LIGHTS ARE INOPERATIVE. MAINTENANCE REPLACED THE OVERWING EMERGENCY EXIT EVACUATION LIGHT BATTERY PER B717 AMM 33-51. OPERATIONAL CHECK WAS GOOD. (LP #8125023)SDR 2022FA0000051None · noneALL EMER LIGHTS INOP. CHARGED EMER BATTERIES- OP GOOD.SDR AALA202202276702Connector · looseAIRCRAFT WAS NOT GROUNDED: LH AFT OVERWING EMERGENCY LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT: SECURED LOOSE CONNECTOR IAW WDM 33-51-13 AND AMM 33-51-06, OPS CHECK GOOD.** (CLOSED)SDR FDEA202201290176None · noneMDIS 901 33-50 4826 28JAN22 MUC FACT U DOOR 1R EXTERIOR EMERGENCY LIGHT / SLIDE LIGHT INOP FACT 29JAN22 12:08 MUC U DOOR 1R EMERGENCY LIGHT / SLIDE LIGHT REPLACED ACC AMM 33-51-06-2-1 (REV 129.0)SDR SWAA2022020265258Light · inoperativeAFT SERVICE DOOR EMERGENCY LIGHT STRIP HAS 1 LAMP INOP. ; / [01] REPLACED AFT SERVICE DOOR EMERGENCY LIGHT STRIP LAMP PER AMM 33-51-01. OP CHECK GOOD AT THIS TIME.SDR SWAA2022020265259Light · inoperativeSEAT 8DEF EMERGENCY LIGHT INOP. ; / [01] RELAMPED IAW AMM 33-51-03SDR SWAA2022020265518Light · missingEMERGENCY EXIT ?NOT ARMED? ANNUNICATOR LIGHT MISSING ; / [01] INSTALLED NEW EMER EXIT LIGHT NO ARMED KORRY LIGHT PER 33-18-00 (AMM)SDR AALA202202016702None · noneAIRCRAFT WAS NOT GROUNDED: LH AFT OVERWING EMERGENCY LIGHT INOPERATIVE. **SUPPLEMENTAL REPORT WILL BE SUBMITTED.** (OPEN)SDR SWAA2022020165894Light · inoperative*CUSTOMER REQUEST* LH OVER WING EMERGENCY EXIT SIDEWALL LIGHT IS OUT. ; / [01] REMOVED AND REPLACED WINDOW LIGHT LAMP AS PER REF. B737 AMM 33-21-00-960-801. PERFORMED OPS CHECK AND FOUND NORMAL; [02] REMOVED AND REPLACED LH OVERWING EMERGENCY EXIT WINDOW LIGHTSDR SWAA2022020166327Power Supply · faultedSMOKE IN AFT GALLEY AFTER TAKE OFF. SMOKE CAME FROMF.O. SIDE WORK LIGHT IN GALLRY. EMER EXIT LIGHTS IN AFT GALLEY AND AIRCRAFT LIFT SIDE ILLIMINATED TURNED OFF ON THEIR OWN. ALL ENGINE PARAMETERS ; NORMAL NO INDICATIONS IN COCKPIT / [01] C/W SMOKE AND FUME IN SDR SWAA2022020165304Battery · faultedSMOKE IN AFT GALLEY AFTER TAKE OFF. SMOKE CAME FROMF.O. SIDE WORK LIGHT IN GALLRY. EMER EXIT LIGHTS IN AFT GALLEY AND AIRCRAFT LIFT SIDE ILLIMINATED TURNED OFF ON THEIR OWN. ALL ENGINE PARAMETERS ; NORMAL NO INDICATIONS IN COCKPIT / [01] C/W SMOKE AND FUME IN SDR SWAA2022020166328Battery · faultedSMOKE IN AFT GALLEY AFTER TAKE OFF. SMOKE CAME FROMF.O. SIDE WORK LIGHT IN GALLRY. EMER EXIT LIGHTS IN AFT GALLEY AND AIRCRAFT LIFT SIDE ILLIMINATED TURNED OFF ON THEIR OWN. ALL ENGINE PARAMETERS ; NORMAL NO INDICATIONS IN COCKPIT / [01] C/W SMOKE AND FUME IN SDR ASAA2022012937305Unknown · unknownF/A REPORTS THE EXIT SIGN AT ROW 16ABC POPPED OFF. GROUNDED - YES. SECURED EXIT SIGN AT ROW 16 ABC BY TIGHTENING HARDWARE REF B737-900 AMM TASK 33-51-02. OPS CHECK GOOD.SDR DALA2022013100614None · noneSHIP 3301 EMER ESCAPE PATH LIGHTS INOP AT10B, 11B, 16B, 18B, 19B, 14H, 15H ,20H. CORRECTIVE ACTION: FOUND CONNECTERS LOOSE ON ALL SEATS NOTED. RESECURED ALL. (8144156)SDR AALA202201317955Powerpack · inoperativeAIRCRAFT WAS NOT GROUNDED: GALLEY 3 FLOOR PROXIMITY EMERGENCY LIGHT INOPERATIVE. REPLACED INOPERATIVE LAMP (AALA202201312078) AND REPLACED INOPERATIVE POWER PACK (AALA202201317955) PER AMM 33-51-05 AND AMM 33-51-06.SDR AALA202201312078Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: GALLEY 3 FLOOR PROXIMITY EMERGENCY LIGHT INOPERATIVE. REPLACED INOPERATIVE LAMP (AALA202201312078) AND REPLACED INOPERATIVE POWER PACK (AALA202201317955) PER AMM 33-51-05 AND AMM 33-51-06.SDR IXXA202201287004Battery Pack · inoperativePRE-DEPARTURE: EMERGENCY EXTERIOR LIGHT FAILS ON TEST. REMOVED AND REPLACED EXTERIOR LIGHT BATTERY PACK ASSEMBLY IAW B767 AMM 33-51-07. OPERATIONAL CHECK GOOD. FAULT NOT DUPLICATED.SDR AALA202202287851Light · inoperativeAIRCRAFT IN BASE MAINTENANCE: CEILING EMERGENCY LIGHT IN FRONT OF MID LAVATORY IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202201317851: LIGHT REPLACED.** (CLOSED)SDR AALA202202285104Sign · inoperativeAIRCRAFT IN BASE MAINTENANCE: CEILING EMERGENCY EXIT SIGN FACING AFT BETWEEN L3 AND R3 DOORS IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202201315104: REPLACED SIGN.** (CLOSED)SDR AALA202202243889Sign · misinstalledAIRCRAFT IN BASE MAINTENANCE: R3 DOOR UPPER EMERGENCY EXIT SIGN IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202201313889: REMOVED AND REINSTALLED SIGN PER AMM 33-51-16. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** CLOSED)SDR AALA202202240791Sign · misinstalledAIRCRAFT IN BASE MAINTENANCE: R3 DOOR LOWER EMERGENCY EXIT SIGN IS INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202201310791: REMOVED AND REINSTALLED SIGN PER AMM 33-51-16. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR AALA202202233421Wire · looseAIRCRAFT IN BASE MAINTENANCE: L3 DOOR BOTTOM EXIT SIGN INOPERATIVE. **SUPPLEMENTAL REPORT FOR AALA202201313421: SECURED LOOSE WIRES. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.** (CLOSED)SDR DALA2022020100658Light · inoperative(LOG 8224324) DURING INSPECTION FOUND FWD EMERG. LIGHT ON SEAT 1DC INOP. R/R FWD EMERG LIGHT ON 3DC PER B737 AMM 33-51. OPS CHECKS GOOD.SDR SWAA2022020165078Light · inoperativeCABIN EMERGENCY LIGHTS HAVE BULBS OUT ABOVE BIN 9 AND 12 ON LEFT SIDE AND FLIGHT DECK EMERGENCY DOME LIGHT OUT.SDR SWAA2022020164877Bulb · inoperativeLH OVERWING EXIT EMERGENCY SIGN HAS ONE LIGHT INOP. ; / [01] RELAMPED LH OVERWING EXIT EMERGENCY SIGN AFT BULB IAW AMM 33-51-01.SDR SWAA2022020165103Power Supply · faultyFWD EMERGENCY CABIN LIGHTS INTERMITTING ; / [01] R AND R L/H FWD POWER SUPPLY ASSY. R AND R L/H AND R/H BATTERY PACK REF AMM 33-51-06
Back to JASC 3350