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 SWAA2020020541017Sign · unsecureCENTER AISLE EXIT SIGN UNSECURE. / RESECURED SIGN PER SIP.SDR ASOA20200205004Lamp · odorPILOT REPORTED ELECTRICAL SMELL BY SEAT 4CD AND 5CD. ITEM PLACED ON MEL. ON 2/3/20 MX REMOVED AND REPLACED SIDEWALL LAMP AND RESEATED CONNECTOR WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR ASOA20200205003Bulb · failedPILOT REPORTED ROW 18 EMERGENCY LIGHT INOP. MX RELAMPED EMERGENCY LIGHT IAW EMB145 AMM 33-50-08 WITH OPERATIONAL CHECK GOOD. A/C WAS APPROVED FOR RETURN TO SERVICE.SDR R61A2020020410149Lens · damagedPHOTOLUMINESCENT STRIP COVER DAMAGED AT 11CD. R&R STRIP IAW 33-51-07.SDR R61A2020020410148Battery · inoperativeEMERGENCY LIGHT ABOVE ROW 20/21 INOP. R&R EMERGENCY LIGHT POWER UNIT IN RH AFT GALLEY.SDR FDEA2020020410254Relay · malfunctionedRECEIVED "EMER LT BAT 1 LO" ALERT DURING EMERGENCY LIGHTS TEST. REMOVED AND REPLACED THE R2-5700 EMERGENCY LIGHT BATTERY PACK TEST RELAY PER FIM 33-52-00-1 AND OP'S CHECK WAS GOOD. OK FOR CONTINUED SERVICE.SDR SWAA2020020441025Bulb · inoperativeEXTERNAL EMERGENCY EXIT LIGHT INOPERATIVE AT R1 DOOR. / R&R BULB PER AMM.SDR DALA2020020320861Lens · missingL1 CABIN WALL MOUNTED EMERGENCY EXIT MARKER LENS MISSING, INSTALLED LENSSDR CALA2020020300316Lens · inaccurateEXIT IDENTIFIERS AT SEATS 21A AND 20A INSTALLED WITH ARROWS POINTING IN WRONG DIRECTION. REMOVED AND REPLACED EXIT IDENTIFIERS WITH CORRECT ARROWS AT SEATS 20A AND 21A. REF IPC 33-51-01-16.SDR CALA2020020300312Power Supply · failed(SUPPORT TASK) REMOVE AND REPLACE THE L/H FWD CABIN EMERGENCY PO WER SUPPLY. REFER TO AAR N/R: 9622888. CHANGED DUE TO A FAILED E MERGENCY LIGHT TEST. REMOVED AND REPLACED THE L/H FWD CABIN EMERGENCY POWER SUPPLY. R EFER TO AAR N/R: 9622888. WORK ACCOMPLISHED SDR QXEA2020020300077Light · looseEMERGENCY FLOOR LIGHTING COMING LOOSE IN FRONT OF DOOR TO THE FORWARD CARGO COMPARTMENT. REMOVED FROM SERVICE. RESECURED FLOOR LIGHTING FWD CABIN BY FWD. DOOR CARGO COMPARTMENT NO OTHER DEFECTS NOTED AT THIS TIME. AIRCRAFT RETURNED TO SERVICE.SDR PNSA20200203101Light · unsecureEMERGENCY TRACK LIGHTING STRIP ALONG ROW 2-3 IS COMING OFF. RE-SECURED TRACK LIGHTING, OPS OKSDR AALA202002039027Battery · faultedAIRCRAFT WAS NOT GROUNDED: DURING OPERATIONS CHECK, MCDU DISPLAYED EPSU/BATTERY 18WL FAULT MESSAGE, DOOR 4. MAINTENANCE REPLACED BATTERY 18WL AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38-000-802-A/400-802.SDR AALA202002039026Battery · faultedAIRCRAFT WAS NOT GROUNDED: DURING OPERATIONS CHECK, MCDU DISPLAYED EPSU/BATTERY 17WL FAULT MESSAGE, DOOR 4. MAINTENANCE REPLACED BATTERY 17WL AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38-000-802-A/400-802.SDR AALA202002039025Battery · faultedAIRCRAFT WAS NOT GROUNDED: DURING OPERATIONS CHECK, MCDU DISPLAYED EPSU/BATTERY 13WL FAULT MESSAGE, DOOR 2. MAINTENANCE REPLACED BATTERY 13WL AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38-000-802-A/400-802.SDR AALA202002039024Battery · faultedAIRCRAFT WAS NOT GROUNDED: DURING OPERATIONS CHECK, MCDU DISPLAYED EPSU/BATTERY 12WL FAULT MESSAGE, DOOR 1. MAINTENANCE REPLACED BATTERY 12WL AND PERFORMED SATISFACTORY OPERATIONAL CHECK PER AMM 33-51-38-000-802-A/400-802.SDR AALA202002039022Light · inoperativeAIRCRAFT WAS GROUNDED: SEAT MOUNTED EMERGENCY LIGHT 20L INOPERABLE. MAINTENANCE REPLACED LIGHT ASSEMBLY PER AMM 33-51-19.SDR MASA2020020100041Battery Pack · dischargedEMER LTS ARE DEAD-FLT DK SWITCH LEFT ON
CHARGED EMERGENCY BATTERIESSDR MASA2020020100040Light · inoperativeROW 13 L/R LWR LEVEL EMER LIGHTS INOP
REPLACED ROW 13 L/R LWR LEVEL EMER LIGHTS.SDR DALA2020020100772Battery Pack · inoperativeEMERGENCY LIGHTS (CEILING) @ ROWS 15 TO 20 ARE INOP. REPLACED BATTERIES OPS CK GOOD REF MD88 AMM 33-53. (LP6920276)SDR SWAA2020020440969Ballast · inoperativeEMERGENCY EXIT ROW LIGHT INOPERATIVE 12 F. (SIDEWALL LIGHT) / R&R BALLAST IAW AMM.SDR SIMA2020021231005Light · unknownINSIDE MAIN CABIN THE #1 AND #2 EMERGENCY LIGHTING FLOOR PROXIMITY STRIPS DO NOT ILLUMINATE-C/A-PERFORMED OPC OF EMERGENCY LIGHTING SYSTEM IAW EMB 140 AMM 33-50-00, OPC GOOD.SDR DALA2020020430883Light · inoperativeSHIP 5815 EMERGENCY SEAT MOUNTED LIGHTING DAMAGED / INOP / LOCATIONS:27D. CORRECTIVE ACTION: REINSTALL EMERG. LIGHT ASSEMBLY. (1469998)SDR DALA2020020430882Battery Pack · inoperativeSHIP 5811 SEAT 28E LOWER EMERGENCY EXIT SIGN INOP. CORRECTIVE ACTION: FOUND BATTERY PACK EQUIPMENT # M11384 DEAD R/R BATTERY PACK IAW B757 AMM 33-51. OPS NML. (6438745)SDR AALA2020020439005Bulb · unsecureAIRCRAFT WAS NOT GROUNDED: R1 EXTERIOR SLIDE LIGHT INOPERABLE. MAINTENANCE SECURED BULB PER MM 33-51-06.SDR AALA2020020439002Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: PER WORKCARD 2803 DOOR 4LH EXIT LIGHTS INOPERATIVE. MAINTENANCE REPLACED WIRELESS BATTERY UNIT PER AMM 33-51-07.SDR SWAA2020020441056Sign · missingFORWARD ENTRY DOOR, LOWER EMERGENCY EXT LIGHT LENS MISSING DIRECTIONAL ARROW. / R&R EXIT SIGN AMM.SDR SWAA2020020441055Lens · missingRIGHT WING EMERGENCY EXIT LOWER LIGHT LENS MISSING DIRECTIONAL ARROW. / R&R LENS PER AMM.SDR SWAA2020020441049Lens · looseMID CABIN EMERGENCY EXIT LIGHT LENS LOOSE. / SECURED LENS IAW AMM.SDR SWAA2020020440986Battery Pack · no test5 EACH CABIN EMERGENCY LIGHTING BATTERY PACKS FAIL CAPACITY TEST. / R&R BATTERY PACKS PER AMM AND DWG.SDR SWAA2020020440970Battery · no testEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATIONS M1169M, M1670 AND M1673 IN CABIN. / R&R BATTERIES PER MM.SDR ASAA2020020332060Lens · detachedCENTER AISLE O/W EMERGENCY EXIT SIGN LENS (CENTER LINE) FOUND ON SEAT. GROUNDED - YES. INSPECTED LIGHT ASSY NO DEFECTS NOTED. REINSTLD LENS. OPS CK OK.SDR ASAA2020020332059Lens · detachedSEAT 17F EMERGENCY EXIT SIGN COVER MISSING. GROUNDED - YES. REPLACED EMERGENCY EXIT SIGN COVER PER B737-800 AMM 33-51-01.SDR AALA202002039023Power Supply · failedAIRCRAFT IN BASE VISIT: DONT PASS OPERATIONAL TEST EPSU-EMERGENCY POWER SUPPLY UNIT FWDLH PASSENGER CABIN. REMOVED AND REPLACED EPSU 11WL ON LH FWD CABINE PASSENGER IAW AMM 33-51-38-000-801-A AND AMM 33-51-38-400-801-A.SDR IPXA2020020151637Charger · inoperativeINSPECTION TYPE:N/AEMERGENCY LIGHTS INOP.R&R BATTERY CHARGER AND BATTERY IAW MM 33-51-07-201. EMERGENCY LIGHTS TEST GOOD IAW MM 33-51-00-501.SDR DALA2020013100752Lamp · inoperativeDURING INSPECTION, FOUND THE LT & RT OVERWING EXIT EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-51. OPS CHECKED GOOD.SDR SWAA2020013140928Power Supply · inoperativeL1 DOOR EMERGENCY LIGHT INOPERATIVE. R&R POWER SUPPLY PER AMM.SDR SWAA2020020641138Sign · looseEMERGENCY EXIT SIGN MID-CABIN LOOSE. / RE-ATTACHED SIGN IAW AMM.SDR SWAA2020020651091Lamp · inoperativeL/H LOWER EXTERNAL FUSELAGE EMERGENCY EXIT FLOOD LIGHT WAS INOPERATIVE AT BS. 757. / R&R LAMP IAW AMM.SDR SWAA2020020541024Battery Pack · inoperativeEMERGENCY LIGHT INOP AT UPPER R/H AFT SERVICE DOOR. / R&R POWER SUPPLY M1672 BATTERY PACK IAW AMM.SDR SWAA2020020541023Battery Pack · inoperativeEMERGENCY LIGHT INOPERATIVE AT UPPER R/H FORWARD SERVICE DOOR. / R&R POWER SUPPLY M2816 BATTERY PACK IAW AMM.SDR FDEA202001300248Lamp · inoperativeDURING POST FLIGHT INSPECTION FOUND R/H EXTERIOR EMERGENCY LIGHT AFT OF R1 DOOR INOP. RELAMPED EXTERIOR RH EMERGECY LIGHT REF AMM 33-51-06-2-1. A/C OK FOR SERVICESDR YENA2020020430130Battery · failedDURING HEAVY MAINTENANCE, INOP EPSU BATTERIES AT 13WL AND 15WL; (REF AE NR 2020-42502, W/O 2020-16/1) PERFORMED TSM 33-51-00-810-879-A(13WL) AND 33-51-00-810-875-A(15WL). BATTERIES REQUIRE REPLACEMENT. REPLACED BATTERIES IAW AMM 33-51-38-400-002-A. OPS CK'D IASDR YENA2020020430129Battery · failedDURING HEAVY MAINTENANCE, INOP EPSU BATTERIES AT 13WL AND 15WL; (REF AE NR 2020-42502, W/O 2020-16/1) PERFORMED TSM 33-51-00-810-879-A(13WL) AND 33-51-00-810-875-A(15WL). BATTERIES REQUIRE REPLACEMENT. REPLACED BATTERIES IAW AMM 33-51-38-400-002-A. OPS CK'D IASDR YENA2020020430128Power Supply · failedFT # 352, MCO-BOS. EPSU FAILED BITE CHECK (UNIT FAULT); R & R EPSU (10 WL) IAW AMM 33-51-38, BITE CHECK GOODSDR YENA2020020430127Battery · failedFT # 352, MCO-BOS. EPSU BATTERY (13WL) FAILED CAP CHECK; R & R EPSU (13WL) IAW AMM 33-51-38, BITE CHECK GOODSDR YENA2020020430126Battery · failedFT # 352, MCO-BOS. EPSU BATTERY (11WL) FAILED CAP CHECK; R & R EPSU (11WL) IAW AMM 33-51-38, BITE CHECK GOODSDR YENA2020020430125Battery · failedFT # 352, MCO-BOS. EPSU BATTERY (12WL) FAILED CAP CHECK; R & R EPSU (12WL) IAW AMM 33-51-38, BITE CHECK GOODSDR YENA2020020430124Battery · failedFT # 352, MCO-BOS. EPSU BATTERY (14WL) FAILED CAP CHECK; R & R EPSU (14WL) IAW AMM 33-51-38, BIT CHECK GOODSDR YENA2020020430123Battery · failedFT # 352, MCO-BOS. EPSU BATTERY (15WL) FAILED CAP CHECK; R & R EPSU (15WL) IAW AMM 33-51-38, BITE CHECK GOOD.
Back to JASC 3350