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 YENA201805010197Lamp · burned outEMERGENCY EXIT SIGN AT THE L1 DOOR, MOUNTED ON THE AFT WALL OF LAVATORY. FOUND THE LAMPS BURNED OUT. REPLACED THE LAMPS IAW AMM 33-51-16. OPS CHECKED OK.SDR YENA201805010196Power Supply · failedFLIGHT ATTENDANT REPORTED THE AFT CEILING G5 EXIT LIGHT INOPERATIVE. R & R EPSU IAW AMM 33-51-38. OPS CHECKED GOOD.SDR 29GA2018050100001Light · malfunctionedGALLEY EMERGENCY LIGHTS ILLUMINATED WHEN THE FA TESTED EMERGENCY LIGHT SYSTEM. CYCLED THE CIRCUIT BREAKER L8. OPS CHECKED GOOD IAW AMM 33-50-00-02, 33-50-00-01, AND 33-50-00-05-01.SDR DALA2018050102953Power Supply · inoperativeSEAT 24DE - ROW 30DE EMERGENCY LIGHTS INOPERATIVE. REPLACED THE POWER SUPPLY AT BS 1233 IAW AMM 33-53.SDR DALA2018050103000Cover · missingPLASTIC COVER FOR OVERHEAD (OVER WING) EMERG EXIT SIGN IS MISSING. REPLACED SIGN.SDR REXA2018043000333Light · inoperativeLEFT OVERWING EMERGENCY LIGHT OUT. R&R LIGHT BULB IAW AMM 33-51-21. OPS CHECK GOOD NO DEFECTS.SDR MASA2018050113168Sign · missingGALLEY DOOR LOWER EMERGENCY SIGN WAS FOUND MISSING. REPLACED THE SIGN.SDR YENA2018050100195Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R EMERGENCY LIGHT BATTERIES AT 10WL,11WL,12WL, AND 13WL IAW AMM 33-51-38. TESTED OK.SDR YENA2018050100194Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R EMERGENCY LIGHT BATTERIES AT 10WL,11WL,12WL, AND 13WL IAW AMM 33-51-38. TESTED OK.SDR YENA2018050100193Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R EMERGENCY LIGHT BATTERIES AT 10WL,11WL,12WL, AND 13WL IAW AMM 33-51-38. TESTED OK.SDR YENA2018050100192Battery Pack · no testEMERGENCY LIGHT FAILED TO TEST. R & R EMERGENCY LIGHT BATTERIES AT 10WL,11WL,12WL, AND 13WL IAW AMM 33-51-38. TESTED OK.SDR DALA2018050102951Battery Pack · inoperativeDURING A SERVICE CHECK, FOUND THE FWD GALLEY FLIGHT ATTENDANT EMERGENCY EXIT LIGHT INOPERATIVE. REMOVED AND REPLACED THE BATTERY PACK AT B5-235 IAW AMM 33-51-03. OK FOR SERVICE.SDR DALA2018050102950Battery Pack · inoperativeDURING A SERVICE CHECK, THE VENTRAL DOOR EMERGENCY EXIT SIGN AND OTHER CEILING EMERGENCY LIGHTS FAILED TO TEST. PERFORMED TROUBLESHOOTING IAW WDM 33-51-12, FOUND TWO BATTERY PACKS DAMAGED B5-239 AND B5-237, REMOVED AND REPLACED THE BATTERY PACKS. OPS CHSDR MASA2018043013166Bulb · inoperativeROW 18 LOWER EXIT SIGN HAD ONE BULB INOPERATIVE. REPLACED THE BULB.SDR DALA2018043002905Battery Pack · inoperativeAFT BULKHEAD EMERGENCY EXIT SIGN DOES NOT ILLUMINATE. R & R THE BATTERY PACK. OPS TESTED NORMAL.SDR ASOA2018F00000Inverter · inoperativeRIC FLIGHT 4330 DURING SCHEDULED MAINTENANCE INSPECTION THE EMERGENCY EXIT SIGN AT SEAT 15D WAS FOUND INOPERATIVE. MAINTENANCE REMOVED AND REPLACED EMERGENCY EXIT SIGN INVERTER WITH OPERATIONAL CHECK GOOD. AIRCRAFT WAS APPROVED FOR RETURN TO SERVICE.SDR REXA2018042900332Sign · inoperativeLIGHTED FLOOR LEVEL EXIT SIGN FOUND INOP. R&R FLOOR LEVEL EXIT SIGN IAW AMM 33-51-10 OPS CHECK GOOD NO FURTHER DEFECTS NOTED AT THIS TIME PN ON/OFF 6020-6 NON SERIALIZED PART.SDR AALA201805019016Battery · dischargedTHE AIRCRAFT WAS NOT GROUNDED. DOOR 3R EPAS LIGHT DOES NOT TEST. REPLACED 3R EPAS BATTERY PER AMM 52-11-20. ALL TEST GOOD.SDR AALA20180430005Power Supply · inoperativeTHE AIRCRAFT IS IN BASE MAINTENANCE. EMERGENCY LIGHT BATTERY CHARGER M33405 TEST FAILED. REMOVED AND REPLACED EMERGENCY LIGHTS POWER SUPPLY M33405 PER AMM 33-51-06. OPERATIONS CHECK GOOD.SDR SWAA2018043021592Battery Pack · dischargedRT OVERWING EXIT INDICATOR LIGHT INOP. R&R BATTERY PACK PER AMM.SDR SWAA2018043021498Cover · unsecureR1 DOOR LOWER EMERGENCY EXIT SIGN COVER FELL OFF. R&R SIGN ASSEMBLY PER MM.SDR SWAA2018043021490Light · inoperativeRT OVERWING EXIT INDICATOR LIGHT INOP. R&R LIGHT ASSEMBLY PER AMM.SDR REXA2018050100331Light · inoperativeFLIGHT ATTENDANT INDICATION LIGHTS ON THE EMERGENCY EXIT SIGN ARE NOT WORKING. RESET THE EMERGENCY LIGHT CIRCUIT BREAKER IAW AMM 33-51-00. OPS CHECKED GOODSDR DALA2018050102969Lens · damagedEMERGENCY LIGHT LENS DAMAGED. THE EMERGENCY LIGHT LENS WAS REPLACED.SDR AALA2018005010009Cover · brokenEMERGENCY EXIT LIGHT AT THE R1 DOOR HAS A BROKEN COVER. REPLACED EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-11.SDR C77A20180501001Cradle · brokenCAPTAIN`S FLASHLIGHT HOLDER WAS FOUND BROKEN. R & R THE FLASHLIGHT IAW AMM 33-51-01/400.SDR AALA2018050109046Lens · missingROW 8 EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS IAW AMM 33-50-00. OPS CHECKED GOOD.SDR SWAA2018050121460Housing · crackedAFT GALLEY AREA OVERHEAD EMERGENCY EXIT LIGHT HOUSING CRACKED. R & R THE HOUSING IAW AMM.SDR HALA0218043000190Lens · detachedEXIT SIGN LENS AT THE R3 DOOR DETACHED. INSTALLED THE LENS. OK FOR SERVICE.SDR SIMA2018043029002Light · inoperativeFLOOR EMERGENCY LIGHT BETWEEN ROWS 7 AND 8 FOUND INOPERATIVE.SDR SIMA2018043029001Power Supply · failedDURING PS-1 INSPECTION, FOUND THE LEFT & RIGHT EXTERNAL OVERWING EMERGENCY LIGHTS INOPERATIVE. REMOVED & REPLACED THE NR 4 EMERGENCY LIGHT POWER SUPPLY & BATTERY, OPS OK.SDR QXEA2018043000166Lamp · inoperativeF/A REPORTED THE FWD CABIN EMERGENCY LIGHTS SWITCH, LIGHT WAS DARK. REPLACED THE LAMPS IN THE LIGHT SWITCH. CHECKED GOOD. RETURNED TO SERVICE.SDR DALA2018043002897Battery Pack · inoperativeFOUND CEILING EMERGENCY LIGHTS OUT AT ROWS 16-24. REPLACED BATTERY PACKS.SDR DALA2018043002895Lamp · inoperative14 & 15 ED SEAT MOUNTED EMERGENCY LIGHTS INOPERATIVE. REPLACED THE LAMPS. OPS NORMAL.SDR AALA201805019014Light · illuminatedTHE AIRCRAFT WAS NOT GROUNDED. ON LANDING CABIN EMERGENCY EXIT LIGHTS ILLUMINATED WOULD NOT EXTINGUISH. EMERGENCY EXIT LIGHTS GROUND TEXT NORMAL PER AMM 33-50-00.SDR AALA201805019013Battery Pack · dischargedTHE AIRCRAFT WAS NOT GROUNDED. OVERHEAD COCKPIT EMERGENCY LIGHTS WILL NOT ILLUMINATE. REMOVED AND REPLACED BATTERY PACK FOR COCKPIT LIGHTS PER AMM 33-53-00. ALL OPERATIONS CHECK OK.SDR AALA20180429003Lens · missingDURING CABIN WALKAROUND AT THE GATE, NOTED B/C SEAT 5D, ONE SEAT MOUNTED EMERGENCY LIGHT LENS WAS MISSING. REPLACED LIGHT ASSEMBLY SEAT 5D IAW ESO 21376. OK FOR SERVICE.SDR QXEA2018050100167Light · detachedEMERGENCY LIGHT STRIP IN FROUNT OF ROW 2 D & E DETACHED. REINSTALLED THE EMERGENCY LIGHT ASSEMBLY IAW AMM 33-51-16-400-801. RETURNED TO SERVICE.SDR AALA201805019041Guard · looseTHE EMERGENCY LIGHT SWITCH WIRE WAS LOOSE ON THE GUARD. MAINTENANCE REPLACED THE EMERGENCY LIGHT SWITCH GUARD ASSEMBLY AND PERFORMED SATISFACTORY OPERATIONAL CHECK IAW ESO 41209 CMM 30-41-01.SDR AALA201805019040Sign · detachedEXIT SIGN AT THE L3 DOOR WAS DETACHED. MAINTENANCE REPLACED THE SIGN IAW AMM 33-51-01, AND PERFORMED SATISFACTORY OPERATIONAL CHECK.SDR AALA201805010002Connector · not seatedMID CABIN AISLE EMERGENCY LIGHTS FROM SEAT 13DEGH TO 22DEGH ARE INOPERATIVE. FOUND EMERGENCY LIGHTS FLOOR PROXIMITY CONNECTOR J1 AND J2 NOT PROPERLY SEATED. RESEATED CONNECTORS IAW AMM 33-51-00-710-801.SDR AALA201805019025Power Supply · inoperativeDURING EMERGENCY LIGHT TEST, EXTERIOR LOAD AFT AND INTERIOR LOAD AFT 13WLP LIGHTS FLASHING. REPLACED EMERGENCY LIGHTS 32WL, 90WL7, 90WL8, 44WL AND EMERGENCY POWER SUPPLY UNIT 13WL PER AMM 33-51-00. THIS SDR IS FOR EMERGENCY POWER SUPPLY UNIT 13WL.SDR AALA201805019024Light · inoperativeAIRCRAFT WAS NOT GROUNDED. DURING EMERGENCY LIGHT TEST, EXTERIOR LOAD AFT AND INTERIOR LOAD AFT 13WLP LIGHTS FLASHING. REPLACED EMERGENCY LIGHTS 32WL, 90WL7, 90WL8, 44WL AND EMERGENCY POWER SUPPLY UNIT 13WL PER AMM 33-51-00. THIS SDR IS FOR LIGHTS 44WL.SDR AALA201805019023Light · inoperativeAIRCRAFT WAS NOT GROUNDED. DURING EMERGENCY LIGHT TEST, EXTERIOR LOAD AFT AND INTERIOR LOAD AFT 13WLP LIGHTS FLASHING. REPLACED EMERGENCY LIGHTS 32WL, 90WL7, 90WL8, 44WL AND EMERGENCY POWER SUPPLY UNIT 13WL PER AMM 33-51-00. THIS SDR IS FOR LIGHTS 90WL8.SDR AALA201805019022Light · inoperativeAIRCRAFT WAS NOT GROUNDED. DURING EMERGENCY LIGHT TEST, EXTERIOR LOAD AFT AND INTERIOR LOAD AFT 13WLP LIGHTS FLASHING. REPLACED EMERGENCY LIGHTS 32WL, 90WL7, 90WL8, 44WL AND EMERGENCY POWER SUPPLY UNIT 13WL PER AMM 33-51-00. THIS SDR IS FOR LIGHTS 90WL7.SDR AALA2018050109033Connector · damagedEMERGENCY LIGHT, SEAT MOUNTED, FOUND INOPERATIVE AT SEAT 21. REPLACED THE CONNECTOR IAW AWM 33-51-07.SDR AALA2018050109032Connector · damagedEMERGENCY LIGHT, SEAT MOUNTED FOUND INOPERATIVE AT SEAT 20. REPLACED THE CONNECTOR FOR SEAT 20 IAW AWM 33-51-07.SDR AALA2018050109031Power Supply · malfunctionedDURING AN EMERGENCY LIGHT TEST, THE EXTERIOR LOAD AFT AND INTERIOR LOAD AFT 13WLP LIGHTS FLASHING. REPLACED EMERGENCY LIGHTS 32WL, 90WL7, 90WL8, 44WL AND EMERGENCY POWER SUPPLY UNIT 13WL IAW AMM 33-51-00.SDR FDEA201804281142Lamp · inoperativeDURING A POST FLIGHT INSPECTION, THE L1 DOOR OVERHEAD AFT EMERGENCY LIGHT WAS FOUND INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-52-04-2. EMERGENCY LIGHTS TESTED GOOD. OK FOR SERVICE.SDR AALA201804309037Light · brokenEMERGENCY LIGHT AT SEAT 20C WAS FOUND BROKEN. MAINTENANCE REPLACED EMERGENCY LIGHT IAW AMM 33-51-19 AND PERFORMED SATISFACTORY OPERATIONAL CHECK.
Back to JASC 3350