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 SWAA2020102926806Cover · damagedEMERGENCY EXIT SIGN RIGHT SIDEWALL DAMAGED. REPLACED LENS COVER, PER AMM 33-51-01.SDR DALA2020102903508Connector · damagedL2 EXTERIOR DOOR EMERGENCY LIGHTS ARE INOPERATIVE. CORRECTIVE ACTION: MAINTENANCE FOUND CORROSION ON SOCKET CENTER PIN. CLEANED CORROSION AND REASSEMBLED. SYSTEM OPERATION IS NORMAL.SDR AALA202010299002Lamp · burned outAIRCRAFT WAS IN BASE MAINTENANCE. L3 DOOR EXTERNAL EMERGENCY SLIDE LIGHT IS INOPERATIVE. FOUND LAMP BAD. RELAMPED L3 DOOR EXTERNAL EMERGENCY LIGHT ASSEMBLY, PER 33-51-04.SDR MASA2020102810605Battery Pack · inoperativeCEILING LEVEL EMERGENCY FLOOD LIGHT ROW 23 INOPERABLE. REPLACED EMERGENCY LIGHT BATTERY PACK 3.SDR MASA2020102810604Battery Pack · inoperativeCEILING LEVEL EMERGENCY FLOODLIGHT ROW 21 INOPERABLE. REPLACED EMERGENCY BATTERY PACK 3.SDR MASA2020102810603Battery Pack · inoperativeROW 18 LOWER FLOOR LEVEL EXIT SIGN INOPERABLE. REPLACED BATTERY PACK 3.SDR AALA202010289011Battery · inoperativeAIRCRAFT WAS NOT GROUNDED: FOUND 13WL EMERGENCY POWER SUPPLY UNIT BATTERY TO BE INOPERATIVE DURING PS CHECK. REMOVED AND REPLACED 13WL EMERGENCY POWER SUPPLY UNIT BATTERY, PER AMM 33-51-38.SDR SWAA2020110226136Lamp · inoperativeEXTERNAL EMERGENCY LIGHT INOPERABLE AT L1 DOOR. RELAMPED EXTERNAL EMERGENCY LIGHT AT L1 DOOR AND PERFORMED OPERATIONS TEST, AS PER B737 AMM 33-51-04-960-801. TEST FOUND NORMAL.SDR J7SA2020110200233Power Supply · malfunctionedDISCOVERED EMERGENCY LIGHTS REMAIN ON IN ARMED POSITION. REMOVED AND INSTALLED FWD AND AFT EMERGENCY LIGHT POWER SUPPLIES WITH SERVICEABLE, IAW AMM 33-52-01. FUNCTIONAL CHECK GOOD.SDR SWAA2020102926597Lamp · inoperativeLEFT SIDE EMERGENCY EXIT OVERHEAD LIGHT INOPERABLE. CLOSING DMA PAGE: 0412223. RELAMPED SIDEWALL LIGHT AT SEAT 11A, IAW AMM 33-51-01 CL 57515.SDR SWAA2020102926119Lens · missingFWD SERVICE DOOR LOWER FWD EMERGENCY EXIT LIGHT MISSING DIRECTIONAL ARROW. REMOVED & REPLACED FWD SERVICE DOOR LOWER FWD EMERGENCY EXIT LIGHT LENS, PER AMM 33-51-01.SDR CALA2020102901220Battery Pack · no testEPSU BATTERY 12WL AND 13WL BATTERY FAILS CAPACITY CHECK. REMOVED AND REPLACED 12WL & 13WL ESPU BATTERIES, IAW A320 AMM 33- 51-38-000-002-A AND 33-51-38-400-002-A. OPERATIONS CHECK GOOD, IAW A320 AMM 33-51-00-710-001-A.SDR AALA202010289010Battery · no testAIRCRAFT WAS GROUNDED. EMERGENCY LIGHTS FAIL TEST. REMOVED AND REPLACED MID RIGHT EMERGENCY POWER SUPPLY UNIT BATTERY, IAW AMM 33-51-38.SDR ASAA2020102733421Lamp · inoperativeRT FWD OVERWING EMERG EXIT DOOR EXIT SIGN LAMP INOPERABLE. GROUNDED-YES. RELAMPED & TESTED FWD RT EMERGENCY EXIT LIGHT, REF B737-900 AMM 33-51-01-960-801. OPERATIONS TEST GOOD.SDR WX0A2020102873596Power Supply · failedDURING CABIN EMERGENCY LIGHTING TEST EPSU BAT CAP FWD LT FAILED. REMOVED AND REPLACED EPSU AND BATTERY, IAW AMM 33-51-38. OPERATIONS CHECK GOOD.SDR AALA202010289001Battery Pack · inoperativeAIRCRAFT IN BASE MAINTENANCE. L1 DOOR EMERGENCY BATTERY PACK M33093 WILL NOT CHARGE. REMOVED AND REPLACED L1 DOOR EMERGENCY BATTERY PACK.SDR MASA2020102710602Bulb · inoperativeFLOOR LEVEL GALLEY DOOR EXIT SIGN 1 BULB INOPERABLE. PLACED ON MEL.SDR J7SA2020102700232Power Supply · malfunctionedDISCOVERED EMERGENCY LIGHTS REMAIN ON IN ARMED POSITION. REMOVED AND REPLACED AFT NR 2 EMERGENCY LIGHT POWER SUPPLY. OPERATIONS CHECK GOOD, IAW AMM 33-51-00. P/N 6450LS-00 S/N 001360.SDR AALA202010279009Battery · inoperativeAIRCRAFT WAS NOT GROUNDED. FOUND EMERGENCY LIGHTS AT DOOR R3 NOT WORKING. REMOVED AND REPLACED 3 RT DOOR EMERGENCY POWER SUPPLY UNIT (AALA202010279004) AND BATTERY (AALA202010279009), IAW AMM33-51-38-000-001-A &33-51-38-400-001-A.SDR AALA202010279004Power Supply · inoperativeAIRCRAFT WAS NOT GROUNDED. FOUND EMERGENCY LIGHTS AT DOOR R3 NOT WORKING. REMOVED AND REPLACED 3 RT DOOR EMERGENCY POWER SUPPLY UNIT (AALA202010279004) AND BATTERY (AALA202010279009), IAW AMM33-51-38- 000-001-A &33-51-38-400-001-A.SDR J7SA2020110200234Battery Pack · inoperativeDISCOVERED EMERGENCY LIGHTS REMAIN ON IN ARMED POSITION. REMOVED FWD EMERGENCY LIGHT BATTERY AND INSTALLED INSPECTED EMERGENCY LIGHT BATTERY, IAW LEGACY 450 AMM 33-51-01-400-801-A. OPERATIONS CHECK GOOD. P/N 6450LS-00; S/N 000631.SDR YENA2020103000506Battery · no testFLT 2398 SEA-BOS. EPSU (14WL) FAILED BITE CHECK. REPLACED EPSU BATTERY, IAW AMM 33-51-38.SDR DALA2020102903521Battery Pack · inoperativeDURING INSPECTION FOUND EMERGENCY LIGHTS OUT ABOVE L1 DOOR. R & R BATTERY PACK AT LOC D10750, PER B737 AMM 33-51. OPERATIONS CHECK GOOD.SDR SWAA2020102826310Battery Pack · failedAFT LT EMERGENCY LIGHTING BATTERY PACK FAILED CAPACITY CHECK. REMOVED AND REPLACED, PER AMM.33-51-06.SDR SWAA2020102825941Charger · inoperativeLT OVERWING EMERGENCY EXIT INSIDE + OUTSIDE LIGHTS ARE INOPERABLE. R&R LT OVERWING EMERGENCY EXIT LIGHT CHARGER ASSEMBLY & BATTERY PACK, IAW AMM 33-51-06.SDR SWAA2020102826602Battery Pack · inoperativeLT OVERWING EMERGENCY EXIT INSIDE + OUTSIDE LIGHTS ARE INOPERABLE. R & R LT OVERWING EMERGENCY EXIT LIGHT CHARGER ASSEMBLY & BATTERY PACK, IAW AMM 33-51-06.SDR SWAA2020102826217Cover · missingFWD SERVICE DOOR FLOOR EXIT SIGN COVER MISSING. REPLACED FWD SERVICE DOOR FLOOR EXIT SIGN COVER, PER SIP.SDR SWAA2020102826032Lens · missingOVERWING EXIGT LIGHT MISSING. RESECURED LENS IN REF TO SIP.SDR IPXA2020102661695Charger · failedINSPECTION TYPE: N/A EMERGENCY EXIT LIGHTS ILLUMINATED WITH EMERGENCY SWITCH IN ARMED POSITION. REMOVED AND REPLACED BATTERY CHARGER ASSEMBLY, AS PER AMM 33-51-07-402-010. PERFORMED TEST AND NO DISCREPANCIES FOUND.SDR AALA202010279006Battery · inoperativeAIRCRAFT IN BASE MAINTENANCE. INOPERATIVE EMERGENCY POWER SUPPLY UNIT 15WL BATTERY IN PASSENGER CABIN. REPLACED EMERGENCY POWER SUPPLY UNIT 15WL BATTERY IN PASSENGER CABIN, IAW AMM 33-51-38-400-002-A.SDR AALA202010279010Fuse · blownAIRCRAFT IN BASE MAINTENANCE. INOPERATIVE EMERGENCY SIDEWALL LIGHT AT FORWARD OVERWING EXIT. REPLACED FUSE IN M1694 POWER SUPPLY WITH NEW, IAW AMM 31-51-00. OPERATIONS CHECK GOOD.SDR MASA2020102610601Light · inoperativeEMERGENCY ESCAPE FLOOR PATH LIGHTING STRIP ROW 1 INOPERABLE. REPLACED STRIP.SDR YENA2020102900504Battery · no testFLT 624, LAX-JFK. PER EPSU TST/BATTERY CAP TEST, 10WL REQUIRED REMREP. REMREP 10WL, IAW AMM 33-51-38 EPSU/BATTERY TEST GOOD.SDR YENA2020102900503Battery · failedFLT 712, ROC-BOS. R2 EMERGENCY EXIT DOOR SIGN WILL NOT ILLUMINATE. R & R EMERGENCY LIGHT POWER UNIT, IAW AMM 33-50-01. OPERATIONS CHECK GOOD AT THIS TIME.SDR AALA202010269010Switch · inoperativeAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT FLOOR LIGHTING ON INFLIGHT WITH COCKPIT SWITCH IN ARM POSITION. REPLACED EMERGENCY EXIT COCKPIT SWITCH 4WL, PER AWM 33-51-00.SDR AALA202010259010Control Unit · inoperativeAIRCRAFT WAS NOT GROUNDED. WELS BATTERY AT DOOR 4L WILL NOT TURN ON. REPLACED WELS CONTROL UNIT, PER AMM 33-51-07.SDR DXTA2020102504269Battery Pack · inoperativeTHE EMERGENCY LIGHTS BEGAN BLINKING WHILE IN THE ARM AND ON POSITIONS. CORRECTIVE ACTION: INSTALLED REPAIRED FWD EMERGENCY BATTERY AND MODIFIED AFT EMERGENCY BATTER, IAW AMM 33-52-00. PERFORMED SATISFACTORY OPERATIONS CHECK, IAW AMM 33-52-00-710 501A AND 33-SDR N6WA2020102501Light · unknownEMERGENCY LIGHTS INOPERABLE. PERFORMED OPERATIONAL CHECK OF EMERGENCY LIGHTS, IAW CRJ AMM 33-51-00. NO DEFECTS NOTED.SDR N6WA2020102502Light · inoperativeOVERHEAD EMERGENCY LIGHT AT ROW 3 INOPERABLE. DEFERRED PER MEL 33-51-01B-2A OCN 70070448 CAT C MXC.SDR DALA2020102603473Battery Pack · disconnectedEMERGENCY OVERHEAD EXIT LIGHT AT R1 AND L1 AND 4 ESCAPE PATH LIGHTS BY LAV 201 ARE INOPERATIVE. MAINTENANCE DISCOVERED BATTERY PACK M1208 DISCONNECTED. RECONNECTED AND SECURED BATTERY PACK. SYSTEM OPERATION IS NORMAL.SDR DALA2020102603472Charger · inoperativeEMERGENCY PATH LIGHTS AT 34AB AND EXIT SIGN BY LAV 205 ARE INOPERATIVE. REPLACED BATTERY PACK CHARGER M739. SYSTEM OPERATION IS NORMAL.SDR DXTA2020102504270Battery Pack · inoperativeSUSPECT EMERGENCY LIGHT BATTERY IS WEAK OR DEAD. ALL EXIT LIGHTS TEST WITH MASTER SWITCH ON, BUT BACK HALF DO NOT ILLUMINATE WHEN MASTER IS OFF. CORRECTIVE ACTION: REMOVED DEFECTIVE FORWARD EMERGENCY BATTERY PACK P/N 9913/1 S/N 2457 AND INSTALLED CUSTOMER SUSDR DALA2020102503455Lamp · inoperativeDURING INSPECTION FOUND RT FWD SLIDE/OVERWING EMERGENCY LIGHT INOPERATIVE. RELAMPED, PER B737 AMM 33-51. LIGHT TEST GOOD.SDR SWAA2020110428259Lens · missingFWD RT DOOR HEADER PANEL EXIT SIGN LENS MISSING. REMOVED AND REPLACED DOOR EXIT LIGHT ASSEMBLY AND OPERATIONS CHECK OK, PER AMM 33-51-01.SDR U2RA202010300001Battery Pack · dischargedLT EMERGENCY EXIT HATCH OVER-HEAD EMERGENCY LIGHT INOPERABLE. CHARGED BATTERY PACK, PERFORMED OPERATIONAL CHECK OF LIGHTS. OPERATIONS CHECK NORMAL.SDR SWAA2020102825515Lamp · inoperativeLT AFT ENTRY DOOR EMERGENCY LIGHT INOPERABLE (EXTERIOR). RELAMPED LT AFT ENTRY DOOR EXTERIOR EMERGENCY LIGHT, PER AMM 33-51-00. OPERATIONS CHECK GOOD.SDR SWAA2020102825621Battery Pack · inoperativeMULTIPLE INTERIOR AND EXTERIOR EMERGENCY LIGHTS INOPERABLE. REPLACED RT EMERGENCY LIGHT BATTERY PACK, PER AMM 33-51-06. EMERGENCY LIGHTS OPERATIONS CHECK GOOD.SDR SWAA2020102826532Battery Pack · inoperativeMULTIPLE INTERIOR AND EXTERIOR EMERGENCY LIGHTS INOPERABLE. REPLACED RT EMERGENCY LIGHT BATTERY PACK, PER AMM 33-51-06. EMERGENCY LIGHTS OPERATIONS CHECK GOOD.SDR AALA202010279013Light · detachedAIRCRAFT WAS NOT GROUNDED. PASSENGER SEAT MOUNTED ESCAPE PATH LIGHT AT SEAT 9C FALLING OFF. REPLACED LIGHT ASSEMBLY, PER AMM 33-51-11.SDR AALA202010269013Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED. LEFT FORWARD OVER WING EMERGENCY LIGHT INOPERATIVE. RELAMPED LEFT FORWARD OVER WING EMERGENCY LIGHT, AS PER AMM 33-51-00.
Back to JASC 3350