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 ASOA2016082915326Light · inoperativeROW 17, CEILING EMERGENCY LIGHT BULB BURNED. R & R ROW 17 CEILING EMERGENCY LIGHT IAW AMM 33-51-07. OPS CHECKED GOOD.SDR ASOA2016082915325Battery · unserviceableLT AND RT FORWARD OVERWING EMERGENCY EXIT LIGHTS INOPERATIVE. FOUND NR 3 BATTERY LAYING IN OVERHEAD PANEL, BROKE ATTACHMENT STUD TRYING TO REINSTALL BATTERY. REPLACED BATTERY WITH SERVICE BATTERY IAW AMM 33-51-17. OPS CHECK GOOD. IPC 33-51-17, FIG 1, ITEM 6SDR VNAA2016082900039Battery Pack · inoperativeEMERGENCY LIGHTS ROW TWO - FIVE INOPERATIVE. MAINTENANCE INSPECTED AND, REMOVED AND REPLACED THE BATTERY POWER SUPPLY AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR VNAA2016082900038Power Supply · intermittentEMERGENCY LIGHTS ROW TWO - FIVE INOPERATIVE. REMOVED AND REPLACED THE POWER SUPPLY UNIT AND PERFORMED CHECKS IAW THE AMM. THE AIRCRAFT WAS RELEASED FOR SERVICE.SDR AALA20160830004Power Supply · no testEMERGENCY LIGHTS ROW 27-32 FAILED TO TEST. REPLACED THE POWER SUPPLY IAW AMM 33-53-00. TESTED OK.SDR AALA20160830003Power Supply · no testEMERGENCY LIGHTS ROW 11-17 FAILED TO TEST. REPLACED THE POWER SUPPLY IAW AMM 33-53-00. TESTED OK.SDR AALA20160830002Power Supply · no testFORWARD INTERIOR EMERGENCY EXIT LIGHTS FAIL TO TEST. REPLACED EMERGENCY LIGHT POWER SUPPLY IAW AMM 33-53-00. TEST OK.SDR AALA20160829001Battery Pack · dischargedEMERGENCY LIGHT BATTERY PACK DISCHARGED. REPLACED THE BATTERY PACK IAW MM 33-51-06, OPS CHECKED GOOD. THE AIRCRAFT WAS GROUNDED.SDR SWAA2016083155303Cover · detachedRIGHT OVERWING EMERGENCY EXIT SIGN COVER FELL OFF. SECURED THE SIGN COVER IAW SIP.SDR SWAA2016083155302Lamp · inoperativeL1 DOOR LOWER EXIT LIGHT INOPERATIVE. R & R THE LAMP IAW AMM.SDR SWAA2016083155297Battery Pack · no testAFT GALLEY RT EMERGENCY FAILED 15 MINUTE CYCLE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016083155296Battery Pack · no testAFT GALLEY LEFT EMERGENCY FAILED 15 MINUTE CYCLE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016083155295Bulb · inoperativeLEFT FORWARD OVERWING EMERGENCY ESCAPE LATCH LIGHT BULB INOPERATIVE. R & R THE BULB IAW AMM.SDR SWAA2016083155289Battery Pack · no testFORWARD RIGHT EMERGENCY BATTERY FAILED 15 MINUTE CYCLE. R & R THE BATTERY PACK IAW AMM.SDR SWAA2016083155284Battery Pack · no testFORWARD LEFT EMERGENCY LIGHT BATTERY FAILED 15 MINUTE CYCLE. R & R THE BATTERY PACK IAW AMM.SDR HNAA2016083100265Lamp · inoperativeEMERGENCY LIGHTS DISARM CAUTION LIGHT INOPERATIVE, REPLACED THE LAMP. OPS CHECKED GOOD. OK FOR SERVICE.SDR ASAA2016082917845Lamp · failedEMERGENCY LIGHT EXIT LOCATOR SIGN AT L1 AND L2 DOORS HAS SEVERAL LAMPS INOPERATIVE. ACFT GROUNED. REPLACED THE LAMPS AND TESTED IAW AMM 33-51-01-960-801, OPS NORMAL.SDR AALA201608309008Light · inoperativeAIRCRAFT IN BASE MAINTENANCE, R2 DOOR SURROUND EMERGENCY LIGHT IS HALF INOPERATIVE. REPLACED EMERGENCY EXIT IDENTIFIER SIGN AND ACCOMPLISHED A SATISFACTORY OPS CHECK IAW AMM 33-50-15-400-801-A.SDR AALA201608309002Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT RT AFT LAV. REPLACED LENS COVER.SDR SIMA20160829002Lamp · inoperativeLEFT OVERWING EXIT LIGHT INOPERATIVE. REPLACED THE LAMP, OPS OK IAW AMM 33-50-10SDR SWAA2016083055267Lens · unsecureAFT GALLEY EMERGENCY EXIT SIGN FELL OFF. SECURED LENS IAW SIP.SDR SWAA2016083055260Light · inoperativeL1 DOOR EMERGENCY EXIT SLIDE LIGHT INOPERATIVE. RELAMPED LIGHT IAW AMM.SDR SWAA2016083055259Lens · brokenRIGHT WING EMERGENCY EXIT DOOR LIGHT LENS BROKEN. R & R LIGHT ASSEMBLY IAW AMM.SDR MASA2016082912342Light · inoperativeROW 17 EMERGENCY FLOOD LIGHT INOPERATIVE.SDR A6WA201644276Light · inoperativeFLIGHT 3862. LEFT LOWER EXIT LIGHT ROW 8 INOPERATIVE. FLOOR LIGHT ROWS 2-5 INOPERATIVE CYCLED EMERG LIGHT SWITCH. EMERGENCY LIGHTS OPS CHECK GOOD IAW AMM 33-51SDR REXA2016082801612Light · missingLIGHT STRIP NEXT TO FORWARD LAV AND BY EXIT ROWS 12+13 MISSING. REINSTALLED FLOOR STRIPS ON FWD LAV AND ROWS 12+13. NO FURTHER DEFECTS NOTED. REINSTALLED AS REQUIRED.SDR AALA201608299004Light · looseAIRCRAFT WAS NOT GROUNDED: EMERGENCY FLOOR LIGHTING AT SEAT ROW 12 IS COMING LOOSE. SECURED EMERGENCY FLOOR LIGHTING AT SEAT ROW 12.SDR MASA2016082812341Lamp · inoperativeROW 6 EMERGENCY CEILING FLOOD LIGHT INOPERATIVE. REPLACED THE LAMP.SDR C77A20160829003Power Unit · inoperativeEMERGENCY LIGHTS AT L1 DOOR, ABOVE ROW 3, AND ABOVE ROW 9 INOPERATIVE. R & R EMERGENCY LIGHT POWER UNIT IAW AMM 33-50-01. OPS CHECK GOOD. ACFT OK FOR SERVICE.SDR SIMA20160828002Switch · failedF/A FWD FLASHLIGHT SWITCH CAME APART. REMOVED AND REPLACED THE FLASHLIGHT IAW STANDARD MAINTENANCE PRACTICESSDR SIMA20160828004Lamp · inoperativeCOCKPIT EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE LAMP IAW AMM 33-50-05-000-801-A AND 33-50-05-400-801-A. OPS CHECKED GOOD.SDR SIMA20160828003Bulb · inoperativeSERVICE DOOR EMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULB IAW AMM 33-50-10-000-801-A AND 33-50-10-400-801-A. OPS CHECKED GOOD.SDR JJBA20160828017Light · malfunctionedEMERGENCY LIGHT AT ROW 1 IS INOPERATIVE. PERFORMED OPS CHECKED AND LIGHT IS WORKING AS REQUIRED.SDR DALA2016082806240Light · missingDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY EXIT IDENTIFIER IN THE FLOOR AT SEAT 19AB IN THE CABIN WAS MISSING, AND INOPERATIVE. MAINTENANCE INSTALLED THE FLUORESCENT STRIP FOR THE NOTED AREA AND THE OPS CHECK WAS GOOD.SDR AALA20160827005Light · brokenSEAT 20D EMERGENCY LIGHT SHROUD BROKEN AND DAMAGED. REPLACED THE LIGHT SHROUD IAW AMM 33-51-11. CHECKED NORMAL.SDR AALA20160827004Light · brokenSEAT 17D EPM PROXIMITY SWITCH LIGHT SHROUD BROKEN & DAMAGED. REPLACED THE LIGHT SHROUD IAW AMM 33-51-11. CHECKED NORMAL.SDR AALA20160827003Light · brokenSEAT 15 D PROXIMITY LIGHT SHROUD EMP BROKEN & DAMAGED. REPLACED THE LIGHT SHROUD REF. AMM 33-51-11. CHECKED NORMAL.SDR AALA20160827002Light · brokenSEAT 8D EPM PROX LIGHT SHROUD BROKEN & DAMAGED. REPLACED THE LIGHT SHROULD REF. AMM 33-51-11. CHECKED NORMAL.SDR REXA2016082701611Light · inoperative2 FORWARD OVERWING EMERGENCY LIGHTS ON LT WING AND 2 AFT OVERWING EMERGENCY LIGHTS ON THE WING INOPERATIVE. CONTINUATION CARD 81519411, OP 255. REMOVED PANEL 251NLW AND REINSTALLED PANEL AFTER CONNECTING P377 CONNECTOR IAW ESPM 20-26-00 AND AMM 25-26-01-400-SDR CALA2016083095699Connector · damagedEMERGENCY LIGHTS AT SEATS 11C, 29C DO NOT ILLUMINATE WHEN POWER OFF 11C OK, REPINNED SEAT 29C CONNECTOR, OPS CHECKED GOODSDR SWAA2016083055257Lens · missingR2 DOOR FLOOR LEVEL EXIT SIGN LENS MISSING. R & R LENS ASSEMBLY IAW MM.SDR SWAA2016082955237Sign · brokenR2 DOOR EMERGENCY EXIT SIGN BROKEN. R & R SIGN IAW AMM.SDR SCNA20160827109Battery Pack · inoperativeLEFT AFT EMERGENCY LIGHT BATTERY PACK NOT CHARGING. R & R THE BATTERY PACK AND CHARGER. FUNCTION CHECKED GOOD.SDR SCNA20160827108Lamp · inoperativeROW 22DEF EMERENCY LIGHT INOPERATIVE. REPLACED THE LAMP.SDR SCNA20160827107Charger · no testLEFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER. FUNCTIONAL CHECK GOOD.SDR SCNA20160827106Battery Pack · no testRIGHT OVERWING WINDOW EMERGENCY LIGHT BATTERY PACK FAILED CAPACITIANCE CHECK. R & R BATTERY PACK. OPS CHECKED GOOD.SDR SCNA20160827105Charger · no testLEFT FWD EMERGENCY BATTERY PACK FAILED CAPACITY CHECK. REMOVED AND REPLACED THE BATTERY PACK AND CHARGER. FUNCTIONAL CHECKED GOOD.SDR SCNA20160827104Battery Pack · no testRIGHT AFT EMERGENCY LIGHT BATTERY PACK FAILED CAPACITIANCE CHECK. R & R THE BATTERY PACK. OPS TESTED GOOD.SDR DALA2016082906259Switch · failedEMERGENY LIGHTING NOT OPERATING IN COMMANDED POSITION. FOUND EMERGENCY LIGHT SWITCH AT P62 NLG PANEL INTERMIT. R & R S10035 SWITCH IAW SWPM 20 SHOOK WIRES DOWN NO FAULTS NOTED. R & R EMERGENCY LIGHT BATTERY M732, M731, M10919. IAW AMM 33-51-07. OPS OK.SDR REXA2016082701608Lamp · inoperativeLEFT EXTERNAL EMERGENCY LIGHT JUST FWD OF WING INOPERATIVE. REPLACED THE LAMP IAW AMM 33-51-21
Back to JASC 3350