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 AALA201702239008Lens · missingFOUND R1 DOOR EMERGENCY LIGHT EXIT SIGN LENS MISSING. REPLACED THE LENS.SDR AALA201702239007Power Supply · failedAFT LEFT POWER SUPPLY FAILED. INSTALLED A SERVICABLE POWER SUPPLY.SDR AALA201702239006Lens · missingBROKEN EMERGENCY LIGHT LENS ON EXIT ROW 14R. REPLACED EMERGENCY LIGHT LENS.SDR AALA201702239005Lens · missingL1 DOOR EMERGENCY LIGHT LENS MISSING. REPLACED THE LENS. ACFT GROUNDED.SDR AALA201702239002Lens · missingLENS CAP FOR EMERGENCY EXIT LIGHT THE R4 DOOR MISSING. REPLACED THE LENS.SDR DALA2017022301505Wire · misinstalledEMERGENCY EXIT LIGHTS TURN ON WITH THE SWITCH IN OFF POSITION. FOUND A WIRE FROM D10968 PIN E16 TO S6 ON THE EMERGENCY LIGHT SWITCH ON WRONG TERMINALS. CORRECTED THE PROBLEM, OPS TEST OK IAW AMM 33-51-00. AND WDM 33-51-11, PG1, SH1.SDR DALA2017022301504Battery Pack · no testDURING EMERGENCY LIGHT BATTERY PACK CHECK, FOUND LIGHTS AT THE R2 DOOR TOP AND BOTTOM AND ON NBA LAVATORY WALL INOPERATIVE. REPLACED THE BATTERY PACK IAW AMM 33-51. CHARGED BATTERY AND CHECKED IAW AMM 33-51. ALL CHECKED GOOD.SDR FDEA201702220625Lamp · inoperativeDURING A POST FLIGHT INSPECTION, ONE OVERHEAD EMERGENCY LIGHT WAS INOPERATIVE. REPLACED THE LAMPS IAW AMM 33-50-00-2. LIGHTS TESTED GOOD, OK FOR SERVICE.SDR MASA2017022212624Light · inoperativeROW 11 CEILING EMERG FLOOD LIGHT INOP. REPLACED BULB.SDR JJBA20170222015Inverter · inoperativeEMERGENCY EXIT SIGN OVER ROW 18 HALF LIT. R&R INVERTER AND R&R EXIT SIGN ASSY. OPS CHECK SAT AT THIS TIME.SDR IPXA2017022214328Light · inoperativeLAV LIGHT IS INOP (OVER SINK)RELAMPED LAV AUXILIARY LIGHT AND TESTED PER AMM 33-51-21 OK FOR SERVICE.SDR MASA2017022212623Light · inoperativeEMERGENCY LIGHT AT ROW 15 INOPERATIVE.SDR HNAA2017022200061Bulb · inoperativeCABIN CENTER AISLE EMERGENCY LIGHT BETWEEN ROWS 7 AND 8 ARE INOPERATIV. REMOVED AND REPLACED THE BULBS. OPS CHECKED GOOD.SDR SIMA20170221009Light · inoperativeHALF OF EMERGENCY LIGHT STRIP NR 4 IS INOPERATIVE. REMOVED AND REPLACED THE LIGHT IAW AMM 33-50-12.SDR DALA2017031602104Ballast · failedWHEN OVERHEAD AND SIDEWALL LIGHTS WERE TURNED ON DURING DESCENT, THE F/A OBSERVED FLICKERING AND A HOT BALLAST ODOR FROM FWD CABIN AREA. TURNED LIGHTS OFF AND ODOR DISSIPATED. FOUND A DAMAGED LIGHT L2-6607 CONNECTOR, IT ALSO HAD AN ELECTRICAL ODOR. DISCONNECTSDR AALA20170224019Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M962. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M962 PER AMM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224017Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M731. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M731 PER AMM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224016Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M735. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M735 PER AMM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224014Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M736. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M736 PER AMM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224012Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M730. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M730 PER AMM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224010Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M1208., REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M1208 IAW MM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224009Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M734, REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M734 PER AMM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224008Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M738, REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M738 PER AMM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224007Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M737. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M737 PER AMM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224006Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M733, REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M733 PER AMM 33-51-07 ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR AALA20170224005Battery · dischargedAIRCRAFT IN BASE MAINTENANCE. NEED TO REPLACE EMERGENCY LIGHT BATTERY M739. REMOVED AND REPLACED EMERGENCY LIGHT BATTERY M739 PER AMM 33-51-07. ACCOMPLISHED SATISFACTORY OPERATIONAL CHECK.SDR SWAA2017022712097Sign · detachedAFT GALLEY EMERGENCY EXIT SIGN FELL OFF. SECURED THE SIGN IAW SIP.SDR AALA20170224013Light · inoperativeAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED EMERGENCY ESCAPE PATH LIGHT AT SEAT 11C FAILED TEST. REMOVED AND REPLACED LIGHT IAW AMM 33-51-00. OPERATIONAL CHECK GOOD.SDR AALA20170220041Lens · crackedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE FORWARD ENTRY DOOR HAS A CRACKED LENS COVER. REPLACED EXIT LIGHT ASSEMBLY. OPERATIONAL CHECK GOOD.SDR DALA2017022401549Battery Pack · inoperativeEMERGENCY OVERHEAD LIGHTS BETWEEN 1DE TO 11CDE INOPERATIVE. REMOVED AND REPLACED BATTERY PACK AND EMERGENCY POWER SUPPLY B5-227 IAW MM. OPERATION CHECKS GOOD.SDR AALA20170223020Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHTS IN THE AFT CABIN FAILED TEST. REMOVED AND REPLACED BATTERY PACK M10953 IAW AMM 33-51-11. OPERATIONAL CHECK GOOD.SDR AALA20170223019Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHTS IN MID CABIN, L2/R2 DOOR EMERGENCY EXIT LIGHTS AND OVERHEAD BIN LIGHTS FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY M733 (AALA20170223018) AND BATTERY PACK M10952 IAW AMM 33-51-11. OPERATIONAL CSDR AALA20170223018Battery · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHTS IN MID CABIN, L2/R2 DOOR EMERGENCY EXIT LIGHTS AND OVERHEAD BIN LIGHTS FAILED TEST. REMOVED AND REPLACED BATTERY ASSEMBLY M733 AND BATTERY PACK M10952 (AALA20170223019) IAW AMM 33-51-11. OPERATIONAL CSDR AALA20170223015Lens · detachedAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE FIRST CLASS GALLEY HAS A DETACHED LENS COVER. REPLACED LIGHT ASSEMBLY IAW AMM 33-51-02. OPERATIONAL CHECK GOOD.SDR AALA20170223007Battery · dischargedAIRCRAFT WAS NOT GROUNDED. EMERGENCY POWER SUPPLY UNIT AT 12WL FAILED TEST. REMOVED AND REPLACED EPSU BATTERY IAW AMM 33-51-38. OPERATIONAL CHECK GOOD.SDR AALA20170222002Battery Pack · dischargedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHTS IN FIRST CLASS, L1/R1 DOOR EMERGENCY EXIT LIGHTS AND OVERHEAD BIN LIGHTS FAILED TEST. REMOVED AND REPLACED CONTROL MODULE M10798 (AALA20170222001) AND BATTERY PACK M10798 IAW AMM 33-51-11. OPERATIONALSDR AALA20170222001Module · failedAIRCRAFT WAS NOT GROUNDED. SEAT MOUNTED ESCAPE PATH LIGHTS IN FIRST CLASS, L1/R1 DOOR EMERGENCY EXIT LIGHTS AND OVERHEAD BIN LIGHTS FAILED TEST. REMOVED AND REPLACED CONTROL MODULE M10798 AND BATTERY PACK M10798 (AALA20170222002) IAW AMM 33-51-11. OPERATIONALSDR AALA20170221024Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH PROXIMITY FLOODLIGHT FORWARD OF L1 DOOR AT THE FORWARD GALLEY IS DAMAGED. REMOVED AND REPLACED FLOODLIGHT IAW WDM 33-51-21. OPERATIONAL CHECK GOOD.SDR AALA20170221028Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH PROXIMITY FLOODLIGHT AFT OF R2 DOOR AT G4 GALLEY IS DAMAGED. REMOVED AND REPLACED FLOODLIGHT IAW WDM 33-51-21. OPERATIONAL CHECK GOOD.SDR AALA20170221027Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH PROXIMITY FLOODLIGHT AFT OF L2 DOOR AT G4 GALLEY IS DAMAGED. REMOVED AND REPLACED FLOODLIGHT IAW WDM 33-51-21. OPERATIONAL CHECK GOOD.SDR AALA20170221025Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH PROXIMITY FLOODLIGHT FORWARD OF R1 DOOR AT THE FORWARD GALLEY IS DAMAGED. REMOVED AND REPLACED FLOODLIGHT IAW WDM 33-51-21. OPERATIONAL CHECK GOOD.SDR AALA20170221023Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH LIGHTING ABOVE ROW 14 STOWAGE BIN IS MISSING THE LENS COVER. REMOVED AND REPLACED LENS COVER IAW AMM 33-51-03. OPERATIONAL CHECK GOOD.SDR AALA20170221029Light · damagedAIRCRAFT WAS NOT GROUNDED. EMERGENCY ESCAPE PATH PROXIMITY FLOODLIGHT ON THE G2 GALLEY IS DAMAGED. REMOVED AND REPLACED FLOODLIGHT IAW WDM 33-51-21. OPERATIONAL CHECK GOOD.SDR SWAA2017022312063Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1675. R&R BATTERY PACK IAW AMM.SDR SWAA2017022312044Lens · unsecureL1 DOOR EXIT LIGHT LENS CAME OFF. INSTALLED LENS PER SIP.SDR SWAA2017022312041Battery Pack · failedEMERGENCY LIGHT BATTERY PACK FAILED CAPACITY TEST AT LOCATION M1674. R&R BATTERY PACK IAW AMM.SDR SWAA2017022312039Battery Pack · dischargedL2 DOOR EMERGENCY LIGHTS INOP. R&R BATTERY PACK PER AMM.SDR SWAA2017022312038Sign · brokenR2 DOOR AFT GALLEY BULKHEAD EMERGENCY EXIT SIGN BROKEN. R&R SIGN PER MM.SDR SWAA2017022312035Sign · unsecureR2 DOOR EMERGENCY EXIT SIGN CAME OFF. INSTALLED SIGN PER MM.SDR DALA2017022201509Battery Pack · inoperativeEMERGENCY EXIT LIGHT AT THE L1 DOOR INOPERATIVE. REPLACED THE BATTERY PACK, OPS CHECKED GOOD IAW 33-51-00.
Back to JASC 3350