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 AALA201712059074Light · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHT ON THE AFT LEFT LAVATORY IS INOPERATIVE. RELAMPED LIGHT PER AMM 33-51-18. OPERATIONAL CHECK GOOD.SDR AALA201712049033Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 9 RIGHT HAS A MISSING LENS COVER. REMOVED AND REPLACED LIGHT FITTING. OPERATIONAL CHECK PER AMM 33-51-18-400-001-A GOOD.SDR AALA201712049032Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 8 RIGHT SIDE HAS A BROKEN LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-18. OPERATIONAL CHECK GOOD.SDR AALA201712049031Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT SEAT 2 LEFT SIDE HAS A BROKEN LENS COVER. REMOVED AND REPLACED LIGHT ASSEMBLY PER AMM 33-51-18. OPERATIONAL CHECK GOOD.SDR AALA201712049028Lens · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY SEAT 26C AISLE HAS A BROKEN LENS COVER. REMOVED AND REPLACED LENS COVER. OPERATIONAL CHECK GOOD.SDR SWAA2017120518256Battery Pack · inoperativeRT OVERWING EXIT EMERGENCY BATTERY PACK INOP. R&R BATTERY PACK PER MM.SDR SWAA2017120518254Battery Pack · inoperativeL/H OVERWING EXIT EMERGENCY BATTERY PACK INOP. / R&R BATTERY PACK PER MM.SDR SWAA2017120518253Cover · missingAFT GALLEY EMERGENCY EXIT LIGHT SWITCH MISSING COVER. / INSTALLED COVER PER MM.SDR DALA2017120408427Battery Pack · inoperative(AIRCRAFT 5806, L/P 3556742) PAX SEATS ROWS 36 THRU 40 EMERG. LIGHT PATH INOP. REMOVED AND REPLACED EMERG. BATT. PACK M11082 PER B757 AMM 33-53.SDR HALA2017120400268Lens · missingOVERHEAD AISLE EMERGENCY LIGHT AT ROW 25 LEFT MISSING LENS. INSTALLED NEW LENS.SDR ASAA2017120222758Power Supply · failedEMERGENCY EXIT AREA LIGHTS AT ROWS 28DEF AND ROW 30 DEF ARE INOP. RELAMPED-NO HELP. GROUNDED - YES. REMOVED AND REPLACED EMERGENCY EXIT AREA LIGHTS POWER SUPPLY FOR ROWS 28DEF AND ROW 30 DEF. REF B737-900 AMM 33-51-06-960-806. OPS CHECK GOOD. SYSTEM RETURNED TSDR ASAA2017120222746Lamp · failedL1 SLIDE EMERGENCY LIGHT INOP. GROUNDED - YES. RELAMPED L1 SLIDE EMERGENCY LIGHT IAW B737-800 AMM 33-51-04-960-801. OPS CKS GOOD.SDR DALA2017120408413Power Supply · inoperativeSEATS 24DE-30DE EMERG LIGHTS INOP. R/R EMERG LIGHTS POWER SUPPLY PER AMM 33-51. OPS CHK GOOD. (LP3546186)SDR DALA2017120408408Lamp · inoperativeRED EMERGENCY LIGHT AT EXIT ROW 24 DE INOP. RELAMPED OP CKS OK. (LP3358413)SDR SIMA20171202004Bulb · inoperativeLH OVER WING EXT EMER LIGHT INOP-C/A-RAR LH OVER WING EXT EMER LIGHT BULB IAW AMM 33-51-15. OPC GOODSDR DALA2017120208406Battery Pack · dischargedDURING INSPECTION FOUND EMERGENCY 1ST CLASS ISLE LIGHTS BURNED OUT. MAINTENANCE REMOVED AND REPLACED RIGHT BATTERY PACK PER AMM 33-52.SDR CALA2017120204294Lens · missingEMERGENCY EXIT LIGHT ISLE PATH AT FRONT BULK HEAD LENS MISSING. REPLACED MISSING LENS.SDR MASA2017120212814Battery · dischargedAFT FACING EMER EXIT SIGN AT 1ST CLASS BULKHEAD INOP. CHARGED BATTERIES.SDR DALA2017120608474Holder · brokenEMERGENCY PATH LIGHTS AT 30B ARE BROKEN AND HANGING FROM THE SEAT. FOUND BROKEN SIDE PANEL WHICH HOLDS DIFFUSER COVER. REPLACED AISLE BUMPER TRIM AND EMERGENCY PATH LIGHT HOLDER. SYSTEM OPERATION IS NORMAL.SDR AALA201712059062Controller · faultedAIRCRAFT WAS NOT GROUNDED. AIRPLANE HEALTH MONITORING ALERT RECEIVED FOR CLASS 31 REMOTE WIRELESS EMERGENCY LIGHT SYSTEM CONTROL UNIT LAMP DRIVER POWER CIRCUIT FAILURE, FAULT CODE 33-11931. REMOVED AND REPLACED OVERHEAD FLIGHT ATTENDANT REST WELS REMOTE CONTSDR AALA201712059056Sign · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT SIGN BY THE L2 DOOR IS CRACKED. REMOVED AND REPLACED EXIT SIGN PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201712059054Lens · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EGRESS PATH LIGHT BY THE G5 GALLEY HAS A CRACKED LENS COVER. REPLACED EMERGENCY LUMINATOR PER CMM 33-50-18. OPERATIONAL CHECK GOOD.SDR SWAA2017120518252Light · delaminatedR/H AFT ESCAPE PATH LIGHT STRIP BY G3 GALLEY DELAMINATED. / R&R STRIP PER DWG.SDR SWAA2017120518251Lamp · dimR/H OVERWING EXIT SIDEWALL LIGHT DIM. / RELAMPED LIGHT PER AMM.SDR SWAA2017120518248Lamp · inoperativeR/H OVERWING EMERGENCY LIGHT INOP. / RELAMPED LIGHT PER AMM.SDR DALA2017120408428Fuse · inoperative(AIRCRAFT 6820, L/P 3969421) 27 EFD TO 31 EFD FLOOR PATH LIGHT WON'T ILLUM. REPLACED FUSE AND CKS OK PER B757AMM 33-51.SDR DALA2017120408424Connector · loose(AIRCRAFT 6704, L/P 0320392) SEAT ROW 43 R/H EMERGENCY LITES INOP. INSPECTED, RESECURED LOOSE CONNECTOR AT SEAT ROW 43 R/H EMERGENCY LITES. EMERGENCY LITES OP CHK NORMAL.SDR R61A201712010921Battery · inoperativeEMERGENCY LIGHT ON FLIGHT DECK DOESN'T TURN ON WHEN TESTED. R&R #2 RH FWD EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPS CHECK GOOD.SDR AALA201712049010Battery · faultyAIRCRAFT WAS NOT GROUNDED. FOUND FAULT ON EMERGENCY POWER SUPPLY UNIT. REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY AT MID CABIN PER AMM 33-51-38.SDR QXEA2017120400688Light · inoperativeCABIN EMERGENCY LIGHTING SWITCHLIGHT DOES NOT ILLUMINATE IN THE NORMAL POSITION. RE-LAMPED CABIN EMERGENCY LIGHTING SWITCHLIGHT. LAMP TEST GOOD, NO FURTHER DEFECTS NOTED. RETURNED TO SERVICE.SDR SWAA2017120418177Cover · missingRT OVERWING FORWARD EMERGENCY EXIT LIGHT LENS MISSING. INSTALLED COVER PER AMM.SDR SWAA2017120418176Lens · missingRT OVERWING EMERGENCY EXIT SIGN COVER LENS MISSING. INSTALLED LENS IAW AMM.SDR IPXA2017120124090Bulb · inoperativeINSPECTION TYPE:NAEMERG "UNARMED" ANN, 1 LAMP INOPREPLD BULB,BOTH BULBS ILLUM NORMALLY. OK FOR SVCESDR DALA2017120408411Battery Pack · failedDURING SVC CK- FOUND TWO CABIN EMERGENCY BATTERY PACKS BAD. REMOVED & REPLACED BATTERY PACKS AT SEAT ROWS 25 & 29 PER MD88 AMM 33-53. (LP3309106)SDR UIEA2017120402348Lamp · inoperativeEXTERNAL MAIN ENTRY DOOR LEFT SIDE EMERGENCY LIGHT INOP(<P>REMOVED AND REPLACED LAMP OPS CHECK GOOD. IAW AMM 33-51-00</P>)SDR UIEA2017120402349Charger · inoperativeEMERGENCY LIGHTS INOP AT SEATS 38H, 39H, 24H, 20C AND 21C(<P>REPLACED M734 BATTERY PACK CHARGER IAW 33-51-07</P>)SDR UIEA2017120402350Charger · inoperativeSMALL EMERGENCY LIGHT ABOVE AFT MOST LEFT SIDE EXIT DOOR INOP(<P>REPLACED M734 BATTERY PACK CHARGER IAW AMM 33-51-07. OPS CHECK NORMAL</P>)SDR UIEA2017120402351Charger · inoperativeEMERGENCY EXIT SIGN ABOVE AFT FLT ATTENDANT STATION INOP(<P>REPLACED M734 BATTERY PACK CHARGER. OPS CHECK NORMAL. IAW AMM 33-51-00</P>)SDR SIMA20171201003Inverter · inoperativeEMERGENCY FLOOR LIGHT STRIP #1 INOP.-C/A-REMOVED AND REPLACED #2 INVERTER IAW EMB 145 AMM 33-50-11 OPS CHECK GOODSDR SIMA20171201002Light · inoperativeOVERHEAD ENTRANCE EMERGENCY LIGHT INOP-C/A-REMOVED AND REPLACED OVERHEAD ENTRANCE EMERGENCY LIGHT OPC GOOD IAW EMB AMM 33-50-06SDR JJBA20171201001Bulb · inoperativePASSAGEWAY LIGHT ROW 18A INOP (EMG LIGHT). RR PASSAGEWAY LIGHT BULB AT ROW 18A OP CK SAT.SDR MASA2017120112813Light · inoperativeROW 18 OVHD EMER LIGHT INOP. PLACED ON MEL.SDR CALA2017120104254Light · inoperativeSEAT 20D EMERGENCY LIGHT INOP. REPLACED EPL AND HOUSING REF AMM DMC 33-51-06-00A-720A-A. OPS CHECKED GOODSDR CALA2017120104285Power Supply · no testRIGHT EMER LIGHT POWER SUPPLY FAILED SYSTEM TEST DURING 2 SERVICE CHECK. REPLACED RH EPSU REF AMM 33-51-38 OPS CHK OKSDR CALA2017120104283Lens · missingEMERGENCY LIGHT ELECTRICAL COVERS MISSING AT ROW 11,36 A INSTALLED EMERGENCY LIGHT ELECTRICAL COVERS AT ROW 11,36 ASDR CALA2017120104282Light · malfunctionedOVERHEAD EMERGENCY LIGHTS IN CABIN STUCK ON. UNDER TOMC GUIDANCE, CREW CYC H5, H6, H7 AND V7. LIGHTS REMAINED ON. CYC NO SMOKING SWITCH, LIGHTS WENT OUT.SDR CALA2017120104279Battery Pack · inoperativeFWD GALLEY DOOR EMERGENCY LIGHTS INOP REPLACED EMERGENCY POWER PACK BATTERY M730, OPS CHECK GOOD. MM 33-51-06.SDR CALA2017120104277Battery Pack · inoperativeWHILE WORKING EA 3351-01167 OP 7 L-2 DOOR LENS MOD STEP 12 REQUI RES OP CHECK OF EMERGENCY LIGHTS.L-2 DOOR FAILED.LIGHT DOES NOT COME ON AT ALL. REMOVED AND REPLACED BATTERY PACK AND CHARGER ASSY OPS CHECKS GOOD REF AMM 33-51-06.SDR CALA2017120104276Battery · inoperativeWHILE PERFORMING EA 3351-01167 LENS MOD OP6 R-2 DOOR STEP 12 REQUIRES OPS CHECK OF EMERGENCY LIGHTS.R-2 DOOR FAILED.LIGHT COMES ON THEN GOES RIGHT OUT. REMOVED AND REPLACED THE BATTERY ASSY OPS CHECKS GOOD REF AMM 33-51-06. ADD EMP:U335635SDR CALA2017120104275Bulb · inoperativeEMERGENCY EXIT SIGN DOES NOT TURN ON AFT CABIN FWD OHD STWG AFT EXIT LGT AT POS 422 HAS LGT BULB BURNED OUT. ALL EMER. LTS CHK OK
Back to JASC 3350