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 FDEA2020081071800Battery Pack · failedR1 DOOR SLIDE EMERGENCY LIGHT AND RIGHT SIDE EMERGENCY LIGHTS IN COURIER COMPARTMENT INOPERATIVE. REPLACED THE BATTERY PACK. INSTALLED AND TESTED OK IAW AMM: 33-51-07-2-2.SDR AALA2020081089003Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY EXIT LIGHT AT SEAT 11C HAS COME LOOSE. RESECURED EMERGENCY EXIT LIGHT ON SEAT 11C PER AMM 33-50-00.SDR AALA2020081089002Lens · unsecureAIRCRAFT WAS NOT GROUNDED: SEAT 4C EMERGENCY LIGHT COVER WILL NOT STAY ON. ADJUSTED LENS COVER OK FOR CONTINUED SERVICE.SDR J7SA2020081000213Power Supply · inoperativeDISCOVERED EMERGENCY LIGHTS REMAIN ON IN ARMED POSITION. ACCOMPLISHED REMOVAL AND REPLACEMENT OF FWD AND AFT EMERGENCY LIGHT POWER SUPPLIES. OPS CHECK SATISFACTORY IAW AMM 33-52-00.SDR DALA2020081002747Sign · dislodgedDURING INSPECTION FOUND EXIT SIGN AT 2A FELL OFF. REINSTALLED EXIT SIGN AT AFT DOOR. OPS CHECK OK.SDR DALA2020081072746Battery Pack · inoperativeDURING INSPECTION FOUND OVHD EMERGENCY LIGHT ABOVE ROW 21 INOPERATIVE. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK UNDER ROW 23L PER B737 AMM 33-51. OPS CHECK GOOD.SDR ASOA202008107047Bulb · burned outCREW REPORTED MID CABIN OVERHEAD EMERGENCY LIGHT BURNED OUT. MAINTENANCE REPLACED MID CABIN OVERHEAD EMERGENCY LIGHT BULB. OPERATIONAL CHECKS WERE GOODSDR KCSA202008071133Light · inoperativeUPPER DECK ESCAPE DOOR EMERGENCY LIGHT INOPERATIVE.SDR GTIA2020080735305Battery Pack · no testEMERGENCY LIGHT TEST FAILED FOR EPSU 12WL. BATTERU 12WL WAS REPLACED.SDR SWAA2020081006639Battery Pack · inoperativeEMERGENCY LIGHT AT R1 INSIDE AND OUTSIDE INOP / REPLACED BATTERY PACK FOR M2816 POWER SUPPLY PER AMM 33-51-06.SDR DALA2020081072751Battery Pack · inoperativeDURING SVC CHK, EPSU SYS TEST FAULTED EPSU BAT EXT R (12WL). CORRECTIVE ACTION: R/R REAR EMERGENCY EXIT DOOR R EPSU BAT REF AIRBUS A321 AMM CH 33-51. OPS TEST GOOD.SDR SWAA2020081006524Lamp · inoperativeFUSELAGE EMERGENCY LIGHT FWD OF AFT CARGO DOOR INOPERATIVE. REPLACED THE LAMPS PER MM 33-51-04SDR SWAA2020081006678Cover · missingRIGHT OVERWING EXIT SIGN (1' X 5') COVER IS MISSING. INSTALLED NEW COVER FOR RH OVERWING EXIT SIGN PER S.I.PSDR JJBA202008076003Battery Pack · inoperativeRH FWD EXTERNAL EMERGENCY LIGHT INOPERATIVE. R&R RH FWD EMERGENCY LAMP. OPS CHECK FAILED. R&R #2 BATTERY. OPS CHECK SAT.SDR AALA202008069014Power Supply · failedAIRCRAFT WAS GROUNDED, R1 DOOR EMERGENCY POWER SUPPLY UNIT M33094, BATTERY PACK DRAINED. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY PACK POWER SUPPLY ASSEMBLY ABOVE R1 DOOR IAW AMM 33-51-06.SDR MASA2020080610145Light · inoperativeROW 23 OVERHEAD EMERGENCY FLOOD LIGHT INOPERATIVE.SDR SWAA2020082407118Housing · brokenMID CABIN OVER HEAD CEILING EMERGENCY EXIT LIGHT HOUSING IS BROKEN. / REMOVED AND REPLACED MID CABIN OVERHEAD CEILING EMERGENCY EXIT LIGHT HOUSING IAW AMM 33-51-01-960-802. PERFORMED OPS CHECK. OPS CHECK GOOD.SDR SWAA2020081006583Lens · damagedL1 ENTRY DOOR; EMERGENCY LIGHT LENS DAMAGED. REMOVED AND REPLACED L1 ENTRY DOOR EMERGENCY LENS LIGHT AS PER REF B737 AMM 33-51-01-960-801.SDR SWAA2020081006451Lens · looseEMERGENCY LIGHT LENSES ARE HANGING DOWN ABOVE SEATS 8D & 11D / RE-FASTENED LENSES OVER AT ROWS 8D & 11D AMM 33-51-03SDR CALA2020080901090Battery Pack · dischargedBATTERY PACK FOR 13WL WILL NOT PASS CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK 13WL AND OP CHECKED GOOD IAW AMM 33-51-38-000-002-A & 33-51-38-400-002-A.SDR DALA2020080762737Power Supply · inoperativeLEFT OVERHEAD AISLE EMERGENCY LIGHTS FROM SEATS 50 - 55 AND L4 DOOR WERE INOPERATIVE. REPLACED THE POWER SUPPLY. SYSTEM OPS NORMAL.SDR DALA2020080762735Battery Pack · dischargedAFT EMERGENCY EXIT LIGHTS INOPERATIVE AT TOP LEFT AND RIGHT DOORS. FOUND M737 EMERGENCY LIGHT BATTERY DEAD. REPLACED THE BATTERY, SYSTEM OPS NORMAL.SDR DALA2020080762734Battery Pack · inoperativeEMERGENCY LIGHTS FROM ROWS 23 - 29 WERE INOPERATIVE. REPLACED THE BATTERY PACKS AT M10567 AND M10568. SYSTEM OPS NORMAL.SDR AALA202008069015Power Supply · faultedAIRCRAFT IN BASE MAINTENANCE, EMERGENCY POWER SUPPLY UNIT 10WL FAULTS DURING BITE TEST. REPLACED EMERGENCY POWER SUPPLY UNIT AT 10WL IAW AMM 33-51-38. BITE CHECKED GOOD.SDR AALA202008069012Cover · brokenAIRCRAFT WAS NOT GROUNDED. EXIT LIGHT COVER ASSEMBLY AT AFT RIGHT SERVICE DOOR WAS BROKEN. REMOVED AND REPLACED EXIT LIGHT COVER ASSEMBLY AT AFT RIGHT SERVICE DOOR IAW AMM 33-51-01.SDR AALA202008069003Light · brokenAIRCRAFT IN BASE MAINTENANCE. R1 DOOR FORWARD LOWER EXIT LIGHT WAS BROKEN AT THE MOUNTING SCREW. INSTALLED A NEW LIGHT ASSEMBLY IAW AMM 33-51-16.SDR DALA2020080652731Lens · missingDURING INSPECTION, FOUND EMERGENCY LIGHT LENS ABOVE LAV 205 MISSING. REPLACED LENS FOR EMERGENCY LIGHT.SDR I5EA2020080500001Battery Pack · inoperativeR-1 EMERGENCY EXIT SIGN FAILS TO ILLUMINATE. CORRECTIVE ACTION: REMOVED AND REPLACED R-1 EMERGENCY LIGHT POWER SUPPLY AT STA.330L EQUIP #1133. OPS CHECK GOOD IAW B737-400 AMM 33-51-12SDR ASAA2020082143051Battery Pack · dischargedR2 DOOR EMERGENCY EXIT LIGHTS INOPERABLE. GROUNDED - YES. REMOVED, REPLACED, AND OPS CHECK OF BATTERY PACK M1672 AND R2 DOOR EMERGENCY LIGHT, GOOD IAW B737 AMM 33-81-06-960-805.SDR AALA2020081059012Connector · disconnectedAIRCRAFT IN BASE MAINTENANCE: 17ABC EMERGENCY LIGHT SIDE WALL ENCLOSURES INOPERATIVE OVERWING EXIT. RE-PINNED CONNECTOR D12452 IAW 20-61-28. EMERGENCY LIGHTS OP CHECK GOOD IAW AMM 33-51-00.SDR SWAA2020081005955Light · inoperativeEXTERNAL EXIT LIGHT RIGHT SIDE AFT OF WING FLAP IS OUT / REPLACED FUSE FOR RIGHT GROUND ILLUMINATION EXIT LIGHT STA757 PER AMM 33-51-06-960-804 AND REPLACED LAMP FOR RIGHT STA757 GROUND ILLUMINATION EXIT LIGHT PER AMM 33-51-04-960-801. OPS CHECKED RIGHT GROUNDSDR SWAA2020081006094Cover · brokenEMERGENCY EXIT LIGHT SWITCH COVER BROKEN / REMOVED AND REPLACED SWITCH COVER REF. SIP AND 33-51-00SDR SWAA2020081006358Battery Pack · inoperativeL/H OVERWING EMERGENCY LIGHT L1365 INOP. / REMOVED AND REPLACED BATTERY PACK CHARGER ASSEMBLY M1668; OP CK GOOD PER AMM 33-51-06.SDR DALA2020080762736Fuse · failedAFT GALLEY CEILING EMERGENCY EXIT SIGN INOPERATIVE. REPLACED THE FUSE IN BATTERY PACK. SYSTEM OPS NORMAL.SDR DALA2020080652732Battery Pack · inoperativeDURING INSPECTION FOUND MULTIPLE EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACKS M2816 , M2626, M1670 AND M2335 IAW AMM 33-51-06. OPS CHECKED GOOD.SDR AALA202008059015Flashlight · inoperativeAIRCRAFT NOT GROUNDED - L1 EMERGENCY FLASHLIGHT INOPERATIVE. REMOVED AND REPLACED FLASHLIGHT ASSEMBLY, AMM 25-64-00.SDR AALA202008059014Battery · faultyAIRCRAFT WAS NOT GROUNDED: CABIN INTERCOMMUNICATION DATA SYSTEM 1 FAULT MESSAGE EMERGENCY POWER SUPPLY UNIT BATTERY 15WL. REMOVED AND REPLACED 15WL EMERGENCY POWER SUPPLY UNIT BATTERY PER AMM 33-51-38 .SDR AALA202008059002Lamp · burned outAIRCRAFT WAS NOT GOUNDED: R1 EMERGENCY EXIT LIGHT HAS SEVERAL LAMPS INOPERATIVE. RELAMPED R1 EXIT LIGHTS. CHECKS GOOD.SDR AALA202008059001Lamp · burned outAIRCRAFT WAS NOT GROUNDED: L1 EMERGENCY EXIT LIGHT ABOVE ENTRY SEVERAL LAMPS INOPERATIVE. RELAMPED L1 EMERGENCY EXIT LIGHT ABOVE ENTRY.SDR WX0A2020080573548Relay · inoperativeEMERGENCY EXIT SIGNS THROUGHOUT CABIN KEEP FLICKERING ON AND OFF DURING FLIGHT / PERFORMED TSM 33-51-00-810-819-A R&R RELAY 8WL IAW ESPM 20-46-50. NO FURTHER FAULTS NOTED."SDR WX0A2020080573547Power Supply · inoperativeEMERGENCY EXIT LIGHT EPSU TEST FAILS 11WL LEFT EMERG EXIT. REMOVED AND REPLACED 11WL EPSU AND BITE CHECKED GOOD. EPSU TEST OK. IAW AMM 33-51-38-000-001-A, AND 33-51-58-400-001-A."SDR WX0A2020080573546Battery Pack · inoperativeDURING EPSU BATTERY TEST EPSU 13WL BATTERY FAULT LIGHT ILLUMINATED. REMOVED AND REPLACED EPSU 13WL BATTERY REF AMM 33-51-38 PB401. OPS CHECKED GOOD.SDR DALA2020080542714Battery Pack · inoperativeEMERGENCY LIGHTS AT L1 DOOR ARE INOPERATIVE. REPLACED FORWARD CABIN EMERGENCY LIGHT BATTERY PACK. SYSTEM OPERATION IS NORMALSDR AALA202008059007Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT ROW 14 CTR CEILING EXIT LIGHT FWD HAS SEVERAL LAMPS INOPERATIVE. REPLACED THE LAMPS.SDR AALA202008059006Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED: SEAT ROW 14 CTR CEILING AFT FACING EXIT LT HAS SEVERAL LAMPS INOPERATIVE. REPLACED THE LAMPSSDR AALA202008059004Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED, LEFT OVERWING EXIT LIGHT HAS SEVERAL LAMPS INOPERATIVE. REPLACED THE LAMPS.SDR AALA202008059003Lamp · inoperativeAIRCRAFT WAS NOT GROUNDED, RT OVERWING EXIT LIGHT HAS SEVERAL LAMPS INOPERATIVE. REPLACED THE LAMPS.SDR SIMA202008054001Light · inoperativeDURING PS-2 CHECK, FOUND RH AFT EXTERNAL EMERGENCY LIGHT TO BE INOPERATIVE. R & R RT AFT EMERGENCY LIGHT IAW AMM 33-50-10. NO FURTHER DEFECTS NOTED.SDR SWAA2020080605957Fixture · brokenCENTER ISLE EXIT LIGHT FIXTURE BROKEN. REMOVED AND REPLACED EMERGENCY EXIT LIGHT ASSY IAW AMM 33-51-04.SDR SWAA2020080605770Lens · looseEMERGENCY LIGHT LENS UNSECURE AT THE LEFT OVERWING EXIT. SECURED THE LEFT OVERWING EMERGENCY LIGHT LENS IAW SIP.
Back to JASC 3350