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 MASA 201610212471Power Supply · inoperativeR2 DOOR EMERGENCY EXIT SIGN INOPERTIVE. R & R POWER SUPPLYSDR MASA2016102112470Bulb · inoperativeFWD BULKHEAD EMERGENCY EXIT SIGN HAD TWO BULBS INOPERATIVE.SDR HNAA2016102100326Bulb · inoperativeEMERGENCY LIGHT INOPERATIVE. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR HNAA2016102100325Bulb · inoperativeCABIN EMERGENCY EXIT LIGHT AT AIR STAIR DOOR HAS NUMEROUS BULBS THAT WILL NOT ILLUMINATE. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR AALA201610229015Charger · inoperativeEMERGENCY EXIT SIGN BETWEEN L2 AND R2 DOOR INOPERABLE. REPLACED BATTERY CHARGER ASSEMBLY ABOVE DOOR R2 PER AMM 33-51-07-022-020 AND AMM 33-51-07-862-054.SDR AALA201610229009Lens · missingRIGHT DOOR EMERGENCY EXIT MISSING ARMED SLIDE LIGHT COVER LENS. REPLACED THE LENS IAW AMM 52-20-00.SDR AALA201610229007Battery Pack · inoperativeALL AFT EMERGENCY EXIT DOOR LIGHTS AND SEAT LIGHTS INOPERATIVE. REMOVED AND REPLACED EMERGENCY POWER SUPPLY UNIT BATTERY BETWEEN THE AFT PASSENGER DOORS AND OPS CHECKED GOOD IAW AMM 33-51-38.SDR AALA201610229005Lens · missingEMERGENCY LIGHT COVER MISSING AT ROW 20C REPLACED THE LENS AND ACCOMPLISHED SATISFACTORY CHECK.SDR DALA2016102407472Lamp · inoperativeDURING INSPECTION FOUND L1 DOOR EXTERIOR LIGHT INOPERATIVE. MAITNENANCE REPLACED THE LAMP. OPS CHECKED GOOD.SDR ASAA2016102018442Light · looseF/A REPORTED THE FLOURSCENT EMERGENCY EXIT LIGHT STRIP, A BEAM FWD CLOSET, ON AISLE FLOOR (LEFT) COMING LOOSE. ACFT GROUNDED. REPLACED THE EMERGENCY LIGHT IAW AMM 33-51-15.SDR DALA2016102407479Light · detachedEMERGENCY LIGHT STRIP DETACHED. ATTACHED THE LIGHT.SDR SWAA2016102108968Sign · damagedR1 DOOR EXIT SIGN MISSING AN ARROW. R & R SIGN IAW AMM.SDR SWAA2016102108965Battery Pack · no testEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST. R & R THE BATTERY PACK IAW AMM.SDR QXEA2016102100671Battery Pack · defectiveAFT OVERHEAD EMERGENCY EXIT LIGHT WILL NOT REMAIN ILLUMINATED WHEN SELECTED TO ON. REPLACED SPLICE E23, LIGHTS WORK BUT ONLY FOR A FEW SECONDS. REPLACED BATTERY PACKS IAW AMM 33-51-00. RETURNED TO SERVICE.SDR QXEA2016102100670Light · inoperativeF/A SWITCHLIGHT FOR THE EMERGENCY LIGHTS INOP. RELAMPED PUSH BUTTON SWITCH. CHECKS GOOD. RETURNED TO SERVICE.SDR QXEA2016102100669Light · looseFORWARD EMERGENCY FLOOR STRIP BY SEAT 1B LOOSE. RESECURED LIGHT STRIP. CHECKS GOOD. RETURNED TO SERVICE.SDR AALA20161021003Battery Pack · faultyEMERGENCY LIGHTS AT ROWS 26-36 ARE DARK. REMOVED AND REPLACED CONTROL MODULE AND BATTERY PACK IAW AMM 33-51-11 AND AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR AALA20161021002Light · detachedL2 DOOR AFT EMERGENCY EXIT LIGHT BROKEN OFF WALL AND HANGING FROM WIRES. REMOVED AND REPLACED LIGHT ASSEMBLY IAW AMM 33-51-19. OPERATIONAL CHECKED GOOD.SDR AALA20161020009Control Module · faultyAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS AT ROWS 26-36 ARE DARK. REMOVED AND REPLACED CONTROL MODULE M10801 AND BATTERY PACK IAW AMM 33-51-11 AND AMM 33-51-00. OPERATIONAL CHECKED GOOD.SDR SIMA20161020002Sign · inoperativeEMERGENCY LIGHT NEAR PAX DOOR FLOOR IS INOPERATIVE. REMOVED AND REPLACED THE SIGN IAW AMM 33-51-05. OPS CHECKED GOOD.SDR JJBA20161020026Light · malfunctionedEMERGENCY LIGHTS TURNING ON AND OFF IN FLIGHT AND DURING TAXI. TAXIED AIRCRAFT AND PERFORMED OPS CHECK. COULD NOT DUPLICATE FAULT. NO DEFECTS.SDR DALA2016102107426Battery · dischargedDURING LINE CHECK, MAINTENANCE FOUND THAT THE EMERGENCY PATHWAY LIGHTING AT SEAT 20BCD IN THE CABIN WAS INOPERATIVE. MAINTENANCE REPLACED THE BATTERY AND THE OPERATIONAL CHECK WAS GOOD.SDR MASA2016102012468Light · inoperative
ROW 18 EMERGENCY CEILING LIGHT INOP
. PLACED ON MEL.SDR MASA2016102012467Light · inoperativeEMER FLOOD LIGHT ROW 15 INOP
. PLACED ON MEL.SDR JJBA20161020024Bulb · unsecureEMERGENCY LIGHT OVER ROW 12 INOPERATIVE. SECURED THE BULB, OPS CHECKED GOOD.SDR SWAA2016110909531Lens · brokenFORWARD GALLEY AREA EMERGENCY EXIT SIGN LENS BROKEN. R & R THE LENS IAW AMM.SDR AALA201610229004Lens · missingAIRCRAFT WAS NOT GROUNDED. MISSING MID LAVATORY EMERGENCY LIGHT LENS. INSTALLED NEW LENS AS REQUIRED.SDR AALA201610219002Cover · missingMISSING EMERGENCY EXIT LIGHT COVER AT SEAT 3AC. REPLACED THE LIGHT COVER AND TESTED IAW AMM 33-50-00.SDR AALA201610219001Light · damaged. DAMAGED EMERGENCY LIGHT ON AISLE AT SEAT 10L. REPLACED LIGHT ASSEMBLY IAW JOB CARD 26L00005005.SDR SWAA2016102408989Battery Pack · no testEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY CHECK. R & R THE BATTERY PACK IAW DWG.SDR SWAA2016102408960Lens · brokenFORWARD ENTRY EXIT SIGN LENS BROKEN. REPAIRED THE LENS IAW EA.SDR SWAA2016102108969Light · damagedFORWARD GALLEY EMERGENCY LIGHT STRIP DAMAGED. R & R THE LIGHT IAW DWG.SDR AALA20161020002Battery Pack · failedAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHTS BATTERY PACK AB5-1 FAILED WORK CARD 5403. REMOVED AND REPLACED BATTERY PACK IAW AMM 33-60-98. OPERATIONAL CHECK GOOD.SDR AALA20161020001Battery Pack · no testEMERGENCY LIGHTS BATTERY ASSEMBLY B5-102 AT ROWS 11-17 FAILED WORK CARD 0801. REMOVED AND REPLACED BATTERY ASSEMBLY IAW AMM 33-53-00. OPS CHECKED GOOD.SDR SWAA2016102108948Lens · missingBULLNOSE EMERGENCY LIGHT LENS MISSING AT ROW 14 DEF. INSTALLED THE LENS IAW MM.SDR SWAA2016102108942Sign · looseL1 DOOR EXIT SIGN LOOSE. SECURED THE SIGN IAW MM.SDR SWAA2016102108932Sign · looseOVERHEAD EXIT SIGN LOOSE. SECURED THE EXIT SIGN IAW MM.SDR ASAA2016101918419Sign · detachedL2 EXIT SIGN FELL OFF. ACFT GROUNDED. INSTALLED L2 EMERGENCY EXIT LIGHT COVER.SDR SIMA20161019002Power Supply · inoperativeDURING PS-2 INSPECTION FOUND LT FAIRING FWD EMERGENCY LIGHT INOP. R&R BATTERY POWER SUPPLY IAW AMM 33-50-04. OPS CHECK GOOD. NO FURTHER DEFECTS NOTED. LT LIGHT EMERGENCY P/N 30-2510-3SDR AALA20161019014Light · brokenAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT AFT GALLEY. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-05.SDR AALA20161019013Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT 4F LEFT LAVATORY ON AFT SIDE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-05.SDR AALA20161019012Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT 3F LEFT LAVATORY ON AFT SIDE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-05.SDR AALA20161019011Lens · missingAIRCRAFT WAS NOT GROUNDED. MIDDLE EMERGENCY LIGHT LENS MISSING AT 3F RIGHT LAVATORY ON AFT SIDE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-05.SDR AALA20161019010Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT 3F RIGHT LAVATORY ON AFT SIDE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-05.SDR AALA20161019009Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT MID GALLEY BAR AREA. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-05.SDR AALA20161019008Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT MID GALLEY FORWARD PARTITION ON LEFT SIDE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-05SDR AALA20161019007Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY LIGHT LENS MISSING AT MID GALLEY FORWARD PARTITION ON RIGHT SIDE. REMOVED AND REPLACED LIGHT ASSEMBLY IAW 33-51-05.SDR REXA2016101902000Light · missingEMERGENCY LIGHT LOCATED IN GALLEY IS MISSING. SECURED THE EMERGENCY LIGHT IAW AMM 33-51-01SDR REXA2016101901998Inverter · inoperativeAFT EMERGENCY LIGHTS FOUND INOPERATIVE. REMOVED AND REPLACED AFT EMERGENCY LIGHT INVERTER IAW AMM 33-51-07 .SDR JJBA20161019022Battery Pack · dischargedEMERGENCY LIGHTS ARE INOPERATIVE, FOUND SWITCH IN ON POSITION. CHARGED BATTERIES. ALL OPS CHECK GOOD.
Back to JASC 3350