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 AALA201811089014Control Unit · failedEMERGENCY LIGHTS IN THE FIRST CLASS CABIN WILL NOT TURN OFF WHEN AIRCRAFT WAS SHUTDOWN. CHECKED AND MAINTENANCE MESSAGE FAULT 45-16571, AND 42-01065. TROUBLESHOT IAW AMM 33-51-07. REPLACED THE L1 WIRELESS EMERGENCY LIGHTING SYSTEM CONTROL UNIT, SOFTWARE LOADSDR AALA201811089001Battery Pack · no testEPSU BATTERY AT THE R4 DOOR FAILED EMERGENCY EXIT LIGHT CHECK. REPLACED THE BATTERY PACK. OPS TESTED GOOD.SDR ASAA2018110626737Battery Pack · dischargedWHILE PERFORMING T/C 78233001 FOUND LEFT OVERWING AFT EXIT LIGHT & LEFT OVERHEAD BIN EXIT LIGHTS ROW 1-12 INOP & RT FWD OVERWING EXIT LIGHT & RT OVERHEAD BIN LIGHTS 18-23 INOP. GROUNDED - YES. REPLACED THREE BATTERY PACKS AND ONE POWER SUPPLY INSTALLATION TESTSDR AALA201811079014Light · unknownALL EMERGENCY EXIT LIGHTS REMAIN ON REGARDLESS OF THE SWITCH POSITION. TURNED OFF THE NO SMOKING LIGHT SWITCH. EMERGENCY EXIT LIGHTS OPS CHECKED GOOD IAW AMM 33-51-00.SDR DALA2018110706532Lens · detached(AIRCRAFT 6805, L/P 0815205) EMERGENCY EXIT COVER DIFFUSER LENS DAMAGED OR MISSING / LOCATIONS:604 / 2L EMERGENCY / EXIT LIGHT FELL OFF / INTERIOR. EXIT SIGN REINSTALLED.SDR DALA2018110706524Light · inoperative(AIRCRAFT 5803, L/P 0816546) EMERGENCY PATH LIGHT INOP AT SEAT 28D. REPLACED SEAT LIGHT AT 28D. OPS CHECKS NORMAL.SDR SWAA2018110726592Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01674. R&R BATTERY PER AMM.SDR SWAA2018110726591Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01673. R&R BATTERY PER AMM.SDR SWAA2018110726590Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01672. R&R BATTERY PER AMM.SDR SWAA2018110726589Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01670. R&R BATTERY PER AMM.SDR SWAA2018110726579Battery · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY CHECK AT LOCATION M01675. R&R BATTERY PER AMM.SDR SWAA2018110726576Light · inoperativeR2 DOOR EXTERIOR EMERGENCY LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR SWAA2018110726570Cover · looseAISLE EXIT SIGN AISLE LOOSE. REINSTALLED LIGHT COVER PER AMM.SDR MASA2018110611505Light · inoperativeGALLEY FLOOR EMER LIGHT INOP. RELAMPED.SDR ASOA201811064062Battery Pack · dischargedIAH - DURING MAINTENANCE INSPECTION SEVERAL EMERGTENCY LIGHTS WERE FOUND TO BE INOPERATIVE. MAINTENANCE FOUND THE NUMBER FOUR EMERGENCY LIGHT BATTERY PACK TO BE LOW. MAINTENANCE RECHARGED THE AFFECTED EMERGENCY LIGHT, OPERATIONALLY TESTED WITH NO DEFECTS NOTEDSDR DALA2018110606455Diode · failedEMERG LIGHTS ROW 10 TO FIRST OVERWING DOOR INOP. INSTALLED DIOD ON BATTERY PACK @ 3CD OPS CHECK GOOD IAW MD88 AMM 33-55. (LP4755523)SDR AALA201811069021Cover · missingAIRCRAFT WAS NOT GROUNDED: ROW 13DEF COVER UNDER EMERGENCY LIGHT WAS MISSING. MAINTENANCE SECURED LENS 2WN2 AND ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK PER AMM 52-73-00.SDR SWAA2018111326676Lens · looseR1 DOOR EMERGENCY EXIT LIGHT LENS LOOSE. SECURED LENS IAW SOPM.SDR AALA201811086004Power Supply · no testDURING AN EMERGENCY LIGHT POWER SUPPLY SYSTEM TEST, THE POWER SUPPLY FAILED THE TEST. MAINTENANCE REPLACED BATTERY AND CHARGER IAW MM 33-51-38, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2018110826593Cover · delaminatedMID CABIN OVERHEAD EMERGENCY EXIT SIGN PLASTIC COVER DELAMINATED. REINSTALLED COVER PER SIP.SDR AALA201811086010Power Supply · inoperativeFOUND THE EMERGENCY LIGHT POWER SUPPLY ABOVE THE R3 DOOR TO BE INOPERATIVE. REPLACED THE POWER SUPPY IAW AMM 33-51-06.SDR AALA201811086009Power Supply · inoperativeWHILE PERFORMING AN EMERGENCY LIGHT TEST, FOUND THE POWER SUPPLY AT THE R2 DOOR TO BE INOPERATIVE. REPLACED THE POWER SUPPLY IAW AMM 33-51-06.SDR AALA201811086008Battery Pack · inoperativeDURING A FUNCTIONAL CHECK, THE AFT EMERGENCY LIGHT BATTERY PACK M33097 WAS FOUND TO BE DEAD. REPLACED THE BATTERY PACK IAW AMM 33-51-06-960-802.SDR AALA20181106007Battery Pack · failedTHE AIRCRAFT IS IN BASE MAINTENANCE. DOOR 3R EMERGENCY EPAS BATTERY PACK HAS NO GREEN LIGHT BLINKING. REPLACED EPAS BATTERY PACK IN 3R DOOR PER AMM 52-11-20-000-805-002 AND 52-11-20. OPERATIONS CHECK GOOD.SDR AALA20181106006Battery Pack · failedTHE AIRCRAFT IS IN BASE MAINTENANCE. DOOR 4R EMERGENCY EPAS BATTERY HAS NO GREEN LIGHT BLINKING. REPLACED DOOR 4R EMERGENCY EPAS BATTERY PACK PER AMM 52-11-20-000-805-002 AND 52-11-20-400-805-002.SDR AALA20181106001Power Supply · inoperativeTHE AIRCRAFT IS IN BASE MAINTENANCE. L3 DOOR FORWARD EMERGENCY EXIT IDENTIFIER LIGHT INOPERATIVE. REPLACED L3 DOOR FORWARD EMERGENCY POWER SUPPLY M33440. OPERATIONS CHECK GOOD PER MM 33-51-960-803.SDR AALA201811079006Power Supply · inoperativeAIRCRAFT WAS IN BASE MAINTENANCE. EMERGENCY POWER SUPPLY UNIT IN THE FORWARD LEFT HAND PASSENGER CABIN DOES NOT PASS THE OPERATIONAL TEST. REPLACED EMERGENCY POWER SUPPLY UNIT PER AMM 33-51-38-400-801-A.SDR AALA20181106013Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. INTERIOR EMERGENCY LIGHTS DOES NOT TURN ON AT DOOR 4R. REPLACED BOTH BATTERY PACKS PER AMM 33-51-06. OPERATIONS TEST GOOD.SDR AALA20181106012Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. INTERIOR EMERGENCY LIGHTS DO NOT TURN ON AT DOOR 4R. REPLACED BOTH BATTERY PACK PER AMM 33-51-06. OPERATIONS TEST GOOD.SDR AALA20181106011Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. INTERIOR EMERGENCY LIGHT DOES NOT TURN ON AT DOOR 4L. REPLACED BATTERY PACK PER AMM 33-51-06. OPERATIONS TEST GOOD.SDR DALA2018110766536Housing · broken(AIRCRAFT 5652, L/P 4621885) ON S/C FOUND EMERGENCY LIGHT HOUSING AT SEAT ROW 24 BROKEN OFF FROM SEAT. REPLACED HOUSING IN REF TO CMM 25-21-52.SDR DALA2018110766535Light · inoperative(AIRCRAFT 5652, L/P 4621886) ON S/C FOUND WHITE ESCAPE PATH LIGHT INOP. R & R E PATH LIGHT ASSY IN REF TO CMM 25-21-52.SDR DALA2018110706534Light · unknown(AIRCRAFT 6715, L/P 0814773) EMERGENCY FLOOR LIGHTING DAMAGED OR INOPERATIVE / INTERIOR. RE-INSTALLED EMER LIGHT LENS DOOR 1R.SDR DALA2018110706531Light · damaged(AIRCRAFT 6805, L/P 5138636) EXIT EMERGENCY LIGHTS 2R DOOR INOP. FOUND EXIT INDICATOR LIGHT L860 DAMAGED. REPLACED LIGHT ASSY PER B757 AMM 33-51-10. REPLACED FUSE AT POWER SUPPLY M733 PER B757 AMM 33-51-07, NOW OPS OK.SDR DALA2018110706523Sign · detached(AIRCRAFT 5804, L/P 4918516) 2L EXIT SIGN FELL OFF MOUNT. SECURED 2L EXIT SIGN COVER.SDR SWAA2018110626554Light · inoperativeL2 DOOR EXTERIOR EMERGENCY EXIT LIGHT INOP. RELAMPED LIGHT IAW AMM.SDR AALA201811069010Battery · no testEMERGENCY POWER SUPPLY BATTERIES AT THE L4 DOOR FAILED A CAPACITY CHECK. REPLACED THE BATTERIES IAW AMM 33-51-38. OPS CHECKED OK.SDR AALA201811069005Battery · no testEMERGENCY POWER SUPPLY BATTERIES AT THE R2 DOORSFAILED A CAPACITY CHECK. REPLACED THE BATTERIES IAW AMM 33-51-38. OPS CHECKED OK.SDR SWAA2018110626534Lens · looseRT OVERHEAD BIN EMERGENCY EXIT LIGHT LENS LOOSE. R&R LENS PER SIP.SDR R61A201811051121Power Unit · inoperativeEMERGENCY LIGHTS OVER L2 DOOR INOP. R&R NR 3 EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01.SDR R61A201811051119Power Supply · inoperativeCABIN OVERHEAD EMERGENCY LIGHT INOP 5TH LIGHT BACK. R&R NR 3 POWER SUPPLY EMERGENCY LIGHT IAW AMM 33-50-01.SDR DALA2018110606474Battery Pack · inoperativeEMERGENCY LIGHTS INOP AT OVERWING EXIT ON CEILING PANEL. REPLACED BATTERY PACK AT B5-243. MD90 AMM 33-51. CKS GOOD. OK FOR SERVICE. (LP# 0814402)SDR DALA2018110606473Battery Pack · inoperativeCABIN EMER LIGHTS AT ROW 34 INOP. REMOVED & REPLACED BATTERY AT POWER SUPPLY B5-231. OPS CHECK GOOD. (LP# 3762934)SDR DALA2018110606472Battery Pack · malfunctionedDOOR 1L & 1R EMER LIGHTS FLASH ON THEN OFF. REMOVED & REPLACED BATTERY AT POWER SUPPLY B5-211. OPS CHECK GOOD. (LP# 3762933)SDR DALA2018110606481Lens · missing(AIRCRAFT 5647, L/P 5212337) SEAT 15DEF SEAT MOUNTED E-PATH LIGHT AFT LIGHT LENS MISSING AND DAMAGED. REPLACED SEAT 15DEF AFT E-PATH SEAT MOUNTED LIGHT ASSY PER B757 AMM 43-51.SDR AALA201811069023Lamp · inoperativeEXIT SIGNS LAMP INOPERATIVE, FORWARD AND AFT GALLEYS. REPLACED THE LAMPS . OPS CHECKED GOOD.SDR DALA2018110606458Battery Pack · no testAFT L EPSU FAILS EMER LIGHT TEST, INSTALLED NEW BATTERYSDR DALA2018110606456Battery Pack · inoperativeFOUND EMERGENCY CEILING LIGHTS INOP FROM ROW 24-28 AND ROW 4-1. REPLACED BATTERIES IN BOTH BATTERY PACKS IN OVERHEAD BINS 4 AND 28 PER MD88 AMM 33-53. LIGHTS WORK GOOD. (LP5255009)SDR CALA2018110502309Light · inoperativeSEAT 34 ABC EEL PLATHWAY LIGHT INOP. REPLACED LIGHT ASSY REF AMM 33-51-15 OPS CHECKED OK. ACP IDT INSP OF REPLACING EPL LIGHT ASSY AT SEAT 34ABC REF GMM 0 9-10-05 AND AMM 33-51-15. OPS CK GOOD.SDR CALA2018110502306Power Supply · inoperativeFOUND EPSU 11WL BAD. REPLACED EPSU IAW AMM 33-51-38-400-001A. ROTABLE PARTS CHANGE WAS INDICATED - TT # 1103608 SN OFF 2897 POWER SUPPLY, C OFF 31-3350-9-9001 2897 ON 31-3350-9-9001 5406 PART UPDATE ONLY ROTABLE PARTS CHANGE WAS INDICATED - TT # 1810908 SN
Back to JASC 3350