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 SWAA2018081324208Cover · missingL1 DOOR EMERGENCY LIGHT MISSING RED ARROW. INSTALLED COVER PER AMM.SDR SWAA2018081324207Cover · missingR1 DOOR EMERGENCY LIGHT MISSING RED ARROW. INSTALLED COVER PER AMM.SDR SWAA2018081324188Battery Pack · failedEMERGENCY LIGHT BATTERY FAILED CAPACITY TEST AT LOCATION M1670. R&R BATTERY PACK PER AMM.SDR DALA2018081085006Switch · malfunctionedEMERGENCY LIGHT ILLUMINATED IN FLIGHT WITHOUT POWER LOSS. REMOVED AND REPLACED THE 4WL EMERGENCY LIGHT SWITCH. OPS CHECKED OK.SDR FDEA201808071943Warning Message · illuminatedEMERGENCY LIGHT BATTERY 1 LOW ALERT DURING TEST.SDR DALA2018081084981Lens · damagedSEAT MOUNTED EMERGENCY LIGHT LENS WAS DAMAGED. REPLACED THE LENS. OK FOR SERVICE.SDR DALA2018081084979Cover · looseEMERGENCY EXIT SIGN COVER WAS LOOSE5. SECURED THE SIGN COVER. OK FOR SERVICE.SDR SWAA2018080924151Sign · looseL1 DOOR LOWER EMERGENCY EXIT SIGN LOOSE. R&R SIGN ASSEMBLY PER AMM.SDR ASAA2018080875701Light · disconnectedWHILE PERFORMING T/C 78233008, FOUND EMERGENCY LIGHT AT ROW 16C INOPERATIVE. ACFT GROUNDED. FOUND EMERGENCY LIGHT ASSY DISCONNECTED. CONNECTED IAW WDM 33-51-13, EMERGENCY LIGHT AT 16C NOW OPS GOOD.SDR SWAA2018080824133Charger · inoperativeL1 DOOR EMERGENCY LIGHT INOP. R&R BATTERY CHARGER IAW AMM.SDR SWAA2018080824119Cover · unsecureR2 DOOR EMERGENCY EXIT LIGHT COVER FELL OFF. R&R LIGHT ASSEMBLY PER AMM.SDR AALA201808089009Lamp · inoperativeRIGHT EMERGENCY DOOR LOWER EXIT LIGHT INOPERATIVE. REMOVED EMERGENCY DOOR EXIT SIGN, REPLACED THE LAMPS, AND PERFORMED SATISFACTORY OPERATIONS CHECK IAW AMM 33-51-16.SDR IPXA2018080872568Bulb · inoperativeEMERGENCY LIGHT HAD TWO INOPERATIVE BULBS. REPLACED THE TWO BULBS IAW AMM 33-51-01.SDR UIEA2018080801636Light · inoperativeDURING AMC INSPECTION, FOUND EMERGENCY O/H LIGHT INOP AT ROW 28H INOP. RELAMPED EMERGENCY AISLE LIGHT AT ROW 28H AND OPS CHECK OK PER AMM 33-51-05.SDR DALA2018080804934Bezel · damagedFLOOR EMERGENCY LIGHT WAS DAMAGED. SECURED EMERGENCY LIGHT BEZEL. OK FOR SERVICE.SDR AALA201808089007Lamp · inoperativeLEFT EMERGENCY LIGHT INOPERATIVE. REPLACED THE LAMP. PERFORMED SATISFACTORY OPS CHECK IAW AMM 33-51-16.SDR AALA201808089006Lens · missingSEAT 3C EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS.SDR DALA2018080804928Sign · missingTHE L1 DOOR UPPER EXIT SIGN WAS MISSING. MAINTENANCE INSTALLED A NEW EXIT SIGN IAW AMM 33-51.SDR DALA2018080704903Lens · missingR2 DOOR EXIT SIGN LENS WAS MISSING. INSTALLED A NEW LENS. OK FOR SERVICE.SDR 2DYA201808206001Bulb · brokenTWO EMERGENCY LIGHTS WERE FOUND DAMAGED AT SEAT 10AC. REMOVED AND REPLACED THE LAMP.SDR AALA2018081079027Bulb · burned outUPPER EXIT SIGN AT THE R2 DOOR HAD BURNED OUT BULBS. REPLACED THE BULBS IAW AMM 33-51-15-000-001-A, AND AMM 33-51-15-400-001-A AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR ASAA2018080865691Power Supply · inoperativeALL EMERGENCY LIGHTS WITH R1 DOOR WILL NOT COME ON. ACFT GROUNDED. REMOVED AND REPLACED THE POWER SUPPLY, OPS CHECKED GOOD IAW AMM 33-51-06-960-806.SDR U2RA2018080860004Lamp · inoperativeSEAT MOUNTED EMERGENCY LIGHT WAS INOPERATIVE AT SEAT ROW 15. REPLACED THE SEAT MOUNTED EMERGENCY LIGHT IAW AMM 33-53-11.SDR SWAA2018080824137Light · inoperativeRT OVERWING EMERGENCY LIGHT AT AFT FLAP INOP. R&R LIGHT IAW AMM.SDR SWAA2018080824125Cover · brokenAFT FLIGHT ATTENDANT PANEL EMERGENCY LIGHT SWITCH COVER SPRING BROKEN. R&R COVER IAW CMM.SDR U2RA2018080860003Lamp · inoperativeSEAT MOUNTED EMERGENCY LIGHT WAS INOPERATIVE AT SEAT ROW 14. REPLACED THE LAMPS IAW AMM 33-53-11.SDR U2RA2018080860002Light · inoperativeSEAT MOUNTED EMERGENCY LIGHT WAS INOPERATIVE, SEAT ROW 3. REPLACED THE EMERGENCY LIGHT IAW AMM 33-53-11.SDR U2RA2018080860001Lamp · inoperativeSEAT MOUNTED EMERGENCY LIGHT WAS INOPERATIVE AT SEAT ROW 29. REPLACED THE SEAT MOUNTED EMERGENCY LIGHT IAW AMM 33-53-11.SDR SWAA2018080824115Lens · brokenAFT PANEL EMERGENCY EXIT LIGHT BUTTON CLEAR LIGHT LENS COVER BROKEN. R&R COVER PER MM.SDR AALA2018080879035Power Supply · failedEMERGENCY LIGHT TEST FAILED, FOR THE 14WL POWER SUPPLY. REPLACED THE POWER SUPPLY IAW MM 33-51-00. OPS CHECKED NORMAL.SDR AALA2018080879034Lens · missingL1 DOOR LOWER EXIT SIGN LENS MISSING. REPLACED THE LENS IAW AMM 33-51-13-400-001-A.SDR AALA2018080879030Bulb · burned outL2 DOOR EXIT SIGN HAD FOUR BURNED OUT BULBS. REPLACED THE BULBS IAW AMM 33-51-15-000-001-A, AND AMM 33-51-15-400-001-A. OPS CHECKED GOOD.SDR ASAA2018080765690Lens · unsecureEMERGENCY LIGHT LENS ON THE RIGHT OVERWING EXIT UNSECURE. ACFT GROUNDED. SECURED THE LENS.SDR AALA201808079021Cover · damagedCABIN ENTRY R2 DOOR EMERGENCY EXIT LIGHT DAMAGED. REPLACED THE EMERGENCY LIGHT COVER.SDR QXEA2018080700285Lamp · inoperativeAFT EXIT ROW SIGN HAS A BURNED OUT LIGHT ADVISORY. REMOVED FROM SERVICE. REPLACED THE LAMP. OBSERVED NORMAL OPERATION. NO FURTHER DEFECTS NOTED. AIRCRAFT RETURNED TO SERVICE.SDR DALA2018080704900Lens · missingEMERGENCY EXIT SIGN LENS WAS MISSING. INSTALLED LENS. OK FOR SERVICE.SDR DALA2018081435075Bracket · brokenDURING A SERVICE CHECK, FOUND AN EMERGENCY LIGHT BRACKET AT SEAT 32G BROKEN. REPLACED THE EMERGENCY LIGHT ASSY. SYSTEM OPS NORMAL.SDR SWAA2018081324194Power Supply · inoperativeFORWARD GALLEY, EMERGENCY EXIT LIGHTS COMMON TO M1675 BATTERY CHARGER INOP. R&R POWER SUPPLY IAW MM.SDR DALA2018080904971Lens · damagedFOUND THREE OVERHEAD LIGHT LENSES DAMAGED IN THE CABIN. REMOVED AND REPLACED THE LENSES. CHECKED GOOD.SDR REXA2018080850675Mount · brokenEMERGENGENCY EXIT SIGN MOUNT OVER THE GALLEY SERVICE DOOR WAS BROKEN AND THE SIGN WAS HANGING DOWN. REMOVED AND REPLACED THE EMERGENCY LIGHT HOUSING ASSY IAW AMM 33
-51-05.SDR IPXA2018080862503Lamp · inoperativeEMERGENCY LIGHT SIGN WAS INOPERATIVE REPLACED THE LAMP IAW AMM 33-51-00, OPS CHECKED GOOD.SDR AALA2018080879022Lens · missingSEAT 10 DEF, MOUNTED EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-51-19.SDR AALA2018080879012Lens · looseL4 DOOR LIGHT INOPERATIVE AND BROKEN. FOUND THE LENS LOSE. REINSTALLED THE LENS IAW AMM 33-21-00.SDR AALA2018080879007Lens · missingSEAT 10 ABC, MOUNTED EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-51-19.SDR N6WA20180806501Light · inoperativeTWO OVERHEAD EMERGENCY EXIT LIGHTS WERE INOPERATIVE, ROW 15 & 21.SDR DALA2018080604862Power Supply · inoperativeSEAT MOUNTED EMERGENCY LIGHTS, LAST SIX ROWS WERE INOPERATIVE. REMOVED AND REPLACED THE FUSE IN THE POWER SUPPLY B5-112 IAW AMM 33-53. OPS CHECKED OK.SDR MASA2018080513453Lamp · inoperativeROW 18 CEILING EMERGENCY FLOOD LIGHT WAS INOPERATIVE. REPLACED THE LAMPS.SDR DALA2018081065001Battery Pack · inoperativeWHILE PERFORMING PDC, FOUND EMERGENCY LIGHT RIGHT SIDE NOT TESTING. REPLACED THE BATTERY PACK AND CHARGER. SYSTEM OPS NORMAL.SDR DALA2018081064999Light · detachedEMERGENCY LIGHTS ARE HANGING BY WIRE FROM SEAT WALL BY WIRING. SECURED LIGHT PANEL TO SEAT 19B. SYSTEM OPS NORMAL.SDR DALA2018080604998Control Panel · failedCOCKPIT DOOR EMERGENCY LIGHTS WERE INOPERATIVE. REPLACED EMERGENCY LIGHTS CONTROL PANEL. SYSTEM OPS NORMAL.
Back to JASC 3350