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 SIMA20160827004Bulb · inoperativeSERVICE DOOR EMERGENCY LIGHT IS INTERMITTENT. REMOVED AND REPLACED THE LIGHT SOCKET IAW 33-50-10. OPS CHECKED GOOD.SDR SIMA20160827003Bulb · inoperativeEXTERNAL OVER THE WING EMERGENCY LIGHT ON RIGHT WING IS INOPERATIVE. REMOVED AND REPLACED AND OPS CHECKED EXTERNAL EMERGENCY LIGHT BULB IAW AMM 33-50-10. OPS CHECKED GOOD.SDR SIMA20160826005Battery Pack · not reportedREMOVE AND REPLACE NR 1 EMERGENCY LIGHTING BATTERY ASSY/ BATTERY CHARGER. REMOVED AND REPLACED BATTERY ASSY AND CHARGER IAW WC 33-700-19SDR SIMA20160826007Light · damagedNR 1 LEFT EMERGENCY LIGHT DAMAGED. REMOVED AND REPLACED THE LIGHT IAW AMM 33-50-12.SDR REXA2016082601610Cover · damagedEMERGENCY LIGHT HAS LARGE AREAS DAMAGED TO THE COVER SECTIONS. REPLACED THE LIGHT IAW AMM 33-51-01.SDR DALA2016082906279Battery Pack · inoperativeFWD LEFT AND RIGHT OVERWING EMERGENCY EXIT SIGNS INOPERATIVE. R & R BATTERY PACK IAW MM 33-51.SDR CALA2016083095698Battery Pack · no testLEFT OVERWING EMERGENCY LIGHT BATTERY FAULT DURING 2SVC, REPLACED THE BATTERY, TEST PASSEDSDR CALA2016083095697Power Supply · malfunctionedDURING TEST AT CIDS PANEL, EPSU UNIT FWD LT DISPLAYED. REPLACED EPSU AT FWD LEFT POSITION AND TEST PASSED OKSDR SWAA2016082955238Lens · crackedL1 DOOR EXIT SIGN LENS CRACKED. R & R LIGHT ASSEMBLY IAW MM.SDR SWAA2016082955216Light · inoperativeRIGHT EMERGENCY LIGHT INOPERATIVE BETWEEN ROW 8 TO ROW 13. R & R LAMP IAW AMM.SDR SWAA2016082955215Light · inoperativeAFT GALLEY AREA EMERGENCY LIGHT INOPERATIVE. R & R LAMP IAW AMM.SDR SWAA2016082955214Light · inoperativeFORWARD GALLEY AREA CENTER EMERGENCY LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2016082955213Light · inoperativeLEFT SIDEWALL EMERGENCY LIGHT INOPERATIVE. R & R LIGHT IAW AMM.SDR SWAA2016082955211Circuit Breaker · poppedCABIN EMERGENCY LIGHTS CIRCUIT BREAKER POPPED ON P6-11 CIRCUIT BREAKER PANEL. RESET CIRCUIT BREAKER IAW SWPM.SDR UHLA201608260421Power Supply · inoperativeEMERGENCY LIGHT OVER ROW 6 INOPERATIVE. R & R FWD NR 1 EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPS CHECKED GOOD.SDR HNAA2016082900263Bulb · inoperativeROW 1, 4TH EMERGENCY LIGHT FROM THE FRONT IS OUT. R & R THE BULB.SDR HNAA2016082900262Battery Pack · weakFA EMERGENCY LIGHT SWITCH DOES NOT OPERATE EMERGENCY LIGHTS. ON MAIN AND AUX BATTERIES, BEING REINSTALLED THE SWITCH CYCLED PROPERLY. OPS CHECKED GOOD.SDR C77A20160829002Battery · defectiveR1 FLASHLIGHT RED LIGHT NOT BLINKING.SDR SIMA20160826004Cradle · damagedFA NR 2 FLASHLIGHT WILL NOT REMAIN IN CRADLE. REMOVED AND REPLACED THE FLASHLIGHT MOUNTING BRACKET IAW AMM 25-61-02. OPS CHECKED GOOD.SDR A6WA201644263Light · inoperativeDURING FIRST FLIGHT ACCEPTANCE INSPECTION CREW REPORTED THE EMERGENCY FLOOR TRACK LIGHTING WAS INOPERATIVE FROM ROW 1-5.SDR A6WA201644264Light · inoperativeEMERGENCY FLOOR TRACK LIGHTING ROWS 9-12 WILL NOT ILLUMINATE.SDR AALA201608279003Lens · unsecureAIRCRAFT WAS NOT GROUNDED: AFT CENTER ISLE EMERGENCY EXIT LIGHT LENS UNSECURED. REPLACED EMERGENCY EXIT LIGHT LENS ON AFT CENTER ISLE AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 20-00-00.SDR AALA201608279002Lens · unsecureAIRCRAFT WAS NOT GROUNDED: R2 DOOR LOWER LT EMERGENCY EXIT LIGHT LENS COVER WILL NOT STAY IN PLACE. INSTALLED NEW EMERGENCY EXIT LIGHT LENS COVER AT THE R2 DOOR IAW AMM 33-51-13.SDR AALA20160826005Light · inoperativeR4 EXIT EMERGENCY EXIT LIGHT LOOSE. REMOVED AND REPLACED R4 LOWER AFT EMERGENCY EXIT LIGHT ASSEMBLY REF: AMM 33-51-13. OPS CHECKED GOOD.SDR AALA20160826004Lens · detachedL4 DOOR FORWARD EXIT SIGN LENS DETACHED. EXIT SIGN REPLACED IAW AMM 33-51-01 AND TESTED IAW ECO B1715AB-0004 STEP 1D(I)(T).SDR AALA20160826003Lens · brokenR2 DOOR FOUND FORWARD EXIT SIGN BROKEN. EXIT SIGN REPLACED IAW AMM 33-51-01 AND TESTED IAW ECO B1715AB-0004 STEP 1D(I)(T).SDR CALA2016082600588Light · inoperativeR2 DOOR EMERGENCY REFLECTOR LIGHT INOPERATIVE. REPLACED THE LIGHT ASSY IAW AMM 33-51-06, TESTED GOODSDR HNAA2016082600259Power Supply · inoperativeLEFT FWD EGRESS LEFT INOPERATIVE. R & R EMERGENCY LT POWER SUPPLY.SDR DALA2016083006615Charger · inoperativeDURING PD FOUND EMERGENCY LIGHTS INOPERATIVE AT SEATS 10,11 AND 12. REPLACED THE POWER CHARGER SYSTEM OPERATION IS NORMAL.SDR DALA2016083006273Light · looseSEAT MOUNTED EMERGENCY LIGHT LOOSE AT 16DEF. SECURED THE LIGHT ASSY.SDR SWAA2016083055272Lens · looseRIGHT EMERGENCY EXIT BULLNOSE LENS LOOSE AT ROW 2. SECURED LENS IAW SIP.SDR SWAA2016082955249Light · inoperativeLEFT OVERWING EXTERIOR EXIT LIGHT INOPERATIVE. RELAMPED IAW AMM.SDR SWAA2016082955203Lens · unknownL1 DOOR EMERGENCY EXIT LIGHT LENS & BASE. R & R LENS ASSEMBLY IAW MM.SDR SWAA2016082955202Battery Pack · dischargedLEFT OVERWING LOWER EMERGENCY EXIT LIGHT INOPERATIVE. R & R BATTERY PACK IAW AMM.SDR UHLA201608250425Battery Pack · inoperativeEMERGENCY LIGHT BATTERY FAULT EICAS MESSAGE APPEARED FOR 30 MINUTES, CLEARED, AND REAPPEARED AGAIN INTERMITTENTLY. THE MESSAGE APPEARS RANDOMLY WITH THE EMERGENCY LIGHT SWITCH IN THE ARMED POSITION. R & R EMERGENCY BATTERY NR 2 IAW AMM 33-50-01.SDR UHLA201608250424Power Supply · failedEMERGENCY LIGHT BATTERY FAULT EICAS MESSAGE. R & R FWD LT EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01-000801A ADJUSTMENT TEST IAW AMM 33-50-01-710-801-A. OPS TEST, MESSAGE CLEARED.SDR VNAA2016082500032Sign · malfunctionedLEFT EMERGENCY EXIT SIGN INOPERATIVE. MAINTENANCE INSPECTED, CYCLED ACFT POWER AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR AALA201608269004Lens · missingAIRCRAFT WAS GROUNDED: EMERGENCY ESCAPE PATH LIGHT LENS AT SEAT 3AC MISSING. REPLACED EMERGENCY LIGHT ASSEMBLY AT SEAT 3AC AND ACCOMPLISHED A SATISFACTORY OPS CHECK.SDR SWAA2016082655173Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1669. R & R BATTERY IAW MM.SDR SWAA2016082655169Light · crackedRIGHT SECOND FROM AFT FLUORESCENT EMERGENCY LIGHT TRACK CRACKED. R & R LIGHT IAW AMM.SDR SWAA2016082655168Battery · failedEMERGENCY LIGHT BATTERIES FAILED CAPACITY TEST AT LOCATION M1675. R & R BATTERY IAW MM.SDR SWAA2016082655167Lens · missingLEFT CEILING EMERGENCY LIGHT LENS MISSING AT ROW 27. R & R LIGHT ASSEMBLY IAW AMM.SDR CALA2016082695689Light · malfunctionedCABIN EMERGENCY LIGHTS TESTED WITH A FAULT MESSAGE. RESET SYSTEM, ALL CHECKED GOODSDR DALA2016082606223Lens · unsecureEMERGENCY EXIT PLACARD MISSING AT RT MID EMERGENCY EXIT. SECURDED THE LENS.SDR HNAA2016082600260Battery · dischargedRIGHT FORWARD EMERGENCY EGRESS LT INOPERATIVE. R & R EMERGENCY LT BATTERY.SDR SWAA2016082555120Lens · missingRIGHT FORWARD OVERWING EXIT SIGN MISSING COVER LENS. INSTALLED LENS IAW MM.SDR CALA2016082500586Light · inoperativeEMERGENCY EXIT LIGHT INOPERATIVE AT DOOR R3 EXTERIOR. RELAMPED R3 DOOR EXTERIOR EMERGENCY LIGHT IAW AMM 33-51-06-962-0 01-002, OPS CKS GOOD.SDR MJYA20160825012Portable Light · inoperativeEMERGENCY EXIT LIGHT SYSTEM, PORTABLE EMERGENCY EXIT LIGHT WILL NOT ACTIVATE WHEN SELECTED TO ON. AWAITING DETAILS ON REPAIR.SDR CALA2016090100614Light · brokenRED EMERGENCY SEAT LIGHT AT 21C BROKEN. REPLACED LENS AND BULBS AT 21C. SEAT EMERGENCY LIGHT OPS CHECK NORMAL.SDR SWAA2016082955227Lens · missingRIGHT OVERWING EXIT LOWER SIGN LIGHT LENS MISSING. INSTALLED LIGHT ASSY IAW AMM.
Back to JASC 3350