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 AALA201802209049Battery Pack · inoperativeDURING OPERATIONAL TEST OF EPL TAILCONE SLIDE, THE EMERGENCY LIGHTS INOPERATIVE. THE AIRCRAFT WAS GROUNDED. REMOVED AND REPLACED THE BATTERY PACK ASSEMBLY B5-27 IAW WDM 33-51-13. OPS CHECKED GOOD.SDR AALA201802209036Rod · missingEMERGENCY LIGHTS DID NOT ARM WHEN SWITCH GUARD WAS CLOSED. MAINTENANCE TROUBLESHOT THE SYSTEM, AND FOUND EMERGENCY LIGHT ARM SWITCH ROD MISSING, REPLACED THE PANEL ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW AMM 33-50-00.SDR ASAA2018022023615Lens · unsecureFA REPORTS OVERHEAD EXIT SIGN COVER ABOVE L2 DOOR IS NOT SECURE. GROUNDED - YES. REINSTALLED EXIT SIGN COVER L2 DOOR.SDR SWAA2018022019867Light · inoperativeLT EMERGENCY AISLE LIGHT INOP AT ROW 7. R&R LIGHT IAW AMM.SDR REXA2018021600129Light · inoperativeLEFT FWD EMERGENCY LIGHT OUT (EXTERIOR PAX DOOR). RELAMPED LEFT FWD EMERGENCY LIGHT (EXTERIOR PAX DOOR) IAW AMM 33-51-21. OPS CHECK GOOD.SDR QXEA2018022000062Light · looseEMERGENCY LIGHT STRIP AT ROW 2D IS LOOSE. SECURED THE LIGHT STRIP. CHECKED GOOD. RETURNED TO SERVICE.SDR AALA201802199074Lens · missingSEAT 7C EMERGENCY LIGHT LENS MISSING. INSTALLED THE LENS IAW 33-50-00.SDR SWAA2018021919850Lens · missingRIGHT OVERWING EMERGENCY EXIT SIGN LENS MISSING. INSTALLED THE LENS IAW SIP.SDR DALA2018021901003Light · missingDURING A SERVICE CHECK, FOUND THE EMERGENCY LIGHT AT SEAT 19AB MISSING. INSTALLED A NEW LIGHT SECTION. CHECKED OK.SDR SIMA20180216002Lamp · inoperativeRIGHT EXTERNAL OVERWING EMERGENCY LIGHT FAILED TO ILLUMINATE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-10. OPS CHECKED GOOD.SDR SIMA20180216001Bulb · not seatedRIGHT AFT OVERWING EXIT LIGHT INOPERATIVE. REMOVED, RESEATED AND REINSTALLED THE BULB IAW AMM 33-50-10 . OPS CHECKED GOOD.SDR IPXA2018021626593Bulb · inoperativeEMERGENCY LIGHT HAS THREE INOPERATIVE BULBS. REPLACED THE BULBS IAW AMM 33-51-01-2.SDR GLBA2018021900702Sign · unsecurePILOTS NOTED THAT THE EMERGENCY EXIT SIGN AT ROW 8 WON'T STAY ATTACHED.SDR DALA2018021600964Battery Pack · inoperativeCEILING EMERGENCY LIGHTS ROWS 22 TO 26 INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK B5104 IAW AMM 33-53.SDR MASA2018021612986Bulb · inoperativeROW 15 EMERGENCY FLOOD LIGHT INOPERATIVE. REPLACED THE BULB.SDR CALA2018021600668Lens · deformedSEAT 49G & 25D EMERGENCY LIGHT LENS DEFORML. REPAIRED THE LIGHT HOUSING AND SECURED LENS OKSDR CALA2018021600667Lens · missingSMALL EMERGENCY EXIT LIGHT BELOW EXIT SIGN ON THE R1 DOOR MISSING THE LENS. REPLACED THE LENS, OPS CHECKED NORMALSDR CALA2018021600665Power Supply · faultedDURING A NR 2 SERVICE EMERGENCY LIGHT CHECK, FAULTED TO THE LT OVERWING POWER SUPPLY UNIT. REPLACED THE POWER SUPPLY AND BATTERY IAW MM 33-51-38, NO FAULTS NOTED.SDR CALA2018021600664Battery Pack · no testDURING AN EMERGENCY LIGHT CHECK, FAULTED TO THE FWD LT POWER SUPPLY BATTERY. REPLACED THE BATTERY PACK IAW MM 33-51-38, NO FAULTS NOTED.SDR CALA2018021600663Lens · brokenEMERGENCY LIGHT LENS BROKEN ON AFT SIDE OF 1L CLOSET DOOR. REPLACED THE LENS.SDR CALA2018021600662Lens · crackedFLOOR EMERGENCY LIGHT LENS CRACKED, AFT OF THE FWD CLOSET, FWD OF SEAT 1B. REPLACED THE LENS.SDR CALA2018021600660Lamp · inoperativeREAR INTERIOR EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMPS. OPS CHECKED GOOD.SDR CALA2018021600659Sign · inoperativeR2 DOOR FLOOR EMERGENCY EXIT SIGN L1191 INOPERATIVE. REPLACED THE SIGN IAW AMM 33-51-01. OPS CHECKED OK.SDR CALA2018021600658Battery Pack · inoperativeFWD LT AND RT DOORS EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED THE BATTERY PACKS AND THE LIGHTS WORKS NORMAL.SDR CALA2018021600657Lens · missingEMERGENCY EXIT LIGHT LEFT OF FIRST CLASS CLOSET MISSING THE LENS. REPLACED THE LENS, AND OPS CHECKED GOOD.SDR CALA2018021600656Light · inoperativeSEAT 15C EMERGENCY EXIT LIGHT NOT WORKING. THE EMERGENCY LIGHT WAS REPLACED.SDR CALA2018021600655Lamp · inoperativeOVERHEAD EMERGENCY LIGHT INOPERATIVE AT SEAT 20 ABC. REPLACED THE LAMPS IAW AMM 33-51-03. OPS NORMAL.SDR CALA2018021600651Lamp · inoperativeLEFT BULB INOPERATIVE ON THE UNARMED LIGHT. REPLACED THE LAMP. OPS CHECKED GOOD.SDR CALA2018021600650Lens · detachedRIGHT OVERWING EMERGENCY EXIT SIGN LENS DETACHED DURING LANDING. REPLACED THE SIGN IAW AMM 33-51-01.SDR CALA2018021600649Housing · faultyAFT RIGHT DOOR EXTERIOR EMERGENCY LIGHT IS OUT REPLACED LIGHT BASE . LIGHT CHECKED GOOD. WDM 33-51-15SDR CALA2018021600648Contactor · dirtyR2 DOOR EXTERIOR EMERGENCY LIGHT IS INOPERATIVE. CLEANED THE CONTACTOR . LIGHTS OP CHECKED GOOD IAW 33-51-201-962-001.SDR CALA2018021600646Socket · damagedEMERGENCY LIGHT NEAR SEAT 1K FOUND DAMAGED. REMOVED AND REPLACED THE SOCKET ASSY AND INSTALLED NEW LENS.SDR CALA2018021600645Light · inoperativeCROSS AISLE FLOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LIGHT ASSY. OPS CHECKED NORMAL. OK FOR SERVICE.SDR CALA2018021600644Lens · missingLENS MISSING FOR THE CEILING EMERGENCY LIGHT AT 29B. REPLACED THE LENS.SDR CALA2018021600617Power Supply · faultyEMERGENCY LIGHT ABOVE SEAT 16C INOPERATIVE. REPLACED THE POWER SUPPLY AND EMERGENCY LIGHTS CHECKED NORMAL IAW AMM 33-51-00.SDR MASA2018021612985Light · inoperativeOVERHEAD EMERGENCY FLOOD LIGHT AT ROW 18 INOPERATIVE.SDR DALA2018021600936Light · inoperativeEMERGENCY LIGHTS ON CEILING PANELS FROM ROW 14-20 INOP. EXTERNAL EMERGENCY LIGHTS INOP. REPLACED PART NUMBER AD4002P FOR CEILING EMERGENCY LIGHTS. REMOVED AND REPLACED PART NUMBER AD-3110 FOR EXTERNAL EMERGENCY LIGHTS REF AMM 33-53-00. OPS CHECK GOOD.SDR K11A201806113011Battery Pack · no testEMERGENCY LIGHT BATTERY PACK M1133 FAILED AN EMERGENCY LIGHTS FUNCTIONAL TEST.SDR AALA201802209032Control Unit · faultyAIRCRAFT WAS NOT GROUNDED: WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT CONFIGURATION DID NOT AGREE WITH OTHER WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNITS. MAINTENANCE REPLACED WIRELESS CONTROL UNIT PER AMM 33-51-07 AND ACCOMPLISHED SOFTWARE LOAD AND CSDR AALA201802169010Lens · detachedEMERGENCY LIGHT LENS ON SEAT 3C CONSOLE, CAME OFF. REPLACED THE EMERGENCY LIGHT ASSEMBLY. CHECKED GOOD.SDR ASAA2018021523601Lens · detachedEMERGENCY LIGHT LENS AT 16A DETACHED. ACFT GROUNDED. INSTALLED THE LENS.SDR AALA201802199033Lens · detachedTHE EXIT SIGN FOR THE L1 DOOR FELL OFF. ATTACHED THE LENS. OK FOR SERVICE.SDR AALA201802199077Sign · unsecureOVERWING AISLE EXIT LIGHT WOULD NOT STAY IN PLACE. MAINTENANCE REPLACED THE SIGN ASSEMBLY IAW AMM 33-51-01, AND PERFORMED A SATISFACTORY OPS CHECK.SDR SWAA2018022019920Light · missingCEILING PANEL EMERGENCY LIGHT ASSEMBLY MISSING AT BS 898, BL 0. INSTALLED LIGHT ASSEMBLY PER SOPM.SDR SWAA2018022019874Lens · brokenR2 DOOR THRESHOLD EMERGENCY EXIT LIGHT LENS BROKEN. R & R THE LENS IAW AMM.SDR SWAA2018022019873Cover · looseFORWARD GALLEY EMERGENCY EXIT LIGHT COVER LOOSE. R&R COVER PER AMM.SDR AALA201802199039Lens · missingAIRCRAFT WAS NOT GROUNDED. 4L DOOR EXIT LIGHT LENS MISSING. INSTALL EXIT LIGHT LENS 4L DOOR.SDR SWAA2018021919857Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK AT M01675. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018021919856Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK AT M01674. R & R THE BATTERY PACK IAW AMM.SDR SWAA2018021919855Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED A CAPACITY CHECK AT M01673. R & R THE BATTERY PACK IAW AMM.
Back to JASC 3350