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 SWAA2018111326723Power Supply · inoperativeRT WING EMERGENCY EXIT LIGHT INOP. R&R BATTERY POWER SUPPLY PER AMM.SDR SWAA2018111326722Power Supply · inoperativeRT OVERWING EXIT SLIDE LIGHT INOP. R&R BATTERY POWER SUPPLY PER AMM.SDR SWAA2018111326721Power Supply · inoperativeRT WING SIDEWALL SIGN LIGHT INOP. R&R BATTERY POWER SUPPLY PER AMM.SDR SWAA2018111326664Battery · dischargedR1 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY POWER SUPPLY PER AMM.SDR YENA2018110840768Bulb · inoperativeFT # 405, BOS-LGB. DURING SCHEDULED MX FOUND AFT BULB OF RH AFT OVERWING EMERGENCY LIGHT INOP (62WL); RELAMPED AFT BULB OF RH AFT OVERWING EMERGENCY LIGHT IAW AMM 33-51-15. OPS CHK NORMAL.SDR YENA2018110840767Light · brokenFT #319, FLL-SLC. SEAT 1C EMERGENCY EXIT LIGHT BROKEN ( FLOOR PROX EMERG ESCAPE PATH MARK SYS - INCANDESCENT LIGHTING SYS - NOT APPLICABLE TO (N703 AND UP) ); REPLACED EMERGENCY LIGHT HOUSING AT SEAT 2C, PER AMM 33-51-19. OPS CHECK OK. MX4 UPDATED, PLACARD RESDR SWAA2018110826616Battery Pack · dischargedR1 DOOR EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018110826615Battery Pack · dischargedR1 DOOR LOWER SIDEWALL EMERGENCY EXIT LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018110826602Battery Pack · dischargedRT EMERGENCY LIGHT INOP BETWEEN ROW 3 TO ROW 6. R&R BATTERY PACK PER AMM.SDR DALA2018110606492Switch · defectiveEMERGENCY LIGHTS ON IN ARMED POSITION. TRIED SEVERAL TIMES TO RESET. REPLACED EMERGENCY PATH LIGHTING SWITCH. OPERATION CHECKS OKAY.SDR AALA201811069020Light · damagedAIRCRAFT WAS NOT GROUNDED: EMERGENCY LIGHT DAMAGED AT 4L. MAINTENANCE REPLACED FIXTURE AT 4L PER 33-51-18 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018110526494Light · inoperativeAFT CENTERLINE EMERGENCY EXIT LIGHT INOP. R&R BULB PER AMM.SDR AALA2018110659055Lamp · inoperativeEMERGENCY LIGHT AT SEAT 1C WAS INOPERATIVE. REPLACED THE LAMPS, AND OPS CHECKED GOOD IAW AMM 33-51-19.SDR MASA2018110411501Light · inoperativeROW 6 OVHD EMER LIGHT INOP. RELAMPED.SDR MASA2018110411497Light · inoperativeONE BULB INOP FLOOR EMER SIGN ROW 13. PLACED ON MEL.SDR MASA2018110411496Light · inoperativeONE BULB INOP FLOOR EMER SIGN ROW 14. PLACED ON MEL.SDR R61A201811031151Light · inoperativeDOOR L2 EMERGENCY EXIT IDENTIFIER LIGHT ONLY HALF ILLUMINATED. REMOVED P/N 4028-10 AND REPLACED WITH P/N 4028-20 PER AMM 33-50-15-400-801.SDR REXA201811091072Bulb · inoperativeEMERGENCY ESCAPE LIGHT AT PASS DOOR (LOWER) HAS BULBS OUT
RELAMPED FLOOR LEVEL EMERGENCY FLOOD LIGHT IAW AMM 33-51-11SDR SWAA2018110826618Light · inoperativeRT EMERGENCY LIGHTS INOP. REPAIRED LIGHT PER AMM.SDR SWAA2018110826601Light · inoperativeLT EMERGENCY LIGHTS INOP. REPAIRED LIGHT PER AMM.SDR DALA2018110606495Battery Pack · shortedON SERVICE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY EXIT LIGHTS FOR BOTH LEFT AND RIGHT FORWARD FLOOR LIGHTS ARE INOPERATIVE. MAINTENANCE FOUND THAT BATTERY PACK ASSEMBLY B5-119 HAD INTERNAL SHORT. BATTERY PACK B5-119 WAS REPLACED. THE EMERGENCY LIGHTS NOW SDR AALA201811069018Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED: AFT GALLEY AREA EMERGENCY EXIT LIGHTS INOPERABLE. MAINTENANCE REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201811069016Power Supply · inoperativeAIRCRAFT WAS GROUNDED: L1 DOOR EMERGENCY LIGHT INOPERABLE. MAINTENANCE FOUND EMERGENCY POWER SUPPLY UNIT FAULT AND REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018110526515Cover · missingLT OVERWING EXIT SIGN MISSING. INSTALLED COVER IAW MM.SDR SWAA2018110526493Light · inoperativeL2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018110526470Lens · unsecureCENTER AISLE EMERGENCY EXIT LIGHT LENS FELL OFF. SECURED LENS PER SIP.SDR DALA20181106476Power Supply · inoperativeTAILCONE SLIDE EMERGENCY LIGHTS INOP THREE LIGHTS ON LT CATWALK. T/S SYS FND POWER SUPPLY BAD B5-239 IN AFT-MOST CEILING PNL. R/R SAME IAW MD90 AMM 33-51-13. OPS CHKS OK. (LP# 4254372)SDR DALA2018110606480Bulb · mechanic errorON SVC CHK FND AFT CABIN EXIT SIGN INOP AND CATWALK OVERHEAD LIGHT ABOVE SLIDE PACK INOP. FND WRONG BULBS INSTALLED IN EXIT SIGN. RELAMPED WITH CORRECT BULBS. NOW OPS CHK NORMALLY. LIGHT ABOVE CATWALK SLIDE PACK FOUND DISCONNECTED. CONNECTED SAME. NOW OPS CHKSSDR DALA20181106485Light · damaged(AIRCRAFT 6706, L/P 5143190) EMERGENCY LIGHT DAMAGED AT SEAT 1C. REPLACED EMERGENCY LIGHT ASSY AT SEAT 1C.SDR DALA20181106482Housing · unknown(AIRCRAFT 5638, L/P 5061527) OVERHEAD EMERGENCY LIGHT AT ROW 3 INOP. REPLACED EMERGENCY LIGHT HOUSING AT ROW 3 OVERHEAD REF B757 AMM 33-50.SDR AALA2018110659071Power Supply · inoperativeEMERGENCY LIGHTS, ROWS 10 AND 19 FOUND INOPERATIVE. INSTALLED A NEW POWER SUPPLY IAW AMM 33-51-38. OPS CHECKED GOOD.SDR AALA2018110659063Lens · detachedAN EMERGENCY LIGHT LENS WAS DETACHED AT SEAT 9D. ATTACHED THE LENS. OK FOR SERVICE.SDR DALA2018110406470Lens · damagedDURING INSPECTION FOUND EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING. REPLACED EMERGENCY EXIT COVER DIFFUSER LENS PER AMM 33-51.SDR SWAA2018110226514Light · brokenR1 DOOR SIDEWALL EMERGENCY EXIT LIGHT ASSEMBLY BROKEN. R&R LIGHT ASSEMBLY PER AMM.SDR SWAA2018110226473Guard · brokenEMERGENCY LIGHT SWITCH GUARD BROKEN. R&R SWITCH GUARD PER AMM.SDR DALA2018110656451Battery Pack · inoperativeEMERGENCY LIGHTS INOPERATIVE AT SEATS 15-20. MAINTENANCE REPLACED THE EMERGENCY LIGHT BATTERY PACK AT SEAT 18 PER B717 AMM 33-51. EMERGENCY LIGHTS NOW ILLUMINATE NORMALLY. OPERATIONAL CHECK IS GOOD. (LP #0811746)SDR 7C7A2018110300456Switch · sticksEMERGENCY LIGHT SWITCH ON F/A PANEL IS STICKING AND LIGHTS ON SWITCH DO NOT WORK.SDR CALA2018110502292Battery · unknown(A3NB-33-3-6013) REPLACE ALL EPSU BATTERIES AS AN ALTERNATIVE PR OCEDURE TO COMPLY WITH BATTERY CAPACITY CHECK. REFER TO AAR N/R: 9612056. REMOVED AND REPLACED ALL EPSU BATTERIES AS AN ALTERNATIVE PROCED URE TO COMPLY WITH BATTERY CAPACITY CHECK. SPEC NO. A3NBSDR AALA201811059064Lens · brokenFLOOR LEVEL EMERGENCY LIGHT LENS ON SEAT 9D HAD BROKEN OFF. REPLACED EMERGENCY LIGHT LENS.SDR QXEA2018110500410Sign · unknownFORWARD OVERHEAD EXIT SIGN INOPERATIVE. REMOVED FROM SERVICE. VERIFIED CORRECT OPERATION OF FWD OVERHEAD EXIT SIGN. NO DEFECTS NOTED. COULD NOT DUPLICATE. RETURNED TO SERVICE. NO PARTS REPLACED.SDR SIMA201811053001Light · inoperativeFOUND FLOOR LIGHT PROXIMITY INOP.-C/A-REMOVED AND REPLACED FLOOR PROX LIGHT IAW EMB 140 AMM 33-50-12. OPC GOOD. NO DEFECTS NOTED AT THIS TIME.SDR DALA2018110506443Holder · failedFOUND ROW 1C TO 12C EMERGENCY LIGHTS INOP DURING SERVICE CHECK. TROUBLESHOT PER MD-88 AMM 33-53. FOUND BATTERY HOLDER AT 3D BAD. REMOVED AND REPLACED BATTERY HOLDER PER MD-88 AMM 33-53. ALL CHK GOOD. OK FOR SERVICE. (LP4665963)SDR MYWA2018110300037Power Supply · inoperativeBOTH LEFT AND RIGHT FWD EMERGENCY OVERWING EXIT SIDEWALL LIGHT WAS INOPERATIVE. TROUBLESHOT THE SYSTEM, REMOVED AND REPLACED THE LT MID SECTION EMERGENCY POWER SUPPLY CHARGER, OPS CHECKED NORMAL IAW AMM 33-51-06.SDR SIMA2018112602003Light · inoperativePCR: EMERGENCY LIGHT STRIP INOP AT FLOOR PANEL 226BRF-C/A-COMPLETE:REMOVED AND REPLACED EMERGENCY LIGHT STRIP AT FLOOR PANEL 226BRF IAW EMB 175 AMM 33-50-21, OPS CHECK GOOD.SDR AALA201811079032Battery Pack · failedAIRCRAFT IN BASE MAINTENANCE: FOUND AFT BATTERY PACK AT PASSENGER DOOR 4R FAILED TO LIGHT EMERGENCY EXITS AND ESCAPE PATH LIGHTS. REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA201811079031Battery Pack · failedAIRCRAFT IN BASE MAINTENANCE: FOUND FORWARD BATTERY PACK AT PASSENGER DOOR 4R FAILED TO LIGHT EMERGENCY EXITS AND ESCAPE PATH LIGHTS. REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA201811079030Battery Pack · failedAIRCRAFT IN BASE MAINTENANCE: FOUND BATTERY PACK AT PASSENGER DOOR 3L (MID) FAILED TO LIGHT EMERGENCY EXITS AND ESCAPE PATH LIGHTS. REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA201811079029Battery Pack · failedAIRCRAFT IN BASE MAINTENANCE: FOUND BATTERY PACK AT PASSENGER DOOR 3L (FORWARD) FAILED TO LIGHT EMERGENCY EXITS AND ESCAPE PATH LIGHTS. REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA201811079028Battery Pack · failedAIRCRAFT IN BASE MAINTENANCE: FOUND BATTERY PACK AT PASSENGER DOOR 4L FAILED TO LIGHT EMERGENCY EXITS AND ESCAPE PATH LIGHTS. REPLACED BATTERY PACK PER AMM 33-51-06.SDR AALA201811079027Battery Pack · failedAIRCRAFT IN BASE MAINTENANCE: FOUND BATTERY PACK AT PASSENGER DOOR 2R FAILED TO LIGHT EMERGENCY EXITS AND ESCAPE PATH LIGHTS. REPLACED BATTERY PACK PER AMM 33-51-06.
Back to JASC 3350